Created attachment 144442 [details] The table name contains 5 characters The table name contains 5 characters, and the column name is also 5. Migration does not occur. SET DATABASE COLLATION "Russian" CREATE SCHEMA PUBLIC AUTHORIZATION DBA CREATE CACHED TABLE "\u0420\u0443\u0441\u0441\u043a"("\u0420\u0443\u0441\u0441\u043a" VARCHAR(100)) CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 0 MILLIS
Created attachment 144443 [details] The table name contains 19 characters
Confirmed with Ubuntu 18.04 LibreOffice 6.0.3 and 6.1.1 Unable to check 6.2Alpha as these two ODB files are added to the list of files which fail to run the migration assistant when responding yes to the prompt. Adding Tamas to the CC
sorry of course I meant 6.1.0.3 (not 6.0.3) in the last comment.
It helped me http://www.java2s.com/Code/Java/Development-Class/ASCII2NATIVE.htm https://github.com/Aleks-Ya/ascii2native-maven-plugin
Tamas Bunth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/aa974a1b3798e04424623ad331e9f5a0ae01a34b%5E%21 tdf#119502: dbahsql: tables without primary key It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I do confirm the issue is fixed in if I open the first file attached. Version: 6.3.0.0.alpha0+ Build ID: f8c4459bbda62cb905d0c007cac044f3410ab76b CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded However, the second one still fails to be migrated. @Tamas Bunth, should I create a follow-up bug ?
For what it's worth. If you create an sql script file form each of the test files and attempt to apply the table create statement in a Firebird emb ODB via the SQL Window: The 5 character (multi-byte) string CREATE TABLE "\u0420\u0443\u0441\u0441\u043a"("\u0420\u0443\u0441\u0441\u043a" VARCHAR(100)) is accepted. The 19 character (multi-byte) string CREATE TABLE "\u0420\u0443\u0441\u0441\u043a\u043e\u0435\u041d\u0430\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0438\u0435"("\u0420\u0443\u0441\u0441\u043a" VARCHAR(100)) is rejected with exactly the same error as during the migration assistant: 2: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Name longer than database column size caused by 'isc_dsql_prepare' So I would think this is best as a new issue against the SDBC driver and not just the Migration Assistant.
(In reply to Drew Jensen from comment #7) > > So I would think this is best as a new issue against the SDBC driver and not > just the Migration Assistant. OH - this is embarrassing: forget the last comment. It didn't do what I thought it did at all and was meaningless noise.
Tamas Bunth committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/8d070171116eb9c57aae10d3dfbd913a097d2451%5E%21 tdf#119502: dbahsql: tables without primary key It will be available in 6.2.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.