We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
SQLe Version v3 Describe the bug 开启规则禁止对联合索引左侧字段进行IN 、OR等非等值查询;对下图中的sql审核没有触发规则
将子查询中的语句单独拎出来审核,可以触发规则
目前看该规则没有覆盖子查询,期望可以覆盖子查询的情况 To Reproduce
Expected behavior
Suggestion
The text was updated successfully, but these errors were encountered:
No branches or pull requests
SQLe Version
![image](https://private-user-images.githubusercontent.com/53266479/294092378-9873b435-83ea-48ed-a156-9480f4bb8a12.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQwMTE2NjMsIm5iZiI6MTcyNDAxMTM2MywicGF0aCI6Ii81MzI2NjQ3OS8yOTQwOTIzNzgtOTg3M2I0MzUtODNlYS00OGVkLWExNTYtOTQ4MGY0YmI4YTEyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MTglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODE4VDIwMDI0M1omWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWE2OWY5ODFmMzg2MDYxNzAyOTY3Y2VkNTE4NzUyMzBhY2QzMDg2M2E0NzhiYjMzMjBiYjZmNDY0MDk3ZTBiNjYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.3uN7ji8_Hs7StDDj8vCydbwtaejI-PUl6UCpTyyqmA4)
v3
Describe the bug
开启规则禁止对联合索引左侧字段进行IN 、OR等非等值查询;对下图中的sql审核没有触发规则
将子查询中的语句单独拎出来审核,可以触发规则
![image](https://private-user-images.githubusercontent.com/53266479/294092457-f740fac2-0e7f-4093-8ada-a96ff2a3c0c6.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQwMTE2NjMsIm5iZiI6MTcyNDAxMTM2MywicGF0aCI6Ii81MzI2NjQ3OS8yOTQwOTI0NTctZjc0MGZhYzItMGU3Zi00MDkzLThhZGEtYTk2ZmYyYTNjMGM2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MTglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODE4VDIwMDI0M1omWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTY4ZDNiNzM2ZjBkMmE0NzFhM2U3MmM4Nzc5YzZiZWUyNmJiNGUyNDk2MzhjMWI2ZjVkZWE3ZjVlYzgzNmEwNGEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.vrtAdIJiqixXohxMJ0TXhTigcl_zcaYLbYxCa-tCDAA)
目前看该规则没有覆盖子查询,期望可以覆盖子查询的情况
To Reproduce
Expected behavior
Suggestion
The text was updated successfully, but these errors were encountered: