Frequently Asked Questions
Q. I received empty result from runQuery.
A. runQuery is lazy-IO API.
Trying strict API like runQuery' instead of lazy-IO API may help to resolve your problem.
Q. I received “Commands out of sync; …” error of MySQL
A. Lazy-IO API like runQuery may cause not expected sequence of low-level primitives in RDBMs drivers.
Trying strict API like runQuery' instead of lazy-IO API may help to resolve your problem.
ex. Commands out of sync example
Q. I received “Table xxx doesn’t exist” error of MySQL.
A. Table names of SQL are case sensitive in MySQL default configurations on UNIX systems. So, you may want to modify MySQL configuration of system variable ‘lower_case_table_names = 1’. ( MySQL case sensitivity )
Q. I received SQL syntax errors of MySQL or SQLite3 for union statement like rel1 `unionAll` rel2 `unionAll` rel3.
A. The only sub-set SQL syntax support of MySQL or SQLite3 causes this problem.
You can avoid this problem like relation (query $ rel1 `unionAll` rel2) `unionAll` rel3.
There is more detail information at the discussion on this pull-request.