3
declare -r DIST_BASE=$(cd $(dirname $0)/..; pwd -P)
4
TEST_BASE=${TEST_BASE:-"$DIST_BASE"}
6
. $TEST_BASE/conf/main.conf
8
#declare -r SCRIPTS="$DIST_BASE/scripts"
21
NODE[$i]="-h${NODE_INCOMING_HOST[$i]} -P${NODE_INCOMING_PORT[$i]}"
24
MYSQL="mysql -u$USER -p$PSWD"
26
DROP_TABLE="DROP TABLE IF EXISTS $SCHEMA.$TABLE;"
28
echo $DROP_TABLE | $MYSQL ${NODE[2]}
31
"CREATE TABLE $SCHEMA.$TABLE (c1 INT AUTO_INCREMENT PRIMARY KEY, c2 INT)"
33
echo $CREATE_TABLE | $MYSQL ${NODE[2]}
36
echo "INSERT INTO $SCHEMA.$TABLE VALUES (1, 0)" | $MYSQL ${NODE[1]}
39
for (( i=1; i<=10000; i++ ))
41
echo "UPDATE $SCHEMA.$TABLE SET c2 = $i WHERE c1 = 1;" \
43
echo "SELECT c2 FROM $SCHEMA.$TABLE WHERE c1 = 1;" \
44
| $MYSQL ${NODE[0]} | grep ^$i >/dev/null || failure=$(( $failure + 1 ))
47
#[ $failure -ne 0 ] &&
48
echo "Causal failures: $failure"