Q009warning

Command and output disagree

The declared command does not match what the query returns.

db/queries/example.sql:1:1: warning[Q009]: query "AddAuthor" uses command "one" but produces no output columns

   |
 1 | -- sgl.query(AddAuthor, one)
   | ^

Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

For example, exec on a SELECT, which throws the rows away, or one on an INSERT without RETURNING, which has no row to return.

Pick the command that matches the statement: many or one for rows, exec, execrows or execresult for statements without them.

$ sgl explain Q009

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