https://bugs.documentfoundation.org/show_bug.cgi?id=145203
Bug ID: 145203
Summary: EDITING:FIREBIRD cannot create a table
Product: LibreOffice
Version: 7.3.0.0 alpha0+ Master
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
You cannot create a table. When opening the design view, when creating a field,
the only field type available is "OTHER". If you scroll down the list of field
types it is empty. If you try to save the table it gives an error.
It is also not possible to create the table with the table creation wizard,
because clicking on it does not work.
Steps to reproduce it:
1. Open Base
2. Select "Create a new database", in "Embedded database", select "Firebird
Embedded".
3. Clic "Finish" and give a name to the new .odb file
4. After the file is open, clic on "Create table in design view"
5. Write something in "Field name", in "Field type" apear "OTHER"
6. Try to select a "Field type", the list is empty.
7. Try to save the table without index, gives an error:
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 29
*)
caused by
'isc_dsql_prepare'
The error is also present if create a new file via "Firebird external" and if
connect to an exiting .fdb file.
Also present if connect to a Firebird server database following the next
stepts:
1. Open Base
2. Select "Connect to an existing database", in the list select "Firebird
External"
3. Clic "Next"
4. In the text box write the connection string, for example,
"localhost:employee" (employee is a registered database).
5. Clic "Next"
6. Clic on "Password requiered". Check connection if you want.
7. Clic "Finish"
8. Give a name to the .odf file
9. Write user and password to open the database
10. The database opens correctly
11. After the file is open, clic on "Create table in design view"
12. Write something in "Field name", in "Field type" apear "OTHER"
13. Try to select a "Field type", the list is empty.
14. Try to save the table without index, gives an error
If the database has tables an you try to edit them, in the "Field type" it is
shown "OTHER" and the dropdown is empty, like when try to create.
Tested with:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 7a001d3706bee453db46fb38c80c17bb84fda4af
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: threaded
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 43a9bf11203ed92096af34ab828501e0218832c7
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded
This error WAS NOT present on:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 93115d2c54d645bcf2f80fde325e3ede39dee4d5
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
