| Key: |
CORE-6299
|
| Type: |
Bug
|
| Status: |
Open
|
| Priority: |
Critical
|
| Assignee: |
Unassigned
|
| Reporter: |
Jan Kohlmeyer
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
Windows 10, Intel i7
|
|
|
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
|
|
Description
|
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 |
Show » |
|
Param Datatype detection wrong, if coalesce used