Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: 1.1-rc-1
-
Fix Version/s: 1.5.2
-
Component/s: SQL processing
-
Labels:None
-
Environment:OS: SUSE Linux Enterprise Desktop 10 SP1
java: 1.6.0_02 from Sun
Connector/J: mysql-connector-java-5.0.8-bin.jar
MySQL: 5.0.45
-
Testcase included:yes
-
Number of attachments :
Description
Using groovy.sql.Sql.eachRow("show full processlist"), the class of most of the result columns used to be java.lang.String. Now (as of mysql-connector-java-5.0.8-bin.jar), the class of most of the result columns is byte array.
Setting priority to Major since this used to work correctly (using mysql-connector-java-5.0.7-bin.jar, for example).
Test case is attached. This test passes with mysql-connector-java-5.0.7-bin.jar but fails with mysql-connector-java-5.0.8-bin.jar.
Attachments
Activity
Hide
Vance Baarda
added a comment -
Thanks for the link, Paul. I had searched for info like this, but not hard enough, obviously. 
Regards,
Vance
Show
Vance Baarda
added a comment - Thanks for the link, Paul. I had searched for info like this, but not hard enough, obviously.
Regards,
Vance
Regards,
Vance
I can reproduce the results but it seems like a change in the mysql server or driver rather than anything in Groovy. See here:
http://osdir.com/ml/db.mysql.java/2006-02/msg00042.html
The workaround from Groovy is to do something like: new String(it.Command) for such fields.