[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table

[bugzilla-daemon at bugs.documentfoundation.org]

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

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW

--- Comment #4 from Julien Nabet <serval2412 at yahoo.fr> ---
According to
https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/Table.cxx?r=80aec8ef#191
    188     if (bIsAutoIncrementChanged)
    189     {
    190        ::dbtools::throwSQLException(
    191             "Changing autoincrement property of existing column is not
supported",
    192             ::dbtools::StandardSQLState::FUNCTION_NOT_SUPPORTED,
    193             *this);
    194 
    195     }

It's not supported yet.

More details here about autoincrement field support in the different versions
of Firebird:
https://stackoverflow.com/questions/34553826/easiest-way-to-create-an-auto-increment-field-in-firebird-database

(BTW Mark Rotteveel works on "Jaybird" the JDBC connector to Firebird)

Remark: for the moment, LO includes Firebird 3.0.0 package where there's 3.0.5.
I had tried to upgrade it but there were some pb with MacOs part, I abandoned
it.
If someone wants to give it a try or perhaps we prefer waiting for Firebird
4.0.

-- 
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/20200213/c86dc821/attachment.htm>