133 lines
4.1 KiB
Plaintext
133 lines
4.1 KiB
Plaintext
# Copyright (C) 2008 Sun Microsystems, Inc. All rights reserved.
|
|
# Use is subject to license terms.
|
|
#
|
|
# This program is free software; you can redistribute it and/or modify
|
|
# it under the terms of the GNU General Public License as published by
|
|
# the Free Software Foundation; version 2 of the License.
|
|
#
|
|
# This program is distributed in the hope that it will be useful, but
|
|
# WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
|
|
# General Public License for more details.
|
|
#
|
|
# You should have received a copy of the GNU General Public License
|
|
# along with this program; if not, write to the Free Software
|
|
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
|
|
# USA
|
|
|
|
#####################################################################
|
|
#
|
|
# Author: Hema Sridharan
|
|
# Date: May 2009
|
|
#
|
|
# Purpose: Implementation of WL#4732: The test is intended to verify
|
|
# the interoperability of MySQL BACKUP / RESTORE operations with other
|
|
# server operations.
|
|
# This grammar file creates tables and objects in the database db1.
|
|
#
|
|
# Associated files are:
|
|
# mysql-test/gentest/conf/backup_obj.yy
|
|
# mysql-test/gentest/conf/backup_interop.yy
|
|
# mysql-test/gentest/lib/Gentest/Reporter/BackupInterop.pm
|
|
#
|
|
#####################################################################
|
|
query:
|
|
create_table | create_view |
|
|
create_procedure | create_function |
|
|
create_trigger | create_event ;
|
|
# sql_mode | character_set;
|
|
|
|
# NOTE: sql_mode and character set is disabled because of BUG#46419
|
|
# BUG#46419: Memory corruption when creating tables with different character
|
|
# sets in RQG
|
|
|
|
create_table:
|
|
CREATE TABLE IF NOT EXISTS table_name (table_cols) ENGINE = storage_engine ;
|
|
|
|
storage_engine: Myisam | Innodb ;
|
|
|
|
table_cols: one_col | two_col | three_col ;
|
|
|
|
one_col: column_definition ;
|
|
|
|
two_col: column_definition,
|
|
column_definition ;
|
|
|
|
three_col: column_definition,
|
|
column_definition,
|
|
column_definition ;
|
|
|
|
column_definition: new_column data_type column_option ;
|
|
|
|
new_column: c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | c9 | c10 ;
|
|
|
|
data_type: INT | CHAR(255) | TINYINT | VARCHAR(255) | SMALLINT | BIGINT | TIME
|
|
| YEAR | TIMESTAMP | DATETIME | DATE | TEXT | BLOB ;
|
|
|
|
column_option: NULL | NOT NULL ;
|
|
|
|
table_name:
|
|
t1 | t2 | t3 | t4 | t5 | t6 | t7 | t8 | t9 | t10 ;
|
|
|
|
create_view:
|
|
CREATE VIEW view_name AS SELECT * FROM table_name ;
|
|
|
|
view_name:
|
|
v1 | v2 | v3 | v4 | v5 | v6 | v7 | v8 | v9 | v10 ;
|
|
|
|
create_procedure:
|
|
CREATE PROCEDURE db1.procedure_name () SET @pro=10 ;
|
|
|
|
procedure_name:
|
|
p1 | p2 | p3 | p4 | p5 | p6 | p7 | p8 | p9 | p10 ;
|
|
|
|
call_procedure:
|
|
CALL db1.procedure_name ;
|
|
|
|
create_function:
|
|
CREATE FUNCTION function_name () RETURNS INT RETURN (SELECT COUNT(*) FROM table_or_view) ;
|
|
|
|
table_or_view:
|
|
table_name | view_name;
|
|
|
|
function_name:
|
|
f1 | f2 | f3 | f4 | f5 | f6 | f7 | f8 | f9 | f10 ;
|
|
|
|
create_trigger:
|
|
CREATE TRIGGER trigger_name trigger_time trigger_event ON table_name FOR EACH ROW SET @trg=100 ;
|
|
|
|
trigger_name:
|
|
letter ;
|
|
|
|
trigger_time:
|
|
BEFORE | AFTER ;
|
|
|
|
trigger_event:
|
|
INSERT | UPDATE ;
|
|
|
|
create_event:
|
|
CREATE EVENT event_name ON SCHEDULE EVERY digit SECOND ON COMPLETION PRESERVE DO SET @ev=100 ;
|
|
|
|
event_name:
|
|
letter ;
|
|
|
|
sql_mode:
|
|
SET SQL_MODE=' ' | SET SQL_MODE='TRADITIONAL' |
|
|
SET SQL_MODE='PIPES_AS_CONCAT' | SET SQL_MODE='ANSI_QUOTES' ;
|
|
|
|
character_set:
|
|
SET CHARACTER_SET_CLIENT=cset | SET CHARACTER_SET_CONNECTION=cset |
|
|
SET CHARACTER_SET_DATABASE=cset | SET CHARACTER_SET_FILESYSTEM=cset |
|
|
SET CHARACTER_SET_RESULTS=cset | SET CHARACTER_SET_SERVER=cset |
|
|
SET COLLATION_CONNECTION=coll | SET COLLATION_DATABASE=coll |
|
|
SET COLLATION_SERVER=coll ;
|
|
|
|
cset: LATIN1 | LATIN2 | LATIN5 | LATIN7 | SWE7 | BIG5 |
|
|
EUCJPMS | GB2312 | ARMSCII8 | CP932 | UTF8 ;
|
|
|
|
coll: LATIN1_SWEDISH_CI | LATIN2_GENERAL_CI | LATIN5_TURKISH_CI |
|
|
LATIN7_GENERAL_CI | SWE7_SWEDISH_CI | BIG5_CHINESE_CI |
|
|
EUCJPMS_JAPANESE_CI | GB2312_CHINESE_CI | ARMSCII8_GENERAL_CI |
|
|
CP932_JAPANESE_CI | UTF8_SPANISH_CI ;
|
|
|