Description: Original file created with 5.4.6.2 Test system: Version: 6.1.0.0.alpha1 Build ID: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; Locale: en-US (en_US.UTF-8); Calc: group Steps to Reproduce: 1. Load and open attached ODB file. 2. Open and go to Tables 3. Answer yes to migration to Firebird Actual Results: Error firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Token unknown - line 1, column 123 *SUB_TYPE caused by 'isc_dsql_prepare' Expected Results: Table and data migrate to firebird schema Reproducible: Always User Profile Reset: No Additional Info: error happens before data import User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/65.0.3325.181 Chrome/65.0.3325.181 Safari/537.36
Created attachment 141727 [details] test ODB with single table, two columns and two records test file with data
Confirmed on ubuntu 16.04 x64 with Version: 6.1.0.0.alpha1+ Build ID: e9ac3a9c1ee7689c4d591a68250666c95632bd2a CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-04-27_00:59:01 Locale: en-US (en_US.UTF-8); Calc: As a workaround, first click 'later'. Next try to open the table again. Now base doesn't shows the error and the table is opened normally. When trying to save the file, base shows the error again and on clicking 'yes' and 'ok', crashes: crashreport.libreoffice.org/stats/crash_details/a5c3b866-b94d-4a79-ad65-577a58ec0027 Maybe a different bug ?
(In reply to MM from comment #2) > Confirmed on ubuntu 16.04 x64 with Version: 6.1.0.0.alpha1+ > Build ID: e9ac3a9c1ee7689c4d591a68250666c95632bd2a > CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk2; > TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: > 2018-04-27_00:59:01 > Locale: en-US (en_US.UTF-8); Calc: > > As a workaround, first click 'later'. Next try to open the table again. Now > base doesn't shows the error and the table is opened normally. > > When trying to save the file, base shows the error again and on clicking > 'yes' and 'ok', crashes: > crashreport.libreoffice.org/stats/crash_details/a5c3b866-b94d-4a79-ad65- > 577a58ec0027 > Maybe a different bug ? YUP that does crash it.. and yes I agree separate issue. Off to do that now.
Tamas Bunth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1932f4b04a299fc4f478a629f0f97efea8a10c62 tdf#117301 dbahsql: add FLOAT type It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Checked with build: Version: 6.1.0.0.alpha1+ Build ID: e8d48dd75a1bb31b5bc500bc79fb80384a09bcc6 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-05-12_18:01:45 Locale: en-US (en_US.UTF-8); Calc: group Table with field type and data came across as expected.
(In reply to Drew Jensen from comment #5) > Checked with build: > Version: 6.1.0.0.alpha1+ > Build ID: e8d48dd75a1bb31b5bc500bc79fb80384a09bcc6 > CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; > TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: > 2018-05-12_18:01:45 > Locale: en-US (en_US.UTF-8); Calc: group > > Table with field type and data came across as expected. Setting as RESOLVED VERIFIED then. Thanks for checking it...