Parameters inside the CAST function are described as not nullable [CORE3475] #3836
Labels
affect-version: 2.0.4
affect-version: 2.0.5
affect-version: 2.0.6
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.1.4
affect-version: 2.5.0
affect-version: 3.0 Initial
component: engine
fix-version: 3.0 Alpha 1
priority: minor
qa: done successfully
type: bug
Submitted by: @dyemanov
Relate to JDBC271
ISQL:
set planonly;
set sqlda_display;
select (null as int) from rdb$database;
-- sqltype = 497 (nullable)
select (? as int) from rdb$database;
-- sqltype = 496 (not null)
It may cause wrong results (e.g. zero instead of null) returned by applications hardly relying on the described nullability flag and ignoring the runtime one.
Commits: dd0047e
The text was updated successfully, but these errors were encountered: