Issue Details (XML | Word | Printable)

Key: CORE-5341
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Alex Bekhtin
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

User collate doesn't work with blobs

Created: 29/Aug/16 08:14 AM   Updated: 09/Sep/16 07:00 AM
Component/s: Charsets/Collation
Affects Version/s: 4.0 Initial, 3.0.0
Fix Version/s: 3.0.1, 4.0 Alpha 1

QA Status: Done successfully


 Description  « Hide
create collation PXW_CYRL_CI_AI for WIN1251
   from PXW_CYRL
   CASE INSENSITIVE
   ACCENT INSENSITIVE;

with A(val) as(
  select cast('update' as blob sub_type text) from rdb$database
  union all
  select 'UPDATE' from rdb$database
)
select * from A where val collate PXW_CYRL_CI_AI like '%update%'

FB 2.5 - two record
FB 3.0, 4.0 - only one record

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.