Result of boolean expression can not be concatenated with string literal [CORE5408] #5681
Assignees
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Alpha 1 [ 10731 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
|
Commented by: @mrotteveel From the perspective of the SQL standard, concatenation of types other than a string type would require an explicit cast, because the concatenation operator is only defined between strings (and between arrays). |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @pavel-zotov
SQL> select true || 'aaa' from rdb$database;
CONCATENATION
TRUEaaa
(OK, expected)
SQL> select (true = true)|| 'aaa' from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 21
-||
SQL> select (true is true)|| 'aaa' from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 22
-||
SQL> select 'aaa' || true from rdb$database;
CONCATENATION
aaaTRUE
(OK, expected; note that here order of boolean and string is changed comparing with sample #1)
SQL> select 'aaa' || (true = true) from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 23
-=
SQL> select 'aaa' || (true is true) from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 23
-is
Commits: 5f6d20c 64fa7dc
The text was updated successfully, but these errors were encountered: