Results of сoncatenation with blob has no info about collation of source
columns (which are declared with such info)
--------------------------------------------------------------------------------------------------------------------
Key: CORE-6532
URL: http://tracker.firebirdsql.org/browse/CORE-6532
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 4.0 RC 1, 3.0.7
Reporter: Pavel Zotov
set bail on;
set list on;
shell del c:\temp\tmp.fdb 2>nul;
create database 'localhost:c:\temp\tmp.fdb';
create collation name_coll for utf8 from unicode case insensitive;
commit;
--create domain dm_name_ci as varchar(10) character set utf8 collate name_coll;
create domain dm_name_ci as blob sub_type text character set utf8 collate
name_coll;
commit;
recreate table test(
id int
,c1 varchar(10) character set utf8 collate name_coll
,b1 dm_name_ci
--,b1 blob sub_type text character set utf8 collate name_coll -- same result
);
insert into test(id, c1, b1) values(1,'qWE','qWE');
insert into test(id, c1, b1) values(2,'QWe','QWe');
insert into test(id, c1, b1) values(3,'qwE','qwE');
commit;
set count on;
set echo on;
---------------------------------------------
select id from test
where
b1 starting with 'qwe' -- Records affected: 3 // OK
;
---------------------------------------------
select id from test
where
b1 || b1 starting with 'qwe' -- Records affected: 0
;
--------------------------------------------
select id from test
where
c1 || cast(c1 as blob sub_type text character set utf8) collate name_coll
starting with 'qwe' -- Records affected: 0
;
---------------------------------------------
set sqlda_display on;
select
b1
,b1 || b1 as "b1 || b1"
,c1 || cast(c1 as blob sub_type text character set utf8) collate name_coll
as "c1 || cast(c1 as blob)"
from test t rows 0;
set sqlda_display off;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
