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

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

CR:323035

CR Number:   323035 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Duplicate Description The UPDATE INDEX STATISTICS command inappropriately raises error 11715 "Options (index name, partition number) in UPDATE ALL STATISTICS statement are ignored"

CR:323043

CR Number:   323043 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2003 Bundled Request Description Under rare circumstances, on multi-engined ASE Servers under heavy load, sp_monitorconfig can report "Max_Used" quanties that exceed their configured value.

CR:323047

CR Number:   323047 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2003 Bundled Request Description Under rare circumstances, on multi-engined ASE Servers under heavy load, sp_monitorconfig can report "Max_Used" quanties that exceed their configured value.

CR:323049

CR Number:   323049 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2003 Bundled Request Description Under rare circumstances, on multi-engined ASE Servers under heavy load, sp_monitorconfig can report "Max_Used" quanties that exceed their configured value.

CR:323052

CR Number:   323052 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2003 Fixed Description Under rare circumstances, on multi-engined ASE Servers under heavy load, sp_monitorconfig can report "Max_Used" quanties that exceed their configured value.

CR:323081

CR Number:   323081 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Nov 2003 Not a Bug Description sp_droplogin is documented to fail if the login being dropped is a user in any datasbase; however, it fails to fail (drops the login anyway) when the login is a user in an offline database.

CR:323088

CR Number:   323088 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2003 Fixed 09 Jul 2003 Fixed Description CIS: After ASE version 12.5.0.1, some SQL statements with JOIN of two proxy tables are not passed to remote ASIQ server, which causes some performance regression

CR:323168

CR Number:   323168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jun 2003 Fixed 24 Jun 2003 Fixed 30 Jun 2003 Fixed 13 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description Under heavy load, when the JAVA VM hits PANIC mode, it leaves the VM in an inconsistent state

CR:323171

CR Number:   323171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed 23 Feb 2004 Fixed 13 Sep 2005 Fixed 23 Feb 2004 Fixed Description Add new configuration option 'histogram tuning factor'. When this option is set to a value greater than one UPDATE STATISTICS will generate intermediate histogram with number of steps equal to number_of_requested_steps * 'histogram tuning factor'. This intermediate histogram will be later compressed before storing in sysstatsitics. The size of compressed histogram will depend on the data layout : high frequency cells will not be compressed. As a result the final histogram should provide much better representation of the table values. To activate the feature execute: sp_configure 'histogram tuning factor', VALUE whenere VALUE > 1 Good value to use is 20: sp_configure 'histogram tuning factor', 20 To disable the feature use: sp_configure 'histogram tuning factor', 1

CR:323177

CR Number:   323177 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jun 2003 Fixed 29 Jul 2003 Fixed 18 Jul 2003 Fixed Description The configuration parameter 'cis connect timeout' was never implemented and has been removed.

CR:323303

CR Number:   323303 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2003 Third Party Problem 11 Jul 2003 Third Party Problem 11 Jul 2003 Third Party Problem Description When any version of ASE is running on IBM AIX 4.3.3 with ML11 patch and a DNS entry is used in the interfaces file, ASE encounters "infected with 11" stacktrace or "kernel ninit: cannot find host" error and fails to boot. This is due to a bug in IBM AIX 4.3.3 ML11 patch. To fix this problem, install IBM AIX 4.3.3 patches bos.adt.prof.4.3.3.89 and bos.rte.libc.4.3.3.90. The problem als exists on AIX 5.1 (fixed by bos.rte.libc 5.1.0.50) and AIX 5.2 (fixed by bos.rte.libc 5.2.0.10) also. Workaround Description  increase stack size by 64k more than what is configured.

CR:323328

CR Number:   323328 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   11.9.2.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2003 Fixed Description ASE running on Linux will not start up if the limit of file descriptors per process is set to a number greater than 1024. Workaround Description  Set the limit of file descriptors per process to a number less than 1024.

CR:323337

CR Number:   323337 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enhancement request to have new Audit event codes and new stored procedures for easy monitoring of Auditing information

CR:323338

CR Number:   323338 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 May 2004 Presently Not Targeted For Any Future Release Of This Product Description Enhancement request to enable Sybase Central to monitor Auditing events

CR:323444

CR Number:   323444 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2003 Fixed Description The maximum column length of sysprocesses.tran_name is 64 bytes. However, some rows may return upto 3 bytes more for this column causing exceptions in the client.

CR:323550

CR Number:   323550 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2004 Fixed 13 Jan 2004 Fixed 23 Feb 2004 Fixed Description Eliminate "DBCC TRACEON 8399" messages in errorlog when sp_sysmon and other applications use the monitor counters

CR:323628

CR Number:   323628 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2003 Duplicate Description Msg 103 (Identifier too long) is raised incorrectly for 29 or 30-character long identifiers.

CR:323636

CR Number:   323636 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jun 2003 Fixed Description Server will not boot if Server Default Data Cache's name is not correctly set to 'default data cache' in the server config file.

CR:323644

CR Number:   323644 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jul 2003 Fixed Description Queries containing DISTINCT, ORDER BY, GROUP BY or UNION or queries whose execution involves reformatting or sort merge join strategies may get a 511 error when processing wide rows from tables with datarows lock scheme: Msg 511, Level 16, State 1: "Attempt to update or insert row failed because resultant row of size nnnn bytes is larger than the maximum size (mmmm) bytes allowed for this table."

CR:323730

CR Number:   323730 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Oct 2003 Fixed 09 Oct 2003 Fixed 21 Dec 2003 Presently Not Targeted For Any Future Release Of This Product Description An ALTER TABLE operation with ADD, DROP or MODIFY COLUMN on a large Data Only Locked table having a placement index may cause subsequent DBCC CHECKTABLE to report 7928 errors: "Index <indexname> is not consistent; found <leafrow_num> leaf rows but <datarow_num> data rows. Drop and recreate the index". Subsequent REORG REBUILD on this table may result in data loss. Workaround Description  Drop the clustered index before running alter table.

CR:323822

CR Number:   323822 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2004 Fixed Description turning off 'enable monitoring' still logs info in the monitoring tables

CR:323863

CR Number:   323863 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Feb 2004 Fixed 12 Jan 2010 Added to user documentation 12.5.2 18 Feb 2004 Fixed 12.5.2 13 Mar 2004 Fixed Description When configuring ASE for High Availability with SunCluster3.0, username and password of the user with sa_role/ha_role and the monitor probe user are stored in ase_login_file in clear text format.

CR:323940

CR Number:   323940 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2003 Fixed Description Some system stored procedures executed in user databases upgraded from earlier releases may fail with error 11060: "This statement has exceeded the maximum number of recompilations (4). This indicates an internal error. Please note the error prior to this one and contact Sybase Technical Support". Workaround Description  Manually update sysobjects.objspare for system tables in user databases so that it have the same value as the sybsystemprocs.sysobjects.objspare.

CR:323985

CR Number:   323985 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2003 Fixed Description In the following case: o A view references a Java type that is either system or cross database defined. o The view is sourced in a SELECT INTO statement. This incorrectly generate recompilations. In the case of a batch, this will produce a 225 error.

CR:324165

CR Number:   324165 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2003 Fixed 17 Aug 2003 Presently Not Targeted For Any Future Release Of This Product Description On Windows platform, the message "Cannot get unicode conversion handle for character set id 50" may be reported in the errorlog due to an outdated libntlog.dll file.

CR:324250

CR Number:   324250 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Feb 2004 Fixed Description Syconfig deletes list of selected languages after installing Japanese language along after selecting UTF8 and dictionary case insensitive

CR:324377

CR Number:   324377 Product Name:   Adaptive Server Enterprise Product Component:   charsets Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2003 Fixed Description OMNI: ASE configured with non-default sort orders (eg: Spanish Dictionary) may get error: ksctsetlocale: connectivity library error. Operation: cs_locale(CS_SET CS_SYB_SORTORDER espdict_iso_1) when a CIS connection is opened to a remote server. Workaround Description  Add following line to objectid.dat [collate] section e.g: [collate] . . 1.3.6.1.4.1.897.4.9.3.55 = espdict

CR:324435

CR Number:   324435 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jan 2004 Not a Bug Description Row level access rule doesn't work if the underlying datatype is BIT

CR:324472

CR Number:   324472 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2003 Fixed Description 'CPU Yields by Engine' in sp_sysmon doesn't always keep count of individual engine yields (usually manifests as constantly 0 yields for engine 0 even though the engine is yielding).

CR:324531

CR Number:   324531 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jan 2004 Fixed Description sp_helpconfig does not display help text when called with the "max concurrently recovered db" configuration option.

CR:324546

CR Number:   324546 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jul 2003 Fixed 28 Jul 2003 Fixed 30 Jul 2003 Fixed Description ASE does not provide details of the cause of sending ATTENTION to Open Server applications. For example, backup server may get "A call to srv__waitfor_read() was interrupted by an attention" message and ASE does not indicate reasons for this condition.

CR:324568

CR Number:   324568 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2007 Fixed Description Sybase Central does not display number of rows for proxy table on ASE 12.5 correctly.

CR:324573

CR Number:   324573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2003 Fixed 11 Jul 2003 Fixed Description Running a query in parallel that uses one of the builtin's day(), month(), year(), left(), str_replace(), square(), audit_event_name(), derived_stat(), getdllname(), get_xtypeid(), get_xtypename(), identity_burn_max(), index_colorder(), internal_encrypt(), is_sec_service_on(), lockscheme(), newid(), next_identity(), pagesize(), show_translation(), syscol_name() may cause internal memory corruption, resulting in the message "current process infected with 11 in different functions, incorrect results or errors like 2511. The diagserver will print an Assertion message in the errorlog together with a stack trace which includes the modules get_eval_param_type() and copy__eval() Workaround Description  Disable parallel processing.

CR:324589

CR Number:   324589 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jul 2003 Not a Bug Description When using divide (/) or modulo (%) in the where clause and the where clause also has an or in it, depending on the position of / or % you either get 'divide by zero occurred' or some sort of result when dividing or moduloing by 0.

CR:324625

CR Number:   324625 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   athena Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Oct 2003 Fixed Description 1. in xsm create some objects 2. in diagram, put the mouse on some selected objects. you have a tooltip, but it shows only object type and not name

CR:324638

CR Number:   324638 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2003 Presently Not Targeted For Any Future Release Of This Product Description The error 4216 may be reported in the errorlog followed by a stack trace containing the module dmp_send_logchain, when truncating a database log from a recently created database, or at boot time when creating tempdb, if the log in database model is segragated. Workaround Description  Disable serial log allocation optimization starting the server with trace flag 4200.

CR:324689

CR Number:   324689 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2004 Fixed Description When a dynamic prepare assigns the result of coalesce(?,?) to a char type column the query fails with error 257 (Implicit conversion from datatype 'INT' to 'CHAR' is not allowed ...)

CR:324759

CR Number:   324759 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   AIX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.0.3 12 Sep 2003 Fixed 12.5.1 ESD#2 12 Sep 2003 Fixed Description EFTS: when indexing "non-well formed XML document" with universal filtering turned on, txtsvr core dumps.

CR:324778

CR Number:   324778 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2003 Fixed Description xpserver does not set locale sometimes leading to wrong character translation between ASE and the xpserver

CR:324799

CR Number:   324799 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2004 Fixed Description Under rare circumstances a stored procedure that executes a SET ROWCOUNT statement may raise a 9522 error: "The parameter that specifies the number of rows in a SET ROWCOUNT statement must be an integer with a value greater than 0." although the number of rows specified was a correct value. Workaround Description  There are two ways of working around this. Either with recompile option or declaring a local variable and use it to assign the value of the parameter. CREATE PROCEDURE sp_testproc2 @p1 int = null with recompile AS BEGIN IF (ISNU

CR:324847

CR Number:   324847 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2003 Fixed Description Passwords from Solaris 32-bit/64-bit can be migrated to Linux using BCP or other data migration tools and used as such. Traceflag 1650 will turn on the compatibility mode. This compatibility mode is available only on Linux platform and only passwords from Solaris 32-bit/64-bit can be migrated.

CR:324962

CR Number:   324962 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jul 2003 Fixed 26 Feb 2004 Fixed Description On some platforms, the following messages may be seen at startup: "kernel ncheck_quit: no pid associated with <fd>, vsn = 32, socket type = 2" and "kernel ncheck_checkconn: Unable to identify thread for <fd>".

CR:325003

CR Number:   325003 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2003 Fixed 27 Oct 2003 Fixed 27 Nov 2003 Fixed Description In rare circumstances, sessions that access a given database may seem to hang while the transaction log of this database is undergoing truncation either by the 'CHECKPOINT SLEEP' task or through the execution of the DUMP TRANSACTION command. Workaround Description  N/A

CR:325042

CR Number:   325042 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2003 Fixed 27 Oct 2003 Fixed Description Error 2610 may be hit in module 'ncrid_update' resulting in the session being killed when an UPDATE command is run in the 'deferred_varcol' update mode as shown by SET SHOWPLAN and a data page split occurs. The modules 'xact_endupdate', 'def_insert' and 'linksplit' will also be reported in the stack trace found in the error log. Workaround Description  Force the usage of index 'DocHis_idx5' so that E_ORSTRING doesn't happen OR boot ASE with traceflag 695 to disable the update_mode() optimization. The former solution is better than the latter.

CR:325088

CR Number:   325088 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2003 Fixed 26 Nov 2003 Fixed Description A DBCC CHECKTABLE for large Data Only Locked tables may take too much time to stop when interrupted with Ctrl C or killed from another session.

CR:325280

CR Number:   325280 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2003 Fixed 19 Sep 2003 Fixed Description The message "currect process infected with 11" is reported in the errorlog together with a stack trace which includes the module 'execudf' when bcp in to a table with a UDF default value.

CR:325340

CR Number:   325340 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Insufficient priority to fix Description Feature request to enhance sysdepends to include references to cross-database dependencies.

CR:325386

CR Number:   325386 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If an update is based on a join, the choice between the possible query-paths of the join are only based on the costing of the query. As a result of this, potential cost differences between direct versus deferred updates are not considered. In certain siuations this leads to an overall bad plan. So the request is, to factor in the potential extra costs of a deferred update

CR:325388

CR Number:   325388 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   athena Fixed Version Build Resolution Date Closure Code (If Appropriate) Minerva 05 Jan 2004 Fixed Description Steps to reproduce behavior : 1- Creae an XML with XSD 2- Move the tool palette and docked it between the workspace and the diagram. 3- Save model and close the PD. 4- Reopen them, we will notice that the tool palette now is docked on the left of the workspace but not between this one and the diagram

CR:325408

CR Number:   325408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2009 Insufficient priority to fix Description Feature request to have an option for SET STATISTICS IO to return the individual statistics for each fetch, currently the cumulative total is returned for each fetch.

CR:325414

CR Number:   325414 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jul 2003 Fixed Description The maximum number of ANDs or ORs in an expression level has been increased from 300 to 1024. As a result, the maximum number of values in an IN-list has also been increased from 301 to 1025. The ASE configuration value, "stack size" will have to be increased beyond the default value to avoid error 3626 when more than 300 AND/ORs are used in a query.

CR:325452

CR Number:   325452 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2004 Fixed 04 Feb 2004 Fixed Description A new command, GRANT/REVOKE DEFAULT PERMISSIONS ON SYSTEM TABLES, has been added to setup or to remove the default permissions assigned on the system tables.

CR:325482

CR Number:   325482 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2003 Fixed 12.5.1 04 Nov 2005 Not a Bug Description The ASE Replicator folder is only displayed if the ASE Replicator is installed in the ASE. The ASEPlugin uses the stored procedure sp_helpddb to determine the name of the Replicator's distribution database. If the stored procedure is not installed, then the plugin will not display the ASE Replicator folder.

CR:325550

CR Number:   325550 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2003 Fixed 19 Sep 2003 Fixed Description A 913 error, "Could not find row in sysdatabases with database id ... Run DBCC CHECKTABLE on sysdatabases" followed by a 14208 error "Unable to execute SQLJ function .... The function schema may have changed since the command was compiled." may be reported when executing a SQLJ function from a stored procedure or a view in a recently loaded database. Workaround Description  Drop and recreate the problemed stored procedure.

CR:325557

CR Number:   325557 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2003 Fixed 11 Sep 2003 Fixed 11 Sep 2003 Fixed 19 Sep 2003 Fixed Description Adaptive Server Enterprise for IBM AIX platforms encounters disk corruption if a database is created or altered on the master device after the master device has been mirrored with the DISK MIRROR command.

CR:325572

CR Number:   325572 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description feature request to increase speed of the time it takes to run set proxy command, regardless of the number of "enabled by default roles" a login has .

CR:325584

CR Number:   325584 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2004 Fixed Description Display the size of all tables in use by a process in the monProcessObject table

CR:325627

CR Number:   325627 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2003 Fixed 15 Jul 2003 Fixed Description A 804 error, "Unable to find buffer '<value>' from cache '<value>' holding logical page '<value>' in sdes '<value>' kept buffer pool for object '<value>'." together with a stack trace which includes the modules 'update_statistics', 'sam__get_dol_pages' and 'bufunkeep' may be reported in the error log when an UPDATE STATISTICS WITH SAMPLING command is run on a Data Only Locked table that has forwarded rows. Workaround Description  Ensure that forwarded rows don't exist in this DOL table.

CR:325693

CR Number:   325693 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Oct 2005 Fixed 30 Nov 2005 Fixed 16 Dec 2005 Fixed Description ODBC types are incorrect for unichar, univarchar when SQLColumns is called. This trnaslates to sp_columns, and the types are defined incorrectly in spt_datatype_info. Workaround Description  I am seeing if the customer will try the UPDATES to spt_datatype_info

CR:325727

CR Number:   325727 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   NA Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2003 Fixed 30 Jul 2003 Fixed 14 Aug 2003 Fixed 03 Sep 2003 Fixed 10 Oct 2003 Presently Not Targeted For Any Future Release Of This Product Description CIS: selecting from proxy table with unichar or univarchar column mapped onto a remote server with char or varchar column may result in 'cs_convert: cslib user api layer: common library error' on UTF8 servers.

CR:325729

CR Number:   325729 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2003 Fixed Description The procedure cache may be subjected to replacement in some cases even if free memory is available on other engines. This may have an adverse impact in performance.

CR:325766

CR Number:   325766 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2003 Fixed Description Dynamically increasing the "number of devices" using sp_configure, without actually making use of them, may potentially cause the thread to terminate with segmentation violation, under 1) If you bring an engine online 2) If you try to do a failover(dbcc takeover)

CR:325777

CR Number:   325777 Product Name:   Adaptive Server Enterprise Product Component:   xpserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2003 Fixed 05 Sep 2003 Fixed Description Executing an interactive program via xp_cmdshell can cause the XP server to hang. For example, executing xp_cmdshell "isql -Usa -Sase12503" will cause XP server to hang. Workaround Description  Do not execute interactive programs via xp_cmdshell.

CR:325793

CR Number:   325793 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2003 Fixed 19 Feb 2004 Not reproducible with latest version of the product available as of Resolution Date Description Disk init of a 32 GB device with a vdevno of 127 fails with error 5115.

CR:325794

CR Number:   325794 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Dec 2003 Fixed Description When configuring for High Availability with SunCluster3.0, SY.ase resource creation may fail without proper error message if the resource property Secondary_companion_name is specified for the SunCluster3.0 command `scrgadm'. User is not supposed to specify or modify this property, because the HA agent will do that automatically when required.

CR:325849

CR Number:   325849 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description bcp parameters -F and -L can be used for copying in or out.

CR:325880

CR Number:   325880 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 02 Oct 2003 Workaround Description In installations created new at server versions 12.5 through 12.5.0.3, index sysusers.ncsysusers2 is not marked 'unique' although it should be. This can permit databases to have several users with identical user IDs (UIDs). Server version 12.5.1 fixes the index problem, but the fix will fail in a given database if sysusers in that database does have duplicate UIDs. (This problem DOES NOT affect installations that were created in versions 12.0.x or older and subsequently upgraded to 12.5.)

CR:325914

CR Number:   325914 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.0.0.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2003 Fixed 04 Dec 2003 Fixed Description The option SET FORCE PLAN ON may be ignored when an UPDATE has a FROM clause with more than one table or view, and the view is updated.

CR:325943

CR Number:   325943 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2003 Fixed 29 Jun 2006 Not a Bug Description Sub-optimal performance may result under certain conditions when executing a query involving a MAX() or MIN() aggregate and join operation between two or more tables because the optimizer chooses the best index to resolve the aggregate function. New command line traceflag provided to avoid aggregate optimization for queries involving joins. Workaround Description  disable "allow backward scan" OR use command line traceflag -T370 to disable aggregate optimization for joins and only use that optimization for one table queries and as alternative to table scan.

CR:325947

CR Number:   325947 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2003 Fixed Description In sp_sysmon Transaction Management section a new cause for "ULC flushes to Xact Log" has been added. This cause is named "by Unpin".

CR:326038

CR Number:   326038 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2004 Presently Not Targeted For Any Future Release Of This Product Description Feature Request: Checkstorage fault 100006 is classified as a soft fault if the target database is not in single user mode. This CR requests that 100006 always be classified as a hard fault, even if the target database is not in single user mode. Workaround Description  All dbcc stored procedures can be modified by the customer. If they require some customized reporting, they can code that in.

CR:326039

CR Number:   326039 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2003 Fixed Description ASE on the windows NT platform performs socket reset on shutdown.

CR:326050

CR Number:   326050 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2003 Fixed Description User 'guest'is always created when a new temporary database is created even when the option for creating 'guest' user is not selected in Sybase Central ASE Plug-in. The solution is not to present an option of creating 'guest' user in Temporary Database Creation Wizard as 'guest' user is always created with temporary database.

CR:326060

CR Number:   326060 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2003 Fixed Description The error 10812 together with a stack trace which includes the modules 'trunctab' and 'cfg_notify_current_audit_table' may be reported when trying to change the current audit table using sp_configure, if the process gets into a deadlock or it receives an attention while trying to truncate the target audit table.

CR:326076

CR Number:   326076 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jul 2003 Fixed Description In some cases when a very large buffer pool is configured we will see the pool configuration failing even when there is sufficient memory.

CR:326091

CR Number:   326091 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2003 Fixed 18 Sep 2003 Fixed Description Session-specific SET options 'proc_return_status' and 'proc_output_params' added to turn OFF sending back a stored procedure's return status and/or its output parameters back to the front-end client. These options are ON by default.

CR:326098

CR Number:   326098 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2006 Fixed Description Eliminate duplicate wait event descriptions in the monWaitEventInfo MDA table.

CR:326113

CR Number:   326113 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2003 Presently Not Targeted For Any Future Release Of This Product 31 Oct 2003 Presently Not Targeted For Any Future Release Of This Product 31 Oct 2003 Fixed Description When an attempt is made to insert TEXT data encoded in SJIS using the bulk interface (e.g. BCP) on an EUCJIS server configured with "enable unicode conversions" set to 0 and trace flag -T2402 active, error message 7105 is generated and the insertion fails. This occurs regarless of whether the data actually contains any Hankaku Katakana characters whose width expands from one byte to two bytes during conversion from SJIS to EUCJIS; it should occur only if the data contains such characters. Furthermore, extraction of such data using the bulk interface (e.g. BCP out) produces a TDS protocol error if the data contains Hankaku Katakana characters. This should not occur. Workaround Description  Use -Y option of BCP -- this option is available from OCS 12.5 ESD#11 M:\Temp>bcp jpubs..txt2 in out.data -Usa -P -Snamako125_64 -c -Jsjis -Y <-- Starting copy... 2 rows copied. Clock Time (ms.): total = 1 Avg = 0 (2000.00 rows per sec.)

CR:326126

CR Number:   326126 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Microsoft Windows NT Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Jan 2004 Fixed 11 Dec 2003 Fixed Description CIS: SELECT <case expr> FROM <proxy tables join> may result in wrong SQL being constructed when quickpass is disabled. Workaround Description  Change the server type of the remote server to direct_connect.

CR:326152

CR Number:   326152 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Aug 2003 Fixed 08 Sep 2003 Presently Not Targeted For Any Future Release Of This Product To Be Determined 12 Sep 2003 Fixed Description Replication Agent may shutdown with a stacktrace, including function ra__pack_struct_tok(), followed by stack overflow, when trying to process an inconsistent log record. Workaround Description  Skip the page.

CR:326158

CR Number:   326158 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Oct 2004 Insufficient priority to fix 01 Jul 2005 Fixed Description When stored procedure text is send to ASE containing multiple keywords like CREATE TABLE, all control characters (like space etc.) except for the last control character between these keywords are not saved in syscomments. Workaround Description  don't use >1 control char between double/triple keywords

CR:326289

CR Number:   326289 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jul 2003 Fixed 29 Oct 2004 Presently Not Targeted For Any Future Release Of This Product 11 Nov 2004 Fixed 29 Jul 2004 Fixed 11 Nov 2004 Fixed Description New generic stored procedures added to installmaster. sp_autoformat is a generic procedure that can output a result set from a table auto-formatting character data. sp_exec_SQL is a wrapper procedure to execute a SQL statement via 'execute immediate' and handle errors in a single place.

CR:326386

CR Number:   326386 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2003 Duplicate Description Infected with 11 when using a subquery and a view .

CR:326398

CR Number:   326398 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2003 Third Party Problem Description ASE fails to boot on some versions of Red Hat linux with the message "current process infected with 11" reported in the errorlog together with a stack trace which includes a number of instances of init_dummy() module during boot time. This is due to a bug in Red Hat's glibc patch tracked under RedHat Bug#102995 (Specifically glibc-2.3.1-30 through glibc-2.3.2-30 contains this bug; which has been fixed from glibc-2.3.2-31 onwards). Installing glibc-2.3.2-31.i686.rpm or later from RedHat will solve this problem. Workaround Description  NOTE: ASE is not supported on Red Hat 9. The fix is actually Red Hat patch which is also a workaround. I suggest not to Run ASE on any version of OS not certified by Sybase listed under http://www.sybase.com/detail?id=1024194

CR:326423

CR Number:   326423 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2003 Fixed 22 Jul 2003 Fixed 24 Jul 2003 Fixed 25 Jul 2003 Fixed 31 Jul 2003 Fixed Description The message "current process infected with signal 11" may be reported in the error log with a stack trace that includes the modules 'dol_qualrow' and 'dol__get_lock' when concurrent DML commands are run on a DATA PAGE locked table. Alternatively, this may manifest as a timeslice error or "infected with signal 11" messages with different stack traces.

CR:326477

CR Number:   326477 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2003 Fixed Description When creating a stored procedure normalization process may alter query tree so that the potential later renormalization of this stored procedure may not give desired effect. In such cases the only way to obtain the functionality was to drop recreate stored procedure. This issue is related to INSERT and UPDATE statements only.

CR:326497

CR Number:   326497 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2003 Fixed 14 Oct 2003 Fixed 28 Oct 2003 Fixed Description DBCC FIX_TEXT on All Pages Locked table loaded into an utf-8 server from an iso_1 server results in a 605 error after receiving 7952 error on DBCC CHECKTABLE. Workaround Description  1. create a clustered index on table , run dbcc fix_text, run dbcc checktable, drop clustered index OR 2. bcp out PC_request from iso_1 server & bcp the data back in on test utf-8 server & then run dbcc fix_text on it

CR:326503

CR Number:   326503 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2004 Fixed 14 Nov 2003 Fixed 19 Mar 2004 Presently Not Targeted For Any Future Release Of This Product Description A positive (successful) XA status is returned rather than an XAER_NOTA error, when a thread attempts to attach to an XA transaction that is concurrently being rolled back by another thread. Workaround Description  No workaround.

CR:326521

CR Number:   326521 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Feb 2009 Insufficient priority to fix Description Feature request to have ASE automatically rebuild indexes on user tables after character set / sort order changes

CR:326551

CR Number:   326551 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2003 Fixed Description If the machine hostname is an invalid server name, syconfig.exe and sybatch.exe failed to configure server with default server name. Workaround Description  manual added the backupser entry to sysservers. isql -Usa -St12345 1>sp_addserver SYB_BACKUP, null, a12345_bs

CR:326572

CR Number:   326572 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jan 2004 Fixed Description When the configuration parameter 'allow updates to system tables' was reconfigured, some times memory consumption was reported. This configuration parameter does not consume memory.

CR:326575

CR Number:   326575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jul 2003 Fixed 29 Jul 2003 Fixed 19 Nov 2003 Fixed Description The message "current process infected with 11" in the module 'opt_like' may be reported in the error log for subqueries involving a LIKE clause referencing a correlated column of an outer query block. Workaround Description  Avoid correlated columns on like clauses in subqueries until regression fix is released.

CR:326602

CR Number:   326602 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2003 Fixed Description The maxinmum number of user connections is 5 when running under the Developer Licensde Option.

CR:326605

CR Number:   326605 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.0.0.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2003 Fixed 27 Oct 2003 Fixed Description Queries that involve tables that are using Referential Integrity Constraints when executed at 'transaction isolation level 3' may not obtain a 'Sh_intent' lock but instead a 'Sh_table' lock although the primary key index is being used by the query. Workaround Description  N/A

CR:326620

CR Number:   326620 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2003 Fixed 03 Nov 2003 Fixed 07 Nov 2003 Fixed 06 Nov 2003 Fixed Description The message "process infected with 11" in the module 'dbt_curseq' together with a stack trace that includes the module 'lddb_chkcreator' may be reported in the error log when loading a database dump that was originally dumped on Adaptive Server 12.0.x. Workaround Description  None

CR:326692

CR Number:   326692 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Oct 2003 Fixed 01 Oct 2003 Fixed Description CIS : INSERT INTO <proxy table> command may insert additional EUCJIS character 0xA1C7 or SJIS character 0x8166. Workaround Description  Turn on -T109 on local server; but this is a restrained workaround because it won't work if the remote server is of pre-ASE 12.5 or a replica server.

CR:326721

CR Number:   326721 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Nov 2003 Fixed Description Sub-optimal performance may result for queries involving subqueries with non-unique index which could be used to flatten the subquery. Workaround Description  Force the desired index.

CR:326741

CR Number:   326741 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2006 Fixed Description Feature Request: When possible, optimizer should consider row count limits, set using "set rowcount", in costing

CR:326742

CR Number:   326742 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   11.9.2.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2003 Fixed 02 Oct 2003 Fixed 27 Oct 2003 Fixed 13 Jan 2004 One-off Provided Description A 12301 error, "Internal error: the index (id = <value>) and the data for row (<pageid_1>, <rowid_1>) in table '<value>', database <value> are inconsistent; data is marked deleted but index is not. Aborting the transaction." may be reported during the execution of a SELECT command on a Data Only Locked table, when another session has concurrently updated the forwarded data row above which resulted in its re-forwarding to an other <pageid_2>, <rowid_2> location. Workaround Description  Try reorg rebuild to get rid of forwarded rows.

CR:326743

CR Number:   326743 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2014 Presently Not Targeted For Any Future Release Of This Product 29 May 2009 Insufficient priority to fix Description Feature request for support of FULL OUTER JOIN syntax. Workaround Description  Do a UNION of a LEFT OUTER JOIN and RIGHT OUTER JOIN