Re: Problem with JDBC resultset type mapping

On 12/8/06, Christopher G. Stach II <[email protected]> wrote:
> RTFM
>
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

Ok, but I wasn't speaking about that, but about a small incosistency:

This gives out STRING as a result:
SELECT concat(Class,cast(petallength as char)) as a, COUNT(*) FROM
`iris` GROUP BY `a`

Then, without casting this also gives STRING:
SELECT concat(Class,petallength),Class FROM `iris`

But when we add the GROUP BY clause we get LONGVARBINARY:
SELECT concat(Class,petallength), COUNT(*) FROM `iris` GROUP BY
`concat(Class,petallength)

All the time I was speaking about the JDBC connection.
There is some lax of consistency for me.

Regards,
MIlosz

-- 
Milosz Hulboj
https://www.linkedin.com/profile?viewProfile=&key=1467390

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]