Re: what's wrong with that ?

[Roland Bouman]

The exists works fine. Convince yourself:

delimiter //

create table t(id int)
//
create procedure pexists()
begin
if exists (Select * from t) then
select true;
else
select false;
end if;
end;
//
call pexists()
//
+-------+
| FALSE |
+-------+
| 0 |
+-------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

insert into t values (1)
//

call pexists()
//

+------+
| TRUE |
+------+
| 1 |
+------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)