远程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:464327
CR Number:   464327
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 03 May 2007 Fixed
12.7 e03 06 Jun 2007 Fixed
Description
A server could fail with a Signal 11 if the Force_No_Scroll_Cursors

option was set to the non-default value of 'ON' and a client-side cursor

was closed and re-opened. The cursor operations could be called explicitly

from a client library or as the result of a CIS decomposed query

or OUTPUT TO statement.



CR:464331
CR Number:   464331
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 05 Jun 2007 Fixed
15.0 15 Oct 2008 Fixed
Description
A server failure might result during an INSERT...LOCATION

of an ASE IMAGE column or IQ LONG BINARY column to an IQ

BINARY or VARBINARY column.



CR:464420
CR Number:   464420
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 07 May 2007 Fixed
Description
In rare circumstances, the engine could fail when a stored procedure ran after DDL statements against the server caused a schema change involving a

cached stored procedure.



CR:464869
CR Number:   464869
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e06.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 23 Jul 2008 Fixed
Description
Request feature that allows locking nonactive user account and indicates why the account is locked.



CR:465093
CR Number:   465093
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   12.6 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
mechanism where IQ re-use the same astmp file or deletes with session end



CR:465663
CR Number:   465663
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   AIX
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 15 Sep 2008 Fixed
12.7 e03 26 Jun 2007 Fixed
15 Sep 2008 Presently Not Targeted For Any Future Release Of This Product
Description
On some UNIX systems (particularly AIX), files that the installer was trying to update could be held in memory and locked. This problem usually resolved itself in subsequent runs of the installer. However, if the locks continue to be held, run sybinstall with the new -unlock parameter. This parameter installs the files in a shadow directory, links to the correct location, then removes the shadow directory, thereby avoiding lock problems.
Workaround Description
 *** Tuesday, June 19, 2007 12:26:36 PM *** kthayer ***

I have attached the Unix script "unlock_dir" (see attached) which will unlock a locked dir. checkout header for usage.



CR:465679
CR Number:   465679
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 19 Apr 2007 Fixed
12.6 e10 03 May 2007 Fixed
Description
Use of procedure references in the UPDATE statement could cause the server to fail under certain circumstances. The server now generates an appropriate error message.



CR:465686
CR Number:   465686
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Unknown
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 03 Aug 2007 Fixed
12.7 e03 10 Aug 2007 Fixed
15.0 15 Oct 2008 Fixed
Description
When IP aliasing is used, the plug-in might fail to connect to the agent.

Successful connections by host name might fail when the IP Address is used.



CR:465697
CR Number:   465697
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e06.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Create a feature similar to ASE's named cache in IQ



CR:465800
CR Number:   465800
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 26 Jun 2007 Fixed
15.0 07 Jan 2008 Fixed
Description
Under some circumstances, a query containing multiple nested levels of views or derived tables could encounter an internal error when either (1) the SELECT list of one of the higher level views or derived tables contained an expression that was not a constant, but which could be simplified into a constant value, or (2) some expression in the SELECT list of a higher level view was not used in the query using that view.



CR:465896
CR Number:   465896
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 15 May 2007 Fixed
12.7 e03 1 29 May 2007 Fixed
Description
An invalid double dot '..' expression in front of an aliased column name

in a GROUP BY clause could cause the server to be unresponsive.



CR:466135
CR Number:   466135
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03.x 02 Oct 2007 Fixed
12.7 e04 21 Jan 2008 Added to user documentation
15.0 17 Dec 2007 Fixed
12.7 e04 02 Dec 2007 Fixed
Description
Certain combinations of CURSOR FETCH, COMMIT, and CLOSE CURSOR could server failure. The following sequence will cause a failure:

create table;

insert table;

commit;

open cursor for select from table;

commit;

insert table;

fetch cursor;

commit;

insert table;

commit;

close cursor;



See the Release Bulletin for a description of related behavior changes.



CR:466246
CR Number:   466246
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   12.7 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
More diagnostic information during dbbackup



CR:466355
CR Number:   466355
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   12.6 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
feature request to include the cpu cost in the query detail.



CR:466410
CR Number:   466410
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2000
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 12 Jul 2007 Fixed
Description
Setting the option MAX_QUERY_PARALLELISM did not correctly

control the degree of parallelism used for UNION query processing.



CR:466473
CR Number:   466473
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 01 Feb 2008 Fixed
15.0 04 Mar 2009 Fixed
Description
ODBC applications may not process UPDATE and DELETE commands properly, whenever zero

rows are updated or deleted. ODBC SQLROWCOUNT will be -1 instead of 0 for these two

cases.



CR:466564
CR Number:   466564
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.6 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 10 May 2007 Fixed
12.7 e03 10 May 2007 Fixed
Description
Under certain circumstances, Sybase IQ could produce incorrect results when an HNG index was created on a column of CHAR type and the logical expression of a WHERE clause contained a comparison operator between that column and a string longer than the column width.



CR:466851
CR Number:   466851
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 15 May 2007 Fixed
12.7 27 Apr 2007 Duplicate
12.6 e10 08 May 2007 Added to user documentation
Description
A "Table not found" error is returned if a base table owner is not supplied within a stored procedure that issues a SELECT on the base table and is run by a user who does not own the procedure but has execute permission on the procedure and select permission on the base table.



CR:467394
CR Number:   467394
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 03 May 2007 Duplicate
Description
After a select into a local temporary table returned "ASA Error -1000106: Local temporary table, table1, must be committed in order to create an index", a select, update or drop on the local temporary table caused server failure. Another sequence that caused the same failure: DECLARE LOCAL TEMPORARY TABLE foo (c1 INT);

CREATE foo (c1 INT);



CR:467665
CR Number:   467665
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 2 17 Jan 2008 Fixed
Description
The IQ server fails while trying to resolve a range predicate simplification of the form "a > x OR a > y" where x and y are equal.
Workaround Description
 The workaround is to disable the range predicate simplification:

set temporary option DML_OPTIONS1='2097152';



CR:467981
CR Number:   467981
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 15 May 2007 Fixed
12.6 e10 13 May 2007 Fixed
Description
The IQGOVERN_PRIORITY database option value might not persist

through a database stop and restart. If the IQGOVERN_PRIORITY

and IQGOVERN_MAX_PRIORITY options were set to 1 for the PUBLIC

group, the warning "Option IQgovern_priority has an invalid

setting: 1." was reported on database restart.



CR:468278
CR Number:   468278
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 29 May 2007 Fixed
12.7 e03 29 May 2007 Fixed
Description
An IQ database may fail to start after restoring a

backup that moves the catalog store.



CR:468370
CR Number:   468370
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Windows NT
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 16 Aug 2007 Fixed
Description
Depending on the configuration of your Windows system, when running the "Raw Device Access" or "Sybase IQ Service Manager" server applications, the following error message might have been reported: "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem."



CR:468458
CR Number:   468458
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   AIX
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 1 31 May 2007 Fixed
Description
If you used BCP IN to populate a table owned by a user other than the connected user, then BCP IN would fail with either a table not found error or the server would fail. In some cases, if the connected user also owned a table with the same name as the table being populated, then the server would attempt to add rows to the wrong table.



CR:468769
CR Number:   468769
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e06.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Load table to should compare no. col specified in cmd is same as input file



CR:468975
CR Number:   468975
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Windows 2000
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When '0x5c' is contained in the 2nd byte of a multi-byte character, dbisql cannot output the character to a file correctly. And this issue is reproduced when the character exists in the head of a character sequence.
Workaround Description
 Please change ESCAPE CHARACTER. For example, please specify '!'.



CR:469023
CR Number:   469023
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 24 Jan 2008 Fixed
Description
Changing passwords using the sp_iqpassword procedure fails in ISQL if the VERIFY_PASSWORD_FUNCTION option is enabled.



CR:469093
CR Number:   469093
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 06 Jun 2007 Fixed
12.7 e03 06 Jun 2007 Fixed
12.6 e08 27 Jul 2007 Fixed
Description
In rare circumstances, a busy server executing DROP TABLE statements against local

temporary tables could become unresponsive.



CR:469250
CR Number:   469250
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e10 25 May 2007 Fixed
12.7 e03 23 Oct 2007 Not a Bug
12.6 e10 07 Jun 2007 Added to user documentation
12.7 e03 07 Jun 2007 Added to user documentation
Description
A database created with JAVA ON reported a different error on incorrect dotted references than a database created with JAVA OFF.



CR:469460
CR Number:   469460
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 24 Aug 2008 Fixed
12.7 e02 31 May 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
Using the OUTPUT statement to output an indeterminate result set to a file causes dbisqlc to fail.



CR:469715
CR Number:   469715
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e06.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Adding join to the view decreases performance , optimizer should choose push down instead of customer having to set join_preference = '-5'
Workaround Description
 set join_prerference = '-5'



CR:469926
CR Number:   469926
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 18 Nov 2008 Fixed
12.7 e06 10 Sep 2009 Fixed
Description
A query involving many UNIONs in combination with the SYS.DUMMY table may return

"ASA Error-300" and cause a stack trace.



CR:469940
CR Number:   469940
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2010 Fixed
12.7 e07 02 Jun 2009 Fixed
03 Aug 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Query - Server failure was caused by incorrect logic for handling sort related data structures. Especially, this was a problem with "top n" kind of queries. The problem was not readily reproducible due to the fact that the problem was triggered by a busy temp cache.



CR:469966
CR Number:   469966
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Windows NT
Original Version:   12.6 e07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide option to set AutoPreCommit in the ASA.NET driver



CR:469968
CR Number:   469968
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 15 Jun 2007 Not a Bug
12.6 e11 20 Aug 2008 Fixed
12.7 e03 05 Jul 2007 Fixed
15.0 28 Jan 2008 Fixed
Description
A datatype conversion error was reported when converting a zero length string to DATETIME.



CR:470046
CR Number:   470046
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 07 Oct 2008 Fixed
12.7 e03 1 19 Jun 2007 Fixed
15.0 15 Oct 2008 Fixed
Description
Using UNION ALL to put results from different proxy tables together used the data from the first proxy table to replace the expected data from the other proxy tables used in the query.



CR:470168
CR Number:   470168
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 28 Aug 2008 Fixed
12.6 e11 28 Aug 2008 Fixed
Description
Running the stored procedure sa_get_server_messages()

will probably cause the IQ temporary store to fill up.`



CR:470183
CR Number:   470183
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 24 Oct 2008 Fixed
Description
With certain types of queries, the IQ 12.7 query optimizer simplifies certain query conditions to avoid unnecessary joins and comparisons. In certain GROUP BY operations, a problem was found due to an incomplete elimination of a sort operation.
Workaround Description
 This is a constant equating problem. Use



dml_options5=524288

dml_options3=8388608



Rather than the workaround below.



****************************************************************************



join_preference = -1



If they don't want to set the option public due to performance reasons, use temporary option for a connection scope or use hint syntax for a query only scope:



set temporary option join_preference=-1

...query...

set temporary option join_preference=0



so other connections will not be affected by the loss of performance.



If they need to use the same connection, then modifying the failed query using the syntax:



WHERE (a=b, 'J:-1') AND....



will allow them to avoid sort-merge join only for that query.



CR:470538
CR Number:   470538
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows NT
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 01 Aug 2008 Fixed
12.7 e03 24 Aug 2007 Fixed
Description
"sp_iqindexinfo" returned the wrong value for DBSpPct. It now returns

the correct percent of the dbspace used by the index.



CR:470596
CR Number:   470596
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 03 Nov 2008 Fixed
15.0 03 Nov 2008 Fixed
12.7 e06 23 Feb 2009 Fixed
15.0 03 Mar 2009 Fixed
Description
The IQ server may become unresponsive when the caches are heavily used, e.g., multiple connections are constantly loading to and deleting from tables.



CR:470997
CR Number:   470997
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e06.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide an option to estimate space used by join columns between 2 tables



CR:471000
CR Number:   471000
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2000
Original Version:   12.6 e06
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 18 Aug 2008 Fixed
Description
A delete from a varchar column with a HG index defined could fail with

the message "Key too large" or insert ... location ...could fail with

"Page size selected is too small for this datatype".



CR:471003
CR Number:   471003
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   SunOS
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 28 Dec 2007 Fixed
15.0 21 Jul 2008 Fixed
Description
Executing a "DELETE ... WHERE ROWID(table) BETWEEN ... and ROWID(table) BETWEEN ..." statement could cause a server failure.
Workaround Description
 The problem can be averted by using



set temporary option dml_options3 = 16777216;



CR:471004
CR Number:   471004
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e06.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Other 16 Jul 2007 Not a Bug
Description
sp_iqcolumn truncates column name on the 51st column and after



CR:471075
CR Number:   471075
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2009 Duplicate
12.7 e07 29 Apr 2009 Fixed
12.7 e05.x 06 May 2009 Fixed
12.7 e06.x 20 May 2009 Fixed
15.1 e01 15 Jun 2009 Fixed
12.7 e07 21 May 2009 Fixed
Description
Attempting to return a result set from within a BEGIN ATOMIC

block (this is not allowed) would not close the cursors that

were created for the SELECT. This would cause the server to fail

at st_txncb.cxx line 2822.
Workaround Description
 Not yet.



CR:471237
CR Number:   471237
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A lot of insert queries freezes IQ without an error.
Workaround Description
 Please increase the value of "-mc."



CR:471297
CR Number:   471297
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 3565+ 15 Jan 2008 Fixed
12.6 e11 05 Aug 2008 Fixed
Description
If you execute a query that involves many tables, then there is a chance the query will cause the server to fail. Such failures are more likely with databases that have a smaller page size. This problem has been fixed and the server now properly gives an error when a query with too many table nodes is executed. The error is "-890 Statement size or

complexity exceeds server limits."



CR:471302
CR Number:   471302
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2000
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 10 Dec 2007 Fixed
Description
Index Advisor recommends adding a CMP index on DOUBLE and FLOAT columns, when not all versions of Sybase IQ supports this behavior.



CR:471405
CR Number:   471405
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2000
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 21 Apr 2008 Duplicate
Description
iq_bcp cannot blkin data correctly about the combination of a char type and a datetime type.



CR:472271
CR Number:   472271
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 e01 13 Jul 2009 Fixed
15.2 27 Jul 2009 Fixed
Description
The sp_sproc_columns stored procedure does not return the parameter mode (IN, OUT, or

INOUT). Instead, it returns 0 for all the modes. This has been fixed.



CR:472273
CR Number:   472273
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 05 Dec 2007 Fixed
Description
The procedure sp_iqprocparm() was returning the IN parameter mode for the INOUT parameter for all version of Sybase IQ. sp_iqprocparm() now returns INOUT mode for INOUT parameters.



CR:472435
CR Number:   472435
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 31 Jul 2007 Fixed
15.0 05 Feb 2008 Fixed
Description
A non-fatal error could occur when the number of rows was greater than 2 billion and there was a prefix match in the LIKE predicate through a WORD (WD) index.



CR:472803
CR Number:   472803
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 09 Jul 2007 Fixed
Description
Using the RANK statement returned data in the requested order, but if a WHERE clause was added, the data was sorted differently, ignoring the ordering requested.



CR:473089
CR Number:   473089
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 10 Dec 2007 Fixed
Description
The performance of the sp_iqindex stored procedure degrades as the number of tables increases in Sybase IQ.



CR:473547
CR Number:   473547
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 3480 25 Jan 2008 Fixed
15.0 05 Sep 2008 Fixed
Description
A query that involves more than one Remote Procedure Call in the FROM clause could cause server failure. For example:

SELECT col1 from remote_procedure_1() where col2 = (select c1 from remote_procedure 2())



CR:473728
CR Number:   473728
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2000
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03 1 27 Jul 2007 Fixed
Description
Under certain circumstances, an IQ server could not start with a

freshly created IQ database using a raw partition on Windows.



CR:474007
CR Number:   474007
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 21 Dec 2007 Fixed
Description
Execution of a SELECT statement with invalid syntax causes an IQ server failure

when a period is present, instead of a comma, between two items in a SELECT list in

which the second item is an aggregation function.



CR:474371
CR Number:   474371
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Windows 2000
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2008 Not a Bug
Description
Sybase Central Java and Sybase IQ plugin cannot create dbspace to a windows network drive.



CR:474620
CR Number:   474620
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow a function similar to rowid() for views



CR:474893
CR Number:   474893
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 12 Aug 2008 Fixed
15 Jul 2009 Fixed
12.6 e11 01 Sep 2008 Fixed
Description
Server should return an error instead of hanging, if incorrect data is being passed to the variable in the set command



CR:475766
CR Number:   475766
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e07 08 Jun 2009 Fixed
12.7 e07 22 Jul 2009 Added to user documentation
15.0 e01 10 Jul 2009 Fixed
15.2 28 Sep 2009 Added to user documentation
Description
The NOEXEC database option has been enhanced to support INSERT...VALUE, INSERT...SELECT,

INSERT...LOCATION, SELECT...INTO, LOAD TABLE, UPDATE, TRUNCATE, DELETE, SYNCHRONIZE JOIN

INDEX, and updatable cursor operations.



CR:476329
CR Number:   476329
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Suse
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 07 Jul 2009 Fixed
Description
On a default SLES 10 install, Novell moved the rawctl file from /dev to /dev/raw, and IQ fails to find it until it is either copied into /dev or softlinked in /dev.

Now IQ will look into both /dev and /dev/raw to find the rawctl file.
Workaround Description
 softlink /dev/raw/rawctl to /dev/rawctl



this however would need to be done after every reboot, unless the ln - s is placed into /etc/rc.d/rc.local file.



or:



Change the line in /etc/udev/rules.d/50-udev-default.rules



KERNEL=="rawctl*", NAME="raw/%k", GROUP="disk"

to

KERNEL=="rawctl*", NAME="%k", GROUP="disk"



CR:476496
CR Number:   476496
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide option to find total space used by a particular user



CR:476598
CR Number:   476598
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Windows 2003
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 10 Nov 2008 Fixed
Description
User will be allowed to add columns to existing tables through Sybase Ceneral



CR:477073
CR Number:   477073
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.6 e09.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 31 Jan 2008 Fixed
Description
Subqueries with a simple predicate could show poor performance if the predicate contains a BETWEEN condition in the WHERE clause and not all of the predicate arguments are constants.



CR:477187
CR Number:   477187
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Aug 2007 Consult Complete
Description
Union All parallel query is serial in Subsequent Fetches phase



CR:477501
CR Number:   477501
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide option in Insert...Location to move empty string as empty string



CR:477504
CR Number:   477504
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 10 Dec 2007 Fixed
Description
A query involving a table with a multicolumn primary key joined to another table could cause the following exception in IQ 12.7 ESD #2 on Solaris and Windows: SQLCode = -1006000. This exception occurs when one condition in the join compares a column from the multicolumn primary key with an expression, rather than with a base column from the other table.



CR:477609
CR Number:   477609
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2007 Fixed
Description
Display an error when truncating column name in dbisql -nogui mode



CR:477612
CR Number:   477612
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow user to be able to select view B without the need to grant select permission on the based table in the view A



CR:477741
CR Number:   477741
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2007 Not a Bug
12.7 e04 09 Oct 2007 Added to user documentation
Description
Operations such as INSERT...VALUES, LOAD, and SYNCHRONIZE are not affected by the NOEXEC option because they do not include a query.



CR:477881
CR Number:   477881
Product Name:   IQ
Product Component:   Sybase Central
Status:   Open
OS:   Windows 2000
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If you are using IP aliasing and have started your IQ server with the MyIP tcpip setting set to the alias IP address... for example -x tcpip{MyIP=10.50.7.70;port=6999}

... then if you try and connect from SC to the IQ server using an ODBC data source file (.dsn file), the connection works but you are not able to open the multiplex folder.
Workaround Description
 The work arounds are to either not use a DSN file name to connect , or do not use the MyIP tcpip parameter, or if you have to use the MyIP parameter then also specify the base host IP address.



CR:478439
CR Number:   478439
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The customer is waiting for release of "Multiplex management without Sybase Central."



CR:478486
CR Number:   478486
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 12 Oct 2007 Fixed
15.0 12 Oct 2007 Fixed
12.6 e11 16 Oct 2007 Fixed
Description
Restore fails with "not enough threads" if many stripes are involved in the restore.
Workaround Description
 Set MAX_IQ_THREADS_PER_CONNECTION & MAX_IQ_THREADS_PER_TEAM to a higher value as temporary option prior to doing the restore.



CR:478886
CR Number:   478886
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 31 Jul 2008 Fixed
12.6 e11 06 Nov 2008 Fixed
Description
Subqueries with a simple predicate could show poor performance if the predicate contains a BETWEEN condition in the WHERE clause and not all of the predicate arguments are constants. This has been fixed.



CR:478904
CR Number:   478904
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 10 Jul 2008 Fixed
12.7 e06 22 Oct 2008 Fixed
15.0 e01 02 Dec 2008 Added to user documentation
15.0 e01 02 Dec 2008 Added to user documentation
Description
The maximum length of the string that the SORTKEY function can handle is 254 bytes.

The length limit of 254 bytes is now enforced and a new error message "Function not

supported for the string > 254" is reported.



CR:479443
CR Number:   479443
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 21 Apr 2009 Fixed
12.7 e06 14 Jan 2009 Fixed
12.7 e07 17 Mar 2009 Fixed
Description
When Insert.. Location command was executed between two servers running on different collation, an error was thrown while trying to insert multi-byte characters. This fix handles such issues and inserts multi-byte characters using Insert.. Location.



CR:480255
CR Number:   480255
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Windows XP
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2008 One-off Provided
Description
iq_bcp may be unable to insert the data of the length defined as charactor column. And the data of a succession column cannot be inserted correctly, either. For example, an issue is reproduced on a table with the column of char (50), char (210), and int.



CR:480259
CR Number:   480259
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Windows XP
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2008 Presently Not Targeted For Any Future Release Of This Product
Description
iq_bcp inserts wrong Japanese data. Moreover, it may cause a conversion error.

This issue relates to CR#480255.



CR:480994
CR Number:   480994
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e03.x 25 Sep 2007 Duplicate
Description
IQ server crashed in s_bufhash while trying to do a insert into a temp table



CR:481251
CR Number:   481251
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2008 Consult Complete
Description
execution of cleaner dll provided by eng returns "Invalid expression near rowid"



CR:481616
CR Number:   481616
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 3523 25 Jan 2008 Fixed
Description
If you attempt to revoke connect permissions from a user who still has an externlogin mapped, the server returns a foreign key error. Logging in as the user being dropped then results in incorrect user permissions. The server now returns an error that externlogins are still mapped for the user, leaving the user permissions unchanged.
Workaround Description
 Use 'DROP EXTERNLOGIN', not 'REVOKE CONNECT'.



CR:481633
CR Number:   481633
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Suse
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 3565 05 Dec 2007 Fixed
15.0 26 Dec 2007 Fixed
Description
The following SQL statement could result in a Non-Fatal Internal IQ Error:



select id, fname into #ltt from customer where id = -99;

commit;

create index hg0 on #ltt(id);

savepoint S4;



create index hg2 on #ltt(fname);

drop table #ltt;
Workaround Description
 *** Friday, September 28, 2007 8:20:26 AM *** aldrich ***



Avoid trying to create indexes on columns that don't exist, or let the local temp table drop at disconnect rather than dropping it explicitly.



CR:481648
CR Number:   481648
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 05 Dec 2007 Fixed
12.7 e04 07 Jan 2008 Fixed
15.0 21 Jan 2008 Fixed
15.0 05 Feb 2008 Fixed
Description
A query with a condition containing thousands of OR-ed equalities in the WHERE clause, plus a FROM clause containing a view whose definition had a UNION with numerous arms, takes an excessive amount of time to get through the optimizer.



CR:481807
CR Number:   481807
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2010 Fixed
12.7 e06 21 Jun 2010 Fixed
12.7 e06 02 Dec 2008 Fixed
16 Dec 2008 Fixed
Description
In certain circumstances, using user defined functions as a parameter to a procedure call, may cause a server failure. The following conditions must be true:

- a cursor is opened on a procedure call that returns a result set

- a parameter to the procedure is a user-defined function call

- the UDF issues a COMMIT
Workaround Description
 Nothing yet.



CR:481820
CR Number:   481820
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 19 Aug 2008 Fixed
12.7 e04 07 Dec 2007 Fixed
12.6 e11 01 Sep 2008 Fixed
Description
If a SELECT statement contains proxy tables and a procedure call to a procedure for that server cannot inline the procedure's SELECT statement (the first statement in the procedure

is not a SELECT), the server could fail. This issue could also occur if the SELECT is

used as a subselect in a DML statement. This issue is resolved.



CR:481890
CR Number:   481890
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2007 Duplicate
Description
Server stacktrace when trying to release memory, it is stemming from DestroyCursor.

This appears to be a dupe of cr 466135.



CR:482143
CR Number:   482143
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2007 Consult Complete
Description
Query causes non-fatal stacktrace in dfo_ranking.cxx



CR:482317
CR Number:   482317
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Windows 2003
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e09 19 Nov 2009 Fixed
Description
The Sybase IQ Administration Guide states: "The JDBC-based server classes are the only classes that can be used with 64-bit UNIX IQ servers." An asejdbc class is also supported by Windows x64.



CR:482387
CR Number:   482387
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 3565 07 Jan 2008 Fixed
15.0 3565 19 Dec 2007 Fixed
12.6 e11 31 Mar 2009 Fixed
Description
The server could fail when running queries containing 2000 or more OR-ed equality conditions over a view that contains a many-arm UNION. This has been fixed.



CR:482604
CR Number:   482604
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 10 Dec 2007 Fixed
15.0 08 Jan 2008 Fixed
12.6 e11 02 Sep 2008 Fixed
Description
Attempting to extract a VARBINARY column greater than 255 in length results in

the error "Data exception. Data conversion is not possible."



CR:482705
CR Number:   482705
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 27 Feb 2009 DEFER
15.1 28 Apr 2009 Fixed
Description
systypes view uses allowsnull column instead of allownull



CR:482989
CR Number:   482989
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 03 Sep 2008 Fixed
12.7 e06 17 Dec 2008 Fixed
Description
Sybase central allows a DBA to create a users with a space in the name, but cannot drop them. This is corrected.



CR:482990
CR Number:   482990
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Solaris
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 07 Jan 2009 Fixed
Description
Sybase Central.



User cannot uncheck checkkbox "No default or computed value" on "Column property -> Value panel" , after checking it.



CR:483271
CR Number:   483271
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 09 May 2008 Fixed
12.6 e11 27 Aug 2008 Fixed
12.6 e11 06 Oct 2008 Fixed
Description
sp_iqcheckdb may show leaked blocks for a database on multiplex if the write server is started in read-only mode using the "-r" or "-iqro 1" server startup option. If sp_iqcheckdb does not report leaked blocks if the server is not started for read-only, there are no leaked blocks.



CR:483384
CR Number:   483384
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e07 25 Jun 2009 Fixed
15.1 e01 15 17 Apr 2009 Fixed
03 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
In some situations, a query containing a CASE expression

with a HAVING clause reported Internal error at dfo.cxx

(Cannot evaluate expression).



CR:483417
CR Number:   483417
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 2 31 Jan 2008 Fixed
05 Dec 2007 Presently Not Targeted For Any Future Release Of This Product
Description
In certain circumstances, connections can appear unresponsive while the server returns large strings or binary large objects. This problem is more likely to be encountered when using TDS.



CR:483455
CR Number:   483455
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 20 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date
12.6 e11 15 Sep 2008 Fixed
Description
Under a heavy load, and while another connection is executing DDL statements, calls to a user-defined function could result in a server failure. This issue has been resolved.



CR:483767
CR Number:   483767
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 04 Jan 2008 Fixed
15.0 15 Jan 2008 Fixed
12.7 e04 10 Dec 2007 Added to user documentation
15.0 17 Jan 2008 Duplicate
12.6 e11 09 May 2008 Presently Not Targeted For Any Future Release Of This Product
Description
If character data is extracted to a file when the TEMP_EXTRACT_QUOTES option is ON, the

data cannot be loaded successfully if the data contains quotes. For example, if a column

contains a'b'c, the extract file contains 'a'b'c', which cannot be loaded by the

LOAD statement with QUOTES ON.



CR:483824
CR Number:   483824
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 3565 22 Jan 2008 Fixed
Description
xp_cmdshell fails on IQ 12.7 when iqtc+iqmc is bigger than a certain value. The failure occurs if iqmc+iqtc is large enough for the server to start, but enough memory is not left over for a fork() to execute. This issue varies by the amount of memory on the system and is specific to Solaris.





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