[Libreoffice-bugs] [Bug 123020] Migration to Firebird db fails on "unknown token isc_dsql_prepare"

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123020

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |btomi96 at gmail.com

--- Comment #6 from Julien Nabet <serval2412 at yahoo.fr> ---
I retested this and had another result.
First, when I downloaded this, I got this name on my laptop (Debian x86-64 with
French UI):
'Poängdatabasen - kopia (2).odb'

Here are the actions I done:
- rename the file to avoid special characters
- open the file and disable macros
- accept migration when trying to open tables
=> errors
Here are console logs:
warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Util.cxx:55:
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Name longer than database column size
caused by
'isc_dsql_prepare'

warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Statement.cxx:122:
isc_dsql_execute failed
warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Util.cxx:55:
firebird_sdbc error:
*unsuccessful metadata update
*CREATE VIEW Transaktionssumma failed
*Dynamic SQL Error
*SQL error code = -206
*Column unknown
*Ins\u00e4ttning
caused by
'CREATE VIEW "Transaktionssumma"
("Transaktionsnr","Kontonr","Datum","Beskrivning","Ins\u00e4ttning","Uttag","Ej
utnyttjat","Tillgodo") AS SELECT "Transaktionsnr" AS "Transaktionsnr",
"Kontonr" AS "Kontonr", "Datum" AS "Datum", "Beskrivning" AS "Beskrivning",
"Ins\u00e4ttning", "Uttag", "Ej utnyttjat", "Ins\u00e4ttning" - "Uttag" - "Ej
utnyttjat" AS "Tillgodo" FROM "Transaktioner"'

warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Statement.cxx:122:
isc_dsql_execute failed
warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Util.cxx:55:
firebird_sdbc error:
*unsuccessful metadata update
*CREATE VIEW \u00c5rstransaktioner failed
*Dynamic SQL Error
*SQL error code = -206
*Column unknown
*Ins\u00e4ttning
caused by
'CREATE VIEW "\u00c5rstransaktioner"
("Kontonr","\u00c5r","Ins\u00e4ttningar","Uttag") AS SELECT "Kontonr", CAST(
LEFT( "Datum", 4 ) AS INTEGER ) AS "\u00c5r", SUM( "Ins\u00e4ttning" ) AS
"Ins\u00e4ttningar", SUM( "Uttag" ) AS "Uttag" FROM "Transaktioner" GROUP BY
"Kontonr", LEFT( "Datum", 4 ) ORDER BY "Kontonr" ASC, "\u00c5r" ASC'

warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Statement.cxx:122:
isc_dsql_execute failed
warn:connectivity.firebird:11528:11528:connectivity/source/drivers/firebird/Util.cxx:55:
firebird_sdbc error:
*unsuccessful metadata update
*CREATE VIEW Konto och transaktioner failed
*Dynamic SQL Error
*SQL error code = -206
*Column unknown
*Transaktioner.Ins\u00e4ttning
caused by
'CREATE VIEW "Konto och transaktioner"
("Kontonamn","Datum","Beskrivning","Ins\u00e4ttning","Uttag") AS SELECT
"Konton"."Kontonamn", "Transaktioner"."Datum", "Transaktioner"."Beskrivning",
"Transaktioner"."Ins\u00e4ttning", "Uttag" + "Ej utnyttjat" AS "Uttag" FROM
"Transaktioner", "Konton" WHERE "Transaktioner"."Kontonr" = "Konton"."Kontonr"'

warn:dbaccess:11528:11528:dbaccess/source/filter/hsqldb/hsqlimport.cxx:384:
Error during migration

Tamás: thought you might be interested in this one. It seems there are still
part which need to take into account encoding.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190130/721c47c8/attachment.html>