TYPE=VIEW
query=select `outer_table`.`a` AS `a`,`outer_table`.`b` AS `b`,(select _utf8\'Y\' AS `Y` where exists(select _utf8\'X\' AS `X` from `test`.`t1` `inner_table` where (`inner_table`.`b` = `outer_table`.`a`))) AS `(SELECT \'Y\' FROM DUAL WHERE EXISTS (SELECT \'X\' FROM t1 inner_table WHERE inner_table.b = outer_table.a))` from `test`.`t1` `outer_table`
md5=39317fd3b4844261d4f32f9a2a5bb641
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=1
timestamp=2008-03-11 09:59:47
create-version=1
source=SELECT a, b, (SELECT \'Y\' FROM DUAL WHERE EXISTS (SELECT \'X\' FROM t1 inner_table WHERE inner_table.b = outer_table.a)) \n FROM t1 outer_table