|
608
by Brian Aker
Adding snowman test (plus a dead variable removal). |
1 |
# Test Snowman Unicode character for creation
|
2 |
# of tables and databases.
|
|
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.6
by Stewart Smith
make snowman test not leave tables behind after running |
37 |
|
38 |
DROP TABLE t1; |