IBM Cognos fails to work with MariaDB with Optional Feature is not implemented error

1. Installed ODBC1.0.5 64 bit driver and created a System DSN
2. Trying to run a simple select statement using attached sample.java program and it works fine. However if I give 2 spaces just before SELECT clause then it couldn't execute the query. Refer screenshot1.

3. When I try to execute a query using IBM Cognos Framework manager reporting tool, I see the below error even for a simple "select * from table" query
Refer screenshot2.

4. When I try to query using Tableau reporting tool, I see the following warnings,
Refer screenshot3.