[CONJ-669] SQLSyntaxErrorException: No such column: (Empty column without alias) Created: 2019-01-02  Updated: 2019-02-08  Resolved: 2019-01-11

Status: Closed
Project: MariaDB Connector/J
Component/s: JDBC 4.2 compatibility
Affects Version/s: 2.3.0
Fix Version/s: 1.8.0, 2.4.0

Type: Bug Priority: Minor
Reporter: Leonid M. Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None


 Description   

SQL query with empty value as column without alias in select statement causes exception, e.g.:
getSession().createSQLQuery("SELECT '' FROM t").list();

Caused by: java.sql.SQLSyntaxErrorException: No such column:
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:236)
at org.mariadb.jdbc.internal.com.read.dao.ColumnNameMap.getIndex(ColumnNameMap.java:133)
at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.findColumn(SelectResultSet.java:1484)
at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getString(SelectResultSet.java:1017)
at sun.reflect.GeneratedMethodAccessor265.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)

As workaround, with alias works fine:
getSession().createSQLQuery("SELECT '' AS a FROM t").list();


Generated at Thu Feb 08 03:17:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.