Cfquery bigint values

I have a id column in a table that is a bigint. When querying this table with this code:

a = '2148124530';
q = new query()
    .setsql('select * from mytable where id=:id')
    .addparam(name='id', value=a, sqltype="CF_SQL_BIGINT")

The conversion to bigint fails, it sets to 2147483647, the max integer value.

The workaround it’s to convert myself the string to bigint, but I think there has to be a better solution.


Ok, I see this bug has been fixed and will be released in next lucee stable version