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

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

CR:731615

CR Number:   731615 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 08 Feb 2013 Fixed 20 Mar 2013 Fixed Description Load table statement was failing when date clause is mentioned for columns with data type, other that date/date-time/time. This fix resolves this issue.

CR:731738

CR Number:   731738 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 11 Feb 2013 Fixed Description In the Node Monitor, the Temp Cache statistics were showing the Main Cache statistics.

CR:731757

CR Number:   731757 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 May 2013 Fixed Description When running on Solaris systems, if the server had accepted a new connection, but the client side closed its socket right away, the TCP listener would have been stopped and the message "TCP Listener shutting down (130)" would have been displayed on the server console. This has been fixed.

CR:731807

CR Number:   731807 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2013 Fixed Description SET USER violation might happen on a secondary node in an IQ Multiplex environment when any of the following DDL statements are synchronized on secondary nodes. This results in an emergency shutdown of secondary node. 1. GRANT/REVOKE AUTHORITY 2. GRANT/REVOKE GROUP MEMBERSHIP 3. GRANT CONNECT

CR:731812

CR Number:   731812 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Solaris Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description We need an environment variable similar to $SATMP_UMASK to restrict IQ/SA temp files permissions generated in $IQTMP15

CR:731961

CR Number:   731961 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 12 Feb 2013 Fixed Description Columns were failing to create if the user did not have create permission on the selected DBSpace. The user is now warned up front of this issue.

CR:731973

CR Number:   731973 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 12 Feb 2013 Fixed 3.2.7 04 Mar 2013 Added to user documentation Description Creating External Procedure was not allowed for DBA user in 15.4.

CR:732033

CR Number:   732033 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02 09 May 2013 Fixed Description Customer repeatedly creating and dropping table might experience slowness due to a case-sensitivity bug. The issue resulted in slower scan times against the system catalog tables. This has been fixed.

CR:732069

CR Number:   732069 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   RH Linux Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 20 Feb 2013 Fixed Description In the node monitor, the cache hits and reads were consistently showing as 0.

CR:732141

CR Number:   732141 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Solaris Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 18 Feb 2013 Fixed Description Registering a multiplex would succeed, but there were invalid errors in the log.

CR:732176

CR Number:   732176 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Apr 2013 Added to user documentation Description All the options for a database default value has been changed, not been described in the manual or EBF Cover Letter.

CR:732201

CR Number:   732201 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 sp01 27 Feb 2013 Fixed Description When data is loaded with _forceMergeOption 'on', tiers at each level are merged together to process DBM. In case of delete physical delete is performed if _forceMergeOption is 'on'.

CR:732267

CR Number:   732267 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 15 Feb 2013 Fixed Description When adding a primary key to a table, the DDL was not reflecting the change until the resource was re-authenticated.

CR:732480

CR Number:   732480 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 19 Feb 2013 Fixed Description In the Materialized View Properties Sheet, the Refresh button was disabled for a user with privilege to refresh.

CR:732481

CR Number:   732481 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 sp01 20 Feb 2013 Fixed Description When loading into an RLV enabled table the SKIP option does not have any effect if as Sybase IQ is single-threaded (max_query_parallelism=1).

CR:732566

CR Number:   732566 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description compounded statement with a GROUP BY and HAVING within a SET statement fails with Could not execute statement. Function or column reference to 'ACCR_NON_INT' must also appear in a GROUP BY SQLCODE=-149, ODBC 3 State="42000" Line 1, column 1 This worked fine in IQ 12.7. If you remove the SET statement it works fine.

CR:732624

CR Number:   732624 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 20 Feb 2013 Fixed Description When adding a column and selecting 'global autoincrement', an invalid SQL error was returned.

CR:732635

CR Number:   732635 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 14 Mar 2013 Fixed 15.4 future 17 Mar 2013 Fixed Description Updating a column with CMP index might lead to an inconsistent index. This fix resolves the issue. Target Version  16.0 sp01

CR:732706

CR Number:   732706 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 26 May 2013 Fixed 16.0 sp02 13 Jun 2013 Fixed Description Some scalar subqueries which have an aggregate expression wrapped in a case expression in the subquery select list may result in wrong results being returned. Workaround Description  set temporary option Subquery_Flattening_Preference = '-2'

CR:732757

CR Number:   732757 Product Name:   IQ Product Component:   Utility Status:   Closed OS:   Windows 7 Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2013 Fixed Description OUTPUT statement of DBISQL cannot output to MS-ACCESS via ODBC. CHAR-type column can not be output to MS-Access.

CR:732805

CR Number:   732805 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 7 Original Version:   future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description what version of IQ will be certified with Windows 8 and in what timeframe

CR:732866

CR Number:   732866 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 25 Mar 2013 Duplicate Description In certain load scenarios involving Foreign key constraints, data inconsistency may be observed by running database consistency check. This has been fixed.

CR:732940

CR Number:   732940 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) 29 Oct 2013 Duplicate Description crash at s_blockmap.cxx:3052 at s_blockmap23RegisterPhysicalBlockId . This is CR 657690 fixed in IQ 15.4. This is to request a back port of the fix in CR 657690 into IQ 15.2

CR:732952

CR Number:   732952 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 20 Mar 2013 Fixed Description Under rare circumstances a deadlock could occur between two threads where one thread is in the process of committing an update to an RLV table and a second thread is in the process of updating the same RLV table. During the commit, the logging system for the RLV table runs out of buffers/pages. Its attempt to increase the space is blocked by a lock that the second thread already owns. This has been resolved.

CR:732956

CR Number:   732956 Product Name:   IQ Product Component:   Install Status:   Open OS:   Windows Vista Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Product: IQ Network Client 15.4 32-bit installer OS: Windows Vista 32-bit Installer does not create the Sybase group icons on Start menu for Windows Vista 32-bits. Works fine in Windows XP. The icons below should be created: Interactive SQL - C:\sybase1\IQ-15_4\Bin32\dbisql.exe ODBC Administrator 32-bit - C:\WINDOWS\system32\odbcad32.exe Sybase Central v6.1 - Target: "C:\sybase1\Shared\Sybase Central 6.1.0\win32\scjview.exe" Sybase on the Web - C:\sybase1\IQ-15_4\support\IQweb.htm

CR:733034

CR Number:   733034 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2013 Fixed 16.0 sp01 04 Apr 2013 Added to user documentation 12 Apr 2013 Fixed Description a) A non-DBA user with execute privilege on sp_iqmpxdumptlvlog cannot execute the procedure in the SYSTEM PROC AS DEFINER ON model. (The fix will be applicable for databases upgraded to IQ 16.0 sp01 onwards) b) The stored procedure sp_proc_priv returns incorrect information for system procedures sa_procedure_profile and sa_procedure_profile_summary

CR:733046

CR Number:   733046 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 07 Mar 2013 Fixed Description During a hash-partitioned load certain combinations of table schema could cause crashes during a load.

CR:733063

CR Number:   733063 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 03 Mar 2013 Fixed Description Multiple inserts and deletes into tiered HG index may lead to load failure in some scenarios. This has been fixed. In such a case DBCC on the index would report an error on the THG index before the failing load.

CR:733178

CR Number:   733178 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   RH Linux Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 04 Mar 2013 Fixed Description When viewing Multiplex Properties, menus were not enabled/disabled appropriate on entry.

CR:733208

CR Number:   733208 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) 15.4 e03.x 29 Apr 2013 Fixed 16.0 sp02 04 Jun 2013 Fixed Description Load table statement when executed with multibyte row delimiter failed in specific cases due to error in scanning logic. Workaround Description  - Workaround under test Convert two byte row delimiter to single byte delimiter

CR:733279

CR Number:   733279 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 07 Mar 2013 Fixed Description If the current load is such that it makes tier 0 go above threshold (by key logic), then send key threshold= 1 regardless of its actual calculated value. This will ensure that full merge occurs before pushing tier 0 to tier 1 incremental.

CR:733376

CR Number:   733376 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 11 Mar 2013 Fixed 16.0 sp01 24 Apr 2013 Added to user documentation Description A new database option CREATE_HG_AND_FORCE_PHYSICAL_DELETE is added in THG. By default the option will do physical delete in all tiers.PreELAN database needs to do alter database upgrade to see the effect of this option. By default the option will be on and HG index will follow physical delete.

CR:733412

CR Number:   733412 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 07 Mar 2013 Fixed Description Updated delete method for THG to print delete messages if HG_DELETE_MESSAGES is set.

CR:733441

CR Number:   733441 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 23 May 2013 Fixed 16.0 sp02 18 Sep 2013 Fixed Description Query using Nested Loop pushdown join algorithm having CASE expression in join condition might abort with an Internal Error at dfo_Join.cxx: 452 in IQ 15.4. Workaround Description  set temporary option join_preference = '-3'

CR:733449

CR Number:   733449 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 sp01 05 Mar 2013 Fixed Description Doing an insert into with a remote location of partitioned data into an RLV enabled table does not work.

CR:733451

CR Number:   733451 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 beta2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 12 Mar 2013 Fixed Description If a multi-column UNIQUE index (including a multi-column primary key) exists on an RLV-enabled table, and the column order in the index definition differs from the column order in the table definition, the server would fails on inserts, updates and loads of that table. This has been fixed.

CR:733973

CR Number:   733973 Product Name:   IQ Product Component:   Install Status:   Closed OS:   Windows 2008 Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 12 Apr 2013 Workaround Description Running the uninstaller in silent mode will leave more files and directories behind than the graphical uninstaller. Workaround: add flag -DUNINSTALL_DELETE_USER_FILES=true when running uninstaller in silent mode.

CR:734034

CR Number:   734034 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Mar 2013 Fixed 16.0 sp01 18 Mar 2013 Fixed 28 Mar 2013 Fixed 29 Mar 2013 Fixed Description While performing fixed ASCII extract of a column with numeric datatype with precision == scale IQ server would crash as the MaxDataLength/field_size computation for the extracted string was incorrect. Workaround Description  The option temp_extract_column_delimiter must not be set to the empty string. But then, you loose the feature to extract data in fixed-width ASCII with no column delimiter.

CR:734153

CR Number:   734153 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 27 May 2013 Fixed Description Under some circumstances a query that uses ISNULL in a where clause may return an incorrect number of rows compared to that returned with the same test when run in an IQ 15.2 or earlier server. Workaround Description  set temporary option core_Options13=33554432

CR:734291

CR Number:   734291 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 14 Mar 2013 Fixed Description During a hash-partitioned load certain combinations of table schema could cause crashes during a load.

CR:734317

CR Number:   734317 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 27 Mar 2013 Fixed Description Certain types of errors during insertion of data into an IQ table may not be relayed back to the client. The data will not be inserted in these cases and the only indication will be from looking at the iqmsg file.

CR:734336

CR Number:   734336 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 16 Apr 2013 Fixed 15.4 e03.x 29 Apr 2013 Fixed Description Text index LOAD may report a non-fatal IQ error in s_bt.cxx. Target Version  15.4 e03.x

CR:734699

CR Number:   734699 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Apr 2013 Duplicate Description A SELECT statement with a GROUP BY might raise an error (Non-aggregate select/having expr appear in the group by) when a select item is an integer column computed with a value of more than 18 digits (for example, select (sales + 2000000000000000000) from sale group by (sales + 2000000000000000000) Workaround Description  -- Workaround: multiply the 19 digits number by 1, and it works select (sales + 2000000000000000000 * 1 ) from sale group by (sales + 2000000000000000000 * 1 )

CR:734717

CR Number:   734717 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 21 Mar 2013 Fixed Description When membership in a group in a 15.4 database was granted via a mechanism outside SCC, it was not revoked correctly in SCC.

CR:734822

CR Number:   734822 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Suse Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 28 Mar 2013 Fixed Description In case of 'alter table add FK' the RO version of candidate key table was opened at very late, this RO version was picking latest schema changes and in case of rollback it remains there in catalog. Fixed this to open RO version of CK table at start.

CR:734849

CR Number:   734849 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   RH Linux Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 20 Mar 2013 Fixed Description In the Create Group Wizard, a newly created Login Policy was not displayed correctly.

CR:734855

CR Number:   734855 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 sp01 29 Mar 2013 Fixed 16 May 2013 Workaround Description The IQ server could fail during rollback after an out-of-space error. This issue has been resolved now. Target Version  16.0 sp01

CR:734961

CR Number:   734961 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 19 Mar 2013 Fixed Description In a 15.4 resource, the user was prevented from adding partitions to an already partitioned table.

CR:735135

CR Number:   735135 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Open OS:   Windows 7 Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.2.7 ESD1 21 Mar 2013 Fixed 3.2.7 20 Mar 2013 Added to user documentation Description On Windows 7 Multiplex creation via SCC was failing to create the local temp db.

CR:735185

CR Number:   735185 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 29 Mar 2013 Fixed Description Bug exists because of inconsistent handling of multi-column key in HG code. This fix resolves the issue.

CR:735264

CR Number:   735264 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2008 Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 29 May 2013 Fixed Description Help about the OK button appeared off the screen. This is fixed

CR:735379

CR Number:   735379 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 24 Apr 2013 Fixed Description No error was reported when trying to register a Simplex as a Multiplex.

CR:735385

CR Number:   735385 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2013 Fixed 16.0 sp01 09 Apr 2013 Fixed 15.4 e04 12 Apr 2013 Fixed Description A query with a group by expression that contained a very large constant value would not use the expected partitioned grouping algorithms on big endian architectures.

CR:735441

CR Number:   735441 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Suse Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 10 Apr 2013 Fixed Description Some range queries when executed on tiered HG index may fail. This has been fixed.

CR:735445

CR Number:   735445 Product Name:   IQ Product Component:   Sybase Central Status:   Open OS:   Windows 7 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Sybase Central for ASA 12.0.1 and SC for IQ 15.4 client install can not co-exist on the same Windows 7 box. Both can be installed OK and started indiidually OK. However if you try start them both the only the first one starts up. The second SC just does not start , no error. If you try to add the plugin so one of the SC so that you can access both from the same SC the dbisql from within SC fails to connect throwing this error "jodbc.jar build does not match the shared object build" This only appears to be an issue with Windows 7 , other windows platforms like 2003 don't have the issue.

CR:735471

CR Number:   735471 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 sp01 21 Mar 2013 Fixed 15.4 e03.x 29 Mar 2013 Fixed 15.4 e01.x 08 May 2013 One-off Provided Description This CR fixes a memory overwrite problem that may expose itself in various ways. One is a server failure at s_dpthreestore.cxx line 924.

CR:735485

CR Number:   735485 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 03 May 2013 Fixed 3.2.7 ESD1 18 Apr 2013 Added to user documentation Description Fixed issue where the truncate and refresh options were not working properly for text indexes.

CR:735487

CR Number:   735487 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) 16.0 sp02 19 Apr 2013 Fixed 16.0 sp02 04 Jun 2013 Fixed Description An update statement to update an IQ table fails (SQL Anywhere Error -728: Update operation attempted on non-updatable remote query) when the statement includes the IsNumeric function.

CR:735604

CR Number:   735604 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp09 22 Sep 2014 Fixed 23 Sep 2014 Fixed 16.0 sp08 18 Dec 2014 Fixed 16.0 sp09.x 24 Nov 2014 Fixed 15.4 e04.x 19 Sep 2014 Fixed 16.0 sp08 22 Sep 2014 Fixed 16.0 sp04 20 Nov 2014 Fixed 15.4 e05 23 Sep 2014 Fixed Description A complex query involving parallel ordered projection from HG index with large amount of data causes a sporadic failure. Target Version  15.4 e04.x

CR:735653

CR Number:   735653 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 sp02 06 May 2013 Fixed 16.0 sp02 04 Jun 2013 Added to user documentation 15.4 e04 29 Oct 2013 Fixed Description Support LOAD TABLE from compressed files with .gz or .gzip file extensions.

CR:735762

CR Number:   735762 Product Name:   IQ Management Product Component:   Web UI - Other Status:   Closed OS:   Generic Original Version:   3.2.7 ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 25 Apr 2013 Fixed Description Resolved issue where a blank password called LDAP validation to fail.

CR:735797

CR Number:   735797 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Unknown Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 08 Apr 2013 Fixed Description When we write into garray either we write it from scratch or we open the garray in append mode. This issue has appeared after enabling physical delete for THG. Lets consider a case in which we open the garray in append mode after physical delete. We set the unit list header at the end of execution. This header was set incorrectly. The fix involve setting the header correctly.

CR:736116

CR Number:   736116 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 TF 7 04 Apr 2013 Fixed Description When using a UTF8 Collation on a database and inserting into an RLV enabled table with a primary or unique key, in some cases the insert will not fail when there is a unique violation.

CR:736340

CR Number:   736340 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 CORE_Options1=10663296, and when the table has over 2 million rows, CREATE WD INDEX on a char (255) could cause IQ to execute the command for over 8 hours and eventually crash. Workaround Description  Unset CORE_Options1

CR:736366

CR Number:   736366 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 10 Apr 2013 Fixed Description THG index was merged inconsistently during a DML in few scenarios. This is now fixed.

CR:736445

CR Number:   736445 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 10 Apr 2013 Fixed Description dbcc was failing for DBCC Hash range or Hash partition table after initial load. This fix resolves this issue.

CR:736485

CR Number:   736485 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   HP-UX Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 26 Jun 2013 Fixed Description Previously, if a single user on a computer ran a number of copies of DBISQL, it was possible for the DBISQL options to be reset to their defaults. For this to happen, one DBISQL process would have to be starting when another DBISQL process was shutting down. Workaround Description  Not Yet.

CR:736523

CR Number:   736523 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 09 Apr 2013 Added to user documentation Description MERGE statement is not implemented in IQ. All references to this statement have been removed from the manuals.

CR:736551

CR Number:   736551 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 TF 0 25 Apr 2013 Fixed Description For some collations, duplicate values were being allowed in a primary key column for RLV enabled tables.

CR:736565

CR Number:   736565 Product Name:   IQ Management Product Component:   Web UI - Node Monitor - Overview Screen Status:   Closed OS:   Windows 7 Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 06 May 2013 Fixed Description Resolved issue when using SCC with Portugues (Brazil). The information in the monitor will now display correctly.

CR:736919

CR Number:   736919 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Original Version:   15.4 e02.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03.x 11 Jun 2013 Fixed 15.4 e04 11 Feb 2014 Fixed 16.0 sp08 19 Mar 2014 Fixed Description A query with a column having UNIQUE index and duplicate values, may return the wrong result when a hash join plan is chosen.

CR:736932

CR Number:   736932 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 18 Apr 2013 Fixed Description Prior to IQ 16.0 sp02 it was possible to create a table with a table check constraint that included variables or columns that were not part of the table. A SQL error would be generated upon insertion into the table as this is not supported by IQ. As of IQ 16.0 sp02 a syntax will be generated at table creation time.

CR:736983

CR Number:   736983 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 07 May 2013 Added to user documentation Description Scope of MAX_IQ_THREADS_PER_CONNECTION and MAX_IQ_THREADS_PER_TEAM ware incorrect. These options can be set for all users.

CR:737049

CR Number:   737049 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 16 May 2013 Fixed Description Two transactions attempting to lock the same RLV row could result in server failure. This is a very rare scenario and has been fixed.

CR:737160

CR Number:   737160 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 11 Jul 2013 Fixed 16.0 sp02 01 Aug 2013 Fixed Description Error "trying to use Direct IO on unsupported system" may occur on a supported system even when IQ_USE_DIRECTIO = 1 was set to enable Direct IO. Target Version  16.0 sp02

CR:737272

CR Number:   737272 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 13 May 2013 Fixed 16.0 sp02 13 May 2013 Fixed 15.4 e03.x 02 Jul 2013 Fixed Description In certain cases migration to 15.4 using iqunload -au fails with "Reload of SYSIQINFO failed." error.

CR:737305

CR Number:   737305 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 23 Apr 2013 Fixed Description A null pointer exception was received when restarting SCC. This prevented correct registration of the managed resources and failure to create a database.

CR:737347

CR Number:   737347 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp01 24 Apr 2013 Fixed 16.0 sp02 10 May 2013 Fixed Description In some scenarios, DMLs may lead to Tiered HG being shown as inconsistent in sp_iqcheckdb ouput. The order-by, join (sort-merge) based queries using HG may also give incorrect results.

CR:737363

CR Number:   737363 Product Name:   IQ Product Component:   SA Component Status:   Closed OS:   Solaris Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2013 Fixed Description When running on Solaris systems, if the server had accepted a new connection, but the client side closed its socket right away, the TCP listener would have been stopped and the message "TCP Listener shutting down (130)" was be displayed on the server console. Now fixed as of IQ 15.4 ESD3 - request backport to IQ 15.2

CR:737392

CR Number:   737392 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Apr 2013 Fixed 07 May 2013 Fixed Description As the IQ buffer cache sizes grow, the cost of Rollback and RollbackToSP increases, even if the volume of data to be rolled back is small. This has been fixed.

CR:737551

CR Number:   737551 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   12.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Connection Profile of Sybase Central is transferred to the other columns the Host/Port information. As a result, 'View Data in Interactive SQL' function does not work correctly. Workaround Description  Please use "Connection with connection string' Action in Connection Dialog.

CR:737646

CR Number:   737646 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 05 May 2013 Fixed 05 May 2013 Fixed Description Calling sp_iqrebuildindex on an unupgraded FP index having an unupgraded HG index on the same column leads to a server failure with error message pointing to slib/s_ohcidx.cxx:814.

CR:737716

CR Number:   737716 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 25 Apr 2013 Fixed Description When creating a database, there was a misleading error in the log even though the database was successfully created. This error has been removed.

CR:737773

CR Number:   737773 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.2 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Select SQL statement that uses a MAX function and a where clause that does a > or a < comparison against a DATEADD function that contains a date cloumn name as the date-expression causes the IQ server to crash st_server.cxx:1485 on call s_fetchGroup::Fetch but ONLY if the column has a LF index defined. Workaround Description  either re structure query or remove LF index

CR:738029

CR Number:   738029 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 02 Aug 2013 Fixed Description The SQL command "ALTER DBSPACE ALTER FILE" could be used to rename a valid dbspace file to point to a filesystem directory. This would lead to failures in starting the database. The command now properly checks to ensure that a path rename does not point to a directory. Workaround Description  Workaround -- create <DB_DIR_NEW> copy <DB_DIR> contents to <DB_DIR_NEW> copy <DB_DIR> to another directory <<DB_DIR_OLD> as backup remove directory <DB_DIR> effectively removing reason on which IQ was blocked on. --

CR:738123

CR Number:   738123 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 30 Apr 2013 Fixed Description Fixed a performance issue when listing views.

CR:738240

CR Number:   738240 Product Name:   IQ Product Component:   Install Status:   Open OS:   AIX Original Version:   15.4 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ 15.4 ESD 3 AIX PowerPC 64-bits IQ installer with GUI or with silent mode ends quickly with "Installation complete" but only a few directories are created and no files (exe or lib) are installed.

CR:738244

CR Number:   738244 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 08 May 2013 Fixed Description Improved the performance for listing IQ Servers and Multiplex Servers.

CR:738374

CR Number:   738374 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 08 May 2013 Fixed 16.0 sp01.x 23 Jul 2013 Fixed Description The IQ process size grows without limit due to LMA allocation. The problem appears to be that there are callers of the LMA that call it for small allocations. Several issues related to this have been fixed is SP02. The LMA allocation now takes the memory alignment into the bookkeeping. Target Version  16.0 sp02

CR:738392

CR Number:   738392 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 17 May 2013 Fixed 03 May 2013 Fixed 16.0 sp01.x 26 Jul 2013 Fixed Description Executing a series of select into operations may eventually result in an error that reports that All IQ large memory has been used [-1013130].

CR:738423

CR Number:   738423 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 08 May 2013 Fixed 16.0 sp01.x 29 Aug 2013 Fixed Description Load may fail doing Tiered HG proportional merge in certain cases.

CR:738672

CR Number:   738672 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e03 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description load engine can take a lot of time to report load finished after physical load is complete

CR:738873

CR Number:   738873 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   16.0 sp02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 09 May 2013 Fixed Description Creating an RLV dbspace was contributing to the overall main dbspace count.

CR:738890

CR Number:   738890 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   7.07 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Using java.sql.Statement.setFetchSize(int) with Sybase IQ and the jConnect for JDBC driver results in an empty ResultSet being returned. Eliminating the setFetchSize statement or using the sajdbc4.jar file from the SQL Anywhere bundle resolves the error.

CR:738988

CR Number:   738988 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 31 May 2013 Fixed 16.0 sp02 31 May 2013 Fixed 23 Jun 2013 Fixed Description Predicates are not pushed down into union all view when there are multiple predicates resulting in poor performance.

CR:739146

CR Number:   739146 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 sp01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 09 May 2013 Fixed Description Update on range partitioned table with over 67108864 rows on one partition may result in an inconsistent index. Target Version  16.0 sp02

CR:739274

CR Number:   739274 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Windows 2003 Original Version:   16.0 sp02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp08 25 Mar 2014 Added to user documentation Description When connected to an IQ database, or if your DBISQL is configured to use only IQ, the following "Help" menu items have been disabled: Interactive SQL Help SQL Syntax Keyboard Shortcuts also, on the "Connect" window, the "Help" button has been disabled if you have selected the "SAP Sybase IQ" database type.

CR:739302

CR Number:   739302 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03.x 05 Nov 2013 One-off Provided 23 Jun 2013 Fixed 16.0 sp02 13 Jun 2013 Fixed 16.0 sp02 24 Jul 2013 Fixed 15.4 e03.x 08 Nov 2013 Fixed Description IQ crash with signal4 due to a query which involved a distinct operation(with grouping over rowid's) over a from list containing derived tables.

CR:739459

CR Number:   739459 Product Name:   IQ Management Product Component:   Web UI - Administration Status:   Closed OS:   Generic Original Version:   3.2.7 ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 3.3 15 May 2013 Fixed 3.2.7 ESD1 28 Jun 2013 Fixed Description If CESU8BIN was selected as collation to create the database, the resource could not be registered properly. This is now resolved.

CR:739583

CR Number:   739583 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 sp02 25 Jun 2013 Fixed 16.0 sp02 08 Jul 2013 Fixed 16.0 sp02 19 Jul 2013 Fixed Description A query containing LIMIT to restrict the number of rows returned performs very poorly when run against a large IQ table.