+++ This bug was initially created as a clone of Bug #46198 +++ http://stackoverflow.com/questions/4770466/sql-dialect-in-openoffice-base/9315951#9315951 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?
Sorry Lionel, just need this as a test for the bugzilla script. Will correct it if the script does not fix it.
Lionel Elie Mamane commited a patch related to this issue to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=00e26baaf5cca36a7e78036aa5694196ccbf7402 fdo#46206 accept an arbitrary query for INSERT
Sorry for the noise. Fixed now the last error in the script.
Lionel Elie Mamane committed a patch related to this issue. It has been pushed to "libreoffice-3-5": http://cgit.freedesktop.org/libreoffice/core/commit/?id=02dc763291630f7cb4cd9342e8937f3abb92dbc2&g=libreoffice-3-5 fdo#46206 accept an arbitrary query for INSERT It will be available in LibreOffice 3.5.1.
Fix is in 3.5, 3.6, there will be no 3.4.7, so I closed tis one. Please feel free to reopen if I did wrong.