Database Type
MySQL
Database Version
MySQL5.7
Druid Version
1.2.24
JDK Version
JDK8
Error SQL
SELECT u.name, o.total FROM users u JOIN orders o ON u.id = o.user_id WHERE u.age > 18
Testcase Code
String sql = "SELECT u.name, o.total FROM users u "
+ "JOIN orders o ON u.id = o.user_id "
+ "WHERE u.age > 18";
List<SQLStatement> stmts = SQLUtils.parseStatements(sql, DbType.mysql);
SchemaStatVisitor visitor = SQLUtils.createSchemaStatVisitor(DbType.mysql);
stmts.get(0).accept(visitor);
System.out.println("Conditions: " + visitor.getConditions());
// 预期输出: [users.id = orders.user_id, users.age > 18]
// 实际输出: [users.id =, orders.user_id =, users.age > 18]
Stacktrace Info
No response
Error Info
No response
Database Type
MySQL
Database Version
MySQL5.7
Druid Version
1.2.24
JDK Version
JDK8
Error SQL
SELECT u.name, o.total FROM users u JOIN orders o ON u.id = o.user_id WHERE u.age > 18
Testcase Code
String sql = "SELECT u.name, o.total FROM users u "
+ "JOIN orders o ON u.id = o.user_id "
+ "WHERE u.age > 18";
// 预期输出: [users.id = orders.user_id, users.age > 18]
// 实际输出: [users.id =, orders.user_id =, users.age > 18]
Stacktrace Info
No response
Error Info
No response