|
CREATE TABLE t1 (original_id varchar(100), key_p2
|
DATETIME, some_value text, PRIMARY KEY (original_id, key_p2));
|
INSERT IGNORE INTO t1 (original_id, key_p2, some_value) VALUES ('oid_a', '2020-06-01 00:00', 'some_value_a');
|
|
CREATE TABLE t2 (original_id varchar(100), other_id varchar(100), PRIMARY KEY (original_id, other_id));
|
INSERT IGNORE INTO t2 (original_id, other_id) VALUES ('oid_a', 'otherid_1');
|
INSERT IGNORE INTO t2 (original_id, other_id) VALUES ('oid_b', 'otherid_1');
|
|
SELECT original_id AS alt_id, key_p2 as p2, some_value
|
FROM t1
|
WHERE original_id IN (
|
SELECT DISTINCT(inner1.original_id)
|
FROM t2 AS inner1
|
RIGHT JOIN t2 AS inner2 ON inner1.other_id = inner2.other_id
|
WHERE inner1.original_id = 'oid_a'
|
)
|
ORDER BY key_p2;
|
|
drop table t1;
|
drop table t2;
|
This test suite do not have problems with --ps-protocol so how I can repeat the problem in other ways?
|
|
I can reproduce it using Diego's example above and the latest Connector/J 2.7.2.
Here is my code, test23341.java:
import java.sql.*;
|
public class test23341 {
|
public static void main(String args[]) {
|
System.out.println("welcome to area51");
|
try (Connection con = DriverManager.getConnection("jdbc:mariadb://localhost:3317/test", "root", "mysql")) {
|
Statement stmt = con.createStatement();
|
stmt.execute("CREATE TABLE IF NOT EXISTS foo_outer (original_id varchar(100), key_p2 DATETIME, some_value text, PRIMARY KEY (original_id, key_p2))");
|
stmt.execute("INSERT IGNORE INTO foo_outer (original_id, key_p2, some_value) VALUES ('oid_a', '2020-06-01 00:00', 'some_value_a')");
|
stmt.execute("CREATE TABLE IF NOT EXISTS foo_inner (original_id varchar(100), other_id varchar(100), PRIMARY KEY (original_id, other_id))");
|
stmt.execute("INSERT IGNORE INTO foo_inner (original_id, other_id) VALUES ('oid_a', 'otherid_1')");
|
stmt.execute("INSERT IGNORE INTO foo_inner (original_id, other_id) VALUES ('oid_b', 'otherid_1')");
|
ResultSet r = stmt.executeQuery("SELECT original_id AS alt_id, key_p2 as p2, some_value "
|
+ "FROM foo_outer "
|
+ "WHERE original_id IN ("
|
+ "SELECT DISTINCT(inner1.original_id) "
|
+ "FROM foo_inner AS inner1 "
|
+ "RIGHT JOIN foo_inner AS inner2 ON inner1.other_id = inner2.other_id "
|
+ "WHERE inner1.original_id = 'oid_a'"
|
+ ") ORDER BY key_p2");
|
while (r.next()) {
|
// will throw an error, since column name meta return alt_id
|
ResultSetMetaData meta = r.getMetaData();
|
System.out.println(meta.getColumnLabel(1)); // return alt_id, as expected
|
System.out.println(meta.getColumnName(1)); // return alt_id, not original_id
|
r.getString("original_id"); // will throw an exception
|
}
|
} catch (Exception ex) {
|
ex.printStackTrace();
|
}
|
}
|
}
|
You can see it works in MariaDB 10.2:
C:\chris>javac test23341.java
|
|
C:\chris>"C:\Program Files (x86)\Java\jre1.8.0_161\bin\java.exe" -cp "./mysql-connector-java-3.1.12-bin.jar;." test23341
|
welcome to area51
|
alt_id
|
original_id
|
You can see it works in MariaDB 10.3:
C:\chris>javac test23341.java
|
|
C:\chris>"C:\Program Files (x86)\Java\jre1.8.0_161\bin\java.exe" -cp "./mysql-connector-java-3.1.12-bin.jar;." test23341
|
welcome to area51
|
alt_id
|
original_id
|
And you can see it fails in MariaDB 10.4:
C:\chris>javac test23341.java
|
|
C:\chris>"C:\Program Files (x86)\Java\jre1.8.0_161\bin\java.exe" -cp "./mysql-connector-java-3.1.12-bin.jar;." test23341
|
welcome to area51
|
alt_id
|
alt_id
|
java.sql.SQLSyntaxErrorException: No such column: 'original_id'. 'original_id' must be in [p2, foo_outer.some_value, foo_outer.alt_id, foo_outer.p2, some_value, alt_id]
|
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
|
at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:187)
|
at org.mariadb.jdbc.internal.com.read.dao.ColumnLabelIndexer.getIndex(ColumnLabelIndexer.java:137)
|
at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.findColumn(SelectResultSet.java:1319)
|
at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getString(SelectResultSet.java:953)
|
at test23341.main(test23341.java:25)
|
|
MDEV-23341.patch
version.c
