Error in "row_number() OVER" statement

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
mars
Posts: 15
Joined: Tue 14 Jul 2009 13:56

Error in "row_number() OVER" statement

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Posts: 15
Joined: Tue 14 Jul 2009 13:56

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 20 Jul 2009 12:00

We plan to release the new build in two weeks.

Post Reply