Skip to content

MySQL00140规则【建议对表、视图等对象进行操作时指定库名】优化 #2961

Open
@waterdrink

Description

@waterdrink

版本信息(Version)

v4.25.02

问题描述(Describe)

针对sql:

SELECT CASE WHEN ( `BIRD.T1`.`SEX` = 'F' AND `BIRD.T2`.`UA` > 6.5 ) OR ( `BIRD.T1`.`SEX` = 'M' AND `BIRD.T2`.`UA` > 8.0 ) THEN TRUE ELSE FALSE END FROM `BIRD.Patient` AS `T1` INNER JOIN `BIRD.Laboratory` AS `T2` ON `BIRD.T1`.`ID` = `BIRD.T2`.`ID` WHERE `BIRD.T1`.`ID` = 57266;

期望不触发规则00140【建议对表、视图等对象进行操作时指定库名】,实际触发了

截图或日志(Log)

如何复现(To Reproduce)

问题原因

解决方案

变更影响面

受影响的模块或功能

外部引用的潜在问题或风险

版本兼容性

测试建议

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions