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-29 05:34:48.546
2025-06-29 05:34:48.552 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-29 05:34:48.558 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-29 05:34:48.562
2025-06-29 05:34:48.567 @pytest.mark.version('>=6.0')
2025-06-29 05:34:48.573 def test_1(act: Action, capsys):
2025-06-29 05:34:48.578
2025-06-29 05:34:48.583 # test N1: check output of SHOW commands:
2025-06-29 05:34:48.595 # --------
2025-06-29 05:34:48.603 test_sql = """
2025-06-29 05:34:48.610 set bail on;
2025-06-29 05:34:48.616
2025-06-29 05:34:48.623 ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION unicode_ci;
2025-06-29 05:34:48.631 COMMIT;
2025-06-29 05:34:48.640
2025-06-29 05:34:48.648 set term ^;
2025-06-29 05:34:48.657
2025-06-29 05:34:48.668 create domain dm_vc_default_cset_implicit_coll as varchar(10)
2025-06-29 05:34:48.678 ^
2025-06-29 05:34:48.687 create domain dm_vc_default_cset_explicit_coll varchar(10) collate utf8
2025-06-29 05:34:48.698 ^
2025-06-29 05:34:48.706 create domain dm_vc_nondef_cset_implicit_coll as varchar(10) character set win1251
2025-06-29 05:34:48.716 ^
2025-06-29 05:34:48.727 create domain dm_vc_nondef_cset_explicit_coll as varchar(10) character set win1251 collate pxw_cyrl
2025-06-29 05:34:48.736 ^
2025-06-29 05:34:48.748 create domain dm_nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:48.760 ^
2025-06-29 05:34:48.770 create domain dm_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:48.778 ^
2025-06-29 05:34:48.791 create domain dm_bt_default_cset_implicit_coll as blob sub_type text
2025-06-29 05:34:48.802 ^
2025-06-29 05:34:48.811 create domain dm_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:48.825 ^
2025-06-29 05:34:48.838 create domain dm_bt_nondef_cset_implicit_coll as blob sub_type text character set win1251
2025-06-29 05:34:48.852 ^
2025-06-29 05:34:48.865 create domain dm_bt_nondef_cset_explicit_coll as blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:48.876 ^
2025-06-29 05:34:48.890 create domain dm_blob_binary blob sub_type binary
2025-06-29 05:34:48.902 ^
2025-06-29 05:34:48.916
2025-06-29 05:34:48.928 ------------------------------------------------------------------------------------------------------------------
2025-06-29 05:34:48.937 recreate table test (
2025-06-29 05:34:48.946 vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-29 05:34:48.955 ,vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-29 05:34:48.967 ,vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-29 05:34:48.978 ,vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-29 05:34:48.987 ,nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:49.003 ,nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:49.012 ,bt_default_cset_implicit_coll blob sub_type text
2025-06-29 05:34:49.019 ,bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:49.029 ,bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-29 05:34:49.041 ,bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:49.052 ,blob_binary blob sub_type binary
2025-06-29 05:34:49.058 )
2025-06-29 05:34:49.064 ^
2025-06-29 05:34:49.071 ------------------------------------------------------------------------------------------------------------------
2025-06-29 05:34:49.078 create procedure sp_test(
2025-06-29 05:34:49.085 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-29 05:34:49.092 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-29 05:34:49.104 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-29 05:34:49.114 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-29 05:34:49.123 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:49.132 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:49.139 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-29 05:34:49.145 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:49.152 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-29 05:34:49.159 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:49.165 ,a_blob_binary blob sub_type binary
2025-06-29 05:34:49.172 ) returns (
2025-06-29 05:34:49.178 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-29 05:34:49.186 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-29 05:34:49.194 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-29 05:34:49.205 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-29 05:34:49.213 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:49.223 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:49.235 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-29 05:34:49.246 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:49.255 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-29 05:34:49.264 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:49.278 ,o_blob_binary blob sub_type binary
2025-06-29 05:34:49.288 )
2025-06-29 05:34:49.296 as
2025-06-29 05:34:49.304 begin
2025-06-29 05:34:49.310 end
2025-06-29 05:34:49.317 ^
2025-06-29 05:34:49.323 ------------------------------------------------------------------------------------------------------------------
2025-06-29 05:34:49.337 create function fn_test(
2025-06-29 05:34:49.348 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-29 05:34:49.360 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-29 05:34:49.373 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-29 05:34:49.385 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-29 05:34:49.399 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:49.409 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:49.417 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-29 05:34:49.424 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:49.431 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-29 05:34:49.438 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:49.445 ,a_blob_binary blob sub_type binary
2025-06-29 05:34:49.452 ) returns dm_vc_default_cset_explicit_coll collate unicode_ci_ai as
2025-06-29 05:34:49.462 begin
2025-06-29 05:34:49.472 return 1;
2025-06-29 05:34:49.481 end
2025-06-29 05:34:49.495 ^
2025-06-29 05:34:49.503 ------------------------------------------------------------------------------------------------------------------
2025-06-29 05:34:49.512 create package pg_test as
2025-06-29 05:34:49.519 begin
2025-06-29 05:34:49.526 procedure pg_sp (
2025-06-29 05:34:49.533 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-29 05:34:49.539 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-29 05:34:49.545 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-29 05:34:49.550 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-29 05:34:49.556 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:49.561 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:49.566 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-29 05:34:49.572 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:49.578 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-29 05:34:49.583 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:49.588 ,a_blob_binary blob sub_type binary
2025-06-29 05:34:49.593 ) returns (
2025-06-29 05:34:49.598 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-29 05:34:49.603 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-29 05:34:49.608 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-29 05:34:49.614 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-29 05:34:49.619 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:49.624 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:49.629 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-29 05:34:49.634 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:49.639 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-29 05:34:49.645 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:49.650 ,o_blob_binary blob sub_type binary
2025-06-29 05:34:49.655 );
2025-06-29 05:34:49.660 end
2025-06-29 05:34:49.665 ^
2025-06-29 05:34:49.670 create package body pg_test as
2025-06-29 05:34:49.675 begin
2025-06-29 05:34:49.681 procedure pg_sp (
2025-06-29 05:34:49.687 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-29 05:34:49.692 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-29 05:34:49.698 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-29 05:34:49.704 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-29 05:34:49.710 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:49.720 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:49.731 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-29 05:34:49.740 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:49.749 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-29 05:34:49.757 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:49.763 ,a_blob_binary blob sub_type binary
2025-06-29 05:34:49.769 ) returns (
2025-06-29 05:34:49.776 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-29 05:34:49.783 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-29 05:34:49.790 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-29 05:34:49.797 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-29 05:34:49.803 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-29 05:34:49.810 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-29 05:34:49.816 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-29 05:34:49.822 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-29 05:34:49.828 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-29 05:34:49.838 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-29 05:34:49.848 ,o_blob_binary blob sub_type binary
2025-06-29 05:34:49.856 ) as
2025-06-29 05:34:49.863 begin
2025-06-29 05:34:49.871 end
2025-06-29 05:34:49.883 end
2025-06-29 05:34:49.891 ^
2025-06-29 05:34:49.898 commit
2025-06-29 05:34:49.909 ^
2025-06-29 05:34:49.917 --#####################################################################################
2025-06-29 05:34:49.926 show domain dm_vc_default_cset_explicit_coll
2025-06-29 05:34:49.936 ^
2025-06-29 05:34:49.946 show domain dm_vc_default_cset_implicit_coll
2025-06-29 05:34:49.955 ^
2025-06-29 05:34:49.968 show domain dm_vc_nondef_cset_implicit_coll
2025-06-29 05:34:49.978 ^
2025-06-29 05:34:49.992 show domain dm_vc_nondef_cset_explicit_coll
2025-06-29 05:34:50.004 ^
2025-06-29 05:34:50.016 show table test
2025-06-29 05:34:50.030 ^
2025-06-29 05:34:50.039 show procedure sp_test
2025-06-29 05:34:50.052 ^
2025-06-29 05:34:50.061 show function fn_test
2025-06-29 05:34:50.073 ^
2025-06-29 05:34:50.083 show package pg_test
2025-06-29 05:34:50.091 ^
2025-06-29 05:34:50.097 """
2025-06-29 05:34:50.102
2025-06-29 05:34:50.107 isql_show_expected_stdout = """
2025-06-29 05:34:50.113 DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-29 05:34:50.119 DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-29 05:34:50.125 DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-29 05:34:50.130 DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-29 05:34:50.136 VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-29 05:34:50.142 VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-29 05:34:50.154 VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-29 05:34:50.166 VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-29 05:34:50.180 NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
2025-06-29 05:34:50.192 NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
2025-06-29 05:34:50.200 BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-29 05:34:50.208 BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-29 05:34:50.215 BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
2025-06-29 05:34:50.225 BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-29 05:34:50.236 BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
2025-06-29 05:34:50.248 A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:50.260 A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:50.273 A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-29 05:34:50.285 A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:50.293 A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-29 05:34:50.298 A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-29 05:34:50.303 A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:50.309 A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:50.314 A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-29 05:34:50.319 A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:50.325 A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-29 05:34:50.331 O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:50.338 O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:50.345 O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-29 05:34:50.356 O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:50.367 O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-29 05:34:50.375 O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-29 05:34:50.383 O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:50.390 O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:50.399 O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
2025-06-29 05:34:50.409 O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:50.416 O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
2025-06-29 05:34:50.424 OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
2025-06-29 05:34:50.430 A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:50.442 A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:50.450 A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-29 05:34:50.457 A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:50.464 A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-29 05:34:50.470 A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-29 05:34:50.477 A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:50.484 A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:50.491 A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-29 05:34:50.498 A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:50.508 A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-29 05:34:50.520 """
2025-06-29 05:34:50.530
2025-06-29 05:34:50.538 act.expected_stdout = isql_show_expected_stdout
2025-06-29 05:34:50.548 act.isql(input = test_sql, combine_output = True)
2025-06-29 05:34:50.561 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-29 05:34:50.570 E assert
2025-06-29 05:34:50.578 E - DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-29 05:34:50.588 E + PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-29 05:34:50.610 E - DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-29 05:34:50.619 E + PUBLIC.DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-29 05:34:50.645 E - DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-29 05:34:50.653 E + PUBLIC.DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-29 05:34:50.670 E - DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-29 05:34:50.681 E + PUBLIC.DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-29 05:34:50.699 E - VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-29 05:34:50.707 E + VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-29 05:34:50.727 E - VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-29 05:34:50.734 E + VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-29 05:34:50.748 E - VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-29 05:34:50.755 E + VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-29 05:34:50.769 E - VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-29 05:34:50.776 E + VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-29 05:34:50.789 E - NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
2025-06-29 05:34:50.795 E + NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 Nullable
2025-06-29 05:34:50.808 E - NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
2025-06-29 05:34:50.814 E + NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR Nullable
2025-06-29 05:34:50.834 E - BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-29 05:34:50.843 E + BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-29 05:34:50.858 E - BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-29 05:34:50.869 E + BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-29 05:34:50.886 E - BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
2025-06-29 05:34:50.895 E + BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-29 05:34:50.909 E - BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-29 05:34:50.916 E + BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-29 05:34:50.928 E BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
2025-06-29 05:34:50.935 E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:50.943 E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-29 05:34:50.963 E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:50.971 E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-29 05:34:50.985 E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-29 05:34:50.991 E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-29 05:34:51.004 E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:51.011 E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-29 05:34:51.025 E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-29 05:34:51.031 E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-29 05:34:51.048 E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-29 05:34:51.059 E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-29 05:34:51.082 E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:51.094 E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-29 05:34:51.114 E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:51.123 E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-29 05:34:51.138 E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-29 05:34:51.151 E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-29 05:34:51.167 E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:51.174 E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-29 05:34:51.192 E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-29 05:34:51.200 E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-29 05:34:51.215 E - O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:51.222 E + O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-29 05:34:51.235 E - O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:51.242 E + O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-29 05:34:51.262 E - O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-29 05:34:51.272 E + O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-29 05:34:51.288 E - O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:51.295 E + O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-29 05:34:51.308 E - O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-29 05:34:51.318 E + O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-29 05:34:51.337 E - O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-29 05:34:51.344 E + O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-29 05:34:51.359 E - O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:51.366 E + O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-29 05:34:51.384 E - O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:51.392 E + O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-29 05:34:51.408 E - O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
2025-06-29 05:34:51.416 E + O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-29 05:34:51.432 E - O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:51.439 E + O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-29 05:34:51.452 E - O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
2025-06-29 05:34:51.459 E + O_BLOB_BINARY OUTPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-29 05:34:51.479 E - OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
2025-06-29 05:34:51.488 E + OUTPUT (PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI_AI
2025-06-29 05:34:51.502 E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:51.510 E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-29 05:34:51.525 E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:51.537 E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-29 05:34:51.557 E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-29 05:34:51.568 E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-29 05:34:51.593 E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:51.602 E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-29 05:34:51.617 E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-29 05:34:51.624 E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-29 05:34:51.636 E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-29 05:34:51.644 E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-29 05:34:51.657 E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-29 05:34:51.663 E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-29 05:34:51.693 E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-29 05:34:51.703 E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-29 05:34:51.720 E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-29 05:34:51.727 E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-29 05:34:51.741 E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-29 05:34:51.748 E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-29 05:34:51.772 E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-29 05:34:51.780 E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-29 05:34:51.806
2025-06-29 05:34:51.816 tests/bugs/gh_7749_test.py:264: AssertionError
2025-06-29 05:34:51.824 ---------------------------- Captured stdout setup -----------------------------
2025-06-29 05:34:51.846 Creating db: localhost:/var/tmp/qa_2024/test_11617/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
|