[Libreoffice-bugs] [Bug 133769] New: FIREBIRD: Filed length for VARCHAR couldn't be set to 10000

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 133769
           Summary: FIREBIRD: Filed length for VARCHAR couldn't be set to
                    10000
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

This bug appears while migrating from HSQLDB to Firebird with the
Migration-wizard.

firebird_sdbc error:
*unsuccessful metadata update
*CREATE TABLE Rechnungsinhalt failed
*Dynamic SQL Error
*SQL error code = -204
*Data type unknown
*Implementation limit exceeded
*COLUMN <Missing arg #1 - possibly status vector overflow>
caused by
'CREATE TABLE "Rechnungsinhalt" ( "ID" INTEGER NOT NULL, "Rechnungsinhalt"
VARCHAR(10000) NOT NULL,PRIMARY KEY("ID"))'

/home/buildslave/source/libo-core/connectivity/source/drivers/firebird/Util.cxx:68

So I tried it later in the Firebird-database with Tools → SQL:
CREATE TABLE "Rechnungsinhalt" ( "ID" INTEGER NOT NULL, "Rechnungsinhalt"
VARCHAR(10000) NOT NULL,PRIMARY KEY("ID"))
doesn't work. If I set it to 8000 instead of 10000 it will accept the command.

Note: Firebird supports 1 to 32.767 Bytes for a Varchar-field. But we have also
problems to count the characters right way, because there are characters, which
will need 2 byte or 4 byte. Seems this limit has been set in the driver from LO
to 8000 - for 4 byte characters...

The bug appears in Firebird in LO 6.4.4.2 on OpenSUSE 15.1 64bit rpm Linux.

-- 
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/20200607/012a2f2f/attachment-0001.htm>