https://bugs.documentfoundation.org/show_bug.cgi?id=104942
Bug ID: 104942
Summary: Table design issues
Product: LibreOffice
Version: 5.3.0.0.beta2
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: gerhard.scha...@gmx.at
The Firebird support is much better now, but there are still some table design
related issues.
I am trying to move a HSQLDB based file to a Firebird based file, because I
consider Firebird better and faster. I just drag tables from one base document
to the other, but have a couple of issues to get the table design over to the
Firebird based file.
1. The definition is copied, but not the table data, nor the indexes.
Error code: 1
firebird_sdbc error:
*Attempt to reclose a closed cursor
caused by
'isc_dsql_free_statement: close cursor'
2. All auto increment fields of the source document become normal fields in the
Firebird base file.
3. When I then change the auto increment from No to Yes, I get the error:
SQL Status: IM001
Changing autoincrement property of existing column is not supported
4. When I try to create a view from a query (right-click, select Create as
View), then I get the following error.
Error code: 1
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 397
*(
caused by
'isc_dsql_prepare'
This issue is slightlyrelated to bug #103715.
--
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