COLLATE expressions are applied incorrectly [CORE2913] #3297
Labels
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.0.4
affect-version: 2.0.5
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.5 Alpha 1
affect-version: 2.5 Beta 1
affect-version: 2.5 Beta 2
affect-version: 2.5 RC1
affect-version: 2.5 RC2
affect-version: 3.0 Initial
component: charsets/collation
fix-version: 3.0 Alpha 1
priority: major
qa: done successfully
type: bug
Submitted by: @asfernandes
Is related to QA549
For example, this expression should cast the string in DOS850 to ISO8859_1 and mark it as using ISO8859_1 collation:
select cast(_dos850 'x' as char(1) character set iso8859_1) collate iso8859_1 from rdb$database;
But:
Statement failed, SQLCODE = -204
Dynamic SQL Error
-SQL error code = -204
-Data type unknown
-COLLATION ISO8859_1 for CHARACTER SET DOS850 is not defined
Commits: c4bca14
The text was updated successfully, but these errors were encountered: