# Slow test, don't run during staging part

--source include/not_staging.inc

--source include/have_xtradb.inc

let $engine_type= InnoDB;

set @optimizer_switch_save= @@optimizer_switch;

set optimizer_switch='index_merge_sort_intersection=off';

eval SET SESSION STORAGE_ENGINE = $engine_type;

--disable_warnings

drop table if exists t1;

--enable_warnings

# Testcase for BUG#4984

create table t1

(

  RUNID varchar(22),

  SUBMITNR varchar(5),

  ORDERNR char(1),

  PROGRAMM varchar(8),

  TESTID varchar(4),

  UCCHECK char(1),

  ETEXT varchar(80),

  ETEXT_TYPE char(1),

  INFO char(1),

  SEVERITY tinyint(3),

  TADIRFLAG char(1),

  PRIMARY KEY  (RUNID,SUBMITNR,ORDERNR,PROGRAMM,TESTID,UCCHECK),

  KEY `TVERM~KEY`  (PROGRAMM,TESTID,UCCHECK)

) DEFAULT CHARSET=latin1;

update t1 set `ETEXT` = '', `ETEXT_TYPE`='', `INFO`='', `SEVERITY`='', `TADIRFLAG`=''

WHERE

 `RUNID`= '' AND `SUBMITNR`= '' AND `ORDERNR`='' AND `PROGRAMM`='' AND

 `TESTID`='' AND `UCCHECK`='';

drop table t1;

set optimizer_switch= @optimizer_switch_save;

==3333== Thread 16:

==3333== Conditional jump or move depends on uninitialised value(s)

==3333==    at 0x947AF3: is_key_scan_ror(PARAM*, unsigned int, unsigned char) (opt_range.cc:10621)

==3333==    by 0x932DC6: sel_arg_range_seq_next(void*, st_key_multi_range*) (opt_range_mrr.cc:293)

==3333==    by 0x793F6A: handler::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, COST_VECT*) (multi_range_read.cc:71)

==3333==    by 0x79711C: DsMrr_impl::dsmrr_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, COST_VECT*) (multi_range_read.cc:1451)

==3333==    by 0xB490AD: ha_innobase::multi_range_read_info_const(unsigned int, st_range_seq_if*, void*, unsigned int, unsigned int*, unsigned int*, COST_VECT*) (ha_innodb.cc:14134)

==3333==    by 0x947690: check_quick_select(PARAM*, unsigned int, bool, SEL_ARG*, bool, unsigned int*, unsigned int*, COST_VECT*) (opt_range.cc:10507)

==3333==    by 0x93FD8C: get_key_scans_params(PARAM*, SEL_TREE*, bool, bool, double) (opt_range.cc:7162)

==3333==    by 0x937454: SQL_SELECT::test_quick_select(THD*, Bitmap<64u>, unsigned long long, unsigned long long, bool, bool) (opt_range.cc:3118)

==3333==    by 0x704042: SQL_SELECT::check_quick(THD*, bool, unsigned long long) (opt_range.h:997)

==3333==    by 0x6FDD12: mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, enum_duplicates, bool, unsigned long long*, unsigned long long*) (sql_update.cc:419)

==3333==    by 0x634B2D: mysql_execute_command(THD*) (sql_parse.cc:3053)

==3333==    by 0x63D444: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:6101)

==3333==    by 0x62FFB2: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1113)

==3333==    by 0x62F396: do_command(THD*) (sql_parse.cc:819)

==3333==    by 0x752AF6: do_handle_one_connection(THD*) (sql_connect.cc:1266)

==3333==    by 0x752864: handle_one_connection (sql_connect.cc:1181)

^ Found warnings in /run/shm/var_auto_SW5b/log/mysqld.1.err