2 @message |
assert
- DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
+ PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
- DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
+ PUBLIC.DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
- DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
+ PUBLIC.DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
- DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
+ PUBLIC.DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
- VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
+ VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
- VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
+ VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
- VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
+ VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
- VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
+ VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
- NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
+ NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 Nullable
- NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
+ NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR Nullable
- BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
+ BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
- BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
+ BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
- BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
+ BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 Nullable
- BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
+ BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
- A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
+ A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
- A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
+ A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
- A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
+ A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
- A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
+ A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
- A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
+ A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
- A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
+ A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
- A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
+ A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
- A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
+ A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
- A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
+ A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
- A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
+ A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
- A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
+ A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
- O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
+ O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
- O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
+ O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
- O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
+ O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
- O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
+ O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
- O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
+ O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
- O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
+ O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
- O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
+ O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
- O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
+ O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
- O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
+ O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251
- O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
+ O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
- O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
+ O_BLOB_BINARY OUTPUT BLOB CHARACTER SET SYSTEM.NONE
- OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
+ OUTPUT (PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI_AI
- A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
+ A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
- A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
+ A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
- A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
+ A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
- A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
+ A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
- A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
+ A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
- A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
+ A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
- A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
+ A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
- A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
+ A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
- A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
+ A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
- A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
+ A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
- A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
+ A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
LOG DETAILS:
2025-06-28 05:16:36.000
2025-06-28 05:16:36.011 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-28 05:16:36.021 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-28 05:16:36.030
2025-06-28 05:16:36.042 @pytest.mark.version('>=6.0')
2025-06-28 05:16:36.054 def test_1(act: Action, capsys):
2025-06-28 05:16:36.063
2025-06-28 05:16:36.074 # test N1: check output of SHOW commands:
2025-06-28 05:16:36.084 # --------
2025-06-28 05:16:36.093 test_sql = """
2025-06-28 05:16:36.101 set bail on;
2025-06-28 05:16:36.107
2025-06-28 05:16:36.114 ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION unicode_ci;
2025-06-28 05:16:36.124 COMMIT;
2025-06-28 05:16:36.132
2025-06-28 05:16:36.139 set term ^;
2025-06-28 05:16:36.144
2025-06-28 05:16:36.151 create domain dm_vc_default_cset_implicit_coll as varchar(10)
2025-06-28 05:16:36.156 ^
2025-06-28 05:16:36.162 create domain dm_vc_default_cset_explicit_coll varchar(10) collate utf8
2025-06-28 05:16:36.168 ^
2025-06-28 05:16:36.174 create domain dm_vc_nondef_cset_implicit_coll as varchar(10) character set win1251
2025-06-28 05:16:36.179 ^
2025-06-28 05:16:36.187 create domain dm_vc_nondef_cset_explicit_coll as varchar(10) character set win1251 collate pxw_cyrl
2025-06-28 05:16:36.197 ^
2025-06-28 05:16:36.209 create domain dm_nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:36.220 ^
2025-06-28 05:16:36.231 create domain dm_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:36.240 ^
2025-06-28 05:16:36.252 create domain dm_bt_default_cset_implicit_coll as blob sub_type text
2025-06-28 05:16:36.264 ^
2025-06-28 05:16:36.272 create domain dm_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:36.279 ^
2025-06-28 05:16:36.286 create domain dm_bt_nondef_cset_implicit_coll as blob sub_type text character set win1251
2025-06-28 05:16:36.292 ^
2025-06-28 05:16:36.298 create domain dm_bt_nondef_cset_explicit_coll as blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:36.304 ^
2025-06-28 05:16:36.311 create domain dm_blob_binary blob sub_type binary
2025-06-28 05:16:36.321 ^
2025-06-28 05:16:36.329
2025-06-28 05:16:36.336 ------------------------------------------------------------------------------------------------------------------
2025-06-28 05:16:36.343 recreate table test (
2025-06-28 05:16:36.352 vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-28 05:16:36.360 ,vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-28 05:16:36.367 ,vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-28 05:16:36.374 ,vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-28 05:16:36.381 ,nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:36.389 ,nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:36.398 ,bt_default_cset_implicit_coll blob sub_type text
2025-06-28 05:16:36.405 ,bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:36.412 ,bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-28 05:16:36.419 ,bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:36.425 ,blob_binary blob sub_type binary
2025-06-28 05:16:36.430 )
2025-06-28 05:16:36.441 ^
2025-06-28 05:16:36.450 ------------------------------------------------------------------------------------------------------------------
2025-06-28 05:16:36.458 create procedure sp_test(
2025-06-28 05:16:36.469 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-28 05:16:36.479 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-28 05:16:36.489 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-28 05:16:36.499 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-28 05:16:36.507 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:36.514 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:36.520 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-28 05:16:36.529 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:36.537 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-28 05:16:36.544 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:36.552 ,a_blob_binary blob sub_type binary
2025-06-28 05:16:36.558 ) returns (
2025-06-28 05:16:36.564 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-28 05:16:36.570 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-28 05:16:36.576 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-28 05:16:36.583 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-28 05:16:36.589 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:36.595 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:36.601 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-28 05:16:36.608 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:36.615 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-28 05:16:36.623 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:36.634 ,o_blob_binary blob sub_type binary
2025-06-28 05:16:36.646 )
2025-06-28 05:16:36.659 as
2025-06-28 05:16:36.669 begin
2025-06-28 05:16:36.677 end
2025-06-28 05:16:36.682 ^
2025-06-28 05:16:36.688 ------------------------------------------------------------------------------------------------------------------
2025-06-28 05:16:36.694 create function fn_test(
2025-06-28 05:16:36.700 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-28 05:16:36.712 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-28 05:16:36.722 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-28 05:16:36.730 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-28 05:16:36.737 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:36.744 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:36.750 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-28 05:16:36.756 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:36.762 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-28 05:16:36.767 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:36.773 ,a_blob_binary blob sub_type binary
2025-06-28 05:16:36.780 ) returns dm_vc_default_cset_explicit_coll collate unicode_ci_ai as
2025-06-28 05:16:36.786 begin
2025-06-28 05:16:36.793 return 1;
2025-06-28 05:16:36.798 end
2025-06-28 05:16:36.808 ^
2025-06-28 05:16:36.817 ------------------------------------------------------------------------------------------------------------------
2025-06-28 05:16:36.824 create package pg_test as
2025-06-28 05:16:36.831 begin
2025-06-28 05:16:36.838 procedure pg_sp (
2025-06-28 05:16:36.849 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-28 05:16:36.857 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-28 05:16:36.863 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-28 05:16:36.870 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-28 05:16:36.875 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:36.881 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:36.887 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-28 05:16:36.894 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:36.907 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-28 05:16:36.915 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:36.921 ,a_blob_binary blob sub_type binary
2025-06-28 05:16:36.930 ) returns (
2025-06-28 05:16:36.941 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-28 05:16:36.952 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-28 05:16:36.960 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-28 05:16:36.968 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-28 05:16:36.975 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:36.982 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:36.991 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-28 05:16:37.003 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:37.010 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-28 05:16:37.020 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:37.027 ,o_blob_binary blob sub_type binary
2025-06-28 05:16:37.034 );
2025-06-28 05:16:37.039 end
2025-06-28 05:16:37.045 ^
2025-06-28 05:16:37.051 create package body pg_test as
2025-06-28 05:16:37.057 begin
2025-06-28 05:16:37.062 procedure pg_sp (
2025-06-28 05:16:37.068 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-28 05:16:37.076 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-28 05:16:37.083 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-28 05:16:37.090 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-28 05:16:37.097 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:37.104 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:37.111 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-28 05:16:37.118 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:37.130 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-28 05:16:37.144 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:37.153 ,a_blob_binary blob sub_type binary
2025-06-28 05:16:37.162 ) returns (
2025-06-28 05:16:37.169 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-28 05:16:37.175 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-28 05:16:37.181 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-28 05:16:37.187 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-28 05:16:37.193 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-28 05:16:37.199 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-28 05:16:37.205 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-28 05:16:37.211 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-28 05:16:37.223 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-28 05:16:37.229 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-28 05:16:37.241 ,o_blob_binary blob sub_type binary
2025-06-28 05:16:37.251 ) as
2025-06-28 05:16:37.263 begin
2025-06-28 05:16:37.271 end
2025-06-28 05:16:37.278 end
2025-06-28 05:16:37.289 ^
2025-06-28 05:16:37.299 commit
2025-06-28 05:16:37.309 ^
2025-06-28 05:16:37.321 --#####################################################################################
2025-06-28 05:16:37.331 show domain dm_vc_default_cset_explicit_coll
2025-06-28 05:16:37.343 ^
2025-06-28 05:16:37.353 show domain dm_vc_default_cset_implicit_coll
2025-06-28 05:16:37.360 ^
2025-06-28 05:16:37.366 show domain dm_vc_nondef_cset_implicit_coll
2025-06-28 05:16:37.377 ^
2025-06-28 05:16:37.388 show domain dm_vc_nondef_cset_explicit_coll
2025-06-28 05:16:37.395 ^
2025-06-28 05:16:37.401 show table test
2025-06-28 05:16:37.414 ^
2025-06-28 05:16:37.421 show procedure sp_test
2025-06-28 05:16:37.428 ^
2025-06-28 05:16:37.440 show function fn_test
2025-06-28 05:16:37.451 ^
2025-06-28 05:16:37.459 show package pg_test
2025-06-28 05:16:37.466 ^
2025-06-28 05:16:37.473 """
2025-06-28 05:16:37.478
2025-06-28 05:16:37.484 isql_show_expected_stdout = """
2025-06-28 05:16:37.490 DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-28 05:16:37.496 DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-28 05:16:37.503 DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-28 05:16:37.510 DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-28 05:16:37.520 VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-28 05:16:37.532 VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-28 05:16:37.540 VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-28 05:16:37.549 VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-28 05:16:37.556 NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
2025-06-28 05:16:37.564 NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
2025-06-28 05:16:37.570 BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-28 05:16:37.577 BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-28 05:16:37.583 BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
2025-06-28 05:16:37.590 BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-28 05:16:37.602 BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
2025-06-28 05:16:37.613 A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:37.624 A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:37.633 A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-28 05:16:37.641 A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:37.648 A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-28 05:16:37.655 A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-28 05:16:37.663 A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:37.670 A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:37.677 A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-28 05:16:37.683 A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:37.689 A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-28 05:16:37.695 O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:37.702 O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:37.713 O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-28 05:16:37.721 O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:37.728 O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-28 05:16:37.734 O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-28 05:16:37.741 O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:37.747 O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:37.753 O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
2025-06-28 05:16:37.759 O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:37.765 O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
2025-06-28 05:16:37.770 OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
2025-06-28 05:16:37.777 A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:37.788 A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:37.796 A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-28 05:16:37.802 A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:37.808 A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-28 05:16:37.814 A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-28 05:16:37.820 A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:37.826 A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:37.831 A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-28 05:16:37.837 A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:37.843 A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-28 05:16:37.848 """
2025-06-28 05:16:37.854
2025-06-28 05:16:37.863 act.expected_stdout = isql_show_expected_stdout
2025-06-28 05:16:37.872 act.isql(input = test_sql, combine_output = True)
2025-06-28 05:16:37.880 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-28 05:16:37.887 E assert
2025-06-28 05:16:37.897 E - DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-28 05:16:37.905 E + PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-28 05:16:37.922 E - DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-28 05:16:37.929 E + PUBLIC.DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-28 05:16:37.941 E - DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-28 05:16:37.951 E + PUBLIC.DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-28 05:16:37.968 E - DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-28 05:16:37.975 E + PUBLIC.DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-28 05:16:37.989 E - VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-28 05:16:37.995 E + VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-28 05:16:38.007 E - VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-28 05:16:38.015 E + VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-28 05:16:38.036 E - VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-28 05:16:38.047 E + VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-28 05:16:38.062 E - VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-28 05:16:38.071 E + VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-28 05:16:38.090 E - NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
2025-06-28 05:16:38.098 E + NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 Nullable
2025-06-28 05:16:38.122 E - NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
2025-06-28 05:16:38.130 E + NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR Nullable
2025-06-28 05:16:38.151 E - BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-28 05:16:38.158 E + BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-28 05:16:38.170 E - BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-28 05:16:38.177 E + BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-28 05:16:38.189 E - BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
2025-06-28 05:16:38.195 E + BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-28 05:16:38.207 E - BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-28 05:16:38.213 E + BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-28 05:16:38.225 E BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
2025-06-28 05:16:38.236 E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:38.248 E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-28 05:16:38.262 E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:38.269 E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-28 05:16:38.283 E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-28 05:16:38.290 E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-28 05:16:38.306 E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:38.317 E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-28 05:16:38.335 E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-28 05:16:38.343 E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-28 05:16:38.365 E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-28 05:16:38.375 E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-28 05:16:38.399 E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:38.410 E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-28 05:16:38.428 E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:38.434 E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-28 05:16:38.448 E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-28 05:16:38.454 E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-28 05:16:38.467 E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:38.474 E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-28 05:16:38.486 E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-28 05:16:38.492 E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-28 05:16:38.511 E - O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:38.521 E + O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-28 05:16:38.536 E - O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:38.543 E + O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-28 05:16:38.557 E - O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-28 05:16:38.562 E + O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-28 05:16:38.582 E - O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:38.592 E + O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-28 05:16:38.608 E - O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-28 05:16:38.617 E + O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-28 05:16:38.637 E - O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-28 05:16:38.647 E + O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-28 05:16:38.668 E - O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:38.676 E + O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-28 05:16:38.691 E - O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:38.701 E + O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-28 05:16:38.716 E - O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
2025-06-28 05:16:38.722 E + O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-28 05:16:38.745 E - O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:38.754 E + O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-28 05:16:38.766 E - O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
2025-06-28 05:16:38.773 E + O_BLOB_BINARY OUTPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-28 05:16:38.786 E - OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
2025-06-28 05:16:38.792 E + OUTPUT (PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI_AI
2025-06-28 05:16:38.813 E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:38.822 E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-28 05:16:38.843 E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:38.851 E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-28 05:16:38.867 E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-28 05:16:38.875 E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-28 05:16:38.894 E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:38.902 E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-28 05:16:38.922 E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-28 05:16:38.930 E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-28 05:16:38.944 E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-28 05:16:38.950 E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-28 05:16:38.962 E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-28 05:16:38.975 E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-28 05:16:38.995 E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-28 05:16:39.003 E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-28 05:16:39.016 E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-28 05:16:39.022 E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-28 05:16:39.042 E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-28 05:16:39.053 E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-28 05:16:39.077 E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-28 05:16:39.086 E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-28 05:16:39.101
2025-06-28 05:16:39.107 tests/bugs/gh_7749_test.py:264: AssertionError
2025-06-28 05:16:39.113 ---------------------------- Captured stdout setup -----------------------------
2025-06-28 05:16:39.118 Creating db: localhost:/var/tmp/qa_2024/test_11615/test.fdb [page_size=None, sql_dialect=None, charset='UTF8', user=SYSDBA, password=masterkey]
|
3 #text |
act = <firebird.qa.plugin.Action pytest object at [hex]>
capsys = <_pytest.capture.CaptureFixture pytest object at [hex]>
@pytest.mark.version('>=6.0')
def test_1(act: Action, capsys):
# test N1: check output of SHOW commands:
# --------
test_sql = """
set bail on;
ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION unicode_ci;
COMMIT;
set term ^;
create domain dm_vc_default_cset_implicit_coll as varchar(10)
^
create domain dm_vc_default_cset_explicit_coll varchar(10) collate utf8
^
create domain dm_vc_nondef_cset_implicit_coll as varchar(10) character set win1251
^
create domain dm_vc_nondef_cset_explicit_coll as varchar(10) character set win1251 collate pxw_cyrl
^
create domain dm_nc_fixed_char_implicit_coll nchar(10)
^
create domain dm_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
^
create domain dm_bt_default_cset_implicit_coll as blob sub_type text
^
create domain dm_bt_default_cset_explicit_coll blob sub_type text collate utf8
^
create domain dm_bt_nondef_cset_implicit_coll as blob sub_type text character set win1251
^
create domain dm_bt_nondef_cset_explicit_coll as blob sub_type text character set win1251 collate pxw_cyrl
^
create domain dm_blob_binary blob sub_type binary
^
------------------------------------------------------------------------------------------------------------------
recreate table test (
vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
,vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
,vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
,vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
,nc_fixed_char_implicit_coll nchar(10)
,nc_fixed_char_explicit_coll nchar(10) collate fr_fr
,bt_default_cset_implicit_coll blob sub_type text
,bt_default_cset_explicit_coll blob sub_type text collate utf8
,bt_nondef_cset_implicit_coll blob sub_type text character set win1251
,bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
,blob_binary blob sub_type binary
)
^
------------------------------------------------------------------------------------------------------------------
create procedure sp_test(
a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
,a_nc_fixed_char_implicit_coll nchar(10)
,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
,a_bt_default_cset_implicit_coll blob sub_type text
,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
,a_blob_binary blob sub_type binary
) returns (
o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
,o_nc_fixed_char_implicit_coll nchar(10)
,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
,o_bt_default_cset_implicit_coll blob sub_type text
,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
,o_blob_binary blob sub_type binary
)
as
begin
end
^
------------------------------------------------------------------------------------------------------------------
create function fn_test(
a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
,a_nc_fixed_char_implicit_coll nchar(10)
,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
,a_bt_default_cset_implicit_coll blob sub_type text
,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
,a_blob_binary blob sub_type binary
) returns dm_vc_default_cset_explicit_coll collate unicode_ci_ai as
begin
return 1;
end
^
------------------------------------------------------------------------------------------------------------------
create package pg_test as
begin
procedure pg_sp (
a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
,a_nc_fixed_char_implicit_coll nchar(10)
,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
,a_bt_default_cset_implicit_coll blob sub_type text
,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
,a_blob_binary blob sub_type binary
) returns (
o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
,o_nc_fixed_char_implicit_coll nchar(10)
,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
,o_bt_default_cset_implicit_coll blob sub_type text
,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
,o_blob_binary blob sub_type binary
);
end
^
create package body pg_test as
begin
procedure pg_sp (
a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
,a_nc_fixed_char_implicit_coll nchar(10)
,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
,a_bt_default_cset_implicit_coll blob sub_type text
,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
,a_blob_binary blob sub_type binary
) returns (
o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
,o_nc_fixed_char_implicit_coll nchar(10)
,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
,o_bt_default_cset_implicit_coll blob sub_type text
,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
,o_blob_binary blob sub_type binary
) as
begin
end
end
^
commit
^
--#####################################################################################
show domain dm_vc_default_cset_explicit_coll
^
show domain dm_vc_default_cset_implicit_coll
^
show domain dm_vc_nondef_cset_implicit_coll
^
show domain dm_vc_nondef_cset_explicit_coll
^
show table test
^
show procedure sp_test
^
show function fn_test
^
show package pg_test
^
"""
isql_show_expected_stdout = """
DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
"""
act.expected_stdout = isql_show_expected_stdout
act.isql(input = test_sql, combine_output = True)
> assert act.clean_stdout == act.clean_expected_stdout
E assert
E - DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
E + PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
E - DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
E + PUBLIC.DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
E - DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
E + PUBLIC.DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
E - DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
E + PUBLIC.DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
E - VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
E + VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
E - VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
E + VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
E - VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
E + VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
E - VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
E + VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
E - NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
E + NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 Nullable
E - NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
E + NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR Nullable
E - BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
E + BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
E - BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
E + BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
E - BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
E + BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 Nullable
E - BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
E + BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
E BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
E - O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
E + O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
E - O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
E + O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
E - O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
E + O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
E - O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
E + O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
E - O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
E + O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
E - O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
E + O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
E - O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
E + O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
E - O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
E + O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
E - O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
E + O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251
E - O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
E + O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
E - O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
E + O_BLOB_BINARY OUTPUT BLOB CHARACTER SET SYSTEM.NONE
E - OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
E + OUTPUT (PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI_AI
E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
tests/bugs/gh_7749_test.py:264: AssertionError
|