Error in "row_number() OVER" statement
Posted: Thu 16 Jul 2009 08:11
Hello,
Linq to Entity generate sql with wrong (in my opinion) fragment :
[b]row_number() OVER (ORDER BY ,"Project1".ACC_ID ASC) AS "row_number"[/b]
should be without comma :
[b]row_number() OVER (ORDER BY "Project1".ACC_ID ASC) AS "row_number"[/b]
Could you correct this? Or explain what i am doing wrong, please?
We use Professional edition 5.25.37.0
In trial all worked correctly.
Thanks
Linq to Entity generate sql with wrong (in my opinion) fragment :
[b]row_number() OVER (ORDER BY ,"Project1".ACC_ID ASC) AS "row_number"[/b]
should be without comma :
[b]row_number() OVER (ORDER BY "Project1".ACC_ID ASC) AS "row_number"[/b]
Could you correct this? Or explain what i am doing wrong, please?
We use Professional edition 5.25.37.0
In trial all worked correctly.
Thanks