Changeset: e81143a701cf for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e81143a701cf
Modified Files:
sql/test/BugTracker-2013/Tests/restore-uuid.Bug-3407.stable.out
sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.stable.out
sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.out
sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.stable.out
sql/test/orderidx/Tests/imprints_all_types.stable.out
sql/test/orderidx/Tests/oidx_all_types.stable.out
Branch: Apr2019
Log Message:
approved uuid length output
diffs (233 lines):
diff --git a/sql/test/BugTracker-2013/Tests/restore-uuid.Bug-3407.stable.out
b/sql/test/BugTracker-2013/Tests/restore-uuid.Bug-3407.stable.out
--- a/sql/test/BugTracker-2013/Tests/restore-uuid.Bug-3407.stable.out
+++ b/sql/test/BugTracker-2013/Tests/restore-uuid.Bug-3407.stable.out
@@ -65,7 +65,7 @@ Ready.
% sys.testuuid # table_name
% column1 # name
% uuid # type
-% 0 # length
+% 36 # length
[ 38fded43-79ef-41b0-a2af-05d20d7c4d51 ]
#ROLLBACK;
diff --git a/sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.stable.out
b/sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.stable.out
--- a/sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.stable.out
+++ b/sql/test/BugTracker-2015/Tests/uuid-compare.Bug-3827.stable.out
@@ -69,32 +69,32 @@ Ready.
% sys.u, sys.u # table_name
% u1, u2 # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
#select * from u where u1 <> u2;
% sys.u, sys.u # table_name
% u1, u2 # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
#select * from u where u1 < u2;
% sys.u, sys.u # table_name
% u1, u2 # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
#select * from u where u1 <= u2;
% sys.u, sys.u # table_name
% u1, u2 # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
#select * from u where u1 > u2;
% sys.u, sys.u # table_name
% u1, u2 # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
#select * from u where u1 >= u2;
% sys.u, sys.u # table_name
% u1, u2 # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
#drop table u;
# 09:49:16 >
diff --git
a/sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.out
b/sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.out
--- a/sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.out
+++ b/sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.out
@@ -52,7 +52,7 @@ Ready.
% sys.testuuid, sys.testuuid # table_name
% s, u # name
% varchar, uuid # type
-% 36, 0 # length
+% 36, 36 # length
[ "7393ad7e-4fcf-461a-856e-b70027fe1a9e",
7393ad7e-4fcf-461a-856e-b70027fe1a9e ]
[ "ad887b3d-08f7-c308-7285-354a1857cbc8",
ad887b3d-08f7-c308-7285-354a1857cbc8 ]
[ "c005d6fd-20c3-4d01-91a5-bbe676593530",
c005d6fd-20c3-4d01-91a5-bbe676593530 ]
@@ -60,7 +60,7 @@ Ready.
% sys.testuuid, sys.testuuid, sys.L4 # table_name
% s, u, a_isa_uuid # name
% varchar, uuid, boolean # type
-% 36, 0, 5 # length
+% 36, 36, 5 # length
[ "7393ad7e-4fcf-461a-856e-b70027fe1a9e",
7393ad7e-4fcf-461a-856e-b70027fe1a9e, true ]
[ "ad887b3d-08f7-c308-7285-354a1857cbc8",
ad887b3d-08f7-c308-7285-354a1857cbc8, true ]
[ "c005d6fd-20c3-4d01-91a5-bbe676593530",
c005d6fd-20c3-4d01-91a5-bbe676593530, true ]
@@ -68,7 +68,7 @@ Ready.
% sys.testuuid, sys.testuuid, sys.L4 # table_name
% s, u, u_isa_uuid # name
% varchar, uuid, boolean # type
-% 36, 0, 5 # length
+% 36, 36, 5 # length
[ "7393ad7e-4fcf-461a-856e-b70027fe1a9e",
7393ad7e-4fcf-461a-856e-b70027fe1a9e, true ]
[ "ad887b3d-08f7-c308-7285-354a1857cbc8",
ad887b3d-08f7-c308-7285-354a1857cbc8, true ]
[ "c005d6fd-20c3-4d01-91a5-bbe676593530",
c005d6fd-20c3-4d01-91a5-bbe676593530, true ]
@@ -76,7 +76,7 @@ Ready.
% sys.testuuid, sys.testuuid # table_name
% s, u # name
% varchar, uuid # type
-% 36, 0 # length
+% 36, 36 # length
[ "7393ad7e-4fcf-461a-856e-b70027fe1a9e",
7393ad7e-4fcf-461a-856e-b70027fe1a9e ]
[ "ad887b3d-08f7-c308-7285-354a1857cbc8",
ad887b3d-08f7-c308-7285-354a1857cbc8 ]
[ "c005d6fd-20c3-4d01-91a5-bbe676593530",
c005d6fd-20c3-4d01-91a5-bbe676593530 ]
@@ -84,7 +84,7 @@ Ready.
% sys.testuuid, sys.testuuid # table_name
% s, u # name
% varchar, uuid # type
-% 36, 0 # length
+% 36, 36 # length
[ "7393ad7e-4fcf-461a-856e-b70027fe1a9e",
7393ad7e-4fcf-461a-856e-b70027fe1a9e ]
[ "ad887b3d-08f7-c308-7285-354a1857cbc8",
ad887b3d-08f7-c308-7285-354a1857cbc8 ]
[ "c005d6fd-20c3-4d01-91a5-bbe676593530",
c005d6fd-20c3-4d01-91a5-bbe676593530 ]
@@ -92,7 +92,7 @@ Ready.
% sys.L4, sys.L7, sys.L12, sys.L15 # table_name
% mn, mx, cnt, cnt_d # name
% uuid, uuid, bigint, bigint # type
-% 0, 0, 1, 1 # length
+% 36, 36, 1, 1 # length
[ 7393ad7e-4fcf-461a-856e-b70027fe1a9e,
c005d6fd-20c3-4d01-91a5-bbe676593530, 3, 3 ]
#DROP TABLE testUUID;
diff --git
a/sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.stable.out
b/sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.stable.out
---
a/sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.stable.out
+++
b/sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.stable.out
@@ -71,19 +71,19 @@ Ready.
% sys.L4, sys.L7 # table_name
% mn, mx # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
[ 1e1a9c62-d656-11e5-9fd7-9b884ad020cd,
1e1a9c62-d656-11e5-9fd7-9b884ad020cd ]
#SELECT MIN(c) AS mn, MAX(c) AS mx FROM test;
% sys.L4, sys.L7 # table_name
% mn, mx # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
[ 1e1a9c62-d656-11e5-9fd7-9b884ad020cd,
1e1a9c62-d656-11e5-9fd7-9b884ad020cd ]
#SELECT MIN(c) AS mn, MAX(c) AS mx FROM test;
% sys.L4, sys.L7 # table_name
% mn, mx # name
% uuid, uuid # type
-% 0, 0 # length
+% 36, 36 # length
[ 1e1a9c62-d656-11e5-9fd7-9b884ad020cd,
1e1a9c62-d656-11e5-9fd7-9b884ad020cd ]
#DROP TABLE test;
diff --git a/sql/test/orderidx/Tests/imprints_all_types.stable.out
b/sql/test/orderidx/Tests/imprints_all_types.stable.out
--- a/sql/test/orderidx/Tests/imprints_all_types.stable.out
+++ b/sql/test/orderidx/Tests/imprints_all_types.stable.out
@@ -72,7 +72,7 @@ Ready.
% sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types #
table_name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal9, decimal83, float, float9, float83,
date, iY, iYM, iM, id, idh, idm, ids, ih, ihm,
ihs, im, ims, is, timestamp, timestamp5, timestampzone,
timestamp5zone, time, time5, timezone, time5zone, blob,
blob100, clob, clob100, character, varchar100,
character10, inet, inet9, json, json10, url, url55, uuid # name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal, decimal, double, real, real, date,
month_interval, month_interval, month_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, timestamp, timestamp,
timestamptz, timestamptz, time, time, timetz, timetz, blob, blob,
clob, clob, char, varchar, char, inet, inet, json, json,
url, url, uuid # type
-% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 0 # length
+% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 36 # length
[ true, 10, 10000, 1000000, 10000000000, 1e+30, 1e+20,
1.000, 123456789, 12345.678, 3.1415, 3.1415, 3.1415, 2009-04-15,
24, 18, 3, 1728000.000, 108000.000, 120000.000,
100000.000, 36000.000, 6000.000, 2000.000, 600.000,
100.000, 10.000, 1995-07-15 07:30:00.000000, 1995-07-15
07:30:00.00000, 1995-07-15 08:30:00.000000+01:00, 1995-07-15
08:30:00.00000+01:00, 07:30:00, 07:30:00.00000, 08:30:00+01:00,
08:30:00.00000+01:00, 123456, 123456, "123456", "123456", "x",
"varchar", "0123456789", 127.0.0.0, 127.127.127.255,
"{\"a\": 123}", "{\"b\": 456}",
www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
#insert into all_types select * from all_types;
@@ -81,7 +81,7 @@ Ready.
% sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types #
table_name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal9, decimal83, float, float9, float83,
date, iY, iYM, iM, id, idh, idm, ids, ih, ihm,
ihs, im, ims, is, timestamp, timestamp5, timestampzone,
timestamp5zone, time, time5, timezone, time5zone, blob,
blob100, clob, clob100, character, varchar100,
character10, inet, inet9, json, json10, url, url55, uuid # name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal, decimal, double, real, real, date,
month_interval, month_interval, month_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, timestamp, timestamp,
timestamptz, timestamptz, time, time, timetz, timetz, blob, blob,
clob, clob, char, varchar, char, inet, inet, json, json,
url, url, uuid # type
-% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 0 # length
+% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 36 # length
[ true, 10, 10000, 1000000, 10000000000, 1e+30, 1e+20,
1.000, 123456789, 12345.678, 3.1415, 3.1415, 3.1415, 2009-04-15,
24, 18, 3, 1728000.000, 108000.000, 120000.000,
100000.000, 36000.000, 6000.000, 2000.000, 600.000,
100.000, 10.000, 1995-07-15 07:30:00.000000, 1995-07-15
07:30:00.00000, 1995-07-15 08:30:00.000000+01:00, 1995-07-15
08:30:00.00000+01:00, 07:30:00, 07:30:00.00000, 08:30:00+01:00,
08:30:00.00000+01:00, 123456, 123456, "123456", "123456", "x",
"varchar", "0123456789", 127.0.0.0, 127.127.127.255,
"{\"a\": 123}", "{\"b\": 456}",
www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ true, 10, 10000, 1000000, 10000000000, 1e+30, 1e+20,
1.000, 123456789, 12345.678, 3.1415, 3.1415, 3.1415, 2009-04-15,
24, 18, 3, 1728000.000, 108000.000, 120000.000,
100000.000, 36000.000, 6000.000, 2000.000, 600.000,
100.000, 10.000, 1995-07-15 07:30:00.000000, 1995-07-15
07:30:00.00000, 1995-07-15 08:30:00.000000+01:00, 1995-07-15
08:30:00.00000+01:00, 07:30:00, 07:30:00.00000, 08:30:00+01:00,
08:30:00.00000+01:00, 123456, 123456, "123456", "123456", "x",
"varchar", "0123456789", 127.0.0.0, 127.127.127.255,
"{\"a\": 123}", "{\"b\": 456}",
www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
@@ -696,7 +696,7 @@ COMMIT;
% sys.all_types # table_name
% uuid # name
% uuid # type
-% 0 # length
+% 36 # length
[ 76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ 76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
@@ -1137,7 +1137,7 @@ COMMIT;
% sys.all_types # table_name
% uuid # name
% uuid # type
-% 0 # length
+% 36 # length
[ ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
[ ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
[ 76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
@@ -1148,7 +1148,7 @@ COMMIT;
% sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types #
table_name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal9, decimal83, float, float9, float83,
date, iY, iYM, iM, id, idh, idm, ids, ih, ihm,
ihs, im, ims, is, timestamp, timestamp5, timestampzone,
timestamp5zone, time, time5, timezone, time5zone, blob,
blob100, clob, clob100, character, varchar100,
character10, inet, inet9, json, json10, url, url55, uuid # name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal, decimal, double, real, real, date,
month_interval, month_interval, month_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, timestamp, timestamp,
timestamptz, timestamptz, time, time, timetz, timetz, blob, blob,
clob, clob, char, varchar, char, inet, inet, json, json,
url, url, uuid # type
-% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 0 # length
+% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 36 # length
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
diff --git a/sql/test/orderidx/Tests/oidx_all_types.stable.out
b/sql/test/orderidx/Tests/oidx_all_types.stable.out
--- a/sql/test/orderidx/Tests/oidx_all_types.stable.out
+++ b/sql/test/orderidx/Tests/oidx_all_types.stable.out
@@ -114,7 +114,7 @@ Ready.
% sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types #
table_name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal9, decimal83, float, float9, float83,
date, iY, iYM, iM, id, idh, idm, ids, ih, ihm,
ihs, im, ims, is, timestamp, timestamp5, timestampzone,
timestamp5zone, time, time5, timezone, time5zone, blob,
blob100, clob, clob100, character, varchar100,
character10, inet, inet9, json, json10, url, url55, uuid # name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal, decimal, double, real, real, date,
month_interval, month_interval, month_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, timestamp, timestamp,
timestamptz, timestamptz, time, time, timetz, timetz, blob, blob,
clob, clob, char, varchar, char, inet, inet, json, json,
url, url, uuid # type
-% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 0 # length
+% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 36 # length
[ true, 10, 10000, 1000000, 10000000000, 1e+30, 1e+20,
1.000, 123456789, 12345.678, 3.1415, 3.1415, 3.1415, 2009-04-15,
24, 18, 3, 1728000.000, 108000.000, 120000.000,
100000.000, 36000.000, 6000.000, 2000.000, 600.000,
100.000, 10.000, 1995-07-15 07:30:00.000000, 1995-07-15
07:30:00.00000, 1995-07-15 08:30:00.000000+01:00, 1995-07-15
08:30:00.00000+01:00, 07:30:00, 07:30:00.00000, 08:30:00+01:00,
08:30:00.00000+01:00, 123456, 123456, "123456", "123456", "x",
"varchar", "0123456789", 127.0.0.0, 127.127.127.255,
"{\"a\": 123}", "{\"b\": 456}",
www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
#insert into all_types select * from all_types;
@@ -123,7 +123,7 @@ Ready.
% sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types #
table_name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal9, decimal83, float, float9, float83,
date, iY, iYM, iM, id, idh, idm, ids, ih, ihm,
ihs, im, ims, is, timestamp, timestamp5, timestampzone,
timestamp5zone, time, time5, timezone, time5zone, blob,
blob100, clob, clob100, character, varchar100,
character10, inet, inet9, json, json10, url, url55, uuid # name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal, decimal, double, real, real, date,
month_interval, month_interval, month_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, timestamp, timestamp,
timestamptz, timestamptz, time, time, timetz, timetz, blob, blob,
clob, clob, char, varchar, char, inet, inet, json, json,
url, url, uuid # type
-% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 0 # length
+% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 36 # length
[ true, 10, 10000, 1000000, 10000000000, 1e+30, 1e+20,
1.000, 123456789, 12345.678, 3.1415, 3.1415, 3.1415, 2009-04-15,
24, 18, 3, 1728000.000, 108000.000, 120000.000,
100000.000, 36000.000, 6000.000, 2000.000, 600.000,
100.000, 10.000, 1995-07-15 07:30:00.000000, 1995-07-15
07:30:00.00000, 1995-07-15 08:30:00.000000+01:00, 1995-07-15
08:30:00.00000+01:00, 07:30:00, 07:30:00.00000, 08:30:00+01:00,
08:30:00.00000+01:00, 123456, 123456, "123456", "123456", "x",
"varchar", "0123456789", 127.0.0.0, 127.127.127.255,
"{\"a\": 123}", "{\"b\": 456}",
www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ true, 10, 10000, 1000000, 10000000000, 1e+30, 1e+20,
1.000, 123456789, 12345.678, 3.1415, 3.1415, 3.1415, 2009-04-15,
24, 18, 3, 1728000.000, 108000.000, 120000.000,
100000.000, 36000.000, 6000.000, 2000.000, 600.000,
100.000, 10.000, 1995-07-15 07:30:00.000000, 1995-07-15
07:30:00.00000, 1995-07-15 08:30:00.000000+01:00, 1995-07-15
08:30:00.00000+01:00, 07:30:00, 07:30:00.00000, 08:30:00+01:00,
08:30:00.00000+01:00, 123456, 123456, "123456", "123456", "x",
"varchar", "0123456789", 127.0.0.0, 127.127.127.255,
"{\"a\": 123}", "{\"b\": 456}",
www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
@@ -888,7 +888,7 @@ COMMIT;
% sys.all_types # table_name
% uuid # name
% uuid # type
-% 0 # length
+% 36 # length
[ 76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ 76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
@@ -1383,7 +1383,7 @@ COMMIT;
% sys.all_types # table_name
% uuid # name
% uuid # type
-% 0 # length
+% 36 # length
[ ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
[ ae106ad4-81fd-4f1a-85e8-5efface60da4 ]
[ 76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
@@ -1394,7 +1394,7 @@ COMMIT;
% sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types,
sys.all_types, sys.all_types, sys.all_types, sys.all_types, sys.all_types #
table_name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal9, decimal83, float, float9, float83,
date, iY, iYM, iM, id, idh, idm, ids, ih, ihm,
ihs, im, ims, is, timestamp, timestamp5, timestampzone,
timestamp5zone, time, time5, timezone, time5zone, blob,
blob100, clob, clob100, character, varchar100,
character10, inet, inet9, json, json10, url, url55, uuid # name
% boolean, tinyint, smallint, int, bigint, double, real,
decimal, decimal, decimal, double, real, real, date,
month_interval, month_interval, month_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, sec_interval, sec_interval,
sec_interval, sec_interval, sec_interval, timestamp, timestamp,
timestamptz, timestamptz, time, time, timetz, timetz, blob, blob,
clob, clob, char, varchar, char, inet, inet, json, json,
url, url, uuid # type
-% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 0 # length
+% 5, 3, 6, 8, 12, 24, 15, 20, 10, 10,
24, 15, 15, 10, 3, 3, 2, 12, 11, 11,
11, 10, 9, 9, 8, 8, 7, 26, 25, 32,
31, 8, 14, 14, 20, 0, 0, 7, 7, 1,
8, 10, 0, 0, 11, 11, 71, 66, 36 # length
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
[ false, -10, -10000, -1000000, -10000000000, -1e+30, -1e+20,
-1.000, -123456789, -12345.678, -3.1415, -3.1415,
-3.1415, 2005-04-15, -24, -18, -3, -1728000.000,
-108000.000, -120000.000, -100000.000, -36000.000, -6000.000,
-2000.000, -600.000, -100.000, -10.000, 1988-07-15
07:30:00.000000, 1988-07-15 07:30:00.00000, 1988-07-15
08:30:00.000000+01:00, 1988-07-15 08:30:00.00000+01:00, 06:30:00,
06:30:00.00000, 07:30:00+01:00, 07:30:00.00000+01:00, 01234567,
01234567, "0123456", "0123456", "A", "Avarchar",
"A012345678", 120.0.0.0, 120.120.120.129, "{\"A\": -123}",
"{\"B\": -456}",
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes,
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype,
76236890-f4e2-4d4f-a02b-ec7a02c3cb50 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
