Test check_MaxStrLength_violations.sql (id 0177627dc2e1) (err)
check_MaxStrLength_violations.stable.out.FILTERED 2019-09-21 00:19:50.642034800 +0200check_MaxStrLength_violations.test.out.FILTERED 2019-09-21 00:19:50.673234800 +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 617 lines, 4320 words, 23562 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 617 lines, 4320 words, 23558 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 617 lines, 4320 words, 23562 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 617 lines, 4320 words, 23558 chars in lines not matching '^$|^(\| |)#` 3
4 # 954 lines, 13851 words, 98936 chars in all lines 4 ! 4 # 952 lines, 13832 words, 98673 chars in all lines 4
5 5 5 5
..................
# .L505, .L506, .L507, .L510 #
143 % char, tinyint, int, char # type 143 141 % char, tinyint, int, char # type 141
144 % 34, 1, 1, 13 # length 144 ! 142 % 34, 1, 1, 6 # length 142
145 #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'))); 145 143 #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'))); 143
..................
# .L505, .L506, .L507, .L510 #
155 % char, tinyint, int, char # type 155 153 % char, tinyint, int, char # type 153
156 % 42, 1, 1, 13 # length 156 ! 154 % 42, 1, 1, 6 # length 154
157 #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'))); 157 155 #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'))); 155
..................
# .L250, .L251, .L252, .L253 #
563 % char, tinyint, int, char # type 563 561 % char, tinyint, int, char # type 561
564 % 22, 1, 1, 13 # length 564 ! 562 % 22, 1, 1, 6 # length 562
565 #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'))); 565 563 #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'))); 563
..................
# .L250, .L251, .L252, .L253 #
569 % char, tinyint, int, char # type 569 567 % char, tinyint, int, char # type 567
570 % 23, 1, 1, 13 # length 570 ! 568 % 23, 1, 1, 11 # length 568
571 #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'))); 571 569 #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'))); 569
..................
# .L150, .L151, .L152, .L153 #
869 % char, tinyint, int, char # type 869 867 % char, tinyint, int, char # type 867
870 % 29, 1, 1, 16 # length 870 ! 868 % 29, 1, 1, 5 # length 868
871 #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'))); 871 869 #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'))); 869