Issue Details (XML | Word | Printable)

Key: CORE-437
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Nickolay Samofatov
Reporter: Nickolay Samofatov
Votes: 0
Watchers: 0
Operations

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

Parameter order is wrong

Created: 20/Aug/02 12:00 AM   Updated: 14/Jun/06 09:39 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 1.5.0

SF_ID: 597769


 Description  « Hide
SFID: 597769#
Submitted By: skidder

I use Firebird-1.0.0.796 CS on Linux.

I hope this bug will not be ignored as my previous ones.

Parameter introduced in the select list come after all other
params in dynamic SQL.
Example query:
---
select (select 'ok' from RDB$DATABASE where :test=1)
from RDB$DATABASE where :test2=2
---
When we set
:test=1
:test2=2
we get null result.

When we set
:test=2
:test2=1
we get 'ok' result

We reproduced this bug on using InterClient, JCA and IBX,
so it seems to be in the core engine.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.