doltgresql icon indicating copy to clipboard operation
doltgresql copied to clipboard

unable to prepare query: unsupported syntax

Open forhsd opened this issue 8 months ago • 1 comments

  1. execute the following SQL report error:unable to prepare query: unsupported syntax
  2. can execute normally in Postgres database
  3. Doltgres version 0.50.0

select * from (values(1,'峰哥',18),(2,'王哥',20),(3,'张哥',22)) x(id,name,age);

forhsd avatar Apr 24 '25 09:04 forhsd

We have some known issues around prepared statements. We have a PR open to fix them.

https://github.com/dolthub/doltgresql/pull/1406

We'll add this bug to the list.

timsehn avatar Apr 24 '25 16:04 timsehn

Hi @forhsd,

I couldn't reproduce this behavior in 0.50.1, out now:

https://github.com/dolthub/doltgresql/releases/tag/v0.50.1

Please try again and let us know if you still see the issue.

zachmu avatar May 02 '25 00:05 zachmu

您好 ,

我无法在 0.50.1 中重现这种行为,现在已经发布:

https://github.com/dolthub/doltgresql/releases/tag/v0.50.1

请重试,如果您仍然看到问题,请告诉我们。

I tried 0.50.1 and the problem has been resolved. Thank you

forhsd avatar May 06 '25 01:05 forhsd