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-30 05:40:44.635
2025-06-30 05:40:44.642 act = <firebird.qa.plugin.Action object at [hex]>
2025-06-30 05:40:44.651 capsys = <_pytest.capture.CaptureFixture object at [hex]>
2025-06-30 05:40:44.658
2025-06-30 05:40:44.665 @pytest.mark.version('>=6.0')
2025-06-30 05:40:44.673 def test_1(act: Action, capsys):
2025-06-30 05:40:44.680
2025-06-30 05:40:44.687 # test N1: check output of SHOW commands:
2025-06-30 05:40:44.694 # --------
2025-06-30 05:40:44.701 test_sql = """
2025-06-30 05:40:44.708 set bail on;
2025-06-30 05:40:44.715
2025-06-30 05:40:44.723 ALTER CHARACTER SET UTF8 SET DEFAULT COLLATION unicode_ci;
2025-06-30 05:40:44.730 COMMIT;
2025-06-30 05:40:44.736
2025-06-30 05:40:44.743 set term ^;
2025-06-30 05:40:44.750
2025-06-30 05:40:44.757 create domain dm_vc_default_cset_implicit_coll as varchar(10)
2025-06-30 05:40:44.763 ^
2025-06-30 05:40:44.771 create domain dm_vc_default_cset_explicit_coll varchar(10) collate utf8
2025-06-30 05:40:44.785 ^
2025-06-30 05:40:44.794 create domain dm_vc_nondef_cset_implicit_coll as varchar(10) character set win1251
2025-06-30 05:40:44.806 ^
2025-06-30 05:40:44.820 create domain dm_vc_nondef_cset_explicit_coll as varchar(10) character set win1251 collate pxw_cyrl
2025-06-30 05:40:44.834 ^
2025-06-30 05:40:44.844 create domain dm_nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:44.853 ^
2025-06-30 05:40:44.860 create domain dm_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:44.865 ^
2025-06-30 05:40:44.870 create domain dm_bt_default_cset_implicit_coll as blob sub_type text
2025-06-30 05:40:44.879 ^
2025-06-30 05:40:44.886 create domain dm_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:44.894 ^
2025-06-30 05:40:44.901 create domain dm_bt_nondef_cset_implicit_coll as blob sub_type text character set win1251
2025-06-30 05:40:44.908 ^
2025-06-30 05:40:44.914 create domain dm_bt_nondef_cset_explicit_coll as blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:44.921 ^
2025-06-30 05:40:44.927 create domain dm_blob_binary blob sub_type binary
2025-06-30 05:40:44.934 ^
2025-06-30 05:40:44.943
2025-06-30 05:40:44.951 ------------------------------------------------------------------------------------------------------------------
2025-06-30 05:40:44.964 recreate table test (
2025-06-30 05:40:44.975 vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-30 05:40:44.983 ,vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-30 05:40:44.992 ,vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-30 05:40:45.000 ,vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-30 05:40:45.007 ,nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:45.015 ,nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:45.023 ,bt_default_cset_implicit_coll blob sub_type text
2025-06-30 05:40:45.031 ,bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:45.040 ,bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-30 05:40:45.048 ,bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:45.056 ,blob_binary blob sub_type binary
2025-06-30 05:40:45.063 )
2025-06-30 05:40:45.070 ^
2025-06-30 05:40:45.083 ------------------------------------------------------------------------------------------------------------------
2025-06-30 05:40:45.095 create procedure sp_test(
2025-06-30 05:40:45.104 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-30 05:40:45.112 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-30 05:40:45.123 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-30 05:40:45.130 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-30 05:40:45.137 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:45.145 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:45.154 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-30 05:40:45.166 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:45.175 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-30 05:40:45.183 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:45.189 ,a_blob_binary blob sub_type binary
2025-06-30 05:40:45.194 ) returns (
2025-06-30 05:40:45.201 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-30 05:40:45.214 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-30 05:40:45.226 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-30 05:40:45.237 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-30 05:40:45.248 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:45.257 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:45.266 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-30 05:40:45.279 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:45.290 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-30 05:40:45.299 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:45.306 ,o_blob_binary blob sub_type binary
2025-06-30 05:40:45.314 )
2025-06-30 05:40:45.323 as
2025-06-30 05:40:45.331 begin
2025-06-30 05:40:45.339 end
2025-06-30 05:40:45.347 ^
2025-06-30 05:40:45.355 ------------------------------------------------------------------------------------------------------------------
2025-06-30 05:40:45.362 create function fn_test(
2025-06-30 05:40:45.371 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-30 05:40:45.379 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-30 05:40:45.388 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-30 05:40:45.396 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-30 05:40:45.411 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:45.423 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:45.430 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-30 05:40:45.438 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:45.444 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-30 05:40:45.451 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:45.457 ,a_blob_binary blob sub_type binary
2025-06-30 05:40:45.464 ) returns dm_vc_default_cset_explicit_coll collate unicode_ci_ai as
2025-06-30 05:40:45.473 begin
2025-06-30 05:40:45.482 return 1;
2025-06-30 05:40:45.489 end
2025-06-30 05:40:45.496 ^
2025-06-30 05:40:45.503 ------------------------------------------------------------------------------------------------------------------
2025-06-30 05:40:45.510 create package pg_test as
2025-06-30 05:40:45.518 begin
2025-06-30 05:40:45.525 procedure pg_sp (
2025-06-30 05:40:45.530 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-30 05:40:45.536 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-30 05:40:45.543 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-30 05:40:45.556 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-30 05:40:45.570 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:45.581 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:45.590 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-30 05:40:45.597 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:45.604 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-30 05:40:45.608 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:45.613 ,a_blob_binary blob sub_type binary
2025-06-30 05:40:45.618 ) returns (
2025-06-30 05:40:45.623 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-30 05:40:45.628 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-30 05:40:45.633 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-30 05:40:45.639 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-30 05:40:45.646 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:45.655 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:45.661 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-30 05:40:45.668 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:45.674 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-30 05:40:45.683 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:45.696 ,o_blob_binary blob sub_type binary
2025-06-30 05:40:45.706 );
2025-06-30 05:40:45.717 end
2025-06-30 05:40:45.727 ^
2025-06-30 05:40:45.735 create package body pg_test as
2025-06-30 05:40:45.742 begin
2025-06-30 05:40:45.749 procedure pg_sp (
2025-06-30 05:40:45.763 a_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-30 05:40:45.775 ,a_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-30 05:40:45.785 ,a_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-30 05:40:45.796 ,a_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-30 05:40:45.809 ,a_nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:45.823 ,a_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:45.834 ,a_bt_default_cset_implicit_coll blob sub_type text
2025-06-30 05:40:45.844 ,a_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:45.851 ,a_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-30 05:40:45.858 ,a_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:45.864 ,a_blob_binary blob sub_type binary
2025-06-30 05:40:45.870 ) returns (
2025-06-30 05:40:45.878 o_vc_default_cset_implicit_coll varchar(10) -- default charset, default collation
2025-06-30 05:40:45.885 ,o_vc_default_cset_explicit_coll varchar(10) collate utf8 -- default charset, non-default collation
2025-06-30 05:40:45.892 ,o_vc_nondef_cset_implicit_coll varchar(10) character set win1251 -- non-default charset, default collation
2025-06-30 05:40:45.901 ,o_vc_nondef_cset_explicit_coll varchar(10) character set win1251 collate pxw_cyrl -- non-default charset, non-default collation
2025-06-30 05:40:45.915 ,o_nc_fixed_char_implicit_coll nchar(10)
2025-06-30 05:40:45.928 ,o_nc_fixed_char_explicit_coll nchar(10) collate fr_fr
2025-06-30 05:40:45.939 ,o_bt_default_cset_implicit_coll blob sub_type text
2025-06-30 05:40:45.948 ,o_bt_default_cset_explicit_coll blob sub_type text collate utf8
2025-06-30 05:40:45.956 ,o_bt_nondef_cset_implicit_coll blob sub_type text character set win1251
2025-06-30 05:40:45.964 ,o_bt_nondef_cset_explicit_coll blob sub_type text character set win1251 collate pxw_cyrl
2025-06-30 05:40:45.971 ,o_blob_binary blob sub_type binary
2025-06-30 05:40:45.979 ) as
2025-06-30 05:40:45.991 begin
2025-06-30 05:40:46.001 end
2025-06-30 05:40:46.009 end
2025-06-30 05:40:46.022 ^
2025-06-30 05:40:46.034 commit
2025-06-30 05:40:46.044 ^
2025-06-30 05:40:46.051 --#####################################################################################
2025-06-30 05:40:46.059 show domain dm_vc_default_cset_explicit_coll
2025-06-30 05:40:46.067 ^
2025-06-30 05:40:46.080 show domain dm_vc_default_cset_implicit_coll
2025-06-30 05:40:46.090 ^
2025-06-30 05:40:46.099 show domain dm_vc_nondef_cset_implicit_coll
2025-06-30 05:40:46.107 ^
2025-06-30 05:40:46.115 show domain dm_vc_nondef_cset_explicit_coll
2025-06-30 05:40:46.127 ^
2025-06-30 05:40:46.136 show table test
2025-06-30 05:40:46.143 ^
2025-06-30 05:40:46.151 show procedure sp_test
2025-06-30 05:40:46.157 ^
2025-06-30 05:40:46.165 show function fn_test
2025-06-30 05:40:46.172 ^
2025-06-30 05:40:46.180 show package pg_test
2025-06-30 05:40:46.186 ^
2025-06-30 05:40:46.194 """
2025-06-30 05:40:46.206
2025-06-30 05:40:46.217 isql_show_expected_stdout = """
2025-06-30 05:40:46.231 DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-30 05:40:46.242 DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-30 05:40:46.250 DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-30 05:40:46.260 DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-30 05:40:46.272 VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-30 05:40:46.282 VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-30 05:40:46.293 VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-30 05:40:46.300 VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-30 05:40:46.306 NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
2025-06-30 05:40:46.315 NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
2025-06-30 05:40:46.326 BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-30 05:40:46.339 BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-30 05:40:46.350 BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
2025-06-30 05:40:46.360 BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-30 05:40:46.369 BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
2025-06-30 05:40:46.377 A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:46.384 A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:46.398 A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-30 05:40:46.409 A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:46.415 A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-30 05:40:46.423 A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-30 05:40:46.431 A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:46.437 A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:46.444 A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-30 05:40:46.456 A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:46.467 A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-30 05:40:46.474 O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:46.480 O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:46.487 O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-30 05:40:46.498 O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:46.508 O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-30 05:40:46.522 O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-30 05:40:46.532 O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:46.546 O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:46.554 O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
2025-06-30 05:40:46.563 O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:46.570 O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
2025-06-30 05:40:46.579 OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
2025-06-30 05:40:46.592 A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:46.603 A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:46.612 A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-30 05:40:46.626 A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:46.637 A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-30 05:40:46.647 A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-30 05:40:46.655 A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:46.663 A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:46.670 A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-30 05:40:46.682 A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:46.696 A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-30 05:40:46.708 """
2025-06-30 05:40:46.717
2025-06-30 05:40:46.725 act.expected_stdout = isql_show_expected_stdout
2025-06-30 05:40:46.731 act.isql(input = test_sql, combine_output = True)
2025-06-30 05:40:46.740 > assert act.clean_stdout == act.clean_expected_stdout
2025-06-30 05:40:46.753 E assert
2025-06-30 05:40:46.767 E - DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-30 05:40:46.779 E + PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-30 05:40:46.801 E - DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-30 05:40:46.818 E + PUBLIC.DM_VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-30 05:40:46.842 E - DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-30 05:40:46.852 E + PUBLIC.DM_VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-30 05:40:46.866 E - DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-30 05:40:46.875 E + PUBLIC.DM_VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-30 05:40:46.896 E - VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-30 05:40:46.904 E + VC_DEFAULT_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-30 05:40:46.918 E - VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-30 05:40:46.925 E + VC_DEFAULT_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-30 05:40:46.940 E - VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 Nullable
2025-06-30 05:40:46.947 E + VC_NONDEF_CSET_IMPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-30 05:40:46.961 E - VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-30 05:40:46.967 E + VC_NONDEF_CSET_EXPLICIT_COLL VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-30 05:40:46.981 E - NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 Nullable
2025-06-30 05:40:46.990 E + NC_FIXED_CHAR_IMPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 Nullable
2025-06-30 05:40:47.008 E - NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR Nullable
2025-06-30 05:40:47.024 E + NC_FIXED_CHAR_EXPLICIT_COLL CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR Nullable
2025-06-30 05:40:47.050 E - BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UNICODE_CI Nullable
2025-06-30 05:40:47.065 E + BT_DEFAULT_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI Nullable
2025-06-30 05:40:47.092 E - BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET UTF8 COLLATE UTF8 Nullable
2025-06-30 05:40:47.100 E + BT_DEFAULT_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8 Nullable
2025-06-30 05:40:47.115 E - BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 Nullable
2025-06-30 05:40:47.128 E + BT_NONDEF_CSET_IMPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 Nullable
2025-06-30 05:40:47.146 E - BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET WIN1251 COLLATE PXW_CYRL Nullable
2025-06-30 05:40:47.154 E + BT_NONDEF_CSET_EXPLICIT_COLL BLOB segment 80, subtype TEXT CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL Nullable
2025-06-30 05:40:47.167 E BLOB_BINARY BLOB segment 80, subtype BINARY Nullable
2025-06-30 05:40:47.175 E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:47.187 E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-30 05:40:47.205 E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:47.212 E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-30 05:40:47.227 E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-30 05:40:47.235 E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-30 05:40:47.250 E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:47.258 E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-30 05:40:47.275 E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-30 05:40:47.283 E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-30 05:40:47.298 E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-30 05:40:47.310 E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-30 05:40:47.337 E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:47.347 E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-30 05:40:47.360 E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:47.366 E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-30 05:40:47.380 E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-30 05:40:47.389 E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-30 05:40:47.402 E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:47.408 E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-30 05:40:47.424 E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-30 05:40:47.433 E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-30 05:40:47.451 E - O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:47.463 E + O_VC_DEFAULT_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-30 05:40:47.484 E - O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:47.491 E + O_VC_DEFAULT_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-30 05:40:47.511 E - O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-30 05:40:47.521 E + O_VC_NONDEF_CSET_IMPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-30 05:40:47.534 E - O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:47.540 E + O_VC_NONDEF_CSET_EXPLICIT_COLL OUTPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-30 05:40:47.550 E - O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-30 05:40:47.555 E + O_NC_FIXED_CHAR_IMPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-30 05:40:47.577 E - O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-30 05:40:47.591 E + O_NC_FIXED_CHAR_EXPLICIT_COLL OUTPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-30 05:40:47.618 E - O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:47.629 E + O_BT_DEFAULT_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-30 05:40:47.653 E - O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:47.666 E + O_BT_DEFAULT_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-30 05:40:47.684 E - O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251
2025-06-30 05:40:47.690 E + O_BT_NONDEF_CSET_IMPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-30 05:40:47.705 E - O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:47.713 E + O_BT_NONDEF_CSET_EXPLICIT_COLL OUTPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-30 05:40:47.731 E - O_BLOB_BINARY OUTPUT BLOB CHARACTER SET NONE
2025-06-30 05:40:47.740 E + O_BLOB_BINARY OUTPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-30 05:40:47.755 E - OUTPUT (DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI_AI
2025-06-30 05:40:47.763 E + OUTPUT (PUBLIC.DM_VC_DEFAULT_CSET_EXPLICIT_COLL) VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI_AI
2025-06-30 05:40:47.786 E - A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:47.797 E + A_VC_DEFAULT_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-30 05:40:47.811 E - A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:47.818 E + A_VC_DEFAULT_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-30 05:40:47.837 E - A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251
2025-06-30 05:40:47.848 E + A_VC_NONDEF_CSET_IMPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251
2025-06-30 05:40:47.872 E - A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:47.882 E + A_VC_NONDEF_CSET_EXPLICIT_COLL INPUT VARCHAR(10) CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-30 05:40:47.908 E - A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1
2025-06-30 05:40:47.917 E + A_NC_FIXED_CHAR_IMPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1
2025-06-30 05:40:47.930 E - A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET ISO8859_1 COLLATE FR_FR
2025-06-30 05:40:47.936 E + A_NC_FIXED_CHAR_EXPLICIT_COLL INPUT CHAR(10) CHARACTER SET SYSTEM.ISO8859_1 COLLATE SYSTEM.FR_FR
2025-06-30 05:40:47.951 E - A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UNICODE_CI
2025-06-30 05:40:47.958 E + A_BT_DEFAULT_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UNICODE_CI
2025-06-30 05:40:47.980 E - A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET UTF8 COLLATE UTF8
2025-06-30 05:40:47.992 E + A_BT_DEFAULT_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.UTF8 COLLATE SYSTEM.UTF8
2025-06-30 05:40:48.020 E - A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251
2025-06-30 05:40:48.034 E + A_BT_NONDEF_CSET_IMPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251
2025-06-30 05:40:48.059 E - A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET WIN1251 COLLATE PXW_CYRL
2025-06-30 05:40:48.067 E + A_BT_NONDEF_CSET_EXPLICIT_COLL INPUT BLOB CHARACTER SET SYSTEM.WIN1251 COLLATE SYSTEM.PXW_CYRL
2025-06-30 05:40:48.084 E - A_BLOB_BINARY INPUT BLOB CHARACTER SET NONE
2025-06-30 05:40:48.096 E + A_BLOB_BINARY INPUT BLOB CHARACTER SET SYSTEM.NONE
2025-06-30 05:40:48.112
2025-06-30 05:40:48.118 tests/bugs/gh_7749_test.py:264: AssertionError
2025-06-30 05:40:48.123 ---------------------------- Captured stdout setup -----------------------------
2025-06-30 05:40:48.130 Creating db: localhost:/var/tmp/qa_2024/test_11620/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
|