Error in "row_number() OVER" statement

Error in "row_number() OVER" statement

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

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

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

Postby AndreyR » Mon 20 Jul 2009 12:00

We plan to release the new build in two weeks.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle