tracker issue : CF-4206460

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

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

| View in Tracker

Status/Resolution/Reason: To Track//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 /

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(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.imq.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:122) at coldfusion.sql.Executive.executeQuery(Executive.java:1553) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:72) at coldfusion.runtime.CFPage.QueryExecute(CFPage.java:10165)

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});
queryExecute(
  '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:
None

Attachments:

Comments:

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. 1.in 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