[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Julien Nabet changed: What|Removed |Added Blocks|116968 | Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Julien Nabet changed: What|Removed |Added Blocks||116968 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Robert Großkopf changed: What|Removed |Added Blocks||154426 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=154426 [Bug 154426] [META] Steps to work with Base without needing Java -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||0267 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 --- Comment #10 from mhonline --- the concept of having no record-numbers "available for users" in firebird is weak, althought they need to have them, since they can establish table-relations. However, the proposal of robert might not work, as the value from "generated by default" can be overwriten. Pls see this copy from the FB-4.0-manual: GENERATED BY DEFAULT An identity column of type GENERATED BY DEFAULT will generate a value on insert if no value — other than DEFAULT — is specified on insert. When the OVERRIDING USER VALUE clause is specified in the INSERT statement, the user-provided value is ignored, and an identity value is generated (as if the column was not included in the insert, or the value DEFAULT was specified). But the solution for the problem lies somewhere in there. I still believe, that - as stated somewhere else - the field of type identity with autoincrement must be made "non-editable" by user, but to have additional regular fields filled by a generator might be an option too to get a usable workaround. m. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||7174 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 --- Comment #9 from Robert Großkopf --- New idea, because it isn't possible to switch a field to autoincrement in Firebird 3 (and also Firebird 4): Couldn't we add the possibility to set autoincremented field in the wizard for importing tables? There has only to be added GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY to the code for internal databases (HSQLDB, Firebird 3). -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 --- Comment #8 from Julien Nabet --- (In reply to mhonline from comment #7) > dropping support of firebird within LO might be a good idea. > Non working and no developement on their site visable (last FB 4.0Beta is 15 > month old, ODBC 3 Year, all new stuff around FB JAVA-based only) > m. LO uses Firebird 3.0.0 whereas 3.0.5 exists but it needs some working to use it since it must work on Linux, Mac and Windows (so patches may be necessary). For the rest, that's the reason why Firebird has been put back experimental. So you can't create new ODB files with Firebird when experimental features are disabled. You can still open existing Firebird odb files even if experimental features are disabled. About dropping support of Firebird, I wouldn't oppose against this. The initial goal to support Firebird was to use a non Java dependent database like HSQLDB and one day, drop HSQLDB support. There was even a migration tool for this. But migration tool is quite buggy and Firebird implementation isn't complete. About HSQLDB, there are more recent versions released but since there was Firebird, nobody worked on this. In brief, we're in the middle of a bridge and are stuck for the moment. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 --- Comment #7 from mhonline --- dropping support of firebird within LO might be a good idea. Non working and no developement on their site visable (last FB 4.0Beta is 15 month old, ODBC 3 Year, all new stuff around FB JAVA-based only) m. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Julien Nabet changed: What|Removed |Added Blocks||51780 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=51780 [Bug 51780] [META] Default to Firebird not HSQLDB in Base (for _new_ files) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 --- Comment #6 from Julien Nabet --- (In reply to Robert Großkopf from comment #5) > ... > We could > - change the wizard to choose the possibility to set AutoIncrement while > importing rows, which has already a value in the field. The Generator has to > be set afterwords with the max value of the field. > - change the table editor. It should be possible to read the max value of a > Integer field and set this value to the generator. Too difficult task at least for me. > > Since LO 4.2 we have an experimental Firebird database. It is 6 years ago. > Seems it is too tricky to get it working for us. I won't use this kind of > internal database. I understand you too well and already told it... There have been a lot of work to integrate Firebird but it's not the case anymore since several months (years?). I think it should be removed but it's only my personal opinion. I'm gonna send an email to Lionel and Tamas and I put you in cc Alexander Thurgood and you since you're the main (only?) QA experts about Base. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 --- Comment #5 from Robert Großkopf --- Autoincrement isn't supported by Firebird at all. There is a special generator created for. But when we want to change from HSQLDB to Firebird the working internal database should offer this in another way. When changing from internal HSQLDB to Firebird with the migrationwizard the autovalue will be created for existing tables. So it is implemented somewhere in this code. We could - change the wizard to choose the possibility to set AutoIncrement while importing rows, which has already a value in the field. The Generator has to be set afterwords with the max value of the field. - change the table editor. It should be possible to read the max value of a Integer field and set this value to the generator. Since LO 4.2 we have an experimental Firebird database. It is 6 years ago. Seems it is too tricky to get it working for us. I won't use this kind of internal database. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345
Julien Nabet changed:
What|Removed |Added
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
--- Comment #4 from Julien Nabet ---
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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 --- Comment #3 from Robert Großkopf --- Difference to HSQLDB: The wizard is the same. The key could be set, but no AutoValue. But in HSQLDB you could change the table afterwards. You could set the AutoValue in the tableeditor without any problem. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Status|NEW |UNCONFIRMED Ever confirmed|1 |0 --- Comment #2 from Xisco Faulí --- (In reply to Julien Nabet from comment #1) > Perhaps related or brand new bug but on pc Debian x86-64 with master sources > updated today, I can't see the properties fields with gtk3 rendering (no pb > with kf5 or gen rendering) for a Firebird embedded odb or an embedded hsqldb > odb. That's bug 130623. Setting this report back to UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #1 from Julien Nabet --- Perhaps related or brand new bug but on pc Debian x86-64 with master sources updated today, I can't see the properties fields with gtk3 rendering (no pb with kf5 or gen rendering) for a Firebird embedded odb or an embedded hsqldb odb. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130345] FIREBIRD: Impossible to create an autovalue key when inserting a new table
https://bugs.documentfoundation.org/show_bug.cgi?id=130345 Julien Nabet changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||7527 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
