Conversion error on CASE using computed column
----------------------------------------------
Key: CORE-6101
URL: http://tracker.firebirdsql.org/browse/CORE-6101
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.4
Environment: Firebird-3.0.4.33054_0_x64
Windows 10 / Windows Server 2016
Reporter: Pavel Cisar
Here is reproducible test:
create table test_table_01 (
id int,
get_temp_i computed by ((cast (64 as int))),
fld2 int
);
commit;
insert into test_table_01 (id, fld2) values (1, 1);
commit;
select * from test_01;
ID GET_TEMP_I FLD2
============ ============= ============
1 64 1
select get_temp_i+1 from test_01;
ADD
=====================
65
select
case get_temp_i
when (get_temp_i = 1) then 1
else 2
end as case_result
from test_table_01;
CASE_RESULT
============
Statement failed, SQLSTATE = 22018
conversion error from string "64"
--
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
