Q052errornew in Seagull

RETURNING not supported

A query uses RETURNING on a dialect whose database does not support it, such as MySQL.

db/queries/example.sql:2:39: error[Q052]: query "AddAuthor" has a RETURNING clause on its INSERT, but the mysql dialect does not support RETURNING on any statement

   |
 2 | INSERT INTO authors (name) VALUES (?) RETURNING id;
   |                                       ^^^^^^^^^

Printed by sgl from a small MySQL reproduction project.

When it is reported

The database would reject the statement, so the generated method could only fail when it runs, and no command makes it work. The dialect says whether it supports RETURNING; MariaDB does for INSERT and DELETE, MySQL and ClickHouse do not.

How to fix it

Drop the RETURNING clause and use execresult, reading LastInsertId or RowsAffected, then select the row again if you need it.

In your terminal

$ sgl explain Q052

Look for ReturningNotSupported in Seagull's source to see where it is reported.