[Libreoffice-bugs] [Bug 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

Tamas Bunth  changed:

   What|Removed |Added

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

--- Comment #20 from Tamas Bunth  ---
1. 2. are solved.

3. is impossible with Firebird. Firebird does not allow to change an existing
column to autoincremented.

4.: I think it would be nice to create a new, clean bug tracker for this,
considering that the initial error message has been changed since the creation
of this tracker.

I'm not sure what is the correct status in that case, so I just move it to
resolved / 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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

Lionel Elie Mamane  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
-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

Lionel Elie Mamane  changed:

   What|Removed |Added

 Blocks||116968


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=116968
[Bug 116968] (Database-Firebird-Migration) - [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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #19 from Julien Nabet  ---
I forgot to say that if I create a view with "Create View" wizard, the view
doesn't appear automatically too.

In comparison, with hsqldb embedded, the view appears automatically (so with
using "Refresh Tables") in both cases, so no error message of course with using
"Create as View" on a query.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #18 from Julien Nabet  ---
(In reply to Gerhard Schaber from comment #17)
>...
> 4. Does not work either. But it says "No table format could be found", now.
On pc Debian x86-64 with master sources updated today, I indeed reproduce the
error message but if you select Refresh tables, you'll see that the view has
been created.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #17 from Gerhard Schaber  ---
1. and 2. work.
3. still does not work. It tries to create an additional primary key. But
explicitly setting the previous primary key as primary key again does also not
help.
4. Does not work either. But it says "No table format could be found", now.

Tested with:
Version: 6.1.0.0.alpha0+
Build ID: dbf83d315acc454b576355f2e5bd8412586827ac
CPU threads: 8; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-01-07_23:57:11
Locale: de-AT (de_AT); Calc: group threaded

I am glad that the major two issues have been resolved. Thanks.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #16 from Gerhard Schaber  ---
Hello, I can test as soon as there is a new nightly build where these and
related fixes are included. I am having other Firebird unrelated troubles with
with 6.1.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #15 from Tor Lillqvist  ---
I think it would be a good idea to split this bug up into separate individual
easily verifiable bugs, to the extent there are issues left. How many of the
four items in the initial comment are still present?

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

Commit Notification  changed:

   What|Removed |Added

 Whiteboard|target:6.1.0|target:6.1.0 target:6.0.0.2

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #14 from Commit Notification 
 ---
Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-6-0":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=d4469196a2072d2d3fa2e433d02552facaa269f2=libreoffice-6-0

Related tdf#104942: implement setByte on firebird

It will be available in 6.0.0.2.

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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #13 from Lionel Elie Mamane  ---
(In reply to Tor Lillqvist from comment #11)
> As far as I could see, copying the tables from the HSQLDB .odb database in
> Comment #2 into a freshly created empty Firebird .odb database works now in
> master. Resolve as fixed? I will attach the resulting .odb.
> 
> I do se warnings like:
> warn:connectivity.firebird:1905:1905:connectivity/source/drivers/firebird/
> PreparedStatement.cxx:269: firebird_sdbc error:
> *Attempt to reclose a closed cursor
> caused by
> 'isc_dsql_free_statement: close cursor'
> 
> but they are indeed "just" warnings. Should one still be concerned?

They seem to be a sign of incorrect resource management by the Firebird SDBC
driver, so I wouldn't be unhappy to have them understood and fixed. If a cursor
is closed "too early", then it might be closed when still needed.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #12 from Tor Lillqvist  ---
Created attachment 138798
  --> https://bugs.documentfoundation.org/attachment.cgi?id=138798=edit
tested.odb manually "converted" to Firebird by drag-and-dropping the tables

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #11 from Tor Lillqvist  ---
As far as I could see, copying the tables from the HSQLDB .odb database in
Comment #2 into a freshly created empty Firebird .odb database works now in
master. Resolve as fixed? I will attach the resulting .odb.

I do se warnings like:
warn:connectivity.firebird:1905:1905:connectivity/source/drivers/firebird/PreparedStatement.cxx:269:
firebird_sdbc error:
*Attempt to reclose a closed cursor
caused by
'isc_dsql_free_statement: close cursor'

but they are indeed "just" warnings. Should one still be concerned?

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #10 from Commit Notification 
 ---
Julien Nabet committed a patch related to this issue.
It has been pushed to "master":

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

Related tdf#104942: implement setByte on firebird

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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #9 from Julien Nabet  ---
https://cgit.freedesktop.org/libreoffice/core/commit/?id=b3ea7ed747991696b9f02ede14c57f333c28a41b
may help here

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #8 from Gerhard Schaber  ---
Same issue with
libo-master-2017-02-06_00.00.55_LibreOfficeDev_5.4.0.0.alpha0_Win_x86.msi

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

Lionel Elie Mamane  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=51
   ||780

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #7 from Gerhard Schaber  ---
See also #105240 for an issue with inserting rows into a table with auto
generated values.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #6 from m.a.riosv  ---
Few days ago I have reported about to have all field types set up for FB.
https://bugs.documentfoundation.org/show_bug.cgi?id=104734

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #5 from Gerhard Schaber  ---
The most annoying two issues is number 1. This happens with every single row
that is being copied, and you need to confirm a dialog for every single one.

Even, if I create the table manually in the Firebird file, when I try to copy
only the data from the HSQLDB file for the Geschlecht (Gender) table, I get the
following error:
SQL Status: IM001
The driver does not support the function 'XParameters::setByte'.

The reason seems to be TINYINT. Well, since I only use that in 3 places, I can
change that easily in the source file, but then still there is the issue number
1, which makes is nearly impossible to get data over from an HSQLDB file.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #4 from Gerhard Schaber  ---
A related question. Is there a way to access the SQL commands for a Firebird
DB, just like the "database\script" file in an HSQLDB ODB file? That would be
useful for the future, if one has to migrate a database again.

What I will try as workaround is to change the data types of the HSQLDB not
supported by Firebird to supported ones, and then run the commands from the
"database\script" file of the ODB file. This way the indexes would also be
created.

I noticed that indexes are not even copied when I drag a table from one HSQLDB
file to another. So this seems to be a general limitation.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #3 from m.a.riosv  ---
Reproducible.
Version: 5.3.0.1 (x64)
Build ID: 3b800451b1d0c48045de03b5b3c7bbbac87f20d9
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine:
new; 
Locale: es-ES (es_ES); Calc: group

Many field types are not avaible in FB, in some table data are copyed, by
example with "Lehrgangsgruppen" table.

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

--- Comment #2 from Gerhard Schaber  ---
Created attachment 130063
  --> https://bugs.documentfoundation.org/attachment.cgi?id=130063=edit
Sample HSQLDB file

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||miguelangelrv@libreoffice.o
   ||rg
 Ever confirmed|0   |1

--- Comment #1 from m.a.riosv  ---
Please could you attach the HSQLDB file as sample to test?

-- 
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 104942] Conversion HSQLDB to Firebird, Table design issues

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

Summary|Conversion HQSQLDB to   |Conversion HSQLDB to
   |Firebird, Table design  |Firebird, Table design
   |issues  |issues

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