#5 Select from local tables crash server process

[sbettini]

Hello, major problem trying to use local tables.

Every procedure that tries to select data from a local table to produce a recordset (the ideal reporting way in my opinion) cause a server-crash at call time.

Strangely, a simple select count(*) from local_table work as expected.

I'm working with v. 11.0.1.0806.

Sample to reproduce the problem:

PROCEDURE test( );
BEGIN
declare TABLE tlocal (
id INT ,
DENOMINAZIONE varchar(50) IGNORE_CASE ,
CONSTRAINT PK PRIMARY KEY (id)
);

insert into tlocal (id, denominazione) values (1, "111");
insert into tlocal (id, denominazione) values (2, "222");

select count(*) from tlocal;        // This work

// select * from tlocal; // This crash the server

END