--echo
--echo ===== BEGIN TEST =====

--disable_query_log

# THREAD_ID, EVENT_ID

IF ($key_group == 1)
{
  eval CALL index_test($table, "WHERE thread_id is null");
  eval CALL index_test($table, "WHERE thread_id is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id");
  eval CALL index_test($table, "WHERE event_id != 9999999");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id ORDER BY thread_id");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id ORDER BY thread_id DESC");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_id is null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_id is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_id != 99999999");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_id = 99999999");
  eval CALL index_test($table, "WHERE thread_id > @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id < @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id >= @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id <= @target_thread_id");
}

# OWNER_THREAD_ID, OWNER_EVENT_ID

IF ($key_group == 1.1)
{
  eval CALL index_test($table, "WHERE owner_thread_id is null");
  eval CALL index_test($table, "WHERE owner_thread_id is not null");
  eval CALL index_test($table, "WHERE owner_thread_id = @target_thread_id");
  eval CALL index_test($table, "WHERE owner_thread_id = @target_thread_id AND owner_event_id = @target_event_id");
  eval CALL index_test($table, "WHERE owner_event_id != 9999999");
  eval CALL index_test($table, "WHERE owner_thread_id = @target_thread_id ORDER BY owner_thread_id");
  eval CALL index_test($table, "WHERE owner_thread_id = @target_thread_id ORDER BY owner_thread_id DESC");
  eval CALL index_test($table, "WHERE owner_thread_id = @target_thread_id AND owner_event_id is null");
  eval CALL index_test($table, "WHERE owner_thread_id = @target_thread_id AND owner_event_id is not null");
  eval CALL index_test($table, "WHERE owner_thread_id = @target_thread_id AND owner_event_id != 99999999");
  eval CALL index_test($table, "WHERE owner_thread_id = @target_thread_id AND owner_event_id = 99999999");
  eval CALL index_test($table, "WHERE owner_thread_id >= @target_thread_id");
  eval CALL index_test($table, "WHERE owner_thread_id <= @target_thread_id");
  eval CALL index_test($table, "WHERE owner_thread_id != 9999999 AND owner_event_id = @target_event_id");
  eval CALL index_test($table, "WHERE owner_thread_id = 9999999 ORDER BY owner_thread_id");
}

# THREAD_ID, ERROR_NUMBER

IF ($key_group == 1.2)
{
  eval CALL index_test($table, "WHERE thread_id is null");
  eval CALL index_test($table, "WHERE thread_id is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id");
  eval CALL index_test($table, "WHERE error_number != 9999999");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id ORDER BY thread_id");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id ORDER BY thread_id DESC");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND error_number is null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND error_number is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND error_number = 99999999");
  eval CALL index_test($table, "WHERE thread_id > @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id < @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id >= @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id <= @target_thread_id");
}

# USER, HOST, EVENT_NAME

IF ($key_group == 2)
{
  eval CALL index_test($table, "WHERE user is null");
  eval CALL index_test($table, "WHERE user is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and host is null");
  eval CALL index_test($table, "WHERE user = 'user1' and host is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and host = '$target_host' and event_name is null");
  eval CALL index_test($table, "WHERE user = 'user1' and host = '$target_host' and event_name is not null");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1' AND event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1' AND event_name = 'impossible'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND user= 'nouser' AND event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'nouser' AND event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND user= 'user1' AND event_name = '$target_event_name'");
}

# USER, HOST

IF ($key_group == 2.1)
{
  eval CALL index_test($table, "WHERE user is null");
  eval CALL index_test($table, "WHERE user is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and host is null");
  eval CALL index_test($table, "WHERE user = 'user1' and host is not null");
  eval CALL index_test($table, "WHERE host = '$target_host'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1'");
  #eval CALL index_test($table, "WHERE host != '$target_host' AND user != 'user1'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND user= 'nouser'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'nouser'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND user= 'user1'");
}

# PROCESSLIST_USER, PROCESSLIST_HOST

IF ($key_group == 2.1.1)
{
  eval CALL index_test($table, "WHERE processlist_user is null");
  eval CALL index_test($table, "WHERE processlist_user is not null");
  eval CALL index_test($table, "WHERE processlist_user = 'user1' and processlist_host is null");
  eval CALL index_test($table, "WHERE processlist_user = 'user1' and processlist_host is not null");
  eval CALL index_test($table, "WHERE processlist_host = '$target_host'");
  eval CALL index_test($table, "WHERE processlist_host = '$target_host' AND processlist_user= '$target_user'");
  eval CALL index_test($table, "WHERE processlist_host != '$target_host' AND processlist_user != '$target_user'");
  eval CALL index_test($table, "WHERE processlist_host = 'nohost' AND processlist_user= 'nouser'");
  eval CALL index_test($table, "WHERE processlist_host = '$target_host' AND processlist_user= 'nouser'");
  eval CALL index_test($table, "WHERE processlist_host = 'nohost' AND processlist_user= '$target_user'");
}

# USER, HOST, VARIABLE_NAME

IF ($key_group == 2.2)
{
  eval CALL index_test($table, "WHERE user is null");
  eval CALL index_test($table, "WHERE user is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and host is null");
  eval CALL index_test($table, "WHERE user = 'user1' and host is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and host = '$target_host' and variable_name is null");
  eval CALL index_test($table, "WHERE user = 'user1' and host = '$target_host' and variable_name is not null");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1' AND variable_name = '$target_variable_name'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1' AND variable_name = 'impossible'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND user= 'nouser' AND variable_name = '$target_variable_name'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'nouser' AND variable_name = '$target_variable_name'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND user= 'user1' AND variable_name = '$target_variable_name'");
}

# USER, HOST, ERROR_NUMBER

IF ($key_group == 2.3)
{
  eval CALL index_test($table, "WHERE user is null");
  eval CALL index_test($table, "WHERE user is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and host is null");
  eval CALL index_test($table, "WHERE user = 'user1' and host is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and host = '$target_host' and error_number is null");
  eval CALL index_test($table, "WHERE user = 'user1' and host = '$target_host' and error_number is not null");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1' AND error_number = '$target_error_number'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'user1' AND error_number = 999999");
  eval CALL index_test($table, "WHERE host = 'nohost' AND user= 'nouser' AND error_number = '$target_error_number'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND user= 'nouser' AND error_number = '$target_error_number'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND user= 'user1' AND error_number = '$target_error_number'");
}

# HOST, ERROR_NUMBER

IF ($key_group == 2.4)
{
  eval CALL index_test($table, "WHERE host is null");
  eval CALL index_test($table, "WHERE host is not null");
  eval CALL index_test($table, "WHERE host = '$target_host' and error_number is null");
  eval CALL index_test($table, "WHERE host = '$target_host' and error_number is not null");
  eval CALL index_test($table, "WHERE host = '$target_host'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND error_number = '$target_error_number'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND error_number = 999999");
  eval CALL index_test($table, "WHERE host = 'nohost' AND error_number = '$target_error_number'");
}

# USER, ERROR_NUMBER

IF ($key_group == 2.5)
{
  eval CALL index_test($table, "WHERE user is null");
  eval CALL index_test($table, "WHERE user is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and error_number is null");
  eval CALL index_test($table, "WHERE user = 'user1' and error_number is not null");
  eval CALL index_test($table, "WHERE user= 'user1'");
  eval CALL index_test($table, "WHERE user= 'user1' AND error_number = '$target_error_number'");
  eval CALL index_test($table, "WHERE user= 'user1' AND error_number = 999999");
  eval CALL index_test($table, "WHERE user= 'nouser' AND error_number = '$target_error_number'");
}

# ERROR_NUMBER

IF ($key_group == 2.6)
{
  eval CALL index_test($table, "WHERE error_number is null");
  eval CALL index_test($table, "WHERE error_number is not null");
  eval CALL index_test($table, "WHERE error_number = '$target_error_number'");
  eval CALL index_test($table, "WHERE error_number = '$target_error_number' ORDER BY error_number");
  eval CALL index_test($table, "WHERE error_number = '$target_error_number' ORDER BY error_number DESC");
  eval CALL index_test($table, "WHERE error_number > '$target_error_number'");
  eval CALL index_test($table, "WHERE error_number < '$target_error_number'");
  eval CALL index_test($table, "WHERE error_number >= '$target_error_number'");
  eval CALL index_test($table, "WHERE error_number <= '$target_error_number'");
}

# USER, HOST, ROLE

IF ($key_group == 2.7)
{
   eval CALL index_test($table, "WHERE user is null");
   eval CALL index_test($table, "WHERE user is not null");
   eval CALL index_test($table, "WHERE user = 'user1' and host is null");
   eval CALL index_test($table, "WHERE user = 'user1' and host is not null");
   eval CALL index_test($table, "WHERE user = 'user1' and host = '$target_host' and `role` is null");
   eval CALL index_test($table, "WHERE user = 'user1' and host = '$target_host' and `role` is not null");
   eval CALL index_test($table, "WHERE host = '$target_host' AND user = 'user1'");
   eval CALL index_test($table, "WHERE host = '$target_host' AND user = 'user1' AND `role` = '%'");
   eval CALL index_test($table, "WHERE host = '$target_host' AND user = 'user1' AND `role` = 'impossible'");
   eval CALL index_test($table, "WHERE host = 'nohost' AND user = 'nouser' AND `role` = '%'");
   eval CALL index_test($table, "WHERE host = '$target_host' AND user = 'nouser' AND `role` = '%'");
   eval CALL index_test($table, "WHERE host = 'nohost' AND user = 'user1' AND `role` = '%'");
}

# USER, EVENT_NAME

IF ($key_group == 3)
{
  eval CALL index_test($table, "WHERE user is null");
  eval CALL index_test($table, "WHERE user is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and event_name is null");
  eval CALL index_test($table, "WHERE user = 'user1' and event_name is not null");
  eval CALL index_test($table, "WHERE user= 'user1'");
  eval CALL index_test($table, "WHERE user= 'user1' AND event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE user= 'user1' AND event_name = 'impossible'");
  eval CALL index_test($table, "WHERE user= 'nouser' AND event_name = '$target_event_name'");
}

# USER, VARIABLE_NAME

IF ($key_group == 3.1)
{
  eval CALL index_test($table, "WHERE user is null");
  eval CALL index_test($table, "WHERE user is not null");
  eval CALL index_test($table, "WHERE user = 'user1' and variable_name is null");
  eval CALL index_test($table, "WHERE user = 'user1' and variable_name is not null");
  eval CALL index_test($table, "WHERE user= 'user1'");
  eval CALL index_test($table, "WHERE user= 'user1' AND variable_name = '$target_variable_name'");
  eval CALL index_test($table, "WHERE user= 'user1' AND variable_name = 'impossible'");
  eval CALL index_test($table, "WHERE user= 'nouser' AND variable_name = '$target_variable_name'");
}

# THREAD_ID, EVENT_NAME

IF ($key_group == 4)
{
  eval CALL index_test($table, "WHERE thread_id is null");
  eval CALL index_test($table, "WHERE thread_id is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id and event_name is null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id and event_name is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id");
  eval CALL index_test($table, "WHERE event_name != '$target_event_name'");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id ORDER BY thread_id DESC");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_name != '$target_event_name'");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_name = 'impossible'");
  eval CALL index_test($table, "WHERE thread_id > @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id < @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id >= @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id <= @target_thread_id");
}

# FIXME

IF ($key_group == 4.1)
{
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id ORDER BY thread_id DESC");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND event_name = 'impossible'");
  eval CALL index_test($table, "WHERE thread_id > @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id < @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id >= @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id <= @target_thread_id");
}

# EVENT_NAME

IF ($key_group == 5)
{
  eval CALL index_test($table, "WHERE event_name is null");
  eval CALL index_test($table, "WHERE event_name is not null");
  eval CALL index_test($table, "WHERE event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE event_name != '$target_event_name'");
  eval CALL index_test($table, "WHERE event_name = 'impossible'");
  eval CALL index_test($table, "WHERE event_name != 'impossible' ORDER BY event_name DESC");
}

# FIXME
# EVENT_NAME (for events with only 1 class)

IF ($key_group == 5.1)
{
  eval CALL index_test($table, "WHERE event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE event_name = 'impossible'");
  eval CALL index_test($table, "WHERE event_name != 'impossible' ORDER BY event_name DESC");
}

# HOST, EVENT_NAME

IF ($key_group == 6)
{
  eval CALL index_test($table, "WHERE host is null");
  eval CALL index_test($table, "WHERE host is not null");
  eval CALL index_test($table, "WHERE host = '$target_host' and event_name is null");
  eval CALL index_test($table, "WHERE host = '$target_host' and event_name is not null");
  eval CALL index_test($table, "WHERE host = '$target_host'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND event_name = '$target_event_name'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND event_name = 'impossible'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND event_name = '$target_event_name'");
}

# HOST, VARIABLE_NAME

IF ($key_group == 6.1)
{
  eval CALL index_test($table, "WHERE host is null");
  eval CALL index_test($table, "WHERE host is not null");
  eval CALL index_test($table, "WHERE host = '$target_host' and variable_name is null");
  eval CALL index_test($table, "WHERE host = '$target_host' and variable_name is not null");
  eval CALL index_test($table, "WHERE host = '$target_host'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND variable_name = '$target_variable_name'");
  eval CALL index_test($table, "WHERE host = '$target_host' AND variable_name = 'impossible'");
  eval CALL index_test($table, "WHERE host = 'nohost' AND variable_name = '$target_variable_name'");
}

# HOST

IF ($key_group == 6.2)
{
  eval CALL index_test($table, "WHERE host = '$target_host'");
  eval CALL index_test($table, "WHERE host IS NULL");
  eval CALL index_test($table, "WHERE host IS NOT NULL");
  eval CALL index_test($table, "WHERE host = 'nohost'");
}

# PROCESSLIST_HOST

IF ($key_group == 6.3)
{
  eval CALL index_test($table, "WHERE processlist_host = '$target_host'");
  eval CALL index_test($table, "WHERE processlist_host IS NULL");
  eval CALL index_test($table, "WHERE processlist_host IS NOT NULL");
  eval CALL index_test($table, "WHERE processlist_host = 'nohost'");
}

# THREAD_ID, VARIABLE_NAME

IF ($key_group == 7)
{
  eval CALL index_test($table, "WHERE thread_id is null");
  eval CALL index_test($table, "WHERE thread_id is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id and variable_name is null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id and variable_name is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id ORDER BY thread_id DESC");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND variable_name = '$target_variable_name'");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND variable_name != '$target_variable_name'");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND variable_name = 'impossible'");
  eval CALL index_test($table, "WHERE thread_id > @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id < @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id >= @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id <= @target_thread_id");
}

# VARIABLE_NAME

IF ($key_group == 8)
{
  eval CALL index_test($table, "WHERE variable_name is null");
  eval CALL index_test($table, "WHERE variable_name is not null");
  eval CALL index_test($table, "WHERE variable_name = '$target_variable_name'");
  eval CALL index_test($table, "WHERE variable_name != '$target_variable_name'");
  eval CALL index_test($table, "WHERE variable_name = 'impossible'");
  eval CALL index_test($table, "WHERE variable_name != 'impossible' ORDER BY variable_name DESC");
}

# THREAD_ID, NAME

IF ($key_group == 9)
{
  eval CALL index_test($table, "WHERE thread_id is null");
  eval CALL index_test($table, "WHERE thread_id is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id and name is null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id and name is not null");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id ORDER BY thread_id DESC");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND name = '$target_name'");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND name != '$target_name'");
  eval CALL index_test($table, "WHERE thread_id = @target_thread_id AND name = 'impossible'");
  eval CALL index_test($table, "WHERE thread_id > @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id < @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id >= @target_thread_id");
  eval CALL index_test($table, "WHERE thread_id <= @target_thread_id");
}

# PROCESSLIST_ID, ATTR_NAME -- Multiple connections

IF ($key_group == 9.1)
{
  eval CALL index_test($table, "WHERE processlist_id is null");
  eval CALL index_test($table, "WHERE processlist_id is not null");
  eval CALL index_test($table, "WHERE processlist_id = @target_id and attr_name is null");
  eval CALL index_test($table, "WHERE processlist_id = @target_id and attr_name is not null");
  eval CALL index_test($table, "WHERE processlist_id = @target_id");
  eval CALL index_test($table, "WHERE processlist_id = @target_id ORDER BY processlist_id DESC");
  eval CALL index_test($table, "WHERE processlist_id = @target_id AND attr_name = '$target_name'");
  eval CALL index_test($table, "WHERE processlist_id = @target_id AND attr_name != '$target_name'");
  eval CALL index_test($table, "WHERE processlist_id = @target_id AND attr_name = 'impossible'");
  eval CALL index_test($table, "WHERE processlist_id > @target_id");
  eval CALL index_test($table, "WHERE processlist_id < @target_id");
  eval CALL index_test($table, "WHERE processlist_id >= @target_id");
  eval CALL index_test($table, "WHERE processlist_id <= @target_id");
}

# FIXME
# PROCESSLIST_ID, ATTR_NAME -- Current connection

IF ($key_group == 9.2)
{
  eval CALL index_test($table, "WHERE processlist_id = @target_id");
  eval CALL index_test($table, "WHERE attr_name != '$target_name'");
  eval CALL index_test($table, "WHERE processlist_id = @target_id ORDER BY processlist_id DESC");
  eval CALL index_test($table, "WHERE processlist_id = @target_id AND attr_name = '$target_name'");
  eval CALL index_test($table, "WHERE processlist_id = @target_id AND attr_name != '$target_name'");
  eval CALL index_test($table, "WHERE processlist_id = @target_id AND attr_name = 'impossible'");
  eval CALL index_test($table, "WHERE processlist_id > @target_id");
  eval CALL index_test($table, "WHERE processlist_id < @target_id");
  eval CALL index_test($table, "WHERE processlist_id >= @target_id");
  eval CALL index_test($table, "WHERE processlist_id <= @target_id");
  eval CALL index_test($table, "WHERE processlist_id > 9999999");
  eval CALL index_test($table, "WHERE processlist_id < 9999999");
  eval CALL index_test($table, "WHERE processlist_id >= 9999999");
  eval CALL index_test($table, "WHERE processlist_id <= 9999999");
}

# OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME

IF ($key_group == 10)
{
  eval CALL index_test($table, "WHERE object_type is null");
  eval CALL index_test($table, "WHERE object_type is not null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema is null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema is not null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema = '$target_schema' and object_name is null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema = '$target_schema' and object_name is not null");
  eval CALL index_test($table, "WHERE object_type = '$target_type'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema = '$target_schema'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = '$target_schema' AND object_name = '$target_name'");
  eval CALL index_test($table, "WHERE object_type = 'impossible' AND object_schema = '$target_schema' AND object_name = '$target_name'");
  eval CALL index_test($table, "WHERE object_type = 'impossible'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = 'impossible'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = '$target_schema' AND object_name = 'impossible'");
}

# OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME

IF ($key_group == 10.1)
{
  eval CALL index_test($table, "WHERE owner_object_type is null");
  eval CALL index_test($table, "WHERE owner_object_type is not null");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type' and owner_object_schema is null");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type' and owner_object_schema is not null");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type' and owner_object_schema = '$target_schema' and owner_object_name is null");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type' and owner_object_schema = '$target_schema' and owner_object_name is not null");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type'");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type' AND owner_object_schema = '$target_schema'");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type' AND owner_object_schema = '$target_schema' AND owner_object_name = '$target_name'");
  eval CALL index_test($table, "WHERE owner_object_type = 'impossible' AND owner_object_schema = '$target_schema' AND owner_object_name = '$target_name'");
  eval CALL index_test($table, "WHERE owner_object_type = 'impossible'");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type' AND owner_object_schema = 'impossible'");
  eval CALL index_test($table, "WHERE owner_object_type = '$target_type' AND owner_object_schema = '$target_schema' AND owner_object_name = 'impossible'");
}

# OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, INDEX_NAME

IF ($key_group == 11)
{
  eval CALL index_test($table, "WHERE object_type is null");
  eval CALL index_test($table, "WHERE object_type is not null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema is null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema is not null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema = '$target_schema' and object_name is null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema = '$target_schema' and object_name is not null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema = '$target_schema' and object_name = '$target_name' and index_name is null");
  eval CALL index_test($table, "WHERE object_type = '$target_type' and object_schema = '$target_schema' and object_name = '$target_name' and index_name is not null");
  eval CALL index_test($table, "WHERE object_type = '$target_type'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = '$target_schema'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = '$target_schema' AND object_name = '$target_name'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = '$target_schema' AND object_name = '$target_name' AND index_name = '$target_index'");
  eval CALL index_test($table, "WHERE object_type = 'impossible' AND object_schema = '$target_schema' AND object_name = '$target_name'");
  eval CALL index_test($table, "WHERE object_type = 'impossible'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = 'impossible'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = '$target_schema' AND object_name = 'impossible'");
  eval CALL index_test($table, "WHERE object_type = '$target_type' AND object_schema = '$target_schema' AND object_name = '$target_name' AND index_name = 'impossible'");
}

# OBJECT_INSTANCE_BEGIN

IF ($key_group == 12)
{
  eval CALL index_test($table, "WHERE object_instance_begin is null");
  eval CALL index_test($table, "WHERE object_instance_begin is not null");
  eval CALL index_test($table, "WHERE object_instance_begin = @object_instance_begin");

  # NOTE: The following test is disabled for metadata locks because it will give
  # a different number of locks for indexed and non-indexed access. The
  # non-indexed access will try to use histogram statistics, and will thus use
  # one more metadata lock.
  IF ($table != "metadata_locks")
  {
    eval CALL index_test($table, "WHERE object_instance_begin != @object_instance_begin");
  }

  eval CALL index_test($table, "WHERE object_instance_begin = '9999999999'");
}

# GENERIC NAME - EVENT_NAME / NAME / STATEMENT_NAME

IF ($key_group == 13)
{
  eval CALL index_test($table, "WHERE $name_column is null");
  eval CALL index_test($table, "WHERE $name_column is not null");
  eval CALL index_test($table, "WHERE $name_column = '$target_name'");
  eval CALL index_test($table, "WHERE $name_column != '$target_name'");
  eval CALL index_test($table, "WHERE $name_column = 'impossible'");
  eval CALL index_test($table, "WHERE $name_column != 'impossible' ORDER BY $name_column DESC");
}

# FIXME
# FILE_NAME

IF ($key_group == 13.1)
{
  eval CALL index_test($table, "WHERE $name_column = @target_name");
  eval CALL index_test($table, "WHERE $name_column != @target_name");
  eval CALL index_test($table, "WHERE $name_column = 'impossible'");
  eval CALL index_test($table, "WHERE $name_column != 'impossible' ORDER BY $name_column DESC");
}

# GENERIC ID - THREAD_ID / LOCKED_BY_THREAD_ID / STATEMENT_ID / SOCKET_ID

IF ($key_group == 14)
{
  eval CALL index_test($table, "WHERE $id_column is null");
  eval CALL index_test($table, "WHERE $id_column is not null");
  eval CALL index_test($table, "WHERE $id_column = @target_id");
  eval CALL index_test($table, "WHERE $id_column = @target_id ORDER BY $id_column");
  eval CALL index_test($table, "WHERE $id_column = @target_id ORDER BY $id_column DESC");
  eval CALL index_test($table, "WHERE $id_column = 9999999 ORDER BY $id_column");
}

# IP

IF ($key_group == 15)
{
  eval CALL index_test($table, "WHERE IP is null");
  eval CALL index_test($table, "WHERE IP is not null");
  eval CALL index_test($table, "WHERE IP = '$target_ip'");
  #eval CALL index_test($table, "WHERE IP != '$target_ip'");
  eval CALL index_test($table, "WHERE IP = 'impossible'");
}

# PORT

IF ($key_group == 16)
{
  eval CALL index_test($table, "WHERE port is null");
  eval CALL index_test($table, "WHERE port is not null");
  eval CALL index_test($table, "WHERE port = @target_port");
  eval CALL index_test($table, "WHERE port = @target_port ORDER BY port");
  eval CALL index_test($table, "WHERE port = 9999999");
  eval CALL index_test($table, "WHERE port > 9999999");
  eval CALL index_test($table, "WHERE port < 9999999");
  eval CALL index_test($table, "WHERE port >= 9999999");
  eval CALL index_test($table, "WHERE port <= 9999999");
}

# IP, PORT

IF ($key_group == 16.1)
{
  eval CALL index_test($table, "WHERE IP is null");
  eval CALL index_test($table, "WHERE IP is not null");
  eval CALL index_test($table, "WHERE IP = '$target_ip' and port is null");
  eval CALL index_test($table, "WHERE IP = '$target_ip' and port is not null");
  eval CALL index_test($table, "WHERE IP = '$target_ip'");
  eval CALL index_test($table, "WHERE IP = 'impossible'");
  eval CALL index_test($table, "WHERE IP = '$target_ip' AND port = @target_port");
  eval CALL index_test($table, "WHERE IP = '$target_ip' AND port = 9999999");
  eval CALL index_test($table, "WHERE IP = 'impossible' AND port = @target_port");
  eval CALL index_test($table, "WHERE port = @target_port");
}

# SCHEMA_NAME, DIGEST

IF ($key_group == 17)
{
  eval CALL index_test($table, "WHERE schema_name is null");
  eval CALL index_test($table, "WHERE schema_name is not null");
  eval CALL index_test($table, "WHERE schema_name = '$target_schema' and digest is null");
  eval CALL index_test($table, "WHERE schema_name = '$target_schema' and digest is not null");
  eval CALL index_test($table, "WHERE schema_name = '$target_schema'");
  eval CALL index_test($table, "WHERE schema_name != '$target_schema'");
  eval CALL index_test($table, "WHERE schema_name = '$target_schema' AND digest = @target_digest");
  eval CALL index_test($table, "WHERE schema_name = '$target_schema' AND digest = 'impossible'");
  eval CALL index_test($table, "WHERE schema_name = 'noschema_name' AND digest = @target_digest");
}

# CHANNEL_NAME

IF ($key_group == 18)
{
  eval CALL index_test($table, "WHERE CHANNEL_NAME is null");
  eval CALL index_test($table, "WHERE CHANNEL_NAME is not null");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = $target_channel_name");
  eval CALL index_test($table, "WHERE CHANNEL_NAME != $target_channel_name");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = 'impossible'");
  eval CALL index_test($table, "WHERE CHANNEL_NAME != 'impossible' ORDER BY CHANNEL_NAME DESC");
}

# CHANNEL_NAME, WORKER_ID

IF ($key_group == 18.1)
{
  eval CALL index_test($table, "WHERE CHANNEL_NAME is null");
  eval CALL index_test($table, "WHERE CHANNEL_NAME is not null");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = $target_channel_name");
  eval CALL index_test($table, "WHERE CHANNEL_NAME != $target_channel_name");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = 'impossible'");
  eval CALL index_test($table, "WHERE CHANNEL_NAME != 'impossible' ORDER BY CHANNEL_NAME DESC");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = $target_channel_name AND WORKER_ID is null");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = $target_channel_name AND WORKER_ID is not null");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = $target_channel_name AND WORKER_ID = $target_worker_id");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = $target_channel_name AND WORKER_ID != $target_worker_id");
  eval CALL index_test($table, "WHERE CHANNEL_NAME = $target_channel_name AND WORKER_ID = 9999");
}

--enable_query_log