[Libreoffice-bugs] [Bug 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

 Status|RESOLVED|VERIFIED

--- Comment #8 from Xisco Faulí  ---
Verified in

Version: 6.1.0.0.alpha0+
Build ID: b36ea44dcbdb862b0ac6e6cdaf27225b43dc0c7e
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

-- 
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

Tamas Bunth  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

-- 
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

--- Comment #7 from Commit Notification 
 ---
Tamas Bunth committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=22cfac8edeb3371e458b9f9533478c6e5a81287e

tdf#116982 dbahsql: fix autoincrementation

It will be available in 6.1.0.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

-- 
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard||target:6.1.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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

--- Comment #6 from rob...@familiegrosskopf.de ---
(In reply to robert from comment #5)
> This is the code for getting all generators:
> 
> SELECT * FROM RDB$GENERATORS;
> 
> ... but don't know the right generator.
> 
> Could we save the name of the generator in the description of the field,
> which should be the autovalue-field?
> 
> For HSQLDB you haven't to know this, because the code only need the table
> and the field.

Have found this:
SELECT RDB$FIELD_NAME, RDB$RELATION_NAME, RDB$GENERATOR_NAME  FROM
RDB$RELATION_FIELDS WHERE RDB$GENERATOR_NAME IS NOT NULL

Will show the generatorname for the fields of the tables with autoincrement
value.

Generatornames are RDB$1, RDB$2 and so on ...
ALTER SEQUENCE RDB$1 RESTART WITH 10;
Sets the generator to 10. This should be the last value of the
autoincrement-field. Not the value, which should be generated as next value!
Next autoincremented value will be 11, when "RESTART WITH 10" is set - a little
bit confusing.

-- 
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

--- Comment #5 from rob...@familiegrosskopf.de ---
This is the code for getting all generators:

SELECT * FROM RDB$GENERATORS;

... but don't know the right generator.

Could we save the name of the generator in the description of the field, which
should be the autovalue-field?

For HSQLDB you haven't to know this, because the code only need the table and
the field.

-- 
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

--- Comment #4 from rob...@familiegrosskopf.de ---
Have tested the following:
Opened a migrated Firebird database.
Tried to input a new row in a table with autoincrement.
Next value has to be 10.
When I want to go to next row it shows
*Problematic key value is ("id" = 0)
Click "OK"
then again
*Problematic key value is ("id" = 1)
Click "OK"
... and so on.
The generated key-value will switch every time I try to input the row again up
to the value which works.

Don't know if there is another way to set the start-value of autoincrement.
There isn't a function like 

ALTER TABLE "tablename" ALTER COLUMN "fieldname" RESTART WITH ;

available, because the autoincement value is set by a generator. I don't know
where to get the name of the generator. The name isn't shown in the error-code.
Could be with the name this will work:

SET GENERATOR gen_t1_id TO ;

-- 
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords|bibisected  |

-- 
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

--- Comment #3 from Lionel Elie Mamane  ---
This looks like the autoincrement column is created in firebird (by means of a
sequence / generator, that is an object that returns a new, fresh, incremented
number each time it is required), but the generator is not initialised with the
next value it should give (something like MAX(existing values in the table) or
whatever HSQLDB would have returned for the next insertion), so it starts with
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords||bibisected, bisected,
   ||regression
 Status|UNCONFIRMED |NEW
 CC||btom...@gmail.com,
   ||xiscofa...@libreoffice.org
   Hardware|x86-64 (AMD64)  |All
 Blocks||116968
 Ever confirmed|0   |1
 OS|Mac OS X (All)  |All

--- Comment #2 from Xisco Faulí  ---
Regression introduced by:

author  Tamas Bunth    2018-03-25 13:26:57
+0200
committer   Tamás Bunth  2018-04-07 17:08:26 +0200
commit  159dd28651788a19848eae56693ad06ed947414d (patch)
treeb69013db1c0fa45677b59d58999ce0d8ebebd76c
parent  1a9bfdd8976d28fa3a56726bdcae9f2b294d6c6d (diff)
dbaccess: Enable hsql migration by default
Also make Firebird driver not experimental anymore.

Bisected with: bibisect-linux64-6.1

Adding Cc: to Tamas Bunth


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 mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

--- Comment #1 from Alex Thurgood  ---
Created attachment 141322
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141322=edit
Test hsqldb file for migration to firebird

-- 
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 116982] FIREBIRD : Migration : import of table with autoincrement leads to integrity violation when attempting to add new record

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   Priority|medium  |high
   Severity|normal  |major

-- 
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