You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When I executed the query_text sent by the Trino MySQL connector recorded by databend when executing the 'desc table' command, I did indeed obtain two records
The original query statement of the Trino MySQL connector is as follows: SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, CASE WHEN (TABLE_TYPE = 'BASE TABLE') THEN CASE WHEN ((TABLE_SCHEMA = 'mysql') OR (TABLE_SCHEMA = 'performance_schema')) THEN 'SYSTEM TABLE' ELSE 'TABLE' END WHEN (TABLE_TYPE = 'TEMPORARY') THEN 'LOCAL_TEMPORARY' ELSE TABLE_TYPE END AS TABLE_TYPE, TABLE_COMMENT AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION FROM INFORMATION_SCHEMA.TABLES WHERE ((TABLE_SCHEMA = 'trino') AND (TABLE_NAME = 't1')) HAVING TABLE_TYPE IN('TABLE', 'VIEW', NULL, NULL, NULL) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME
Whose problem is this exactly? Is it the Trino MySQL connector or Databend? I also raised the same issue on the Trino GitHub issues page,trinodb/trino#17985
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
When I executed the query_text sent by the Trino MySQL connector recorded by databend when executing the 'desc table' command, I did indeed obtain two records
The original query statement of the Trino MySQL connector is as follows:
SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, CASE WHEN (TABLE_TYPE = 'BASE TABLE') THEN CASE WHEN ((TABLE_SCHEMA = 'mysql') OR (TABLE_SCHEMA = 'performance_schema')) THEN 'SYSTEM TABLE' ELSE 'TABLE' END WHEN (TABLE_TYPE = 'TEMPORARY') THEN 'LOCAL_TEMPORARY' ELSE TABLE_TYPE END AS TABLE_TYPE, TABLE_COMMENT AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION FROM INFORMATION_SCHEMA.TABLES WHERE ((TABLE_SCHEMA = 'trino') AND (TABLE_NAME = 't1')) HAVING TABLE_TYPE IN('TABLE', 'VIEW', NULL, NULL, NULL) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME
Whose problem is this exactly? Is it the Trino MySQL connector or Databend? I also raised the same issue on the Trino GitHub issues page,trinodb/trino#17985
Beta Was this translation helpful? Give feedback.
All reactions