Debian Codegraph @

mysql-test/suite/compat/mssql/parser.test

raw
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 #