Debian Codegraph @

mysql-test/suite/ndb_ddl/identifier_limits63_debug.result

raw
1 set @save_debug = @@global.debug;
2 # Testing schema identifier with length 64
3 # NOTE! ndb_schema identifier length limit used to be 63 bytes,
4 # use dbug keyword to emulate old limit
5 #
6 set global debug='+d,ndb_schema_dist_63byte_limit';
7 should_be_64_bytes should_be_64_characters
8 64 64
9 # Create database suceeds but generates a warning as well as
10 # prints a message to log.
11 CREATE DATABASE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
12 Warnings:
13 Warning 1296 [mysql.ndb_schema] Identifier length exceeds the 63 byte limit
14 Warning 1296 Identifier name 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123' is too long
15 # Verify database existence
16 USE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
17 # Create non NDB table
18 CREATE TABLE t1 (
19 a int
20 );
21 # Create NDB table should fail
22 CREATE TABLE t2 (
23 a int
24 ) ENGINE=NDB;
25 ERROR 42000: Identifier name 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123' is too long
26 show warnings;
27 Level Code Message
28 Warning 1296 [mysql.ndb_schema] Identifier length exceeds the 63 byte limit
29 Error 1059 Identifier name 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123' is too long
30 Error 1031 Table storage engine for 't2' doesn't have this option
31 DROP DATABASE abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123;
32 Warnings:
33 Warning 1296 [mysql.ndb_schema] Identifier length exceeds the 63 byte limit
34 Warning 1296 Identifier name 'abcdefghijklmnopqrstuvwxyz1234567890bcdefghijklmnopqrstuvwxyz123' is too long
35 set @@global.debug = @save_debug;