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

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

CR:610065

CR Number:   610065 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) 12.7 e10 27 Jan 2010 Fixed Description On UNIX, interrupting an external procedure call (for example, by pressing CTRL-C in the console to which the server is attached) sometimes caused a server failure. Workaround Description  Not yet.

CR:611009

CR Number:   611009 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.0 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2010 Duplicate Description On the MPX coordinator, the following sequence of user actions leads to other nodes of the MPX to crash: 1. dba creates a stored procedure or a table specifying dbo as the owner 2. dba drops the stored procedure or the table without specifying the owner 3. dba re-creates the stored procedure or the table as in step 1 This has been fixed.

CR:611090

CR Number:   611090 Product Name:   IQ Product Component:   Install Status:   Closed OS:   AIX Original Version:   15.1 l10n Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2011 Presently Not Targeted For Any Future Release Of This Product Description The screen of InstallShield is too long when EUC_JIS environment is used by AIX 6.1.

CR:611539

CR Number:   611539 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 15 Jan 2010 Fixed 22 Dec 2009 Presently Not Targeted For Any Future Release Of This Product 15.2 18 Jan 2010 Fixed Description When a query was having the order by rowid desc so we might have wrong result. Now this problem is fixed.

CR:611560

CR Number:   611560 Product Name:   IQ Product Component:   Install Status:   Closed OS:   AIX Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 03 Feb 2010 Fixed 17 Feb 2010 Fixed Description Downloaded IQ 15.1 Enterprise edition for AIX 64 bit from SPDC. The GUI installer and the silent installer do not create bin folders in the SYSAM-2_0 directory. Workaround Description  the solution for now is to install SYSAM-2 from within the IQ installer, in console mode, using the "-console" option. : ./setup -console. This creates the bin directory ok.

CR:611815

CR Number:   611815 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) 21 Dec 2009 Consult Complete 02 Feb 2010 Fixed 11 Feb 2010 Fixed 26 Jan 2010 Presently Not Targeted For Any Future Release Of This Product Description An IQ Multiplex Reader may crash while doing local TLV replay of create index statements within a begin and end parallel blocks. This has been fixed.

CR:612007

CR Number:   612007 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2012 Duplicate Description Sybase IQ does not support raw access to a GPT disk. raw access to an MBR disk is possible for IQ. Workaround Description  Please re-create a physical disk by MBR.

CR:613003

CR Number:   613003 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 07 Jan 2010 Fixed 15.2 11 Jan 2010 Fixed 12.7 e10 07 Mar 2010 Fixed Description SELECT query with UNION ALL, ORDER BY DESC, TOP returned an incorrect result.

CR:613262

CR Number:   613262 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 18 Jan 2010 Fixed Description Executing a query like the following from SQL Server Management Studio (2005): select * from saoledblink..SYS.syscollation; would have failed with the error: Msg 7356, Level 16, State 1, Line 1 The OLE DB provider "SAOLEDB.11" for linked server "saoledblink" supplied nconsistent metadata for a column. The column "collation_order" (compile-time ordinal 4) of object ""SYS"."syscollation"" was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 0 at compile time and 16 at run time. The problem occurred for BINARY(n) columns. The DBCOLUMNFLAGS_ISFIXEDLENGTH schema attribute was set true (0x10) at run time. This problem has been fixed.

CR:613601

CR Number:   613601 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 02 Jun 2010 Fixed Description Multiplex: In Sybase IQ 15.0 and later versions, restore of a multiplex coordinator requires the utility database to be started with the same server name. This is a change in behavior since 12.7 and was also a problem for users attempting to restore, when the production server was running using the coordinator server name.

CR:613674

CR Number:   613674 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 22 Jan 2010 Fixed Description An uninitialized parameter leads to a generic non-fatal IQ internal error message. This has been fixed. The message is now "Host variable 'xxx' is not initialized" where xxx is the name of the uninitialized parameter.

CR:613920

CR Number:   613920 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.1 l10n Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 10 Mar 2010 Fixed Description IQ/SA Utility cannot recognize the following AIX Japanese locales correct. Ja_JP Ja_JP.IBM-932 Workaround Description  Ja_JP.IBM-943 are set to be a locale. IQ/SA Utility will return the message of Shift JIS. However, IBM-943 are not included in locales.dat. It is necessary to add "locale = Ja_JP.IBM-943, japanese, sjis" to locales.dat.

CR:614055

CR Number:   614055 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2013 Fixed Description IQ support for ISNUMERIC()

CR:614148

CR Number:   614148 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 26 Jan 2010 Fixed 15.2 22 Feb 2010 Fixed 26 Jan 2010 Not a Bug Description Secondary nodes are shutting down because of a failure in propagating stored procedures from the coordinator to the secondary nodes. This will only happen when a stored procedure is recreated after being dropped and the stored procedure is not fully qualified. This has been fixed.

CR:614301

CR Number:   614301 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.7 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement on sp_iqindexfragmentation.

CR:614557

CR Number:   614557 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 03 Mar 2010 Fixed Description Core_options13 "PARAMID_COREOPTIONS13_TRACE_SORT_EXCEPTIONS" is added to print the diagnostic information, if needed, for insufficient buffers during sort.

CR:614770

CR Number:   614770 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.7 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e10 15 Apr 2010 Fixed Description The server randomly becomes unresponsive. This can happen when the main cache and/or the temporary cache is running low. Please contact Sybase Technical Support for assistance, if this issue occurs.

CR:614946

CR Number:   614946 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.7 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2010 Fixed Description We have a sproc that opens a cursor on a table and we fetch each row of the cursor and update one column of each row with the CURRENT OF clause. All is fine. But, in the cursor fetch loop, when we add a select count (*) from another table, then IQ SILENTLY updates a column that is not specified in the update statement!

CR:615244

CR Number:   615244 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2010 Consult Complete Description Msg 11206 is raised for second subsequent selects after set rowcount nn from IQ proxy table in ASE using latest 15.x OCS

CR:615402

CR Number:   615402 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.1 e03 04 Feb 2010 Added to user documentation Description Syntax error is raised with large Skip number which is greater than signed 32bit integer value.

CR:615638

CR Number:   615638 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e10 02 Mar 2010 Fixed 15.1 e03 02 Mar 2010 Fixed 15.2 08 Mar 2010 Fixed 15.3 08 Mar 2010 Fixed Description If the optimizer chose to use a push-down algorithm for join, while executing a query with many predicates between multiple tables, a non-fatal error sometimes occurred.

CR:615707

CR Number:   615707 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 29 Jan 2010 Fixed 15.1 e02.x 16 Feb 2010 Fixed Description Using the C Unicode data type SQL_C_WCHAR and a buffer length greater than 16K may cause the "IQ Internal error. Please report this to Sybase IQ support. -- (df_Heap.cxx 2695) " error. This has been fixed.

CR:615917

CR Number:   615917 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 22 Jan 2010 Fixed Description Improvements have been made to the query optimizer to improve optimization speed for queries containing deeply nested expressions.

CR:616212

CR Number:   616212 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   12.7 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Utility to give information about memory usage, cpu consumed per connection

CR:616343

CR Number:   616343 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 18 Feb 2010 Fixed 15.2 19 Feb 2010 Fixed Description When using a composite key and all the columns of the composite key are present in the join condition and one of the columns of the join condition is of different length (e.g in this case numeric(2) and numeric(5)) a wrong result may occur in the case of HPD Join. This has been fixed. Workaround Description  After wrong result is detected, match column length like below. TMKDD82.CORR_SPEC_SEQ_NO = TMKDD820.CSNO => CAST(TMKDD82.CORR_SPEC_SEQ_NO AS NUMERIC(9)) = TMKDD820.CSNO

CR:616381

CR Number:   616381 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.0 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 29 Jan 2010 Fixed Description sa_validate will erroneously report missing index entries. For example: Primary key for "ISYSIDX" has missing index entries Foreign key "ISYSTAB" has missing index entries Index name "index_name" has missing index entries

CR:617560

CR Number:   617560 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2008 Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e01 17 Feb 2010 Fixed 16 Feb 2010 Fixed Description Corrupted values may be returned to a caller for Multibyte CLOB values that span several database pages. Partial chars at the beginning and the end of a page is incorrectly handled in case of mulitbyte chars. This has been fixed.

CR:617617

CR Number:   617617 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request to improve handling error for inaccessible dbfile on the secondary server.

CR:617710

CR Number:   617710 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 30 Mar 2010 Added to user documentation Description The maximum of Number of tables per join index is 31.

CR:618157

CR Number:   618157 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 07 Mar 2010 Fixed 15.2 09 Mar 2010 Fixed Description Remove the incorrect extra system call of getrusage which boost up query performance.

CR:618632

CR Number:   618632 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 10 Feb 2010 Fixed 15.2 10 Feb 2010 Fixed Description Queries with a grouped leaf and conditions on the grouping column could perform poorly in some cases.

CR:618738

CR Number:   618738 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 27 Jul 2010 Fixed 15.3 29 Jul 2010 Fixed Description sp_iqcheckdb did not report an error, even if there was a byte FP lookup table inconsistency error.

CR:619114

CR Number:   619114 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 10 Mar 2010 Fixed Description If 'From' clause in a subselect section of a delete statement was missing then IQ Server was crashing with: *** ERROR *** Assertion failed: 201501 Page 0x0:0x0 for requested record not a table page UpdCur not updatable in IQ Sample Statement (missing from clause in select statement in where section): delete Contacts_new where surname in ( select distinct surname Contacts union select distinct surname Contacts ) Now the above kind of query will not lead to crash. If Contacts_new and Contacts will 1) IQ table- We will get the error "Update operation attempted on non-updatable remote query". The able mentioned query , internally converted to the following delete Contacts_new where surname in ( select distinct surname Contacts union select distinct surname as Contacts from SYS.DUMMY ) SYS.Dummy is the SA table thatswhy we will get this error. 2)SA table - All the rows of Contacts_new will be deleted or Contacts_new table will truncated. Because , Here column "surname" is not found in the subquery, then it will be search in the outer query block. Since table "Contacts_new" has a column "surname" it is a valid out reference and the WHERE clause is always true.

CR:619211

CR Number:   619211 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e00.x 09 Jun 2010 Fixed 15.2 e01 14 Jun 2010 Fixed 14 Jun 2010 Fixed 14 Jun 2010 Fixed Description Multiplex: A GRANT or REVOKE statement on an invalid view caused a multiplex node failure at saint_iqthresholdddl.cxx:6232 with the error "Unexpected error during commit."

CR:619347

CR Number:   619347 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 May 2010 Fixed 11 May 2010 Fixed Description When the SKIP option is set to be load table, even if IQ finds the error included in a data file, it may not execute rollback. Therefore, IQ will insert the read data of a part in IQ.

CR:619352

CR Number:   619352 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 05 Mar 2010 Presently Not Targeted For Any Future Release Of This Product Description The guideline about the size of IQ_SYSTEM_MAIN currently written to the administrator guide is aimed at large-scale DB.

CR:619358

CR Number:   619358 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.2 25 Feb 2010 Fixed 15.1 e03 25 Feb 2010 Fixed 24 Mar 2010 Added to user documentation Description INSERT LOCATION may truncate TEXT and IMAGE data from an OpenServer application to 32k.

CR:619361

CR Number:   619361 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 21 May 2010 Fixed 15.2 e00.x 15 Jun 2010 Fixed 05 Oct 2010 Fixed Description A problem with virtual and incremental backups led to large size backups of Sybase IQ 15.x databases, compared to backups of 12.7 databases.

CR:619601

CR Number:   619601 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2012 Fixed Description Provide LDAP/UA, LDAP User Authentication, for IQ.

CR:619628

CR Number:   619628 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.7 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2010 Fixed Description Setting Compression option with invalid value 'OFF' causing MPX dbremote to fail.

CR:619803

CR Number:   619803 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.7 e06.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2011 Presently Not Targeted For Any Future Release Of This Product Description Feature Request for IQ to support GB18030 as storage format.

CR:619804

CR Number:   619804 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2003 Original Version:   15.2 l10n Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Restriction of DB collation and OS locale must be in agreement. However, it is unknown whether this restriction is specification.

CR:620097

CR Number:   620097 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.1 e03 25 Feb 2010 Duplicate 24 Mar 2010 Added to user documentation Description If an application connected to IQ using Open Client 15.5 and attempted to fetch a time or timestamp value, then the fetch would fail with a TDS protocol error. This problem has now been fixed. Note that this problem does not affect versions of Open Client prior to 15.5. Workaround Description  A workaround for this problem is to set the option RETURN_DATE_TIME_AS_STRING = 'ON'

CR:620281

CR Number:   620281 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.7 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Mar 2010 Consult Complete 12.7 e10 04 Mar 2010 Fixed 15.1 e03 05 Mar 2010 Fixed 15.2 05 Mar 2010 Fixed Description The Sybase IQ server sometimes failed during recovery, if the server was restarted after it stopped for a disk-full condition on the disk where the transaction log resided.

CR:620444

CR Number:   620444 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 Using DBISQL ->Tools ->PlanViewer may cause IQ Server to shut down immediately when temporary Tables are used and IQ Server memory is limited.

CR:620458

CR Number:   620458 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.0 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 future 08 Nov 2013 EOL'd version. Not to be Fixed. 15.4 05 Jun 2011 Fixed 16.0 25 Dec 2011 Fixed Description A driven table that contains UNION ALL and NOT/ EXISTS correlated subqueries with conjunctive condition cause the query to fail with non-fatal stack trace at opt_TableNode.cxx. Workaround Description  *** Wed Mar 23 2011 18:19:29 GMT+0530 (India Standard Time) *** manishas *** Below is the Workaround for this issue, set option dml_options3 = 16777216 This will avoid predicate simplification and this is more better with respect to performance compared to avoiding subquery flattening.

CR:620636

CR Number:   620636 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Windows XP Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e10 17 Mar 2010 Fixed Description The sp_iqdbspaceinfo stored procedure returned incorrect values for the DbspaceSize column, when dbspace sizes were over 4GB.

CR:621197

CR Number:   621197 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 e10 12 Apr 2010 Added to user documentation 15.2 05 Apr 2010 Added to user documentation Description @@rowcount is not supported in a Sybase IQ database. However, in versions 12.7 and 15.1, @@rowcount behaves as expected.

CR:621247

CR Number:   621247 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.7 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2010 Consult Complete 20 Oct 2010 Fixed 20 Oct 2010 Fixed Description Please see description for CR 594295

CR:621461

CR Number:   621461 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) 15.2 e01 20 May 2010 Fixed 15.2 e00.x 03 Jun 2010 Fixed Description A query with aggregate functions (for example, SUM and AVG) with COALESCE(isnull, ifnull) returned NULL, when the query optimizer chose parallel GBH. Workaround Description  set temporary option DML_options8=8;

CR:621473

CR Number:   621473 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03 16 Mar 2010 Duplicate Description This problem is duplicate of the problem 620950/615638. while executing a query which had many predicates between multiple tables and when optimizer chooses to use a push-down algorithm for join, a non-fatal error occured. This problem has been fixed now.

CR:621716

CR Number:   621716 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03.x 11 Jun 2010 Fixed 15.2 e00.x 17 Jun 2010 Fixed 15.2 e01 17 Jun 2010 Fixed 15.3 17 Jun 2010 Fixed Description A timing sensitive deadlock could occur in the IQ main or temp buffer cache, if all pages of the cache were locked or dirty. This error was reported: "main Bufman: All buffer cache pages are in use, ask your DBA to increase the size of the buffer cache." Workaround Description  No

CR:621836

CR Number:   621836 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 Jun 2010 Fixed 12.7 e10 15 Jun 2010 Fixed 15.2 e00.x 15 Jun 2010 Fixed 15.2 e01 15 Jun 2010 Fixed 17 Nov 2010 Fixed Description A virtual restore failed with the error: "Msg 21, Level 14, State 0: SQL Anywhere Error ~1006167: DateTime is invalid (0)".

CR:622519

CR Number:   622519 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   12.7 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NFR: A way to allow mapping all remote logins to one local name.

CR:623179

CR Number:   623179 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e00.x 03 Jun 2010 Fixed 15.2 e02 28 Jun 2010 Fixed 15.1 e03.x 11 Jun 2010 Fixed Description The error "Non-Fatal IQ Internal Error Detected at opt_Driver.cxx:5700" was reported by an IQ error checking routine to ensure that the IQ server did not fail due to invalid data structures. The routine checked whether a column from a view or derived table was valid for a partitioned table optimization, where IQ can treat the output of a UNION ALL as a single table. The check was modified to permit the valid query.

CR:623313

CR Number:   623313 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.2 Beta Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NFR Please improve message by providing which value got truncated

CR:623457

CR Number:   623457 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.7 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e10 04 May 2010 Fixed 15.2 e01 12 May 2010 Fixed 15.3 12 May 2010 Fixed 12.7 e10 25 May 2010 Fixed Description Multiplex: A view using a date order different than the query server date_order did not propagate to the query server. View creation now propagates to query nodes. After creating a view using date/timestamp/datetime as filters, set the date_order option on the query node to the same value as the date_order option on the writer node to perform a query on that view.

CR:623511

CR Number:   623511 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   12.7 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The default value of Max_Warnings of Linux x86 -64 is too low. The default of this value should be 281479761065

CR:623588

CR Number:   623588 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.1 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature Request: instead of 'NA',sp_iqdbspace run on secondary node should display a warning message.

CR:623701

CR Number:   623701 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.1 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e00.x 08 Jun 2010 Fixed 15.3 08 Jun 2010 Fixed 15.2 e01 08 Jun 2010 Fixed 12.7 e11 11 Jun 2010 Fixed 15.1 e03.x 11 Jun 2010 Fixed Description An IN predicate based query returned an exception from s_bm.cxx:2807 and the error "O/S Err#: 0, ErrID: 2049 (sbm_exception); SQLCode: -1009045, SQLState: 'QSA45', Severity: 14 Bitmap failed internal checks. You may have a damaged index. Please check your IQ message file for additional information." and rolled back. Workaround Description  No Yet

CR:623706

CR Number:   623706 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 21 May 2010 Fixed 03 Nov 2010 Fixed 27 Jun 2012 Not a Bug Description ISNULL() is not estimated correctly in an IF statement.

CR:624191

CR Number:   624191 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.2 Beta Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e00.x 03 Jun 2010 Fixed 15.2 e02 28 Jun 2010 Fixed 18 Aug 2010 Presently Not Targeted For Any Future Release Of This Product Description A query that fetched rows in descending order by rowid, for example, ORDER BY ROWID(table) DESC, returned incorrect results.

CR:624200

CR Number:   624200 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Unknown Original Version:   12.7 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request the audit text format from the translated transaction log file.

CR:624398

CR Number:   624398 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Windows 2003 Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ 15.1 ADO.NET policy file not reflecting 15.0 version of provider in bindingRedirect

CR:624551

CR Number:   624551 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.0 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 16 Apr 2010 Fixed 12.7 e10 16 Apr 2010 Fixed 08 Jul 2010 Fixed Description hextoint() function with a value greater that 8 bytes may have caused a server failure with inconsistent memory detected. Workaround Description  Use workaround option as ASE_Function_Behavior='on'

CR:624645

CR Number:   624645 Product Name:   IQ Product Component:   Documentation Status:   Open OS:   Unknown Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description DOC: Add example on how to use connection string with ADO.NET.

CR:624968

CR Number:   624968 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.7 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e10 28 May 2010 Fixed 15.2 e01 02 Jun 2010 Fixed 15.3 02 Jun 2010 Fixed Description Creating a dbspace between 1 and 2 TB on a raw partition on AIX sometimes caused the server to fail in s_dbmvbio::PlaceNewSegment.

CR:625054

CR Number:   625054 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.1 l10n Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2013 Consult Complete Description The language set as DB Collation is used for a message language after IQ15.1ESD#1i. The method which changes a message language does not exist.

CR:625129

CR Number:   625129 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.1 future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description They would like a FR so that the BACKUP and RESTORE commands also backup and restore the .lmp license key file.

CR:625154

CR Number:   625154 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2010 Failed 15.1 e03 20 Apr 2010 Fixed 15.1 e03 03 May 2010 Fixed Description Restoring Multiplex co-ordinator using an incremental/incremental since full backup will fail if the backup was taken immediately after allocation activity from a writer server. All releases post 15.0 till 15.1esd 2 are effected. This has now been fixed in 151esd3. Workaround Description  dthrall 5/5/10 commenting out "old" workaroud and udpating with new ones. /* take backup after assuring that the writer servers are inactive for 10 INC heartbeat events. */ There are two ways to work around the problem: Workaround # 1 When preparing for incremental backups, perform the following steps: 1. Perform a normal shutdown of all writer servers. Note that killing of the writer servers does not constitute a normal shutdown. The writers servers need to be shutdown cleanly. 2. Execute a checkpoint on the coordinator. a. Execute another checkpoint on the coordinator. b. Run sp_iqdbspace('IQ_SYSTEM_MAIN') and verify that there are no 'G' (Global Free list Manager) type blocks in the BlkTypes column. For more information on Block Types see http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/CIHDAEDC.htm If all writers have been shutdown properly and G type blocks still appear, stop here and call Sybase support. 3. Execute the backup command for incremental or incremental since full backup. 4. After the incremental backup command is complete, restart the write servers. Workaround #2 The intermediate structures created during writer activity are cleaned up periodically every 600 seconds by default. Once these structures are cleaned up, the backups taken will not encounter the above problem. Before taking an incremental backup, please ensure following: 1. All writers have committed the active transaction. 2. All the writers are inactive (i.e. no transactions are run) for a period of more than 600 seconds. 3. Execute a checkpoint on the coordinator. a. Execute another checkpoint on the coordinator. b. Run sp_iqdbspace('IQ_SYSTEM_MAIN') and verify that there are no 'G' (Global Free list Manager) type blocks in the BlkTypes column. For more information on Block Types see http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc38151.1510/html/iqrefbb/CIHDAEDC.htm If G type blocks still appear, recheck that all writers have committed all transactions. If G blocks persist, you must use Workaround #1. 4. Execute the backup command for incremental or incremental since full backup. For the workaround #2, it would be difficult to ascertain that the writer servers have been completely inactive for the 10 minute duration. Hence, it is recommended that the customer use workaround #1.

CR:625208

CR Number:   625208 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.1 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 16 Apr 2010 Fixed 15.1 e04 16 Apr 2010 Fixed 15.1 e03.x 17 May 2010 Fixed 15.3 16 Jun 2010 Fixed Description Running INSERT...LOCATION against a Sybase IQ database created with collation 950ZHO_TW to import data from a remote ASE server generated an exception thrown from hqm_con.cxx:182 and reported the error "SQLCode: -1006000, SQLState: 'QBA00', Severity: 23 IQ Internal error. Please report this to Sybase IQ support."

CR:625242

CR Number:   625242 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) Description The restriction which adds new conditions to table partition of IQ exists. For example, new conditions cannot be allocated to new dbspace. New conditions are applied within the existing dbspace.

CR:625261

CR Number:   625261 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.1 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.1 e03.x 11 Jun 2010 Fixed 15.2 e00.x 17 Jun 2010 Fixed 15.2 e01 17 Jun 2010 Fixed 15.3 17 Jun 2010 Fixed Description Multiplex: Multiplex nodes were unresponsive and went to a pending status. A timing sensitive deadlock could occur in the IQ main or temp buffer cache, if all pages of the cache were locked or dirty.

CR:625659

CR Number:   625659 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Linux Red Hat Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request sa_recompile_views() proc to return meaningful error when encounter invalid view.

CR:625757

CR Number:   625757 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.7 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 13 Dec 2010 Fixed Description incorrect result using local var in where clause and UNION ALL

CR:626416

CR Number:   626416 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.7 e09 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2010 Not a Bug Description SELECT datepart(cwk,'2010/01/01') returns 53 coorectly, but returns erroneously 52 when selecting it from a table. This option must be set: set option Date_First_Day_Of_Week = 1;

CR:626436

CR Number:   626436 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e02 02 Sep 2010 Fixed 23 Sep 2010 Fixed 23 Sep 2010 Fixed 23 Sep 2010 Fixed Description Due to a 3 byte FP index inconsistency, a query or sp_iqcheckdb caused a server failure in s_dpThreeByteFetch::GetCardinalty or inconsistencies in memory. Workaround Description  The only workaround is to use flat FP instead.

CR:626488

CR Number:   626488 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 Visual Studio: Adding a data grid and database connection to a windows form resulted in an error. Visual Studio could not generate DataSets and Entity Framework models using Sybase IQ data sources.

CR:626489

CR Number:   626489 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 Jul 2010 Fixed Description Visual Studio: Accessing Sybase Central from the tools menu returned the error "The System could not find the file specified." Visual Studio was missing entries for Interactive SQL and Sybase Central.

CR:626490

CR Number:   626490 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   15.1 e03.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 13 Aug 2010 Fixed Description Visual Studio: The Server Explorer pulldown menu for DSN did not list any configured DSNs. The Visual Studio integration component now searches Sybase IQ data sources using the prefix "SYBASE IQ".

CR:626607

CR Number:   626607 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Suse Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 10 May 2010 Fixed 15.3 10 May 2010 Fixed Description The error "Syntax error - ORDER BY item of WITHIN GROUP clause must be expression over column" is generated, if the ORDER BY of the WITHIN GROUP clause of the PERCENTILE_DISC function is over a constant expression. This error is correct, since the ORDER BY over a constant expression makes no sense. The error message is now more accurate.

CR:626644

CR Number:   626644 Product Name:   IQ Product Component:   Documentation Status:   Open OS:   Linux Red Hat Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description if output file is not specified with -zo startup parameter, then all logging from -zr (ALL , NONE, or SQL) is logged in srvlog

CR:627003

CR Number:   627003 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) 19 Jul 2010 Not a Bug 18 Nov 2010 Consult Complete Description IQ 15.x fails in restore using backup of readonly dbspace.

CR:627304

CR Number:   627304 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) 15.2 e01 27 Jun 2012 Fixed 15.2 e00.x 08 Jun 2010 Fixed Description A query referencing a view or derived table that contained a select list item that was not a table column could cause a server fault, when executing in an IQ table or a proxy table. The error reported was "SQLCode: -1001047, SQLState: 'QFA43', Severity: 14 Column: is not accessible in this context. -- (df_GenerateDF.cxx 192)."

CR:627445

CR Number:   627445 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Linux Red Hat Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Console mode of DBISQL cannot print multiple results.

CR:627485

CR Number:   627485 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) 15.2 e02 07 Nov 2013 Fixed 15.2 e01 25 Aug 2010 Fixed Description A server failure was caused by delayed projection optimization that affected push-down join conditions.

CR:627508

CR Number:   627508 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2010 Fixed 04 May 2010 Fixed 04 May 2010 Fixed Description Restoring Multiplex co-ordinator using an incremental/incremental since full backup will fail if the backup was taken immediately after allocation activity from a writer server. All releases post 15.0 till 15.1esd 2 are effected. This has now been fixed in 151esd3. Workaround Description  take backup after assuring that the writer servers are inactive for 10 INC heartbeat events.

CR:627514

CR Number:   627514 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 07 May 2010 Third Party Problem Description Documentation Request for the Errors and Warnings of TIME SERIES functions like ts_arma_ar in RAP A list of IMSL errors are in files imslerr.dat and imsls_e.dat. A copy of those files can be opened in any text editor.

CR:627568

CR Number:   627568 Product Name:   IQ Product Component:   other Status:   Open OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jun 2010 Fixed Description When additional CPUs are added while IQ is running and IQ repeated fails to check-out licenses for the additional CPUs it should shutdown after 30 days.

CR:627724

CR Number:   627724 Product Name:   IQ Product Component:   Utility Status:   Open OS:   Windows 2003 Original Version:   15.1 l10n Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The utility which changes a message log and a language to Sybase IQ 15.x is not attached. Probably, IQ should release a message log language change utility.

CR:628049

CR Number:   628049 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2010 Fixed Description The Interactive SQL utility option isql_print_result_set was being ignored. This has been corrcted so that it is once again respected.

CR:628222

CR Number:   628222 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 e01 10 Jun 2010 Fixed Description A query that joined view tables and the join condition contained CASE statements failed with the error "IQ Internal error. Please report this to Sybase IQ support. -- (dfjo.cxx 198) [-1006000] ['QBA00']."

CR:628413

CR Number:   628413 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.1 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Sep 2010 Fixed Description trying to load from a client side pipe on AIX does not work

CR:628455

CR Number:   628455 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 29 Nov 2010 Fixed 15.2 e03 17 Nov 2010 Workaround 15.3 17 Nov 2010 Workaround 12.7 e10.x 10 Dec 2010 Fixed Description Under some rare circumstances, when a local temporary table went out of scope, the server failed at s_blockmap.cxx:2440. Workaround Description  Set set option CORE_ Options13=67108864; to use the workaround.

CR:628477

CR Number:   628477 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) 15.2 e00.x 11 Jun 2010 Fixed 15.1 e03.x 11 Jun 2010 Fixed 15.2 e01 11 Jun 2010 Fixed 15.3 11 Jun 2010 Fixed Description Multiplex: A coordinator shut down, then after a period of time some of the writers shut down with a non-fatal IQ internal error detected at s_bm.cxx:1476 and the message "Bitmap result bitcount not in legal range."

CR:628581

CR Number:   628581 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 Enhance IQ auding for enterprise customers

CR:628619

CR Number:   628619 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 Beta Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e01 24 Jun 2010 Fixed 15.3 24 Aug 2010 Fixed Description Problem due to a replacing CASE predicate for optimization within group by node if NULL due to which IQ optimizer used "sort" algorithm for group by node, as it chose "sort-mege" algorithm in resolving the join node has been resolved. Workaround Description  Not yet

CR:628667

CR Number:   628667 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) 15.2 e01 28 Jun 2010 Fixed 15.3 09 Feb 2011 Fixed Description Server failed if query flattening optimization was be applied to a Subquery aggregate scalar function. This has been fixed. Workaround Description  set temporary option SUBQUERY_FLATTENING_PREFERENCE=-2

CR:629012

CR Number:   629012 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 load table to the partition table which uses a compression column fails. IQ fails in the dirty page to a buffer cache at creation. Workaround Description  Please set IQ_UNIQUE as a column.

CR:629163

CR Number:   629163 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 02 Jun 2010 Fixed 15.2 e01 02 Jun 2010 Fixed 15.2 02 Jun 2010 Fixed 27 Feb 2011 DEFER Description A SELECT TOP N GROUP BY ORDER BY DESC query returns an error "Non-Fatal IQ Internal Error Detected at opt_Driver.cxx:9059", followed by a server failure at st_server.cxx:1376. Workaround Description  Setting aggregation_preference to 1, 3 or -2 also makes the query work. Not sure if this is a valid work around yet for the customer.