Status/Resolution/Reason: To Fix//Investigate
Reporter/Name(from Bugbase): Adam Cameron / Adam Cameron (Adam Cameron)
Created: 12/03/2014
Components: Language
Versions: 11.0
Failure Type: Enhancement Request
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Trivial / Unknown
Locale/System: English / Platforms All
Vote Count: 8
QoQ has, I think, only these functions:
avg()
count()
max()
min()
sum()
upper()
lower()
Not bad for a first try (although the casing ones didn't even make it in the first try, I think?), but there are really a lot of scalar functions an SQL implementation ought to support.
Obviously Adobe are not in the business of creating a DB platform, but as a minimum a few ought to be added:
* time part extraction like year() / month() / day() / hour() / minute() / second()
* datediff() / dateadd()
* substring() / replace() / trim()
Again, I thought I (or someone) had already raised a ticket to this effect, but I cannae find it anywhere.
--
Adam
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3861322
External Customer Info:
External Company:
External Customer Name: Adam Cameron.
External Customer Email:
External Test Config: My Hardware and Environment details:Attachments:
Comments: