DROP TABLE IF EXISTS test_row_count;
DROP TABLE IF EXISTS merge_tab_row_count;
DROP TABLE IF EXISTS test_row_count1;
DROP TABLE IF EXISTS test_row_count2;
DROP PROCEDURE IF EXISTS proc_row_count;
select row_count();
create table test_row_count(a int);
create table merge_tab_row_count(a int);
select row_count();
insert into test_row_count values(1),(2),(3),(4),(5);
select row_count();
insert into merge_tab_row_count values(7);
select row_count();
merge into merge_tab_row_count using test_row_count on (test_row_count.a = merge_tab_row_count.a)
when not matched then insert values(6);
update test_row_count set a = 7 where a = 1;
select row_count();
delete from test_row_count where a < 4;
select row_count();
truncate table test_row_count;
select row_count();
select * into test_row_count1 from merge_tab_row_count;
select row_count();
insert into test_row_count values(99999999999999999999999999);
select row_count();
drop table merge_tab_row_count1;
select row_count();
select * from merge_tab_row_count1;
select row_count();
create table test_row_count2(a int);
create table test_row_count2(a int);
select row_count();

create procedure proc_row_count(a out int, b out int)
as
begin
  insert into test_row_count values(1),(2);
  select row_count() into a;
  raise info 'a=%',a;
  insert into test_row_count values(3);
  select row_count() into b;
  raise info 'b=%',b;
  insert into test_row_count values(4);
  insert into test_row_count values(5);
end;
/
call proc_row_count(a,b);
select row_count();
DROP TABLE IF EXISTS test_row_count;
DROP TABLE IF EXISTS test_row_count1;
DROP TABLE IF EXISTS test_row_count2;
DROP TABLE IF EXISTS merge_tab_row_count;
DROP PROCEDURE IF EXISTS proc_row_count;
select row_count();