https://bugs.documentfoundation.org/show_bug.cgi?id=120310
--- Comment #7 from Alex Thurgood <[email protected]> ---
Testing with embedded firebird ODB file :
I can enter an apostrophe or single quote mark in a field name string and it
will be saved.
If I attempt to enter a single "double-quote" mark in the field name, and then
try to save the table, an error message is displayed:
Error code: 1
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 79
*" VARCHAR(100), PRIMARY KEY ("
caused by
'isc_dsql_prepare'
The table can not be saved in this form.
Seems to me that this is working as designed.
Irrespective of the discussion on whether people should be using such special
characters for naming of their fields in a db, what exactly is the problem ?
Seems to me that the problem is one of an ambiguous error message from the db
engine (possibly truncated by LO) when the user actually attempts to do
something not normally accepted as standard SQL.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
