Test tableau with go-mysql-server and add integration tests with the queries used by the application itself.

[ajnavarro]

[kuba--]

So far it doesn't work. If you try to connect to the localhost you'll get:

[MySQL][ODBC 5.3(w) Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unable to connect to the server "localhost". Check that the server is running and that you have access privileges to the requested database.

For 127.0.0.1:

An error occurred while communicating with MySQL.

Bad Connection: Tableau could not connect to the data source.
[MySQL][ODBC 5.3(w) Driver][mysqld-5.5.10-Vitess][MySQL][ODBC 5.3(w) Driver]unknown error: unsupported syntax: &sqlparser.Default{ColName:""}
Unable to connect to the server "127.0.0.1". Check that the server is running and that you have access privileges to the requested database.

When it tried to connect it executes following queries:

### DEBU[0459] executing query                               query="SET NAMES utf8"
### DEBU[0459] executing query                               query="SET character_set_results = NULL"
### DEBU[0459] executing query                               query="SET SQL_AUTO_IS_NULL = 0"
### DEBU[0459] executing query                               query="set @@sql_select_limit=DEFAULT"

[erizocosmico]

I believe the error must be at SET NAMES utf8. The rest of them should be supported.

[kuba--]

Actually the error comes from:
set @@sql_select_limit=DEFAULT
DEFAULT is unknown. I'll have to add DEFAULT expression.

[kuba--]

Following queries:

DEBU[0051] executing query                               query="DROP TABLE `#Tableau_01_sid_00000001_1_Connect`"
DEBU[0158] executing query                               query="SELECT CONNECTION_ID()"
DEBU[0158] executing query                               query="show variables like 'collation_server'"
DEBU[0158] executing query                               query="SELECT `table_name`, `column_name`\nFROM `information_schema`.`columns`\nWHERE `data_type`='enum' AND `table_schema`=''"
DEBU[0158] executing query                               query="SHOW DATABASES LIKE '%'"

We have to return some default db

[kuba--]

• Database name cannot be empty
• After select DB, we need to support following queries (ignore git - it was my test/fake db):

EBU[0048] executing query                               query="SELECT CONNECTION_ID()"
DEBU[0048] executing query                               query="SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM ( SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA LIKE 'git' AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) ) TABLES "
DEBU[0048] executing query                               query="SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM ( SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA LIKE 'git' AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) ) TABLES "
DEBU[0048] executing query                               query="SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM ( SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA = DATABASE() AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) ) TABLES "
DEBU[0048] executing query                               query="SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM ( SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA = DATABASE() AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) ) TABLES "
DEBU[0048] executing query                               query="show variables like 'collation_server'"
DEBU[0048] executing query                               query="SELECT `table_name`, `column_name`\nFROM `information_schema`.`columns`\nWHERE `data_type`='enum' AND `table_schema`='git'"
DEBU[0048] executing query                               query="DROP TABLE `#Tableau_01_sid_00000002_1_Connect`"
DEBU[0048] executing query                               query="SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM ( SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA LIKE 'git' AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) ) TABLES "
DEBU[0048] executing query                               query="SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM ( SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA LIKE 'git' AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) ) TABLES "
DEBU[0048] executing query                               query="SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM ( SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA = DATABASE() AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) ) TABLES "
DEBU[0048] executing query                               query="SELECT TABLE_NAME, TABLE_COMMENT, TABLE_TYPE, TABLE_SCHEMA FROM ( SELECT * FROM INFORMATION_SCHEMA.TABLES  WHERE TABLE_SCHEMA = DATABASE() AND ( TABLE_TYPE='BASE TABLE' OR TABLE_TYPE='VIEW' ) ) TABLES "

[kuba--]

This issue depends on following sub-tasks:

• [Tableau] - Support DEFAULT expression #487
• [Tableau] - default db name cannot be an empty string #488
• [Tableau] - support for INFORMATION_SCHEMA.TABLES queries #489
• [Tableau] - Support for sql_select_limit #492
• [Tableau] - support for DATABASE() function #503
• Move TABLES to non-keywords. vitessio/vitess#4313
• [Tableau]: Add support for information_schema.columns #510
• [Tableau] - add support for GROUP BY X #520
• [Tableau]: GROUP BY X with alias (as columnd name) and INNER JOIN #535