1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
# Setup table for tests
USE test;
--source include/setup-global-constraints.inc
# Test for sort buffer constraint
# Test disabled, needs two parallel filesorts to trigger error. Drizzleslap's error handling currently unpredictable
#--error 134
#--exec $DRIZZLE_SLAP -q "SELECT * FROM t1 ORDER BY 1" -c100 --iterations=1 --number-of-queries=1000 --create-schema=test
# Test for join buffer constraint
--error ER_OUT_OF_GLOBAL_JOINMEMORY
select SQL_BIG_RESULT * from t1 join t2 on (t1.charcol1 = t2.charcol2) join t2 as t3 on (t1.charcol1 = t3.charcol2);
--source include/teardown-global-constraints.inc
|