Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:629367

CR Number:   629367 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   AIX Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 21 May 2010 Added to user documentation Description Catalog DB and IQ store of IQ do not support NAS.

CR:629497

CR Number:   629497 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 15 Jul 2010 Fixed Description A SELECT query with a two table join intermittently produced an incorrect result. The result depended on the method the query optimizer chose to process the pushed down predicate of a hash pushed down join.

CR:629523

CR Number:   629523 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 21 Mar 2011 Added to user documentation Description With the imsl timeseries functions an error number is reported but no error text. Please document that a list of errors can be found in the files imslerr.dat and imsls_e.dat

CR:629542

CR Number:   629542 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Aug 2011 Presently Not Targeted For Any Future Release Of This Product Description When there is a problem with calling time series within the imsl library functions then only errornumber and no errortext is put into the logfile or send to the client

CR:629701

CR Number:   629701 Product Name:   IQ Product Component:   other Status:   Closed OS:   Linux Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Nov 2013 Duplicate Description multiplex system running a stored procedure which alters some ddl gets st_server.cxx:1376 crash. On HP the stack does not have the sq symbols printed so you see this for example.... /opt/sybase/IQ-15_1/IQ-15_1/lib64/libiqserv15_r.so [0x400011f52d8] /opt/sybase/IQ-15_1/IQ-15_1/lib64/libiqserv15_r.so [0x400011f5534] /opt/sybase/IQ-15_1/IQ-15_1/lib64/libiqserv15_r.so [0x400011d6b88] There is a seperate CR 633385 raised to resolve this stack print error on IBM platforms. The real stack can be obtained from running s gbd on the core, failure is at _ZN15df_MemGovRegion14DoCanAllocPageEv

CR:629819

CR Number:   629819 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2010 Fixed Description IQ catches signal11 and stops in df_Heap::GenerateDF.

CR:629840

CR Number:   629840 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2011 Presently Not Targeted For Any Future Release Of This Product Description Customer uses Replication Server DSI to connect and replicated data into IQ. Under certain rare conditions the DSI TDS connection into IQ hits the following error... I. 05/18 09:29:13. TDS 178: login: user 'DLNPSPSW04_IQ_maint', database '', application 'RepServer', host 'lns66d-8110a', host_pid '21988', charset 'iso_1' I. 05/18 09:29:13. Login procedure 'DBA.sp_iq_process_login' caused SQLSTATE '22003' I. 05/18 09:29:13. Value 2117418877184 out of range for destination The login is not rejected however and the connection to IQ is allowed (this must surely also be a bug?). Another side affect of the error is that the call to sp_login_environment() is not made meaning that the sp_tsql_environment procedure is not called so database options specific to TDS connections are not set. The source of the "Value 2117418877184 out of range for destination" error is an incorrect declaration of the column that represents LockName in the stored procedure sp_iq_process_login... 'create procedure DBA.sp_iq_process_login()\x0Abegin declare @admin_on char(1); declare @has_perm char(1); declare @login_locked char(1); declare @number_connects integer; declare @number_connects_admin integer; declare @number_db_connects integer; declare @password_days integer; declare @password_days_admin integer; declare @password_created timestamp; declare @times_connected integer; declare c1 integer; declare c2 varchar(255); declare c3 varchar(255); declare c4 integer; declare c5 varchar(255); declare c6 varchar(255); declare c7 integer; declare c8 varchar(255); declare c9 varchar(255); declare c10 varchar(255); declare c11 integer; declare c12 integer; declare c13 integer; declare c14 unsigned integer; declare c15 integer; declare @counter integer; declare end_of_cursor exception for sqlstate value ''02000''; declare saconn dynamic scroll cursor for call sa_conn_info(); ...... the declare for c14 (which is the LockName) should be unsigned bigint and NOT unsigned integer. Here is the corresponding declares in sa_conn_info where the connection infromation is obtained from... 'create procedure dbo.sa_conn_info(in connidparm integer default null) result(Number integer,Name varchar(255),Userid varchar(255),DBNumber integer,LastReqTime varchar(255),ProcessTime varchar(255),Port integer,ReqType varchar(255),CommLink varchar(255),NodeAddr varchar(255),LastIdle integer,CurrTaskSw integer,BlockedOn integer,LockName unsigned bigint,UncmtOps integer) begin declare connid integer; declare local temporary table t_conn_info( Number integer null, Name varchar(255) null, Userid varchar(255) null, DBNumber integer null, LastReqTime varchar(255) null, ProcessTime varchar(255) null, Port integer null, ReqType varchar(255) null, CommLink varchar(255) null, NodeAddr varchar(255) null, LastIdle integer null, CurrTaskSw integer null, BlockedOn integer null, LockName unsigned bigint null, UncmtOps integer null, ) in SYSTEM not transactional;if(connidparm is not null) then .... Not an issue for IQ 15 and higher as this use dbo.sp_login_environment instead of DBA.sp_iq_process_login Workaround Description  Alter procedure sp_iq_process_login and change declare c14 unsigned integer; to declare c14 unsigned bigint; suggest to minimize problems caused by users loging in while changing the proc restart the server with -gm 1 and tcpip connections disabled before dropping and recreating the login proc.

CR:629950

CR Number:   629950 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   AIX Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2010 Fixed 29 Jun 2010 Fixed Description IQ cannot be started on an AIX machine with 252 or more CPU threads. IQ will output and abort the "Memory allocation size too large" message.

CR:629952

CR Number:   629952 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   AIX Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The request of the feature which restores the backup file of readonly dbspace to Updating dbspace.

CR:630020

CR Number:   630020 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2010 One-off Provided Description Referenced view or derived table that contained a select list item which was not a table column caused a crash in IQ at df_GenrateDF.cxx:192. This has been rectified

CR:630516

CR Number:   630516 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for sp_iqdatatype to return for a user-defined datatype/domain, the underlying IQ system data type.

CR:630523

CR Number:   630523 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 13 Aug 2010 Fixed Description Could not insert, update, delete, or transfer data to Sybase IQ, when using MS-SQL SSIS. Could not insert, update, or delete, when using MS-SQL 2008 Link Server to Sybase IQ. The error "[ADO NET Destination [16]] Error: Length cannot be less than zero." was returned. ADO.NET drivers were not properly registered with the system registry for Microsoft Visual Studio 2008.

CR:631239

CR Number:   631239 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NFR: provide a way for IQ to return XOpen/SQL99 form

CR:631262

CR Number:   631262 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 24 Jun 2010 Fixed 15.2 e01 14 Jun 2010 Fixed 15.3 16 Jun 2010 Fixed 15.2 e01 24 Jun 2010 Fixed 03 Dec 2010 Consult Complete Description Updatable Cursor could not handle more rows than specified by the cursor_window_rows option and caused the server to become unresponsive.

CR:631447

CR Number:   631447 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2010 Presently Not Targeted For Any Future Release Of This Product 15.2 04 Jun 2010 Added to user documentation Description The trigger creation wizard of Sybase Central cannot list a user table. Workaround Description  Please use DBISQL.

CR:631478

CR Number:   631478 Product Name:   IQ Product Component:   Documentation Status:   Open OS:   Linux Red Hat Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description clarify open cursors to the db are not closed when an auto-commit occurs

CR:631595

CR Number:   631595 Product Name:   IQ Product Component:   Sybase Central Status:   Open OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A new user's comment set to be a user creation wizard is not shown on the user property dialog of Sybase Central.

CR:631775

CR Number:   631775 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2010 Fixed 03 Aug 2010 Fixed Description Creating WD indices in parallel gives them the default delimiters instead of the one specified.

CR:631863

CR Number:   631863 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   HP-UX Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Support for UTC timestamp format when using load table.

CR:632115

CR Number:   632115 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2010 Consult Complete Description IQ should locate all object data to a partition by range specification. IQ cannot split metadata and index(non FP index) data.

CR:632178

CR Number:   632178 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2008 Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 09 Jun 2011 Fixed Description When attempting to replicate data from MS-SQL to Sybase IQ, no data was sent to Sybase IQ and the connection was dropped abruptly. The schema definitions that provide input to the OLEDB driver have been updated to return correct database metadata for Sybase IQ.

CR:632261

CR Number:   632261 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 13 Jul 2010 Fixed 15.3 26 Aug 2010 Fixed Description The ISDATE function returned an incorrect result.

CR:632266

CR Number:   632266 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 17 Sep 2010 Fixed 10 Dec 2010 Fixed 15.1 e03.x Description Only in case of parallel left outer hash join, when under resource constraints, parallel probing was not possible and it tries to do a serial probing and while doing so the server fails. This has been fixed.

CR:632475

CR Number:   632475 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2008 Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 13 Aug 2010 Fixed Description OLEDB not working for linked server for some SQL syntaxes. This has now been fixed.

CR:632548

CR Number:   632548 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Improve performance for select * from wide tables (900+ columns)

CR:632876

CR Number:   632876 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2013 Presently Not Targeted For Any Future Release Of This Product Description iqunload -n generate incorrect syntax for IQ table with foreign key. An error "Not NULL foreign key not supported" was raised when executing a reload schema in reload.sql.This issue does not apply to iqunload -au. Workaround Description  The workaround for this issue is to do a search and replace in the generated reload.sql (iqunload -n) file as follows: ADD NOT NULL FOREIGN KEY with ADD FOREIGN KEY

CR:633040

CR Number:   633040 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 25 Jun 2010 Fixed 03 Aug 2010 Presently Not Targeted For Any Future Release Of This Product 18 Aug 2010 Presently Not Targeted For Any Future Release Of This Product Description Calling a stored procedure that operates on a table column could cause a server failure, if the specified column did not exist. A server failure could also occur, when calling stored procedures that operate on literal names, when quotes were omitted. For example, sp_helptext dbo.sp_iqstatus caused a server failure, because without quotes, dbo.sp_iqstatus was interpreted as a table/column name pair. Workaround Description  use single/double quotes around owner.table.idxname sp_iqindexsize 'mytext.tidx' ; sp_iqindexsize "mytext.tidx" ;

CR:633062

CR Number:   633062 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description For example, when DB Collation of IQ is UTF8 and Client Chaeset is EUC_JIS. The client for which Japanese included in the result of SQL is using which character set is also converted correct.

CR:633066

CR Number:   633066 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ does not support a trigger. However, a trigger can be created using DBISQL. However, the created trigger does not work.

CR:633143

CR Number:   633143 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 29 Jun 2010 Fixed 15.2 e01 28 Jun 2010 Added to user documentation 15 Nov 2010 Added to user documentation Description Sybase IQ and the installer require .NET v2 and .NET v3.5 for support of the ADO.NET drivers.

CR:633354

CR Number:   633354 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 02 Jul 2010 Fixed 15.3 01 Jul 2010 Fixed 16.0 01 Jul 2010 Fixed 15.4 01 Jul 2010 Fixed Description xp_cmdshell did not execute the command on UNIX platforms. Workaround Description  revert back to esd 1 or 2.1

CR:633385

CR Number:   633385 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2011 Fixed 08 Mar 2011 DEFER 15.3 08 Mar 2011 Fixed 15.3 10 Mar 2011 Fixed Description On linux the stack is not resolving all symbols so you see something like this.... : ===== Thread Number 1305012544 (IQ connID: 0000514253) ===== /sybase/IQ-15_3/bin64/../lib64/libiq15.so(_Z9pcstkwalkP9stk_traceiP6db_logP6hos_fd+0x31) [0x2aaabf3a4ad1] &/sybase/IQ-15_3/bin64/../lib64/libiq15.so [0x2aaabf3a3a42] &/sybase/IQ-15_3/bin64/../lib64/libiq15.so(_Z14DumpAllThreadsPKcji+0xff) [0x2aaabf3a37bf] &/sybase/IQ-15_3/bin64/../lib64/libiq15.so(_Z9hos_ABORTPKcjS0_PcS1_+0x19a) [0x2aaabf15729a] &/sybase/IQ-15_3/bin64/../lib64/libiq15.so(SigHndlr+0x4e) [0x2aaabfc6366e] &/lib64/libpthread.so.0 [0x367520eb10] &/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f7f21e7] &/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f5f9e00] &/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f5fad8f] &/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8eb42f] &/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8c314f] &/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8c3313] &/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8c490d] &/sybase/IQ-15_3/lib64/libiqserv15_r.so [0x2ad89f8c4e3c] .................. The environment has to have a pstack command defined as a symbolic link to the gstack command for Linux. If this is set up then a second print of the stack is done with all the symbols resolved. Please note the top part of the stack will still show the first thread for the ABORT with the unresolved symbolic names. However if you search on ABORT further down in the stack trace you should see the thread printed again (with the thread number in HEX) this time with the symbolic names resolved. Workaround Description  The environment has to have a pstack command defined as a symbolic link to the gstack command for Linux. If this is set up then a second print of the stack is done with all the symbols resolved. Please note the top part of the stack will still show the first thread for the ABORT with the unresolved symbolic names. However if you search on ABORT further down in the stack trace you should see the thread printed again (with the thread number in HEX) this time with the symbolic names resolved.

CR:633466

CR Number:   633466 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 15 Mar 2013 Fixed Description A simple join between an IQ table and a remote table returned an internal error if the local IQ table did not return any rows.

CR:633606

CR Number:   633606 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02.x 10 Jan 2011 Fixed 18 Feb 2011 Presently Not Targeted For Any Future Release Of This Product 15.2 e03 Fixed 15.4 e02 14 Nov 2012 Fixed 13 Dec 2012 Fixed 15.4 e03 10 Dec 2012 Fixed Description Sybase IQ server failed from s_blockmap.cxx with message "TEMPORARY blockmap still owns dirty pages -- should have been destroyed".

CR:633825

CR Number:   633825 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.7 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jul 2010 Consult Complete 14 Jul 2010 Not reproducible with latest version of the product available as of Resolution Date 12.7 e11 05 Oct 2010 Fixed Description When sp_addtype was executed on local store, it created 'Create domain ...' entry into local TLV store with Owner of the domain 'dbo'. If sync followed, sync failed to replay the domain command due to 'dbo' owner. Workaround Description  Nothing Yet.

CR:633919

CR Number:   633919 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Windows 2003 Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer has a requirement to be able to create windows services for starting IQ servers via a command line utility similar to windows sc.exe so that this operation can be done via a silent install script with no user interaction or intervention needed. Can SybaseIQservice15.exe be enhanced to be able to run it as a command line tool?

CR:633949

CR Number:   633949 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Solaris Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 May 2011 Fixed Description dbisql fails to decrypt command file encrypted with dbfhide utility on solaris

CR:634176

CR Number:   634176 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2013 Consult Complete Description We need an official document that states whether there is backward compatibility of the IQ 15.2 connectivity drivers with the previous versions of IQ server.

CR:634314

CR Number:   634314 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2010 Fixed Description On running "select * from sp_iqmpxincheartbeatinfo()", error Cannot convert '00:00:0000:00:00:00' to a timestamp SQLCODE=-157, ODBC 3 State="07006" maybe thrown.

CR:634333

CR Number:   634333 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e10 16 Jul 2010 Added to user documentation 15.2 e02 09 Nov 2010 Fixed 15.3 09 Nov 2010 Added to user documentation Description In Performance and Tuning Guide > Using OLAP >Analytical Functions > Windowing > Window framing > ROWS, the description of calculation for averages contains five bullet points. The last two bullet points should be changed to: Row [4] = (120 + 500 + NULL)/2 and Row [5] = (500 + NULL + NULL)/1

CR:634385

CR Number:   634385 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 19 Jul 2010 Fixed 15.3 19 Jul 2010 Fixed Description Queries containing a CASE statement with a NOT NULL clause returned incorrect results. Workaround Description  W/R is to set dml_options5=1073741824 in order to disable case simplification.

CR:634674

CR Number:   634674 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.7 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e11 27 Aug 2010 Fixed Description Under exceptionally rare conditions, the server failed when expanding a very large view definition that contained a UNION, INTERSECT, or EXPEPT query node and there was insufficient cache space available.

CR:634959

CR Number:   634959 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 21 Jul 2010 Fixed Description A query that included both an IQ table and a proxy table returned the error "Msg 2706, Level 11, State 0: SQL Anywhere Error -141: Table '<proxy_table_name>' not found," when the proxy table was qualified by owner and the user executing the query was not the owner of the table.

CR:635046

CR Number:   635046 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   HP-UX Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 30 Jul 2010 Fixed Description When performing IQUNLOAD -au on a database with quoted_identifier='off', IQUNLOAD failed on reload with the syntax error "SQL error: Syntax error near 'old_IQ_MPX_INFO' on line 1"

CR:635108

CR Number:   635108 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.7 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e11 17 Dec 2010 Fixed Description If an application executed a remote statement that required the server to execute the statement in either partial or no passthru mode, there was a chance the server would fail, if the statement was overly complex or if the server cache was exhausted. In addition, if an application executed a remote query that required partial or no passthru processing and the query made heavy use of aliases, then the server could incorrectly return error "-890 statement size or complexity exceeds server limits." Now the -890 error is returned only if the statement size or complexity really do exceed server limits.

CR:635244

CR Number:   635244 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   AIX Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When a bit data type is added using a SUM function, IQ may return the wrong result. An index exists in the corresponding table, and it may be reproduced when the column is set to be order by. Workaround Description  The cast of the bit data type is carried out to a tinyint data type.

CR:635782

CR Number:   635782 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e11 05 Oct 2010 Fixed Description During local TLV replay, if comment on procedure statement encountered a procedure not found error (SQLSTATE:52W09), then local TLV performed an emergency shutdown.

CR:635832

CR Number:   635832 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Nov 2010 Fixed Description The option ANSI_SUBSTRING was introduced in the IQ 15.0 time frame but was never honored in IQ's implementation of substr. This option controls whether or not the substr function conforms to the ANSI standards. In particular, it disallows the third argument from being a negative number. The default value for this option is being changed for IQ databases to be 'OFF'. This will maintain the current default behavior of allowing a negative number as the third argument.

CR:635840

CR Number:   635840 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2003 Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 16 Aug 2010 Fixed Description ADO.NET Data Provider: The Available objects list was empty when creating SSIS data source view.

CR:636042

CR Number:   636042 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2010 Consult Complete 05 Jan 2011 Added to user documentation Description The value of the VersionID column of sp_iqtransaction is always set to 0. However, in non-MPX, the same value as TxnID is set to VersionID.

CR:636175

CR Number:   636175 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 30 Jul 2010 Fixed 15.2 e03 20 Sep 2010 Fixed 20 Sep 2010 Fixed Description LOAD TABLE QUOTES ON could not load quoted strings with columns delimited by TAB, and returned the error "Could not execute statement. Expected 'column' delimited column type on input, but encountered a row delimiter instead. Probable cause is a mismatch between the specified column delimiter and the column delimiter used in the input file." Target Version  15.2 e01

CR:636192

CR Number:   636192 Product Name:   IQ Product Component:   other Status:   Closed OS:   Unknown Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 01 Sep 2010 Added to user documentation 15.2 e02 03 Sep 2010 Added to user documentation 15.3 31 Mar 2011 Added to user documentation Description The mapping of the columns of a proxy table to a Microsoft SQL Server table changed as of Sybase IQ 15.2 ESD #1. A LONG BINARY column now maps to a Microsoft SQL Server VARBINARY(max) column. In Sybase IQ 15.2 GA, a VARBINARY column was mapped to a Microsoft SQL Server VARBINARY(max) column.

CR:636476

CR Number:   636476 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.7 e08.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e11 31 Aug 2010 Fixed 15.2 e02 31 Aug 2010 Fixed 15.3 31 Aug 2010 Fixed Description The IQ server appeared to be unresponsive, when an ESQL program that opened many no-scroll cursors disconnected.

CR:636632

CR Number:   636632 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 e00.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 19 Aug 2010 Fixed 15.2 e01 19 Aug 2010 Fixed 15.3 21 Feb 2011 Fixed Description The IQ server failed when the query was using a sort merge pushdown join on a heavily loaded server. Workaround Description  If removed "A.call_code = B.call_code" in where condition, the query run well.

CR:636953

CR Number:   636953 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 05 Aug 2010 Fixed 15.2 e02 05 Aug 2010 Fixed 15.3 05 Aug 2010 Fixed Description The Sybase IQ server failed while creating an index, when the database option MAX_IQ_THREADS_PER_TEAM = 1.

CR:637544

CR Number:   637544 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jan 2011 Fixed Description Customer using '-onerror continue' option for dbisql. However Batch SQL was finished when certain error occurred.

CR:637612

CR Number:   637612 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 18 Aug 2010 Fixed Description Loading into auto-increment/default columns can fail for a specific scenario. This has been fixed.

CR:637839

CR Number:   637839 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2010 Fixed Description When CONTAINS() was used in a CASE expression for empty string data, a WD index on a VARCHAR column returned an incorrect result.

CR:637840

CR Number:   637840 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 16 Aug 2010 Fixed 15.2 e01.x 17 Sep 2010 Fixed Description ADO.NET driver: SAConnection.State was still open after the connection was dropped.

CR:637935

CR Number:   637935 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   AIX Original Version:   15.2 e00.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 18 Oct 2010 Fixed 15.3 28 Oct 2010 Fixed Description A query returned "Non-Fatal IQ Internal Error Detected at dfo.cxx:9685 on thread 2828 (TID 25) Internal error at node: #08 Can not evaluate expression: MIN(MIN(TEST_MIN.col1)) Error detected at DFO #08 Group By Single" Workaround Description  set temporary option aggregation_preference=(1/2/3/-2)

CR:637953

CR Number:   637953 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e03 31 Mar 2011 Fixed 28 Dec 2010 Fixed 15.3 10 Feb 2011 Fixed Description A SELECT query involving an outer join and scalar correlated subquery sometimes failed with a dfo.cxx:9562 exception. Workaround Description  set temporary option 'subquery_flattening_preference'='-2'

CR:638356

CR Number:   638356 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2010 Fixed Description There was an issue in the memory handling in the driver code. This has been fixed.

CR:638546

CR Number:   638546 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.7 e10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e11 28 Oct 2010 Fixed 15.2 e03 28 Oct 2010 Fixed Description Secondary nodes shut down after executing a few alter table statements separated by colon ":" on the coordinator/writer node.

CR:638734

CR Number:   638734 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Nov 2010 Consult Complete 15.3 11 May 2011 Fixed Description In an MPX environment,backup first RW dbspaces then RO dbspaces. Inadvertantly, if you restore read only dbspaces (resp. RW dbspaces) from the RW (resp. RO) archive, the restored catalog could be invalid.

CR:639150

CR Number:   639150 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request for Replication Agent IQ.

CR:639229

CR Number:   639229 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   HP-UX Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description need ACCENT_RESPECT collation for 1250LATIN2 charset

CR:639243

CR Number:   639243 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e00.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 06 Oct 2010 Fixed Description Multiplex: An update on a table returned a main bufman error, when executed in the same session after converting a Reader node to a Writer node without rebooting the server.

CR:639334

CR Number:   639334 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows 2003 Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2010 Work as design Description The Redistributable package of VC++2005 and VC++2008 is required for IQ. The installer of IQ installs these packages in a system. However, in the system in which VC++ of one of versions was installed, IQ installer cannot install insufficient VC++Redistrabutable. Workaround Description  Please install manually VC++Redistributable which is not installed.

CR:639368

CR Number:   639368 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2013 Not reproducible with latest version of the product available as of Resolution Date Description 15.2 IQUNLOAD -au would faile if the database being upgraded has a java class installed with the command: INSTALL JAVA FROM @variable Workaround Description  Remove this Java class before migrating

CR:639512

CR Number:   639512 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description add a parameter to sp_iqemptyfile to allow specifying which r/w dbfile to relocate data to

CR:639513

CR Number:   639513 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description allow specification of any r/w dbfile in ANY dbspace rather than just current one

CR:639730

CR Number:   639730 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 future 07 Mar 2011 Fixed Description The unnecessary link is included in description of "-cl" starting option in IQ Utility Guide.It does not need to be explained for description of '-cl' after 'For more information'.

CR:639767

CR Number:   639767 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 15 Mar 2011 Fixed Description It is included in description of 'ALTER TABLE' about EBM. However, the document written about EBM does not exist. EBM is the short title of Existence Bit Map. EBM : a basic datastructure used for storing metadata information that table/Indexes

CR:639824

CR Number:   639824 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp08 04 Dec 2013 Fixed Description A complex query with subqueries that contain no FROM clause may result in an IQ Internal Error along with a stacktrace in the iqmsg file.

CR:640129

CR Number:   640129 Product Name:   Sybase IQ ETL Product Component:   pEngine Status:   Closed OS:   all Original Version:   Denali Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2012 Fixed 10 Oct 2010 Added to user documentation 23 May 2011 Fixed Description When a product requires multiple licenses and the license server has insufficient licenses available to satisfy it's needs, the failure message reported by the product does not show the correct amount that were available (that the product could obtain). E.g. "Replication Server requires 4 REP_SERVER licenses but only 4 could be obtained." Workaround Description  Run the following command to determine how many licenses are available: sysam status -a

CR:640192

CR Number:   640192 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Dec 2010 Fixed 15.2 e03 11 Jan 2011 Fixed 11 Jan 2011 Fixed 14 Jan 2011 Fixed Description There was a problem in an HG index load algorithm, when the underlying index contained some deleted keys. "Non-Fatal IQ Internal Error Detected" was returned.

CR:640331

CR Number:   640331 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description load table (filename-vaiable) fails with an Exception

CR:640333

CR Number:   640333 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhance TDS support for 'load table using client file' using iqisql/jConnect

CR:640419

CR Number:   640419 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Oct 2010 Duplicate Description A query involving OLAP and views using extended GROUP BY syntax was not rejected with a syntax error, when the query ran as a SQL Anywhere managed and non-passthrough query (using cis_option=8).

CR:640433

CR Number:   640433 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2010 Fixed 23 Jan 2011 Fixed Description When the 'substr' function was used with 'SELECT....CASE WHEN' and the value -ve was passed as length to the function, Sybase IQ returned an invalid parameter error (SQLCODE -1090), only if the 'substr' function executed at runtime.

CR:640731

CR Number:   640731 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2008 Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2012 Fixed Description In IQ15, the updating transaction which used cursor requires many time rather than IQ12.7.

CR:640890

CR Number:   640890 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2010 Fixed Description When creating a database using an iqinit utility, IQ temp reserve size cannot be set.

CR:640913

CR Number:   640913 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description add ability to tds layer so that user can log in via ctlib isql if user was created with 'force password change on'

CR:641090

CR Number:   641090 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03.x 22 Dec 2010 Fixed 15.3 22 Dec 2010 Fixed 15.2 e02 22 Dec 2010 Fixed Description Cleanup for sort object during forceful termination of query has been corrected.

CR:641229

CR Number:   641229 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 08 Oct 2010 Fixed 15.2 e01.x 03 Nov 2010 Fixed Description In very rare cases, the Sybase IQ server could stop processing, if an external environment call was made at the same time the server began to perform some maintenance on the database.

CR:641943

CR Number:   641943 Product Name:   IQ Product Component:   other Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 21 Sep 2010 Not a Bug Description IQ 15.1 checks out one IQ_CORE license more than there are actual cores on the machine if floating licenses are in use.

CR:642111

CR Number:   642111 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description 15.2 ALTER TABLE hangs until full BACKUP finishes

CR:642368

CR Number:   642368 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Oct 2010 Fixed Description v3 Scalar UDF example my_toupper produced wrong results due to a character pointer offset by 1. This has been fixed.

CR:642371

CR Number:   642371 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Dec 2010 Fixed Description The CREATE PROCEDURE for the v3 Scalar UDF example my_toupper example was not present while creating a new IQ database. This has been fixed.

CR:642507

CR Number:   642507 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description distinct query with inner joins takes much longer than MySQL

CR:642511

CR Number:   642511 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 05 Apr 2011 Added to user documentation Description Customer requested fruther documentation on the transaction states reproted in sp_iqtransaction. In particular to help understand when a transaction is placed in an APPLIED state and what it means to versions and locks the transaction was holding.

CR:643258

CR Number:   643258 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   AIX Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ(SQL Anywhere) JDBC driver cannot handle the DBCS SJIS character including 0x7B correct as an object name.

CR:643282

CR Number:   643282 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 11 Oct 2010 Fixed 15.3 11 Oct 2010 Fixed Description The Sybase IQ server failed on the parallel execution of vertical predicates (a SELECT with subqueries). Workaround Description  Disable "parallelism into vpp_dfp execution of FP complex predicates path" with set temporary option dml_options6 = 512;

CR:643926

CR Number:   643926 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Feb 2011 Fixed Description IQ 15.1 cannot reach ASE 15 through remote server class ASEODBC 64 bits

CR:644031

CR Number:   644031 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 e01.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01.x 05 Nov 2010 Fixed 15.3 05 Nov 2010 Fixed 15.2 e02.x 31 Jan 2011 Fixed 15.2 e03 01 Apr 2011 Fixed Description The Sybase IQ server sometimes failed when executing a query involving the sort merge push-down algorithm. Workaround Description  If removed "A.call_code = B.call_code" in where condition, the query run well.

CR:644073

CR Number:   644073 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 e00.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2011 Consult Complete Description We need explanations about temp cache management

CR:644410

CR Number:   644410 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 2003 Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 09 Dec 2010 Added to user documentation Description Please be sure to install VC++ 2005,2008 Redistributed Package before executing the installer of Sybase IQ 15.x for Windows. Some programs could not be started when only VC++ 2005 currently written to the installation guide is installed. Workaround Description  Please install insufficient VC++ 2005,2008 Redistributed Package from CD or the downloaded installation package. And Sybase IQ Agent is manually registered to Windows Service.

CR:644979

CR Number:   644979 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   HP-UX Original Version:   12.7 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Version: 12.7.0/100114/P/ESD 9/ITANIUM/HP-UXi 11.23/64bit Would like help determining if a poorly performing query is the result of bad optimizer choices , or if working as expected and explaination as to why and whats happening... Customer has a query that is being executed in 12 seconds, the format for the query is SELECT ... FROM ... WHERE ... AND B.TIMESTAMP_S4B > '2010-08-04 11:00:00.000000' If customer adds a simple condition in the where for a column that already had a condition then the query plan changes and the query takes 55 minutes. This is the format for the new query SELECT ... FROM ... WHERE ... AND B.TIMESTAMP_S4B > '2010-08-04 11:00:00.000000' and B.TIMESTAMP_S4B < '2010-07-06 11:00:00.000000' looking at the query plans good and bad that can be found at \\ecss\ts-cases\11629000s\11629275, we can see the performance increase is stemming from the rows returned from leaf node #3 into the join. In the bad query a table scan is done and the entire 684 million rows from table HOP_OPPERACIONES_6_MESES_EVR is passed to the JOIN and a sort merge join is done on it. In the good query a condition of ROW(A.ID_4B, A.CODIGO_OPERACION) = ROW(BV(2, CAST(SUBSTR ((D.REFERENCIA_DOCUMENTAL,2,23) AS NUMERIC(126,38))), BV(1, CAST(D.NUMERO_EXPEDIENTE AS NUMERIC(126,38)))) is pushed out of the join and into Leaf node #03 resulting in only 553 rows passed into the join and a Nested Loop push down is done. In both queries the B.TIMESTAMP_S4B condition is resolved and an invariant in Leaf #5. For the bad query the extra condition is merged into a single BETWEEN condition. If the customer uses join_preference -1 or 3 to avoid the sort merge then the query runs quickly again. So why is the optimizer choosing the slower sort merge ?

CR:645066

CR Number:   645066 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Windows 2003 Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A user name is not set to analaysis result when request log is analyzed using sa_get_request_profile() or sa_get_request_times().

CR:645127

CR Number:   645127 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.1 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2010 Fixed 31 Oct 2010 Fixed 15.1 e03 11 Feb 2011 Fixed Description The problem may occur if a crash occurs after insert/load transaction commits and before checkpoint. The fix takes care of reflecting most up-to-date identity value into catalog before the objects are closed at the end of insert/load operation. Target Version  15.1 e03.x