Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11283

CAST(..AS VARCHAR(N))

    XMLWordPrintable

Details

    Description

      MDEV-11275 adds support for CAST(expr AS VARCHAR(N)) for sql_mode=ORACLE.

      CAST(expr AS VARCHAR(N)) should also be supported not only in sql_mode=ORACLE, but in other modes as well, it's supported by many popular databases:

      CAST(expr AS VARCHAR(N)) is supported by:

      • Oracle
      • SQL Server
      • PostgreSQL
      • SQLite
      • IBM DB2
      • Sybase/SAP ASE

      CAST(expr AS VARCHAR) (without length) is supported by:

      • SQL Server
      • PostgreSQL
      • SQLite
      • Sybase/SAP ASE

      Attachments

        Issue Links

          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-10137 Providing compatibility to other databases

          • Major - Major loss of function.
          • Open

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-35388 Postgres compatible syntax

          • Major - Major loss of function.
          • Open
          relates to

          Technical task - A technical task. MDEV-11275 sql_mode=ORACLE: CAST(..AS VARCHAR(N))

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              bar Alexander Barkov
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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