远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:690097
CR Number:   690097
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 06 Dec 2011 Fixed
Description
Support for binary and varbinary datatypes in Java UDF resultsets and

proxy tables was missing for sizes > 255 bytes. It has now been added.
Target Version
 15.4 e01



CR:690218
CR Number:   690218
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a partitioned table resides on online and offline dbspaces, data of the table can not be accessed, if any data/index/partition of the table resides on the OFFLINE dbspace.

Also, sp_iqcheckdb doesn't check partitioned table with OFFLINE dbspaces.

To create indexes on a partitioned table, all dbspaces have to be online.



CR:690233
CR Number:   690233
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Unable to effectively use TDS client packet sizes greater than 4096(max actually accepted by IQ is 7300).

So for example is you tried connecting with isql -Udba -Psql -Smyserver -A8192

the select connection_property ('PacketSize') will shows 7300. If you then try send a client packet that is 8192 in size this causes

CT-LIBRARY error:

ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
Workaround Description
 do not exceed max TDS packet size of 4096



CR:690299
CR Number:   690299
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2013 Fixed
Description
On a machine under heavy load, a TCP connection attempt could fail with an incorrect error code. On certain operating systems, the connection attempt could hang. This has been fixed.



CR:690354
CR Number:   690354
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
iqunload may fail with "Feature, aggregate 'list' at line 0, is not supported."



CR:690410
CR Number:   690410
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2 e02.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02.x 29 Dec 2011 Fixed
Description
Writer nodes request coordinator for storage on demand basis. Coordinator maintains certain persistent and recoverable book-keeping structures to track writer allocations. After a successful allocation, these structures are passed to writer nodes so that they can update their local storage structures. If a checkpoint occurs after coordinator creates allocation structures but before it commits them, coordinator allocation transaction loses ownership of the newly created structures to checkpoint. During commit, coordinator transaction creates its own copy from checkpoint owned allocation structures. However, writer node still receives checkpoint owned copy for local update. In a rare scenario, if another checkpoint happens before writer can update the local storage, checkpoint owned copy gets destroyed. Any further update by writer using destroyed copy can result in database crash.



CR:690664
CR Number:   690664
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.3 e00.x 20 Jun 2012 Fixed
15.4 e02 15 Jun 2012 Fixed
15.4 e01.x 23 Oct 2012 Fixed
15.4 e01.x 23 Oct 2012 Fixed
Description
The IQ server crashes if query has HASH JOIN and due to incorrect estimates

the runtime rehashing is required.



CR:690706
CR Number:   690706
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2008
Original Version:   15.2 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for IQ to use timezone different from local Windows machine timezone, so that getdate() return date/time is base on IQ specified timezone instead of Windows machine timezone.



CR:690939
CR Number:   690939
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2012 Fixed
Description
Improved Load performance of tables having text indexes.



CR:691158
CR Number:   691158
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2011 Fixed
28 Jun 2012 Fixed
Description
Attempting to make a Kerberos connection with a large Kerberos ticket could incorrectly fail with the error "Kerberos login failed". This could occur with Keberos ticket size approaching 8K, which was possible if the ticket was part of a large number of Active Directory groups.



CR:691164
CR Number:   691164
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Windows XP
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 28 Mar 2012 Fixed
Description
IQ 15.3 windows network client installer only installs dboledba11.dll, dboledb11.dll is missing. The server installer has it.



also problem with IQ 15.4 installer where dboledb12.dll is missing.
Workaround Description
 use file from server install.



CR:691275
CR Number:   691275
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 18 Dec 2013 Fixed
16.0 sp08 10 Jan 2014 Added to user documentation
Description
need a switch implemented that disallows checkout of any optional graced license if someone inadvertently tries to use an unlicensed feature



CR:691465
CR Number:   691465
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2011 Fixed
Description
When using the fetch_block() UDF api to retrieve rows from an input table 1 row will be lost for every subsequent block fetch. This is now fixed.
Target Version
 15.4 e01



CR:691527
CR Number:   691527
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e03.x 04 Jan 2012 Fixed
Description
Server failure may occur in st_txncb.cxx when a sql batch is interrupted

by a DROP CONNECTION command.



CR:691609
CR Number:   691609
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows 2008
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2012 One-off Provided
15.4 e01 28 Nov 2011 Fixed
16.0 30 Nov 2011 Fixed
Description
The JDBC driver sajdbc4.jar might not be installed on Windows.



CR:691733
CR Number:   691733
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 22 Feb 2012 Fixed
Description
Recommendations in "MAIN_RESERVED_DBSPACE_MB Option" in Reference: Statements and Options and "Sizing guidelines for main and temporary stores" in System Administration Guide: Volume 1 seem contradictory, but sizing for MAIN_RESERVED_DBSPACE_MB depends on many factors, such as IQ page size and the number of concurrent connections. Set MAIN_RESERVED_DBSPACE_MB to at least 20 percent of the IQ_SYSTEM_MAIN size.



CR:691756
CR Number:   691756
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.3 e00.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2012 Fixed
18 Apr 2012 Fixed
18 Apr 2012 Fixed
Description
The failure was caused due to access of invalid memory in queries with hash join. The issue is specific to Linux Power Series. This has been fixed.
Workaround Description
 Today dec th 20th while SPS was implementing migrating customer to another platform,

could find that if the procedure syntax is switched from T-SQL to ANSI, the problem

is avoided on Linux PPC.



However for AIX , IQ do not crash even with T-sql syntax, however result set seem to be wrong.



Quick WA from SPS , was suggest customer to switch from T-sql procs to ANSI on linux ppc.

However this could not apply for system sp's, these were avoided increasing catalog store memory.



CR:691839
CR Number:   691839
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 future 05 Feb 2012 Fixed
16.0 26 Dec 2011 Fixed
Description
A derived table that contains UNION ALL and SCALAR correlated subqueries with

conjunctive condition causes the query fail with a non-fatal stack trace at

opt_TableNode.cxx.
Workaround Description
 The workaround for this issue is as below,

set temporary option Subquery_Flattening_Preference = '-2';



This option disables the scalar subquery flattening.



CR:691845
CR Number:   691845
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 31 Jan 2012 Added to user documentation
Description
The documentation for the sp_iqspaceused stored procedure had inaccurate descriptions for the tempKBUsed and shTempTotalKBUsed columns. tempKBUsed is the number of kilobytes of total IQ temporary store space in use by the database. shTempTotalKBUsed is the number of kilobytes of total IQ global shared temporary store space in use by the database. (Secondary multiplex nodes return '(Null)'.)



CR:692222
CR Number:   692222
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 04 Jan 2012 Fixed
16.0 19 Jan 2012 Fixed
Description
If an attempt to insert a value requiring implicit conversion

into a column that results in a conversion error, previously

inserted, uncommitted values are rolled back.



CR:692449
CR Number:   692449
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
a DQP query under certain circumstances can be slower than the same query run non-dqp
Workaround Description
 set temporary option DML_Options75=181891; -- Explicit group by estimate to force a parallel hash group by



CR:692460
CR Number:   692460
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)
16.0 sp08 05 Dec 2013 Already Fixed by Another CR
Description
Executing a SELECT * from a procedure that includes an INSERT fails with a non fatal error at df_Heap.cxx:2613 when one of the parameters passed in exceeds the defined parameter length. Subsequent queries from the same client fail with "CURSOR ALREADY OPEN" errors.
Workaround Description
 To work around the problem the ct should either only used data of the correct length , or change the table and procedure definitions to increase the length of column / parameter causing the issue.



CR:692519
CR Number:   692519
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   AIX
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 12 Dec 2011 Fixed
Description
If an application connected via jConnect or Open Client to a blank padded UTF8 database and fetched a non-nullable char(n) value, then the client may experience protocol errors if n is less than 3. This has been fixed.
Workaround Description
 a. use convert() to explicitly convert char strings to varchar.

This is not acceptable to cust. since this means lot of modifications in the scripts



CR:692528
CR Number:   692528
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Windows 2008
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request monthname(getdate()), datename(mm,getdate()) to return localized Japanese month names when LANG is set to Japanese. Also request to support additional languages.



CR:692572
CR Number:   692572
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.4 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New feature request to allow a way for temp objects to only exist in cache, never to be written to disk unless temp cache gets full.



CR:692575
CR Number:   692575
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.4 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
allow mpx dqp queries to work across locations (if Frankfurt needs London data it will split off part of the query and send it to the London server to get that data for example)



CR:692599
CR Number:   692599
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2012 Fixed
11 Jan 2012 Fixed
Description
If the server is started with a TLS/HTTPS identity file that requires a password but none is supplied, an unhelpful error message is given ("Error parsing certificate file, error code 20763").

This has been fixed; the error message is now "An identity password must be specified".



CR:692694
CR Number:   692694
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 e01 14 Dec 2011 Added to user documentation
Description
The 15.4 documentation describing the permissions required for these permissions is incorrect:

DEFAULT_PROXY_TABLE_ROW_COUNT Option

DEFAULT_TABLE_UDF_ROW_COUNT Option

TABLE_UDF_ROW_BLOCK_CHUNK_SIZE_KB Option



DBA permissions are not required for these options.



CR:692802
CR Number:   692802
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   12.7 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under rare circumstance the server might incorrectly parse the SQL statement for a procedure and result in a crash. This has been now been fixed.



CR:693033
CR Number:   693033
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 Dec 2011 Presently Not Targeted For Any Future Release Of This Product
15.4 e01 22 Dec 2011 Fixed
Description
If a column has a data type VARCHAR or VARBINARY greater than 255 bytes, sp_iqrebuildindex does not rebuild a default index. This problem was erroneously reported fixed in the 15.4 Sybase IQ New Features Summary.



CR:693109
CR Number:   693109
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 12 Nov 2012 Added to user documentation
Description
When a partitioned table resides on online and offline dbspaces, data of the table can not be accessed, if any data/index/partition of the table resides on the OFFLINE dbspace.

Also, sp_iqcheckdb doesn't check partitioned table with OFFLINE dbspaces.

To create and use indexes on a partitioned table, all dbspaces have to be online.



CR:693122
CR Number:   693122
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux
Original Version:   15.2 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 future
Description
a union all query may abort in df_heap.cxx: 12140
Workaround Description
 The workaround for this issue is turning off shadow transformation for Group By using below dml option,

set temporary option dml_options8 = 8 ;



CR:693311
CR Number:   693311
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 e01 03 Feb 2012 Added to user documentation
16.0 sp01 25 Mar 2013 Added to user documentation
15.4 e03 25 Mar 2013 Added to user documentation
Description
Modifying a column data type using alter command is not supported.



CR:693421
CR Number:   693421
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Windows 7
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 09 Feb 2012 Fixed
16.0 09 Feb 2012 Fixed
Description
In the 15.4 Release Bulletin, the section "Network Clients and ODBC Kits" should state: Sybase IQ Network Clients and ODBC kits for development are available on the Sybase download site. A Network Client is available for each platform supported by this version of Sybase IQ. The Linux 32-bit client is also available. The Sybase download site is http://www.sybase.com/downloads.



CR:693648
CR Number:   693648
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
LOAD TABLE with 3 char ROW DELIMITER ';]\x0a' can not always load the data files



CR:693662
CR Number:   693662
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ 15.4 and all previous versions of 15, sp_iqdbspaceinfo lists objects residing in a dbspace, customer require ability to list objects residing in a specific dbfile



CR:693833
CR Number:   693833
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 01 Feb 2012 Fixed
16.0 14 May 2012 Fixed
Description
A query might cause datatype conversion error at dfe_Cast.cxx : 918 and subsequent IQ server failure at hos_mem.cxx:243 while converting varchar column value to numeric datatype.



CR:693904
CR Number:   693904
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2008
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 17 Feb 2012 Fixed
Description
The following was omitted from the LOCK TABLE statement in Sybase IQ Reference: Statements and Options. Using the WITH HOLD clause in the same statement with WRITE MODE is unsupported and returns the error SQLCODE=-131, ODBC 3 State="42000".



CR:693905
CR Number:   693905
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2008
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Lock Table: instead of syntax error, return meaningful msg: 'with hold' and in 'write' mode are not allowed in same statement



CR:693970
CR Number:   693970
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like extra diagnostics about objects involved when hitting errors like..



I. 12/19 01:29:26. 0001304510 [20895]: Insert Pass 1 completed in 2 seconds.

I. 12/19 01:31:19. 0001304510 main Bufman: Incorrect page header read;

buffer={btype=12,nlb=16,blk=11084,pbn=447979368,npb=7,uid=1387737518,txn=418596030,sp=1,flgs=0x818 page={btype=12,nlb=16,npb=16,ctr=131,cta

I. 12/19 01:31:19. 0001304510 =131,pbn=447979368,txn=418039238,sp=844,ver=1,pb=104,pus=43966}.

s_trycatch.cxx:1549

I. 12/19 01:31:19. 0001304510 There was an s_buf::Read() error during s_bufman::Find().

I. 12/19 01:31:19. 0001304510 Exception Thrown from s_blockmap.cxx:4469, Err# 0, tid 1089 origtid 1089

I. 12/19 01:31:19. 0001304510 O/S Err#: 0, ErrID: 2100

(s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14

I. 12/19 01:31:19. 0001304510 [20060]: main Bufman: An error was detected on a database page. You may have a damaged index. For additional information, please check your IQ message file or run sp_iqcheckdb.



CR:694467
CR Number:   694467
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2012 Added to user documentation
16.0 13 Nov 2012 Added to user documentation
Description
Customers using Sybase IQ/CIS on SunOS version 5.10 Generic_144488-04 to access remote ASE tables using the 15.7 ASE ODBC driver will get the following message:



"Error when attempting to connect: Unable to connect to server 'MYASE': [Sybase][ODBC Driver Manager] Unable to load driver"



To connect, install the June 30, 2011 OS patch bundle. Kernel version: SunOS 5.10 Generic_144488-17



CR:694685
CR Number:   694685
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2012 Fixed
16.0 13 Jul 2012 Fixed
Description
If a NON zero return status produced by script called by a BACKUP DATABASE FULL VIRTUAL ENCAPSULATED command IQ is not picking this up and not throwing an error on Linux Redhat. Instead the backup is treated as sucessful.



CR:694840
CR Number:   694840
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2012 Fixed
Description
When execute a Java UDF in IQ the server might crash when trying to right truncate data for a binary column whose size is greater than 256 bytes. This has been fixed.



CR:695298
CR Number:   695298
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 31 Jan 2012 Added to user documentation
Description
In Sybase IQ 15.4 > System Administration Guide: Volume 1 > Sybase IQ Indexes > Criteria for Choosing Indexes > Number of Unique Values in the Index, the documentation stated that the recommended index type for less than 1000 unique values is HG when the table has <25,000 rows. This is incorrect. Sybase recommends using the HG index when the table has <100,000 rows.



CR:695461
CR Number:   695461
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 19 Jan 2012 Fixed
19 Jan 2012 Presently Not Targeted For Any Future Release Of This Product
19 Jan 2012 Presently Not Targeted For Any Future Release Of This Product
Description
While performing a database backup that required multiple tapes,

the backup stopped with error "Unable to write to archive"

shortly after displaying the message prompting to load tape #2.



CR:695758
CR Number:   695758
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SELECT .. UNION SELECT .. ORDER BY COLUMN could returns The field 'COLUMN' specified in the query cannot be found
Workaround Description
 WA set temporary option CIS_OPTION=8;

When your UNION contains an SA table and IQ table.

In this case the select att=1 --> select att=1 FROM DUMMY

In IQ 12.7 the whole query would have been exeucted at the SA side. IN IQ 15 this is executed at the IQ side.



Even in IQ 12.7 you would get the same result for this test query if you change the SELDCT att=1 to SELECT att=1 FROM IQDUMMY.



CR:695904
CR Number:   695904
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2008
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2012 Fixed
01 Mar 2012 Fixed
Description
Customers might experience an error while trying to create a raw database on Windows 2008 R2. This has now been fixed.



CR:695918
CR Number:   695918
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 19 Jul 2012 Fixed
05 Nov 2012 Fixed
05 Nov 2012 Fixed
Description
In a MPX, if the column id of a table is greater than 65535 and any DML operation is done on the table, during TLV replay the secondary servers will abort with SEGV



CR:696059
CR Number:   696059
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2012 Fixed
05 Sep 2012 Fixed
15.3 e00.x 04 May 2012 Fixed
Description
There was an issue in the parallel HG index insert logic which could lead to an inconsistent index. The load/insert used to throw a non-fatal error from HG index logic.

This issue has been resolved.
Target Version
 15.4 e01



CR:696213
CR Number:   696213
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 08 Feb 2012 Work as design
15.4 e02 04 Mar 2012 Fixed
16.0 27 Feb 2012 Fixed
16.0 10 Apr 2012 Fixed
Description
Out of sync R/W lock may cause secondary node emergency shutdown. It is an expected server behavior.



CR:696317
CR Number:   696317
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PATINDEX could return wrong results for wildcard chars and latin special chars



CR:696396
CR Number:   696396
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NFR: Allow extraction of data from mixed on and offline partitioned objects



CR:696563
CR Number:   696563
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 7
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 03 Feb 2012 Fixed
Description
A bulk insert of large object data using host variables

will insert, for each

row, the same value that was inserted to the same column

in the first row inserted.



CR:696673
CR Number:   696673
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 7
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 17 Feb 2012 Fixed
Description
If bulk inserts are sent to the server and one encounters an

error, previous successful bulk inserts may be rolled back.



CR:696880
CR Number:   696880
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.2 e02.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RESTORE cause utlity_db crash on s_buf*s_blockmap::Find



CR:696885
CR Number:   696885
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2 e02.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Assertion failed: 109512 Freeing already-freed memory on SELECT TOP



CR:696982
CR Number:   696982
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 e01 13 Apr 2012 Fixed
15.4 e02 02 May 2012 Fixed
15.4 e01.x 29 Apr 2012 Fixed
Description
A query with right outer hash join node could return internal error at s_csort.cxx:3161

in IQ15.4 while sorting output from right outer hash join node.



CR:697069
CR Number:   697069
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 16 Dec 2012 Fixed
16.0 27 Feb 2013 Added to user documentation
Description
The LOAD TABLE clauses BLOCK FACTOR, BLOCK SIZE and UNLOAD FORMAT are deprecated. IQ nolonger accepts this syntax and will return syntax errors if these clauses are used.



CR:697153
CR Number:   697153
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Windows 2008
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 28 Feb 2012 Fixed
28 Feb 2012 Fixed
28 Feb 2012 Fixed
Description
SybaseIQAgent15 would fail to start the IQ Server if the Windows environment variable PATH was greater than 1024 characters.



CR:697211
CR Number:   697211
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2012 Added to user documentation
Description
A new version of the Sybase IQ 15.4 Quick Start Guide on the Sybase Product Documentation Web site includes some path name changes. Some sections in the 15.4 Quick Start Guide use a variable as part of the path where an absolute path may have been more appropriate. The revised Quick Start includes full and explicit path names.



CR:697212
CR Number:   697212
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2012 Added to user documentation
Description
A new version of the Sybase IQ 15.4 Quick Start Guide on the Sybase Product Documentation Web site includes some path name changes and a note on distributed queries.



Some sections in the 15.4 Quick Start Guide use a variable as part of the path where an absolute path may have been more appropriate. The revised Quick Start includes full and explicit path names. A change in the Running a Distributed Query section notes that the query engine may choose a query plan that does not distribute to the write server.



CR:697314
CR Number:   697314
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 02 Feb 2012 Fixed
16.0 30 Aug 2012 Fixed
Description
Sybase IQ has been upgraded to Sybase Open Client 15.7. This will be automatically installed with version 15.4 ESD #1 and up.



CR:697490
CR Number:   697490
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Windows 7
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 03 Feb 2012 Added to user documentation
Description
The SCC online help for Sybase IQ does not contain information on recent changes to the SCC security modules. See the SCC 3.2.6 Release Bulletin for the updated documentation.



CR:697746
CR Number:   697746
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2003
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
discrepancy in the representation of floating point numbers to the IEEE 754 standard in any version of IQ.



4.70000000000000028865798640254E-1 is the most accurate representation of 0.47000000000000003 for double precision in the IEEE 754 standard But IQ chooses a slightly different representation of 0.47000000000000008437694987150000000000000000000000 when retrieving the number stored in a DOUBLE datatype when using a select convert ( numeric(126,50)



CR:698044
CR Number:   698044
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.2 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 10 Apr 2012 Duplicate
14 May 2012 Fixed
Description
A non-fatal error occurred on NTILE and RANK functions run on tables of a million rows.



CR:698206
CR Number:   698206
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This a doc enhancement request regarding the minimum permission's setting for the $IQTMP15 directory.



CR:698347
CR Number:   698347
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2013 Presently Not Targeted For Any Future Release Of This Product
Description
IQ 15 checkpointing more frequently and spending more time on checkpoints than 12.7



CR:698374
CR Number:   698374
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)
10 May 2013 Fixed
Description
If the identity_insert option was set for a user on a table owned by a user other than DBA, iqunload would be unable to set that option on the new database. This has been resolved.



Workaround: unset the identity_insert option for that table prior to running iqunload and re-establish it on the reloaded database afterwards.
Workaround Description
 set option "user1"."identity_insert"=''



CR:698573
CR Number:   698573
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 01 Jun 2012 Fixed
Description
Server failure may occur when loading data with logging turned on and there are

default values for a column.



CR:698659
CR Number:   698659
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Suse
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When the database option Max_Query_Parallelism is set to a decimal value instead of an integer, IQ server can crash.
Workaround Description
 Set the option Max_Query_Parallelism to an integer value.



CR:698811
CR Number:   698811
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request. IQ to allow users with expired password to connect and be prompted to change the password as ASE does.



CR:699014
CR Number:   699014
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 14 Mar 2013 Fixed
Description
There was a 508 issue where keyboard access in the Domain Wizard did not work properly.



CR:699206
CR Number:   699206
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ could crash when running multi-table UPDATE when one of the tables is a proxy table.

Multi-table UPDATE is not allowed. It will fire an error instead of crashing
Workaround Description
 Rewrite the UPDATE as batch. In customer's case, it could be rewriten as follows:



begin

declare @vdate datetime;

select min (dateformat(tproxy.snapshot_date, 'yyyy-mm-dd hh:mm:ss.sss')) into @vdate

from iqtab

where loaded=0 and deleted<>1;

update iqtab set loaded=0

where (snapshot_date) >= @vdate;

end



CR:699327
CR Number:   699327
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 e02 12 Jun 2012 Fixed
Description
Fixed an internal memory corruption error causing server failure.



CR:699486
CR Number:   699486
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A selective restore of a RO dbspace with RENAME to a raw device where the TO device name alread exists causes restore error like this...



Could not execute statement.

Dbspace file with name or path '/dev/rdsk/c1t6d0s2' already exist.

SQLCODE=-1234, ODBC 3 State="42000"

Line 1, column 1



Investigative CR to see if this is expected behaviour / document clarification



CR:699969
CR Number:   699969
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2012 Fixed
Description
Migration from 12.7 to 15.4 could fail if on on 12.7 there is a proxy table to ASE and an index on that proxy table exists.
Workaround Description
 In IQ, drop the proxy table on 12.7, then run iqunload, then recreate the prxy table on 15.4



CR:700118
CR Number:   700118
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Solaris
Original Version:   15.2 e02.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02.x 24 May 2012 Fixed
Description
On data set with large numner of rows, a query resulting aggregated values with large precision and scale via aggregate functions that has a subtree that predicts aggregate value size undergoes shadow transformation might hit an validation error at dfo.cxx:9638 on 15.2 esd 2.x. This has been fixed.



CR:700166
CR Number:   700166
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Windows 2008
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 12 Jun 2012 Fixed
15.4 e02 23 Aug 2012 Fixed
15.4 e02 23 Aug 2012 Fixed
Description
Previous installers did not stop and delete the previous SCC version window service. This has now been fixed.



CR:700647
CR Number:   700647
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2 e02.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_iqversionuse fail with Function 'hextoint' has invalid parameter or return negative version IDs.
Workaround Description
 2012-10-09 ltang

====================

I found a possible workaround.

By creating a new temp table in the IQ store instead of IN SYSTEM, you can run hextoint

without conversion issues or getting a negative value for versionID.





CREATE PROCEDURE test_iqversionuse()

result( VersionID unsigned bigint,

Server char(128),

IQConnID unsigned bigint,

WasReported unsigned bigint,

MinKBRelease unsigned bigint,

MaxKBRelease unsigned bigint )

begin

declare oldestver unsigned bigint;

declare newestver unsigned bigint;

declare writerID unsigned bigint;

declare myID unsigned bigint;

declare local temporary table #iqtrantmp(

TxnID unsigned bigint not null,

VersionID unsigned bigint null,

State char(16) null,

CreateKB unsigned bigint null,

DropKB unsigned bigint null,

CursorCount unsigned bigint null,

IQConnID unsigned bigint null,

primary key(TxnID),) in SYSTEM on commit preserve rows;

declare local temporary table #iqversionlist(

VersionID unsigned bigint not null,

CreateKB unsigned bigint null,

DropKB unsigned bigint null,) in SYSTEM on commit preserve rows;

declare local temporary table #iqversionuse(

VersionID unsigned bigint null,

ServerID unsigned bigint null,

WasReported unsigned bigint null,

IQConnID unsigned bigint null,) in SYSTEM on commit preserve rows;

declare local temporary table sp_iqactiveversions_table(

server_id unsigned integer null,

active_versions long varchar null,) in SYSTEM on commit delete rows;



/* CREATE A TEMP TABLE IN IQ STORE */

declare local temporary table sp_iqactiveversions_tmp(

server_id unsigned integer null,

active_versions char (8) null,

active_versions_hex bigint null ) on commit delete rows;



call dbo.sp_iqversionuse_internal();



set writerID = (select server_id

from SYS.SYSIQMPXSERVER

where role = 0);

set myID = (select server_id from SYS.SYSIQMPXSERVER

where server_name = @@servername);

insert into #iqtrantmp

select TxnID,

case VersionID when 0 then CmtID else VersionID end,

State,MainTableKBCr,MainTableKBDr,CursorCount,IQConnID

from dbo.sp_iqtransaction();

if myID = writerID then

insert into #iqversionlist

select VersionID,CreateKB,DropKB

from #iqtrantmp

where State in( 'COMMITTED','APPLIED' ) ;

/*

REPLACE THIS SELECT, BY THE 3 CMD: INSERT + UPDATE + SELECT BELOW



select isnull(min(hextoint(substr(active_versions,1,locate(active_versions,'Z')-1))),1)

into oldestver from sp_iqactiveversions_table

where locate(active_versions,'Z') > 1;

*/



insert sp_iqactiveversions_tmp (server_id, active_versions)

(select server_id, substr(active_versions,1,locate(active_versions,'Z')-1)

from sp_iqactiveversions_table

where locate(active_versions,'Z') > 1);



update sp_iqactiveversions_tmp set active_versions_hex = hextoint (active_versions);



select isnull(min(active_versions_hex), 1) into oldestver from sp_iqactiveversions_tmp;



-- Add a row for the oldest version if it does not appear in sp_iqtransaction

if not exists(select *

from #iqversionlist as it

where it.VersionID = oldestver) then

insert into #iqversionlist values( oldestver,0,0 )

end if;

-- Calculate version usage for active transactions on this server

insert into #iqversionuse

select(select isnull(max(it2.VersionID),1)

from #iqversionlist as it2

where it2.VersionID <> 0

and it2.VersionID < it.TxnID),

myID,1,IQConnID

from #iqtrantmp as it

where it.State = 'ACTIVE';

-- Add rows for versions used by query servers reported back by SQL remote

insert into #iqversionuse

select it.VersionID,vl.server_id,1,0

from sp_iqactiveversions_table as av,SYS.SYSIQMPXSERVER as vl,#iqversionlist as it

where vl.role <> 0

and vl.status = 0

and it.VersionID <> 0

and av.server_id = vl.server_id

and lower(replace('Z'+av.active_versions,'Z','Z000000000000000'))

like lower('%'+inttohex(it.VersionID)+'Z%');

-- Add rows for versions used by query servers not reported back by SQL remote

insert into #iqversionuse

select it.VersionID,mi.server_id,0,0

from SYS.SYSIQMPXSERVER as mi,#iqversionlist as it

where mi.role <> 0

and mi.status = 0

and it.VersionID > (select isnull(max(VersionID),0)

from #iqversionuse as vt

where vt.ServerID = mi.server_id)

else -- Query server

-- Gather version list from sp_iqtransaction

insert into #iqversionlist select distinct VersionID,0,0 from #iqtrantmp where(State = 'ACTIVE' or CursorCount > 0);

-- Calculate version usage for active transactions on this server

insert into #iqversionuse select VersionID,myID,

isnull((select 1

where exists(select *

from sp_iqactiveversions_table as av

where lower(replace('Z'+av.active_versions,'Z','Z000000000000000'))

like lower('%'+inttohex(it.VersionID)+'Z%'))),0),IQConnID from #iqtrantmp as it where(State = 'ACTIVE' or CursorCount > 0);

-- Add a row for the latest version

select max(VersionID) into newestver from dbo.sp_iqmpxversioninfo();

if newestver <> 0 and not exists(select * from #iqversionlist

where VersionID = newestver) then

insert into #iqversionlist values( newestver,0,0 ) ;

insert into #iqversionuse values( newestver,myID,0,0 )

end if

end if;

set oldestver = (select min(vu.VersionID) from #iqversionuse as vu);

select vt.VersionID as VersionID,

isnull((select mi.server_name

from SYS.SYSIQMPXSERVER as mi

where mi.server_id = vt.ServerID),@@SERVERNAME) as Server,

vt.IQConnID as IQConnID,

vt.WasReported as WasReported,

case vt.VersionID

when oldestver then it2.DropKB

else 0

end as MinKBRelease,

case vt.VersionID

when oldestver then it2.DropKB

when it2.VersionID then 0

else case sign(cast(it2.DropKB as bigint)-cast(it.CreateKB as bigint))

when 1 then it.CreateKB

else it2.DropKB

end

end as MaxKBRelease

from #iqversionuse as vt,#iqversionlist as it,#iqversionlist as it2

where vt.VersionID = it.VersionID

-- it2.VersionID is the previous version used to calculated release

and it2.VersionID = (select isnull(min(it3.VersionID),it.VersionID)

from #iqversionlist as it3

where it3.VersionID > vt.VersionID)

order by vt.VersionID asc,vt.ServerID asc,vt.IQConnID asc

end ;



CR:700675
CR Number:   700675
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Suse
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to reduce disk i/os when doing insert select into temporary table.



CR:700886
CR Number:   700886
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 e03 04 Nov 2013 Duplicate
Description
Execution times of prefetches increased when comparing IQ version 15 with previous Sybase IQ releases. This has been fixed.



CR:700980
CR Number:   700980
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2012 Fixed
15.4 e02 26 Jun 2012 Fixed
15.4 e01.x 25 Jun 2012 Fixed
Description
1. The unhandled datatype exception is observed when host variable of type date with 6 digit precision in declared application using jConnect client 5.X onwards, used in query running on IQ table.

2. The Secondary error is observed when query has Sort Merge join executed serially and early resource release option is disabled.



CR:701039
CR Number:   701039
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2014 One-off Provided
18 Apr 2012 Fixed
15.4 e01.x 20 Apr 2012 Fixed
15.4 e02 21 Jun 2012 Fixed
16.0 30 Jun 2012 Fixed
Description
Added new database option 慉ES_Encrypt_Header_Format for decrypting data upgraded from 12.7 to 15.x or imported from 12.7 to 15.x.



Option usage:



SET OPTION public. AES_Encrypt_Header_Format = VAL ;



Where 慥AL is an integer and it can have the following possible values:



-1 -> Default: format is that of current release. Data is encrypted and decrypted using the same release. e.g. data is encrypted on 15.3 database and decrypted on 15.3 database.



127 -> Set this option to decrypt data if database is upgraded or imported from 12.7 release. e.g. data is encrypted on 12.7 database and it is upgraded to 15.x.



153 -> Set this option if data is from previous 15.3 release. e.g. Data is encrypted on previous 15.3 database and decrypted on next 15.x release.



154 -> Set this option if data is from previous 15.4 release. e. g. Data is encrypted on previous 15.4 database and decrypted on next 15.x release.



1000 -> Data is from fixed releases.



CR:701052
CR Number:   701052
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 09 Mar 2012 Fixed
11 Oct 2012 Fixed
Description
Grant multiple authority to multiplex users does not propagate on secondary

nodes.



CR:701085
CR Number:   701085
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 18 Oct 2012 Added to user documentation
Description
Contents of Permissions of alter index and alter table are not corret.



alter index not required RESOURCE authority.

alter table not required CREATE permission on the new dbspace and be the table owner.



CR:701097
CR Number:   701097
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Windows 2008
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 24 Sep 2012 Fixed
Description
IQ15.4 includes 15.2ESD#3 and 15.3GA updating.



CR:701116
CR Number:   701116
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2008
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Japanese file name containing "0x5c" makes Temp_Extract fail.
Workaround Description
 Please do not use Japanese for Temp_Extract_Name.



CR:701326
CR Number:   701326
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 12 Mar 2012 Fixed
15.4 e01 19 Mar 2012 Added to user documentation
Description
As of 15.4 ESD #1, Sybase IQ no longer supports elliptic-curve

cryptography (ECC) encryption.



CR:701447
CR Number:   701447
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Backup FULL and INCREMENTAL a database older than 30 days that has and uses the VLDB license.

On a installation that has no license at all, RESTORE FULL would succeed

but then even after installing a valid VLDB license, the subsequent RESTORE INCREMENTAL could faile with error:



Msg 21, Level 14, State 0:

SQL Anywhere Error -1012008: Database has changed since last restore.

-- (db_backupID.cxx 617)
Workaround Description
 Before any kind of RESTORE, ensure that the restore system has valid IQ licenses installed.



CR:701474
CR Number:   701474
Product Name:   IQ Management
Product Component:   Web UI - Node Monitor - View All Statistics in Tab
Status:   Open
OS:   Generic
Original Version:   3.2.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ Multiplex Coordinator node statistcs: No data was found for statistics



CR:701641
CR Number:   701641
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 19 Apr 2012 Fixed
16 May 2012 Fixed
22 May 2012 Fixed
Description
In DQP, a simple SELECT COUNT(*) FROM TABLE WHERE COL like '123%' could return incorrect values.
Workaround Description
 set temporary option index_preference = 5

or donot use the option

set temporary option hg_search_range=1000



CR:701907
CR Number:   701907
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2003
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 26 Jun 2012 Fixed
Description
New Clickwrap licenses were received for Australia and Japan.

These have been added to the installer.



CR:701953
CR Number:   701953
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 22 Mar 2012 Fixed
16.0 22 Mar 2012 Fixed
15.4 e01 13 Apr 2012 Fixed
15.4 e02 17 Apr 2012 Fixed
16.0 03 May 2012 Fixed
Description
A query that contains a parallel orderby over a union with constant values for a column in all arms of the union could fail with an internal error.



CR:702246
CR Number:   702246
Product Name:   IQ
Product Component:   Documentation
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
32-bit GNU C Libraries package (glibc-2.xx-x.xx.el6.i686.rpm) also need to be installed before installing IQ 15.3 or 15.4 64-bit to a Redhat Enterprise Linux 6.x x86_64.



CR:702363
CR Number:   702363
Product Name:   IQ
Product Component:   Sybase Central
Status:   Open
OS:   Windows 2008
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When proxy table to an Oracle table is created, IQ plug-in maps NUMBER (5,2) to a different type.



CR:702419
CR Number:   702419
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
When backup full is taken on a coordinator and if it crash,

backup incremental is taken on the new coordinator (failover server),

then restore full or incremental can faile.



CR:702433
CR Number:   702433
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Windows XP
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dbisql for IQ 15 returns columns in fixed width necessitating resizing to see longer data which is not persistent. 12.7 returned data in variable length columns display.



CR:702454
CR Number:   702454
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Unknown
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 02 Apr 2012 Fixed
16.0 03 Apr 2012 Fixed
Description
With IQ 15.4 esd 1 on Windows platform, when you run "iqdsedit" it is missing the network protocols from the drop down box.

This has now been fixed.



CR:702845
CR Number:   702845
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 06 Jul 2012 Added to user documentation
Description
A Max_Warnigs option does not affect IQ server. The description about this option will be removed from a manual.



CR:702999
CR Number:   702999
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 e03 30 Oct 2012 Fixed
16.0 22 Nov 2012 Fixed
15.4 e02.x 02 May 2013 Fixed
Description
An insert..select query caused the server to crash when the record length exceeded the max record length a Parallel Combiner node can support.
Workaround Description
 Please try dml_options8=8 as a W/A



=================================================



[Problem SQL]

...

case b.datatype_cls when 'T' then b.info_val_text

when 'N' then left(repeat('0',2-length(cast(cast(b.info_val_num as int)

as varchar)))||cast(b.info_val_num as int),2) end

[Modified SQL]

...

case b.datatype_cls when 'T' then b.info_val_text

when 'N' then right('00'||left(cast(cast(b.info_val_num as int)

as varchar(10)),2),2) end





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------