If using a query with "AS" to rename a column, like here: <c:set var="sqlBody" value="SELECT c1 as x FROM table"/> <sql:query var="result" startRow="0" maxRows="3" dataSource="${dataSource}"> ${sqlBody} </sql:query> the name of the column is "c1" instead of the expected "x". Detail of the change is specified here: http://lists.mysql.com/commits/47149
JDBC driver specific behaviour afaict.
Mysql developers tells me that they follow the JDBC specs. Tomcat developers tells me that this is a "driver artifact". I, as a user, only know that things do not work, application breaks, and an incongruous behavior happens. Since I provided a complete test case to verify and reproduce the problem I can only link the two bug reports together so you can speak one to another and better understand who has to fix his code. https://issues.apache.org/bugzilla/show_bug.cgi?id=45183 http://bugs.mysql.com/bug.php?id=57591 Thanks for your work, Alex
Fixed in r607683 by using getColumnLabel http://svn.apache.org/viewvc/jakarta/taglibs/proper/standard/trunk/src/javax/servlet/jsp/jstl/sql/ResultImpl.java?r1=607683&r2=607682&pathrev=607683 Resolving as duplicate. Please reopen if this reoccurs with 1.2 *** This bug has been marked as a duplicate of bug 43831 ***