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();
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"
Any ETA on a error-fix?
Kind regards and merry Christmas from Ole