远程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:722155
CR Number:   722155
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
running xp_cmdshell from an IQ server on Linux where the execution gives all the appearance of having been successfully run in IQ , but in reality nothing happens. The unix command, even if it is just a touch file, does not execute. It appears to have something to do with when the child process is spawned it seems to think it needs as much virtual memory as the parent process (the IQ server in this case) . The resolution almost always is to make sure that the swap space is at least 1 x the amount or RAM being used by IQ. This is related to CR 633354 - this feature request if to try find a better way to make this unix call / improve the message handling.



CR:722336
CR Number:   722336
Product Name:   IQ Management
Product Component:   Web UI - Heat Chart
Status:   Closed
OS:   RH Linux
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2012 Fixed
Description
This resolution addresses a heat chart issue where alert related information is not accurately reflected unless the chart is refreshed



CR:722356
CR Number:   722356
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 31 Oct 2012 Added to user documentation
Description
"SQL, HOSTVARS, PLAN, PROCEDURES, TRIGGERS, OTHER, BLOCKS, REPLACE, ALL and YES, NONE, and NO" can be specified to be "-zr" database starting options.

The details written to the IQ15Utility guide are not correct.



CR:722462
CR Number:   722462
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)
08 Dec 2012 Fixed
Description
When using distribited query processing in a MPX environment, IQ may crash when using a technique called early grouping sort and hash joins



CR:722485
CR Number:   722485
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 05 Mar 2013 Fixed
Description
User with the CREATE TABLE privilege will be prevented from proceeding in the table wizard if they select a user other than self.



CR:722560
CR Number:   722560
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.4 e01 05 Dec 2012 Duplicate
Description
An update statement can result in a connection unable to be dropped.



CR:722578
CR Number:   722578
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)
25 Apr 2013 Not a Bug
Description
Connections that have a cursor in prepare mode could fail to be able to drop if application abnormally disconnects



CR:722606
CR Number:   722606
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2013 Fixed
16.0 sp01 03 Apr 2013 Fixed
02 May 2013 Fixed
Description
Value for field 'columns' of sp_iqdbspaceinfo, while run for IQ_SYSTEM_MAIN and a partitioned table,returns non-zero value, expected is zero. This has been fixed.



CR:722628
CR Number:   722628
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 08 Dec 2012 Fixed
Description
Temp buffer pool was running out of buffers for parallel distinct aggregates due to each

thread obtaining its own pin allocation. After a few threads have done so, there was not enough buffers available to initialized the remaining threads.



CR:722661
CR Number:   722661
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 18 Dec 2012 Fixed
Description
Updates against an RLV enabled table using NBit could lead to a crash, this has been fixed.



CR:722919
CR Number:   722919
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 26 Mar 2013 Fixed
16.0 sp02 15 Aug 2013 Fixed
Description
Query with count aggregate on column having NULLs and a grouping column ran

slowly when IQ optimizer performed aggregation using index.



CR:722973
CR Number:   722973
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jan 2013 Duplicate
Description
IQ 15.2 infrequent occurence of writer node hangs during a checkpoint. The system never comes back and they end up having to cancel the server. The pstacks prior to cancelling the writer node show no activity / movement. There is a lot of threads waiting on implicit locks and the thread handling the checkpoint seems to be blocked trying to flush version information.



CR:723133
CR Number:   723133
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows 7
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2013 Duplicate
Description
A long delay may have been observed when right-clicking in the SQL Statements panel, especially if the internet connection was slow, or if there was no internet connected at all. This has been fixed. Note, the problem does not occur if the documentation has been installed locally. (ADDL CR728720)



CR:723216
CR Number:   723216
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 05 Mar 2013 Fixed
Description
The Foreign Key Constraint Wizard had a 508 issue where the keyboard would not successfully enable a particular drop down menu.



CR:723294
CR Number:   723294
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)
15.4 e03 04 Feb 2013 Fixed
Description
LOAD TABLE may incorrectly report "Warning: Partial input record (x bytes) skipped at EOF" and fail to load the last row from the input file.



CR:723446
CR Number:   723446
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03 21 Jan 2013 Fixed
Description
LOAD TABLE may incorrectly give error "Number of bytes (xxxxx) exceeds

maximum (yyyyy)" during a LOAD with QUOTES ON.



CR:723476
CR Number:   723476
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)
03 Jan 2013 Fixed
16.0 sp01 27 Feb 2013 Fixed
20 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
Description
A query with an outer join and many case expressions in the the select list may consume an unacceptable amount of temporary space.



CR:723503
CR Number:   723503
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Windows 2008
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2012 Not a Bug
Description
Windows GPT disk was supported by Sybase IQ 15.4 ESD#1



CR:723697
CR Number:   723697
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2012 Fixed
Description
When a table created in an IQ 15 database with 1, 2, or 3 byte FP is upgraded and joined to a N bit tokenized FP created in IQ 16,the server will crash



CR:723820
CR Number:   723820
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When all the 3 conditions are met:

- IQ SERVER is 15.4 esd 2 of any platform

- ISQL client is from 15.4 esd 2 LINUX 64 install (bundled Open Client 15.7.0.1)

- the option RETURN_DATE_TIME_AS_STRING=on



Then:

1> select getdate()

2> go

getdate()

-----------------------

2012-11

CT-LIBRARY error:

ct_fetch(): protocol specific layer: external error:

There is a tds protocol error. An illegal token was received.



CR:723829
CR Number:   723829
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2012 Fixed
Description
The following scenario would lead to a server crash.



Client has auto-commit on disconnect enabled.



1) Client 1 tries to insert a row in RLV store and has taken the lock. (this insert is not committed)

2) Client 2 fires non-blocking RLV-main store merge, which blocks on the lock.

3) Insert from client 1 completes, followed by merge from client 2.

4) Run 搒elect from client 1

5) Disconnect the client 1 fires auto-commit

6) Re-connect and run 搒elect again on client 1



This has now been fixed.



CR:723891
CR Number:   723891
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 11 Dec 2012 Fixed
Description
The conditions for which insert/load currently written to "System Administration Guide Volume 1" uses a multithread are not correct.



CR:724003
CR Number:   724003
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 e03 10 Dec 2012 Fixed
Description
Data is loaded incorrectly to a partitioned table

following a data value constraint violation.



CR:724109
CR Number:   724109
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)
16.0 sp02 24 Jul 2013 Fixed
16.0 sp02 05 Aug 2013 Fixed
16.0 sp02 21 Aug 2013 Fixed
16.0 sp02 21 Aug 2013 Not a Bug
16.0 sp02 13 Aug 2013 Fixed
16.0 sp02 15 Aug 2013 Fixed
16.0 sp02 21 Aug 2013 Fixed
16.0 sp02 04 Sep 2013 Fixed
16.0 sp02 19 Aug 2013 Test Exists
16.0 sp02 29 Aug 2013 Not a Bug
Description
A query that contains a UNION ALL with an uncorrelated subquery executed over a set of tables performs much slower than the same query executed over a single giant base table.



CR:724223
CR Number:   724223
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 e03 12 Dec 2012 Fixed
Description
The server could in some cases fail while performing a BCP IN request if an error was generated while servicing the BCP request. This problem has now been fixed.



CR:724297
CR Number:   724297
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2008
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Use of a special value or a user SQL function generate the incorrect query plan.

However, an issue is not reproduced when a special value with the date types, such as CURRENT TIMESTAMP is used.



CR:724391
CR Number:   724391
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)
07 Dec 2012 Fixed
Description
If you create a logical server with no servers, the secondary servers can go into an infinite loop during TLV replay giving an impression of a hang



CR:724532
CR Number:   724532
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)
04 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
16.0 sp02 03 Oct 2013 Fixed
Description
An insert .. select statement containing WITH .. AS fails with a Column not found error in 15.4 esd2.



CR:724591
CR Number:   724591
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Consult Complete
Description
LOAD TABLE does not output error column information, when the data over string length exists.



CR:724601
CR Number:   724601
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently LIST function resides in the SA catalog.

Each time it is called from IQ, it needs to go through CIS, which causes some

performance overhead.

The customer would like the LIST function to be implemented in the IQ SYSTEM store to

boost performance.



CR:724627
CR Number:   724627
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 e03 02 Jan 2013 Fixed
15.4 e02.x 04 Feb 2013 Fixed
16.0 17 Jan 2013 Fixed
Description
CR724627 A left outer join on ISNULL() may not return a correct result set. For example, "select * from A left outer join B on IsNull(A.b,9999) = B.b;"

To be more generic any query having leftouter join with all the join condition as invariant predicate (either they are invariant or become invariant because of some simplification by the optimizer) might return wrong result.

After the fix the leftouter join remains as it is rather than getting converted to cross join.



CR:724634
CR Number:   724634
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_iqcheckdb can return corrupt index error on an LF index created with more than 10000 unique values after setting LF_Max_Unique_Values option to a number as high or higher as actual unique values over 10000



CR:724764
CR Number:   724764
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2012 Fixed
16.0 sp01 29 Mar 2013 Fixed
16.0 sp01 22 Mar 2013 Fixed
16.0 sp01 01 Apr 2013 Fixed
Description
Query plans would not display all fields for RLV enabled tables. This has been fixed.



CR:724804
CR Number:   724804
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
IQ 12.7 -> 15.2 upgrade - performance degrade in Subsequent Fetch performance returning result set to client in some queries in Solaris environment



CR:724806
CR Number:   724806
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2012 Fixed
21 Dec 2012 Fixed
Description
Usage of updateable cursors on secondary MPX Writers can cause the Writer to crash



CR:725054
CR Number:   725054
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 e02.x 05 Dec 2012 Fixed
Description
LOAD TABLE will case a server failure if loading from a file with no filename extension.



CR:725055
CR Number:   725055
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2012 Not a Bug
Description
select dateformat('2012-nov-12 08:05:02','YYYY-MM-DD-HH:NN:SS') errors in 15.4, but not in 12.7 or 15.2.



CR:725181
CR Number:   725181
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
"select dateformat('2012-nov-12-08:05:02','YYYY-MM-DD-HH:NN:SS') from iqdummy" should throw an error same as the catalog (from dummy) does.



CR:725406
CR Number:   725406
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2012 Fixed
Description
Bad data could be merged from the RLV store into the IQ main store base table, if a column was set to the bit datatype. This has now been fixed.



CR:725639
CR Number:   725639
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 e03 27 Dec 2012 Fixed
15.4 e03 15 Jan 2013 Fixed
15.3 14 Feb 2013 Fixed
15.4 e03 14 Feb 2013 Fixed
15.4 e04 14 Feb 2013 Fixed
Description
An IS NULL test in a CASE expression can fail to return rows.
Workaround Description
 set temporary option dml_options6=131072;



CR:725806
CR Number:   725806
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)
24 Apr 2013 Duplicate
Description
15.4 esd 2 Simple query slower compared to 15.2 esd 3



CR:725871
CR Number:   725871
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.4 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 14 Dec 2012 Fixed
Description
The description about the fault caused during DQP execution does not exist in the manual of IQ.



CR:726114
CR Number:   726114
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)
25 Dec 2012 Fixed
Description
The LastReqTime connection property could have had an incorrect time stamp compared to current time. This would have only occurred if the server had been running for more than 24 hours. This has been fixed.



CR:726127
CR Number:   726127
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 06 Feb 2013 Fixed
13 Feb 2013 Fixed
16.0 13 Feb 2013 Fixed
Description
sp_iqrebuildindex will fail with "Invalid expression" if the index_clause is a quoted identifier.
Workaround Description
 Rename column with . (DOT) to some string literal without . (DOT)

Run sp_iqrebuildindex on this temporary string literal

Rename column back to original name with . (DOT)



CR:726128
CR Number:   726128
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2012 Fixed
05 Dec 2012 Fixed
Description
When logging message in the iqmsgfile, the username string may get truncated.



CR:726167
CR Number:   726167
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)
12 Dec 2012 Fixed
Description
Performing an incremental back of the RLV enabled store could lead to a server crash. This has been fixed.



CR:726373
CR Number:   726373
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Suse
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 20 Mar 2013 Fixed
Description
If the trigger definition resulting from ALTER TRIGGER statement execution conflicted with an existing trigger, the original trigger could be deleted, and wrong error returned. This has been fixed.



This change also introduces a change in the algorithm used to decide the order of firing triggers when ORDER clause is not specified or multiple triggers with the same order and combination of events were created. For example, this may change the order in which triggers created with 揢PDATE ORDER 2, 揢PDATE, DELETE ORDER 2 and 揢PDATE OF <col> ORDER 2 are fired. Note that documentation explicitly recommends specifying different ORDER values for triggers with the same event. If your database contains such sets of triggers, and the order of firing is important, please alter the triggers to reorder them accordingly.

In general, both UPDATE ORDER 1 and UPDATE OF <col> ORDER 1 triggers will fire before any UPDATE ORDER2 triggers are fired. A unique ordering between UPDATE and UPDATE OF <col> triggers is still recommended.



CR:726496
CR Number:   726496
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)
12 Dec 2012 Fixed
Description
When merging updates from the RLV enable store back into the IQ main store, an ordering error might be encountered. This has been fixed.



CR:726541
CR Number:   726541
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jan 2013 Fixed
Description
IQ server generates an error 9216 saying "Feature, ORDER BY in Union View, is not supported." when using a select-into query with an orderby clause



CR:726559
CR Number:   726559
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)
QA PF 10 14 Dec 2012 Fixed
Description
For the grouped queries against the RLV store, wrong results might be returned. This has been fixed.



CR:726794
CR Number:   726794
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ 15.4 ESD 1.1 Linux64 - IBM pSeries 2.6.18. They have a large partial width update statement that threw an exception at s_bm.cxx:1919 call at _ZN4s_bm7SetBits.
Workaround Description
 customer broke down the size of the update (by rowid) and got around the issue



CR:726819
CR Number:   726819
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)
01 Apr 2013 Fixed
11 Feb 2014 Fixed
03 Sep 2014 Fixed
Description
Queries having a combination of Sort merge join and Windows operator might give wrong result. Because of early exit logic of sort mege join this bug got exposed. Fix resolves this issue.
Workaround Description
 Avoid short merge join :

set temporary option join_preference = '-1'



serial execution :

set temporary option DML_OPTIONS8=8 works around this



CR:726924
CR Number:   726924
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)
15.4 e03 03 Mar 2013 Fixed
16.0 sp01 18 Feb 2013 Fixed
18 Feb 2013 Fixed
Description
When the data of the duplicate primary key and WD index is inserted, IQ process stops.
Workaround Description
 Set "core_options27=1" before the INSERT VALUES or INSERT SELECT statement when inserting to a word index to workaround the problem.



CR:727002
CR Number:   727002
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
LOAD TABLE does not output error column information, when the data over string length exists.



CR:727006
CR Number:   727006
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The information on the violation of constraint outputted to a ROW LOG file is outputted based on ROWID.

The function which outputs a data file name and a line number does not exist.



CR:727148
CR Number:   727148
Product Name:   IQ Management
Product Component:   Web UI - Node Monitor - View All Statistics in Tab
Status:   Open
OS:   RH Linux
Original Version:   3.2.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SCC does not have the function which exports performance data etc. to external data.



CR:727155
CR Number:   727155
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)
20 Dec 2012 Fixed
16 Jan 2013 Fixed
17 Jan 2013 Fixed
Description
When using IQ MPX server, the coordinator may hang when doing distributed query processing under heavy load.



CR:727388
CR Number:   727388
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)
16.0 sp08 30 Dec 2013 Already Fixed by Another CR
Description
A query that includes TOP, a subquery with an alias, and the alias used in the order by clause failed with a Non-Fatal IQ Internal Error Detected at dfo_cOrderBy.cxx:481.



CR:727417
CR Number:   727417
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.x 03 May 2013 Duplicate
Description
Stack trace on at s_packedRec.cxx:1287, on a query with CAST to varchar > 255
Workaround Description
 If possible, CAST TO VARCHAR (255)



CR:727427
CR Number:   727427
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
As the number of concurrent requests across the resource gate increases , as expected you see the number of available concurrent commands reported in the Context Server statistics StCntxNResource field drop. However if all concurrent resources are in use and requests start queuing (i.e. the figure in StCntxNWaiting starts increasing) then the data reported in StCntxNResource becomes a nonsensical / corrupt 10 digit figure.



CR:727579
CR Number:   727579
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2012 Fixed
Description
IQ may produce wrong result in some rare cases when probing an nBit index.



CR:727581
CR Number:   727581
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jan 2013 Fixed
Description
When running distributed query processing in a MPX server, all worker threads may crash for that given query



CR:727585
CR Number:   727585
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 7
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Dec 2012 Fixed
Description
Under rare circumstances, the background automerge of an RLV enabled table would loop repeatedly. This has been fixed.



CR:727648
CR Number:   727648
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)
28 Dec 2012 Fixed
Description
RLV Update queries involving a join in the FROM clause using aliases might crash. This has been fixed.



CR:727679
CR Number:   727679
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2013 Fixed
Description
An RLV table with char columns might merge incorrect data to the IQ main base table. This has been fixed.



CR:727728
CR Number:   727728
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_iqindexadvice gives wrong datatype info in the 3rd row of the Advice column if the select has a join with 2 columns of different datatypes.



CR:727747
CR Number:   727747
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)
07 Jan 2013 Fixed
Description
Concurrent update/load/delete operation into an RLV store followed by a select top20 query crashes IQ. This has been fixed.



CR:727942
CR Number:   727942
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03 Fixed
Description
Sub query containing NOT EXISTS causes an internal error.



CR:727958
CR Number:   727958
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Dec 2012 Fixed
Description
When running distributed queries using IQ MPX, coordinator may crash at stcxtlib/st_server.cxx:1485 under a heavy work load.



CR:727979
CR Number:   727979
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)
15.4 e04 27 May 2013 Fixed
16.0 sp02 13 Jun 2013 Fixed
Description
CONVERT to BIT gives INT instead of BOOLEAN for the return value datatype



CR:728058
CR Number:   728058
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.3 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Connection to Coordinator from Sybase Central doing Refresh All/Refresh folder spawns too many syncID_xx connections



CR:728097
CR Number:   728097
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)
22 Jan 2013 Fixed
07 Feb 2013 Fixed
Description
After applying the Sybase IQ15.4 ESD#2 on EUCJIS enviroment, would garbled srvlog messages IQ server.



CR:728121
CR Number:   728121
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When dml_options2 = 64, query with group by could fire the error:

Input to GROUP BY # from child # not ordered as required
Workaround Description
 remove dml_options2



CR:728124
CR Number:   728124
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Explanations needed on query plan generating 2 GROUP BY nodes



CR:728153
CR Number:   728153
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)
03 Jan 2013 Fixed
Description
When using the IQ MPX server, the reader nodes may crash under heavy stress condition that includes a combination of DML and DDL jobs.



CR:728319
CR Number:   728319
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 you already have an IQ 15.2 esd 2 or esd 2.x installed, and you upgrade your IQ solfware install to 15.2 esd 3, after applying "ALTER DATABASE UPGRADE",

iqsrv15 -v

select @@version

in IQMSG

still display the old IQ version/esd number.
Workaround Description
 Uninstall previous 15.2 esd before indtalling 15.2 esd 3.



CR:728435
CR Number:   728435
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
IQ 15.4 ESD 2 Linux64 - x86_64 - a number of simplex production servers on different host intermittently experience problems shutting the IQ process down.



The final checkpoint completes and the CloseDatabase messages is seen but the IQ process hangs and does not go away. The customer has to issue a kill -9 to resolve.



This appears to happen with dbstop, stop_iq and SQL command STOP ENGINE UNCONDITIONALLY.



CR:728739
CR Number:   728739
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
Assertion failed: 201501. No stack trace, no assert.dmp, were generated



CR:728927
CR Number:   728927
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
S99SybaseIQAgent15 sets the wrong value in the environment variable PATH.S99SybaseIQAgent15 refers to the "$IQDIR15/bin". The correct path is "$IQDIR15/bin64".



CR:729095
CR Number:   729095
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 26 Feb 2013 Fixed
Description
User was allowed to bypass an invalid DBSpace selection in the Materialized View Wizard.



CR:729154
CR Number:   729154
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 Feb 2013 Fixed
Description
The Login Policy Wizard was not enabling the Next button based on the sequence of data entry. The issue has been resolved.



CR:729299
CR Number:   729299
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
The Partition Wizard will now properly check for appropriate "create" permissions on the desired DBSpace. The user cannot proceed without selecting a valid DBSpace (one in which they have create permissions).



CR:729384
CR Number:   729384
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)
15 Jan 2013 Fixed
15 Jan 2013 Fixed
3.2.7 ESD1 13 Feb 2013 Fixed
Description
Create permission on the desired DBSpace is now verified before you can proceed to the next step for Partition Properties / column Storage.



CR:729413
CR Number:   729413
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 18 Feb 2013 Fixed
3.2.7 22 Jan 2013 Added to user documentation
Description
Performing a Split Partition now ensures correct permission on the destination DBSpace.



CR:729557
CR Number:   729557
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   RH Linux
Original Version:   3.2.7 Beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 04 Mar 2013 Fixed
Description
The Table Objects page will not be updated when primary key columns are added. Previously the page could get out of sync.



CR:729570
CR Number:   729570
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 Feb 2013 Fixed
3.2.7 ESD1 12 Mar 2013 Added to user documentation
Description
Create permission on the destination DBSpace is now verified for the Table Index Wizard.



CR:729768
CR Number:   729768
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   RH Linux
Original Version:   3.2.7 Beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 14 Feb 2013 Fixed
Description
There was no way for a user to undo a selection in the various role wizards. This can now be done.



CR:730008
CR Number:   730008
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 sp02 10 Jun 2013 Fixed
16.0 06 Jun 2013 Fixed
16.0 sp02 11 Sep 2013 Fixed
Description
In IQ 16 with the Revert_To_V15_Optimizer option set some queries ran much slower and with different plans than in 15.4.



CR:730018
CR Number:   730018
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 05 Mar 2013 Fixed
Description
Edit, move and delete options for indexes were not working correctly on the table objects page.



CR:730137
CR Number:   730137
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 e04 26 Apr 2013 Fixed
26 Apr 2013 Fixed
16.0 sp02 20 Aug 2013 Fixed
Description
A UNION ALL query with an aggregate and a group by expression runs slow in IQ 15.4 when the cardinality of the group by expression is low.



CR:730157
CR Number:   730157
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 13 Mar 2013 Fixed
13 Mar 2013 Presently Not Targeted For Any Future Release Of This Product
Description
The spinbox for the upper range of values was not working correctly.



CR:730225
CR Number:   730225
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.4 e02.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03 04 Feb 2013 Fixed
04 Feb 2013 Fixed
Description
Non-Fatal IQ Internal Error Detected

at s_garray.cxx:3125 on thread

May be reported deleting from a HG index.
Workaround Description
 dropping all HGs seems to get around this issue, however that is unacceptable as a valid workaround.



CR:730350
CR Number:   730350
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)
15.4 e04 18 Mar 2013 Fixed
15.4 e03.x 30 Sep 2013 Fixed
Description
A SELECT with a LIKE clause on a column with a HG index may return wrong results.
Workaround Description
 Either

Delete the HG index, an run the slect again, the results are correct.

or

Keep the HG index and "set temporary option index_preference = 5;", the results are correct



Abandoned the use of HG index at Varchar column. Resulting in sever loss of IQ performance



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

set temporary option dml_options8=128

Can be used as a W/A.



CR:730502
CR Number:   730502
Product Name:   IQ Management
Product Component:   Web UI - Other
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 15 Mar 2013 Fixed
Description
A user with DBA authority was unable to comment on a proxy table.



CR:730633
CR Number:   730633
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 26 Feb 2013 Fixed
Description
Granting Administrative and Role privileges to a system role was causing a failure.



CR:730784
CR Number:   730784
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 Mar 2013 Fixed
Description
Deleting Domains from multiple resources is not working. The issue has been resolved.



CR:730898
CR Number:   730898
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 03 Mar 2013 Fixed
Description
Insert into a LOB column using a LOB variable containing partial multi-byte characters could fail. This has been fixed now.
Target Version
 16.0 sp01



CR:730918
CR Number:   730918
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 08 Mar 2013 Fixed
Description
Alter table add long varchar column with LOB variable was failing. This fix resolves this issue.



CR:731039
CR Number:   731039
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 06 Mar 2013 Fixed
Description
Added missing php files to the installer.



CR:731290
CR Number:   731290
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)
17 May 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
ROLLUP functions are not allowed in a SELECT subquery. It certain situations, IQ executes it without firing an error and returns wrong results.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------