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.

Sign up for GitHub

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

Jump to bottom

doris和starrocks报错 #2589

Closed
xiehaitang opened this issue Apr 16, 2024 · 2 comments · Fixed by #2602
Closed

doris和starrocks报错 #2589

xiehaitang opened this issue Apr 16, 2024 · 2 comments · Fixed by #2602

Comments

@xiehaitang
Copy link

xiehaitang commented Apr 16, 2024 •
edited
Loading

重现步骤

查询starrocks 点击查看表结构出现的异常
image
查询doris点击查看表结构出现的异常
image

预期外的结果

正常应该和mysql一样不报错

日志文本

No response

版本

1.10.0

部署方式

Docker

是否还有其他可以辅助定位问题的信息？比如数据库版本等

No response
@Grain-Yu
Copy link
Contributor

请问实例创建的时候，数据库类型是MySQL还是doris？

@xiehaitang
Copy link
Author

1、我数据库类型使用的是doris。
第一个图是starrocks 报错的内容，starrocks 使用的是3的版本
第二个图是doris报错的内容，doris版本是1.13

2、我在1.8.5的时候，使用的是mysql，只是我更改query_privileges.py文件：if instance.db_type == 'mysql' and instance.instance_name != 'doris':

@xiehaitang xiehaitang changed the title 请对问题进行简要的描述 doris和starrocks报错 Apr 17, 2024
Grain-Yu added a commit to Grain-Yu/Archery that referenced this issue Apr 21, 2024
@Grain-Yu
修复doris表结构查询异常
3795ab4 
fix: hhyo#2589
优化MysqlEngine与doris的兼容性：
doris中，带变量的sql语句，不支持“WHERE TABLE_SCHEMA = %(db_name)s” 的写法。
@Grain-Yu Grain-Yu mentioned this issue Apr 21, 2024
Merged
LeoQuote pushed a commit that referenced this issue Apr 22, 2024
@Grain-Yu
修复doris表结构查询异常 (#2602)
5e073aa 
fix: #2589
优化MysqlEngine与doris的兼容性：
doris中，带变量的sql语句，不支持“WHERE TABLE_SCHEMA = %(db_name)s” 的写法。
xxlaila pushed a commit to xxlaila/Archery that referenced this issue Feb 15, 2025
@Grain-Yu
修复doris表结构查询异常 (hhyo#2602)
b127da8 
fix: hhyo#2589
优化MysqlEngine与doris的兼容性：
doris中，带变量的sql语句，不支持“WHERE TABLE_SCHEMA = %(db_name)s” 的写法。
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

修复doris表结构查询异常 Grain-Yu/Archery
2 participants
@Grain-Yu @xiehaitang