Test check_MaxStrLength_violations.sql (id 7617234e528d) (err)
check_MaxStrLength_violations.stable.out.FILTERED 2019-09-21 01:04:00.000000000 +0200check_MaxStrLength_violations.test.out.FILTERED 2019-09-21 01:04:00.000000000 +0200
1 Statistics about stdout of test 'check_MaxStrLength_violations` in directory 'sql/test/sys-schema`: 1 1 Statistics about stdout of test 'check_MaxStrLength_violations` in directory 'sql/test/sys-schema`: 1
2 618 lines, 4321 words, 23596 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 618 lines, 4321 words, 23592 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 618 lines, 4321 words, 23596 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 618 lines, 4321 words, 23592 chars in lines not matching '^$|^(\| |)#` 3
4 # 955 lines, 13852 words, 99550 chars in all lines 4 ! 4 # 955 lines, 13851 words, 99581 chars in all lines 4
5 5 5 5
..................
# .L1152, .L1154, .L1156, .L1160 #
144 % char, tinyint, int, char # type 144 144 % char, tinyint, int, char # type 144
145 % 34, 1, 1, 13 # length 145 ! 145 % 34, 1, 1, 6 # length 145
146 #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'))); 146 146 #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'))); 146
..................
# .L1152, .L1154, .L1156, .L1160 #
156 % char, tinyint, int, char # type 156 156 % char, tinyint, int, char # type 156
157 % 42, 1, 1, 13 # length 157 ! 157 % 42, 1, 1, 6 # length 157
158 #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'))); 158 158 #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'))); 158
..................
# .L521, .L523, .L525, .L527 #
564 % char, tinyint, int, char # type 564 564 % char, tinyint, int, char # type 564
565 % 22, 1, 1, 13 # length 565 ! 565 % 22, 1, 1, 6 # length 565
566 #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'))); 566 566 #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'))); 566
..................
# .L521, .L523, .L525, .L527 #
570 % char, tinyint, int, char # type 570 570 % char, tinyint, int, char # type 570
571 % 23, 1, 1, 13 # length 571 ! 571 % 23, 1, 1, 11 # length 571
572 #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'))); 572 572 #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'))); 572
..................
# .L251, .L253, .L255, .L257 #
870 % char, tinyint, int, char # type 870 870 % char, tinyint, int, char # type 870
871 % 29, 1, 1, 16 # length 871 ! 871 % 29, 1, 1, 5 # length 871
872 #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'))); 872 872 #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'))); 872