Page 1 of 1

BUG in 7.11.1278 !!!

Posted: Fri 21 Dec 2018 13:49
by ole.tetzschner
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

Re: BUG in 7.11.1278 !!!

Posted: Mon 24 Dec 2018 17:13
by Shalex
We cannot reproduce the bug at the moment. Could you please send us a small test project for reproducing the issue?

Re: BUG in 7.11.1278 !!!

Posted: Mon 31 Dec 2018 10:03
by ole.tetzschner
Hi Shalex

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

Kind regards and a happy new year, Ole

Re: BUG in 7.11.1278 !!!

Posted: Thu 03 Jan 2019 19:03
by Shalex
We have asked for the additional information by email.

Re: BUG in 7.11.1278 !!!

Posted: Mon 07 Jan 2019 10:17
by ole.tetzschner
Additional information sent :)

Re: BUG in 7.11.1278 !!!

Posted: Tue 15 Jan 2019 14:37
by Shalex
We have answered via email.

Re: BUG in 7.11.1278 !!!

Posted: Wed 16 Jan 2019 10:27
by ole.tetzschner
After upgrading to 7.12.1307 the problem seems solved.

Re: BUG in 7.11.1278 !!!

Posted: Wed 16 Jan 2019 10:48
by Shalex
Thank you for letting us know.