https://bz.apache.org/ooo/show_bug.cgi?id=126029
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|CONFIRMED |RESOLVED --- Comment #16 from [email protected] --- The syntax error is on the user's side: missing space before "and" and table name not quoted. As for the serious problem here, where table and column name were not getting quoted, leading to an error creating the query, patch was committed in revision 1713164: #i126029# Base query wizard error due to missing quoting of table and column names During the Base query design wizard, com.sun.star.wizards.ui.FilterComponent.getFilterConditions() calls com.sun.star.wizards.db.SQLQueryComposer.getSelectClause() before its getFromClause(). However the getSelectClause() needs composedCommandNames which is populated only by getFromClause() in order to quote table and column names. Without this, table and column names that need quoting (spaces, special characters, reserved words) produce errors. Resolving fixed. -- You are receiving this mail because: You are the assignee for the issue.
