sql dialect in OpenOffice Base

Question

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?

Answer 1

Indeed, NULL is not accepted there. It should. Could you please file this as a bug and assign it to [email protected] 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"