~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
# Test Snowman Unicode character for creation
# of tables and databases.

# Test without backticks
CREATE DATABASE ;

DROP DATABASE ;

# Now with backticks
CREATE DATABASE `☃`;

DROP DATABASE `☃`;

# Now try table names
USE test;

# Test table creation without backticks
# And various operations on the table
CREATE TABLE  (a INT NOT NULL);

INSERT INTO  VALUES(1);
INSERT INTO  VALUES(2);

SELECT a FROM ;

DELETE FROM  WHERE a = 1;

UPDATE  SET a = 3 WHERE a = 2;

TRUNCATE ;

RENAME TABLE  TO t1;
CREATE DATABASE ;
DROP DATABASE ;
CREATE DATABASE `☃`;
DROP DATABASE `☃`;

DROP TABLE t1;