--source include/have_innodb.inc

CREATE TABLE t1 (pk INT, a INT, b INT, PRIMARY KEY (pk), KEY(b), KEY(b)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1,6,0),(2,1,0),(3,5,2),(4,8,0);

CREATE TABLE t2 (c INT) ENGINE=InnoDB;

INSERT INTO t2 VALUES (1),(2);

CREATE TABLE t3 (d INT) ENGINE=InnoDB;

INSERT INTO t3 VALUES (3),(4);

CREATE ALGORITHM = MERGE VIEW v AS SELECT pk, a, b FROM t1, t2 WHERE pk < c AND b = '0';

# Only needed on 5.5

SET optimizer_switch='extended_keys=on';

SELECT * FROM v, t3 WHERE b >= d;

# Cleanup

DROP VIEW v;

DROP TABLE t1, t2, t3;

#3  <signal handler called>

#4  0x00005639d4bb116a in SEL_ARG::store_min (this=0x7f9b7c04afb8, length=5, min_key=0x7f9bd0372100, min_key_flag=0) at /data/src/10.3/sql/opt_range.h:413

#5  0x00005639d4b9a5f2 in ror_scan_selectivity (info=0x7f9b7c04b5e8, scan=0x7f9b7c04b540) at /data/src/10.3/sql/opt_range.cc:6241

#6  0x00005639d4b9aa9f in ror_intersect_add (info=0x7f9b7c04b5e8, ror_scan=0x7f9b7c04b540, is_cpk_scan=false) at /data/src/10.3/sql/opt_range.cc:6323

#7  0x00005639d4b9b2e3 in get_best_ror_intersect (param=0x7f9bd0373400, tree=0x7f9b7c04aec0, read_time=3.8999999999999999, are_all_covering=0x7f9bd03732df) at /data/src/10.3/sql/opt_range.cc:6524

#8  0x00005639d4b9285e in SQL_SELECT::test_quick_select (this=0x7f9b7c044850, thd=0x7f9b7c000b00, keys_to_use=..., prev_tables=4611686018427387910, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=false) at /data/src/10.3/sql/opt_range.cc:2610

#9  0x00005639d4796def in make_join_select (join=0x7f9b7c01a160, select=0x7f9b7c044210, cond=0x7f9b7c041f30) at /data/src/10.3/sql/sql_select.cc:10774

#10 0x00005639d477d982 in JOIN::optimize_stage2 (this=0x7f9b7c01a160) at /data/src/10.3/sql/sql_select.cc:2142

#11 0x00005639d477cadd in JOIN::optimize_inner (this=0x7f9b7c01a160) at /data/src/10.3/sql/sql_select.cc:1914

#12 0x00005639d477b03d in JOIN::optimize (this=0x7f9b7c01a160) at /data/src/10.3/sql/sql_select.cc:1451

#13 0x00005639d4784c64 in mysql_select (thd=0x7f9b7c000b00, tables=0x7f9b7c014ef8, wild_num=1, fields=..., conds=0x7f9b7c015e20, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f9b7c01a138, unit=0x7f9b7c0049c8, select_lex=0x7f9b7c005138) at /data/src/10.3/sql/sql_select.cc:4225

#14 0x00005639d4776c20 in handle_select (thd=0x7f9b7c000b00, lex=0x7f9b7c004900, result=0x7f9b7c01a138, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:385

#15 0x00005639d4741617 in execute_sqlcom_select (thd=0x7f9b7c000b00, all_tables=0x7f9b7c014ef8) at /data/src/10.3/sql/sql_parse.cc:6548

#16 0x00005639d4737f36 in mysql_execute_command (thd=0x7f9b7c000b00) at /data/src/10.3/sql/sql_parse.cc:3821

#17 0x00005639d47455b5 in mysql_parse (thd=0x7f9b7c000b00, rawbuf=0x7f9b7c014ce8 "SELECT * FROM v, t3 WHERE b >= d", length=32, parser_state=0x7f9bd03755f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8091

#18 0x00005639d4732884 in dispatch_command (command=COM_QUERY, thd=0x7f9b7c000b00, packet=0x7f9b7c162261 "SELECT * FROM v, t3 WHERE b >= d", packet_length=32, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1857

#19 0x00005639d473126e in do_command (thd=0x7f9b7c000b00) at /data/src/10.3/sql/sql_parse.cc:1403

#20 0x00005639d4899df5 in do_handle_one_connection (connect=0x5639d8310030) at /data/src/10.3/sql/sql_connect.cc:1402

#21 0x00005639d4899b79 in handle_one_connection (arg=0x5639d8310030) at /data/src/10.3/sql/sql_connect.cc:1308

#22 0x00005639d4d36617 in pfs_spawn_thread (arg=0x5639d82553f0) at /data/src/10.3/storage/perfschema/pfs.cc:1862

#23 0x00007f9bd86be494 in start_thread (arg=0x7f9bd0376700) at pthread_create.c:333

#24 0x00007f9bd688c93f in clone () from /lib/x86_64-linux-gnu/libc.so.6