@@ -5549,82 +5549,6 @@ id select_type table type possible_keys key key_len ref rows Extra
554955491 PRIMARY t2 ALL NULL NULL NULL NULL 3 Using where; Using join buffer (Block Nested Loop)
555055502 DEPENDENT SUBQUERY t3 unique_subquery PRIMARY PRIMARY 4 func 1 Using index
55515551drop table t0, t1, t2, t3;
5552- create table t1 (a int not null);
5553- drop procedure if exists p1|
5554- CREATE PROCEDURE p1()
5555- BEGIN
5556- DECLARE EXIT HANDLER FOR SQLEXCEPTION select a from t1;
5557- prepare s1 from '
5558- select a from t1 where a in (
5559- select a from t1 where a in (
5560- select a from t1 where a in (
5561- select a from t1 where a in (
5562- select a from t1 where a in (
5563- select a from t1 where a in (
5564- select a from t1 where a in (
5565- select a from t1 where a in (
5566- select a from t1 where a in (
5567- select a from t1 where a in (
5568- select a from t1 where a in (
5569- select a from t1 where a in (
5570- select a from t1 where a in (
5571- select a from t1 where a in (
5572- select a from t1 where a in (
5573- select a from t1 where a in (
5574- select a from t1 where a in (
5575- select a from t1 where a in (
5576- select a from t1 where a in (
5577- select a from t1 where a in (
5578- select a from t1 where a in (
5579- select a from t1 where a in (
5580- select a from t1 where a in (
5581- select a from t1 where a in (
5582- select a from t1 where a in (
5583- select a from t1 where a in (
5584- select a from t1 where a in (
5585- select a from t1 where a in (
5586- select a from t1 where a in (
5587- select a from t1 where a in (
5588- select a from t1 where a in (
5589- select a from t1 where a in (
5590- select a from t1 where a in (
5591- select a from t1 where a in (
5592- select a from t1 where a in (
5593- select a from t1 where a in (
5594- select a from t1 where a in (
5595- select a from t1 where a in (
5596- select a from t1 where a in (
5597- select a from t1 where a in (
5598- select a from t1 where a in (
5599- select a from t1 where a in (
5600- select a from t1 where a in (
5601- select a from t1 where a in (
5602- select a from t1 where a in (
5603- select a from t1 where a in (
5604- select a from t1 where a in (
5605- select a from t1 where a in (
5606- select a from t1 where a in (
5607- select a from t1 where a in (
5608- select a from t1 where a in (
5609- select a from t1 where a in (
5610- select a from t1 where a in (
5611- select a from t1 where a in (
5612- select a from t1 where a in (
5613- select a from t1 where a in (
5614- select a from t1 where a in (
5615- select a from t1 where a in (
5616- select a from t1 where a in (
5617- select a from t1 where a in (
5618- select a from t1 where a in (
5619- select a from t1 where a in ( select a from t1)
5620- )))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))';
5621- execute s1;
5622- END;
5623- |
5624- call p1();
5625- a
5626- drop procedure p1;
5627- drop table t1;
56285552create table t0 (a int);
56295553insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
56305554create table t1 (a int) as select A.a + 10 *(B.a + 10*C.a) as a from t0 A, t0 B, t0 C;
0 commit comments