5.6.17_1 的 MySQL 语法错误

Question

我有 MySQL 5.6.17_1 并具有用于 5.1.xx 的查询

select
    schtermid,idfptnsubid,d.idfptnid,idflinksetid,
     cast(count(distinct cthr) as real)/cast(count(distinct s.schid)  as real)*100  as ctr, cast(sum(status) as real)/cast(count(*) as real)*100  as pfiled,
 count(distinct s.schid)  as schcount
from source.kdm_session as

这提示

您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，了解要在附近使用的正确语法

'real)/cast(count(distinct s.schid)  as real)*100  as ctr, cast(sum(status) as' at line 3

哪一部分是错误的？我应该改变什么才能发生同样的事情？

Answer 1

如per the docs , real 不是有效类型:

The type for the result can be one of the following values:

BINARY[(N)]
CHAR[(N)]
DATE
DATETIME
DECIMAL[(M[,D])]
SIGNED [INTEGER]
TIME
UNSIGNED [INTEGER]