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

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              bar Alexander Barkov
              Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated: