Changeset: d7460e81c359 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d7460e81c359
Modified Files:
sql/test/testdb-upgrade-hge/Tests/dump.stable.out
sql/test/testdb-upgrade/Tests/dump.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: Jul2015
Log Message:
Approve upgrade tests after release of Jul2015-SP1.
diffs (52 lines):
diff --git a/sql/test/testdb-upgrade-hge/Tests/dump.stable.out
b/sql/test/testdb-upgrade-hge/Tests/dump.stable.out
--- a/sql/test/testdb-upgrade-hge/Tests/dump.stable.out
+++ b/sql/test/testdb-upgrade-hge/Tests/dump.stable.out
@@ -101197,11 +101197,12 @@ CREATE TABLE "testschema"."typestest" (
"varchar100" VARCHAR(100),
"character10" CHAR(10),
"uuid" UUID,
- "inet" INET
+ "inet" INET,
+ "json" JSON
);
COPY 2 RECORDS INTO "testschema"."typestest" FROM stdin USING DELIMITERS
'\t','\n','"';
-true 10 10000 1000000 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"
7d95a9ce-aeb8-4881-9cf7-60b4d55f9e45 192.168.10.0/24
-NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL
+true 10 10000 1000000 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" "𐤀" "varchar" "0123456789"
7d95a9ce-aeb8-4881-9cf7-60b4d55f9e45 192.168.10.0/24
{"f1":{"f12":3},"f2":[2,3,4]}
+NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL
CREATE TABLE "testschema"."keytest1" (
"key1" INTEGER NOT NULL,
"key2" INTEGER NOT NULL,
diff --git a/sql/test/testdb-upgrade/Tests/dump.stable.out
b/sql/test/testdb-upgrade/Tests/dump.stable.out
--- a/sql/test/testdb-upgrade/Tests/dump.stable.out
+++ b/sql/test/testdb-upgrade/Tests/dump.stable.out
@@ -101172,11 +101172,12 @@ CREATE TABLE "testschema"."typestest" (
"varchar100" VARCHAR(100),
"character10" CHAR(10),
"uuid" UUID,
- "inet" INET
+ "inet" INET,
+ "json" JSON
);
COPY 2 RECORDS INTO "testschema"."typestest" FROM stdin USING DELIMITERS
'\t','\n','"';
-true 10 10000 1000000 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"
7d95a9ce-aeb8-4881-9cf7-60b4d55f9e45 192.168.10.0/24
-NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL
+true 10 10000 1000000 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" "𐤀" "varchar" "0123456789"
7d95a9ce-aeb8-4881-9cf7-60b4d55f9e45 192.168.10.0/24
{"f1":{"f12":3},"f2":[2,3,4]}
+NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL
CREATE TABLE "testschema"."keytest1" (
"key1" INTEGER NOT NULL,
"key2" INTEGER NOT NULL,
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
@@ -56,8 +56,8 @@ from sys.storagemodel() group by "schema
insert into sys.systemfunctions (select id from sys.functions where name in
('fuse', 'generate_series', 'stddev_samp', 'stddev_pop', 'var_samp', 'var_pop',
'median', 'quantile', 'corr') and schema_id = (select id from sys.schemas where
name = 'sys') and id not in (select function_id from sys.systemfunctions));
insert into sys.systemfunctions (select id from sys.functions where name =
'filter' and schema_id = (select id from sys.schemas where name = 'json') and
id not in (select function_id from sys.systemfunctions));
update sys._tables set system = true where name = 'tablestoragemodel' and
schema_id = (select id from sys.schemas where name = 'sys');
-insert into sys.types values(7030, 'hge', 'hugeint', 128, 1, 2, 6, 0);
-insert into sys.types values(7031, 'hge', 'decimal', 39, 1, 10, 8, 0);
+insert into sys.types values(7031, 'hge', 'hugeint', 128, 1, 2, 6, 0);
+insert into sys.types values(7032, 'hge', 'decimal', 39, 1, 10, 8, 0);
update sys.types set digits = 18 where systemname = 'lng' and sqlname =
'decimal';
set schema "testschema";
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
