Running a query where sqltype of cfqueryparam is set to smallint causes query to return 0 results. I'm not entirely sure if this is across the board as this particular application has been offline since switching from ACF, but even after updating lucee to latest version queries as simple as "select id from table where id=<cfqueryparam value="#url.id#" sqltype="smallint" maxlength="5">" return 0 results. Swap out 'smallint' for 'integer' and the expected results return. Personally I'd call this a blocker, but have set it as critical as it seems like no one else has run into it. But it clearly has the potential to massively affect outcomes.

I have logged two of the 'smallint' related issues here I can see after a search. Should I be using something else? It seems strange I keep being the only person running into these?