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: