Error in Query Adhoc execution option for sql_generation_mode

While both the Execute Query by ID and Ad-hoc execute query defined sql_generation_mode as:

  • Query - Use the query's select fields plus QRECID
  • Export - Use the query's select fields without adding QRECID
  • Report - Only select QRECID

Only Execute Query by ID respect this definition. When using sql_generation_mode=Export, no QRECID is produced when using execute query by ID.

However, when executing adhoc query using the same sql_generation_mode=Export, QRECID is produced nonetheless. This is a waste of bandwidth and a bug as it is not the intention of this parameter.

@Ben Wong @Erik Leaver @Heather McLean Please take a look into this. I don't want to open a support ticket (unless you really want me to) as the support rep is simply going to ask me a bunch of basic troubleshooting questions before they would even reach out to the engineering team.