Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Not a Bug
-
10.0.16-galera
-
None
-
debian 7
Description
create table `entreprise` ( |
`ent_id` int not null AUTO_INCREMENT, |
PRIMARY KEY (`ent_id`) |
);
|
create table `employee` ( |
`emp_id` int not null AUTO_INCREMENT, |
`room_id` int, |
PRIMARY KEY (`emp_id`) |
);
|
create table `room` ( |
`room_id` int not null AUTO_INCREMENT, |
`ent_id` int not null, |
PRIMARY KEY (`room_id`) |
);
|
delete from `employee` E |
where not exists(select 1 |
from `entreprise` a |
join `rooms` r on r.`ent_id` = a.`ent_id` and r.`room_id` = e.`room_id`); |
Error column e.room_id is unknown