Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3005

Implement string functions: LEFT, RIGHT

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.20.0
    • Component/s: None

      Description

      Some string functions including LEFT, RIGHT are not implemented now. It would be great if these functions can be implemented.

      LEFT(str,len)

      Returns the leftmost len characters from the string str, or NULL if any argument is NULL.

      RIGHT(str,len)

      Returns the rightmost len characters from the string str, or NULL if any argument is NULL.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                x1q1j1 Forward Xu
                Reporter:
                x1q1j1 Forward Xu
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 6h 50m
                  6h 50m