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