Debian Codegraph @

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

raw
1 SET sql_mode=MSSQL;
2 #
3 # Start of 10.4 tests
4 #
5 #
6 # MDEV-19142 sql_mode=MSSQL: Bracket identifiers
7 #
8 SELECT 'test' AS [[];
9 [
10 test
11 SELECT 'test' AS []]];
12 ]
13 test
14 SELECT 'test' AS [[a]]];
15 [a]
16 test
17 SELECT 'test' AS [\n];
18 \n
19 test
20 CREATE TABLE [t 1] ([a b] INT);
21 SHOW CREATE TABLE [t 1];
22 Table Create Table
23 t 1 CREATE TABLE "t 1" (
24 "a b" int(11) DEFAULT NULL
25 )
26 INSERT INTO [t 1] VALUES (10);
27 SELECT [a b] FROM [t 1];
28 a b
29 10
30 SELECT [a b] [a b alias] FROM [t 1] [t 1 alias];
31 a b alias
32 10
33 SELECT [a b] FROM [test].[t 1];
34 a b
35 10
36 SELECT [a b], COUNT(*) FROM [t 1] GROUP BY [a b];
37 a b COUNT(*)
38 10 1
39 SELECT [a b], COUNT(*) FROM [t 1] GROUP BY [a b] HAVING [a b]>0;
40 a b COUNT(*)
41 10 1
42 DROP TABLE [t 1];
43 CREATE TABLE [t[1]]] (a INT);
44 SHOW CREATE TABLE [t[1]]];
45 Table Create Table
46 t[1] CREATE TABLE "t[1]" (
47 "a" int(11) DEFAULT NULL
48 )
49 DROP TABLE [t[1]]];
50 CREATE TABLE [t 1] ([a b] INT);
51 CREATE VIEW [v 1] AS SELECT [a b] FROM [t 1];
52 SHOW CREATE VIEW [v 1];
53 View Create View character_set_client collation_connection
54 v 1 CREATE VIEW "v 1" AS select "t 1"."a b" AS "a b" from "t 1" latin1 latin1_swedish_ci
55 SELECT * FROM [v 1];
56 a b
57 DROP VIEW [v 1];
58 DROP TABLE [t 1];
59 CREATE PROCEDURE [p 1]()
60 BEGIN
61 SELECT 'test' [a b];
62 END;
63 $$
64 SHOW CREATE PROCEDURE [p 1];
65 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
66 p 1 PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,MSSQL,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS CREATE DEFINER="root"@"localhost" PROCEDURE "p 1"()
67 BEGIN
68 SELECT 'test' [a b];
69 END latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
70 CALL [p 1];
71 a b
72 test
73 DROP PROCEDURE [p 1];
74 CREATE TABLE [t1] ([a] INT);
75 INSERT INTO t1 VALUES (10);
76 PREPARE [stmt] FROM 'SELECT [a] FROM [test].[t1]';
77 EXECUTE [stmt];
78 a
79 10
80 DEALLOCATE PREPARE [stmt];
81 EXECUTE IMMEDIATE 'SELECT [a] FROM [test].[t1]';
82 a
83 10
84 DROP TABLE [t1];
85 #
86 # End of 10.4 tests
87 #