tracker issue : CF-4206460

select a category, or use search below
(searches all categories and all time range)

Query-Of-Query syntax error when filtering by a string with two dashes

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/PRNeedInfo

Reporter/Name(from Bugbase): Ryan P. / ()

Created: 01/02/2020

Components: Database, Query-of-Query(IMQ)

Versions: 2016

Failure Type: Incorrectly functioning

Found In Build/Fixed In Build: 2016,0,13,316217 / 2020.0.0.316159

Priority/Frequency: Normal / Few users will encounter

Locale/System: English / Windows 10 64 bit

Vote Count: 0

Problem Description:
If you try to run a query of queries with a parameter containing two dashes (-) an exception will occur indicating an there was a Query of Queries syntax error.

Here is part of the stacktrace for the exception:
java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "). Query Of Queries runtime error. at coldfusion.sql.imq.jdbcStatement.parseSQL( at coldfusion.sql.imq.jdbcStatement.fetchResult( at coldfusion.sql.imq.jdbcStatement.execute( at coldfusion.sql.imq.jdbcPreparedStatement.execute( at coldfusion.sql.Executive.executeQuery( at coldfusion.sql.SqlImpl.execute( at coldfusion.tagext.sql.QueryTag.executeQuery( at coldfusion.tagext.sql.QueryTag.startQueryExecution( at coldfusion.tagext.sql.QueryUtils.executeQuery( at coldfusion.runtime.CFPage.QueryExecute(

Steps to Reproduce:
Starting with a table called Example that has the column like Name varchar(100), run the following

test = queryExecute('select * from Example', {}, {datasource: datasource});
  'select * from test where Name in (:names)',
  {names: {value: '123-45-678,912-34-56', cfsqltype: 'varchar', list: true}},
  {dbtype: 'query'}

Actual Result:
An exception occurs with the message "<br><b>Query Of Queries syntax error.</b><br> Encountered ". Query Of Queries runtime error."

Expected Result:
No exception occurs

Any Workarounds:



I have try to reproduce this issue on CF2016 with update 13,12 and 11, and mysql database i have used. and it's working as expected. we need some more information. which update  this issue is producible. 2.which database used
Comment by Yogesh P.
32010 | January 06, 2020 05:50:25 AM GMT
Is there any update regarding this issue, or if you are still facing this issue please provide me information , which mention in previous comment  Thank you 
Comment by Yogesh P.
33172 | February 24, 2020 10:37:26 AM GMT