https://bugs.documentfoundation.org/show_bug.cgi?id=83737
--- Comment #8 from Lionel Elie Mamane <[email protected]> ---
(In reply to Doug from comment #7)
> Can I just have a clarification. The command
>
> INSERT INTO `table` () VALUES ();
>
> is interpreted by MariaDB 10.1.6, and there is no error. It performs as
> desired, using default values for a new row.
Then MariaDB supports that as an extension, that other RDBMS do not support. I
tried PostgreSQL, HSQLDB 1.8 and Firebird 2.5.
My guess is that the SQL standard does require support for that. OTOH, I now
discover, PostgreSQL and Firebird both support:
INSERT INTO "table" DEFAULT VALUES;
Maybe that's another non-standard extension, but it seems to be more widely
supported :) E.g. also Microsoft SQL Server.
Beyond what SQL supports, would the ODBC / ADO / JDBC drivers also accept such
a "insert all defaults" command? I'm not sure either way.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
