CF10 vs CF2018 unintentional query cache
I've been working on migrating code from CF10 to CF2018. I just noticed that in CF2018, my queries are unintentionally using a CF-like query cache. This is noticable everytime I alter the table structure, my CF2018 session is still referencing a cached version of the query. This happens even when I try to clear the query cache in CFADMIN, it doesnt affect the results. Different behavior is produced with CF10 (see below). If I add a comment to the query, it returns the correct results. Is there a default query cache option enabled with CF2018?
My Code:
<cfquery name=”qTest”>
select * from users
</cfquery>
<cfdump var=”#qTest#”>
CF2018 Results:
Displays table columns names correctly
Cache is false
CF10 Results:
Displays table columns names correctly
Cache is false
Then I rename a column in oracle, and run the same page
<cfquery name=”qTest”>
select * from users
</cfquery>
<cfdump var=”#qTest”>
CF2018 Results:
Does not display new column name
Cache is false
CF10 Results:
Displays table columns correctly
Cache is false
If I add a comment to the query, things work
<cfquery name=”qTest”>
select * from users
--test1234
</cfquery>
<cfdump var=”#qTest”>
CF2018 Results:
Displays table columns names correctly
Cache is false
CF10 Results:
Displays table columns names correctly
Cache is false
