Changeset: 9500918e8d18 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9500918e8d18 Added Files: sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.sql sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.err sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out sql/test/BugTracker-2019/Tests/could-not-allocate-space.Bug-6795.sql sql/test/BugTracker-2019/Tests/could-not-allocate-space.Bug-6795.stable.err sql/test/BugTracker-2019/Tests/could-not-allocate-space.Bug-6795.stable.out sql/test/BugTracker-2019/Tests/python-aggregate-no-groups.Bug-6726.sql sql/test/BugTracker-2019/Tests/python-aggregate-no-groups.Bug-6726.stable.err sql/test/BugTracker-2019/Tests/python-aggregate-no-groups.Bug-6726.stable.out Modified Files: sql/test/BugTracker-2019/Tests/All sql/test/emptydb/Tests/check.SQL.py sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 tools/mserver/mserver5.c Branch: default Log Message:
Merge with Nov2019 diffs (truncated from 969 to 300 lines): diff --git a/sql/test/BugTracker-2019/Tests/All b/sql/test/BugTracker-2019/Tests/All --- a/sql/test/BugTracker-2019/Tests/All +++ b/sql/test/BugTracker-2019/Tests/All @@ -21,6 +21,7 @@ select_window_function_and_asterisk.Bug- disallow_duplicate_column_aliases.Bug-6723 prepare-types.Bug-6724 prepare-non-existing-function.Bug-6725 +HAVE_LIBPY3?python-aggregate-no-groups.Bug-6726 select-distinct.Bug-6728 table-duplicate-column.Bug-6729 view-too-few-rows.Bug-6736 @@ -51,3 +52,5 @@ isaUUID.Bug-6784 count-distinct.Bug-6790 str_to_time.Bug-6791 jsonpath-validity.Bug-6792 +cast-interval.Bug-6793 +could-not-allocate-space.Bug-6795 diff --git a/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.sql b/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.sql @@ -0,0 +1,20 @@ +CREATE TABLE INTERVAL_TBL (f1 interval second); +INSERT INTO INTERVAL_TBL (f1) VALUES (1.123); +INSERT INTO INTERVAL_TBL (f1) VALUES (2.123); +INSERT INTO INTERVAL_TBL (f1) VALUES (3.123); +INSERT INTO INTERVAL_TBL (f1) VALUES (4.123); +SELECT f1, cast(f1 as int), cast(f1 as dec(8,3)), cast(f1 as real) FROM INTERVAL_TBL; +SELECT count(f1), sum(f1), cast(sum(f1) as int), cast(sum(f1) as dec(8,3)), cast(sum(f1) as real) FROM INTERVAL_TBL; +DROP TABLE INTERVAL_TBL; + +CREATE TABLE INTERVAL_TBL (f1 interval month); +INSERT INTO INTERVAL_TBL (f1) VALUES (1); +INSERT INTO INTERVAL_TBL (f1) VALUES (2); +INSERT INTO INTERVAL_TBL (f1) VALUES (3); +INSERT INTO INTERVAL_TBL (f1) VALUES (4); +SELECT f1, cast(f1 as int) FROM INTERVAL_TBL; +SELECT f1, cast(f1 as dec(3,0)) FROM INTERVAL_TBL; -- returns error: types month_interval(3,0) and decimal(3,0) are not equal for column 'f1' +SELECT f1, cast(f1 as real) FROM INTERVAL_TBL; -- returns error: types month_interval(3,0) and real(24,0) are not equal for column 'f1' +SELECT count(f1), sum(f1), cast(sum(f1) as int), cast(sum(f1) as dec(8,3)), cast(sum(f1) as real) FROM INTERVAL_TBL; +DROP TABLE INTERVAL_TBL; + diff --git a/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.err b/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.err @@ -0,0 +1,30 @@ +stderr of test 'cast-interval.Bug-6793` in directory 'sql/test/BugTracker-2019` itself: + + +# 13:25:35 > +# 13:25:35 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33951" "--set" "mapi_usock=/var/tmp/mtest-5984/.s.monetdb.33951" "--forcemito" "--dbpath=/home/dinther/dev/dev/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" +# 13:25:35 > + +# builtin opt gdk_dbpath = /home/dinther/dev/dev/INSTALL/var/monetdb5/dbfarm/demo +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_ipv6 = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 33951 +# cmdline opt mapi_usock = /var/tmp/mtest-5984/.s.monetdb.33951 +# cmdline opt gdk_dbpath = /home/dinther/dev/dev/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2019 +# cmdline opt embedded_c = true + +# 13:25:36 > +# 13:25:36 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-5984" "--port=33951" +# 13:25:36 > + + +# 13:25:36 > +# 13:25:36 > "Done." +# 13:25:36 > + diff --git a/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out b/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2019/Tests/cast-interval.Bug-6793.stable.out @@ -0,0 +1,97 @@ +stdout of test 'cast-interval.Bug-6793` in directory 'sql/test/BugTracker-2019` itself: + + +# 13:25:35 > +# 13:25:35 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33951" "--set" "mapi_usock=/var/tmp/mtest-5984/.s.monetdb.33951" "--forcemito" "--dbpath=/home/dinther/dev/dev/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2019" "--set" "embedded_c=true" +# 13:25:35 > + +# MonetDB 5 server v11.35.4 (hg id: e54cc7e9164a) +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2019', using 8 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 31.243 GiB available main-memory of which we use 25.463 GiB +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.localdomain:33951/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-5984/.s.monetdb.33951 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +# 13:25:36 > +# 13:25:36 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-5984" "--port=33951" +# 13:25:36 > + +#CREATE TABLE INTERVAL_TBL (f1 interval second); +#INSERT INTO INTERVAL_TBL (f1) VALUES (1.123); +[ 1 ] +#INSERT INTO INTERVAL_TBL (f1) VALUES (2.123); +[ 1 ] +#INSERT INTO INTERVAL_TBL (f1) VALUES (3.123); +[ 1 ] +#INSERT INTO INTERVAL_TBL (f1) VALUES (4.123); +[ 1 ] +#SELECT f1, cast(f1 as int), cast(f1 as dec(8,3)), cast(f1 as real) FROM INTERVAL_TBL; +% sys.interval_tbl, sys.L1, sys.L2, sys.L3 # table_name +% f1, L1, L2, L3 # name +% sec_interval, int, decimal, real # type +% 5, 1, 10, 15 # length +[ 1.123, 1, 1.123, 1.123 ] +[ 2.123, 2, 2.123, 2.123 ] +[ 3.123, 3, 3.123, 3.123 ] +[ 4.123, 4, 4.123, 4.123 ] +#SELECT count(f1), sum(f1), cast(sum(f1) as int), cast(sum(f1) as dec(8,3)), cast(sum(f1) as real) FROM INTERVAL_TBL; +% sys.L2, sys.L3, sys.L5, sys.L7, sys.L11 # table_name +% L2, L3, L5, L7, L11 # name +% bigint, sec_interval, int, decimal, real # type +% 1, 6, 2, 10, 15 # length +[ 4, 10.492, 10, 10.492, 10.492 ] +#DROP TABLE INTERVAL_TBL; +#CREATE TABLE INTERVAL_TBL (f1 interval month); +#INSERT INTO INTERVAL_TBL (f1) VALUES (1); +[ 1 ] +#INSERT INTO INTERVAL_TBL (f1) VALUES (2); +[ 1 ] +#INSERT INTO INTERVAL_TBL (f1) VALUES (3); +[ 1 ] +#INSERT INTO INTERVAL_TBL (f1) VALUES (4); +[ 1 ] +#SELECT f1, cast(f1 as int) FROM INTERVAL_TBL; +% sys.interval_tbl, sys.L1 # table_name +% f1, L1 # name +% month_interval, int # type +% 1, 1 # length +[ 1, 1 ] +[ 2, 2 ] +[ 3, 3 ] +[ 4, 4 ] +#SELECT f1, cast(f1 as dec(3,0)) FROM INTERVAL_TBL; +% sys.interval_tbl, sys.L1 # table_name +% f1, L1 # name +% month_interval, decimal # type +% 1, 5 # length +[ 1, 1 ] +[ 2, 2 ] +[ 3, 3 ] +[ 4, 4 ] +#SELECT f1, cast(f1 as real) FROM INTERVAL_TBL; +% sys.interval_tbl, sys.L1 # table_name +% f1, L1 # name +% month_interval, real # type +% 1, 15 # length +[ 1, 1 ] +[ 2, 2 ] +[ 3, 3 ] +[ 4, 4 ] +#SELECT count(f1), sum(f1), cast(sum(f1) as int), cast(sum(f1) as dec(8,3)), cast(sum(f1) as real) FROM INTERVAL_TBL; +% sys.L2, sys.L3, sys.L5, sys.L7, sys.L11 # table_name +% L2, L3, L5, L7, L11 # name +% bigint, month_interval, int, decimal, real # type +% 1, 2, 2, 10, 15 # length +[ 4, 10, 10, 10.000, 10.000 ] +#DROP TABLE INTERVAL_TBL; + +# 13:25:36 > +# 13:25:36 > "Done." +# 13:25:36 > + diff --git a/sql/test/BugTracker-2019/Tests/could-not-allocate-space.Bug-6795.sql b/sql/test/BugTracker-2019/Tests/could-not-allocate-space.Bug-6795.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2019/Tests/could-not-allocate-space.Bug-6795.sql @@ -0,0 +1,234 @@ +START TRANSACTION; + +CREATE TABLE ingestion ( + ingestion_id INTEGER NOT NULL, + sourcepath VARCHAR(1024), + destinationpath VARCHAR(1024), + sourcereference VARCHAR(4096), + operator VARCHAR(64), + tilesizerow INTEGER, + tilesizecolumn INTEGER, + gridlevels INTEGER, + multitemporal boolean, + overlaprows INTEGER, + overlapcolumns INTEGER, + timeStartUTC VARCHAR(30), + timeStoptUTC VARCHAR(30), + "status" INTEGER, + CONSTRAINT ingestion_id_pkey PRIMARY KEY (ingestion_id) +); + +COPY 22 RECORDS INTO "sys"."ingestion" FROM stdin USING DELIMITERS E'\t',E'\n','"'; +1 "/usr/src/S_product/GRANULE/L1C_T31TCJ_A012232_20190710T105335" "https://platform.candela-h2020.eu/rest/img/L1C_T31TCJ_A012232_20190710T105335/L1C_T31TCJ_A012232_20190710T105335"; "/usr/src/dmg/L1C_T31TCJ_A012232_20190710T105335/L1C_T31TCJ_A012232_20190710T105335" "test" 120 120 1 false 120 120 "2019-11-05T11:03:51.000Z" "2019-11-05T11:06:58.000Z" 2 +2 "/usr/src/S_product/GRANULE/L1C_T33UVR_A021326_20190723T101347" "https://platform.candela-h2020.eu/rest/img/L1C_T33UVR_A021326_20190723T101347/L1C_T33UVR_A021326_20190723T101347"; "/usr/src/dmg/L1C_T33UVR_A021326_20190723T101347/L1C_T33UVR_A021326_20190723T101347" "test" 120 120 1 false 120 120 "2019-11-05T11:13:26.000Z" "2019-11-05T11:16:58.000Z" 2 +4 "/usr/src/S_product/GRANULE/L1C_T32TMT_A012432_20190724T103030" "https://platform.candela-h2020.eu/rest/img/L1C_T32TMT_A012432_20190724T103030/L1C_T32TMT_A012432_20190724T103030"; "/usr/src/dmg/L1C_T32TMT_A012432_20190724T103030/L1C_T32TMT_A012432_20190724T103030" "test" 120 120 1 false 120 120 "2019-11-05T11:13:40.000Z" "2019-11-05T11:17:13.000Z" 2 +5 "/usr/src/S_product/GRANULE/L1C_T31UES_A021784_20190824T105344" "https://platform.candela-h2020.eu/rest/img/L1C_T31UES_A021784_20190824T105344/L1C_T31UES_A021784_20190824T105344"; "/usr/src/dmg/L1C_T31UES_A021784_20190824T105344/L1C_T31UES_A021784_20190824T105344" "test" 120 120 1 false 120 120 "2019-11-05T11:13:47.000Z" "2019-11-05T11:17:26.000Z" 2 +8 "/usr/src/S_product/GRANULE/L1C_T32UPU_A012961_20190830T102552" "https://platform.candela-h2020.eu/rest/img/L1C_T32UPU_A012961_20190830T102552/L1C_T32UPU_A012961_20190830T102552"; "/usr/src/dmg/L1C_T32UPU_A012961_20190830T102552/L1C_T32UPU_A012961_20190830T102552" "test" 120 120 1 false 120 120 "2019-11-05T11:13:57.000Z" "2019-11-05T11:17:37.000Z" 2 +10 "/usr/src/S_product/GRANULE/L1C_T31UFU_A021784_20190824T105344" "https://platform.candela-h2020.eu/rest/img/L1C_T31UFU_A021784_20190824T105344/L1C_T31UFU_A021784_20190824T105344"; "/usr/src/dmg/L1C_T31UFU_A021784_20190824T105344/L1C_T31UFU_A021784_20190824T105344" "test" 120 120 1 false 120 120 "2019-11-05T11:12:34.000Z" "2019-11-05T11:17:34.000Z" 2 +11 "/usr/src/S1B_IW_GRDH_1SDV_20190718T060632_20190718T060657_017184_020521_F49E" "https://platform.candela-h2020.eu/rest/img/S1B_IW_GRDH_1SDV_20190718T060632_20190718T060657_017184_020521_F49E"; "/usr/src/dmg/S1B_IW_GRDH_1SDV_20190718T060632_20190718T060657_017184_020521_F49E" "test" 120 120 1 false 120 120 "2019-11-05T11:14:29.000Z" "2019-11-05T11:40:00.000Z" 2 +12 "/usr/src/S1B_IW_GRDH_1SDV_20190713T055956_20190713T060021_017111_020314_080A" "https://platform.candela-h2020.eu/rest/img/S1B_IW_GRDH_1SDV_20190713T055956_20190713T060021_017111_020314_080A"; "/usr/src/dmg/S1B_IW_GRDH_1SDV_20190713T055956_20190713T060021_017111_020314_080A" "test" 120 120 1 false 120 120 "2019-11-05T11:14:48.000Z" "2019-11-05T11:40:33.000Z" 2 +13 "/usr/src/S1B_IW_GRDH_1SDV_20190712T051713_20190712T051738_017096_0202A5_C8D8" "https://platform.candela-h2020.eu/rest/img/S1B_IW_GRDH_1SDV_20190712T051713_20190712T051738_017096_0202A5_C8D8"; "/usr/src/dmg/S1B_IW_GRDH_1SDV_20190712T051713_20190712T051738_017096_0202A5_C8D8" "test" 120 120 1 false 120 120 "2019-11-05T11:14:45.000Z" "2019-11-05T11:40:56.000Z" 2 +14 "/usr/src/S1B_IW_GRDH_1SDV_20190710T053414_20190710T053439_017067_0201C6_3EFC" "https://platform.candela-h2020.eu/rest/img/S1B_IW_GRDH_1SDV_20190710T053414_20190710T053439_017067_0201C6_3EFC"; "/usr/src/dmg/S1B_IW_GRDH_1SDV_20190710T053414_20190710T053439_017067_0201C6_3EFC" "test" 120 120 1 false 120 120 "2019-11-05T11:15:39.000Z" "2019-11-05T11:41:38.000Z" 2 +15 "/usr/src/S1A_IW_GRDH_1SDV_20190711T052618_20190711T052643_028065_032B64_C67A" "https://platform.candela-h2020.eu/rest/img/S1A_IW_GRDH_1SDV_20190711T052618_20190711T052643_028065_032B64_C67A"; "/usr/src/dmg/S1A_IW_GRDH_1SDV_20190711T052618_20190711T052643_028065_032B64_C67A" "test" 120 120 1 false 120 120 "2019-11-05T11:30:27.000Z" "2019-11-05T11:58:51.000Z" 2 +16 "/usr/src/S1A_IW_GRDH_1SDV_20190718T051950_20190718T052015_028167_032E7E_19D5" "https://platform.candela-h2020.eu/rest/img/S1A_IW_GRDH_1SDV_20190718T051950_20190718T052015_028167_032E7E_19D5"; "/usr/src/dmg/S1A_IW_GRDH_1SDV_20190718T051950_20190718T052015_028167_032E7E_19D5" "test" 120 120 1 false 120 120 "2019-11-05T11:12:52.000Z" "2019-11-05T11:42:50.000Z" 2 +17 "/usr/src/S1B_IW_GRDH_1SDV_20190710T164150_20190710T164215_017074_020201_F677" "https://platform.candela-h2020.eu/rest/img/S1B_IW_GRDH_1SDV_20190710T164150_20190710T164215_017074_020201_F677"; "/usr/src/dmg/S1B_IW_GRDH_1SDV_20190710T164150_20190710T164215_017074_020201_F677" "test" 120 120 1 false 120 120 "2019-11-05T11:13:40.000Z" "2019-11-05T11:43:21.000Z" 2 +18 "/usr/src/S1A_IW_GRDH_1SDV_20190710T062615_20190710T062640_028051_032AFB_9FAE" "https://platform.candela-h2020.eu/rest/img/S1A_IW_GRDH_1SDV_20190710T062615_20190710T062640_028051_032AFB_9FAE"; "/usr/src/dmg/S1A_IW_GRDH_1SDV_20190710T062615_20190710T062640_028051_032AFB_9FAE" "test" 120 120 1 false 120 120 "2019-11-05T19:43:58.000Z" "2019-11-05T20:08:57.000Z" 2 +19 "/usr/src/S1B_IW_GRDH_1SDV_20190711T172417_20190711T172442_017089_020272_4ABF" "https://platform.candela-h2020.eu/rest/img/S1B_IW_GRDH_1SDV_20190711T172417_20190711T172442_017089_020272_4ABF"; "/usr/src/dmg/S1B_IW_GRDH_1SDV_20190711T172417_20190711T172442_017089_020272_4ABF" "test" 120 120 1 false 120 120 "2019-11-05T19:44:09.000Z" "2019-11-05T20:09:39.000Z" 2 +20 "/usr/src/S_product/GRANULE/L1C_T31UDQ_A021355_20190725T105702" "https://platform.candela-h2020.eu/rest/img/L1C_T31UDQ_A021355_20190725T105702/L1C_T31UDQ_A021355_20190725T105702"; "/usr/src/dmg/L1C_T31UDQ_A021355_20190725T105702/L1C_T31UDQ_A021355_20190725T105702" "test" 120 120 1 false 120 120 "2019-11-26T16:16:50.000Z" "2019-11-26T16:21:29.000Z" 2 +21 "/usr/src/S_product/GRANULE/L1C_T31UDQ_A021355_20190725T105702" "https://platform.candela-h2020.eu/rest/img/L1C_T31UDQ_A021355_20190725T105702/L1C_T31UDQ_A021355_20190725T105702"; "/usr/src/dmg/L1C_T31UDQ_A021355_20190725T105702/L1C_T31UDQ_A021355_20190725T105702" "test" 120 120 1 false 120 120 "2019-11-27T08:35:36.000Z" "2019-11-27T08:40:39.000Z" 2 +22 "/eodata/Sentinel-1/SAR/GRD/2019/03/08/S1B_IW_GRDH_1SDV_20190308T171625_20190308T171650_015266_01C90B_2269.SAFE" "https://platform.candela-h2020.eu/rest/img/S1B_IW_GRDH_1SDV_20190308T171625_20190308T171650_015266_01C90B_2269.SAFE"; "/usr/src/dmg/S1B_IW_GRDH_1SDV_20190308T171625_20190308T171650_015266_01C90B_2269.SAFE" "test" 120 120 1 false 120 120 "2019-11-27T08:38:43.000Z" "2019-11-27T09:08:34.000Z" 2 +24 "/eodata/Sentinel-2/MSI/L1C/2016/10/15/S2A_MSIL1C_20161015T154222_N0204_R011_T18TWL_20161015T154519.SAFE/GRANULE/L1C_T18TWL_A006872_20161015T154519" "https://platform.candela-h2020.eu/rest/img/L1C_T18TWL_A006872_20161015T154519/L1C_T18TWL_A006872_20161015T154519"; "/usr/src/dmg/L1C_T18TWL_A006872_20161015T154519/L1C_T18TWL_A006872_20161015T154519" "test" 120 120 1 false 120 120 "2019-11-27T08:38:43.000Z" "2019-11-27T09:12:52.000Z" 2 +25 "/eodata/Sentinel-1/SAR/GRD/2019/03/08/S1B_IW_GRDH_1SDV_20190308T171625_20190308T171650_015266_01C90B_2269.SAFE" "https://platform.candela-h2020.eu/rest/img/S1B_IW_GRDH_1SDV_20190308T171625_20190308T171650_015266_01C90B_2269.SAFE"; "/usr/src/dmg/S1B_IW_GRDH_1SDV_20190308T171625_20190308T171650_015266_01C90B_2269.SAFE" "test" 120 120 1 false 120 120 "2019-11-27T12:20:36.000Z" "2019-11-27T12:49:31.000Z" 2 +26 "/eodata/Sentinel-2/MSI/L1C/2016/10/15/S2A_MSIL1C_20161015T154222_N0204_R011_T18TWL_20161015T154519.SAFE/GRANULE/L1C_T18TWL_A006872_20161015T154519" "https://platform.candela-h2020.eu/rest/img/L1C_T18TWL_A006872_20161015T154519/L1C_T18TWL_A006872_20161015T154519"; "/usr/src/dmg/L1C_T18TWL_A006872_20161015T154519/L1C_T18TWL_A006872_20161015T154519" "test" 120 120 1 false 120 120 "2019-11-27T12:20:36.000Z" "2019-11-27T12:53:22.000Z" 2 +27 "/usr/src/S_product/GRANULE/L1C_T30TYQ_A009529_20170419T110601" "/usr/src/dmg/L1C_T30TYQ_A009529_20170419T110601/L1C_T30TYQ_A009529_20170419T110601" "/usr/src/dmg/L1C_T30TYQ_A009529_20170419T110601/L1C_T30TYQ_A009529_20170419T110601" "test" 120 120 1 false 120 120 "2019-12-04T16:37:46.000Z" "2019-12-04T16:41:23.000Z" 2 + +CREATE TABLE metadata ( + metadata_id INTEGER NOT NULL, + mission VARCHAR(64) NOT NULL, + orbitphase INTEGER, + absorbit INTEGER, + relorbit INTEGER, + orbitcycle INTEGER, + numorbitsincycle INTEGER, + orbitdirection VARCHAR(64), + sensor VARCHAR(64), + imagingmode VARCHAR(64), + antennareceiveconfiguration VARCHAR(64), + lookdirection VARCHAR(64), + polarisationmode VARCHAR(64), + pollayer VARCHAR(64), + projection VARCHAR(64), + mapprojection VARCHAR(64), + producttype VARCHAR(64), + productvariant VARCHAR(64), + radiometriccorrection VARCHAR(64), + resolutionvariant VARCHAR(64), + pixelvalueid VARCHAR(64), + columncontent VARCHAR(64), + rowcontent VARCHAR(64), + imagedatadepth INTEGER, + imagedataformat VARCHAR(64), + imagedatatype VARCHAR(64), + imagestorageorder VARCHAR(64), + numberoflayers INTEGER, + sceneid VARCHAR(1024), + starttimegps BIGINT, + starttimegpsfraction FLOAT, + starttimeutc DATE, + stoptimegps BIGINT, + stoptimegpsfraction FLOAT, + stoptimeutc DATE, + rangetimefirstpixel DOUBLE, + rangetimelastpixel DOUBLE, + scenestoptimeutc VARCHAR(64), + centerazimuthtimeutc VARCHAR(64), + scenerangeextent DOUBLE, + sceneazimuthextent DOUBLE, + scenecentercoord_refrow INTEGER, + scenecentercoord_refcolumn INTEGER, + scenecentercoord_lat FLOAT, + scenecentercoord_lon FLOAT, + scenecentercoord_azimuthtimeutc DATE, + scenecentercoord_incidenceangle DOUBLE, + scenecentercoord_rangetime DOUBLE, + scenecorner_ul_lon FLOAT, + scenecorner_ul_lat FLOAT, + scenecorner_ul_refrow INTEGER, + scenecorner_ul_refcolumn INTEGER, + scenecorner_ul_azimuthtimeutc DATE, + scenecorner_ul_incidenceangle DOUBLE, + scenecorner_ul_rangetime DOUBLE, + scenecorner_ur_lon FLOAT, + scenecorner_ur_lat FLOAT, + scenecorner_ur_refrow INTEGER, + scenecorner_ur_refcolumn INTEGER, + scenecorner_ur_azimuthtimeutc DATE, + scenecorner_ur_incidenceangle DOUBLE, + scenecorner_ur_rangetime DOUBLE, + scenecorner_ll_lon FLOAT, + scenecorner_ll_lat FLOAT, + scenecorner_ll_refrow INTEGER, + scenecorner_ll_refcolumn INTEGER, + scenecorner_ll_azimuthtimeutc DATE, + scenecorner_ll_incidenceangle DOUBLE, + scenecorner_ll_rangetime DOUBLE, + scenecorner_lr_lon FLOAT, + scenecorner_lr_lat FLOAT, _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
