Error in "row_number() OVER" statement

mars · Post by **mars** » 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

AndreyR · Post by **AndreyR** » Thu 16 Jul 2009 11:39

Thank you for the report, the problem is already fixed.
The fix will be included in the next build.

mars · Post by **mars** » Thu 16 Jul 2009 16:00

How soon will be next build?
On next week we should demostrate pilot version, and this feature is critical for us.
Could you upload previous version dotConnect to http://secure.devart.com/ for dowloading, please?

Thanks

AndreyR · Post by **AndreyR** » Mon 20 Jul 2009 12:00

We plan to release the new build in two weeks.