Changeset: 25735610dff1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=25735610dff1
Modified Files:
sql/test/BugDay_2005-10-06_2.9.3/Tests/union_limitation.SF-921992.stable.out
sql/test/BugTracker-2016/Tests/leftjoin.Bug-3981.stable.out
sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
Branch: Nov2019
Log Message:
Approved output
diffs (83 lines):
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/union_limitation.SF-921992.stable.out
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/union_limitation.SF-921992.stable.out
---
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/union_limitation.SF-921992.stable.out
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/union_limitation.SF-921992.stable.out
@@ -23,8 +23,8 @@ stdout of test 'union_limitation.SF-9219
#SELECT val1 AS c1, val2 AS c2 FROM union_test;
% .L13, .L13 # table_name
% c1, c2 # name
-% char, char # type
-% 3, 3 # length
+% varchar, varchar # type
+% 6, 6 # length
[ "abc", "123" ]
[ "abcdef", "123456" ]
diff --git a/sql/test/BugTracker-2016/Tests/leftjoin.Bug-3981.stable.out
b/sql/test/BugTracker-2016/Tests/leftjoin.Bug-3981.stable.out
--- a/sql/test/BugTracker-2016/Tests/leftjoin.Bug-3981.stable.out
+++ b/sql/test/BugTracker-2016/Tests/leftjoin.Bug-3981.stable.out
@@ -43,7 +43,7 @@ stdout of test 'leftjoin.Bug-3981` in di
% .a, .b, .c # table_name
% fruit, fruit, isyellow # name
% char, char, tinyint # type
-% 5, 5, 1 # length
+% 6, 6, 1 # length
[ "banana", "banana", 1 ]
[ "apple", "apple", NULL ]
diff --git
a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
---
a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
+++
b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
@@ -142,7 +142,7 @@ stdout of test 'check_ForeignKey_referen
% .ids, .ids, .ids, .ids, .ids, .ids, .ids # table_name
% id, name, schema_id, table_id, table_name, obj_type,
sys_table # name
% int, varchar, int, int, varchar, char, char # type
-% 1, 0, 1, 1, 0, 6, 11 # length
+% 1, 0, 1, 1, 0, 13, 13 # length
#SELECT * FROM sys.keys WHERE id NOT IN (SELECT id FROM sys.objects);
% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys # table_name
% id, table_id, type, name, rkey, action # name
diff --git a/sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
b/sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
--- a/sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
+++ b/sql/test/sys-schema/Tests/check_MaxStrLength_violations.stable.out
@@ -117,7 +117,7 @@ stdout of test 'check_MaxStrLength_viola
% .L615, .L616, .L617, .L620 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
% char, tinyint, int, char # type
-% 34, 1, 1, 6 # length
+% 34, 1, 1, 13 # length
#SELECT '"sys"."dependencies_vw"."used_by_name"' as full_col_nm, 1024 as
max_allowed_length, length("used_by_name") as data_length, t."used_by_name" as
data_value FROM "sys"."dependencies_vw" t WHERE "used_by_name" IS NOT NULL AND
length("used_by_name") > (select type_digits from sys._columns where name =
'used_by_name' and table_id in (select id from tables where name =
'dependencies_vw' and schema_id in (select id from sys.schemas where name =
'sys')));
% .L615, .L616, .L617, .L620 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
@@ -127,7 +127,7 @@ stdout of test 'check_MaxStrLength_viola
% .L615, .L616, .L617, .L620 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
% char, tinyint, int, char # type
-% 42, 1, 1, 6 # length
+% 42, 1, 1, 13 # length
#SELECT '"sys"."dependency_args_on_types"."arg_name"' as full_col_nm, 256 as
max_allowed_length, length("arg_name") as data_length, t."arg_name" as
data_value FROM "sys"."dependency_args_on_types" t WHERE "arg_name" IS NOT NULL
AND length("arg_name") > (select type_digits from sys._columns where name =
'arg_name' and table_id in (select id from tables where name =
'dependency_args_on_types' and schema_id in (select id from sys.schemas where
name = 'sys')));
% .L34, .L35, sys.L36, sys.L37 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
@@ -467,12 +467,12 @@ stdout of test 'check_MaxStrLength_viola
% .L311, .L312, .L313, .L314 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
% char, tinyint, int, char # type
-% 22, 1, 1, 6 # length
+% 22, 1, 1, 13 # length
#SELECT '"sys"."ids"."sys_table"' as full_col_nm, 13 as max_allowed_length,
length("sys_table") as data_length, t."sys_table" as data_value FROM
"sys"."ids" t WHERE "sys_table" IS NOT NULL AND length("sys_table") > (select
type_digits from sys._columns where name = 'sys_table' and table_id in (select
id from tables where name = 'ids' and schema_id in (select id from sys.schemas
where name = 'sys')));
% .L311, .L312, .L313, .L314 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
% char, tinyint, int, char # type
-% 23, 1, 1, 11 # length
+% 23, 1, 1, 13 # length
#SELECT '"sys"."ids"."table_name"' as full_col_nm, 1024 as max_allowed_length,
length("table_name") as data_length, t."table_name" as data_value FROM
"sys"."ids" t WHERE "table_name" IS NOT NULL AND length("table_name") > (select
type_digits from sys._columns where name = 'table_name' and table_id in (select
id from tables where name = 'ids' and schema_id in (select id from sys.schemas
where name = 'sys')));
% .L311, .L312, .L313, .L314 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
@@ -722,7 +722,7 @@ stdout of test 'check_MaxStrLength_viola
% .L160, .L161, .L162, .L163 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
% char, tinyint, int, char # type
-% 29, 1, 1, 5 # length
+% 29, 1, 1, 16 # length
#SELECT '"tmp"."_columns"."default"' as full_col_nm, 2048 as
max_allowed_length, length("default") as data_length, t."default" as data_value
FROM "tmp"."_columns" t WHERE "default" IS NOT NULL AND length("default") >
(select type_digits from sys._columns where name = 'default' and table_id in
(select id from tables where name = '_columns' and schema_id in (select id from
sys.schemas where name = 'tmp')));
% .L21, .L22, tmp.L23, tmp.L24 # table_name
% full_col_nm, max_allowed_length, data_length, data_value # name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
