oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: yuchen.wyc
5
# owner group: SQL1
6
# description: 测试带别名的并且走索引的语句
7

8
--disable_query_log
9
--source mysql_test/include/index_quick_major.inc
10
--real_sleep 1
11
--disable_warnings
12
drop table if exists t1;
13
--enable_warnings
14
--enable_query_log
15

16

17
create table t1 (c1 int primary key, c2 int, c3 int, c4 int);
18
create index i1 on t1(c2);
19

20
let $index_name = __idx_3003_i1;
21
--source mysql_test/include/check_all_idx_ok.inc
22

23
insert into t1 values(10, 1, 1, 1), (9, 2, 2, 2), (8, 3, 3, 3), (7, 4, 4, 4);
24

25
select * from t1 where c2 > 0 and c2 < 5;
26
select * from t1 b where b.c2 > 0 and b.c2 < 5;
27
select /*+index(t1 i1) */ * from t1 b where b.c2 > 0 and b.c2 < 5;
28
select /*+index(b i1) */ * from t1 b where b.c2 > 0 and b.c2 < 5;
29

30
drop table t1;
31

32

33