cfquery of query not working in CF2016

I have a query which has run well on ColdFusion 10.

However we've upgraded to CF2016 and yet when I run a query of a query I get no results.

<cfquery datasource="travcomus" name="firstquery">

  SELECT * FROM tablename

</cfquery>

Followed by

<cfquery dbtype="Query" name="secondquery" >

  select * from firstquery

</cfquery>

The second query does not return any results. There is nothing in the logs as well.