← Back to branch summary

~vadim-tk/percona-server/percona-galera-5.1.57

« back to all changes in this revision

Viewing changes to mysql-test/suite/parts/inc/partition_syntax_2.inc

  • Committer: root
  • Date: 2011-07-10 16:09:24 UTC
  • Revision ID: root@r815.office.percona.com-20110710160924-fyffqsbaclgu6vui
Initial port

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/parts/inc/partition_syntax_2.inc
 
1
################################################################################
 
2
# inc/partition_syntax_2.inc                                                   #
 
3
#                                                                              #
 
4
# Purpose:                                                                     #
 
5
#   Auxiliary script, only useful when sourced by inc/partition_syntax.inc.    #
 
6
#                                                                              #
 
7
#------------------------------------------------------------------------------#
 
8
# Original Author: mleich                                                      #
 
9
# Original Date: 2006-05-11                                                    #
 
10
# Change Author:                                                               #
 
11
# Change Date:                                                                 #
 
12
# Change:                                                                      #
 
13
################################################################################
 
14
 
 
15
if (`SELECT @@session.storage_engine NOT IN('ndbcluster')`)
 
16
{
 
17
   --error ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
 
18
   eval CREATE TABLE t1 (
 
19
   $column_list,
 
20
   $unique_index
 
21
   )
 
22
   $partition_scheme;
 
23
   --error ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF
 
24
   eval CREATE TABLE t1 (
 
25
   $column_list,
 
26
   PRIMARY KEY(f_int1,f_int2), $unique_index
 
27
   )
 
28
   $partition_scheme;
 
29
}
 
30
if (`SELECT @@session.storage_engine IN('ndbcluster')`)
 
31
{
 
32
   eval CREATE TABLE t1 (
 
33
   $column_list,
 
34
   $unique_index
 
35
   )
 
36
   $partition_scheme;
 
37
   eval $insert_all;
 
38
   --source suite/parts/inc/partition_check.inc
 
39
   DROP TABLE t1;
 
40
   eval CREATE TABLE t1 (
 
41
   $column_list,
 
42
   PRIMARY KEY(f_int1,f_int2), $unique_index
 
43
   )
 
44
   $partition_scheme;
 
45
   eval $insert_all;
 
46
   --source suite/parts/inc/partition_check.inc
 
47
   DROP TABLE t1;
 
48
}