BUG in 7.11.1278 !!!

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
ole.tetzschner
Posts: 17
Joined: Thu 12 Jul 2018 10:57

BUG in 7.11.1278 !!!

Post by ole.tetzschner » Fri 21 Dec 2018 13:49

Hi

After upgrading from 7.11.1253 (professional-edition) we are now constantly receiving ErrorCode "42601" with the text "{"syntax error at or near \")\""}".

My C# code:

Code: Select all

var myRow = myContext.MyTableBs
                        .Include("MyTableA")
                        .Include("MyTableC")
                        .Include("MyTableD")
                        .Where(t => t.Id == myId)
                        .FirstOrDefault();
SQL-code generated by Devart-lib:

Code: Select all

SELECT "t.MyTableC"."Id", "t.MyTableC"."MyColA"
FROM my_schema."MyTableC" "t.MyTableC"
INNER JOIN (
    SELECT DISTINCT t1.*
    FROM ((
        SELECT t0."Id"
        FROM my_schema."MyTableB" t0
        INNER JOIN my_schema."MyTableA" "t.MyTableA0" ON t0."MyTableAId" = "t.MyTableA0"."Id"
        WHERE t0."Id" = $1
        ORDER BY t0."Id"
        LIMIT 1
    ) AS t1)
) AS t2 ON "t.MyTableC"."MyTableBId" = t2."Id"
ORDER BY t2."Id"
Replacing $1 with a value and running the query in a database-manager, I can see the error is the ) just after AS t1


Any ETA on a error-fix?

Kind regards and merry Christmas from Ole

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

Re: BUG in 7.11.1278 !!!

Post by Shalex » Mon 24 Dec 2018 17:13

We cannot reproduce the bug at the moment. Could you please send us a small test project for reproducing the issue?

ole.tetzschner
Posts: 17
Joined: Thu 12 Jul 2018 10:57

Re: BUG in 7.11.1278 !!!

Post by ole.tetzschner » Mon 31 Dec 2018 10:03

Hi Shalex

A small test-project is sent. Hope to hear from you soon.

Kind regards and a happy new year, Ole

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

Re: BUG in 7.11.1278 !!!

Post by Shalex » Thu 03 Jan 2019 19:03

We have asked for the additional information by email.

ole.tetzschner
Posts: 17
Joined: Thu 12 Jul 2018 10:57

Re: BUG in 7.11.1278 !!!

Post by ole.tetzschner » Mon 07 Jan 2019 10:17

Additional information sent :)

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

Re: BUG in 7.11.1278 !!!

Post by Shalex » Tue 15 Jan 2019 14:37

We have answered via email.

ole.tetzschner
Posts: 17
Joined: Thu 12 Jul 2018 10:57

Re: BUG in 7.11.1278 !!!

Post by ole.tetzschner » Wed 16 Jan 2019 10:27

After upgrading to 7.12.1307 the problem seems solved.

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

Re: BUG in 7.11.1278 !!!

Post by Shalex » Wed 16 Jan 2019 10:48

Thank you for letting us know.

Post Reply