Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

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 Ive 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 create 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.