1SET @@session.default_storage_engine = 'InnoDB'; 2create table t1 (a int, 3b int as (-a), 4c int as (-a) persistent, 5d char(1), 6index (a), 7index (c)); 8insert into t1 (a,d) values (4,'a'), (2,'b'), (1,'c'), (3,'d'); 9select * from t1; 10a b c d 114 -4 -4 a 122 -2 -2 b 131 -1 -1 c 143 -3 -3 d 15# HANDLER tbl_name OPEN 16handler t1 open; 17# HANDLER tbl_name READ non-vcol_index_name > (value1,value2,...) 18handler t1 read a > (2); 19a b c d 203 -3 -3 d 21# HANDLER tbl_name READ non-vcol_index_name > (value1,value2,...) WHERE non-vcol_field=expr 22handler t1 read a > (2) where d='c'; 23a b c d 24# HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 25handler t1 read c = (-2); 26a b c d 272 -2 -2 b 28# HANDLER tbl_name READ vcol_index_name = (value1,value2,...) WHERE non-vcol_field=expr 29handler t1 read c = (-2) where d='c'; 30a b c d 31# HANDLER tbl_name READ non-vcol_index_name > (value1,value2,...) WHERE vcol_field=expr 32handler t1 read a > (2) where b=-3 && c=-3; 33a b c d 343 -3 -3 d 35# HANDLER tbl_name READ vcol_index_name <= (value1,value2,...) 36handler t1 read c <= (-2); 37a b c d 382 -2 -2 b 39# HANDLER tbl_name READ vcol_index_name > (value1,value2,...) WHERE vcol_field=expr 40handler t1 read c <= (-2) where b=-3; 41a b c d 423 -3 -3 d 43# HANDLER tbl_name READ vcol_index_name FIRST 44handler t1 read c first; 45a b c d 464 -4 -4 a 47# HANDLER tbl_name READ vcol_index_name NEXT 48handler t1 read c next; 49a b c d 503 -3 -3 d 51# HANDLER tbl_name READ vcol_index_name PREV 52handler t1 read c prev; 53a b c d 544 -4 -4 a 55# HANDLER tbl_name READ vcol_index_name LAST 56handler t1 read c last; 57a b c d 581 -1 -1 c 59# HANDLER tbl_name READ FIRST where non-vcol=expr 60handler t1 read FIRST where a >= 2; 61a b c d 624 -4 -4 a 63# HANDLER tbl_name READ FIRST where vcol=expr 64handler t1 read FIRST where b >= -2; 65a b c d 662 -2 -2 b 67# HANDLER tbl_name READ NEXT where non-vcol=expr 68handler t1 read NEXT where d='c'; 69a b c d 701 -1 -1 c 71# HANDLER tbl_name READ NEXT where vcol=expr 72handler t1 read NEXT where b<=-4; 73a b c d 74# HANDLER tbl_name CLOSE 75handler t1 close; 76drop table t1; 77