| 1 |
set @save_big_tables=@@big_tables; |
| 2 |
set big_tables=1; |
| 3 |
Warnings: |
| 4 |
Warning 1287 '@@big_tables' is deprecated and will be removed in a future release |
| 5 |
create table folks(id int, name char(32), dob date, father int, mother int); |
| 6 |
insert into folks values |
| 7 |
(100, 'Me', '2000-01-01', 20, 30), |
| 8 |
(20, 'Dad', '1970-02-02', 10, 9), |
| 9 |
(30, 'Mom', '1975-03-03', 8, 7), |
| 10 |
(10, 'Grandpa Bill', '1940-04-05', null, null), |
| 11 |
(9, 'Grandma Ann', '1941-10-15', null, null), |
| 12 |
(25, 'Uncle Jim', '1968-11-18', 8, 7), |
| 13 |
(98, 'Sister Amy', '2001-06-20', 20, 30), |
| 14 |
(7, 'Grandma Sally', '1943-08-23', null, 6), |
| 15 |
(8, 'Grandpa Ben', '1940-10-21', null, null), |
| 16 |
(6, 'Grandgrandma Martha', '1923-05-17', null, null), |
| 17 |
(67, 'Cousin Eddie', '1992-02-28', 25, 27), |
| 18 |
(27, 'Auntie Melinda', '1971-03-29', null, null); |
| 19 |
call mtr.add_suppression(".*marked as crashed.*"); |
| 20 |
SET @saved_dbug= @@SESSION.debug_dbug; |
| 21 |
SET SESSION debug_dbug="+d,ha_rnd_next_error"; |
| 22 |
SET @ha_rnd_next_error_counter=110; |
| 23 |
with recursive |
| 24 |
ancestor_couples(h_id, h_name, h_dob, h_father, h_mother, |
| 25 |
w_id, w_name, w_dob, w_father, w_mother) |
| 26 |
as |
| 27 |
( |
| 28 |
select h.*, w.* |
| 29 |
from folks h, folks w, coupled_ancestors a |
| 30 |
where a.father = h.id AND a.mother = w.id |
| 31 |
union |
| 32 |
select h.*, w.* |
| 33 |
from folks v, folks h, folks w |
| 34 |
where v.name = 'Me' and |
| 35 |
(v.father = h.id AND v.mother= w.id) |
| 36 |
), |
| 37 |
coupled_ancestors (id, name, dob, father, mother) |
| 38 |
as |
| 39 |
( |
| 40 |
select h_id, h_name, h_dob, h_father, h_mother |
| 41 |
from ancestor_couples |
| 42 |
union |
| 43 |
select w_id, w_name, w_dob, w_father, w_mother |
| 44 |
from ancestor_couples |
| 45 |
) |
| 46 |
select h_name, h_dob, w_name, w_dob |
| 47 |
from ancestor_couples; |
| 48 |
ERROR HY000: Table '(temporary)' is marked as crashed and should be repaired |
| 49 |
drop table folks; |
| 50 |
set big_tables=@save_big_tables; |
| 51 |
Warnings: |
| 52 |
Warning 1287 '@@big_tables' is deprecated and will be removed in a future release |
| 53 |
SET @@SESSION.debug_dbug=@saved_dbug; |