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-07-02 05:56:20.278
2025-07-02 05:56:20.284 act = <firebird.qa.plugin.Action object at [hex]>
2025-07-02 05:56:20.291 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-07-02 05:56:20.297
2025-07-02 05:56:20.309 @pytest.mark.version('>=6.0')
2025-07-02 05:56:20.319 def test_1(act: Action, capsys):
2025-07-02 05:56:20.325
2025-07-02 05:56:20.331 # test N1: check output of SHOW commands:
2025-07-02 05:56:20.337 # --------
2025-07-02 05:56:20.343 test_sql = """
2025-07-02 05:56:20.349 set bail on;
2025-07-02 05:56:20.355
2025-07-02 05:56:20.360 ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION unicode_ci;
2025-07-02 05:56:20.366 COMMIT;
2025-07-02 05:56:20.372
2025-07-02 05:56:20.379 set term ^;
2025-07-02 05:56:20.386
2025-07-02 05:56:20.395 create domain dm_vc_default_cset_implicit_coll as varchar(10)
2025-07-02 05:56:20.403 ^
2025-07-02 05:56:20.415 create domain dm_vc_default_cset_explicit_coll varchar(10) collate utf8
2025-07-02 05:56:20.424 ^
2025-07-02 05:56:20.431 create domain dm_vc_nondef_cset_implicit_coll as varchar(10) character set win1251
2025-07-02 05:56:20.437 ^
2025-07-02 05:56:20.443 create domain dm_vc_nondef_cset_explicit_coll as varchar(10) character set win1251 collate pxw_cyrl
2025-07-02 05:56:20.449 ^
2025-07-02 05:56:20.461 create domain dm_nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:20.473 ^
2025-07-02 05:56:20.486 create domain dm_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:20.496 ^
2025-07-02 05:56:20.504 create domain dm_bt_default_cset_implicit_coll as blob sub_type text
2025-07-02 05:56:20.511 ^
2025-07-02 05:56:20.518 create domain dm_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:20.528 ^
2025-07-02 05:56:20.537 create domain dm_bt_nondef_cset_implicit_coll as blob sub_type text character set win1251
2025-07-02 05:56:20.544 ^
2025-07-02 05:56:20.554 create domain dm_bt_nondef_cset_explicit_coll as blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:20.567 ^
2025-07-02 05:56:20.580 create domain dm_blob_binary blob sub_type binary
2025-07-02 05:56:20.593 ^
2025-07-02 05:56:20.604
2025-07-02 05:56:20.617 ------------------------------------------------------------------------------------------------------------------
2025-07-02 05:56:20.626 recreate table test (
2025-07-02 05:56:20.631 vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-07-02 05:56:20.637 ,vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-07-02 05:56:20.642 ,vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-07-02 05:56:20.647 ,vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-07-02 05:56:20.652 ,nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:20.657 ,nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:20.661 ,bt_default_cset_implicit_coll blob sub_type text
2025-07-02 05:56:20.666 ,bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:20.671 ,bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-07-02 05:56:20.675 ,bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:20.680 ,blob_binary blob sub_type binary
2025-07-02 05:56:20.684 )
2025-07-02 05:56:20.689 ^
2025-07-02 05:56:20.693 ------------------------------------------------------------------------------------------------------------------
2025-07-02 05:56:20.698 create procedure sp_test(
2025-07-02 05:56:20.702 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-07-02 05:56:20.707 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-07-02 05:56:20.712 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-07-02 05:56:20.717 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-07-02 05:56:20.721 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:20.726 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:20.730 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-07-02 05:56:20.735 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:20.739 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-07-02 05:56:20.744 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:20.749 ,a_blob_binary blob sub_type binary
2025-07-02 05:56:20.753 ) returns (
2025-07-02 05:56:20.758 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-07-02 05:56:20.762 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-07-02 05:56:20.767 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-07-02 05:56:20.772 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-07-02 05:56:20.776 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:20.781 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:20.786 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-07-02 05:56:20.790 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:20.795 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-07-02 05:56:20.803 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:20.809 ,o_blob_binary blob sub_type binary
2025-07-02 05:56:20.816 )
2025-07-02 05:56:20.823 as
2025-07-02 05:56:20.832 begin
2025-07-02 05:56:20.843 end
2025-07-02 05:56:20.851 ^
2025-07-02 05:56:20.859 ------------------------------------------------------------------------------------------------------------------
2025-07-02 05:56:20.866 create function fn_test(
2025-07-02 05:56:20.878 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-07-02 05:56:20.886 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-07-02 05:56:20.895 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-07-02 05:56:20.903 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-07-02 05:56:20.911 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:20.917 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:20.923 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-07-02 05:56:20.931 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:20.946 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-07-02 05:56:20.958 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:20.967 ,a_blob_binary blob sub_type binary
2025-07-02 05:56:20.975 ) returns dm_vc_default_cset_explicit_coll collate unicode_ci_ai as
2025-07-02 05:56:20.988 begin
2025-07-02 05:56:20.997 return 1;
2025-07-02 05:56:21.008 end
2025-07-02 05:56:21.017 ^
2025-07-02 05:56:21.024 ------------------------------------------------------------------------------------------------------------------
2025-07-02 05:56:21.031 create package pg_test as
2025-07-02 05:56:21.035 begin
2025-07-02 05:56:21.040 procedure pg_sp (
2025-07-02 05:56:21.046 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-07-02 05:56:21.053 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-07-02 05:56:21.064 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-07-02 05:56:21.073 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-07-02 05:56:21.087 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:21.098 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:21.107 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-07-02 05:56:21.115 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:21.124 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-07-02 05:56:21.130 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:21.136 ,a_blob_binary blob sub_type binary
2025-07-02 05:56:21.142 ) returns (
2025-07-02 05:56:21.153 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-07-02 05:56:21.161 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-07-02 05:56:21.169 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-07-02 05:56:21.175 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-07-02 05:56:21.181 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:21.187 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:21.193 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-07-02 05:56:21.199 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:21.204 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-07-02 05:56:21.209 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:21.214 ,o_blob_binary blob sub_type binary
2025-07-02 05:56:21.219 );
2025-07-02 05:56:21.225 end
2025-07-02 05:56:21.237 ^
2025-07-02 05:56:21.248 create package body pg_test as
2025-07-02 05:56:21.260 begin
2025-07-02 05:56:21.270 procedure pg_sp (
2025-07-02 05:56:21.278 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-07-02 05:56:21.287 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-07-02 05:56:21.295 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-07-02 05:56:21.301 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-07-02 05:56:21.307 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:21.314 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:21.320 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-07-02 05:56:21.326 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:21.333 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-07-02 05:56:21.339 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:21.345 ,a_blob_binary blob sub_type binary
2025-07-02 05:56:21.351 ) returns (
2025-07-02 05:56:21.359 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-07-02 05:56:21.372 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-07-02 05:56:21.384 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-07-02 05:56:21.393 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-07-02 05:56:21.405 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-07-02 05:56:21.416 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-07-02 05:56:21.429 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-07-02 05:56:21.441 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-07-02 05:56:21.451 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-07-02 05:56:21.460 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-07-02 05:56:21.472 ,o_blob_binary blob sub_type binary
2025-07-02 05:56:21.482 ) as
2025-07-02 05:56:21.490 begin
2025-07-02 05:56:21.503 end
2025-07-02 05:56:21.513 end
2025-07-02 05:56:21.521 ^
2025-07-02 05:56:21.528 commit
2025-07-02 05:56:21.535 ^
2025-07-02 05:56:21.543 --#####################################################################################
2025-07-02 05:56:21.551 show domain dm_vc_default_cset_explicit_coll
2025-07-02 05:56:21.564 ^
2025-07-02 05:56:21.575 show domain dm_vc_default_cset_implicit_coll
2025-07-02 05:56:21.586 ^
2025-07-02 05:56:21.598 show domain dm_vc_nondef_cset_implicit_coll
2025-07-02 05:56:21.610 ^
2025-07-02 05:56:21.620 show domain dm_vc_nondef_cset_explicit_coll
2025-07-02 05:56:21.628 ^
2025-07-02 05:56:21.635 show table test
2025-07-02 05:56:21.642 ^
2025-07-02 05:56:21.654 show procedure sp_test
2025-07-02 05:56:21.666 ^
2025-07-02 05:56:21.678 show function fn_test
2025-07-02 05:56:21.688 ^
2025-07-02 05:56:21.698 show package pg_test
2025-07-02 05:56:21.705 ^
2025-07-02 05:56:21.711 """
2025-07-02 05:56:21.717
2025-07-02 05:56:21.723 isql_show_expected_stdout = """
2025-07-02 05:56:21.732 DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-07-02 05:56:21.743 DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-07-02 05:56:21.752 DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-07-02 05:56:21.759 DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-07-02 05:56:21.767 VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-07-02 05:56:21.775 VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-07-02 05:56:21.785 VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-07-02 05:56:21.791 VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-07-02 05:56:21.799 NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
2025-07-02 05:56:21.807 NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
2025-07-02 05:56:21.818 BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-07-02 05:56:21.830 BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-07-02 05:56:21.840 BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
2025-07-02 05:56:21.848 BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-07-02 05:56:21.856 BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
2025-07-02 05:56:21.863 A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:21.873 A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:21.884 A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-07-02 05:56:21.893 A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:21.900 A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-07-02 05:56:21.908 A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-07-02 05:56:21.915 A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:21.921 A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:21.929 A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-07-02 05:56:21.939 A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:21.952 A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-07-02 05:56:21.962 O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:21.970 O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:21.980 O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
2025-07-02 05:56:21.993 O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:22.005 O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
2025-07-02 05:56:22.019 O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-07-02 05:56:22.030 O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:22.044 O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:22.057 O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
2025-07-02 05:56:22.069 O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:22.083 O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
2025-07-02 05:56:22.094 OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
2025-07-02 05:56:22.102 A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:22.110 A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:22.119 A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-07-02 05:56:22.129 A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:22.135 A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-07-02 05:56:22.141 A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-07-02 05:56:22.146 A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:22.152 A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:22.157 A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-07-02 05:56:22.162 A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:22.166 A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-07-02 05:56:22.171 """
2025-07-02 05:56:22.176
2025-07-02 05:56:22.180 act.expected_stdout = isql_show_expected_stdout
2025-07-02 05:56:22.186 act.isql(input = test_sql, combine_output = True)
2025-07-02 05:56:22.191 > assert act.clean_stdout == act.clean_expected_stdout
2025-07-02 05:56:22.196 E assert
2025-07-02 05:56:22.201 E - DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-07-02 05:56:22.206 E + PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-07-02 05:56:22.216 E - DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-07-02 05:56:22.222 E + PUBLIC.DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-07-02 05:56:22.232 E - DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-07-02 05:56:22.237 E + PUBLIC.DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
2025-07-02 05:56:22.247 E - DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-07-02 05:56:22.252 E + PUBLIC.DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-07-02 05:56:22.262 E - VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-07-02 05:56:22.267 E + VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-07-02 05:56:22.288 E - VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-07-02 05:56:22.299 E + VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-07-02 05:56:22.319 E - VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-07-02 05:56:22.330 E + VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
2025-07-02 05:56:22.356 E - VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-07-02 05:56:22.370 E + VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-07-02 05:56:22.393 E - NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
2025-07-02 05:56:22.400 E + NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 Nullable
2025-07-02 05:56:22.412 E - NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
2025-07-02 05:56:22.419 E + NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR Nullable
2025-07-02 05:56:22.449 E - BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-07-02 05:56:22.461 E + BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-07-02 05:56:22.477 E - BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-07-02 05:56:22.484 E + BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-07-02 05:56:22.495 E - BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
2025-07-02 05:56:22.500 E + BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 Nullable
2025-07-02 05:56:22.517 E - BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-07-02 05:56:22.525 E + BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-07-02 05:56:22.541 E BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
2025-07-02 05:56:22.549 E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:22.556 E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-07-02 05:56:22.570 E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:22.581 E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-07-02 05:56:22.596 E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-07-02 05:56:22.603 E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-07-02 05:56:22.617 E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:22.624 E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-07-02 05:56:22.642 E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-07-02 05:56:22.648 E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-07-02 05:56:22.666 E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-07-02 05:56:22.675 E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-07-02 05:56:22.697 E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:22.708 E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-07-02 05:56:22.733 E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:22.747 E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-07-02 05:56:22.770 E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-07-02 05:56:22.779 E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-07-02 05:56:22.804 E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:22.816 E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-07-02 05:56:22.842 E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-07-02 05:56:22.855 E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
2025-07-02 05:56:22.876 E - O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:22.888 E + O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-07-02 05:56:22.908 E - O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:22.916 E + O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-07-02 05:56:22.930 E - O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
2025-07-02 05:56:22.939 E + O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-07-02 05:56:22.959 E - O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:22.966 E + O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-07-02 05:56:22.986 E - O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
2025-07-02 05:56:22.995 E + O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-07-02 05:56:23.009 E - O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-07-02 05:56:23.016 E + O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-07-02 05:56:23.037 E - O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:23.045 E + O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-07-02 05:56:23.062 E - O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:23.070 E + O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-07-02 05:56:23.085 E - O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
2025-07-02 05:56:23.092 E + O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-07-02 05:56:23.107 E - O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:23.118 E + O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-07-02 05:56:23.135 E - O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
2025-07-02 05:56:23.145 E + O_BLOB_BINARY OUTPUT BLOB CHARACTER SET SYSTEM.NONE
2025-07-02 05:56:23.165 E - OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
2025-07-02 05:56:23.178 E + OUTPUT (PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI_AI
2025-07-02 05:56:23.196 E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:23.202 E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-07-02 05:56:23.225 E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:23.234 E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-07-02 05:56:23.255 E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-07-02 05:56:23.262 E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-07-02 05:56:23.283 E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:23.292 E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-07-02 05:56:23.309 E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-07-02 05:56:23.316 E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-07-02 05:56:23.328 E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-07-02 05:56:23.339 E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-07-02 05:56:23.355 E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-07-02 05:56:23.361 E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-07-02 05:56:23.371 E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-07-02 05:56:23.376 E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-07-02 05:56:23.385 E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-07-02 05:56:23.390 E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-07-02 05:56:23.404 E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-07-02 05:56:23.411 E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-07-02 05:56:23.423 E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-07-02 05:56:23.428 E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
2025-07-02 05:56:23.439
2025-07-02 05:56:23.447 tests/bugs/gh_7749_test.py:264: AssertionError
2025-07-02 05:56:23.459 ---------------------------- Captured stdout setup -----------------------------
2025-07-02 05:56:23.469 Creating db: localhost:/var/tmp/qa_2024/test_11621/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
|