I'm familiar with SQL in SQLite and MySQL, but OpenOffice Base seems to be either very crippled, or I don't understand how to execute raw SQL.
I want to do (effectively) this:
INSERT INTO t2 SELECT NULL as id, t.foo, t.bar, '' as baz, 0 as quux
FROM MyTable t
All I can do is
SELECT t.foo, t.bar, '' as baz, 0 as quux FROM MyTable t
because the NULL seems to give Base confusion, as does the INSERT INTO T2 SELECT ... syntax.
Can anyone suggest how I need to fix this?
Indeed, NULL is not accepted there. It should. Could you please file this as a bug and assign it to lionel@mamane.lu so that I don't forget to fix it? Thanks.
In general, to avoid Libre/OpenOffice from trying to parse/understand your query, and send it to the database engine pristine as-is, use "run sql command directly" or "analyze SQL: no"