mysql协议中的测试bug

[jd-zhang]

Issue migrated from trac ticket # 839

component: Testing | priority: major

2022-06-20 16:11:40: vito@zettadb.com created the issue

---

一共存在32个失败:

其中需要创建test就可以运行成功的14个:

test_wl12475
test_wl13510_multi_statements
test_bug31048553 
test_bug31082201
test_bug20821550 
test_wl8754
test_bug22028117
test_bug17309863
test_bug17512527
test_opt_reconnect
test_bug12744
test_bug12001
test_bug5315
test_bug38486  增加-B就会失败

剩下的18个是:

test_wl11772
test_bug19894382
test_bug11766854
test_bug56976
test_bug40365
test_bug28075
test_bug32265
test_bug19671
test_bug15613
test_bug14210
test_bug11183
test_bug9735
test_bug8722
test_bug6761
test_bug6096
test_bug3035
test_bug1500
test_bug1115

test_bug1115

[MySQL-8.0.26-16-kunlun-storage-debug][1292] Incorrect datetime value: '1965' for column 'd' at row 1
mysql_client_test.cc:2191: check failed: 'r == 0'

test_bug1500

mysql_client_test.cc:8477: check failed: 'stmt != 0'

test_bug3035

 [MySQL-8.0.26-16-kunlun-storage-debug][1264] Out of range value for column 'i8' at row 1
mysql_client_test.cc:9591: check failed: 'rc == 0'

test_bug6096

[MySQL-8.0.26-16-kunlun-storage-debug][1060] Duplicate column name 'c_smallint'
mysql_client_test.cc:11620: check failed: 'r == 0'

test_bug6761

[MySQL-8.0.26-16-kunlun-storage-debug][1050] Table 't1' already exists
mysql_client_test.cc:12355: check failed: 'r == 0'

test_bug8722

[MySQL-8.0.26-16-kunlun-storage-debug][1050] Table 'v1' already exists
mysql_client_test.cc:12657: check failed: 'r == 0'

test_bug9735

 length   :`262140`  (expected: `67108860`)
mysql_client_fw.cc:756: check failed: 'strcmp(field->db, db) == 0'

test_bug11183

 [MySQL-8.0.26-16-kunlun-storage-debug][1136] Column count doesn't match value count at row 1
mysql_client_test.cc:13549: check failed: 'rc == 0'

test_bug14210

[MySQL-8.0.26-16-kunlun-storage-debug][1406] Data too long for column 'a' at row 1
mysql_client_test.cc:14197: check failed: 'r == 0'

test_bug15613

 check failed: 'field[1].length == 255'

test_bug19671

check failed: 'strcmp(field->db, db) == 0'

test_bug32265

 check failed: 'strcmp(field->db, "client_test_db") == 0'
 

test_bug28075

mysql_client_test.cc:15593: check failed: 'rc == 0'

test_bug40365

 [MySQL-8.0.26-16-kunlun-storage-debug][1292] Incorrect datetime value: '2009-02-29 00:00:00' for column 'c1' at row 1
 mysql_client_test.cc:17279: check failed: 'rc == 0'

test_bug56976

mysql_client_test.cc:18084: check failed: 'rc && mysql_stmt_errno(stmt) == ER_UNKNOWN_ERROR'

test_bug11766854

mysql_client_test.cc:18139: check failed: 'plugin != nullptr'

test_bug19894382

[MySQL-8.0.26-16-kunlun-storage-debug][1064] You have an error in your SQL syntax;
 check the manual that corresponds to your MySQL server version for the right syntax to use near 'TIMESTAMPtz NULL, f4 TIMESTAMP, f5 TIME(3), f6 TIMESTAMPtz(3) NULL, f7 TIMESTAMP' at line 
mysql_client_test.cc:19363: check failed: 'r == 0'

test_wl11772

 Create user failed with error Operation CREATE USER failed for 'u1'@'%','u2'@'%','u3'@'%' vito@kunlun-test4:~/vito8888/cloudnative/