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

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

CR:666710

CR Number:   666710 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02.x 05 May 2011 Fixed 15.2 e03 20 May 2011 Fixed 19 May 2011 Presently Not Targeted For Any Future Release Of This Product 20 May 2011 Fixed Description The IQ server returned an Internal error, when LOAD TABLE handled large length user defined NULLs.

CR:667051

CR Number:   667051 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2008 Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description LOAD TABLE cannot handle row delimiter of a fixed length file. IQ will output error "said Missing row delimiter detected during a row delimited insert". Workaround Description  Please use FILLER expression instead of row delimiter expression. For example, when row delimiter is CRLF, please add FILLER (2).

CR:667147

CR Number:   667147 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.1 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2011 Duplicate 21 Dec 2011 Duplicate Description The issue was caused by a bug in the server memory handling leading to stale memory reference. This has been fixed.

CR:667221

CR Number:   667221 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2008 Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 07 Jun 2012 Fixed Description When "LOAD TABLE" is executed, roll back on the first constraint violation. The violation should bejavascript:save() written to the message and row logs, but it was not.

CR:667231

CR Number:   667231 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 28 Apr 2011 Added to user documentation Description The sample DDL of iq_dummy is not written to the reference manual of Sybase IQ15.

CR:667235

CR Number:   667235 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Windows 2008 Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description In some cases, client was reporting generic error if it failed to establish the connection to the database server. Additional diagnostics have been added so the error messages are more informative.

CR:667480

CR Number:   667480 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e03 02 Aug 2011 Fixed 20 Sep 2011 Fixed Description When rollover of '3' byte 'FP1' column to 'FlatFP' happens for a partitioned table, the value for partition-id referenced is incorrect, because of which we get 'internal state violation error'. Fix has been done to fetch the correct partition-id value, when rollover of '3' byte 'FP1' to 'FlatFP' happens. Workaround Description  Dropped the table and recreated it with min storage off and all is well

CR:667725

CR Number:   667725 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.x 03 Aug 2011 Fixed 15.4 15 Aug 2011 Fixed Description The issue is observed when IQ inserts a CAST implicitly in join predicate where there is mismatch in datatypes for equated condition.

CR:667898

CR Number:   667898 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 7 Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2011 Fixed Description Previously, if an application connected via jConnect and then subsequently attempted to use the {} JDBC escape sequence when making a stored procedure call, then there was a chance the server would return a strange "variable @p0 not found" error at the time the stored procedure statement or result set was closed. This problem has now been fixed.

CR:668009

CR Number:   668009 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows 2003 Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e03 30 May 2011 Fixed Description Sybase Central: Execution of "Refresh All" of table information caused an internal error.

CR:668312

CR Number:   668312 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2012 Fixed 16 Dec 2012 Fixed Description A Data type conversion error is observed for datetime format 113 ('dd mmm yyyy hh:nn:ss:sss') when used in CONVERT fucntion.

CR:668751

CR Number:   668751 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The issue occurs whenever a null-generating side of an outer join is a flattenable view (or flattenable derived table) and the select list of the view contains a constant expression (or an expression that can be simplified into a constant expression). In such cases, the virtual column should (according to ANSI SQL) have a NULL value for the outer rows from the join, but the virtual column has already been eliminated by the view flattening transform before the IQ optimizer ever sees the annotated parse tree. Workaround Description  WA would be to add a DISTINCT to the derived table. or move the constant to the upper select list and use an ISNULL check to add the constant info

CR:669566

CR Number:   669566 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 13 Nov 2012 Fixed 13 Nov 2012 Fixed Description This is a recurrent issue with copied postannotated parse trees which IQ and OMNI are generated: these parse trees may not contain valid SQL statements. When trying to annotate again these copied postannotated parse trees syntax errors maybe generated. The parse tree to be copied in this issue is of the form : select T1.FK as PK, T2.FK as PK... after the postannotation which performed join elimination. This is not a valid SQL statement as it contains two aliases with the same name in the SELECT list. Workaround Description  add a unique quoted column identifier to the select lists alias name

CR:669569

CR Number:   669569 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 01 May 2013 Fixed Description Fixed issue where the menu from mutliplex servers were out of sync. Specifically, ensure the "Execute SQL" option is available at the correct locations.

CR:670092

CR Number:   670092 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description New Feature Request to have options to suppress the "speculative execution" messages.

CR:671012

CR Number:   671012 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2011 Presently Not Targeted For Any Future Release Of This Product 15.4 10 Aug 2011 Fixed 15.2 e03.x Fixed Description IQ gives an non-fatal internal exception when the projection list of a query has a number of inter-dependent case expressions (one case expression as an argument to the other and so on). Workaround Description  *** Wed Jun 8 12:12:33 UTC+0530 2011 *** mchavan *** A workaround to this issue is to create an FP(1) , FP(2) or FP(3) index on col_1 ------------------------------------------------------------------------------- DML_options3=4194304 disables check for output and production vector validation and can potentially cause incorrect results, so not really a valid workaround

CR:671044

CR Number:   671044 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2011 One-off Provided 15.4 01 Jul 2011 Fixed 26 Sep 2011 Fixed Description Customer Description: select with group by and union all crashes IQ at _ZN9vp_Cursor10PreExecute on 152 esd 2 this has been corrected. Workaround Description  run with temporary option EARLY_PREDICATE_EXECUTION ='ON'

CR:671160

CR Number:   671160 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 31 Oct 2011 Fixed 15.4 24 May 2011 DEFER Description The administrator guide of IQ15 is written to support jConect JDBC Driver for DBISQL/Sybase Central. But those tools does not support jConnect JDBC driver.

CR:671406

CR Number:   671406 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e05.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e12 12 Aug 2011 Fixed Description Primary key table is not getting fully qualified before writing the ALTER TABLE SQL to the TLV log. The ALTER TABLE SQL introduces a foreign key to the table. Because of the unqualified DDL in the TLV log, the foreign key constraints were not propagated to the query nodes, sometimes resulting in inconsistent catalog entries, resulting in the internal bufman error.

CR:671444

CR Number:   671444 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 e03 25 May 2011 Added to user documentation 15.3 e01 07 Oct 2011 Presently Not Targeted For Any Future Release Of This Product 15.4 07 Oct 2011 Added to user documentation Description Sybase recommends using a fiber channel, rather than NAS (Network Attached Storage) devices, for creating 15.x IQ dbspaces. Using a NAS device for a Sybase IQ dbspace may impact performance.

CR:671463

CR Number:   671463 Product Name:   IQ Product Component:   other Status:   Closed OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2011 Fixed 28 Jun 2011 Fixed Description A nested loop join executed using DQP returns wrong results when the columns being joined are not the same datatype (for example, char versus varchar) and an implicit cast is needed. Workaround Description  The simplest work-around for this problem is to add an explicit cast to the query so that an implicit cast is no longer needed.

CR:671544

CR Number:   671544 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 18 Jan 2012 Fixed Description The problem was caused by some in-memory cleanup that must be performed by the server periodically and was performed on every checkpoint; however, that cleanup doesn't need to be performed when checkpoints are executed in quick succession. Now, server will perform the cleanup during checkpoint at most once every twenty minutes. Workaround Description  when performance degrades , reboot IQ server to restore performance to acceptable levels. However this is disruptive to the online production work.

CR:671664

CR Number:   671664 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 30 Jun 2011 Fixed 15.2 e02.x 12 Jul 2011 Fixed 15.2 e03.x 12 Jul 2011 Fixed 15.1 e03.x 12 Jul 2011 Fixed 08 Nov 2012 Not a Bug 15.3 e00.x 07 Aug 2011 Fixed Description In rare circumstances when using multiple writers in IQ MPX the coordinator can become unresponsive when the periodic storage maintenance process happens on a busy cache. If the periodic storage maintenance process uses a dirty page from the cache it can cause IQ server to hang

CR:671767

CR Number:   671767 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e00.x 03 Jun 2011 Fixed Description IQ server hangs in simplex while running under heavy multi-user query load.

CR:671898

CR Number:   671898 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 Clarification being sought for wording in documents... The IQ 15.2 System Administrator Guide, Volume 1, page 456 states the following "The collation of the database must match the collation used by the operating system" - is this a new restriction brought in an why as it still appears you are able to do this without issues.

CR:671933

CR Number:   671933 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 Feature Request to improve TOP performance when used in a select with ORDER BY using DESC keyword. Request to improve IQ's ability backward naviagte the composite HG index to resolve the DESCending requirement in a manner similar to ascending.

CR:672018

CR Number:   672018 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Oct 2011 Presently Not Targeted For Any Future Release Of This Product 15.4 11 Jul 2011 Fixed Description A query having an ISNULL expression in the select and groupby list and containing an outer join, gives a syntax error. Workaround Description  *** Wed Jun 1 14:58:55 UTC+0530 2011 *** mchavan *** A workaround to this issue is to disable the case expression simplification using the following option: set temporary option dml_options5 = 1073741824 ------------------------------------------------------ Currently modifing SQL is avaliable, but it's not acceptable to customer. SELECT ISNULL(a.base_ym , b.base_ym ) AS base_ym ,ISNULL(a.area_hdqr_cd, b.area_hdqr_cd ) AS area_hdqr_cd ,ISNULL(a.mngm_brcd, b.mngm_brcd ) AS mngm_brcd ... GROUP BY base_ym , ... => Modify SELECT (CASE when a.base_ym is null then b.base_ym Else a.base_ym end) AS base_ym ,(CASE when a.area_hdqr_cd is null Then b.area_hdqr_cd Else a.area_hdqr_cd end) AS area_hdqr_cd ... GROUP BY base_ym , ...

CR:672104

CR Number:   672104 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 01 Feb 2012 Fixed 16.0 03 Apr 2012 Fixed 15.4 e02 18 Apr 2012 Fixed Description A query could return an internal error at dfo.cxx 9060 in Sybase IQ 15.2 when an SMJ or SMPDJ node received input from its child in the wrong order. Workaround Description  Currently following is available. Set temporary option Dml_options3=83886;

CR:672624

CR Number:   672624 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The STR() function of Sybase IQ has behavior which is different in AS/ASE. When zero are set to be numeric-expression and two or more digits are set to be length, STR() is padding blank space back of value. However, ASE/ASE will padding blank space head of value.

CR:672893

CR Number:   672893 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 12 Jul 2011 Added to user documentation Description DBISQL of Sybase IQ can set return-code to be an EXIT statement. However, it is not written to the manual.

CR:673310

CR Number:   673310 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description -

CR:673475

CR Number:   673475 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02.x 14 Jul 2011 Fixed 15.4 11 Jul 2011 Fixed Description IQ gives a non-fatal internal failure when a parallel group by (hash) operator is used to evaluate a group by query which aggregates average.

CR:673581

CR Number:   673581 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2011 Duplicate Description LOAD TABLE command run many times slower in 15.2esd8 and later versions than in previous versions whenever literal strings defined for NULL must be checked.

CR:673932

CR Number:   673932 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 28 Oct 2011 Added to user documentation Description Notice is required when deleting the public option. As for change of a user option, the public option needs to exist.

CR:673953

CR Number:   673953 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When account is locked using a login policy, the user with DBA authority cannot lock. However, IQ does not output a message about the reason which cannot be locked.

CR:674317

CR Number:   674317 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 25 Jul 2011 Added to user documentation Description Quotation marks are required for the argument of the READ Statement.

CR:674439

CR Number:   674439 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e05.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e05.x 30 Jun 2011 Fixed 12.7 e12 30 Jun 2011 Fixed 15.3 e01 30 Jun 2011 Fixed 16.0 01 Jul 2011 Fixed 15.3 e00.x 30 Jun 2011 Fixed 15.4 30 Jun 2011 Fixed Description A server failure may occur at s_blockmap::RegisterPhysicalBlockId() file s_blockmap.cxx line 2440. This failure may occur when trying to write a block with block id greater than 4GB. This requires a database large enough to have dbspaces with physical block numbers greater than 4GB. Target Version  15.4 future

CR:674807

CR Number:   674807 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 31 May 2012 Fixed 01 Jun 2012 Not a Bug 15.4 e01.x 22 Jun 2012 Fixed Description LOAD TABLE may stop processing if not enough buffers are available.

CR:674881

CR Number:   674881 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 21 Nov 2011 Fixed Description A LOAD TABLE statement caused the server to fail in st_SAIQInterfacen.cxx with error "Unexpected resource deallocation error from IQ command which originated at s_bmCur.cxx:711."

CR:674944

CR Number:   674944 Product Name:   IQ Management Product Component:   Web UI - Security Status:   Closed OS:   RH Linux Original Version:   3.2.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2011 Fixed Description When authenticating IQ from SCC and using incorrect login information the wrong error is displayed.

CR:675160

CR Number:   675160 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 e00.x 29 Jun 2011 Fixed Description In 15.3 GA, certain parallel FP predicate operations are limited to 30 threads on a single IQ server, even if the server has more than 30 CPU cores. This limit is removed in 15.3 ESD0.1

CR:675425

CR Number:   675425 Product Name:   IQ Product Component:   Install Status:   Open OS:   Windows XP Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Disable "check for updates" in DBISQL help menu

CR:675601

CR Number:   675601 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2008 Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 05 Nov 2013 Fixed Description If a query involves two or more joins of which first join is a self join of same view on primary key, it can cause IQ server to fail or become unresponsive. Workaround Description  When you use self-join, please use the column of left table for other join key.

CR:675730

CR Number:   675730 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A message log archive is necessarily started from 0 at the time of IQ start. The existing archive file will be overwritten. However, the archive of a request log does not overwrite the existing file.

CR:676047

CR Number:   676047 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 08 Jul 2011 Fixed 01 Aug 2011 Fixed Description If the documentation for alter database upgrade is not strictly followed and the server is not started with -iqro then alter database upgrade will fail if a VLDB license is not available. This will make it necessary for customers to restore from backup

CR:676710

CR Number:   676710 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 19 Aug 2011 Fixed 16.0 19 Aug 2011 Fixed Description A truncate table command executed on a global temporary table declared with on commit preserve rows may not truncate the table if executed after some ddl commands. For example, create GTT on commit preserve rows; insert rows; create hg index; drop hg index; truncate table; Will not truncate the table.

CR:677003

CR Number:   677003 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Dec 2012 Fixed Description Connections that remained connected for long periods of time, for example beyond 24 hours, would report an incorrect LastReqTime. This value would drift away from the expected real time. This has been fixed.

CR:677213

CR Number:   677213 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 2008 Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 12 Jul 2011 Added to user documentation Description @@rowcount is not included in List of Sybase IQ Global Variables. But Sybase IQ supports @@rowcount global variable.

CR:677283

CR Number:   677283 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.4 25 Aug 2011 Fixed Description For the following scenario: create table p1 ( c1 int, c2 char(5), primary key( c1, c2 ) ); create table c1 ( c1 int, c2 char(5) ); alter table c1 add foreign key fk1( c2, c1 ) references p1 ( c2, c1 ); The foreign key creation should not be allowed. The documentation is very clear that the foreign key must, in this case, reference the primary key in table p1. p1(c2,c1) is not the primary key. We currently allow the creation of the FK and report an error when INSERT is attempted. Workaround Description  make sure FK columns defined in same order as referenced tables PK - not always an easy task if using schema modling tools like PD

CR:677746

CR Number:   677746 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2013 Work as design Description Don't refer to the changed user password for remote server connection of Sybase IQ. When it connects with a remote server before password change, a password is saved into a cache. A password is not reflected in remote server connection until it reboots IQ. Workaround Description  Please use sp_password.

CR:678327

CR Number:   678327 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e03.x 12 Oct 2011 Fixed 15.2 e01.x 06 Feb 2012 Duplicate Description A query returns an invalid correlation name error if the same table has been joined with itself directly or indirectly on its primary key column and the columns from that table have been specified using OWNER.TABLE.COLUMNN" syntax in the query.

CR:678702

CR Number:   678702 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2011 Not a Bug Description The behavior of the IQ insert values logic has changed in 15.4 for integer values. The old logic always set the length to 4. The new logic will automatically convert integer values that are greater than or equal to -32767 and less than or equal to 32767 to a short and make the length 2. This will effect the display of the data if the display is binary format. For example, insert table1 values ( 3 ); will now display in binary as 0x0003 rather than 0x00000003.

CR:679248

CR Number:   679248 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   HP-UX Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ 15.3 "dbisql -nogui" does not display multiple results

CR:680294

CR Number:   680294 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 22 Aug 2011 Added to user documentation Description DBISQL of IQ15 does not support a binary format to OUTPUT.

CR:680337

CR Number:   680337 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Dec 2013 EOL'd version. Not to be Fixed. 15.4 e01 21 Dec 2011 Fixed 16.0 22 Dec 2011 Fixed Description In a query with multiple joined subqueries containing GROUP BYs returns the wrong results, if the GROUP BY is on a constant(NULL). Workaround Description  This appears to be avoided by setting DML_Options2 = 64 but the customer can not live with this as a work around as it affects performance of other queries.

CR:680546

CR Number:   680546 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 19 Aug 2011 Fixed Description The following sql used to report error -118 Table has no primary key. create table t1 ( c1 int primary key ); create view v1 as select c1 from t1; create table t2 ( c1 int ); alter table t2 add foreign key fk( c1 ) references v1( c1 ); The following error is now reported: Error -729 The specified foreign key cannot be enforced.

CR:680741

CR Number:   680741 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02.x 15 Aug 2011 Fixed Description Under rare circumstances, Multiplex secondary writer nodes may become unresponsive. This may occur when the server's temporary cache is exhausted while performing main store read/write operations.

CR:680763

CR Number:   680763 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The "backup database" command should continue to exploit the remaining available devices, even if one device in the target device list becomes full.

CR:680825

CR Number:   680825 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 23 Aug 2011 Fixed 15.4 23 Aug 2011 Fixed Description Non-Fatal IQ Internal Error Detected at s_dpidx.cxx:3457 occurs when running sp_iqrowdensity in a multibyte database for an FP index on a longvarchar column.

CR:681032

CR Number:   681032 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2011 Duplicate Description In IQ 15.2, a query using ISNULL() within an IF...ENDIF block might return the incorrect results. Workaround Description  A work around found so far is to replace IF.. ENDIF with CASE ... END but its not practical for the customer because the amount of scripts and SQL affected is huge and will require a considerable amount of time and resources to carry out a re-write.

CR:681351

CR Number:   681351 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 23 Aug 2011 Fixed 15.2 e03 06 Sep 2011 Fixed Description LOAD TABLE command run many times slower in 15.2esd8 and later versions than in previous versions whenever literal strings defined for NULL must be checked.

CR:681549

CR Number:   681549 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) 02 Sep 2011 Fixed 15.3 e00.x 08 Sep 2011 Fixed 15.2 e03.x 09 Sep 2011 Fixed 15.2 e02.x 12 Sep 2011 Fixed Description In rare circumstances when using multiple writers in IQ MPX a bookkeeping error can occur that can lead to data corruption. The bookkeeping error can occur if a transaction on the coordinator uses space freed by the periodic storage maintenance process and commits before the periodic storage maintenance process. If then the coordinator crashes or is killed before the next checkpoint, the crash recovery process will incorrectly mark the space used by the commited transaction as available for new allocation.

CR:682518

CR Number:   682518 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2011 Fixed 21 Dec 2011 Fixed Description If an application that was connected using Open Client or jConnect executed a Transact SQL batch that contained an undefined host variable, then there was a chance the server would have crashed. This has now been fixed so that batch will fail with a "Host variable is not initialized" error.

CR:682609

CR Number:   682609 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 sp10 11 Dec 2014 Fixed Description IQ internal stored procedures indexname column definitions are defined as varchar(125) or char(125). Index names longer than this get truncated in the output from the sp. In IQ 15.x the default for option STRING_RTRUNCATION has changed , so instead of the index name being truncated you now by default you now get error message... "Right truncation of string data. SQLCODE -638 " This needs increasing to allow for longer index names. This is particularily so for procedures like sp_iqindexsize where the value put into the indexname column is actually made up of ownername.tablename.indexname Other procedures that may be affected include sp_iqindexuse, sp_iqunusedindex and sp_iqjoinindexsize. Workaround Description  set temporary option string_rtruncation=off NOTE... this only returns behaviour back to pre IQ 15.x where the index name gets truncated.

CR:682644

CR Number:   682644 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2011 Fixed 16 Sep 2011 Fixed Description A query with a probably_in semi-join condition into a column that contains many null values could cause a server abort.

CR:682882

CR Number:   682882 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to improve performance of sp_iqemptyfile.

CR:683016

CR Number:   683016 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ is designed to abort when it gets any error such as out of space condition while performing a privileged operation. We need a far clearer and less alarming error message for this.

CR:683072

CR Number:   683072 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2008 Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description LEFT JOIN and IS NULL to a NOT NULL column grow up CPU of IQ to 100%.

CR:683252

CR Number:   683252 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e12 06 Sep 2011 Fixed Description The following information was omitted from the Sybase IQ System Administration Guide. "Dropping a user from a multiplex writer while the user owns local objects (in local stores) on the readers can cause the readers to shut down. Before dropping a user, check for local object ownership on every reader and delete the local objects owned by that user on the local stores. After deleting local objects, drop the user on the writer. The deletion propagates to all the readers."

CR:683266

CR Number:   683266 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 08 Sep 2011 Fixed 15.3 e00.x 08 Sep 2011 Fixed 15.2 e03.x 09 Sep 2011 Fixed 15.2 e02.x 12 Sep 2011 Fixed Description In rare circumstances when using multiple writers in IQ MPX a bookkeeping error can occur that can lead to data corruption. The bookkeeping error can occur if a global RW transaction on a secondary writer happens at the same time as the periodic storage maintenance process and the periodic storage maintenance process can free up the space still in use by the global RW transaction.

CR:683487

CR Number:   683487 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Linux Red Hat Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description A CONNECT USING statement does not work by DBISQL of IQ15.

CR:683504

CR Number:   683504 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description -

CR:683632

CR Number:   683632 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Please add IQ server name in .lmp file

CR:683961

CR Number:   683961 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description @@identity always = 0 at INSERT table (col) SELECT 'constant'

CR:683993

CR Number:   683993 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 13 Mar 2013 Fixed Description The DBSpace wizard would cause an error if a striping size was entered and then striping set to off. This has been resolved to ensure no error when striping set to off.

CR:684434

CR Number:   684434 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2011 Insufficient priority to fix Description SYNCHRONIZE JOIN INDEX randomly fails in db_join.cxx:3759, hdb_hjoinexception

CR:684973

CR Number:   684973 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 05 Oct 2011 Fixed 24 Oct 2011 Added to user documentation 07 Oct 2011 Fixed 23 Dec 2011 Fixed Description The -iqsmem switch for shared memory allocation will now support values greater than 512MB on 64-bit IBM AIX platforms. Also the max supported limit for a single shared memory segment on AIX64 has been increased from 256MB to 32TB.

CR:684998

CR Number:   684998 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows 2003 Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2012 Fixed Description WITH expression of deraived table causes Assertion failed.

CR:685165

CR Number:   685165 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2011 Added to user documentation Description In addition to the INSERT permission on the table, EXECUTE permission must also be set on sp_iqrebuildindex to users in order to rebuild the index on that table.

CR:685728

CR Number:   685728 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2011 Fixed 30 Sep 2011 Fixed 30 Sep 2011 Fixed Description The IQ scripts: IQ-15_3.sh and IQ-15_4.sh used a non-posix compliant test. This has been fixed.

CR:686062

CR Number:   686062 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e12 20 Dec 2011 Fixed Description The server may stop processing while trying to get the LastStatement properties of another connection while that connection is attempting to commit or checkpoint. Workaround Description  The work-around is not to query the LastStatement property of another connection as you risk hanging the server if another thread is attempting to forbid.

CR:686288

CR Number:   686288 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e03.x 19 Oct 2011 Fixed 06 Dec 2011 Presently Not Targeted For Any Future Release Of This Product Description A query returns an invalid correlation name error if - a table T is joined with table S on an attribute col1 which is a primary key in table S and a foreign key in table T. - No other columns from table S are referred in the query. - owners of table T and S are different

CR:686296

CR Number:   686296 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2012 Presently Not Targeted For Any Future Release Of This Product 15.4 e02 14 Mar 2012 Fixed 14 May 2012 Fixed Description IQ gives non fatal error in some specific scenarios where a group by and aggregate is performed on an alias which refers to a CASE statement. Workaround Description  *** Thu Oct 20 12:14:48 UTC+0530 2011 *** mchavan *** A valid work around is to disable the aggregate simplification transform using: set temporary option dml_options4 = 1024 go ---------------- DML_options3=4194304 disables check for output and production vector validation and can potentially cause incorrect results, so not really a valid workaround

CR:686500

CR Number:   686500 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Dec 2011 Not a Bug Description IQUNLOAD -au, -n, -ax_genscript faile "Feature, aggregate 'list' not supported"

CR:686670

CR Number:   686670 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.3 e00.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2011 Fixed Description LOAD TABLE incorrectly reported a data conversion error and IQ Internal error.

CR:687564

CR Number:   687564 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 May 2012 Deferred 15.4 e02 24 May 2012 Fixed 15 Jun 2012 Fixed Description Group By operation associated with roll-up query does not execute in parallel. Workaround Description  force aggregation_preference=2. Will not work for generated queries.

CR:687679

CR Number:   687679 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 31 Jan 2012 Fixed 15.2 e03.x 28 Feb 2012 Fixed 15.4 e02.x 21 Dec 2012 Fixed Description An update to a table may stop processing while updating a multi-column primary key.

CR:687899

CR Number:   687899 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2008 Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ doesn't support WITH clauses.However, IQ reports an error, when SQL is run.

CR:688101

CR Number:   688101 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 02 Feb 2012 Workaround 24 Feb 2012 Added to user documentation 26 Jan 2012 Added to user documentation Description Use the following workaround if the version of Sybase Central installed with IQ 15.4 cannot start after you install ASE 15.7: 1. Recreate the $SYBASE/shared/JavaHelp-2_0 directory JavaHelp-2_0, if necessary. 2. Copy the $SYBASE/IQ-15_4/java/jh.jar file to the $SYBASE/shared/JavaHelp-2_0 directory. 3. Reload or register the IQ plugin in SC, if necessary. Workaround Description  1. The user should recreate the directory JavaHelp-2_0 in $SYBASE/shared if it was removed. 2. The user should then copy the file jh.jar in $SYBASE/IQ-15_4/java to that directory. 3. The user should reload or register (if necessary) the IQ plugin in SC

CR:688120

CR Number:   688120 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature to select past versions of a given table similar to SELECT AS AT '<DATE>' * Oracle has the "FLASHBACK" feature (SELECT AS AT '<DATE>') implemented since Oracle9i and has been improved in Oracle 10g & 11g * PARACCEL (MPP database) has it on their roadmap. When doing a SELECT AS AT '<DATE>' , the DBMS engine would provide a list of all the snapshot versions that were taken on that '<DATE>' for that table. As with IQ , the snapshot versions only contain the delta of changes since the previous version, to reduce space requirements. The FR would require a "snapshot" of a table after each version change for a specific period of time before it will be destroyed. -> This will cost a lot of storage and based on a quick read up on the Oracle documentation this has some down turns. Workaround Description  Possible Workaround ?: Use Type 2 dimensions (Slowly changing dimension) to track historical data (by creating multiple records for a given key). -> You can store all data of position movements into one table based on timestamps. --> Based on such a table you should be able to build queries which can produce the result they are looking for. --> This would allow selecting versions of a column at a particular point in time, but of course come at a storage & complexity cost. NOTE: RAP (R3 EE or later) which includes "Time Series" functionality should be capable of doing this already, and provides UDF functions to analyse the data (autocorrelation, moving averages, etc..). Some of these functions may also be available in IQ 15.4 with the IQ_IDA license...

CR:688152

CR Number:   688152 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 31 Jan 2012 Fixed Description sp_iqcheckdb may report missing keys checking a partition for a partitioned table that has a multi-column primary key.

CR:688319

CR Number:   688319 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02.x 29 Dec 2011 Fixed 24 Jan 2012 Fixed 27 Feb 2012 Fixed 20 Feb 2012 Fixed 15.4 e01 31 Jan 2012 Fixed 06 Feb 2012 Fixed Description While committing a global transaction on a coordinator, the coordinator takes ownership of blocks allocated by the corresponding writer transaction. The coordinator commits and updates bookkeeping structures as if those blocks were allocated locally. However, in certain cases, these blocks may be reallocated. Reallocation invalidates ownership transfer from writer to coordinator and writes incorrect information to the transaction log on commit. If the coordinator server fails before the next checkpoint, and recovery of global transaction uses incorrect data, inconsistent bookkeeping structures may result.

CR:688429

CR Number:   688429 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Oct 2011 Fixed 11 Nov 2011 Not a Bug Description IQ database paths may not contain a file extension when using a native file system file and will NOT contain a file extension when using a raw device path. Raw devices are a fully qualified path to a physical device attached to the machine, for example: Windows: \\.\E: \\.\PhysicalDrive1 Unix: /dev/md/rdsk/bigdb /dev/md/rdsk/bigtmp When creating a database, the IQ specific paths no longer check for a file extension, however the SA specific paths (.db, .log and mirror) still check for a file extension. For the dbspace commands, the server will not require file extensions.

CR:688452

CR Number:   688452 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows 2003 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Feb 2012 Added to user documentation Description The Sybase IQ 15.4 installer includes 'unknown' product edition and 'unknown' license type options. Sybase includes these options to accommodate potential problems in the license file where the product edition or license type may not be valid. Target Version  15.4 e01

CR:688884

CR Number:   688884 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Nov 2011 Fixed 15.4 e01 15 Feb 2012 Fixed 18 Dec 2011 Fixed Description The procedure sp_iqmodifyadmin exists only for backward compatibility with Sybase IQ 12.7. Use ALTER LOGIN POLICY to change login policies or configure logical server access.

CR:688917

CR Number:   688917 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Linux Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 02 Nov 2011 Fixed 15.4 07 Nov 2011 Added to user documentation Description When using DBISQL to connect to the server, you might encounter the following error: "You cannot user the Host connection parameter and advanced network parameters at the same time." This has been fixed.

CR:689051

CR Number:   689051 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows 2008 Original Version:   15.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 02 Nov 2011 Fixed Description The Sybase IQ 64-bit Windows installer might not install all oledb drivers.

CR:689123

CR Number:   689123 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2008 Original Version:   15.2 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Join which used compressed FP index and Sort/Marge may cause a conversion error. Workaround Description  set temporary option join_preference=-1 ;

CR:689608

CR Number:   689608 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Linux Red Hat Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e03.x 25 Nov 2011 Fixed 15.4 e01.x 08 Feb 2012 Fixed 16 May 2012 Fixed Description A query returns an invalid correlation name error if - a table T is joined with table S on an attribute col1 which is a primary key in table S and a foreign key in table T. - No other columns from table S are referred in the query. - owners of table T and S are different - An alias is given to table T

CR:689775

CR Number:   689775 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.2 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01.x 20 Apr 2012 Fixed 15.4 e02 17 Jul 2012 Fixed 10 Jan 2013 Presently Not Targeted For Any Future Release Of This Product 30 Sep 2013 Fixed Description a query that uses a nested loop push down join and uses early predicate execution may abort. Workaround Description  The workaround for this issue is disable Early Predicate Execution optimization, use command below, set temporary option Early_Predicate_Execution = 'OFF' ;