Non order placing JOIN and ON clauses issue

[vode]

Hi

There is an issue present in the linqer 3.0. Linqer is sensitive to the order of JOINs and corresponding ONs in the source sql query. The issue addressed to conversion logic without using associations for simplifying LINQ query. So the corresponded check box in the configuration should be checked off to reproduce the issue.

The next query is successfully converted:

SELECT * FROM A INNER JOIN A_B ON A.AID = A_B.AID
INNER JOIN B
ON A_B.BID = B.BID

But if the order is changed (the result still be a valid query) conversion fails:

SELECT * FROM A INNER JOIN A_B
INNER JOIN B
ON A_B.BID = B.BID ON A.AID = A_B.AID


The database I have used is made from the script I have posted in the thread sqltolinq.proboards.com/index.cgi?board=general&action=display&thread=28

Good luck.

[Mikhail Oumantsev]

This is the same issue you posted before.
I've found the reason of this error already.
SELECT A.AName, C.CName
FROM C INNER JOIN
B_C ON C.CID = B_C.CID INNER JOIN
A INNER JOIN
A_B ON A.AID = A_B.AID ON B_C.BID = A_B.BID
WHERE (C.CName = 'qqq')

Linqer cannot handle this part corectly
A INNER JOIN
A_B ON A.AID = A_B.AID ON B_C.BID = A_B.BID
SQL parser expects ON immediately after JOIN.


Thanks,
Mikhail.