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

sql_mode=MSSQL: Bracket identifiers

Details

    Description

      SQL Server understands bracket identifiers (in addition to the SQL Standard double-quoted identifiers), so these scripts are equivalent:

      SELECT
      		 
        [column]
      		 
      FROM
      		 
        [my table]
      		 
      WHERE
      		 
        [order] = 10;


      SELECT
      		 
        "column"
      		 
      FROM
      		 
        "my table"
      		 
      WHERE
      		 
        "order" = 10;

      We'll extend the parser to understand bracket identifiers when sql_mode has the MSSQL flag.

      Bracket identifiers will be accepted in all contexts where double-quoted identifiers are possible, including but not limited to:

      • Direct SQL
      • Dynamic SQL (PREPARE/EXECUTE/EXECUTE IMMEDIATE)
      • Stored procedures

      This will help SQL Server users to migrate to MariaDB easier.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-19042 Implement sql_mode=MSSQL

          • 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 SQL Server understands bracket identifiers (in addition to the SQL Standard double-quoted identifiers), so these scripts are equivalent:

            {code:sql}
            SELECT
              [column]
            FROM
              [my table]
            WHERE
              [order] = 10;
            {code}

            {code:sql}
            SELECT
              "column"
            FROM
              "my table"
            WHERE
              "order" = 10;
            {code}

            We'll extende the parser to understand bracket identifiers when {{sql_mode}} has the {{MSSQL}} flag.

            Bracket identifiers will be accepted in all contexts where double-quoted identifiers are possible, including but not limited to:
            - Direct SQL
            - Dynamic SQL (PREPARE/EXECUTE/EXECUTE IMMEDIATE)
            - Stored procedures


            This will help SQL Server users to migrate to MariaDB easier.
            		SQL Server understands bracket identifiers (in addition to the SQL Standard double-quoted identifiers), so these scripts are equivalent:

            {code:sql}
            SELECT
              [column]
            FROM
              [my table]
            WHERE
              [order] = 10;
            {code}

            {code:sql}
            SELECT
              "column"
            FROM
              "my table"
            WHERE
              "order" = 10;
            {code}

            We'll extend the parser to understand bracket identifiers when {{sql_mode}} has the {{MSSQL}} flag.

            Bracket identifiers will be accepted in all contexts where double-quoted identifiers are possible, including but not limited to:
            - Direct SQL
            - Dynamic SQL (PREPARE/EXECUTE/EXECUTE IMMEDIATE)
            - Stored procedures


            This will help SQL Server users to migrate to MariaDB easier.
            manjot Manjot Singh (Inactive) made changes -
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2019-04-15 06:45:59.0 2019-04-15 06:45:59.227
            bar Alexander Barkov made changes -
            Fix Version/s 10.4.5 [ 23311 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 94182 ] MariaDB v4 [ 133914 ]

            People

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