|
673.3.30
by Stewart Smith
add a skeleton clef test that uses the unicode clef character, which is above 2**16. this is https://bugs.launchpad.net/drizzle/+bug/310479 |
1 |
# Test Clef Unicode character for creation
|
2 |
# of tables and databases. This is interesting as it's > 2**16
|
|
3 |
||
4 |
# Test without backticks
|
|
5 |
#CREATE DATABASE 𝄢;
|
|
6 |
||
7 |
#DROP DATABASE 𝄢;
|
|
8 |
||
9 |
# Now with backticks
|
|
10 |
CREATE DATABASE `𝄢`; |
|
11 |
||
12 |
DROP DATABASE `𝄢`; |
|
13 |
||
14 |
# Now try table names
|
|
15 |
USE test; |
|
16 |
||
17 |
# Test table creation without backticks
|
|
18 |
# And various operations on the table
|
|
19 |
CREATE TABLE 𝄢 (a INT NOT NULL); |
|
20 |
||
21 |
INSERT INTO 𝄢 VALUES(1); |
|
22 |
INSERT INTO 𝄢 VALUES(2); |
|
23 |
||
24 |
SELECT a FROM 𝄢; |
|
25 |
||
26 |
DELETE FROM 𝄢 WHERE a = 1; |
|
27 |
||
28 |
UPDATE 𝄢 SET a = 3 WHERE a = 2; |
|
29 |
||
30 |
TRUNCATE 𝄢; |
|
31 |
||
32 |
RENAME TABLE 𝄢 TO t1; |
|
33 |
CREATE DATABASE 𝄢; |
|
34 |
DROP DATABASE 𝄢; |
|
35 |
CREATE DATABASE `𝄢`; |
|
36 |
DROP DATABASE `𝄢`; |
|
|
1119.4.2
by Stewart Smith
make clef test not leave tables behind after running |
37 |
DROP TABLE t1; |