Both HSQL and FB support spaces in column names, the migration script breaks on the first space a column name.
Steps to Reproduce:
1. Download and open attached file.
2. Click on Tables, Start the migration process (click Yes)
While working with Table1 this Error message is displayed.
Error code: 1
*Dynamic SQL Error
*SQL error code = -104
*Unexpected end of command - line 1, column 122
Clear the message box and the migration successfully migrates Table2
Table should migrate as is.
User Profile Reset: No
In Table1 the column name is 'a col name'
In Table2 the column name is 'a_col_name'
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/66.0.3359.139 Chrome/66.0.3359.139 Safari/537.36
Created attachment 142191 [details]
Two table test file
Two tables, Table1 (breaks) and Table2 (works)
This problem was reported via comment on another issue
based on some debug information.
Confirm . Version: 22.214.171.124.alpha1+
Build ID: 59ef304cff3b363fdcbf8bc56762c9349de78d24
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2;
No longer reproducible in
Build ID: 8b96445766efe237eb47608ade6c147673466e2e
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3;
Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded
This has been fixed by https://cgit.freedesktop.org/libreoffice/core/commit/?id=9082e37400baf75296cb94c5588ddeb3d18f0b09
@Julien, thanks for fixing this!!