test/t/keyring_pxb_2275.sh

31 $MYSQL $MYSQL_ARGS -Ns -e "CREATE TABLE tmp1 ENGINE=InnoDB SELECT * FROM payment" sakila
32 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
33 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp1 SELECT * FROM payment" sakila
37 $MYSQL $MYSQL_ARGS -Ns -e "CREATE TABLE tmp2 (ID INT PRIMARY KEY) ENCRYPTION='Y'" sakila
38 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp2 VALUES (1)" sakila
50 $MYSQL $MYSQL_ARGS -Ns -e "DROP TABLE tmp1, tmp2" sakila
53 $MYSQL $MYSQL_ARGS -Ns -e "CREATE TABLE tmp1 ENGINE=InnoDB SELECT * FROM payment" sakila
54 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
55 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp1 SELECT * FROM payment" sakila
56 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
57 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp1 SELECT * FROM payment" sakila
58 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
59 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp1 SELECT * FROM payment" sakila
60 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
61 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp1 SELECT * FROM payment" sakila
62 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
63 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp1 SELECT * FROM payment" sakila
64 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
65 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp1 SELECT * FROM payment" sakila
66 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
67 $MYSQL $MYSQL_ARGS -Ns -e "DROP TABLE tmp1" sakila
83 $MYSQL $MYSQL_ARGS -Ns -e "CREATE TABLE tmp1 ENGINE=InnoDB SELECT * FROM payment" sakila
84 $MYSQL $MYSQL_ARGS -Ns -e "DELETE FROM tmp1" sakila
85 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp1 SELECT * FROM payment" sakila
89 $MYSQL $MYSQL_ARGS -Ns -e "CREATE TABLE tmp2 (ID INT PRIMARY KEY) ENCRYPTION='Y'" sakila
90 $MYSQL $MYSQL_ARGS -Ns -e "INSERT INTO tmp2 VALUES (1)" sakila
111 run_cmd $MYSQL $MYSQL_ARGS -Ns -e "SELECT * FROM tmp2;" sakila