Open akarelas opened 2 years ago
When I do:
say $abstract->insert('a_table', {});
...I get:
INSERT INTO a_table VALUES ()
...which is invalid syntax in PostgreSQL v14 (results in error ERROR: syntax error at or near ")")
ERROR: syntax error at or near ")"
The following SQL string should be output:
INSERT INTO a_table DEFAULT VALUES
Interesting idea.
According to https://www.postgresql.org/docs/7.1/sql-insert.html, DEFAULT VALUES is supported all the way back to PostgreSQL v7.1.
DEFAULT VALUES
Steps to reproduce the behavior
When I do:
...I get:
...which is invalid syntax in PostgreSQL v14 (results in error
ERROR: syntax error at or near ")"
)Expected behavior
The following SQL string should be output: