← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/parts/inc/partition_20.inc
 
1
################################################################################
 
2
# inc/partition_20.inc                                                         #
 
3
#                                                                              #
 
4
# Purpose:                                                                     #
 
5
#   Auxiliary script, only useful when sourced by                              #
 
6
#   suite/parts/inc/partition_check.inc.                                       #
 
7
#                                                                              #
 
8
# 1. Check if the preceding statement caused that the expected number of       #
 
9
#    records was                                                               #
 
10
#    - inserted                                                                #
 
11
#    - updated or deleted+inserted                                             #
 
12
# 2. Revert the modifications                                                  #
 
13
#                                                                              #
 
14
#    The parameters                                                            #
 
15
#       @try_count = total number of inserted and updated or deleted+inserted  #
 
16
#                    records                                                   #
 
17
#       @clash_count = number of records where a DUPLICATE KEY appears         #
 
18
#    must be set before sourcing this routine.                                 #
 
19
#                                                                              #
 
20
#------------------------------------------------------------------------------#
 
21
# Original Author: mleich                                                      #
 
22
# Original Date: 2006-03-05                                                    #
 
23
# Change Author:                                                               #
 
24
# Change Date:                                                                 #
 
25
# Change:                                                                      #
 
26
################################################################################
 
27
 
 
28
if ($no_debug)
 
29
{
 
30
  --disable_query_log
 
31
}
 
32
eval SELECT '# check unique-$num-a success: ' AS "", COUNT(*) = @clash_count AS ""
 
33
FROM t1 WHERE f_charbig = 'was updated';
 
34
eval SELECT '# check unique-$num-b success: ' AS "", COUNT(*) = @try_count AS ""
 
35
FROM t1 WHERE f_charbig IN ('was updated','was inserted');
 
36
--enable_query_log
 
37
# Revert the modification
 
38
DELETE FROM t1 WHERE f_charbig = 'was inserted';
 
39
UPDATE t1 SET f_int1 = CAST(f_char1 AS SIGNED INT),
 
40
          f_int2 = CAST(f_char1 AS SIGNED INT),
 
41
       f_charbig = CONCAT('===',f_char1,'===')
 
42
WHERE f_charbig = 'was updated';
 
43
inc $num;