Grammar is mssql.
// entity def
component table="RMME_C" extends="quick.models.BaseEntity" accessors=true {
property name="ID_C" type="numeric" sqltype="integer";
variables._key = "ID_C";
}
// table
create table rmme_c (id_c int null);
// do it
v = getInstance("RMME_C")
v.whereID_C(42);
sql = v.reset().retrieveQuery().toSql(showBindings=true);
// v5.2.0 (expected) --> SELECT [RMME_C].[ID_C] FROM [RMME_C]
// v5.2.7 (unexpected) --> SELECT [RMME_C].[ID_C] FROM [RMME_C] WHERE [RMME_C].[ID_C] = {"value":42,"cfsqltype":"integer","null":false}
writedump(sql);
The behavior of
resetseems to have changed between 5.2.0 -> 5.2.7.Grammar is mssql.
Repro: