cookieY
[Question] 当数据库中表名大写时，无法正确显示/生成回滚SQL语句。
描述问题 当数据库中的表名为大写字母时，无法正确显示/生成DML语句的工单来回滚SQL语句。
复现 重现该行为的步骤:
- 当表名全部大写时，无法正确显示/生成回滚SQL语句。
期望的结果 正确显示/生成DML语句的工单来回滚SQL语句。
截图
当表名全部大写时，无法正确显示/生成回滚SQL语句。
只需将表名更改为全部小写即可，一切正常
部署方式
- [ ] Docker
环境 (请填写环境信息):
- 操作系统: [e.g. iOS]
- 浏览器 [e.g. chrome, safari]
- 版本号 [e.g. 22]
额外的日志信息 在这里添加有关该问题的所有日志。
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Title: [Question] When the table name in the database is capitalized, the rollback SQL statement cannot be displayed/generated correctly.
Describe the problem When the table name in the database is in uppercase letters, the work order for the DML statement cannot be correctly displayed/generated to roll back the SQL statement.
recurrent Steps to reproduce the behavior:
- When the table name is in all uppercase letters, the rollback SQL statement cannot be displayed/generated correctly.
Desired results Correctly display/generate tickets for DML statements to roll back SQL statements.
screenshot
Rollback SQL statements cannot be displayed/generated correctly when the table name is in all uppercase letters.
Just change the table name to all lowercase and everything should work fine
Deployment method
- [ ] Docker
Environment (please fill in environmental information):
- Operating system: [e.g. iOS]
- Browser [e.g. chrome, safari]
- version number [e.g. 22]
Additional log information Add all logs about the issue here.
我测试了下 这应该是一个 BUG, update 和 delete 操作的时候，无论表名是否大小写都是可以生成回滚SQL语句 insert 就存在大小写敏感问题了 只能是表名是小写才能生成 回滚SQL语句
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
I tested this and it should be a BUG. During the update operation, the rollback SQL statement can be generated regardless of whether the table name is uppercase or lowercase. Insert has a case-sensitive problem and can only generate the rollback SQL statement if the table name is lowercase.