Sql dialect in OpenOffice database

Question

I am familiar with SQL in SQLite and MySQL, but the OpenOffice database seems either very crippled, or I don’t understand how to execute raw SQL.

I want to do (efficiently) 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 NULL seems to confuse Base, as well as the syntax INSERT INTO T2 SELECT ....

Can someone tell me how to fix this?

Answer 1

Indeed, NULL is not accepted there. Must. Could you write this as an error and assign it to [e-mail] so that I do not forget to fix it? Thank.

, Libre/OpenOffice / -, " SQL- " " SQL: "