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(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:
NoneAttachments:
Comments: