[Firebird-devel] Incorrect mapping of SQLDA parameters

[Nickolay S. <sk...@bs...>]

Hello, All !

I'm fixing bugs in SQLDA parameter mapping. I even fixed them in fact.
For those who don't remember, current order of SQLDA parameter in
select statements and subqueries is:
FROM-CLAUSE, FIRST-CLAUSE, SKIP-CLAUSE, WHERE-CLAUSE, GROUP_BY-CLAUSE,
SELECT-LIST, ORDER_BY-CLAUSE, HAVING-CLAUSE
Redundant parameters are generated for fields in ORDER_BY-CLAUSE and
GROUP_BY-CLAUSE accessed by index (but not in order_by-clause of union).

I.e. number and order of parameters doesn't match SQL source string
which order is:
FIRST-CLAUSE, SKIP-CLAUSE, SELECT-LIST, FROM-CLAUSE, WHERE-CLAUSE,
GROUP_BY-CLAUSE, HAVING-CLAUSE, ORDER_BY-CLAUSE.

This inconsistency makes usage of parameters really painful experience.

There are tools that rely on this incorrect behavior while generating
dynamic SQL. It seems that popular ones like IBExpert are among of
them.

Supporting both new and older behavior is difficult and ill-formed,
but usage of new semantics will break compatibility with some of
existing applications.

What I'm going to do is to test my fix some more and commit it to CVS
as is. Suggestions ?

-- 
Best regards,
 Nickolay Samofatov                      mailto:sk...@bs...