[postgis-tickets] r17645 - Add test case and update test case for null-handling behaviour

[Paul Ramsey]

Author: pramsey
Date: 2019-07-29 10:36:47 -0700 (Mon, 29 Jul 2019)
New Revision: 17645

Added:
   trunk/regress/dumper/nullsintable-post.sql
   trunk/regress/dumper/nullsintable-pre.sql
   trunk/regress/dumper/nullsintable.dmp
   trunk/regress/dumper/nullsintable_expected.dbf
   trunk/regress/dumper/nullsintable_expected.prj
   trunk/regress/dumper/nullsintable_expected.shp
   trunk/regress/dumper/nullsintable_expected.shx
Modified:
   trunk/regress/core/Makefile.in
   trunk/regress/dumper/null3d_expected.dbf
   trunk/regress/dumper/null3d_expected.shp
   trunk/regress/dumper/null3d_expected.shx
Log:
Add test case and update test case for null-handling behaviour
References #4209


Modified: trunk/regress/core/Makefile.in
===================================================================
--- trunk/regress/core/Makefile.in	2019-07-29 16:58:16 UTC (rev 17644)
+++ trunk/regress/core/Makefile.in	2019-07-29 17:36:47 UTC (rev 17645)
@@ -69,6 +69,8 @@
 	../loader/mfile \
 	../dumper/literalsrid \
 	../dumper/realtable \
+	../dumper/nullsintable \
+	../dumper/null3d \
 	affine \
 	bestsrid \
 	binary \

Modified: trunk/regress/dumper/null3d_expected.dbf
===================================================================
--- trunk/regress/dumper/null3d_expected.dbf	2019-07-29 16:58:16 UTC (rev 17644)
+++ trunk/regress/dumper/null3d_expected.dbf	2019-07-29 17:36:47 UTC (rev 17645)
@@ -1 +1 @@
-_    ! 
                  W  
+_    ! 
                     
Modified: trunk/regress/dumper/null3d_expected.shp
===================================================================
--- trunk/regress/dumper/null3d_expected.shp	2019-07-29 16:58:16 UTC (rev 17644)
+++ trunk/regress/dumper/null3d_expected.shp	2019-07-29 17:36:47 UTC (rev 17645)
@@ -1,2 +1,2 @@
   '
-                       8è                                                                        
       
\ No newline at end of file
+                       Nè                                                                        
                                                
\ No newline at end of file

Modified: trunk/regress/dumper/null3d_expected.shx
===================================================================
--- trunk/regress/dumper/null3d_expected.shx	2019-07-29 16:58:16 UTC (rev 17644)
+++ trunk/regress/dumper/null3d_expected.shx	2019-07-29 17:36:47 UTC (rev 17645)
@@ -1,2 +1,2 @@
   '
-                       6è                                                                        2   
\ No newline at end of file
+                       :è                                                                        2      8   
\ No newline at end of file

Added: trunk/regress/dumper/nullsintable-post.sql
===================================================================
--- trunk/regress/dumper/nullsintable-post.sql	                        (rev 0)
+++ trunk/regress/dumper/nullsintable-post.sql	2019-07-29 17:36:47 UTC (rev 17645)
@@ -0,0 +1,2 @@
+drop table c;
+delete from spatial_ref_sys where srid = 1;

Added: trunk/regress/dumper/nullsintable-pre.sql
===================================================================
--- trunk/regress/dumper/nullsintable-pre.sql	                        (rev 0)
+++ trunk/regress/dumper/nullsintable-pre.sql	2019-07-29 17:36:47 UTC (rev 17645)
@@ -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);

Added: trunk/regress/dumper/nullsintable.dmp
===================================================================
--- trunk/regress/dumper/nullsintable.dmp	                        (rev 0)
+++ trunk/regress/dumper/nullsintable.dmp	2019-07-29 17:36:47 UTC (rev 17645)
@@ -0,0 +1 @@
+c

Added: trunk/regress/dumper/nullsintable_expected.dbf
===================================================================
(Binary files differ)

Index: trunk/regress/dumper/nullsintable_expected.dbf
===================================================================
--- trunk/regress/dumper/nullsintable_expected.dbf	2019-07-29 16:58:16 UTC (rev 17644)
+++ trunk/regress/dumper/nullsintable_expected.dbf	2019-07-29 17:36:47 UTC (rev 17645)

Property changes on: trunk/regress/dumper/nullsintable_expected.dbf
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Added: trunk/regress/dumper/nullsintable_expected.prj
===================================================================
--- trunk/regress/dumper/nullsintable_expected.prj	                        (rev 0)
+++ trunk/regress/dumper/nullsintable_expected.prj	2019-07-29 17:36:47 UTC (rev 17645)
@@ -0,0 +1 @@
+fake["srs"],text
\ No newline at end of file

Added: trunk/regress/dumper/nullsintable_expected.shp
===================================================================
(Binary files differ)

Index: trunk/regress/dumper/nullsintable_expected.shp
===================================================================
--- trunk/regress/dumper/nullsintable_expected.shp	2019-07-29 16:58:16 UTC (rev 17644)
+++ trunk/regress/dumper/nullsintable_expected.shp	2019-07-29 17:36:47 UTC (rev 17645)

Property changes on: trunk/regress/dumper/nullsintable_expected.shp
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Added: trunk/regress/dumper/nullsintable_expected.shx
===================================================================
(Binary files differ)

Index: trunk/regress/dumper/nullsintable_expected.shx
===================================================================
--- trunk/regress/dumper/nullsintable_expected.shx	2019-07-29 16:58:16 UTC (rev 17644)
+++ trunk/regress/dumper/nullsintable_expected.shx	2019-07-29 17:36:47 UTC (rev 17645)

Property changes on: trunk/regress/dumper/nullsintable_expected.shx
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property