[#GROOVY-2216] mysql: class of result columns from "show full processlist" is byte array, should be java.lang.String

groovy

mysql: class of result columns from "show full processlist" is byte array, should be java.lang.String

Created: 16/Oct/07 04:18 PM Updated: 08/Feb/08 01:26 AM

Component/s:

SQL processing

Affects Version/s:

1.1-rc-1

Fix Version/s:

1.5.2

Time Tracking:

Not Specified

File Attachments:	1. test.groovy (0.6 kB)
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

Description

« Hide

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.

All

Comments

Work Log

Change History

Sort Order:

[ Permalink | « Hide ]

Paul King added a comment - 30/Dec/07 04:59 AM

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.

[ Permalink | « Hide ]

Vance Baarda added a comment - 03/Jan/08 02:20 PM

Thanks for the link, Paul. I had searched for info like this, but not hard enough, obviously.