子查询被自动添加了ifnull，并且备用值为0，与返回值类型不一致

[ANCB520]

var t = SqlService.Db.Select<LocationEntity>().LeftJoin(o => o.Id == o.GDAddress.LocationId) .Where(o => o.CollectTime == SqlService.Db.Select<LocationEntity>().As("b").Where(b=>b.DeviceCode == entity.DeviceCode).Max(b => b.CollectTime)) .First();

生成的SQL为

SELECT a.Id, a.Version, a.IsDeleted, a.CreatedTime, a.ModifiedTime, a.DeviceCode, a.Latitude, a.Longitude, a.Altitude, a.IsFromMockProvider, a.CollectTime, a.FormattedAddress, a__GDAddress.Id as13, a__GDAddress.Version as14, a__GDAddress.CreatedTime as15, a__GDAddress.LocationId, a__GDAddress.GdLatitude, a__GDAddress.GdLongitude, a__GDAddress.FormattedAddress as19, a__GDAddress.Country, a__GDAddress.Province, a__GDAddress.City, a__GDAddress.Citycode, a__GDAddress.District, a__GDAddress.Adcode, a__GDAddress.Township, a__GDAddress.Towncode
FROM Location a
LEFT JOIN GDAddress a__GDAddress ON a.Id = a__GDAddress.LocationId
WHERE (a.CollectTime = ifnull((SELECT max(b.CollectTime)
FROM Location b
WHERE (b.DeviceCode = '7678f598-3f8e-4e8c-90ee-dcd3c3041388') AND (b.IsDeleted = 0)), 0)) AND (a.IsDeleted = 0)
limit 0,1

因为fnull备用值为0，子查询返回数据的数据类型为DATETIME
导致
Incorrect DATETIME value: '0'

[2881099]

收到，晚上解决

[ANCB520]

哈哈，这效率没话说