From d9f68683040f88f969eba86574e0b35e3a906f1d Mon Sep 17 00:00:00 2001
From: Galen Charlton <gmc@esilibrary.com>
Date: Wed, 2 Mar 2016 17:02:04 -0500
Subject: [PATCH] LP#1470957: provide pgTAP test for expected pubdate
 normalization

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
---
 .../regress/lp1470957_sort_null_pubdates.sql  | 21 +++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/t/regress/lp1470957_sort_null_pubdates.sql

diff --git a/Open-ILS/src/sql/Pg/t/regress/lp1470957_sort_null_pubdates.sql b/Open-ILS/src/sql/Pg/t/regress/lp1470957_sort_null_pubdates.sql
new file mode 100644
index 0000000000..995ee2a611
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/t/regress/lp1470957_sort_null_pubdates.sql
@@ -0,0 +1,21 @@
+BEGIN;
+
+SELECT plan(1);
+
+INSERT INTO biblio.record_entry (marc, last_xact_id)
+VALUES (
+    $$<record    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"    xmlns="http://www.loc.gov/MARC21/slim"><leader>00620cam a2200205Ka 4500</leader><controlfield tag="001">1</controlfield><controlfield tag="003">CONS</controlfield><controlfield tag="005">20150113170906.0</controlfield><controlfield tag="008">070101s||||                        eng d</controlfield><datafield tag="245" ind1=" " ind2=" "><subfield code="a">Harry potter</subfield></datafield><datafield tag="901" ind1=" " ind2=" "><subfield code="a">1</subfield><subfield code="b"></subfield><subfield code="c">1</subfield><subfield code="t">biblio</subfield></datafield></record>$$,
+    'LP#1414112'
+);
+
+SELECT is(
+    (
+        SELECT COUNT(*) FROM metabib.record_sorter
+        WHERE source = CURRVAL('biblio.record_entry_id_seq')
+        AND attr = 'pubdate'
+    ),
+    0::BIGINT,
+    'LP#1470957: do not provide sorter for |||| pubdate'
+);
+
+ROLLBACK;
-- 
2.43.2