Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
perl ./mtr main.cte_recursive --ps-protocol
|
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;
|
|