Haskell Relational Record

Frequently Asked Questions

View project on GitHub

Frequently Asked Questions

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.