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

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

CR:403817

CR Number:   403817 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.5 e07 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 02 Nov 2005 Fixed Description If a restore operation restored an obsolete path to the file_name column in the SYSFILE table for the SYSTEM dbspace, the file_name column could be incorrect even after the restore provided a new absolute path for the catalog database.

CR:403907

CR Number:   403907 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   SunOS Original Version:   12.6 port Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 18 Nov 2005 Fixed Description A 12.6 server could not start a 12.5 multiplex database using only the -iqmpx_ov switch. Workaround: using -iqmpx_sn switch.

CR:403953

CR Number:   403953 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 28 Sep 2005 Fixed Description After being restarted with many old versions, a write server may report errors in the IQ message file from the ev_iqmpx_status event.

CR:403954

CR Number:   403954 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 24 Oct 2005 Fixed Description Server failure SEGV at st_server.cxx:1164 might occur running sp_iqrebuildindex while making schema changes in the database.

CR:403965

CR Number:   403965 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 19 Oct 2005 Fixed Description A query containing an outer join using the hash pushdown algorithm and using an IN predicate for the pushdown caused a server failure. Workaround Description  set temporary option dml_options3 = 2147483648 set temporary option dml_options4 = 1073741824

CR:404010

CR Number:   404010 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 27 Oct 2005 Fixed Description The engine may fail under a certain race condition on the write server when the write server is being changed to single-node mode while another write server connection is running active transactions and generates tlv entries.

CR:404031

CR Number:   404031 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 27 Sep 2005 Fixed Description The installation program should end by reminding customers to run an ALTER DATABASE UPGRADE after applying an ESD.

CR:404284

CR Number:   404284 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   AIX Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 21 Sep 2005 Duplicate Description Setting system clock back could cause SQL log time to jump ahead ~25 days.

CR:404394

CR Number:   404394 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2005 Not a Bug Description IQ 12.6 isql exit causes 'Connection terminated abnormally' message in svr log

CR:404599

CR Number:   404599 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 20 Oct 2005 Fixed Description Errors in a user-defined sp_mpxcfg_<server> stored procedure could set query server PUBLICATION information incorrectly, and cause versions to accumlate on the write server.

CR:404602

CR Number:   404602 Product Name:   IQ Product Component:   other Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) Other 31 Jan 2007 DEFER 08 Jul 2010 Duplicate Description Add info from cr 401971 to IQ documentation

CR:404735

CR Number:   404735 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 05 May 2006 Fixed Description dbo.SYSOBJECTS.crdate should display the creation time of IQ objects.

CR:404776

CR Number:   404776 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 27 Oct 2005 Fixed Description The sp_iqrebuildindex procedure incorrectly creates a 1-byte FP for a tinyint column if either 'Minimize_Storage' = 'ON' or a column unique count is specified in the rebuild index.

CR:404788

CR Number:   404788 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 03 Oct 2005 Fixed Description A user could not create a query server using relative paths for the main and temporary dbspaces.

CR:405203

CR Number:   405203 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 06 Oct 2005 Fixed Description The following steps generated non-fatal error df_Heap.cxx:1909 on simple query: create variable @chkey decimal(2); select @chkey = 1; select @chkey FROM iq_dummy;

CR:405209

CR Number:   405209 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 18 Oct 2005 Fixed Description Running the sa_disk_free_space procedure from dbisql caused an IQ server to fail.

CR:405314

CR Number:   405314 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 2000 Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 26 Mar 2006 Fixed Description Document that if you create a table on the multiplex write server with the same name as a query server persistent table (created on a local store in the query server) then the query server table will be renamed to terminate with the ~ character.

CR:405658

CR Number:   405658 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 07 Nov 2005 Fixed Description Failure to start HP Itanium ESD 4.1 with caches > 4GB. Workaround Description  none

CR:405750

CR Number:   405750 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 25 Oct 2005 Fixed Description Under certain circumstances, after upgrading to 12.6 ESD4.1 or higher, a delete operation could cause the engine to fail with a SEGV or Signal 8 error depending on the structure of the FP indexes.

CR:405773

CR Number:   405773 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 14 Oct 2005 Fixed Description Not declaring a size for a varbinary datatype during the declare statement of the variable and then when doing a select on the variable will cause the server to stacktrace in st_server.cxx.

CR:405831

CR Number:   405831 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 22 Jan 2006 Fixed 12.6 e05 18 Oct 2005 Fixed Description Running sp_iqtablesize on a global temporary table may return an s_blockmap error.

CR:405841

CR Number:   405841 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 21 Oct 2005 Fixed Description Running sp_iqstatus concurrently from different connections used to cause errors due to locking of SYSIQFILE system table.

CR:405870

CR Number:   405870 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 27 Jul 2008 Fixed Description "Fatal error: memory exhausted" with large IN list

CR:406109

CR Number:   406109 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 25 Oct 2005 Fixed Description In ALTER DATABASE operations with qualifier..object syntax, Sybase IQ considered the first qualifier to be database rather than owner, causing synchronization problems.

CR:406123

CR Number:   406123 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 18 Oct 2005 Fixed Description Integrated Logins do not work when connecting to the server via a connection profile.

CR:406135

CR Number:   406135 Product Name:   IQ Product Component:   other Status:   Closed OS:   Linux Suse Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2005 Duplicate Description Request for sqlpp utility to be included along with IQ network client.

CR:406156

CR Number:   406156 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows 2000 Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 18 Oct 2005 Fixed Description Sybase Central takes longer to display Java Classes or column names in a table in Sybase IQ 12.6 than it did in 12.5.

CR:406321

CR Number:   406321 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 20 Oct 2005 Fixed Description The workaround provided for CR #403965 failed in some cases to avoid the problem.

CR:406430

CR Number:   406430 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 21 Oct 2005 Fixed 12.7 11 Nov 2005 Presently Not Targeted For Any Future Release Of This Product Description A query with multiple exclusive ranges returned an error at opt_TableNode.cxx 2099. For example: SELECT COUNT(*) FROM sales_order WHERE (cust_id > 20 AND cust_id < 10 AND id IS NULL) OR id >= 10 AND id <=5;

CR:406712

CR Number:   406712 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 30 Dec 2007 Fixed 15.1 01 May 2009 Added to user documentation Description Request to modify LOAD behavior logic when reading from a named pipe to detect when a determinate amount of time has passed where the process is no longer reading data from the named pipe.

CR:406856

CR Number:   406856 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 09 Nov 2005 Fixed Description After the IQ connection was dropped, IQ continued calculating found set for a long period of time, and thus caused table version accumulation.

CR:406921

CR Number:   406921 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 02 Dec 2005 Fixed Description 12.6 ESD5 MPX qnode abort at st_txnMgrn.cxx:362, non-fatal at s_buf.cxx:1022

CR:407556

CR Number:   407556 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 24 Oct 2005 Duplicate Description A server stacktrace occurred in add_string when the table or view name had a space or '_'.

CR:407558

CR Number:   407558 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 08 Mar 2006 Fixed Description The password_created timestamp now gets propagated to query servers.

CR:407778

CR Number:   407778 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 02 Nov 2005 Presently Not Targeted For Any Future Release Of This Product Description Adding an alias for a dbspace via the sp_iqmpxaliasdbspace stored procedure, can result in an invalid file_name value in sysiqfile if the path is to a raw device on Windows.

CR:407844

CR Number:   407844 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 03 Nov 2005 Fixed Description A small subset of queries containing IN pushdown join conditions or uncorrelated IN subquery conditions slowed down between ESD3 and ESD4.

CR:408379

CR Number:   408379 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 10 Nov 2005 Fixed Description A Sybase IQ 12.6 server failed with no error message/stack when query exceeded thread stack space.

CR:408462

CR Number:   408462 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows NT Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 25 Nov 2005 Fixed Description A query containing an atypical SELECT AS GROUP UNION ALL, CASE, SUM, IF THEN, and left outer join constructs caused IQ server failure at st_server.cxx:513.

CR:408504

CR Number:   408504 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   SunOS Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e06 26 Jan 2006 Fixed Description The IQ server might fail while running the Java VM Garbage Collection. This might occur before a very long array or string was allocated or while pieces of that array/string were being allocated. In this situation, if the Garbage Collection ran multiple times, the IQ server could fail. This typically occurred if a user ran a java program inside the IQ server or used CIS to connect to remote servers using jdbc connections and the program was memory intensive.

CR:409024

CR Number:   409024 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.5 e11 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 29 Nov 2005 Fixed Description Database recovery could have failed with assertion 201501 "Page for requested record not a table page or record not present on page". The problem would only have occurred in the event of the database server not shutting down cleanly while dbremote replication was taking place. It would also have been required that another connection revoked CONNECT or REMOTE from the remote user for which the transactions were being replicated. This problem has been fixed. The connection attempting to revoke permissions from the user for which replication is currently occurring will now receive an error indicating "Not allowed while user 'user_name' is actively replicating transactions". The connection attempting to REVOKE permissions will need to wait until replication completes (commit/rollback) before being able to revoke the permissions.

CR:409117

CR Number:   409117 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 20 Nov 2005 Fixed Description Under rare circumstances related to errors during subqueries, the database close portion of a server shutdown could report the error "Assertion failed: 101416 Heap left locked at database close" in the server log.

CR:409156

CR Number:   409156 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 08 Nov 2005 Fixed Description Interrupting a query containing a very large number of unions may result in a server failure.

CR:409164

CR Number:   409164 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2009 Duplicate Description SQL TEXT field of HTML queryplan to show SQL Statement of queryplan and not the SQL Statement of the query as send by the client.

CR:409385

CR Number:   409385 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 04 Dec 2005 Not reproducible with latest version of the product available as of Resolution Date Description Accessing table properties using iAnywhere JDBC driver takes over 1 hour for the customer.

CR:409486

CR Number:   409486 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 25 Apr 2006 Fixed Description Allow column/table comments to propagate without having to manually synchronize

CR:409512

CR Number:   409512 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 23 Nov 2005 Fixed Description An unusual query that contained a LIKE string with width greater than the column being queried could cause server failure. A LIKE query on a column defined as char(5) with a string of six or more characters is an example of such a query.

CR:409758

CR Number:   409758 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 08 Jun 2006 Fixed Description The sp_iqconnection procedure does not show Name when client is java application with jConnect.

CR:409769

CR Number:   409769 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 22 Nov 2005 Fixed Description A server failure resulted when CIS attempted to process a query containing ntile. Workaround Description  set temporary option conversion_error = 'off'; select column1, cast(column3 as bigint) as column4, ntile(2) over (order by column4) as xx, column2 into #temp from dummy_table000;

CR:409967

CR Number:   409967 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 25 Nov 2005 Fixed Description When logged in as 'DBA' to either dbisqlc or dbisql (java), when trying to create a permanent base table using the "SELECT INTO" command and specifying owner.tablename, the error "Table <table> not found".

CR:409984

CR Number:   409984 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2006 Presently Not Targeted For Any Future Release Of This Product Description Lock IQ devices to prevent accidental usage by non IQ processes

CR:410127

CR Number:   410127 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 12 Dec 2005 Fixed Description A query could fail if invariant external host variables were initialized to a maximum length greater than the database page size, so that the key didn't fit on a single page. Workaround Description  - remove the #temp table from the query - Remove the "OR" clause - Use a "UNION" instead of a "OR"

CR:410215

CR Number:   410215 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 23 Nov 2005 Fixed Description A query server failed with an emergency shutdown while replaying a BEGIN PARALLEL IQ clause that had previously successfully executed on the write server.

CR:410269

CR Number:   410269 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   12.6 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 29 Nov 2005 Fixed Description A CTRL-C generated a stack trace from s_bm.cxx during an INSERT INTO #temp operation.

CR:414505

CR Number:   414505 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Windows 2000 Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 17 Feb 2006 Fixed Description ALTER DBSPACE ADD uses space only from reserved space.

CR:414613

CR Number:   414613 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.8 26 Jan 2007 Fixed 15.0 21 May 2007 Fixed 12.7 e03 08 Jun 2007 Fixed Description During multiuser dbspace operations, a multiplex query server could report DBCC Unknown Exceptions.

CR:414639

CR Number:   414639 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2005 Insufficient priority to fix Description Server hangs when out of IQ MAIN DBSPACE condition exists

CR:414940

CR Number:   414940 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 04 Mar 2009 Fixed Description Request feature that forces immediate change of initial/default password.

CR:415153

CR Number:   415153 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.4.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 05 Dec 2005 Fixed Description A query using a PROBABLY_IN pushed join condition on a join key column with more than 700 million distinct values could, under unusual circumstances, cause a server failure. Workaround Description  This problem can be avoided by disabling the optimizer's consideration of any PROBABLY_IN sizes smaller than the ideal size: set temporary option DML_Options4 = 2048

CR:415159

CR Number:   415159 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Unknown Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 20 Apr 2006 Fixed 12.7 16 Mar 2006 Fixed Description A Sybase IQ server might fail running a query containing an outer reference from a derived table to an alias, if the derived table is a union intersect. Target Version  12.6 e07 Review Status  Query containing an outer reference from a derived table to an alias, and if the derived table is a union intersect, could cause server failure

CR:415481

CR Number:   415481 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Windows XP Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 26 Jan 2006 Fixed Description Japanese customer can't use MS Visual Studio .NET with IQ12.6 due to the CR405965. Workaround Description  none

CR:415510

CR Number:   415510 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 18 May 2006 Fixed 12.7 18 May 2006 Fixed Description The Sybase IQ engine failed performing an updatable cursor operation when no data had been previously fetched.

CR:415666

CR Number:   415666 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 09 Feb 2006 Fixed Description Cannot insert into an IQ table with identity column from ASE proxy.

CR:415880

CR Number:   415880 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 17 Mar 2006 Fixed 12.7 14 Aug 2006 Fixed Description Inconsistent table or index occurred as a result of a updatable cursor operation.

CR:416089

CR Number:   416089 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e06 20 Jan 2006 Fixed Description On 64-bit platforms there was a problem in the implementation of the ODBC API call SQLColAttributes(). A pointer to a 32-bit int was being returned instead of a pointer to a 64-bit int as specified by the ODBC standard. This has been corrected in the ASA/IQ ODBC driver and in other product components that use this interface call.

CR:416382

CR Number:   416382 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.3 21 Apr 2011 Insufficient priority to fix Description More examples how to write the load statement,especially if date's are involved.

CR:416669

CR Number:   416669 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.5 e08 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 02 May 2006 Fixed 12.7 05 May 2006 Fixed Description Queries containing functional expressions over outer references could return unexpected results. Target Version  12.6 e07

CR:416859

CR Number:   416859 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Option to get original create date/time of a login

CR:416981

CR Number:   416981 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 23 Jul 2008 Fixed Description Request for option that forces password re-authentication, such as on UNIX.

CR:416986

CR Number:   416986 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 10 Mar 2006 Fixed Description References to sp_iqcommandstats will be removed in the next revision of the Sybase IQ Reference Manual. New Features in Sybase IQ 12.6 correctly states that this procedure is no longer supported.

CR:417147

CR Number:   417147 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Windows 2000 Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e05 06 Jan 2006 Fixed Description Under rare circumstances, on Windows systems only, query server startup could fail with the error "share violation: another process may be using the file."

CR:417507

CR Number:   417507 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e01 04 Oct 2006 Fixed Description The result datatype of a REPLACE function is a long varchar when used in a SELECT ... INTO statement.

CR:417521

CR Number:   417521 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 06 Apr 2006 Fixed 12.6 e07 05 Apr 2006 Fixed Description DESCRIBE not properly reporting NOT NULL attribute for many data types.

CR:417615

CR Number:   417615 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 29 Mar 2006 Fixed 12.7 29 Mar 2006 Fixed Description When MINIMIZE_STORAGE was set ON, a query containing expressions inside the CASE statement involving only one column returned a conversion error. Target Version  12.6 e07 Workaround Description  Turn Minimize_storage option to "OFF"

CR:418213

CR Number:   418213 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2000 Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 30 Mar 2006 Fixed 12.7 20 Mar 2006 Fixed Description When trying to rebuild 19 or more indexes within a single transaction, a multiplex write server might fail.

CR:418252

CR Number:   418252 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 08 May 2006 Fixed 12.7 10 May 2006 Fixed Description If a user ran drop leaks on a query server with a local store started with forced recovery and -iqnolocalreplay, subsequent attempts to access objects in the local store might fail. Target Version  12.6 e07

CR:418344

CR Number:   418344 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 27 Mar 2006 Fixed Description Update documentation to make it clear that Open Client can be used to create programs that access IQ base table data.

CR:418745

CR Number:   418745 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e06 30 Jan 2006 Fixed Description CR 353999 "IQ Agent needs adjustable timeout setting" was a new feature implemented in 12.6 GA, but it was omitted from documentation. It is now documented in the Sybase IQ Release Bulletin.

CR:418759

CR Number:   418759 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Linux Red Hat Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e06 20 Jan 2006 Fixed Description Sybase Central 12.6 ESD 5 could not connect to a 12.5 multiplex write server, and returned the error, "Sybase Central cannot connect to a database on a server that is older than version 7.0.0".

CR:418991

CR Number:   418991 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows 2000 Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 e07 26 Jul 2006 Fixed 12.7 07 Apr 2006 Not a Bug Description New ASA .NET data provider added by ESD#5 is not registered into Assembly Cache of NET Framework 1.1. Workaround Description  Please re-register ianywhere.data.asaclient.dll and policy.9.0.ianywhere.data.asaclient.dll into Assembly Cache using .NET Freamwork 1.1 Configuration Tool. After deleting build 9.0.1.1530, the correct file is added to Assembly Cache.

CR:419064

CR Number:   419064 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2006 Not a Bug Description SELECT stmt with NTILE() returns Feature 'olap extension' not implemented.

CR:419325

CR Number:   419325 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2006 Fixed Description Using 12.6 ESD 5, after starting and stopping an IQ single node database created with a pre-IQ 12.6 version, the next attempt to start the database might fail with a "Bad Block number" error reported in the iqmsg file. This issue only affected IQ single node database created prior to version 12.6 which have the first IQ main dbspace on a RAW partition. Multiplex databases were not affected.

CR:419487

CR Number:   419487 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e02 12 Dec 2006 Fixed Description The parser incorrectly returns an error when trying to determine if CASE expressions in the ORDER BY clause and the SELECT list match when there is an IN condition. Workaround Description  1- Use column number in ORDER BY select case when name in ('syscolumns') then name else 'OTHERS' end from sysobjects group by case when name in ('syscolumns') then name else 'OTHERS' end order by 1 2- Use columns alias in ORDER BY select case when name in ('syscolumns') then name else 'OTHERS' end as test from sysobjects group by test order by test

CR:419556

CR Number:   419556 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 13 Feb 2006 Fixed 12.6 e09 04 Jan 2007 Fixed Description Under certain circumstances, a non-fatal internal error was reported during a large delete.

CR:419567

CR Number:   419567 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Feb 2006 Not a Bug Description Problem promoting query server to write server when 2+ query servers exist

CR:419581

CR Number:   419581 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 27 Apr 2006 Fixed Description The request is for INSERT LOCATION to support Quoted Identifier Object names when inserting from an IQ server.

CR:419678

CR Number:   419678 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 17 Mar 2006 Fixed Description Provide an option to capture partial loads and allow for rollback.

CR:419867

CR Number:   419867 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows XP Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 24 Feb 2006 Fixed Description ASA:INSERT... WITH AUTO NAME should return error message "function not implemented" instead of a non-fatal stack trace.

CR:419908

CR Number:   419908 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 26 Mar 2006 Fixed Description Add SQL command line length to SQL Reference Manual Chapter 8, "Physical Limitations."

CR:419910

CR Number:   419910 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2007 Presently Not Targeted For Any Future Release Of This Product Description Request to support ASE sp_showplan procedure in Sybase IQ.

CR:419912

CR Number:   419912 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 27 Mar 2006 Fixed Description Update documentation to recommend editing configuration file when migrating large servers.

CR:419913

CR Number:   419913 Product Name:   IQ Product Component:   Sybase Central Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 08 Mar 2006 Fixed Description Add option for query server to automatically use the parameters in the cfg file of a write server instead of the default parameters.

CR:419939

CR Number:   419939 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.8 02 Feb 2007 Fixed 12.7 e05 21 Apr 2008 Fixed 12.7 e04.x 05 Jun 2008 Fixed Description Reduce startup costs for queries when opening tables.

CR:419994

CR Number:   419994 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e06 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 27 Apr 2006 Fixed Description startup switch -sb lead to error:DBSPAWN ERROR: -81 Invalid database server command line Workaround Description  Remove -sb parameter manually of the param.cfg

CR:419997

CR Number:   419997 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Correct sqlstate and sqlerrorcode are not returned in case of a warning.

CR:420002

CR Number:   420002 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e06 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 e01 01 Aug 2006 Fixed 12.6 e07 01 Aug 2006 Fixed Description Auditing caused dbtran to report bad transaction log data for IQ databases. Target Version  12.6 e07

CR:420033

CR Number:   420033 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   12.6 e04 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.7 16 Mar 2006 Fixed Description Load fails giving unique constraint violation after IQ server fails when using IDENTITY. Workaround Description  call sp_iq_reset_identity

CR:420097

CR Number:   420097 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Mar 2013 Insufficient priority to fix Description Request a date/time stamp to determine when indexes are created.

CR:420131

CR Number:   420131 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.8 26 Mar 2007 Presently Not Targeted For Any Future Release Of This Product Description Provide utility to convert IQ database from one char set to another something similar to ASE's sqlloc

CR:420264

CR Number:   420264 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e05 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request to enhance IQ front-end query tools to support LDAP authentication.

CR:420306

CR Number:   420306 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   12.6 e06 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Error Message Severity Levels in iqmsg