Warnings are not cleared

[dveeden]

Bug Report

Warnings are not always cleared as expected

1. Minimal reproduce step (Required)

VALUES ( ('foo'), ROW('bar') );
SHOW WARNINGS;
VALUES ( ('foo'), ROW('bar') );
SHOW WARNINGS;
VALUES ( ('foo'), ROW('bar') );
SHOW WARNINGS;

2. What did you expect to see? (Required)

Errors being cleared after every statement.

3. What did you see instead (Required)

mysql-8.0.11-TiDB-v8.5.0> VALUES ( ('foo'), ROW('bar') );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )" 
mysql-8.0.11-TiDB-v8.5.0> SHOW WARNINGS;
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                                                                                                  |
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Error | 1054 | Unknown column '$$' in 'field list'                                                                                                                                      |
| Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )"  |
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql-8.0.11-TiDB-v8.5.0> VALUES ( ('foo'), ROW('bar') );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )" 
mysql-8.0.11-TiDB-v8.5.0> SHOW WARNINGS;
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                                                                                                  |
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Error | 1054 | Unknown column '$$' in 'field list'                                                                                                                                      |
| Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )"  |
| Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )"  |
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.01 sec)

mysql-8.0.11-TiDB-v8.5.0> VALUES ( ('foo'), ROW('bar') );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )" 
mysql-8.0.11-TiDB-v8.5.0> SHOW WARNINGS;
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                                                                                                  |
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Error | 1054 | Unknown column '$$' in 'field list'                                                                                                                                      |
| Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )"  |
| Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )"  |
| Error | 1064 | You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )"  |
+-------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)

4. What is your TiDB version? (Required)

Release Version: v8.5.0
Edition: Community
Git Commit Hash: d13e52ed6e22cc5789bed7c64c861578cd2ed55b
Git Branch: HEAD
UTC Build Time: 2024-12-18 02:26:06
GoVersion: go1.23.3
Race Enabled: false
Check Table Before Drop: false
Store: tikv

Related

• VALUES statement is not supported #21486
• SELECT $$ from MySQL Client leads to errors in the logs #53753

[dveeden]

mysql-8.0.11-TiDB-v8.5.0> \W
Show warnings enabled.
mysql-8.0.11-TiDB-v8.5.0> VALUES ( ('foo'), ROW('bar') );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )" 
Error (Code 1054): Unknown column '$$' in 'field list'
Error (Code 1064): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )" 
mysql-8.0.11-TiDB-v8.5.0> VALUES ( ('foofoo'), ROW('barbar') );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foofoo'), ROW('barbar') )" 
Error (Code 1054): Unknown column '$$' in 'field list'
Error (Code 1064): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )" 
Error (Code 1064): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foofoo'), ROW('barbar') )" 
mysql-8.0.11-TiDB-v8.5.0> VALUES ( ('foofoofoo'), ROW('barbarbar') );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foofoofoo'), ROW('barbarbar') )" 
Error (Code 1054): Unknown column '$$' in 'field list'
Error (Code 1064): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foo'), ROW('bar') )" 
Error (Code 1064): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foofoo'), ROW('barbar') )" 
Error (Code 1064): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 8 near "( ('foofoofoo'), ROW('barbarbar') )" 
mysql-8.0.11-TiDB-v8.5.0> 

[YangKeao]

If an error occured before (s *session) ExecuteStmt, the warnings are not cleared. It's because currently TiDB refreshes the warning in ExecuteStmt -> ResetContextOfStmt -> Reset. We may need to add some ugly logic to fix this issue. Let me fix it.