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

不支持查询分区表 #612

Open
viper-sina-info opened this issue Oct 13, 2023 · 1 comment
Open

不支持查询分区表 #612

viper-sina-info opened this issue Oct 13, 2023 · 1 comment

Comments

@viper-sina-info
Copy link

viper-sina-info commented Oct 13, 2023

描述
查询分区表的时候报错?

重现

  • 执行
    select order_no from user_wallet_log partition(p10);

  • 报错
    无法校验查询语句权限,请联系管理员,错误信息:line 1 column 75 near "partition(p10)"

  • 错误日志详情
    [2023-10-13 09:32:07,130][MainThread:139625455327040][task_id:default][query_privileges.py:94][ERROR]- 无法校验查询语句权限,me,select order_no from user_wallet_log partition(p10);,Traceback (most recent call last): File "/opt/app/sql/query_privileges.py", line 73, in query_priv_check table_ref = _table_ref(sql_content, instance, db_name) File "/opt/app/sql/query_privileges.py", line 485, in _table_ref query_tree = engine.query_print( File "/opt/app/sql/engines/goinception.py", line 186, in query_print raise RuntimeError(print_info.get("errmsg")) RuntimeError: line 1 column 75 near "partition(p10)"

环境

  • 数据库: [mysql/mariadb]
  • 版本: 5.7.31
  • archery版本: v1.10.0
  • goInception版本:v1.3.0-76-g4082e7a

参数
新增了参数enable_partition_table= true 也不行
[inc]
backup_host = "127.0.0.1"
backup_port = 3306
backup_user = "goinception"
backup_password = "xxxxxx"

enable_alter_database = false
enable_zero_date = true
enable_nullable = true
enable_drop_table = false
enable_set_engine = true
enable_timestamp_type=true
enable_change_column = true

check_timestamp_count = true
check_table_comment = false
check_column_comment = false

check_float_double = false
check_identifier_upper = false
check_identifier_lower = false
check_read_only = true
enable_partition_table= true

@zmix999
Copy link

zmix999 commented Feb 21, 2024

可以看下我fork分支,修复了这个问题https://gitee.com/zhoujin826/goInception

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants