To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75557 Issue #|75557 Summary|Combination of LIKE and LOWER does not work when query |ing Calc database Component|Database access Version|OOo 2.2 RC3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|mux2005
------- Additional comments from [EMAIL PROTECTED] Tue Mar 20 12:34:38 +0000 2007 ------- I've created a database that references a Calc document. I get an "Invalid Statement" error trying to use the following SQL statement SELECT "Tabelle1"."A" AS "A", "Tabelle1"."B" AS "B", "Tabelle1"."C" AS "C" FROM "Tabelle1" AS "Tabelle1" WHERE ( LOWER ( "Tabelle1"."A" ) LIKE 'g%' ) The same statement works fine on a HSQL database. If I either remove the "LOWER" or replace "LIKE" with "=" the statement works on the Calc database. So apparently it is the combination of LIKE and LOWER that the Calc database can't process. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
