https://bugs.freedesktop.org/show_bug.cgi?id=82573
Lionel Elie Mamane <lio...@mamane.lu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #2 from Lionel Elie Mamane <lio...@mamane.lu> ---
HSQLDB converts identifiers (names) that are not quoted to all caps. An
identifier that is not all caps should be quoted. That is, your statement
should be
ALTER TABLE "SeriesInformation" ADD CONSTRAINT MYCONSTRAINT UNIQUE
("MainSeriesName")
See http://hsqldb.org/doc/1.8/guide/ch09.html, SQL Expression / Components of
SQL Expressions / name:
A unquoted identifier (name) starts with a letter and is followed by any number
of ASCII letters or digits. When an SQL statement is issued, any lowercase
characters in unquoted identifiers are converted to uppercase. Because of this,
unquoted names are in fact ALL UPPERCASE when used in SQL statements.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
