zhang

Results 23 comments of zhang

https://github.com/actiontech/sqle/issues/589

UI Version: release-1.2207.x 92b44b8 Server Version: release-1.2207.x-ee 018349a02a 复现步骤: 1.admin用户创建一个审核任务 2.然后创建test用户并赋予所有权限 3.切换到test用户,然后对admin用户创建的审核任务进行修改,出现报错 ![image](https://user-images.githubusercontent.com/54339501/187114446-69f707c0-e597-43cd-86d0-d1c9676f473a.png)

验证版本: UI Version: main d965f85 Server Version: main-ee acc51031d3 验证步骤: 1.admin用户创建一个扫描任务 2.然后创建test用户并赋予所有权限 3.切换到test用户,然后对admin用户创建的审核任务进行修改,无其他报错信息,可正常修改 ![image](https://user-images.githubusercontent.com/54339501/187842383-a34d22bc-ed1a-41dc-9389-7f5b862da9de.png) ![image](https://user-images.githubusercontent.com/54339501/187842332-fdddc5a8-292c-4471-ad4c-74fcd035b7a5.png) ![image](https://user-images.githubusercontent.com/54339501/187842481-dfd93bfb-26f1-45a8-97ec-1f6ae0a8f598.png)

复现版本: Server Version: release-1.2207.x-ee 018349a02a 复现步骤: 1.开启该项 `SET GLOBAL sql_mode = 'ANSI_QUOTES';` 2.使用以下sql语句进行审核,出现错误提示 `select TABLE_NAME from information_schema.tables where table_schema="dcisdb02" and TABLE_TYPE in ("BASE TABLE","SYSTEM VIEW");` ![image](https://user-images.githubusercontent.com/54339501/188102763-f5c49be0-558f-43b3-88bb-d025535d05c9.png)

验证版本: Server Version: main-ee c233f3efea 验证步骤: 1.开启该项 `SET GLOBAL sql_mode = 'ANSI_QUOTES';` 2.使用以下sql语句进行审核,正常审核 `select TABLE_NAME from information_schema.tables where table_schema="dcisdb02" and TABLE_TYPE in ("BASE TABLE","SYSTEM VIEW");` ![image](https://user-images.githubusercontent.com/54339501/188103349-04af7d3c-55bb-47d7-8c32-a2aac24a9dd8.png)

UI Version: release-1.2207.x 92b44b8 Server Version: release-1.2207.x-ee 018349a02a 复现步骤: 1.根据上述表结构创建好mysql表 2.然后根据上述的UPDATE语句去审核,然后出现字段不存在的报错 ![image](https://user-images.githubusercontent.com/54339501/187147127-39334f9e-984a-49b4-a57a-ee1c9c1aefad.png)

验证版本: UI Version: main b4bfb8d Server Version: main-ee 3c255f3b01 验证步骤: 1.根据上述表结构创建好mysql表 2.然后根据上述的UPDATE何delete语句去审核,未出现字段不存在的报错 ![image](https://user-images.githubusercontent.com/54339501/187822961-ff128fc1-fb0f-4def-9566-e9d8356f64ab.png) ![image](https://user-images.githubusercontent.com/54339501/187822988-bc22c4c5-8083-401a-b0f7-b6521b25473b.png)

复现版本 UI Version: main 2a0b15e Server Version: main-ee 06950e07b6 复现步骤: 1.系统设置,添加一个邮箱和密码 2.查看mysql里面的表,发现密码被明文记录 ![image](https://user-images.githubusercontent.com/54339501/183351702-bbe0d938-5a72-4389-b2e8-bdc6b8b92492.png)