Changeset: 8501fd99054c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8501fd99054c Branch: nospare Log Message:
merged with default diffs (221 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -4206,6 +4206,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 @@ -4206,6 +4206,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -4280,6 +4280,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 @@ -4280,6 +4280,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 @@ -4206,6 +4206,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 @@ -4280,6 +4280,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/miscellaneous/Tests/simple_plans.test b/sql/test/miscellaneous/Tests/simple_plans.test --- a/sql/test/miscellaneous/Tests/simple_plans.test +++ b/sql/test/miscellaneous/Tests/simple_plans.test @@ -283,6 +283,8 @@ sql.bind 1 algebra.projection 2 +bat.single +1 algebra.likejoin 1 algebra.project diff --git a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -4206,6 +4206,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit --- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit +++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -4280,6 +4280,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 @@ -4206,6 +4206,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out b/sql/test/testdb-upgrade/Tests/upgrade.stable.out --- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out +++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit --- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit +++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit @@ -3611,6 +3611,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; 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 @@ -4280,6 +4280,7 @@ Running database upgrade commands: set schema "sys"; ALTER TABLE sys.keywords SET READ WRITE; DELETE FROM sys.keywords where keyword = 'STREAM'; +INSERT INTO sys.keywords VALUES ('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'); ALTER TABLE sys.table_types SET READ WRITE; DELETE FROM sys.table_types where table_type_id = 4; ALTER TABLE sys.function_types SET READ WRITE; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list