Changeset: 1ac229a3c8d4 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1ac229a3c8d4 Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 sql/test/BugTracker-2015/Tests/expression_with_comparison.Bug-3854.stable.out sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.stable.out sql/test/BugTracker-2015/Tests/schemadiff.Bug-3778.stable.out sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/check.stable.out sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 sql/test/leaks/Tests/check0.stable.out sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check2.stable.out.int128 sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check3.stable.out.int128 sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check4.stable.out.int128 sql/test/leaks/Tests/check5.stable.out sql/test/leaks/Tests/check5.stable.out.int128 sql/test/leaks/Tests/select1.stable.out sql/test/leaks/Tests/select2.stable.out Branch: default Log Message:
Approvals. diffs (truncated from 1250 to 300 lines): diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -1184,9 +1184,6 @@ create aggregate var_samp(val double) re create aggregate var_samp(val date) returns double external name "aggr"."variance"; create aggregate var_samp(val time) returns double external name "aggr"."variance"; create aggregate var_samp(val timestamp) returns double external name "aggr"."variance"; -create function zorder_decode_x(z oid) returns integer external name zorder.decode_x; -create function zorder_decode_y(z oid) returns integer external name zorder.decode_y; -create function zorder_encode(x integer, y integer) returns oid external name zorder.encode; -- helper function create function pcre_replace(origin string, pat string, repl string, flags string) returns string external name pcre.replace; @@ -4972,6 +4969,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/clients/Tests/SQL-dump.stable.out.int128 b/clients/Tests/SQL-dump.stable.out.int128 --- a/clients/Tests/SQL-dump.stable.out.int128 +++ b/clients/Tests/SQL-dump.stable.out.int128 @@ -5335,6 +5335,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/BugTracker-2015/Tests/expression_with_comparison.Bug-3854.stable.out b/sql/test/BugTracker-2015/Tests/expression_with_comparison.Bug-3854.stable.out --- a/sql/test/BugTracker-2015/Tests/expression_with_comparison.Bug-3854.stable.out +++ b/sql/test/BugTracker-2015/Tests/expression_with_comparison.Bug-3854.stable.out @@ -71,7 +71,7 @@ Ready. # AND ((FALSE AND (TRUE OR FALSE)) # OR (15 > t.foo) # ); -% .t, .t # table_name +% sys.t, sys.t # table_name % id, foo # name % int, int # type % 1, 1 # length diff --git a/sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.stable.out b/sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.stable.out --- a/sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.stable.out +++ b/sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.stable.out @@ -80,7 +80,7 @@ Ready. # WHERE A.startdate > '2010-10-01' #) #AND A.startdate >= B.startdate; -% .L1 # table_name +% sys.L1 # table_name % L1 # name % bigint # type % 1 # length diff --git a/sql/test/BugTracker-2015/Tests/schemadiff.Bug-3778.stable.out b/sql/test/BugTracker-2015/Tests/schemadiff.Bug-3778.stable.out --- a/sql/test/BugTracker-2015/Tests/schemadiff.Bug-3778.stable.out +++ b/sql/test/BugTracker-2015/Tests/schemadiff.Bug-3778.stable.out @@ -23,13 +23,14 @@ stdout of test 'schemadiff.Bug-3778` in Ready. -# 15:29:05 > -# 15:29:05 > "/usr/bin/python2" "schemadiff.Bug-3778.SQL.py" "schemadiff.Bug-3778" -# 15:29:05 > +# 11:19:25 > +# 11:19:25 > "/usr/bin/python2" "schemadiff.Bug-3778.SQL.py" "schemadiff.Bug-3778" +# 11:19:25 > -(mapi:monetdb://monetdb@localhost/worker_0) 'user.l1' undefined in: rmt5_X_1_bat_int:bat[:int] := user.l1(); +(mapi:monetdb://monetdb@localhost/worker_0) 'user.l1' undefined in: rmt5_X_4_bat_int:bat[:int] := user.l1(); -# 15:29:06 > -# 15:29:06 > "Done." -# 15:29:06 > +# 11:19:26 > +# 11:19:26 > "Done." +# 11:19:26 > + diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 @@ -5134,6 +5134,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out @@ -4764,6 +4764,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 @@ -5134,6 +5134,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 @@ -5134,6 +5134,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/emptydb-upgrade/Tests/check.stable.out b/sql/test/emptydb-upgrade/Tests/check.stable.out --- a/sql/test/emptydb-upgrade/Tests/check.stable.out +++ b/sql/test/emptydb-upgrade/Tests/check.stable.out @@ -4764,6 +4764,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/emptydb-upgrade/Tests/check.stable.out.int128 b/sql/test/emptydb-upgrade/Tests/check.stable.out.int128 --- a/sql/test/emptydb-upgrade/Tests/check.stable.out.int128 +++ b/sql/test/emptydb-upgrade/Tests/check.stable.out.int128 @@ -5134,6 +5134,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/emptydb/Tests/check.stable.out b/sql/test/emptydb/Tests/check.stable.out --- a/sql/test/emptydb/Tests/check.stable.out +++ b/sql/test/emptydb/Tests/check.stable.out @@ -4764,6 +4764,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/emptydb/Tests/check.stable.out.int128 b/sql/test/emptydb/Tests/check.stable.out.int128 --- a/sql/test/emptydb/Tests/check.stable.out.int128 +++ b/sql/test/emptydb/Tests/check.stable.out.int128 @@ -5134,6 +5134,7 @@ drop function pcre_replace(string, strin [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] diff --git a/sql/test/leaks/Tests/check0.stable.out b/sql/test/leaks/Tests/check0.stable.out --- a/sql/test/leaks/Tests/check0.stable.out +++ b/sql/test/leaks/Tests/check0.stable.out @@ -74,13 +74,13 @@ Ready. [ "str", 1 ] [ "str", 1 ] [ "str", 1 ] -[ "str", 255 ] +[ "str", 256 ] #select 'transient', count(*) from bbp() as bbp where kind like 'tran%'; % .L1, .L2 # table_name % L1, L2 # name % char, bigint # type % 9, 3 # length -[ "transient", 551 ] +[ "transient", 553 ] #select 'persistent', count(*) from bbp() as bbp where kind like 'pers%'; % .L1, .L2 # table_name % L1, L2 # name diff --git a/sql/test/leaks/Tests/check1.stable.out b/sql/test/leaks/Tests/check1.stable.out --- a/sql/test/leaks/Tests/check1.stable.out +++ b/sql/test/leaks/Tests/check1.stable.out @@ -39,13 +39,14 @@ Ready. [ "bit", 0 ] [ "bit", 0 ] [ "bit", 0 ] +[ "bit", 0 ] [ "bit", 5 ] [ "bit", 56 ] -[ "bit", 382 ] -[ "bit", 1546 ] -[ "bit", 1546 ] -[ "bit", 1546 ] -[ "bte", 4366 ] +[ "bit", 383 ] +[ "bit", 1548 ] +[ "bit", 1548 ] +[ "bit", 1548 ] +[ "bte", 4369 ] [ "int", 0 ] [ "int", 0 ] [ "int", 0 ] @@ -103,33 +104,33 @@ Ready. [ "int", 34 ] [ "int", 34 ] [ "int", 34 ] -[ "int", 47 ] -[ "int", 47 ] -[ "int", 47 ] -[ "int", 47 ] -[ "int", 47 ] +[ "int", 44 ] +[ "int", 44 ] +[ "int", 44 ] +[ "int", 44 ] +[ "int", 44 ] [ "int", 56 ] [ "int", 56 ] -[ "int", 255 ] -[ "int", 265 ] -[ "int", 265 ] -[ "int", 382 ] -[ "int", 382 ] -[ "int", 382 ] -[ "int", 382 ] -[ "int", 382 ] -[ "int", 1546 ] -[ "int", 1546 ] -[ "int", 1546 ] -[ "int", 1546 ] -[ "int", 1546 ] +[ "int", 256 ] +[ "int", 266 ] +[ "int", 266 ] +[ "int", 383 ] +[ "int", 383 ] +[ "int", 383 ] +[ "int", 383 ] +[ "int", 383 ] +[ "int", 1548 ] +[ "int", 1548 ] +[ "int", 1548 ] +[ "int", 1548 ] +[ "int", 1548 ] [ "int", 3911 ] [ "int", 3911 ] -[ "int", 4366 ] -[ "int", 4366 ] -[ "int", 4366 ] -[ "int", 4366 ] -[ "int", 4366 ] +[ "int", 4369 ] +[ "int", 4369 ] +[ "int", 4369 ] +[ "int", 4369 ] +[ "int", 4369 ] [ "lng", 0 ] [ "lng", 0 ] [ "lng", 0 ] @@ -208,7 +209,7 @@ Ready. [ "sht", 56 ] [ "sht", 56 ] [ "sht", 56 ] -[ "sht", 265 ] +[ "sht", 266 ] [ "str", 0 ] [ "str", 0 ] [ "str", 0 ] @@ -283,19 +284,19 @@ Ready. [ "str", 56 ] [ "str", 56 ] [ "str", 218 ] -[ "str", 255 ] -[ "str", 382 ] -[ "str", 382 ] -[ "str", 382 ] -[ "str", 382 ] -[ "str", 1546 ] -[ "str", 1546 ] -[ "str", 1546 ] +[ "str", 256 ] +[ "str", 383 ] +[ "str", 383 ] +[ "str", 383 ] +[ "str", 383 ] +[ "str", 1548 ] +[ "str", 1548 ] +[ "str", 1548 ] [ "str", 3911 ] [ "str", 3911 ] [ "str", 3911 ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
