Skip to Content
0
Apr 23, 2018 at 06:41 AM

Using table variable in a derived table raises 225 error if statement cache enabled

113 Views

Hello,

SAP ASE 16.0 SP03 PL02

1> declare @t table (a int)
2> insert into @t values (10)
3> select * from (select * from @t) t
4> go
(1 row affected)
Msg 225, Level 16, State 1:
Server 'ASE1603', Line 3:
Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.

This error doesn't occur when statement cache is disabled.
Could you check this behavior?

Regards,
Kazuo Otani