Data definition | Adaptive Server IQ 12.4.0 |
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
10 | Release Bulletin for Digital UNIX |