Hi All,
Curious as to whether anyone has seen this issue before or can at least tell me why its happening.
I have a sql query being executed in a groovy Service class which returns 3 columns. When I execute the identical query within mysql I get the results I expect, however in my app, the 3rd column somehow is being returned as an array and not a float/double.
I am always expecting only one row, so the code in my app is :
def sql = new Sql(dataSource)
def row = sql.firstRow(query)
where query is :
String query =
"SELECT "+
" MAX(cl.good) - MIN(cl.good) as 'good'," +
" MAX(cl.bad) - MIN(cl.bad) as 'poor', " +
"(MAX(cl.bad) - MIN(cl.bad)) / (MAX(cl.good) - MIN(cl.good)) * 100 as ratio "+
"FROM logs cl "+
"WHERE cl.id = " + id + " AND cl.date_created > (NOW() - INTERVAL 1 hour)"
an example of the results in the app (from a println) is
row = [good:59768255, poor:4113235, ratio:[54, 46, 56, 56, 50, 48]]
whereas the same in mysql is
good poor ratio
59768255 4113235 6.8820
it looks like ratio is coming back as a char array and not just the value
Has anyone else seen this before ?
Thanks
Dave