Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10142 PL/SQL parser
  3. MDEV-11275

sql_mode=ORACLE: CAST(..AS VARCHAR(N))

Details

    • 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

    Description

      When running in sql_mode=ORACLE, MariaDB should support CAST(expr AS VARCHAR(N)) and CAST(expr AS VARCHAR2(N))

      CAST(expr AS VARCHAR(N)) should eventually be supported not only in sql_mode=ORACLE, but in other modes as well. See MDEV-11283.

      This task is limited to sql_mode=ORACLE only.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-11283 CAST(..AS VARCHAR(N))

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}} When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{CAST(expr AS VARCHAR(N))}}, but in other modes as well.

            {{CAST(expr AS VARCHAR(N))}} is supported by:
            - Oracle
            - SQL Server
            - PostgreSQL

            {{CAST(expr AS VARCHAR}} (without length) is supported by:
            - SQL Server
            - PostgreSQL
            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{CAST(expr AS VARCHAR(N))}}, but in other modes as well.

            {{CAST(expr AS VARCHAR(N))}} is supported by:
            - Oracle
            - SQL Server
            - PostgreSQL

            {{CAST(expr AS VARCHAR}} (without length) is supported by:
            - SQL Server
            - PostgreSQL
            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{CAST(expr AS VARCHAR(N))}}, but in other modes as well.

            {{CAST(expr AS VARCHAR(N))}} is supported by:
            - Oracle
            - SQL Server
            - PostgreSQL
            - SQLite

            {{CAST(expr AS VARCHAR}} (without length) is supported by:
            - SQL Server
            - PostgreSQL
            - SQLite
            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{CAST(expr AS VARCHAR(N))}}, but in other modes as well.

            {{CAST(expr AS VARCHAR(N))}} is supported by:
            - Oracle
            - SQL Server
            - PostgreSQL
            - SQLite

            {{CAST(expr AS VARCHAR}} (without length) is supported by:
            - SQL Server
            - PostgreSQL
            - SQLite
            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{CAST(expr AS VARCHAR(N))}}, but in other modes as well.

            {{CAST(expr AS VARCHAR(N))}} is supported by:
            - Oracle
            - SQL Server
            - PostgreSQL
            - SQLite
            - IBM DB2

            {{CAST(expr AS VARCHAR}} (without length) is supported by:
            - SQL Server
            - PostgreSQL
            - SQLite

            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{CAST(expr AS VARCHAR(N))}}, but in other modes as well.

            {{CAST(expr AS VARCHAR(N))}} is supported by:
            - Oracle
            - SQL Server
            - PostgreSQL
            - SQLite
            - IBM DB2

            {{CAST(expr AS VARCHAR}} (without length) is supported by:
            - SQL Server
            - PostgreSQL
            - SQLite

            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{CAST(expr AS VARCHAR(N))}}, but in other modes as well.

            {{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
            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{CAST(expr AS VARCHAR(N))}}, but in other modes as well.

            {{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
            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{sql_mode=ORACLE}}, but in other modes as well.

            {{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
            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{sql_mode=ORACLE}}, but in other modes as well.

            {{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
            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{sql_mode=ORACLE}}, but in other modes as well.

            {{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
            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}}.

            Perhaps not only in {{sql_mode=ORACLE}}, but in other modes as well.

            {{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
            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}} and {{CAST(expr AS VARCHAR2(N))}}

            Perhaps not only in {{sql_mode=ORACLE}}, but in other modes as well.

            {{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
            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}} and {{CAST(expr AS VARCHAR2(N))}}

            Perhaps not only in {{sql_mode=ORACLE}}, but in other modes as well.

            {{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
            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}} and {{CAST(expr AS VARCHAR2(N))}}

            Perhaps {{CAST(expr AS VARCHAR(N))}} should be supported not only in {{sql_mode=ORACLE}}, but in other modes as well.

            {{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
            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}} and {{CAST(expr AS VARCHAR2(N))}}

            Perhaps {{CAST(expr AS VARCHAR(N))}} should be supported not only in {{sql_mode=ORACLE}}, but in other modes as well.

            {{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
            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}} and {{CAST(expr AS VARCHAR2(N))}}

            {{CAST(expr AS VARCHAR(N))}} should eventually be supported not only in {{sql_mode=ORACLE}}, but in other modes as well. See MDEV-11283.
            bar Alexander Barkov made changes -
            Description When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}} and {{CAST(expr AS VARCHAR2(N))}}

            {{CAST(expr AS VARCHAR(N))}} should eventually be supported not only in {{sql_mode=ORACLE}}, but in other modes as well. See MDEV-11283.
            		When running in {{sql_mode=ORACLE}}, MariaDB should support {{CAST(expr AS VARCHAR(N))}} and {{CAST(expr AS VARCHAR2(N))}}

            {{CAST(expr AS VARCHAR(N))}} should eventually be supported not only in {{sql_mode=ORACLE}}, but in other modes as well. See MDEV-11283.

            This task is limited to {{sql_mode=ORACLE}} only.
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2016-11-15 11:31:30.0 2016-11-15 11:31:30.588
            bar Alexander Barkov made changes -
            Fix Version/s 10.3.0 [ 22127 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            Labels NRE-307517 Approved NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            NRE Projects NRE-307517
            alvinr Alvin Richards (Inactive) made changes -
            Labels Approved NRE-307517 Approved
            alvinr Alvin Richards (Inactive) made changes -
            NRE Approved Yes [ 10304 ]
            alvinr Alvin Richards (Inactive) made changes -
            Labels Approved
            bar Alexander Barkov made changes -
            Labels need_review
            bar Alexander Barkov made changes -
            Labels need_review Compatibility need_review
            serg Sergei Golubchik made changes -
            Labels Compatibility need_review Compatibility
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78281 ] MariaDB v4 [ 151214 ]

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.