QoQ joins on columns with type numeric doesn't work

Description

If i get some data from ms sql, it comes back with the numeric data type

If i try to do a join with these in a QoQ, they don't work with the numeric data type, but only with integer

(note ACF doesn't seem to support the numeric type for querynew)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 <cfloop list="numeric,integer" item="d"> <cfoutput><h1>#D#</h1></cfoutput> <cfscript> a = queryNew("id","#d#"); QueryAddRow(a); QuerySetCell(a,"id",1); QueryAddRow(a); QuerySetCell(a,"id",2); QueryAddRow(a); QuerySetCell(a,"id",3); b = duplicate(a); dump(a); dump(b); </cfscript> <cfdump var=#getMetaData(a)#> <cfdump var=#getMetaData(b)#> <cfquery name="q" dbtype="query"> SELECT a.ID, b.id FROM a, b where b.ID=a.ID and b.ID IN (2) </cfquery> <h1>join result</h1> <cfdump var=#q#> <hr> </cfloop>

https://trycf.com/gist/a11f0ec7587133644d4368e93b310fc2/lucee5?theme=monokai

 

 

Environment

None

Status

Assignee

Michael Offner

Reporter

Zac Spitzer

Time tracking

0m

Affects versions

5.3.5.8

Priority

Critical
Configure