| 1 |
SET sql_mode=MSSQL; |
| 2 |
|
| 3 |
--echo # |
| 4 |
--echo # Start of 10.4 tests |
| 5 |
--echo # |
| 6 |
|
| 7 |
--echo # |
| 8 |
--echo # MDEV-19142 sql_mode=MSSQL: Bracket identifiers |
| 9 |
--echo # |
| 10 |
|
| 11 |
# Brackets inside bracket identifiers: |
| 12 |
# - When we want a left bracket inside a bracket identifier, |
| 13 |
# we just add a single left bracket: [ |
| 14 |
# - When we want a right bracket inside a bracket identifier, |
| 15 |
# we add two right brackets: ]] |
| 16 |
|
| 17 |
|
| 18 |
SELECT 'test' AS [[]; |
| 19 |
SELECT 'test' AS []]]; |
| 20 |
SELECT 'test' AS [[a]]]; |
| 21 |
|
| 22 |
# Backslash has no special meaning |
| 23 |
SELECT 'test' AS [\n]; |
| 24 |
|
| 25 |
|
| 26 |
CREATE TABLE [t 1] ([a b] INT); |
| 27 |
SHOW CREATE TABLE [t 1]; |
| 28 |
INSERT INTO [t 1] VALUES (10); |
| 29 |
SELECT [a b] FROM [t 1]; |
| 30 |
SELECT [a b] [a b alias] FROM [t 1] [t 1 alias]; |
| 31 |
SELECT [a b] FROM [test].[t 1]; |
| 32 |
SELECT [a b], COUNT(*) FROM [t 1] GROUP BY [a b]; |
| 33 |
SELECT [a b], COUNT(*) FROM [t 1] GROUP BY [a b] HAVING [a b]>0; |
| 34 |
DROP TABLE [t 1]; |
| 35 |
|
| 36 |
CREATE TABLE [t[1]]] (a INT); |
| 37 |
SHOW CREATE TABLE [t[1]]]; |
| 38 |
DROP TABLE [t[1]]]; |
| 39 |
|
| 40 |
CREATE TABLE [t 1] ([a b] INT); |
| 41 |
CREATE VIEW [v 1] AS SELECT [a b] FROM [t 1]; |
| 42 |
SHOW CREATE VIEW [v 1]; |
| 43 |
SELECT * FROM [v 1]; |
| 44 |
DROP VIEW [v 1]; |
| 45 |
DROP TABLE [t 1]; |
| 46 |
|
| 47 |
DELIMITER $$; |
| 48 |
CREATE PROCEDURE [p 1]() |
| 49 |
BEGIN |
| 50 |
SELECT 'test' [a b]; |
| 51 |
END; |
| 52 |
$$ |
| 53 |
DELIMITER ;$$ |
| 54 |
SHOW CREATE PROCEDURE [p 1]; |
| 55 |
CALL [p 1]; |
| 56 |
DROP PROCEDURE [p 1]; |
| 57 |
|
| 58 |
CREATE TABLE [t1] ([a] INT); |
| 59 |
INSERT INTO t1 VALUES (10); |
| 60 |
PREPARE [stmt] FROM 'SELECT [a] FROM [test].[t1]'; |
| 61 |
EXECUTE [stmt]; |
| 62 |
DEALLOCATE PREPARE [stmt]; |
| 63 |
EXECUTE IMMEDIATE 'SELECT [a] FROM [test].[t1]'; |
| 64 |
DROP TABLE [t1]; |
| 65 |
|
| 66 |
--echo # |
| 67 |
--echo # End of 10.4 tests |
| 68 |
--echo # |