mysql-smokeTest error

[jd-zhang]

*Issue migrated from trac ticket # 884 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-07 16:59:04: [email protected] created the issue

---

当前测试的driver有：(几乎所有测试都是在ubuntu下完成的，centos8环境太麻烦了，所以在126上跑就行)

• 原生sql接口 JDBC PHP C Python go js c# c++ rust
• 所有的driver都测试过计算节点和元数据据点，元数据节点都可以过，但计算节点有以下三个是会报错的
  • rust

thread 'main' panicked at 'called `Result::unwrap()` on an `Err` value: MySqlError { ERROR 1149 (42000): syntax error at or near "@@" at character: 8

FILE:  scan.l    LINE: 1489     FUNCTION:  scanner_yyerror }', src/main.rs:36:32
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace

• c#

Unhandled exception. MySql.Data.MySqlClient.MySqlException (0x80004005): Version string not in acceptable format
   at MySql.Data.Common.DBVersion.Parse(String versionString)
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at mysql.Program.Main(String[] args) in /home/charles/my-scripts/smoke/c#/mysql/Program.cs:line 50

• jdbc

java.sql.SQLSyntaxErrorException: syntax error at or near "ascii" at character: 11

FILE:  scan.l    LINE: 1489     FUNCTION:  scanner_yyerror
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
        at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
        at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
        at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
        at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
        at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
        at mysql.main(mysql.java:35)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at jdk.compiler/com.sun.tools.javac.launcher.Main.execute(Main.java:404)
        at jdk.compiler/com.sun.tools.javac.launcher.Main.run(Main.java:179)
        at jdk.compiler/com.sun.tools.javac.launcher.Main.main(Main.java:119)

[jd-zhang]

2022-07-07 17:02:21: [email protected] changed owner from smith to kunlun

[jd-zhang]

2022-07-07 17:02:21: [email protected] changed status from new to assigned

[jd-zhang]

2022-07-07 17:15:19: [email protected]

[jd-zhang]

2022-07-07 17:15:19: [email protected] commented

---

运行smoketest测试：
git clone https://github.com/zettadb/cloudnative.git
cd cloudnative/smoke/smokeTest-mysql
** c#: **
cd c# && bash ./start.sh host port(如：bash ./start.sh 192.168.0.113 1321)

-* jdbc： **
cd java && bash ./start.sh host port(如：bash ./start.sh 192.168.0.113 1321)

-* rust: **
cd rust-mysql && bash ./start.sh host port(如：bash ./start.sh 192.168.0.113 1321)

[jd-zhang]

2022-07-07 17:22:26: [email protected] edited the issue description

[jd-zhang]

2022-07-07 17:24:14: [email protected] edited the issue description

[jd-zhang]

2022-07-08 11:38:35: [email protected]

[jd-zhang]

2022-07-08 11:38:35: [email protected] commented

---

For jdbc: the stmt failed is: SET NAMES ascii note that there is no quotes around ascii.

[jd-zhang]

2022-07-08 11:41:43: [email protected] commented

---

For rust, the stmt failed is SELECT @@max_allowed_packet , this syntax will be implemented in #885

[jd-zhang]

2022-07-08 21:16:02: [email protected] commented

---

c# and python client libs require a version string similar to that of mysql during connection handshake.

[jd-zhang]

2022-07-08 21:16:13: [email protected] changed status from assigned to accepted