Mongosqld gives a sql parse error when using a Mongo view. The view can be seen in MySQL and queried and gives results, but also an error:
dispatch error: ERROR 1064 (42000): parse sql ‘SELECT TABLE_NAME, CHECK_OPTION, IS_UPDATABLE, DEFINER, SECURITY_TYPE FROM information_schema.VIEWS WHERE BINARY TABLE_SCHEMA=‘WNP’ AND BINARY TABLE_NAME=‘lababcde-wp’ ORDER BY TABLE_NAME’ error: unexpected BINARY at position 114 near binary
It must be the word BINARY. MySQL does not understand this.
How can I solve this?
Thanks, Klaasjan