Query returning error after update to new version

damon.cognito · 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 · 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 · 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 · 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 · 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 · 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 · 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 · 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 .