set sql_mode=oracle;
use test;
create table t2 (c1 integer, c2 integer);
DELIMITER $$
CREATE or replace procedure ps_row_and_alias()
AS
  a INT;
  b INT;
BEGIN
  select a.c1 into b
    from t2 a
   where a.c2 = 0;
  return ;
END;
$$
DELIMITER ;
drop table t2;

