Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Valid SQL query won't save

I have a SQL query which executes fine in "Tools" | "SQL..." If I go to "Queries" "Create Query in SQL View..." and enter the exact same text, it fails to save with a syntax error "SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE" Any idea why it works in one place but not the other?

Valid SQL query won't save

I have a SQL query which executes fine in "Tools" | "SQL..." If I go to "Queries" "Create Query in SQL View..." and enter the exact same text, it fails to save with a syntax error "SQL Status: HY000 Error code: 1000 syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE" Any idea why it works in one place but not the other?other? I should add that I'm using LO 6.1.3.2 (x64) on Windows 10 Pro x64, version 1809.