I found some very strange behaviour of ColdFusion’s query component. When you use this component to build a query of query (QoQ) of another ColdFusion Query and use order by on  several colums, the last column in the order by list is added to the selected output. This appears to happen in CF9, 10, 11 and 2016, but not in Lucee. /* Create an unsorted CF-query */ unsorted = QueryNew(“col1,col2,col3,col4″,”VarChar,VarChar,Integer,VarChar”); for (a=10;a gte 1;a–){ QueryAddRow(unsorted); QuerySetCell(unsorted,”col1″,”col1 #a#”); QuerySetCell(unsorted,”col2″,”col2 #a#”); QuerySetCell(unsorted,”col3″,”#a#”); […]