Changeset: 52fdcb9cdd55 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=52fdcb9cdd55
Removed Files:
geom/sql/pg_regression/Tests/regress.sql.in
sql/benchmarks/ATIS/Tests/one.sql.in
sql/benchmarks/nobench/Tests/nobench.sql.in
sql/test/BugTracker-2009/Tests/COPY_INTO_char_NULL.SF-2560780.sql.in
sql/test/BugTracker-2009/Tests/parallel_bulk-load.SF-2771052.test.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
sql/test/BugTracker-2016/Tests/malformed-copy-int.Bug-3987.sql.in
sql/test/BugTracker-2016/Tests/wrong-nonil-property-with-copy-binary-into.Bug-3937.sql.in
sql/test/BugTracker-2017/Tests/heapextend.Bug-6134.sql.in
sql/test/Tests/bincopycollist.sql.in
sql/test/Tests/copy-from-compressed.sql.in
sql/test/Tests/copy-into-fwf.sql.in
sql/test/Tests/copy_into.sql.in
sql/test/bugs/Tests/redirect.sql.in
sql/test/json/Tests/load_twitter_data.sql.in
sql/test/merge-partitions/Tests/mergepart28.sql.in
sql/test/scripts/Tests/copy-into-lz4.sql.in
Branch: default
Log Message:
Redundant sql.in files are not needed anymore
diffs (truncated from 2651 to 300 lines):
diff --git a/geom/sql/pg_regression/Tests/regress.sql.in
b/geom/sql/pg_regression/Tests/regress.sql.in
deleted file mode 100644
--- a/geom/sql/pg_regression/Tests/regress.sql.in
+++ /dev/null
@@ -1,282 +0,0 @@
---- basic datatypes (correct)
-
-select '1',ST_asewkt('POINT( 1 2 )') as geom;
-select '2',ST_asewkt('POINT( 1 2 3)') as geom;
-
-select '3',ST_asewkt('LINESTRING( 0 0, 1 1, 2 2, 3 3 , 4 4)') as geom;
-select '4',ST_asewkt('LINESTRING( 0 0 0 , 1 1 1 , 2 2 2 , 3 3 3, 4 4 4)') as
geom;
-select '5',ST_asewkt('LINESTRING( 1 2 3 , 4 5 6 , 7 8 9 , 10 11 12, 13 14
15)') as geom;
-
-select '6',ST_asewkt('POLYGON( (0 0, 10 0, 10 10, 0 10, 0 0) )') as geom;
-select '7',ST_asewkt('POLYGON( (0 0 1 , 10 0 1, 10 10 1, 0 10 1, 0 0 1) )') as
geom;
-select '8',ST_asewkt('POLYGON( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7 ,
5 7, 5 5) )') as geom;
-select '9',ST_asewkt('POLYGON( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7 ,
5 7, 5 5),(1 1,2 1, 2 2, 1 2, 1 1) )') as geom;
-select '10',ST_asewkt('POLYGON( (0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1),(5 5
1, 7 5 1, 7 7 1 , 5 7 1, 5 5 1) )') as geom;
-select '11',ST_asewkt('POLYGON( (0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1),(5 5
1, 7 5 1, 7 7 1, 5 7 1, 5 5 1),(1 1 1,2 1 1, 2 2 1, 1 2 1, 1 1 1) )') as geom;
-
-select '12',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 ))');
-select '13',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 3))');
-select '14',ST_asewkt('GEOMETRYCOLLECTION(LINESTRING( 0 0, 1 1, 2 2, 3 3 , 4
4))');
-select '15',ST_asewkt('GEOMETRYCOLLECTION(LINESTRING( 1 2 3 , 4 5 6 , 7 8 9 ,
10 11 12, 13 14 15))');
-select '16',ST_asewkt('GEOMETRYCOLLECTION(POLYGON( (0 0 1, 10 0 1, 10 10 1, 0
10 1, 0 0 1),(5 5 1, 7 5 1, 7 7 1 , 5 7 1, 5 5 1) ))');
-select '17',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 0),POINT( 1 2 3) )');
-select '18',ST_asewkt('GEOMETRYCOLLECTION(LINESTRING( 0 0 0, 1 1 0, 2 2 0, 3 3
0, 4 4 0),POINT( 1 2 3) )');
-select '19',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 ),LINESTRING( 0 0, 1 1, 2
2, 3 3 , 4 4) )');
-select '20',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 0 ),POINT( 1 2
3),LINESTRING( 1 2 3 , 4 5 6 , 7 8 9 , 10 11 12, 13 14 15) )');
-select '21',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 0 ),POINT( 1 2
3),LINESTRING( 1 2 3 , 4 5 6 , 7 8 9 , 10 11 12, 13 14 15),POLYGON( (0 0 0, 10
0 0, 10 10 0, 0 10 0, 0 0 0) ) )');
-select '22',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 0),POINT( 1 2 3),POLYGON(
(0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1),(5 5 1, 7 5 1, 7 7 1, 5 7 1, 5 5 1),(1
1 1,2 1 1, 2 2 1, 1 2 1, 1 1 1) ) )');
-
-select '23',ST_asewkt('MULTIPOINT( 1 2)') as geom;
-select '24',ST_asewkt('MULTIPOINT( 1 2 3)') as geom;
-select '25',ST_asewkt('MULTIPOINT( 1 2, 3 4, 5 6)') as geom;
-select '26',ST_asewkt('MULTIPOINT( 1 2 3, 5 6 7, 8 9 10, 11 12 13)') as geom;
-select '27',ST_asewkt('MULTIPOINT( 1 2 0, 1 2 3, 4 5 0, 6 7 8)') as geom;
-select '28',ST_asewkt('MULTIPOINT( 1 2 3,4 5 0)') as geom;
-
-select '29',ST_asewkt('MULTILINESTRING( (0 0, 1 1, 2 2, 3 3 , 4 4) )') as geom;
-select '30',ST_asewkt('MULTILINESTRING( (0 0, 1 1, 2 2, 3 3 , 4 4),(0 0, 1 1,
2 2, 3 3 , 4 4))') as geom;
-select '31',ST_asewkt('MULTILINESTRING( (0 0 0, 1 1 0, 2 2 0, 3 3 0, 4 4 0),(0
0 0, 1 1 0, 2 2 0, 3 3 0, 4 4 0),(1 2 3 , 4 5 6 , 7 8 9 , 10 11 12, 13 14 15)
)') as geom;
-select '32',ST_asewkt('MULTILINESTRING( (1 2 3 , 4 5 6 , 7 8 9 , 10 11 12, 13
14 15),(0 0 0, 1 1 0, 2 2 0, 3 3 0, 4 4 0),(0 0 0, 1 1 0, 2 2 0, 3 3 0 , 4 4
0))') as geom;
-
-select '33',ST_asewkt('MULTIPOLYGON( ((0 0, 10 0, 10 10, 0 10, 0 0)) )') as
geom;
-select '34',ST_asewkt('MULTIPOLYGON( ((0 0, 10 0, 10 10, 0 10, 0 0)),( (0 0,
10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7 , 5 7, 5 5) ) )') as geom;
-select '35',ST_asewkt('MULTIPOLYGON( ((0 0 0, 10 0 0, 10 10 0, 0 10 0, 0 0
0)),( (0 0 0, 10 0 0, 10 10 0, 0 10 0, 0 0 0),(5 5 0, 7 5 0, 7 7 0, 5 7 0, 5 5
0) ) ,( (0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1),(5 5 1, 7 5 1, 7 7 1, 5 7 1, 5
5 1),(1 1 1,2 1 1, 2 2 1, 1 2 1, 1 1 1) ) )') as geom;
-
-
-select '36',ST_asewkt('GEOMETRYCOLLECTION(MULTIPOINT( 1 2))');
-select '37',ST_asewkt('GEOMETRYCOLLECTION(MULTIPOINT( 1 2 3))');
-select '38',ST_asewkt('GEOMETRYCOLLECTION(MULTIPOINT( 1 2 3, 5 6 7, 8 9 10, 11
12 13))');
-select '39',ST_asewkt('GEOMETRYCOLLECTION(MULTILINESTRING( (0 0, 1 1, 2 2, 3 3
, 4 4) ))');
-select '40',ST_asewkt('GEOMETRYCOLLECTION(MULTILINESTRING( (1 2 3 , 4 5 6 , 7
8 9 , 10 11 12, 13 14 15),(0 0 0, 1 1 0, 2 2 0, 3 3 0, 4 4 0),(0 0 0, 1 1 0, 2
2 0, 3 3 0, 4 4 0)))');
-select '41',ST_asewkt('GEOMETRYCOLLECTION(MULTIPOLYGON( ((0 0 0, 10 0 0, 10 10
0, 0 10 0, 0 0 0)),( (0 0 0, 10 0 0, 10 10 0, 0 10 0, 0 0 0),(5 5 0, 7 5 0, 7 7
0, 5 7 0, 5 5 0) ) ,( (0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1),(5 5 1, 7 5 1, 7
7 1, 5 7 1, 5 5 1),(1 1 1,2 1 1, 2 2 1, 1 2 1, 1 1 1) ) ))');
-select '42',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 0),MULTIPOINT( 1 2 3))');
-select '43',ST_asewkt('GEOMETRYCOLLECTION(MULTIPOINT( 1 2 0, 3 4 0, 5 6
0),POINT( 1 2 3))');
-select '44',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 3),MULTILINESTRING( (0 0
0, 1 1 0, 2 2 0, 3 3 0 , 4 4 0) ))');
-select '45',ST_asewkt('GEOMETRYCOLLECTION(MULTILINESTRING( (0 0 0, 1 1 0, 2 2
0, 3 3 0 , 4 4 0) ),POINT( 1 2 3))');
-select '46',ST_asewkt('GEOMETRYCOLLECTION(POINT( 1 2 3), MULTIPOLYGON( ((0 0
0, 10 0 0, 10 10 0, 0 10 0, 0 0 0)),( (0 0 0, 10 0 0, 10 10 0, 0 10 0, 0 0
0),(5 5 0, 7 5 0, 7 7 0, 5 7 0, 5 5 0) ) ,( (0 0 1, 10 0 1, 10 10 1, 0 10 1, 0
0 1),(5 5 1, 7 5 1, 7 7 1, 5 7 1, 5 5 1),(1 1 1,2 1 1, 2 2 1, 1 2 1, 1 1 1) )
))');
-select '47',ST_asewkt('GEOMETRYCOLLECTION(MULTIPOLYGON( ((0 0 0, 10 0 0, 10 10
0, 0 10 0, 0 0 0)),( (0 0 0, 10 0 0, 10 10 0, 0 10 0, 0 0 0),(5 5 0, 7 5 0, 7 7
0, 5 7 0, 5 5 0) ) ,( (0 0 1, 10 0 1, 10 10 1, 0 10 1, 0 0 1),(5 5 1, 7 5 1, 7
7 1, 5 7 1, 5 5 1),(1 1 1,2 1 1, 2 2 1, 1 2 1, 1 1 1) ) ),MULTILINESTRING( (0 0
0, 1 1 0, 2 2 0, 3 3 0, 4 4 0),(0 0 0, 1 1 0, 2 2 0, 3 3 0, 4 4 0),(1 2 3 , 4 5
6 , 7 8 9 , 10 11 12, 13 14 15) ),MULTIPOINT( 1 2 3, 5 6 7, 8 9 10, 11 12
13))');
-
-select '48',ST_asewkt('MULTIPOINT( -1 -2 -3, 5.4 6.6 7.77, -5.4 -6.6 -7.77,
1e6 1e-6 -1e6, -1.3e-6 -1.4e-5 0)') as geom;
-
-select '49', ST_asewkt('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1) ))')
as geom;
---- basic datatype (incorrect)
-
-select '50', ST_asewkt('POINT()') as geom;
-select '51', ST_asewkt('POINT(1)') as geom;
-select '52', ST_asewkt('POINT(,)') as geom;
-select '53', ST_asewkt('MULTIPOINT(,)') as geom;
-select '54', ST_asewkt('POINT(a b)') as geom;
-select '55', ST_asewkt('MULTIPOINT()') as geom;
-select '56', ST_asewkt('POLYGON( (0 0, 10 0, 10 10, 0 10) )');
-select '57', ST_asewkt('POLYGON( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7
, 5 7) )');
-select '58', ST_asewkt('MULTILINESTRING((0 0, 1 1),(0 0, 1 1, 2 2,) )');
-
-
---- funny results
-
-select '59',ST_asewkt('POINT(1 2 3, 4 5 6)');
-select '60',ST_asewkt('POINT(1 2 3 4 5 6 7)');
-select '61',ST_asewkt('LINESTRING(1 1)');
---NOT RECOGNISED select '62',regexp_replace(ST_asewkt('POINT( 1e700 0)'),
E'(Infinity|1\.#INF)', 'inf');
---NOT RECOGNISED select '63',regexp_replace(ST_asewkt('POINT( -1e700 0)'),
E'(Infinity|1\.#INF)', 'inf');
-select '62',ST_asewkt('POINT( 1e700 0)');
-select '63',ST_asewkt('POINT( -1e700 0)');
-select '64',ST_asewkt('MULTIPOINT(1 1, 2 2');
-
---- is_same() testing
-
--- ~= works only in MBRs
-select '65',MBR('POINT(1 1)') ~= MBR('POINT(1 1)') as bool;
-select '65a',ST_OrderingEquals('POINT(1 1)','POINT(1 1)') as bool;
-select '66',MBR('POINT(1 1 0)') ~= MBR('POINT(1 1)') as bool;
-select '66a',ST_OrderingEquals('POINT(1 1 0)','POINT(1 1)') as bool;
-select '67',MBR('POINT(1 1 0)') ~= MBR('POINT(1 1 0)') as bool;
-select '67a',ST_OrderingEquals('POINT(1 1 0)','POINT(1 1 0)') as bool;
-
-select '68',MBR('MULTIPOINT(1 1,2 2)') ~= MBR('MULTIPOINT(1 1,2 2)') as bool;
-select '68a',ST_OrderingEquals('MULTIPOINT(1 1,2 2)','MULTIPOINT(1 1,2 2)') as
bool;
-select '69',MBR('MULTIPOINT(2 2, 1 1)') ~= MBR('MULTIPOINT(1 1,2 2)') as bool;
-select '69a',ST_OrderingEquals('MULTIPOINT(2 2, 1 1)','MULTIPOINT(1 1,2 2)')
as bool;
-
-select '70',MBR('GEOMETRYCOLLECTION(POINT( 1 2 3),POINT(4 5 6))') ~=
MBR('GEOMETRYCOLLECTION(POINT( 4 5 6),POINT(1 2 3))') as bool;
-select '70a',ST_OrderingEquals('GEOMETRYCOLLECTION(POINT( 1 2 3),POINT(4 5
6))','GEOMETRYCOLLECTION(POINT( 4 5 6),POINT(1 2 3))') as bool;
-select '71',MBR('MULTIPOINT(4 5 6, 1 2 3)') ~= MBR('GEOMETRYCOLLECTION(POINT(
4 5 6),POINT(1 2 3))') as bool;
-select '71a',ST_OrderingEquals('MULTIPOINT(4 5 6, 1 2
3)','GEOMETRYCOLLECTION(POINT( 4 5 6),POINT(1 2 3))') as bool;
-select '72',MBR('MULTIPOINT(1 2 3, 4 5 6)') ~= MBR('GEOMETRYCOLLECTION(POINT(
4 5 6),POINT(1 2 3))') as bool;
-select '72a',ST_OrderingEquals('MULTIPOINT(1 2 3, 4 5
6)','GEOMETRYCOLLECTION(POINT( 4 5 6),POINT(1 2 3))') as bool;
-select '73',MBR('MULTIPOINT(1 2 3, 4 5 6)') ~=
MBR('GEOMETRYCOLLECTION(MULTIPOINT(1 2 3, 4 5 6))') as bool;
-select '73a',ST_OrderingEquals('MULTIPOINT(1 2 3, 4 5
6)','GEOMETRYCOLLECTION(MULTIPOINT(1 2 3, 4 5 6))') as bool;
-
-
-select '74',MBR('LINESTRING(1 1,2 2)') ~= MBR('POINT(1 1)') as bool;
-select '74a',ST_OrderingEquals('LINESTRING(1 1,2 2)','POINT(1 1)') as bool;
-select '75',MBR('LINESTRING(1 1, 2 2)') ~= MBR('LINESTRING(2 2, 1 1)') as bool;
-select '75a',ST_OrderingEquals('LINESTRING(1 1, 2 2)','LINESTRING(2 2, 1 1)')
as bool;
-select '76',MBR('LINESTRING(1 1, 2 2)') ~= MBR('LINESTRING(1 1, 2 2, 3 3)') as
bool;
-select '76a',ST_OrderingEquals('LINESTRING(1 1, 2 2)','LINESTRING(1 1, 2 2, 3
3)') as bool;
-
---- operator testing (testing is on the BOUNDING BOX (2d), not the actual
geometries)
--- &< and &> work only with MBRs
--- << and >> are not recognised. They are mistaken for left and right shift
-
-select '77',MBR('POINT(1 1)') &< MBR('POINT(1 1)') as bool;
-select '78',MBR('POINT(1 1)') &< MBR('POINT(2 1)') as bool;
-select '79',MBR('POINT(2 1)') &< MBR('POINT(1 1)') as bool;
-
-select '80',MBR('POINT(1 1)') << MBR('POINT(1 1)') as bool;
-select '81',MBR('POINT(1 1)') << MBR('POINT(2 1)') as bool;
-select '82',MBR('POINT(2 1)') << MBR('POINT(1 1)') as bool;
-
-select '83',MBR('POINT(1 1)') &> MBR('POINT(1 1)') as bool;
-select '84',MBR('POINT(1 1)') &> MBR('POINT(2 1)') as bool;
-select '85',MBR('POINT(2 1)') &> MBR('POINT(1 1)') as bool;
-
-select '86',MBR('POINT(1 1)') >> MBR('POINT(1 1)') as bool;
-select '87',MBR('POINT(1 1)') >> MBR('POINT(2 1)') as bool;
-select '88',MBR('POINT(2 1)') >> MBR('POINT(1 1)') as bool;
-
--- overlap
--- && works only with MBRs
-
-select '89',MBR('POINT(1 1)') && MBR('POINT(1 1)') as bool;
-select '90',MBR('POINT(1 1)') && MBR('POINT(2 2)') as bool;
-select '91',MBR('MULTIPOINT(0 0, 1 1)') && MBR('MULTIPOINT(1 1, 2 2)') as bool;
-select '92',MBR('MULTIPOINT(0 0, 1 1)') && MBR('MULTIPOINT(1.0001 1, 2 2)') as
bool;
-select '93',MBR('MULTIPOINT(0 0, 1 1)') && MBR('MULTIPOINT(1 1.0001, 2 2)') as
bool;
-select '94',MBR('MULTIPOINT(0 0, 1 1)') && MBR('MULTIPOINT(1 0, 2 2)') as bool;
-select '95',MBR('MULTIPOINT(0 0, 1 1)') && MBR('MULTIPOINT(1.0001 0, 2 2)') as
bool;
-
-select '96',MBR('MULTIPOINT(0 0, 1 1)') && MBR('MULTIPOINT(0 1, 1 2)') as bool;
-select '97',MBR('MULTIPOINT(0 0, 1 1)') && MBR('MULTIPOINT(0 1.0001, 1 2)') as
bool;
-
---- contains
--- ~ works only with MBRs
-
-select '98',MBR('MULTIPOINT(0 0, 10 10)') ~ MBR('MULTIPOINT(5 5, 7 7)') as
bool;
-select '99',MBR('MULTIPOINT(5 5, 7 7)') ~ MBR('MULTIPOINT(0 0, 10 10)') as
bool;
-select '100',MBR('MULTIPOINT(0 0, 7 7)') ~ MBR('MULTIPOINT(0 0, 10 10)') as
bool;
-select '101',MBR('MULTIPOINT(-0.0001 0, 7 7)') ~ MBR('MULTIPOINT(0 0, 10 10)')
as bool;
-
---- contained by
--- @ works only with MBRs
-
-select '102',MBR('MULTIPOINT(0 0, 10 10)') @ MBR('MULTIPOINT(5 5, 7 7)') as
bool;
-select '103',MBR('MULTIPOINT(5 5, 7 7)') @ MBR('MULTIPOINT(0 0, 10 10)') as
bool;
-select '104',MBR('MULTIPOINT(0 0, 7 7)') @ MBR('MULTIPOINT(0 0, 10 10)') as
bool;
-select '105',MBR('MULTIPOINT(-0.0001 0, 7 7)') @ MBR('MULTIPOINT(0 0, 10 10)')
as bool;
-
-
-
---- function testing
---- conversion function
--- box3d not recognised function
-
-select '106',box3d('MULTIPOINT(0 0, 7 7)') as bvol;
-
--- box3d only type is only used for indexing -- NEVER use one yourself
-select '107',ST_AsEWKT(geometry('BOX3D(0 0 0, 7 7 7 )'));
-
---- debug function testing
-
-select '108',ST_NPoints('MULTIPOINT(0 0, 7 7)') as value;
-select '109',ST_NPoints('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING( 1 1 , 2 2,
3 3))') as value;
-
-select '110', ST_NRings('MULTIPOLYGON( ((0 0, 10 0, 10 10, 0 10, 0 0)),( (0 0,
10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7 , 5 7, 5 5) ) ,( (0 0, 10 0, 10 10, 0
10, 0 0),(5 5, 7 5, 7 7, 5 7, 5 5),(1 1,2 1, 2 2, 1 2, 1 1) ) )') as value;
-
-select '111', ST_mem_size(PostGIS_DropBBOX('MULTIPOLYGON( ((0 0, 10 0, 10 10,
0 10, 0 0)),( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7 , 5 7, 5 5) ) ,( (0
0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7, 5 7, 5 5),(1 1,2 1, 2 2, 1 2, 1 1) )
)')) as value;
-
-select '112',ST_NumGeometries('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING( 1 1
, 2 2, 3 3),MULTIPOINT(1 1, 2 2))') as value;
-
----selection
-
-
-
---- TOAST testing
-
--- create a table with data that will be TOASTed (even after compression)
-create table TEST(a GEOMETRY, b GEOMETRY);
-\< $TSTSRCDIR/regress_biginsert.sql
-
-
----test basic ops on this
-
-select '121',box3d(a) as box3d_a, box3d(b) as box3d_b from TEST;
-
-select '122',MBR(a) << MBR(b) from TEST;
-select '123',MBR(a) &< MBR(b) from TEST;
-select '124',MBR(a) >> MBR(b) from TEST;
-select '125',MBR(a) &> MBR(b) from TEST;
-
-select '126',MBR(a) ~= MBR(b) from TEST;
-select '127',MBR(a) @ MBR(b) from TEST;
-select '128',MBR(a) ~ MBR(b) from TEST;
-
-select '129', ST_mem_size(PostGIS_DropBBOX(a)),
ST_mem_size(PostGIS_DropBBOX(b)) from TEST;
-
-select '131', ST_X('POINT(1 2)');
-select '132', ST_Y('POINT(1 2)');
-select '133', ST_Z('POINT(1 2)');
-select '133a', ST_Z('POINT(1 2 3)');
-select '133b', ST_Z('POINTM(1 2 3)');
-select '133c', ST_M('POINT(1 2)');
-select '133d', ST_M('POINTM(1 2 4)');
-select '133e', ST_M('POINT(1 2 4)');
-
-select '137', box3d('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)');
-select '138', box3d('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY, POINT(0
0))');
-
-select '139',
ST_AsEWKT(ST_multi(ST_setsrid('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY,
POINT(0 0))', 2)));
-select '140', ST_AsEWKT(ST_multi(ST_setsrid('POINT(2 2)', 3)));
-select '141', ST_AsEWKT(ST_multi(ST_setsrid('LINESTRING(2 2, 3 3)', 4)));
-select '142', ST_AsEWKT(ST_multi(ST_setsrid('LINESTRING(2 2, 3 3)', 5)));
-select '143', ST_AsEWKT(ST_multi(ST_setsrid('POLYGON((0 0, 1 0, 1 1, 0 1, 0
0))', 6)));
-select '143c1', ST_AsEWKT(ST_multi('CIRCULARSTRING(0 0, 1 1, 2 2)'));
-select '144', ST_AsEWKT(ST_force_3dm('POINT(1 2 3)'));
-select '145', ST_AsEWKT(ST_force_3dz('POINTM(1 2 3)'));
-select '146', ST_AsEWKT(ST_force_4d('POINTM(1 2 3)'));
-select '147', ST_AsEWKT(ST_force_4d('POINT(1 2 3)'));
-
-select '148', ST_AsText(ST_segmentize('LINESTRING(0 0, 10 0)', 5));
-
-select '149', ST_AsText(ST_segmentize('GEOMETRYCOLLECTION EMPTY', 0.5));
-
-select '150', ST_AsEWKT(ST_force_collection(ST_setsrid('POLYGON((0 0, 1 0, 1
1, 0 1, 0 0))', 6)));
-
-select '151', encode(ST_AsBinary(ST_MakeEnvelope(0, 0, 1, 1,
4326),'ndr'),'hex');
-select '152', ST_SRID(ST_MakeEnvelope(0, 0, 1, 1, 4326));
-select '152.1', ST_SRID(ST_MakeEnvelope(0, 0, 1, 1)) = ST_SRID('POINT(0 0)');
-select '152.2', ST_SRID(ST_SetSRID(ST_MakeEnvelope(0, 0, 1, 1), 4326));
-
-select '153', ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(POINT(0
0))',1));
-select '154',
ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0
0)))',1));
-select '155',
ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0
0), POINT(1 1)))',1));
-select '156',
ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0
0, 1 1), POINT(1 1)))',1));
-select '157',
ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0
0, 1 1), POINT(1 1)))',2));
-select '158',
ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0
0, 1 1), POINT(1 1)),LINESTRING(2 2, 3 3))',2));
-select '159',
ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0
0, 1 1), POINT(1 1)),LINESTRING(2 2, 3 3))',3));
-select '160',
ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0
0, 1 1), POINT(1 1)),LINESTRING(2 2, 3 3))',1));
-select '161',
ST_AsText(ST_CollectionExtract('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0
0, 1 1), GEOMETRYCOLLECTION(POINT(1 1))),LINESTRING(2 2, 3 3))',2));
-select '162',
encode(ST_AsBinary(ST_MakeLine(ST_GeomFromText('POINT(-11.1111111
40)'),ST_GeomFromText('LINESTRING(-11.1111111 70,70
-11.1111111)')),'ndr'),'hex') As result;
-select '163', ST_AsEWKT('POLYGON((0 0 0, 1 0 0, 1 1 0, 0 1 0, 0 0 0))');
-select '164', ST_AsEWKT('POLYGON((0 0 0, 1 0 0, 1 1 0, 0 1 0, 0 0 1))');
-select '165', ST_AsEWKT('POLYGON((0 0 0, 1 0 0, 1 1 0, 0 1 0, 0 0.1 1))');
-select '166', ST_AsText('POINT EMPTY');
-select '167', ST_AsText('LINESTRING EMPTY');
-select '168', ST_AsText('POLYGON EMPTY');
-select '169', ST_AsText('CIRCULARSTRING EMPTY');
-select '170', ST_AsText('COMPOUNDCURVE EMPTY');
-select '171', ST_AsText('CURVEPOLYGON EMPTY');
-select '172', ST_AsText('MULTIPOINT EMPTY');
-select '173', ST_AsText('MULTILINESTRING EMPTY');
-select '174', ST_AsText('MULTIPOLYGON EMPTY');
-select '175', ST_AsText('TRIANGLE EMPTY');
-select '176', ST_AsText('TIN EMPTY');
-select '177', ST_AsText('POLYHEDRALSURFACE EMPTY');
-select '178', ST_AsText('MULTISURFACE EMPTY');
-select '179', ST_AsText('MULTICURVE EMPTY');
-select '180', ST_AsText('GEOMETRYCOLLECTION EMPTY');
-select '181', ST_AsText('GEOMETRYCOLLECTION(TRIANGLE EMPTY,TIN EMPTY)');
-
-
--- Drop test table
-DROP table test;
diff --git a/sql/benchmarks/ATIS/Tests/one.sql.in
b/sql/benchmarks/ATIS/Tests/one.sql.in
deleted file mode 100644
--- a/sql/benchmarks/ATIS/Tests/one.sql.in
+++ /dev/null
@@ -1,126 +0,0 @@
-START TRANSACTION;
-create table aircraft (aircraft_code char(3) NOT NULL,aircraft_type char(64)
NOT NULL,engines decimal(1) NOT NULL,category char(10) NOT NULL,wide_body
char(3) NOT NULL,wing_span float(6,2) NOT NULL,length1 float(6,2) NOT
NULL,weight integer NOT NULL,capacity decimal(3) NOT NULL,pay_load integer NOT
NULL,cruising_speed decimal(5) NOT NULL,range_miles decimal(5) NOT
NULL,pressurized char(3) NOT NULL,PRIMARY KEY (aircraft_code));
-create table airline (airline_code char(2) NOT NULL,airline_name char(64) NOT
NULL,notes char(38) NOT NULL,PRIMARY KEY (airline_code));
-create table airport (airport_code char(3) NOT NULL,airport_name char(40) NOT
NULL,location char(36) NOT NULL,state_code char(2) NOT NULL,country_name
char(25) NOT NULL,time_zone_code char(3) NOT NULL,PRIMARY KEY (airport_code));
-create table airport_service (city_code char(4) NOT NULL,airport_code char(3)
NOT NULL,miles_distant float(4,1) NOT NULL,direction char(3) NOT
NULL,minutes_distant decimal(3) NOT NULL,PRIMARY KEY (city_code, airport_code));
-create table city (city_code char(4) NOT NULL,city_name char(25) NOT
NULL,state_code char(2) NOT NULL,country_name char(25) NOT NULL,time_zone_code
char(3) NOT NULL,PRIMARY KEY (city_code));
-create table class_of_service (class_code char(2) NOT NULL,rank decimal(2) NOT
NULL,class_description char(80) NOT NULL,PRIMARY KEY (class_code));
-create table code_description (code char(5) NOT NULL,description char(110) NOT
NULL,PRIMARY KEY (code));
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
