#
# Test of pushed joins, aka SPJ, or AQL.
# (Test with defaults + 'batched_key_access=on')
#
# NOTE: BKA will turn of lots of pushed join, we 
#       are unsure if this is the best strategy, or
#       if its better/possible to sacrify the BKA
#

--source include/have_ndb.inc
if (!`select locate('batched_key_access', @@global.optimizer_switch) > 0`)
{
  skip Need batched_key_access;
}

set @@global.optimizer_switch='batched_key_access=on';

--source ndb_join_pushdown.inc 

set @@global.optimizer_switch=default;