{
  "key": null,
  "status": "BAD_REQUEST"
}

<https://tracker.adobe.com/api/add/feature>

POST

------WebKitFormBoundaryrydhiAWy2hVYGmvZ
Content-Disposition: form-data; name="details"

{"project":{"value":"CF","name":"ColdFusion [CF]"},"version":{"name":"2021","value":"2021"},"component":{"name":"Language","value":"Language"},"system":{"name":"Platforms All","value":"Platforms All"},"locale":{"value":"","name":"-"},"type":{"value":"FEAT","name":"New Feature"},"failureType":{"value":"","name":"-"},"title":"QoQ LIKE cache the regex for performance","description":"While doing some performance testing between Lucee and Adobe CF for Query of Queries, I noticed that it appears Adobe re-compiles the Java regex used for LIKE clauses every time they are used.  Lucee caches the compiled regex's in memory for better performance.  I saw a stack trace like this a LOT during my testing while I profiled the thread meaning it was taking a large amount of time compiling regex over and over.\n\norg.apache.oro.text.regex.Perl5Compiler.__parseUnicodeClass(Unknown Source)\norg.apache.oro.text.regex.Perl5Compiler.__parseAtom(Unknown Source)\norg.apache.oro.text.regex.Perl5Compiler.__parseBranch(Unknown Source)\norg.apache.oro.text.regex.Perl5Compiler.__parseAlternation(Unknown Source)\norg.apache.oro.text.regex.Perl5Compiler.__parseExpression(Unknown Source)\norg.apache.oro.text.regex.Perl5Compiler.compile(Unknown Source)\norg.apache.oro.text.regex.Perl5Compiler.compile(Unknown Source)\ncoldfusion.sql.imq.rttExprCondLike.validateLikePattern(rttExprCond.java:482)\ncoldfusion.sql.imq.rttExprCondLike.evaluate(rttExprCond.java:529)\ncoldfusion.sql.imq.rttExprCondTest.evaluate(rttExprCond.java:273)\ncoldfusion.sql.imq.rttExprCondAnd.evaluate(rttExprCond.java:140)\ncoldfusion.sql.imq.rttSelectExprSpec.evaluateWhere(rttSelectExprSpec.java:245)\ncoldfusion.sql.imq.rttSelectExprSpec.evaluate(rttSelectExprSpec.java:184)\ncoldfusion.sql.imq.rttSelectStmt.evaluate(rttSelectStmt.java:61)\ncoldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:551)\ncoldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:143)\ncoldfusion.sql.Executive.executeQuery(Executive.java:1595)\ncoldfusion.sql.SqlImpl.execute(SqlImpl.java:430)\ncoldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)\ncoldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)\ncoldfusion.tagext.sql.QueryUtils.executeQuery(QueryUtils.java:85)\ncoldfusion.runtime.CFPage.QueryExecute(CFPage.java:14648)\ncfindex2ecfm203462494.runPage(C:\\Users\\Brad\\Desktop\\sandbox\\qoq\\index.cfm:17)\n\nI highly recommend putting in a basic cache for the compiled regular expressions to improve performance under load.","testConfiguration":"2021.0.5"}
------WebKitFormBoundaryrydhiAWy2hVYGmvZ--