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

CAST(..AS VARCHAR(N))

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

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            Affects Version/s 10.3 [ 22126 ]
            Issue Type Bug [ 1 ] Task [ 3 ]
            bar Alexander Barkov made changes -
            Labels Compatibility
            bar Alexander Barkov made changes -
            Epic Link MDEV-10137 [ 56868 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov added a comment - - edited

            Monty wrote:

            Yes, we should [support CAST AS VARCHAR for other sql_modes], but I am not sure how this would differ from CAST(... CHAR), except for a length check.

            In particular, what should the result be for:

            CREATE TABLE t1 SELECT CAST("A" AS VARCHAR(10));

            Logically I assume this should create a VARCHAR(10) column, but can we really detect that in our current code without making this a special case?
            (Maybe this will work automatically, but I can't test this just now)

            The problem with special cases is how to handle expressions:
            CONCAT(CAST("A" AS VARCHAR(10)), "")

            bar Alexander Barkov added a comment - - edited Monty wrote: Yes, we should [support CAST AS VARCHAR for other sql_modes] , but I am not sure how this would differ from CAST(... CHAR), except for a length check. In particular, what should the result be for: CREATE TABLE t1 SELECT CAST("A" AS VARCHAR(10)); Logically I assume this should create a VARCHAR(10) column, but can we really detect that in our current code without making this a special case? (Maybe this will work automatically, but I can't test this just now) The problem with special cases is how to handle expressions: CONCAT(CAST("A" AS VARCHAR(10)), "")
            monty Michael Widenius made changes -
            Parent MDEV-10137 [ 56868 ]
            Issue Type Task [ 3 ] Technical task [ 7 ]
            monty Michael Widenius made changes -
            Epic Link MDEV-10137 [ 56868 ]
            monty Michael Widenius made changes -
            Parent MDEV-10137 [ 56868 ]
            Issue Type Technical task [ 7 ] Task [ 3 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            greenman Ian Gilfillan added a comment -

            Running 

            SELECT CAST(123 AS VARCHAR(10)) FROM DUAL;

            seems to work in non-Oracle mode from MariaDB 10.3.11.

            greenman Ian Gilfillan added a comment - Running SELECT CAST(123 AS VARCHAR(10)) FROM DUAL; seems to work in non-Oracle mode from MariaDB 10.3.11.
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Alexander Barkov [ bar ]
            Labels Compatibility Compatibility Oracle
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78296 ] MariaDB v4 [ 130544 ]
            danblack Daniel Black made changes -

            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.