Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • None
    • N/A
    • None

    Description

      Support the following basic SQL built-in functions in MariaDB:

      • DECODE(exp, when, then, ...) – DONE
      • NVL(exp, replacement) – DONE
      • NVL2(exp1, exp2, exp3) – DONE
      • TRUNC(date [,fmt])
      • TO_CHAR

        TO_CHAR(10)
        TO_CHAR(SYSTIMESTAMP,'DDMMYYYYHH24MISSFF')  - MDEV-20017
        TO_CHAR(BIZ_DATE,'yyyymmdd')
        

      • TO_DATE(str [, fmt [, 'nlsparam']])
      • SYSDATE
      • SYSTIMESTAMP
      • USER

      Note, DECODE, NVL, NVL2, SYSTIMESTAMP are not reserved keywords in Oracle, while USER and SYSDATE are.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              Unassigned Unassigned
              dmtolpeko Dmitry Tolpeko
              Votes:
              1 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.