10 lines
258 B
Plaintext
10 lines
258 B
Plaintext
# TestQueryTime
|
|
set @a = now(6);
|
|
drop table if exists t;
|
|
create table t(a int);
|
|
insert into t values (1), (1), (1), (1), (1);
|
|
select * from t t1 join t t2 on t1.a = t2.a;
|
|
## should less than 1 second
|
|
select timestampdiff(microsecond, @a, now(6)) < 1000000;
|
|
|