https://bugs.freedesktop.org/show_bug.cgi?id=66130
Terrence Enger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Ever confirmed|0 |1 --- Comment #7 from Terrence Enger <[email protected]> --- Short version: I see an error, maybe the reported error or maybe not, without going near any time-related column. Workaround suggested. Long version ... I am setting bug status NEW, but this is merely a guess, as Fernand does not tell us exactly what error he saw. If his error is the error that I see, then the bug summary should be changed to not reference MySQL. So, for specificity, let me say that in a quite different environment, I issued SQL statement select * from Table1 a join Table2 b on a.number like '0%' and LibreOffice presented a dialog Syntax error in SQL statement with <More> revealing SQL Status:HY000, Error code: 1000, and further descriptions ... Syntax error in SQL statement SELECT * FROM "Table1" "a" JOIN "Table2" "b" ON LIKE '0%' Syntax error in SQL statement Note that the second of these further descriptions omits the variable before the LIKE operator. For comparison, `isql` accepts and processes my sql statement correctly, and LibreOffice accepts and processes correctly the statement select * from Table1 a join Table2 b on a.number = b.number where a.number like '0%' This suggests a workaround for the error. My .odb file uses an ODBC connection to PostgreSQL, and my Libreoffice (which no longer has the crash reported in bug 65619 "segfault querying spreadsheet with LIKE criterion" and bug 65653 "EDITING: Base crashes with queries with keyword LIKE in GUI-Mode") is master commit 60e2096, pulled 2013-06-18, configured with --enable-option-checking=fatal --enable-dbgutil --enable-crashdump --without-system-postgresql --without-myspell-dicts --without-help --with-extra-buildid --without-doxygen built and executing ubunty-natty (11.04) 32-bit. HTH, Terry. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
