Uploaded image for project: 'Railo'
  1. Railo
  2. RAILO-3269

Improve scalar functions in query of query

    XMLWordPrintable

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Out of Date
    • Affects Version/s: 4.2.1.008
    • Fix Version/s: None
    • Labels:
      None

      Description

      From https://bugbase.adobe.com/index.cfm?event=bug&id=3861322

      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 [Railo] 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()

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                micstriit Michael Offner
                Reporter:
                adamcameroncf Adam Cameron
              • Votes:
                1 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: