main.cte_recursive [ fail ]
|
Test ended at 2016-09-24 17:14:40
|
|
CURRENT_TEST: main.cte_recursive
|
mysqltest: At line 1165: query 'create table my_ancestors
|
with recursive
|
ancestor_ids (id)
|
as
|
(
|
select father from folks where name = 'Me'
|
union
|
select mother from folks where name = 'Me'
|
union
|
select father from folks, ancestor_ids a where folks.id = a.id
|
union
|
select mother from folks, ancestor_ids a where folks.id = a.id
|
)
|
select p.* from folks as p, ancestor_ids as a where p.id = a.id' failed: 1146: Table 'test.ancestor_ids' doesn't exist
|
|
The result from queries just before the failure was:
|
< snip >
|
}
|
}
|
}
|
}
|
}
|
}
|
create table my_ancestors
|
with recursive
|
ancestor_ids (id)
|
as
|
(
|
select father from folks where name = 'Me'
|
union
|
select mother from folks where name = 'Me'
|
union
|
select father from folks, ancestor_ids a where folks.id = a.id
|
union
|
select mother from folks, ancestor_ids a where folks.id = a.id
|
)
|
select p.* from folks as p, ancestor_ids as a where p.id = a.id;
|
|