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