[Libreoffice-bugs] [Bug 124340] Firebird: Autovalue inconsistency when inserting values into table via macro

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Gerhard Schaber <gerhard.schaber at gmx.at> ---
BTW, I am aware that it is possible to omit the autovalue field like that:

INSERT INTO "table1" ("FirstName", "LastName") VALUES ( 'firstname', 'lastname'
)

But when restoring from a backup, I would like to set the ID field explicitly,
but there does not seem to be a trigger that increases the generator value to
the maximum value. Maybe this is something I have to do myself, but I think
HSQLDB handled it differently.

I will create a simple example.

-- 
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/20190327/257ba5e7/attachment.html>