MySQL数据库
SysStatus字段类型为smallint
生成的sql语句使用了CAST类型转化,索引失效
SELECT ExcelSheet.ID AS ID,ExcelSheet.Name AS Name FROM ExcelSheet AS ExcelSheet WHERE (ExcelSheet.UserID = ?P_0 AND CAST(ExcelSheet.SysStatus AS SIGNED) = 1 AND ExcelSheet.ID IN (3))
请问是基于什么原因要进行类型转化?
MySQL数据库 SysStatus字段类型为smallint 生成的sql语句使用了CAST类型转化,索引失效 SELECT
ExcelSheet
.ID
ASID
,ExcelSheet
.Name
ASName
FROMExcelSheet
ASExcelSheet
WHERE (ExcelSheet
.UserID
= ?P_0 AND CAST(ExcelSheet
.SysStatus
AS SIGNED) = 1 ANDExcelSheet
.ID
IN (3)) 请问是基于什么原因要进行类型转化?