Title:
Provide more fully featured version of Query of Queries (QoQ). Support more functions
| View in TrackerStatus/Resolution/Reason: Needs Review//
Reporter/Name(from Bugbase): Gerry Gurevich / Gerry Gurevich (Gerry Gurevich)
Created: 12/02/2014
Components: Database
Versions: 11.0
Failure Type: Enhancement Request
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Win CE
Vote Count: 4
Almost any ANSI standard SQL command would be welcomed here. In particular I was looking for something in the order by clause that would allow me to sort with NULLS first or NULLS last.
Absent that I tried to use COALESCE to put some values in the null field for sorting. That also was not supported in QoQ.
The official docs list dozens of reserved words that look to be DB commands that aren't supported in QoQ. Why not support them.
Other QoQ enhancements would be to get rid of the wonky way they handle data types. With ColdFusion being typeless, it gets hard to deal with underlying type enforcement when it pops up. QoQ has always been difficult in this way.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3860956
External Customer Info:
External Company:
External Customer Name: GerryGurevich
External Customer Email:
External Test Config: My Hardware and Environment details are not relevant in this situation.Attachments:
Comments: