Apache OpenOffice (AOO) Bugzilla – Issue 44200
HSQLDB Tables names aren't case sensitive, tables names in SQL are case sensitive
Last modified: 2006-10-20 13:03:11 UTC
Hi, I'm using the database application and I find something curious. I can't create two tables with the same name, one in upper case and the other with lower case. Ok, for this reason I thougth tables names aren't case sensitive. (like oracle, postgresql, mysql ...) But when I create querys in SQL View, the tables names are case sensitive. For this reason, if I create a table named TABLE, the following query fails: SELECT * FROM table; In my opinnion, this shouldn't be the normal behavior and it should be treated like a bug. Regards, Xevi.
Hello xevivi, are you creating the tables in a hsqldb or in another database (f.e. mysql)? Max
Hello Max, I create the tables in hsqldb, using the default OpenOffice.org installation. Regards, Xevi.
will check the spec
checked table_wizard.sxw, found nothing useful. confirm behaviour. marc, can you decide on this issue?
should be fixed with issue 41785
first set the target to "Office Later" second I send it to the right developer. msc -> oj: I can reproduce this with hsqldb. Can we change anything in this behaviour?
reassign
*** Issue 52997 has been marked as a duplicate of this issue. ***
Fixed in cws dba30
fs-> msc: please verify in CWS dba30 re-open issue and reassign to msc
reassign to msc
reset resolution to FIXED
targeting to 2.0.4, as the fix is already available, and has meanwhile been checked in in a 2.0.4-CWS
this used to work in some recent build -> keyword "regression"
verified in CWS dba30 find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba30
targeting to 2.1, since the fix is part of a CWS aiming for this release
Hi, this is fixed in the current master. The current master is available at http://download.openoffice.org/680/index.html I close this issue now. Bye Marc