Sybase IQ 12.4.0 Server User Manual


 
Data definition Adaptive Server IQ 12.4.0
10
Release Bulletin for Digital UNIX
7.1 Data definition
This section reports problems with data definition.
7.1.1 Temporary tables in procedures
When you include an automatically created temporary table in a procedure, the
table should be dropped automatically when the procedure completes.
In Adaptive Server IQ 12.4.0, however, the table is not dropped. As a result, it
becomes visible outside the procedure, and a new instance of the table is
created each time the procedure executes. These tables instances are not
dropped until you disconnect.
This problem will be corrected in a future release. As a workaround in this
release, put an explicit
drop table
#temp_table_name
at the end of the procedure.
For example, the following procedure has been corrected so that the
automatically created temporary table, #temp0, is explicitly dropped and will
not be replicated.
create procedure foo
begin
select * into #temp0 from table
drop table #temp0 /* this line fixes the problem*/
end
7.2 Adaptive Server IQ Queries
This section reports problems with Adaptive Server IQ queries.
7.2.1 ANY, SOME, and ALL subquery support
Adaptive Server IQ does not yet support subqueries that use the ANY, ALL or
SOME keywords. For example:
•> ALL
>= ALL
•< ALL
<= ALL