Changeset: 81294173e932 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=81294173e932
Modified Files:
sql/test/Dump/Tests/dump.stable.out
sql/test/Dump/Tests/load.sql
sql/test/Dump/Tests/load.stable.out
Branch: default
Log Message:
Extend table typestest with tests for missing types: inet, json, url and uuid.
diffs (90 lines):
diff --git a/sql/test/Dump/Tests/dump.stable.out
b/sql/test/Dump/Tests/dump.stable.out
--- a/sql/test/Dump/Tests/dump.stable.out
+++ b/sql/test/Dump/Tests/dump.stable.out
@@ -79,10 +79,17 @@ CREATE TABLE "sys"."typestest" (
"clob100" CHARACTER LARGE OBJECT(100),
"character" CHAR(1),
"varchar100" VARCHAR(100),
- "character10" CHAR(10)
+ "character10" CHAR(10),
+ "inet" INET,
+ "inet9" INET(9),
+ "json" JSON,
+ "json10" JSON(10),
+ "url" URL,
+ "url55" URL(55),
+ "uuid" UUID
);
COPY 1 RECORDS INTO "sys"."typestest" FROM stdin USING DELIMITERS
'\t','\n','"';
-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
07:30:00.000000+00:00 1995-07-15 07:30:00.00000+00:00 07:30:00
07:30:00.00000 07:30:00+00:00 07:30:00.00000+00:00 123456 123456
"123456" "123456" "x" "varchar" "0123456789"
+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
07:30:00.000000+00:00 1995-07-15 07:30:00.00000+00:00 07:30:00
07:30:00.00000 07:30:00+00:00 07:30:00.00000+00:00 123456 123456
"123456" "123456" "x" "varchar" "0123456789"
127.0.0.0 127.127.127.255 {"a": 123} {"b": 456}
https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes
https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype
ae106ad4-81fd-4f1a-85e8-5efface60da4
CREATE TABLE "sys"."keytest1" (
"key1" INTEGER NOT NULL,
"key2" INTEGER NOT NULL,
diff --git a/sql/test/Dump/Tests/load.sql b/sql/test/Dump/Tests/load.sql
--- a/sql/test/Dump/Tests/load.sql
+++ b/sql/test/Dump/Tests/load.sql
@@ -51,7 +51,14 @@ create table "typestest" (
"clob100" clob(100),
"character" character,
"varchar100" character varying(100),
- "character10" character(10)
+ "character10" character(10),
+ "inet" inet,
+ "inet9" inet(9),
+ "json" json,
+ "json10" json(10),
+ "url" url,
+ "url55" URL(55),
+ "uuid" uuid
);
insert into "typestest" values (true, 10, 10000, 1000000,
10000000000, 1e30, 1e20, 1, 123456789, 12345.678, 3.1415, 3.1415,
@@ -64,7 +71,12 @@ insert into "typestest" values (true, 10
timestamp '1995-07-15 07:30', timestamp '1995-07-15 07:30',
time '07:30', time '07:30', time '07:30', time '07:30',
blob '123456', blob '123456',
- '123456', '123456', 'x', 'varchar', '0123456789');
+ '123456', '123456', 'x', 'varchar', '0123456789',
+ '127.0.0.0', '127.127.127.255',
+ '{"a": 123}', '{"b": 456}',
+
'https://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes',
+ 'https://www.monetdb.org/Documentation/Manuals/SQLreference/URLtype',
+ 'ae106ad4-81fd-4f1a-85e8-5efface60da4');
create table keytest1 (
key1 int,
@@ -80,3 +92,4 @@ insert into keytest1 values (0, 0);
insert into keytest1 values (0, 1);
insert into keytest2 values (0, 0);
insert into keytest2 values (0, 1);
+
diff --git a/sql/test/Dump/Tests/load.stable.out
b/sql/test/Dump/Tests/load.stable.out
--- a/sql/test/Dump/Tests/load.stable.out
+++ b/sql/test/Dump/Tests/load.stable.out
@@ -15,16 +15,18 @@ stdout of test 'load` in directory 'sql/
# MonetDB/SQL module v2.30.3 loaded
Ready.
-#function user.main():void;
-# clients.quit();
-#end main;
+# 18:42:56 >
+# 18:42:56 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-6207" "--port=37397"
+# 18:42:56 >
-# 17:36:20 >
-# 17:36:20 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32825 < load.sql
-# 17:36:20 >
-
+#create sequence "test_seq" as smallint start with 7 increment by 3 minvalue 5
maxvalue 10 cycle;
+#create table "test" (
+# id integer,
+# i smallint default next value for test_seq);
+#insert into test (id) values (0);
[ 1 ]
+#insert into test (id) values (1);
[ 1 ]
[ 1 ]
[ 1 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
