Debian Codegraph @

mysql-test/suite/ndb_ddl/identifier_limits.result

raw
1 # ####################################################################
2 # Bug11753491: MYSQLD CRASHES WHEN CREATING A CLUSTER TABLE WITH 64
3 # CHARACTER TABLE NAME
4 # ####################################################################
5 create table abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123(
6 id int primary key
7 ) engine=ndb;
8 drop table abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
9 # ############################################################
10 # Bug19550973: CREATE/DROP DATABASE STATEMENT SEGFAULTS IF
11 # IDENTIFIER LENGTH IS >=64
12 # ############################################################
13 #
14 # 1. Testing schema identifier with length 63
15 #
16 CREATE DATABASE
17 abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12;
18 # Create and drop table to test the long database name
19 CREATE TABLE
20 abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12.t1 (
21 a int
22 ) ENGINE=NDB;
23 DROP TABLE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12.t1;
24 DROP DATABASE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz12;
25 #
26 # 2. Testing schema identifier with length 64
27 #
28 CREATE DATABASE
29 abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
30 # Verify database existence
31 USE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
32 # Create non NDB table
33 CREATE TABLE t1 (
34 a int
35 );
36 # Create NDB table
37 CREATE TABLE t2 (
38 a int
39 ) ENGINE=NDB;
40 #
41 # 3. Databases with identifier length = 64 is synchronized to other
42 # MySQL Servers. Verify that the above created dabatase is present
43 # in the other Server
44 # NOTE! This testcase was fixed by BUG#27447958 which extended ndb_schema
45 # to support identifiers > 63
46 #
47 USE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
48 #
49 # 4. Testing alter database
50 #
51 ALTER DATABASE
52 abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123
53 character set=utf8mb4;
54 CREATE DATABASE db1;
55 CREATE TABLE db1.t1 (
56 a int
57 ) ENGINE=NDB;
58 CREATE TABLE db1.t2 (
59 a int
60 ) ENGINE=NDB;
61 #
62 # 4.1 Renaming table to long database name
63 #
64 ALTER TABLE db1.t1
65 RENAME abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123.t3;
66 #
67 # 4.2 Renaming table to long table name
68 #
69 ALTER TABLE db1.t2
70 RENAME db1.abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
71 DROP DATABASE db1;
72 DROP DATABASE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
73 # Checking that database doesn't exists
74 USE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
75 ERROR 42000: Unknown database 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123'
76 #
77 # 5. Testing schema identifier with length 65, should fail
78 # NOTE! The MySQL Server limit is 64 and thus it rejects length 65
79 #
80 CREATE DATABASE
81 abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz1234;
82 ERROR 42000: Identifier name 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz1234' is too long