TryCF Gist

trycf-gist-1694534315498-742c4c85-9121-0edd-1e58-b7450ec3f538.cfm

<cfscript>
q1 = QueryNew("id,dec", "integer,decimal");
    q1.addRow({id: 1, dec: 5.57});
    q2 = QueryNew("id,str", "integer,varchar");
    q2.addRow({id: 1, str: "testing"});
    q3sql = "
      select  *
      from    q1, q2
      where   q1.id = q2.id
    ";
    q3 = QueryExecute(q3sql, {}, {dbtype: "query"});
    // q3.dec should be 5.57. It is 6 instead.
    writeDump(q3);
    
    
    q1 = QueryNew("id,dec", "integer,double");
    q1.addRow({id: 1, dec: 5.57});
    q2 = QueryNew("id,str", "integer,varchar");
    q2.addRow({id: 1, str: "testing"});
    q3sql = "
      select  *
      from    q1, q2
      where   q1.id = q2.id
    ";
    q3 = QueryExecute(q3sql, {}, {dbtype: "query"});
    // q3.dec should be 5.57. It is 6 instead.
    writeDump(q3);
</cfscript>