远程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:420853
CR Number:   420853
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2006 Fixed
06 Mar 2006 Fixed
15 Mar 2006 Fixed
16 Mar 2006 Fixed
Description
318 or 2601 error might be returned during ONLINE DATABASE after LOAD DATABASE across platform where endian

type is different, if UPDATE [INDEX|ALL] STATISTICS command was executed on sysstatistics, sysusers or other system

table before the DUMP DATABASE.
Workaround Description
 Before DUMP DATABASE on the source machine,

delete statistics for the system table (ex. sysstatistics) by running:



delete statistics <system table name>

go



CR:420870
CR Number:   420870
Product Name:   Adaptive Server Enterprise
Product Component:   sql
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2006 Fixed
Description
Add Encrpyption Column feature to ase15x on linuxamd64 platform.



CR:420916
CR Number:   420916
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 EC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2006 Fixed
20 Dec 2007 Fixed
Description
The error "Could not find virtual page for logical page 9984 in database 'master'",

with a stack trace which includes the modules like 'log_to_virt', 'virtmap ', 'bufgrab ',

'getpage_with_validation', will be reported if the requested size for master database

is not multiple of size of allocation unit. The similar error will be reported in

case of model database also.



CR:420951
CR Number:   420951
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2006 Fixed
15 Oct 2007 Fixed
Description
CIS: Setting text or image to NULL on a proxy column from an external client

may cause 'remote i/o' hang on the spid.



CR:421002
CR Number:   421002
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2006 Fixed
01 Jun 2006 Presently Not Targeted For Any Future Release Of This Product
Description
If sp_configure is used to change just the server's default sort order

(without changing the server's default character set at the same time),

and before rebooting, a subsequent change is made to nearly any parameter,

then after the reboot the new sort order appears to have taken effect

(according to the errorlog and sp_helpsort) but it doesn't in fact work.



CR:421061
CR Number:   421061
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2006 Fixed
Description
Multi-engine Adaptive Server on non-NT systems may go into an infinite loop, when client tries to connect to one of the ports added with "sp_listener" after bringing engine(s) online anytime after listener was started. Message "nopen: accept, Socket operation on non-socket" may be reported in the error log.



CR:421076
CR Number:   421076
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2006 Fixed
17 Mar 2006 Fixed
17 Mar 2006 Fixed
19 Mar 2006 Fixed
20 Mar 2006 Fixed
Description
After a SELECT-INTO, where encryption is specified on the target table and where the data is generated from a UNION of SELECT statements, a subsequent SELLECT of the data in the target table will generate the error, "Msg 154133, Level 18, State 5, An internal error occurred during an encryption operation (errorcode -1). Please contact Sybase Technical Support".
Workaround Description
 Do the insert as a two-step process:



1. select unioned data into an intermediate temporary table without encryption

2. insert the data from the temporary table into the desired target table containing encrypted columns



For example:



select t1.col1 into #t from t1

union

select t2.col1 from t2

go



select col1

into tresult (col1 encrypt with k1)

from #t

go



CR:421083
CR Number:   421083
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2006 Fixed
30 Oct 2007 Fixed
Description
CIS: The CREATE PROXY_TABLE command on an ASE with Allpages lock scheme will fail with error

msg 1767: "Number of variable length columns exceeds limit of 254 for allpage locked tables.

CREATE TABLE for '<proxy table name>' failed." if the remote table contains more than 254

variable columns.



CR:421084
CR Number:   421084
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2006 Fixed
13 Sep 2006 Fixed
11 Sep 2006 Fixed
06 Dec 2006 Fixed
07 Dec 2006 Fixed
06 Dec 2006 Fixed
Description
The message 2843, "The dynamic statement '%.*s' could not be found. This may be due to insufficient

metadata descriptors. Increase the serverwide '%s' parameter or the '%s' parameter." is incorrectly

raised when multiple spids are running the same LWP in a multi-engine ASE environment.
Workaround Description
 n/a



CR:421127
CR Number:   421127
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 EC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2006 Fixed
Description
During an upgrade in which statistics exist on an encrypted column, there is an inconsistency introduced into the statistics for that encrypted column. This fix will prevent the inconsistency from being introduced in the catalogs, so that queries can correctly complete when referencing the encrypted column.
Workaround Description
 One workaround would be to drop statistics on any encrypted column prior to upgrading, and then recreated the statistics once upgrade is complete



CR:421147
CR Number:   421147
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2006 Fixed
31 Jul 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
CIS: SELECT DISTINCT with a subquery might return duplicate rows if the backend server class is not defined correctly.



CR:421245
CR Number:   421245
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2006 Fixed
Description
If you execute "ALTER DATABASE master" enough times (how many times depends on the server's page size: 146 on a 2k page, more on larger pages), eventually the command will fail and the server connection will be lost. The server's error log will show the process "infected with 11", with an associated stack trace.



CR:421270
CR Number:   421270
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2006 Fixed
Description
An error message "File <filename> already exists. Can not open tracefile." will be reported if "SET TRACEFILE <filename>" command is issued on an existing file.



CR:421325
CR Number:   421325
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2006 Fixed
08 Mar 2006 Fixed
Description
Wrong non-NULL value was generated for an equijoin column

coming from an inner nested left outer join. Example:

SELECT T1.PNO,

T1.PNAME,

T2.PNO,

T3.PNO

FROM PARTS T1

LEFT OUTER JOIN (PARTPRICE T2

LEFT OUTER JOIN SUPPLY T3

ON (T2.PNO = T3.PNO

AND T3.PNO > 'P1'))

ON (T1.PNO = T2.PNO)

T3.PNO may be incorrectly missing NULL substitution.



CR:421330
CR Number:   421330
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2006 Fixed
07 Nov 2006 Fixed
02 Nov 2006 Reservation Made
02 Nov 2006 Reservation Made
19 Jan 2007 Fixed
24 Jun 2009 Not a Bug
04 Apr 2007 Fixed
13 Nov 2006 Fixed
Description
Add new builtin reserve_identity("table_name", size), allowing a process

to grab a group of identity values reserved for that process.



CR:421374
CR Number:   421374
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2006 Fixed
02 Jun 2006 Duplicate
Description
Adaptive Server Enterprise erroneously reports that license usage is in overdraft when an uncounted license is served from a License Server.



CR:421381
CR Number:   421381
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2006 Presently Not Targeted For Any Future Release Of This Product
Description
Customer would like the srvbuild GUI to automatically change the sysproc.dat size when the page size is changed, srvbuild does this for the rest of the DBs that it defines.



CR:421527
CR Number:   421527
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2006 Fixed
Description
When run xmlextract() functions, got empty results.



CR:421547
CR Number:   421547
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2006 Fixed
Description
A client prepare statement including multiple SQL commands may not be completley executed

if at least one of SQL commands is using TEXT or IMAGE host variables and

the statement cache is active on the server.
Workaround Description
 send UPDATE is a separate batch.



CR:421573
CR Number:   421573
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2006 Fixed
Description
Update the installmaster script to address the following issues:



jConnect: The column names used to describe ResultSet MetaData do not conform to the JDBC specifications. [CR 419579]

sqlupgrade: Errors encountered when installing system stored procedures in Japanese environment. [CR 418053]

jConnect: Request to support getDatabaseMajorVersion(), getDatabaseMinorVersion(), getJDBCMajorVersion() and getJDBCMinorVersion() functions on the DatabaseMetaData class. [CR 416759]



CR:421607
CR Number:   421607
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2008 Fixed
12 Feb 2008 Fixed
01 May 2008 Fixed
14 Feb 2008 Reservation Made
Description
More efficient mergejoin/hashjoin plan might not be possible for MATCHNULL equijoin query. This includes the sybase extended column syntax query and the MATCHNULL join predicate coming from the predicate transformation on "r.a = s.a OR (r.a IS NULL and s.a IS NULL)".



CR:421660
CR Number:   421660
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2006 Fixed
30 May 2006 Fixed
Description
On platforms other than Intel/AMD, inserting data to a fixed-length

unichar column that is shorter than the actual length of the column,

and where the unichar column is not aligned on a 2-byte boundary in

the page may cause the process to terminate with a bus error.
Workaround Description
 Avoid schema where fixed length unichar columns fall on odd byte boundaries.

For example, instead of declaring a table with columns: int, char(3), unichar(50),

use char(4) instead. Alternatively, use univarchar instead of unichar.



CR:421900
CR Number:   421900
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2007 Fixed
Description
Cannot setup a license server to serve ASE Security and Directory Services license for both ASE 12.5.x and 15.0.x versions. This both releases use the same package name (ASE_SECDIR), but different package definitions.
Workaround Description
 Setup two different license servers - one for ASE 12.5.x licenses and another one for ASE 15.0.x licenses.



CR:421934
CR Number:   421934
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 May 2006 Fixed
Description
In the "Login Password Configuration" tab for the server properties dialog, the "disallow simple passwords" and "expire login" binary options in configuration list can be assigned values. With this change, these 2 binary options are no longer editable.



CR:422003
CR Number:   422003
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2006 Fixed
26 Feb 2006 Fixed
28 Feb 2006 Fixed
Description
A SELECT statement using a LIKE clause with NULL variables returns Msg 712.
Workaround Description
 Turn on traceflag 15304.



CR:422051
CR Number:   422051
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2006 Fixed
03 Mar 2006 Fixed
Description
A query involving a semantic partitioned table will do a non-covered index scan of a non-clustered index, when it appears that the query can do a covered scan. This is because the query adds all partitioning columns of the underlying table, which can make the scan non-covered if the partitioning columns are not present in the nonclustered index. This problem has been fixed in the CR such that the partitioning columns are added only for the duration of partition elimination, but not to the actual query.



CR:422089
CR Number:   422089
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2006 Fixed
02 Mar 2006 Fixed
02 Mar 2006 Fixed
16 Mar 2006 Fixed
Description
BCP IN fails when the table has an encrypted column and a Java abstract data type (ADT) defined in it.



CR:422177
CR Number:   422177
Product Name:   System Admin Guide
Product Component:   System Administration Guide
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2006 Not a Bug
Description
JNDILocalName (com.sybase.jaguar.component.local.bind.name) property is set as sybase-easerver-config.xml file, and can be used.



CR:422191
CR Number:   422191
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   Windows XP
Original Version:   ulysses
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Fixed
Description
Whenever a XML model (XSM)contain external shortcut to reference other model's

items, XML model will create a logical item without symbol.

However, it is reported that this external shortcut will affect the items

ordering of the XML Model in PD12, PD11 and PD10
Workaround Description
 Not accepted by customer: Declare the external shortcut at the end of the item list. However, it is not possible to delete the existing problematic shortcut as it may refered by many Elements , Attributes etc. Thus all the refering linkage need to be rebuilded.



CR:422244
CR Number:   422244
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2006 Not a Bug
Description
We take job scheduler down with sp_js_wakeup "stop_js",1 command. However, job scheduler comes back up automatically with server restart.



I hope you can appreciate my point: if I've explicitly told job

scheduler to go down, I think it's reasonable to expect it to stay down

until told otherwise.



CR:422259
CR Number:   422259
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Fixed
17 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
17 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Query with union in view using DOL worktable for view materialization

may sometimes return incorrect results.



CR:422281
CR Number:   422281
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2006 Fixed
18 Jul 2006 Fixed
12 Jul 2006 Fixed
Description
Reformatting may not be selected as the best plan if you run a self-join query.

It may cause performance drop after upgrading from pre-15.



CR:422296
CR Number:   422296
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2006 Fixed
Description
Enable LDAP User Authentication feature on hpia64 platform



CR:422303
CR Number:   422303
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   Windows XP
Original Version:   ulysses
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2006 Fixed
16 Nov 2006 Fixed
Description
In XML model of PD10, "shortcut" items (element, attribute), which reference

a Namespace's item , is still allow to map to OOM or PDM item.

However, in XML model of PD12, the "Mapping" Tab of items will disappear as

long as it become a "shortcut" by defining the "reference" property.



CR:422355
CR Number:   422355
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2006 Fixed
30 Mar 2006 Fixed
Description
When using the monDeadLock MDA table and a process executing a stored procedure or trigger is involved in a deadlock, the monDeadLock table HeldProcDBID and HeldProcedureID columns do not report the DBID and Object ID of the stored procedure or trigger.



CR:422375
CR Number:   422375
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2006 Fixed
Description
The expensive Lava operators (hash, sort, store (for reformat)) have been

limited to a configurable percentage of tempdb's pagesize buffer pool.

This percentage is controlled through the "max resource granularity" configuration

option. This value defaults to 10%. Before this checkin, each instance of

these operators could keep upto 50% of the MRU area of the pagesize buffer pool.



CR:422381
CR Number:   422381
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Windows XP
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2006 Fixed
Description
ASE Plug-in used to selectively display information/warning messages even if user has selected "Show informational and warning messages". This has been corrected.



CR:422388
CR Number:   422388
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2006 Fixed
Description
During normal shutdown, the server only flushes free space counts from the first disk fragment of a database back to master.dbo.sysusages. Upon subsequent reboot, this causes the database disk map to have incorrect free space counts on all but the first fragment.
Workaround Description
 1. between reboots run dbcc usedextents(<dbid>, 0, 1, 1) This can be used to temporarily correct sp_helpdb output.

2. Use sp_spaceused to get database usage.



CR:422423
CR Number:   422423
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2006 Fixed
Description
Fixes parsing issue with server name entry of style "ipv6 mac adress:port no".



CR:422434
CR Number:   422434
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.3.a
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2006 Fixed
03 Mar 2006 Fixed
29 Mar 2006 Fixed
13 Apr 2006 One-off Provided
13 Apr 2006 One-off Provided
26 Mar 2006 Fixed
Description
When trying to parse large XML documents, ~3MB+, ASE will hit the 712 'insufficient heap memory' error.
Workaround Description
 None exists



CR:422444
CR Number:   422444
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2006 Fixed
Description
Enable Encrypted Column feature on Solaris AMD Opteron 64bit platform



CR:422466
CR Number:   422466
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2006 Fixed
17 Jan 2007 Fixed
15 Nov 2007 Fixed
Description
An undetected deadlock may occur when the database option 'ddl-in-tran' is active

and session 1 executes DDL and/or DML commands while session 2 is interested in

printing the execution plan for session 1 through SP_SHOWPLAN.



CR:422537
CR Number:   422537
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2006 Fixed
Description
If the generic form of a join is specified in an Abstract Plan using the "join" keyword, and the tables specified in the forced plan violates outer join semantics in the "from" list in the query, the query could return wrong results. Note that a work around was to specify the specific join, for example "nl_join" for a nested loops join.



CR:422673
CR Number:   422673
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2006 Fixed
13 Mar 2006 Fixed
12 Apr 2006 Fixed
Description
In rare circumstances, an 822 error, "Could not start I/O for request BLKIO flags..." or other recovery-related error may be reported during the failover of a primary server to a secondary server in an HA environment.
Workaround Description
 N/A



CR:422674
CR Number:   422674
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2006 Fixed
Description
A SELECT from a proxy table mapped to an RPC will abort the entire transaction if the RPC returns a status of 0.



CR:422715
CR Number:   422715
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2006 Fixed
03 Apr 2006 Reservation Made
Description
When large quantities of memory is allocated, from procedure cache,

for a single query, performance may be affected adversely due to lengthy

chains.



CR:422719
CR Number:   422719
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2006 Fixed
Description
set option show_missing_stats on



will print some spurious multi-attribute sets that cannot be corrected by update statistics

e.g. references to the "Rid" attribute, as well as references to BIT, IMAGE, TEXT attributes that cannot be placed in update statistics commands



this fix will limit the hints provided by the tracing to just those that can be corrected by update statistics



CR:422771
CR Number:   422771
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2007 Fixed
03 Jan 2007 Presently Not Targeted For Any Future Release Of This Product
20 Nov 2006 Fixed
13 Feb 2007 Fixed
Description
Request for an option to return the data in encrypted form for the encrypted columns - in case the caller does not have decrypt permission.



CR:422779
CR Number:   422779
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2006 Fixed
11 Oct 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
CIS: TSQL outer join query on proxy tables may return wrong result when part of the query (such as the search clause) is not forwarded by CIS to the remote for execution.
Workaround Description
 Remove the select into or use ANSI outer joins.

Also, try traceflag 11210, 11298



CR:422805
CR Number:   422805
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Fixed
Description
The statistics displayed when SET STATISTICS IO is enabled will incorrectly be null on any table that has a trigger.



CR:422809
CR Number:   422809
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2006 Fixed
08 Mar 2006 Fixed
Description
The message 'current process infected with 11' in the module db_ekey_in_use maybe reported in the errorlog when dropping a database if there exists an archive database that has not been loaded yet.



CR:422860
CR Number:   422860
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2006 Fixed
20 Mar 2006 Fixed
20 Mar 2006 Fixed
Description
Listing the tables in the FROM clause in a different order

could result in a very different query plan, sometimes a very bad

performing query plan.
Workaround Description
 change the order of the tables in the "from" clause or use AP



CR:422867
CR Number:   422867
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2006 Fixed
Description
The error 3208, "Unexpected end of file while reading beginning of dump" will be raised when an archive database device is unavailable.



CR:422869
CR Number:   422869
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2006 Fixed
Description
If an execute insensitive scrollable cursor is executed again, error 3806

"Both the READ ONLY and the FOR UPDATE options have been specified for cursor"

might be raised.



CR:422966
CR Number:   422966
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2006 Bundled Request
Description
Queries containing hash operators with large estimated input sets could

consume significant portions of the procedure cache and spend significant

amounts of CPU time in memalloc() (as seen from sybmon stack dumps).

This was the result of extraordinarily long subordinate PROC_HDR chains

where the subordinate PROC_HDR is effectively empty (as seen from sybmon

"procmem prphdr <main_phdr_address verbose" command). This has been fixed

by freeing and recreating the PROC_HDR as processing proceeds from one input

set to the next. Sessions in this state can significantly impact overall

system performance.



CR:423035
CR Number:   423035
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2006 Fixed
Description
Update Statistics Wizard's first page contains a list of table columns and their types. The column types are now displaying correctly.



CR:423070
CR Number:   423070
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2006 Fixed
08 Mar 2006 Fixed
08 Mar 2006 Reservation Made
15 Mar 2006 Fixed
Description
Corrects a performance issue with IN lists



If a table t1 has an index i1 on columns (a1,a2,a3) and multiple IN lists are defined e.g.



select * from t1 where a1 in (1,2) and a2 in (10,11) and a3 in (100,101)



the optimizer would only consider costing subsequent IN lists if the previous IN lists were reasonably selective. The change is to cost all IN lists, since strongly selective IN list can follow weak IN in lists, and then determine whether to avoid some less significant IN lists due to poor selectivity.



CR:423158
CR Number:   423158
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2006 Fixed
Description
The "quiesce database" status for temporary databases, as shown by the sp_helpdb

stored procedure, may unexpectedly survive a server re-start.
Workaround Description
 Re-execute a full quiesce database sequence :



quiesce database test_quiesce hold tempdb

quiesce database test_quiesce release



CR:423209
CR Number:   423209
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2006 Fixed
29 Mar 2006 Fixed
05 Apr 2006 Fixed
Description
Backup Server error 4.141.2.36:[23] "The 'read' call failed for device 'device_name'

with error number 14 (Bad address). Refer to your operating system documentation for

further details." or error 4.139.2.22: [105] "The 'uncompress' call failed for device

'device_name' with error number 0 (Error 0)." is returned, when a database dump file

that was generated with 'with compression=<compression_level>' clause is loaded

across platform.
Workaround Description
 Use old compression syntax (backup api syntax), like,

dump database pubs2 to 'compress::9::/....'



CR:423244
CR Number:   423244
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2006 Fixed
29 Mar 2006 Fixed
Description
In extremely rare situations, recovery of the current database page timestamp can result

in a value a few increments lower than in specified behavior. The practical impact is

virtually nil, and any theoretical problem quickly resolves after a few new runtime

updates.



CR:423251
CR Number:   423251
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2006 Fixed
Description
When ASE dataserver is configured for High Availability on Sun Cluster, it may not release

database devices during failover if PID of dataserver process(es) is not removed.
Workaround Description
 Manually restart primary ASE and make sure it is in a consistent state.



CR:423253
CR Number:   423253
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2006 Fixed
08 Mar 2007 Fixed
20 Mar 2007 Fixed
20 Mar 2007 Fixed
Description
On Solaris, if ASE is configured for HighAvailability on SunCluster, the HA agent ase_monitor will initiate failover if it fails to run various SQL commands as part of thorough probe, though the error is a transient one such as no space in tempdb.
Target Version
 15.0.2



CR:423255
CR Number:   423255
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   RH Linux
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2006 Fixed
Description
Previously, the Input Wizard could crash if you double-clicked the "Finish" button. You could see this problem if your computer was busy when the "Finish" button was clicked. You could run into a similiar problem with the "Next" button if the table into which you were importing was locked and the "blocking" option was "on". This has been fixed as follows: The Wizard controls now prevent you from operating any control on the Wizard while it is busy interacting with the database. This prevents the crash.



CR:423313
CR Number:   423313
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   11.5.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customers would like the ability to enable auditing without having to reboot the ase. An extension to sp_audit "restart" would probably be best if we could allow it to work for newly configured installations as well as exisitng installations where the audit process has just died.



CR:423347
CR Number:   423347
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2006 Fixed
09 Mar 2006 Fixed
Description
While running dbcc upgrade_object() and a syntax error in the source text is found,

Msg. 11031 is raised. At the same time the error 'Invalid pointer

param number 4, pointer value 0x3' .*s invalid pointer param number 6, pointer value 0x2' is also

raised.
Workaround Description
 update sysmessages manually.



CR:423371
CR Number:   423371
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2006 Fixed
Description
Previously certain ASE Plug-in icons such as Indexes appeared cut-off. This has been corrected.



CR:423374
CR Number:   423374
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Commands
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2006 Fixed
Description
The Commands Reference Vol 2 entry on CREATE TABLE still contains an reference to an old limit of 250 columns per table. The limit is actually 1024.



CR:423383
CR Number:   423383
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2006 Fixed
15 Mar 2006 Fixed
Description
Queries involving inner tables of an outer join query with predicates of =NULL returns wrong results. An example of such a query would be:

select 1 from r left join s on r.a = s.a where s.a = NULL



CR:423395
CR Number:   423395
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2006 Fixed
Description
When an ANSI outer join query has an equi-join in the ON clause and

one of the equi-join columns also has "col=<ct>" in the WHERE clause,

the optimizer will not consider using the MergeJoin algorithm,

although it's legal under these circumstances.



CR:423396
CR Number:   423396
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2008 Fixed
21 May 2008 Fixed
Description
DBISQL now allows user to change password if the login's password has expired.



CR:423428
CR Number:   423428
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2006 Fixed
31 May 2006 Fixed
Description
The message "current process...infected with 11" may be reported in module

"collocate" when a session runs a subquery whose execution requires a work

table to be sorted in parallel by ASE. The modules "psort_producer", "subst"

and "subconst" will be reported also in the error log.
Workaround Description
 forcel serial execution of queries at the server or session level.



CR:423441
CR Number:   423441
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   RH Linux
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2006 Fixed
02 Apr 2006 Fixed
21 Mar 2006 Fixed
02 Apr 2006 Fixed
Description
On IBM Power Linux platform, stacktrace does not report all the functions on the stack.



CR:423509
CR Number:   423509
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2006 Fixed
Description
sp_helpdevice displays devices ordered by device name, and shows free space for unused devices.



CR:423530
CR Number:   423530
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2006 Presently Not Targeted For Any Future Release Of This Product
30 May 2006 Fixed
Description
A connection using LDAP authentication retains a lock

on syslogins while waiting for the LDAP server to respond,

which causes sp_addlogin to hang



CR:423559
CR Number:   423559
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2007 Fixed
15 Feb 2007 Fixed
Description
Increase limit of message parameter in syb_sendmsg TSQL function from 255 characters in length.



CR:423575
CR Number:   423575
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2006 Fixed
15 Mar 2006 Fixed
20 Mar 2006 Fixed
Description
A 625 error may be reported by sp_post_xpload if a user table is updated before index is rebuilt

manually or by sp_post_xpload, and after a database dump has been loaded across platform

and brought online.
Workaround Description
 (1)Do not run any DML on user table before sp_post_xpload.

There is no guarantee that such a DML succeeds. Indexes on user table may be in a corrupted state

after XPDL-DA. (Wrong ordering in the RID part in index, known CR 346317.)



or



(2)Run sp_post_xpload under a trace flag 3199,

for example,



dbcc traceon(3199)

go

sp_post_xpload

go

dbcc traceoff(3199)

go



CR:423583
CR Number:   423583
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2006 Fixed
13 Mar 2006 Fixed
21 Mar 2006 Fixed
Description
A UNION query such as: select a from x where 1=2 union select b from y, which contains a

predicate that is always false (in this case 1=2) in the first SELECT of the UNION may not

return all of the rows of the result set if the query plan chosen by the optimizer contains

a hash-based UNION operation. The presence of the hash-based UNION operation in the query

plan is shown in showplan by the line: HASH UNION Operator.
Target Version
 15.0 ESD#2
Workaround Description
 Use the command: set hash_union_distinct 0, to disable hash-based UNION operations.



CR:423674
CR Number:   423674
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.1 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
On the HP Tru64 unix platform, ASE stacktraces sometimes show erroneous symbol references
Workaround Description
 Obtain the correct libbtsymbols.so for the exact ASE version being run



CR:423748
CR Number:   423748
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2006 Fixed
Description
Previously when user right-clicked a table, "Edit..." menu item was missing. This has beeen added so that user can edit the table using Table Editor.



CR:423783
CR Number:   423783
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Fixed
Description
Attempting "LOAD DATABASE master" from a dump where the disk map in the dump does not exactly match the disk map in the target server can cause ASE to encounter a page read error, which it reports as error: 695, state: 1. This causes the load to fail.



CR:423796
CR Number:   423796
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2006 Fixed
21 Mar 2006 Fixed
Description
When importing statistics in simulate mode resulted in some selectivities to be out of bound thereby causing poorer plans.



CR:423806
CR Number:   423806
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Duplicate
16 Mar 2006 Fixed
Description
Wrong results produced when selecting from a table that is list partitioned and the WHERE clause of the SELECT statement has a BETWEEN predicate on a column that is not the partitioning key.



CR:423836
CR Number:   423836
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2006 Fixed
15 Mar 2006 Fixed
13 Mar 2006 Fixed
Description
CIS: When retrieving IMAGE data, ASE may encounter a SEGV in routines omni_rly_row() and memallocheap().



CR:423852
CR Number:   423852
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2006 Fixed
Description
The stored procedure sp_who "spid" will return 0 rows when the parameter spid belongs to

a user with negative suid.
Workaround Description
 *** Friday, March 10, 2006 10:20:07 AM *** cooperg ***

Chnage the code from '@low = 0' to '@low = @@minsuid'



CR:423878
CR Number:   423878
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2007 Fixed
11 Apr 2006 Fixed
14 Nov 2007 Fixed
13 Nov 2007 Reservation Made
15.0.2 ESD#3 28 Nov 2007 Fixed
Description
Queries on range partitioned tables that contain range predicates that can become SARGs and

that contain unknown constants at compile time (i.e. local variables or substituted columns

of a join clause) can be used to eliminate scans of some of the partitons of the table based

upon the runtime values of the constants. For example:



create table t1 (c1 int, c2 int) partition by range (c1) (p1 values <= (50), p2 values <= (100))

declare @v1 int

set @v1 = 49

select * from t1 where c1 < @v1



The select statement contains a range predicate (c1 < @v1) that is unknown at compile time.

This predicate will be used at the beginning of execution of this statement, when the

value of @v1 is known, to determine

which partitions of t1 could possibly contain qualifying rows, and will cause the

elimination of the partition, p2 from the scan of t1 because its values of c1 are all

greater than 49.



CR:423902
CR Number:   423902
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2006 Fixed
15 Mar 2006 Fixed
21 Mar 2006 Fixed
Description
All partitions can be eliminated in queries against a partitioned table that is list partitioned and contains queries that has a predicate on the partitioned key that is used to eliminate partitions. The predicate must be composed of a BETWEEN clause on the partitioned key AND another predicate on the partitioned key that selects ONLY the partitions that would be selected by the BETWEEN predicate.



CR:423913
CR Number:   423913
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2006 Fixed
Description
Update table statistics command is enhanced to enable generation

of systabstats statistics for an index or an index partition.



CR:423930
CR Number:   423930
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Fixed
15 Mar 2006 Fixed
17 Mar 2006 Fixed
Description
In rare circumstances, column data may not be translated if more than 127 contiguous columns data

are non-null values and all the columns require translation and all translation type is same length,

when database dump file is loaded across platform.



CR:423931
CR Number:   423931
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2006 Fixed
Description
DBCC CHECKTABLE may fail to report error 2510: "Key mismatch between index page <index pno>,

partition ID <ptnid>; at offset <indoffset>; and data page <data pno> (row ID <rnum>), partition ID

<ptnid>. Drop and re-create index ID <indid> of table '<tabname>' in database '<dbname>'." and

abort silently, or return "Invalid parameter" error with 2510 error message.



CR:423962
CR Number:   423962
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2006 Bundled Request
15 Mar 2006 Bundled Request
23 Mar 2006 Bundled Request
Description
If one element of the xml document contains attribute and text child, then the stack trace would be thrown out randomly.
Workaround Description
 NONE



CR:423975
CR Number:   423975
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2006 Fixed
Description
Enable LDAP User Authentication feature on Solaris Opteron 64bit platform



CR:424130
CR Number:   424130
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2006 Fixed
23 Mar 2006 Fixed
23 Mar 2006 Fixed
Description
Conversion errors, error code 257, raised during optimization when there is a constant expression in the WHERE clause of a SELECT statement. These constant expressions involved VARCHAR data types.
Workaround Description
 Use boot time trace flag -T306 or delete the related statistics



CR:424132
CR Number:   424132
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2006 Fixed
11 Apr 2006 Fixed
05 Apr 2006 Fixed
02 Jun 2006 Bundled Request
22 Jun 2006 Fixed
22 Jun 2006 Fixed
Description
Increased size of sybsystemprocs database from 120MB to 132 MB.



CR:424170
CR Number:   424170
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Fixed
28 Apr 2006 Fixed
Description
Create unique local index on range/list/hash partitioned table should be allowed even when the index key list sequence is not the same as that of partition key, as long as the partition key list is a subset of index key list



CR:424173
CR Number:   424173
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.3 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2006 Fixed
23 Mar 2006 Fixed
Description
CIS: If at compile time, a remote server's capabilities are already available, then avoid connecting to the remote server during compilation.



CR:424174
CR Number:   424174
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0.1 16 Mar 2006 Fixed
15.0.1 10 Apr 2006 Fixed
Description
Enable JS feature on linuxamd64 platform.



CR:424176
CR Number:   424176
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2006 Fixed
Description
Enable LDAP User Authentication feature on Linux Opteron 64bit platform



CR:424188
CR Number:   424188
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2006 Fixed
Description
When command-line trace flag -T450 is set, queries involving a group-by

clause (and having 32 or less distinct group-by columns) will have a

predicable ordering similar to that of ASE 12.5.x. Namely, in the absence

of an explicit order-by clause, ordering will be that of the group-by columns.



CR:424268
CR Number:   424268
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2006 Fixed
Description
Excessive compilation time when there are a lot of range or list partitions in the

joining relation(s).



CR:424281
CR Number:   424281
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2006 Fixed
22 Mar 2006 Fixed
04 May 2006 Fixed
Description
This fix is to update logic of counting physical processors considering the introduction of CMP and CMT capable processors.





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