远程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:551758
CR Number:   551758
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2009 Fixed
Description
When advanced_aggregation is on (e.g. under allrows_dss optgoal),

signall 11 and stacktrace could happen in GtcChildOptBlockN::GtHasCorrelatedChildOb()

for an aggregate over a union view/derived table under correlated subquery.
Workaround Description
 set advanced_aggregation off



CR:551765
CR Number:   551765
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2009 Fixed
16 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Executing a query with group by all on nullable columns may get wrong result in the presence of NULL values.
Workaround Description
 Enabling compatibility mode either through



sp_configure 'enable compatibility mode', 1



or



set compatibility_mode on



CR:551783
CR Number:   551783
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   HP-UNIX
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2008 Fixed
Description
Installer crashed after in email alert panel and choose NOT to configure email alert if the machine cannot ping through hostname smtp.
Workaround Description
 In /etc/hosts, add a new line with content "127.0.0.1 smtp"



CR:551804
CR Number:   551804
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2009 Fixed
20 May 2009 Fixed
16 Jun 2010 One-off Provided
01 Jul 2009 Presently Not Targeted For Any Future Release Of This Product
22 Feb 2010 One-off Provided
Description
A 638 error, "Memmove() was called with an address of <hexadecimal address>- which is not allocated memory" maybe be reported when diagnostic server is used or random stacktraces indicating some plan corruption when normal server is used may be reported when a stored procedure containing a SELECT UNION ALL with a CONVERT() to TEXT function is executed by several sessions.
Workaround Description
 Execute "with recompile" or create "with recompile" the problematic

procedure containing SELECT UNION ALL and CONVERT(TEXT,...)



CR:551821
CR Number:   551821
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2009 Fixed
Description
In some circumstances during failover recovery in a shared disk cluster,

some transactions may be unnecessarily blocked until the end of the recovery

redo pass before being able to proceed.



CR:551825
CR Number:   551825
Product Name:   ASE Generic docs
Product Component:   Adaptive Server New Features Guide
Status:   Closed
OS:   NA
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2009 Added to user documentation
Description
doc: clarify sp_helptext usage with sp_showtext



CR:551875
CR Number:   551875
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Oct 2009 Fixed
Description
UPDATE on an Oracle DATE column results in error 1843 when both the configuration option

'enable literal autoparam' and 'statement cache size' are set.
Workaround Description
 enable literal autoparam = 0

or

statement cache size = 0

or

use a valid format recognized by Oracle, eg. 'Feb 12 2008' instead of '20081202'



CR:551877
CR Number:   551877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2009 Fixed
Description
Static compile time partition elimination does not happen when queries in stored procedures have predicates that refer to local variables or parameters passed to it.



CR:551887
CR Number:   551887
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Apr 2009 Fixed
24 Apr 2009 Fixed
Description
The sybmon plancost command has been enhanced to dump

sort operator's estimated and actual input set sizes.

This is needed to validate the sort operator's cost

model.

The " Average Row width is %f " message has been removed from

the sort op's showplan output. The message was misleading as it

was actually the "estimated average row width" and of very little

use without the estimated cardinality and the actual row counts and

average input set row size.



CR:551899
CR Number:   551899
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 2008 Fixed
Description
Iofenceutil don't print any message if there is no pass-through DSF created for a given device.
Workaround Description
 Create the pass-through device special file for a specific device before running iofenceutil. In the above example, the pass-through device file /dev/raw/raw# for the device "/dev/rdsk/c5t1d0" should be created before running the utility "iofenceutil".



CR:551908
CR Number:   551908
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Release Bulletin for HP
Status:   Closed
OS:   HP-UX
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2008 Fixed
Description
On HPIA platform, the pass-through device special file for a specific device should be created to work with IO fencing. If there is no corresponding pass-through device special file under /dev/raw for a device, iofenceutil will not print any message for this device. For example, if there is no corresponding device special file for the device "/dev/rdsk/c5t1d0", there will be no output after executing the command

# iofenceutil /dev/rdsk/c5t1d0



Workaround:

Create the pass-through device special file for a specific device before running iofenceutil. In the above example, the pass-through device file /dev/raw/raw# for the device "/dev/rdsk/c5t1d0" should be created before running the utility "iofenceutil".



CR:551928
CR Number:   551928
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   all
Original Version:   closluce
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2009 Fixed
Description
OOM > XSM

Primary attributes that get migrated have no type defined in generated XSM element.

Check Model returns an 'Undefined Type' error.



CR:551958
CR Number:   551958
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The current query optimization does approximate predicate filtering by dropping ANDs under ORs but does not look for ORs under ANDs which are under ORs.
Workaround Description
 Specify redundant ORs to make it easier for ASE to isolation the ORs under current coding.

e.g.



( (dm_document.r_lock_owner='perfuser2') or

(dm_document.owner_name='perfuser2') or

(dm_document.r_modifier='perfuser2')

)

AND ... the rest of the where clause



CR:551969
CR Number:   551969
Product Name:   Adaptive Server Generic Docs
Product Component:   Java in Adaptive Server Enterprise
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2009 Added to user documentation
Description
Windows specific syntax for working directory permission mask and File I/O file open rules are missing from the 15.0.3 Java Book



CR:551972
CR Number:   551972
Product Name:   Adaptive Server Enterprise
Product Component:   JVM
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2009 Workaround
Description
Due to an HP bug, file create using Java in Database feature fails unless working directory

permission mask is set to 0777 equivalent. This requires mask to be set to rwx, for example:

sp_jreconfig "add", "work_dir", "/some/path(ugo+rwx)"
Workaround Description
 On HP (HPIA and HPPA) only



When a trusted/working directory is configured in the sybpcidb configuration properties,

specifically the property: pca_jvm_work_dir a bug on HP prevents files from being created

unless the mask applied to the JVM work_dir is set to 0777. This does not have anything

to do with the physical directory permission in the file system. The physical directory

can have whatever permissions mask that is appropriate. This is only in the sybpcidb config properties

where a DBA can configure a working directory with a mask (or filter) that allows or prevents

certain actions from within the JVM. The file system will always have the last word, so even if the

JVM allows an action to pass through such as a file create, the file system can still prevent it

if the physical directory permissions does not allow it.



The mask is applied to a working directory through either of two stored procedure commands

with the sp_jreconfig stored procedure. It can be applied when a directory is added through

the 'add' command, or when a directory is updated or modified with the 'update' command.

As you can see in the following two examples, the directory mask is defined in parentheses

at the end of the directory location.



sp_jreconfig 'add', pca_jvm_work_dir, '/some/path(ugo=rwx)'

sp_jreconfig 'update', pca_jvm_work_dir, '/old/path', '/new/path(ugo=rwx)'





On HP, a work_dir will need to be configured as shown in these examples, so it effectively

has a 0777 mask (user, group and other are all set to rwx) in order for any Java code in a

class running within the ASE to be able to create a new file in that directory location.

This only affects HP and it only affects the creation of new files. Opening files for

read or write works as it should, and only the expected permissions are required.



CR:552026
CR Number:   552026
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Solaris
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2009 Fixed
15 Jul 2009 Fixed
Description
The Historical Server Monitor process memory usage keeps growing while recording a session.
Workaround Description
 Restart the Historical Server process.



CR:552042
CR Number:   552042
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2009 Fixed
Description
There are multiple errors that the server runs into like 12301, 12308 etc where a task

finds that the index and data row are inconsistent or an invalid row id is encountered

in the table.



CR:552075
CR Number:   552075
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2009 Fixed
11 Mar 2009 Added to user documentation
Description
sp_lock does not show instance id in the output.



CR:552102
CR Number:   552102
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2008 Fixed
18 Feb 2009 Fixed
Description
The default configuration value for the pca_jvm_module_path do not match the directory structure. This specifically refers to the platform specific sub-directory under $SYBASE/shared where the JRE is located.



CR:552106
CR Number:   552106
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2008 Fixed
18 Feb 2009 Fixed
Description
Executing the stored procedures sp_jreconfig() or sp_pciconfig() can result in a stacktrace

reported in the ASE -errorlog which contains the modules 'dispatchpca', 'pca_get_config_value' and

'pci_command'.



CR:552108
CR Number:   552108
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2009 Not a Bug
21 Jun 2009 Fixed
04 Jun 2014 Fixed
03 Jul 2009 Presently Not Targeted For Any Future Release Of This Product
05 Jul 2009 Presently Not Targeted For Any Future Release Of This Product
Description
In fast bcp insert behavior, if an index has a long dups lists for each unique key or its key is in order, there exist unnecessary index search.



CR:552155
CR Number:   552155
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2009 Workaround
Description
Error 3307 due concurrency on column 'logincount' on syslogins when "maximum failed logins" has a value > 0
Workaround Description
 Workaround 1:

sp_configure "allow updates", 1

update syslogins set logincount = 0

sp_configure "allow updates", 1



Workaround 2:

keep "maximum failed logins" at 0 or don't forgot to change scripts after changing the password. [Both the sp_configure global setting and the login-specific sp_addlogin parameter need to be kept at 0. Modifying sp_addlogin by adding "select @maxfailedlogins = 0" as the first statement will help avoid it being set to a non-zero value accidentally]



CR:552216
CR Number:   552216
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2009 Fixed
15 Jan 2009 Fixed
Description
A 6908 error: "During redo the page timestamp value is less than old timestamp from log. Page#=<pageno>, object id = <objid>, page timestamp=<ts>. Log old timestamp=<ts>" may sometimes be reported during recovery of a transaction that has allocated pages or extents.



CR:552225
CR Number:   552225
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2009 Fixed
Description
Replication of an INSERT-SELECT statement on an ASE system using SQL statement

replication may cause the DSI connexion to go down with error 1028, if the

statement references tables from a different database than the source of replication.



CR:552227
CR Number:   552227
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2009 Fixed
29 May 2009 Reservation Made
Description
ASE does not check if the type of the supplied default value matches the type of the column at user table creation time.



CR:552231
CR Number:   552231
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2009 Fixed
Description
In rare circumstances for clusters with two or more instances, A error 16700, "Mismatch between the configuration file and the configuration..." may be reported in errorlog.



CR:552310
CR Number:   552310
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_adduser doesn't recycle unused usertype values and so can run out of values once the max smallint value is assigned, even if a smaller number of user-defined types are currently defined.



CR:552479
CR Number:   552479
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)
11 May 2009 Fixed
11 May 2009 Fixed
22 Jun 2009 Fixed
01 Jul 2009 Not a Bug
Description
Adaptive Server at the replicate site may raise error 15445 when replicating a table that has multiple encrypted columns that use separate keys where one key specifies an initialization vector and another key specifies no initialization vector. A workaround is to use all keys to have initialization vector or no initialization vector.
Workaround Description
 "We were able to confirm that if a table had some fields with an encryption key with initialization vector and some fields with a key that does not have initialization vector, the error appears on the fields that do not have a initialization vector for the key. Reencrypting all fields in a table with a no initialization vector key worked. Reencrypting all fields in a table with a key with initialization vector also worked. It appears that it is the mix of initialization vector/no initialization vector keys in the same table that causes the problem. "



CR:552508
CR Number:   552508
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2009 Fixed
15 Apr 2009 Fixed
17 Apr 2009 Added to user documentation
18 Aug 2009 Fixed
19 Aug 2009 Fixed
Description
A new column "Transactions" has been added to the monState table.



CR:552511
CR Number:   552511
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)
29 Jan 2009 Fixed
Description
Duplicates could be incorrectly returned for a DISTINCT query over

a join involving a union (from a view/derived table) where part

of the union's SELECT columns is in the DISTINCT clause

and another part is involved in the join predicate only.
Workaround Description
 set opportunistic_distinct_view off



CR:552537
CR Number:   552537
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2009 Fixed
14 May 2009 Fixed
19 Jun 2009 Fixed
Description
Incorrect duplicates can be returned for EXISTS subqueries which have an

equi-join in the correlation clause between a column in the subquery and

a scalar expression which contains the outer reference to a main query

column.



CR:552574
CR Number:   552574
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2008 Fixed
Description
Improve query tree generation for queries with huge number of OR predicates.



CR:552577
CR Number:   552577
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Open
OS:   HP-UX
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In a multipathing environment, when one path to a device fails and the LVM switches to an alternate path, Backup Server should be able to to retry i/o which has failed, preventing the failure of the backup.



CR:552583
CR Number:   552583
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2008 Fixed
Description
For a subquery with a group by with a grouping column from the outer table and this grouping column is also in the join predicate, if hash vector aggregate is choosen, it

could cause wrong results.
Workaround Description
 (zhao 12/10/2008)

The workaround is to use trace flag 450 or using AP plan to use group inserting op

instead of hash vector aggregate operator.



CR:552594
CR Number:   552594
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a way to abort a polite shutdown that is waiting for processes to complete



CR:552606
CR Number:   552606
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2009 Insufficient priority to fix
14 Nov 2012 Fixed
Description
sp_options may not show no_stats_distinctness option. This is correct in ASE 15.0.3 IR onwards (CR 539440), this CR was to correct a problem with the backport of 539440 in a 15.0.2 1-off.



CR:552608
CR Number:   552608
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
new feature request to extend ASE LDAP to support mapping of LDAP groups to ASE groups.
Workaround Description
 Add each login to an ASE group and manage them explicitly.



CR:552643
CR Number:   552643
Product Name:   Adaptive Server Enterprise
Product Component:   Pluggable_JVM
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2008 Fixed
Description
When running Java queries that access the file system via PCI trusted directories,

if the trusted directory has been defined improperly (meaning that it does not conform

to the documented syntax) then the server may enter a permanent 100% busy CPU

condition for which there is no solution other than server restart.
Workaround Description
 Ensure correct syntax is used for working directory



CR:552656
CR Number:   552656
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Dec 2008 Fixed
Description
Query compiled in the deferred mode may fail if it references view with java UDF.

Stack trace logged in the errorlog will show modules vu_colnames,colname_driver,

col_open_range
Workaround Description
 Switch off the deferred compilation by trace -T7730.



CR:552736
CR Number:   552736
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2009 Fixed
Description
Wrong result could happen for query with the conditions:

1. an equijoin join predicate between table1's col1 and table2's col2

(table1.col1=table2.col2), and

2. another equijoin predicate between one of the above joining columns

and an expression involving only column(s) which are also equijoined to

the other table's column(s), such as table1.col1=isnull(table1.col1,table1.col1), and

3. a store_index (reformatting) plan is chosen for the nljoin inner side

between those two tables.
Workaround Description
 set store_index off



CR:552786
CR Number:   552786
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Windows
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2009 Duplicate
Description
Need to add "Windows 2008" and "Windows Vista" to list of recognized windows OS used to print which OS the ASE is booted on.



CR:552795
CR Number:   552795
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)
12 Jan 2009 Fixed
Description
Flattened "EXISTS" subqueries may use a reformatting strategy

on the inner block's tables. When the store_index is created,

duplicates were not being removed. This can be a significant performance

issue for correlated subqueries that are theta-joined AND

there are additional predicates that are not used to position on

the reformatted table. The following query is an example:



delete outer

FROM outer

WHERE EXISTS (SELECT * FROM inner

WHERE DATEDIFF(year, innter.ValDate, outer.ValDate) = 0

AND DATEDIFF(month, inner.ValDate, outer.ValDate) = 0

AND outer.ValDate < inner.ValDate

)



Note that the outer and inner tables are theta-joined

(outer.ValDate < inner.ValDate). And that the DATEDIFF builtins

must be evaluated after rows are qualified by the theta-join.
Workaround Description
 Reformat the inner table(s) into a temp table using

the distinct clause to remove duplicate rows.

Rewrite the original query to reference the reformatted

temp table in place of the subqueries tables.



CR:552799
CR Number:   552799
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   RH Linux
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Dec 2008 Fixed
15 Jan 2009 Fixed
03 Feb 2009 Fixed
14 Jan 2009 Reservation Made
Description
Database timestamp may decrease after manual insertion into a timestamp column.



CR:552848
CR Number:   552848
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2008 Fixed
28 Jan 2009 Fixed
Description
Configuration of Webservices failed on HP platform with a syntax error reported.



CR:552859
CR Number:   552859
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2014 Insufficient priority to fix
Description
Under certain circumstances, query containing a sub-query introduced with a not clause where the columns being joined do not have the same data definition can produce incorrect results with larger datasets.
Workaround Description
 There are plenty of work-arounds available.



The query can be re-written as shown below to return 164 rows:



select m.* from mlschm_kaese_test m where not exists (select r.new_artkey from reorg_fv_assignments_kaese r where r.new_artkey = m.article)



select t.* from mlschm_kaese_test t

left outer join reorg_fv_assignments_kaese k

on new_artkey = article

where new_artkey =null



select m.* from mlschm_kaese_test m where m.article not in (select isnull(r.new_artkey,'abc123') from reorg_fv_assignments_kaese r)



- this is not so good as it relies on a value, 123abc never being present in the table mlschm_kaese_test



CR:552880
CR Number:   552880
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2009 Fixed
Description
Executing a java method which has a signature with a String array can cause an assertion to be

raised together with a stacktrace in the ASE errorlog containing the modules 'eudf__convertSQL2Java',

'execudf' and 'LeRun'.
Workaround Description
 n/a



CR:553026
CR Number:   553026
Product Name:   Adaptive Server Enterprise
Product Component:   coverletter
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Under some circumstances reorg rebuild can cause other spids accessing the same table to die with a SIGILL.



CR:553032
CR Number:   553032
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2009 Fixed
Description
Sybmigrate fails to create an index, because it is using the sorted_data option when creating indexes on DOL tables which is incorrect.



CR:553044
CR Number:   553044
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2008 Not a Bug
Description
Scheduled Jobs that produce large volumes of data, may, under certain circumstances, not produce all the output expected.
Workaround Description
 No workaround has been identified.



CR:553072
CR Number:   553072
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2009 Fixed
Description
The replication threshold of a table may be changed regardless of the replication status of that table provided that it is not set to 'never'.



CR:553090
CR Number:   553090
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2009 Fixed
Description
JS template "jst_get_datestr" has a problem when "time" component is part of filename.



CR:553106
CR Number:   553106
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Open
OS:   all
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
certify dbisql to work with all Sybase products, not only ASE.
Workaround Description
 For Replication Server, set property USE_METADATA=false

however, on ASE connction the property will prevent the initial sp_mda call



CR:553163
CR Number:   553163
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2009 Fixed
Description
DBCC STACKUSED reports the wrong maximum amount of stack memory used on Itanium platforms.



CR:553170
CR Number:   553170
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2009 Added to user documentation
Description
System Administration Guide explains that dbcc checkalloc performs check of Text column chains and does not perform check of OAM page entries.

But in fact, dbcc checkalloc performs check of OAM page entries and does not check of Text column chains.



CR:553180
CR Number:   553180
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2009 Fixed
Description
For a very large union view query, if it has too many UNIONs in the query and 'stack size'

is not configured large enough, sometimes it could cause the stack corrupted and ASE goes down.
Workaround Description
 Reduce the number of unions in the query or increase 'stack size' and 'stack guard size'.



CR:553342
CR Number:   553342
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2009 Fixed
Description
In very rare case, a query using a table created in the same procedure may cause stacktrace in add__computedcol_from_tobj().



CR:553428
CR Number:   553428
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2009 Bundled Request
Description
An update of an identity column value may change the value of @@identity. This global variable should only change after a insert, select into, or bcp.



CR:553436
CR Number:   553436
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2009 Fixed
Description
In a shared disk cluster following instance failover, the recovery of a

database that has mixed log and data on an instance that has a single engine,

might hang as a result of a livelock.



CR:553438
CR Number:   553438
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2008 Fixed
06 Feb 2009 Fixed
06 Feb 2009 One-off Provided
24 Mar 2009 One-off Provided
Description
The wrong result could be caused by this only if the special OR stragegy is used and the first value in the IN list or OR list is NULL. It will get less rows than expected.



CR:553484
CR Number:   553484
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under certain conditions, it is not possible to insert into a proxy table using a temporary

table as an intermediary, when the target table contains both an identity column and a text

column.
Workaround Description
 N/A

I抳e not been able to find a work-around for this problem.



CR:553566
CR Number:   553566
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2009 Fixed
09 Jan 2009 Reservation Made
Description
In 15.0.2 ESD 6 and higher, error 233 is raised when the isnull function is used with a replacement value of NULL, i.e. isnull(data,NULL), to generate a nullable column in a temp table from a non-nullable base column. Traceflag 15336 reverts ASE to previous behavior.



CR:553695
CR Number:   553695
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Dec 2009 Insufficient priority to fix
Description
Error 325 when quey has join/case under oltp mode and set store_index 0
Workaround Description
 1) optimization goal = allrows_mix



2) Not use set store_index 0



CR:553697
CR Number:   553697
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2010 Duplicate
Description
Error 325 when quey has join/distinct under oltp mode and set store_index 0
Workaround Description
 1) optimization goal = allrows_mix



2) Not use set store_index 0



CR:553772
CR Number:   553772
Product Name:   Adaptive Server Generic Docs
Product Component:   System Administration Guide
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2009 Added to user documentation
Description
documentation: add warning for oam and index trip parameters



CR:553780
CR Number:   553780
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2009 Fixed
12 Jan 2009 Reservation Made
Description
Deleting a table with LOB columns (text, image, unitext) and self referential integrity constraint

may hit SEGSEGV together with stack trace in the module of LeDeleteOp::_LeOpNext().



CR:553787
CR Number:   553787
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.4 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2009 Fixed
Description
Update statistics might report error 863 severity 20 state 2, the severity of this error

has been changed to 18.



CR:553791
CR Number:   553791
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Windows XP
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2008 Fixed
Description
ASE 15.0.x PC Client installer doesn't install Japanese language module if Sybase Central is deselected

from the install components list.
Workaround Description
 Install Sybase Central and then remove it.

Or copy %SYBASE%\locales\messages\japanese from the other machine which has Japanese language module.



CR:553813
CR Number:   553813
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2009 Fixed
Description
Stored procedures may be unnecessarily upgraded multiple times.
Workaround Description
 drop and recreate the table and stored procedure



CR:553832
CR Number:   553832
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2009 Fixed
Description
A database owner different than 'sa' and not having the replication role gets permission errors when attempting to run system stored procedures used to change the replication status at table level such as sp_setreptable, sp_setrepdefmode.



CR:553866
CR Number:   553866
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2009 Fixed
Description
If built-in function like data_pages(), which accesses OAM pages is called on a table in temporary database while the table is being dropped error 677 may be raised.



CR:553873
CR Number:   553873
Product Name:   Adaptive Server Enterprise
Product Component:   Pluggable_JVM
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2009 Fixed
23 Sep 2009 Fixed
Description
Killing a task which has previously performed Java operations may result in a stacktrace. This may also apply to tasks killed when the client unexpectedly disconnects, or the task has experienced stack overflow, or an engine is taken offline.



CR:553898
CR Number:   553898
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2009 Fixed
10 Apr 2009 Fixed
Description
After altering a table which has a trigger, an update may cause error similar to: Invalid column length: 86. Value must be between 0 and 4 for 'all-pages' row with minimum row length of 6.

followed by a stack trace in the errorlog.



CR:553962
CR Number:   553962
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2008 Fixed
22 Dec 2008 Fixed
16 Feb 2009 Presently Not Targeted For Any Future Release Of This Product
Description
The size of the dataserver binary on the solaris platform in the ASE 15.0.3 release is many times the size in previous releases.



CR:554017
CR Number:   554017
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2009 Fixed
05 Feb 2009 Fixed
Description
Login authentication fails on a target Adaptive Server after a bcp of the login account's syslogins row from a source Adaptive Server that contains trailing zeros in its syslogins.password column.



CR:554029
CR Number:   554029
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.2 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In circumstances when a web service returns a large amount of data, web services must be started up with sufficient memory for example - Xmx512m
Workaround Description
 Allocate more memory to JVM using - Xmx512m for example.



CR:554037
CR Number:   554037
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under some circumstances permissions are not propogating across both a table and procedure grant.



CR:554062
CR Number:   554062
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2009 Fixed
Description
When an extended column aggregate is used in a view, then the query may return no results.



An extended column aggregate is a non-ANSI sql feature that Sybase introduced, which allow a column to be placed into the select list of a GROUP BY aggregate, which is not included in an aggregate expression nor is it in the GROUP BY list.



The processing of the view silently fails in this case and returns no results.





CREATE TABLE PROB_TABLE

(

A int NOT NULL,

B int NOT NULL

)

go

insert into PROB_TABLE values (1,2)

go



CREATE VIEW PROB_VIEW1

AS

SELECT PT.A as PT_A,

PT.B as PT_B

FROM PROB_TABLE PT

go



-- note the extended column aggregate in PROB_VIEW2



CREATE VIEW PROB_VIEW2

AS

SELECT PT_A

FROM PROB_VIEW1

GROUP BY PT_B

go



-- the following returns no results and silently fails

select * from PROB_VIEW2

go



CR:554073
CR Number:   554073
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2008 Fixed
Description
Sybase Central throws NullPointerException in java.util.Calendar.setTime() while attempting to view Scheduled Job properties in a locale other than English.
Workaround Description
 None known if locale needs ot be used.



CR:554214
CR Number:   554214
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   HP-UX
Original Version:   15.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2009 Fixed
17 Feb 2010 Fixed
Description
dump database with EMC Networker failed with Archive API error indicating failure in loading the API library on HP-UX platform.



CR:554254
CR Number:   554254
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Proxy tables are dropped and error 11204 is raised if ALTER DATABASE FOR PROXY_UPDATE is run against a regular (non-proxy) database that contains proxy tables.



CR:554296
CR Number:   554296
Product Name:   Adaptive Server Enterprise
Product Component:   Pluggable_JVM
Status:   Closed
OS:   AIX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2008 Fixed
23 Dec 2008 Fixed
Description
ASE 15.0.3 running on IBM AIX 6.x version incorrectly interprets the OS version as lower than AIX 5.3

and fails with the following error:

kernel PCI(M0): PCI Bridge run-time check failed - Bridge is not enabled (expected: AIX 5.3 or later found: AIX 5.2 or earlier)
Workaround Description
 sp_configure "enable pci", 2

go



CR:554401
CR Number:   554401
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2009 Duplicate
Description
Infected processs in s_mapcontrol() during s_compile()of batch when statement cache was enabled.
Workaround Description
 set statement_cache off



CR:554404
CR Number:   554404
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2009 Diagnostic Provided
03 Jun 2009 Fixed
Description
Incorrect information is displayed under "data cache managementt" section of sysmon report.



CR:554410
CR Number:   554410
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plugin
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2009 Consult Complete
Description
ASEP incorrectly specifies in the help text that the default option for "enable cis" is 0.



CR:554435
CR Number:   554435
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2009 Fixed
Description
Can not install RTDS 4.5 packages on platform hppa64: unable to find any supported ASE message



CR:554472
CR Number:   554472
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   RH Linux
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2009 Fixed
10 Feb 2009 Fixed
Description
Stack trace may result in rvm_migrate_pcrtree() if stored procedure contains cursors and all objects in the stored procedure are owned by the same user as the executor of the procedure.



CR:554489
CR Number:   554489
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
An abstract plan generated using the 揷reate plan method, or by using set option show_abstract_plan on, on a very complex query including unions and views, may, under certain circumstances, be generated such that it cannot be used without producing subsequent warnings that a join is invalid.



CR:554556
CR Number:   554556
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2009 Fixed
Description
An update of an identity column value may change the value of @@identity. This global variable should only change after a insert, select into, or bcp.



CR:554644
CR Number:   554644
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2009 Fixed
Description
Enables data transfer between instances.



CR:554650
CR Number:   554650
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Dec 2008 Fixed
02 Jan 2009 Fixed
Description
instanceid is shown as NULL in systransactions/sp_transactions for some rows



CR:554665
CR Number:   554665
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2009 Fixed
19 Mar 2009 Fixed
Description
ASE incorrectly raises error 19848 instead of error 19850 when attempting to change the ASE errorlog location using sp_errorlog, while engine is coming online or offline.



CR:554710
CR Number:   554710
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   12.5.4 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CPU spikes due to high address spinlock contention when running dbcc checkstorage in a very big database with high number of worker processes and high number of ASE engines.



To reduce CPU usage and spinlock contention, please change one parameter via

sp_configure 'lock address spinlock ratio', 1



CR:554766
CR Number:   554766
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2009 Fixed
11 Feb 2009 Fixed
Description
In certain circumstances, ASE Cluster Edition dataserver may produce a stacktrace involving routine lock__singlechain_deadlock() due to signal 11.



CR:554776
CR Number:   554776
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Some 12.5.x multi-step abstract plans will fail to convert and apply properly on 15.0.x, resulting in syntax error 1013.



CR:554788
CR Number:   554788
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2012 Fixed
Description
In the showplan, when calling the sql function, the function name has garbage on it.



CR:554804
CR Number:   554804
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   pyxis
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2009 Fixed
Description
In rare circumstances we may hit timeslice during checkpoint process.



CR:554849
CR Number:   554849
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2009 Fixed
Description
Incorrect ordering could be returned for a multi-column ORDER BY nested loop join

query whose inner index scan has the same key column sequences as the ORDER BY

clause but with different direction on the leading column (i.e. ascending

vs. descending).
Workaround Description
 Run under allrows_mix, should use merge_join.



CR:555016
CR Number:   555016
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance KILL WITH STATUSONLY to work on transactions that are not currently being rolled back so that it provides an estimate of how long it would take to rollback in the current state.



CR:555071
CR Number:   555071
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2009 Fixed
Description
In rare cases, error 3403 might be reported at boot time during the recovery of a database that has mixed log and data.



CR:555137
CR Number:   555137
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2009 Fixed
Description
In very rare circumstances, the message "Current process (0x...) infected with signal 11 (SIGSEGV) with models like OptBlock::_OptInitBlobTcIdBm() or StTcInfoBase::StTcAverageWidthFromDataType" for queries assigning results of an anonomous subquery i.e. update t1 set c1 = (select null). The SQL is infact invalid.
Workaround Description
 Technically, the SQL is incorrect and should return Msg 409 because of specific Sybase semantics for update and subquery.

In the specific customer example, "a" cannot take a null value.





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