[Bug]: cant see cloumns when connecting to superset

cyann7 commented 1 year ago

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):1.0.0-rc
- Hardware parameters:
- OS type:windows-wsl-ubuntu22.04
- Others:

Actual Behavior

when I use superset to connect to MO, superset can't show columns of a table.

The error statement is " select FROM test.users LIMIT 101", there is no * after select.

Expected Behavior

it's mysql.

Steps to Reproduce

set up superset,and add a database ->choose mysql-> connect to MO-> to superset/SQL lab ->choose a table

Additional information

https://superset.apache.org/docs/databases/mysql

superset also said there may be some problem with mysql connector mysqlclient , users can try to use mysql-connector-python, I tried but failed in some error.

m-schen commented 1 year ago

麻烦确认一下是否语句确实是 select FROM test.users LIMIT 101 如果是的话，我认为报语法错误是合理的。

cyann7 commented 1 year ago

@m-schen 这确实是个语法错误，这里的疑问是为什么会出现这个语法错误呢，我尝试了mysql，并没有出现这个错误。

daviszhen commented 1 year ago

还没看

fengttt commented 1 year ago

Not a bug. This is a superset bug (it generated wrong sql) and MySQL bug (it should have rejected wrong sql).

That said, we may consider to add a mysql_compatibility_mode flag like select_allow_missing_star.

daviszhen commented 1 year ago

还没看

daviszhen commented 1 year ago

还没看

daviszhen commented 1 year ago

还没看

daviszhen commented 1 year ago

还没看

daviszhen commented 1 year ago

还没看

daviszhen commented 1 year ago

还没看

daviszhen commented 10 months ago

未投入

daviszhen commented 10 months ago

未投入

daviszhen commented 10 months ago

未投入

daviszhen commented 9 months ago

未投入

daviszhen commented 9 months ago

未投入

daviszhen commented 9 months ago

未投入

daviszhen commented 9 months ago

未投入