Issue Details (XML | Word | Printable)

Key: CORE-6299
Type: Bug Bug
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Jan Kohlmeyer
Votes: 0
Watchers: 0
Operations

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

Param Datatype detection wrong, if coalesce used

Created: 07/May/20 11:51 AM   Updated: 07/May/20 01:02 PM
Component/s: API / Client Library
Affects Version/s: 3.0.5
Fix Version/s: None

Environment: Windows 10, Intel i7

QA Status: No test


 Description  « Hide
Hi,
i've this statement in 3.0.4 and 3.0.5.

In 3.0.4 the param datatype is char(4) in 3.0.5 the param datatype is char(0):

select coalesce(:test, '') between '0815' and '4700' from rdb$database

If i remove the coalesce, the datatype is in both char(4):

select :test between '0815' and '4700' from rdb$database

Regards, Jan

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 07/May/20 01:02 PM
Looks as a duplicate for CORE-6187.