Query returning error after update to new version

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
damon.cognito
Posts: 50
Joined: Wed 22 Jul 2009 09:30

Query returning error after update to new version

Post by damon.cognito » Sun 04 Mar 2012 17:49

We are using EF to Postgresql. We have just upgraded from postgresql 550 pro Build 237 to 570 pro and a LINQ query is now returning an error. The inner exception is:
'column Project8.C2 does not exist'
It appears that the parsing of the SQL from the LINQ query has failed. I have checked and the query has not been changed. We have also checked out the very newest release (from the end of Feb I think) the the problem remains. I can send you the query , but it is a very complex query and I just wanted to check first that no-one else had reported this problem (because it's going to be a little bit of work getting you the set of tables you'll need).

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 05 Mar 2012 15:09

Could you please compare (between 5.50.237 and 5.70.311) the generated SQL using dbMonitor tool, try to localize the issue, and send us a small test project with the corresponding DDL/DML script?

Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/postgr ... nitor.html

damon.cognito
Posts: 50
Joined: Wed 22 Jul 2009 09:30

Post by damon.cognito » Tue 13 Mar 2012 13:32

Hi - I emailed you some sample stuff on the 6th. Could I have an update please?

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 14 Mar 2012 06:49

We have asked you to send an additional information to us by e-mail.

damon.cognito
Posts: 50
Joined: Wed 22 Jul 2009 09:30

Post by damon.cognito » Wed 14 Mar 2012 21:38

Shalex wrote:We have asked you to send an additional information to us by e-mail.
Extra stuff emailed to you.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 15 Mar 2012 17:52

Thank you for the test project. We have reproduced the issue and are investigating it.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 23 Mar 2012 11:22

The bug with using expression aliases in complex queries is fixed. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 29 Mar 2012 15:56

New build of dotConnect for PostgreSQL 5.80.332 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23777 .

Post Reply