Debian Codegraph @

mysql-test/suite/innodb/include/innodb_isolation_selects.inc

raw
1 # These same selects are used many times in innodb_isolation.test
2
3 --echo ########## innodb_isolation_selects.inc ##########
4 SELECT * FROM t1;
5 SELECT COUNT(*) FROM t1;
6 SELECT COUNT(c1) FROM t1;
7 SELECT COUNT(c2) FROM t1; # Uses secondary index k2
8 SELECT COUNT(c3) FROM t1; # Uses clustered index
9 SELECT SUM(c1) FROM t1; # Uses secondary index
10 SELECT SUM(c2) FROM t1; # Uses secondary index
11 SELECT AVG(c1), MAX(c1), MIN(c2), AVG(c3), SUM(c4) FROM t1; # Uses clustered index
12 SELECT c1, c2 FROM t1 WHERE c1 > ((SELECT COUNT(*) FROM t1) / 2);
13 SELECT COUNT(c2) FROM t1 WHERE c1 > ((SELECT COUNT(*) FROM t1) / 2);
14 SELECT COUNT(*) FROM t1 WHERE c1 > (SELECT AVG(c1) FROM t1);
15 --echo ###############################################