edwardpro's blog

发现在5.0.3上执行如下的sql语句 as 重命名会失效：
select a.subject as title,c.lastpost as 'desc',b.name as style,concat(a.lastpost,"") as level,concat(FROM_UNIXTIME(a.dateline),'') as publishtime,c.name as 'column',a.subject as content,a.author as author from cdb_threads a left outer join cdb_threadtypes b on b.typeid=a.typeid left outer join cdb_forums c on c.fid=a.fid LIMIT 10

表现是字段得到的map依然是subject lastpost 而不是我as出来名字 原来程序在4.0.18上完全正常，数据库升级后出现了问题。

跑到mysql官网下载了5.0.7版本的驱动之后这个问题就消失了，确认应该是 mysql jdbc驱动的问题。