-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Fix Version/s: 10.4.5
-
Component/s: Parser
-
Labels:
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.
- blocks
-
MDEV-19042 Implement sql_mode=MSSQL
-
- Open
-