From 920c991a5bc339cd694a9590283f7920284979c1 Mon Sep 17 00:00:00 2001
From: Paul Ramsey <pramsey@cleverelephant.ca>
Date: Mon, 29 Jul 2019 17:36:47 +0000
Subject: [PATCH] Add test case and update test case for null-handling
 behaviour References #4209

git-svn-id: http://svn.osgeo.org/postgis/trunk@17645 b70326c6-7e19-0410-871a-916f4a2858ee
---
 regress/core/Makefile.in                 |   2 ++
 regress/dumper/null3d_expected.dbf       | Bin 33 -> 33 bytes
 regress/dumper/null3d_expected.shp       | Bin 112 -> 156 bytes
 regress/dumper/null3d_expected.shx       | Bin 108 -> 116 bytes
 regress/dumper/nullsintable-post.sql     |   2 ++
 regress/dumper/nullsintable-pre.sql      |   6 ++++++
 regress/dumper/nullsintable.dmp          |   1 +
 regress/dumper/nullsintable_expected.dbf | Bin 0 -> 113 bytes
 regress/dumper/nullsintable_expected.prj |   1 +
 regress/dumper/nullsintable_expected.shp | Bin 0 -> 164 bytes
 regress/dumper/nullsintable_expected.shx | Bin 0 -> 132 bytes
 11 files changed, 12 insertions(+)
 create mode 100644 regress/dumper/nullsintable-post.sql
 create mode 100644 regress/dumper/nullsintable-pre.sql
 create mode 100644 regress/dumper/nullsintable.dmp
 create mode 100644 regress/dumper/nullsintable_expected.dbf
 create mode 100644 regress/dumper/nullsintable_expected.prj
 create mode 100644 regress/dumper/nullsintable_expected.shp
 create mode 100644 regress/dumper/nullsintable_expected.shx

diff --git a/regress/core/Makefile.in b/regress/core/Makefile.in
index ad61bf0f5..14c955a6a 100644
--- a/regress/core/Makefile.in
+++ b/regress/core/Makefile.in
@@ -69,6 +69,8 @@ TESTS = \
 	../loader/mfile \
 	../dumper/literalsrid \
 	../dumper/realtable \
+	../dumper/nullsintable \
+	../dumper/null3d \
 	affine \
 	bestsrid \
 	binary \
diff --git a/regress/dumper/null3d_expected.dbf b/regress/dumper/null3d_expected.dbf
index b07eb81b1e3b25f03ab4674106dba175c90d8a2f..3db507ed59c8a2fe5f72f73077b1943c85576630 100644
GIT binary patch
delta 9
QcmY#XoFL1>z`(!@00#L10RR91

delta 9
QcmY#XoFK~*&cMJ600>n9SO5S3

diff --git a/regress/dumper/null3d_expected.shp b/regress/dumper/null3d_expected.shp
index 2a7c13cbba5820e489d01ee57bb0f42d6f2d91da..7bbcf6df4a644ceaa13b66ec05eaa11f6576d8ca 100644
GIT binary patch
delta 22
ccmXSz!#F{j(Ql$m2nPcL0}~JnO;k_;068}U`Tzg`

delta 10
RcmbQkSTI4F(PE-Z2mldb0`mX>

diff --git a/regress/dumper/null3d_expected.shx b/regress/dumper/null3d_expected.shx
index 346787e8eac91e6878e5c12b7b93bc26541b3623..c4ec3dff448d990e184030e887ae57aaf55bbd1e 100644
GIT binary patch
delta 18
Xcmc~PnIO$*HBlyjgMop;0*HkGDTM<T

delta 9
QcmXTPnIO$*Hc=)301qbuzyJUM

diff --git a/regress/dumper/nullsintable-post.sql b/regress/dumper/nullsintable-post.sql
new file mode 100644
index 000000000..17deeda1e
--- /dev/null
+++ b/regress/dumper/nullsintable-post.sql
@@ -0,0 +1,2 @@
+drop table c;
+delete from spatial_ref_sys where srid = 1;
diff --git a/regress/dumper/nullsintable-pre.sql b/regress/dumper/nullsintable-pre.sql
new file mode 100644
index 000000000..4e69441e1
--- /dev/null
+++ b/regress/dumper/nullsintable-pre.sql
@@ -0,0 +1,6 @@
+insert into spatial_ref_sys(srid,srtext) values (1,'fake["srs"],text');
+CREATE TABLE c ( id integer NOT NULL, geom geometry(Point, 1));
+INSERT INTO c VALUES(1, NULL);
+INSERT INTO c VALUES(2, NULL);
+INSERT INTO c VALUES(3, 'SRID=1;POINT(1 1)');
+INSERT INTO c VALUES(4, NULL);
diff --git a/regress/dumper/nullsintable.dmp b/regress/dumper/nullsintable.dmp
new file mode 100644
index 000000000..f2ad6c76f
--- /dev/null
+++ b/regress/dumper/nullsintable.dmp
@@ -0,0 +1 @@
+c
diff --git a/regress/dumper/nullsintable_expected.dbf b/regress/dumper/nullsintable_expected.dbf
new file mode 100644
index 0000000000000000000000000000000000000000..fa42b56d6c3a0479898aee80cda0c2ea67eaf640
GIT binary patch
literal 113
vcmZRMXP07OU|?`$-~p1Dz|#dT<_BVN!?_R!uY#ch0vI8f3dTrm69gLoJmd%x

literal 0
HcmV?d00001

diff --git a/regress/dumper/nullsintable_expected.prj b/regress/dumper/nullsintable_expected.prj
new file mode 100644
index 000000000..ab83d5d0e
--- /dev/null
+++ b/regress/dumper/nullsintable_expected.prj
@@ -0,0 +1 @@
+fake["srs"],text
\ No newline at end of file
diff --git a/regress/dumper/nullsintable_expected.shp b/regress/dumper/nullsintable_expected.shp
new file mode 100644
index 0000000000000000000000000000000000000000..62deec11c5eac7703b106a4d45f5f6edc6e543f2
GIT binary patch
literal 164
xcmZQzQ0HR64uW1VGcYj1<v!R$n7C-TLTn6>F-%Yi5DjAkZD8QSVFwFL9RU7O2&Di3

literal 0
HcmV?d00001

diff --git a/regress/dumper/nullsintable_expected.shx b/regress/dumper/nullsintable_expected.shx
new file mode 100644
index 0000000000000000000000000000000000000000..0ee12239d5e1f46b7cb68798edb0659b08ca39aa
GIT binary patch
literal 132
vcmZQzQ0HR64xC;vGcYj1<v!R$n7C-TLTn5ppdb?vTR>?$APutD2gC;e6h#Lh

literal 0
HcmV?d00001

-- 
2.49.0