Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[ bug ] 解析表出错或者表不存在,无法展示表信息 #843

Closed
dongqianzheng opened this issue Aug 4, 2020 · 1 comment
Closed
Labels
bug Something isn't working

Comments

@dongqianzheng
Copy link
Contributor

优化工具-sql tuning 分析结果报错。

重现步骤

  1. lower_case_table_names=0
    2.创建一个表名为大写的表

期待结果和实际结果

实际结果:
image

错误日志

[2020-08-04 18:49:59,319][DummyThread-4:139942869869776][task_id:default][mysql.py:141][WARNING]- MySQL语句执行报错,语句:show create table dong;,错误信息Traceback (most recent call last):
File "/usr/local/archery/sql/engines/mysql.py", line 130, in query
effect_row = cursor.execute(sql)
File "/opt/python3/lib/python3.7/site-packages/MySQLdb/cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "/opt/python3/lib/python3.7/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
raise errorvalue
File "/opt/python3/lib/python3.7/site-packages/MySQLdb/cursors.py", line 247, in execute
res = self._query(query)
File "/opt/python3/lib/python3.7/site-packages/MySQLdb/cursors.py", line 412, in _query
rowcount = self._do_query(q)
File "/opt/python3/lib/python3.7/site-packages/MySQLdb/cursors.py", line 375, in _do_query
db.query(q)
File "/opt/python3/lib/python3.7/site-packages/MySQLdb/connections.py", line 276, in query
_mysql.connection.query(self, query)
_mysql_exceptions.ProgrammingError: (1146, "Table 'for_incep_t.dong' doesn't exist")

版本信息

应用版本/分支:
v1.7.4
部署方式:手工部署

是否是大小写转换,导致找不到这张表。

@hhyo hhyo added the bug Something isn't working label Aug 5, 2020
@hhyo
Copy link
Owner

hhyo commented Aug 5, 2020

已确认,在表解析时做了小写转换,下版本修复

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants