Sybase IQ 12.4.0 Server User Manual


 
Adaptive Server IQ 12.4.0 Large IN subqueries
Release Bulletin for Digital UNIX 11
•= ALL
•!= ALL
If you use an unsupported query in this group, Adaptive Server IQ returns an
error like the following:
Feature, ANY, not yet implemented
Queries of this type can always be expressed in terms of IN subqueries or scalar
subqueries using MIN and MAX set functions.
7.2.2 Large IN subqueries
There is a known performance limitation in Adaptive Server IQ version 12 that
affects IN subqueries that return more than 1 million distinct values; such
queries should be rewritten in term of correlated EXISTS subqueries until this
server limitation is addressed.
7.3 Adaptive Server IQ Operations
This section reports problems with Adaptive Server IQ operations.
7.3.1 Output to file in DBISQL
There are known problems in using the output to file feature from a DBISQL
session that will cause a server to abort. Do not use this feature in this release.
Instead, put
>
filename
on the end of a select statement.
The cases that cause the abort are:
Using the feature when the IQ option
Force_No_Scroll_Cursors is set to
ON
Performing a rollback command following the
output to command, as in
select * from ....;
output to file;
rollback;
7.3.2 Changing length of DBISQL column values
By default, the maximum length of column values displayed by DBISQL is 30
characters. This may be inadequate for displaying output of stored procedures
such as
sp_iqstatus.