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

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

CR:420853

CR Number:   420853 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2006 Fixed 06 Mar 2006 Fixed 15 Mar 2006 Fixed 16 Mar 2006 Fixed Description 318 or 2601 error might be returned during ONLINE DATABASE after LOAD DATABASE across platform where endian type is different, if UPDATE [INDEX|ALL] STATISTICS command was executed on sysstatistics, sysusers or other system table before the DUMP DATABASE. Workaround Description  Before DUMP DATABASE on the source machine, delete statistics for the system table (ex. sysstatistics) by running: delete statistics <system table name> go

CR:420870

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

CR:420916

CR Number:   420916 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 EC Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2006 Fixed 20 Dec 2007 Fixed Description The error "Could not find virtual page for logical page 9984 in database 'master'", with a stack trace which includes the modules like 'log_to_virt', 'virtmap ', 'bufgrab ', 'getpage_with_validation', will be reported if the requested size for master database is not multiple of size of allocation unit. The similar error will be reported in case of model database also.

CR:420951

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

CR:421002

CR Number:   421002 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2006 Fixed 01 Jun 2006 Presently Not Targeted For Any Future Release Of This Product Description If sp_configure is used to change just the server's default sort order (without changing the server's default character set at the same time), and before rebooting, a subsequent change is made to nearly any parameter, then after the reboot the new sort order appears to have taken effect (according to the errorlog and sp_helpsort) but it doesn't in fact work.

CR:421061

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

CR:421076

CR Number:   421076 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2006 Fixed 17 Mar 2006 Fixed 17 Mar 2006 Fixed 19 Mar 2006 Fixed 20 Mar 2006 Fixed Description After a SELECT-INTO, where encryption is specified on the target table and where the data is generated from a UNION of SELECT statements, a subsequent SELLECT of the data in the target table will generate the error, "Msg 154133, Level 18, State 5, An internal error occurred during an encryption operation (errorcode -1). Please contact Sybase Technical Support". Workaround Description  Do the insert as a two-step process: 1. select unioned data into an intermediate temporary table without encryption 2. insert the data from the temporary table into the desired target table containing encrypted columns For example: select t1.col1 into #t from t1 union select t2.col1 from t2 go select col1 into tresult (col1 encrypt with k1) from #t go

CR:421083

CR Number:   421083 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Mar 2006 Fixed 30 Oct 2007 Fixed Description CIS: The CREATE PROXY_TABLE command on an ASE with Allpages lock scheme will fail with error msg 1767: "Number of variable length columns exceeds limit of 254 for allpage locked tables. CREATE TABLE for '<proxy table name>' failed." if the remote table contains more than 254 variable columns.

CR:421084

CR Number:   421084 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2006 Fixed 13 Sep 2006 Fixed 11 Sep 2006 Fixed 06 Dec 2006 Fixed 07 Dec 2006 Fixed 06 Dec 2006 Fixed Description The message 2843, "The dynamic statement '%.*s' could not be found. This may be due to insufficient metadata descriptors. Increase the serverwide '%s' parameter or the '%s' parameter." is incorrectly raised when multiple spids are running the same LWP in a multi-engine ASE environment. Workaround Description  n/a

CR:421127

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

CR:421147

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

CR:421245

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

CR:421270

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

CR:421325

CR Number:   421325 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Feb 2006 Fixed 08 Mar 2006 Fixed Description Wrong non-NULL value was generated for an equijoin column coming from an inner nested left outer join. Example: SELECT T1.PNO, T1.PNAME, T2.PNO, T3.PNO FROM PARTS T1 LEFT OUTER JOIN (PARTPRICE T2 LEFT OUTER JOIN SUPPLY T3 ON (T2.PNO = T3.PNO AND T3.PNO > 'P1')) ON (T1.PNO = T2.PNO) T3.PNO may be incorrectly missing NULL substitution.

CR:421330

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

CR:421374

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

CR:421381

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

CR:421527

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

CR:421547

CR Number:   421547 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2006 Fixed Description A client prepare statement including multiple SQL commands may not be completley executed if at least one of SQL commands is using TEXT or IMAGE host variables and the statement cache is active on the server. Workaround Description  send UPDATE is a separate batch.

CR:421573

CR Number:   421573 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Feb 2006 Fixed Description Update the installmaster script to address the following issues: jConnect: The column names used to describe ResultSet MetaData do not conform to the JDBC specifications. [CR 419579] sqlupgrade: Errors encountered when installing system stored procedures in Japanese environment. [CR 418053] jConnect: Request to support getDatabaseMajorVersion(), getDatabaseMinorVersion(), getJDBCMajorVersion() and getJDBCMinorVersion() functions on the DatabaseMetaData class. [CR 416759]

CR:421607

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

CR:421660

CR Number:   421660 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2006 Fixed 30 May 2006 Fixed Description On platforms other than Intel/AMD, inserting data to a fixed-length unichar column that is shorter than the actual length of the column, and where the unichar column is not aligned on a 2-byte boundary in the page may cause the process to terminate with a bus error. Workaround Description  Avoid schema where fixed length unichar columns fall on odd byte boundaries. For example, instead of declaring a table with columns: int, char(3), unichar(50), use char(4) instead. Alternatively, use univarchar instead of unichar.

CR:421900

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

CR:421934

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

CR:422003

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

CR:422051

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

CR:422089

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

CR:422177

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

CR:422191

CR Number:   422191 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   Windows XP Original Version:   ulysses Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2006 Fixed Description Whenever a XML model (XSM)contain external shortcut to reference other model's items, XML model will create a logical item without symbol. However, it is reported that this external shortcut will affect the items ordering of the XML Model in PD12, PD11 and PD10 Workaround Description  Not accepted by customer: Declare the external shortcut at the end of the item list. However, it is not possible to delete the existing problematic shortcut as it may refered by many Elements , Attributes etc. Thus all the refering linkage need to be rebuilded.

CR:422244

CR Number:   422244 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Feb 2006 Not a Bug Description We take job scheduler down with sp_js_wakeup "stop_js",1 command. However, job scheduler comes back up automatically with server restart. I hope you can appreciate my point: if I've explicitly told job scheduler to go down, I think it's reasonable to expect it to stay down until told otherwise.

CR:422259

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

CR:422281

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

CR:422296

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

CR:422303

CR Number:   422303 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   Windows XP Original Version:   ulysses Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Nov 2006 Fixed 16 Nov 2006 Fixed Description In XML model of PD10, "shortcut" items (element, attribute), which reference a Namespace's item , is still allow to map to OOM or PDM item. However, in XML model of PD12, the "Mapping" Tab of items will disappear as long as it become a "shortcut" by defining the "reference" property.

CR:422355

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

CR:422375

CR Number:   422375 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2006 Fixed Description The expensive Lava operators (hash, sort, store (for reformat)) have been limited to a configurable percentage of tempdb's pagesize buffer pool. This percentage is controlled through the "max resource granularity" configuration option. This value defaults to 10%. Before this checkin, each instance of these operators could keep upto 50% of the MRU area of the pagesize buffer pool.

CR:422381

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

CR:422388

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

CR:422423

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

CR:422434

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

CR:422444

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

CR:422466

CR Number:   422466 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2006 Fixed 17 Jan 2007 Fixed 15 Nov 2007 Fixed Description An undetected deadlock may occur when the database option 'ddl-in-tran' is active and session 1 executes DDL and/or DML commands while session 2 is interested in printing the execution plan for session 1 through SP_SHOWPLAN.

CR:422537

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

CR:422673

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

CR:422674

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

CR:422715

CR Number:   422715 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Mar 2006 Fixed 03 Apr 2006 Reservation Made Description When large quantities of memory is allocated, from procedure cache, for a single query, performance may be affected adversely due to lengthy chains.

CR:422719

CR Number:   422719 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Mar 2006 Fixed Description set option show_missing_stats on will print some spurious multi-attribute sets that cannot be corrected by update statistics e.g. references to the "Rid" attribute, as well as references to BIT, IMAGE, TEXT attributes that cannot be placed in update statistics commands this fix will limit the hints provided by the tracing to just those that can be corrected by update statistics

CR:422771

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

CR:422779

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

CR:422805

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

CR:422809

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

CR:422860

CR Number:   422860 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Mar 2006 Fixed 20 Mar 2006 Fixed 20 Mar 2006 Fixed Description Listing the tables in the FROM clause in a different order could result in a very different query plan, sometimes a very bad performing query plan. Workaround Description  change the order of the tables in the "from" clause or use AP

CR:422867

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

CR:422869

CR Number:   422869 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2006 Fixed Description If an execute insensitive scrollable cursor is executed again, error 3806 "Both the READ ONLY and the FOR UPDATE options have been specified for cursor" might be raised.

CR:422966

CR Number:   422966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2006 Bundled Request Description Queries containing hash operators with large estimated input sets could consume significant portions of the procedure cache and spend significant amounts of CPU time in memalloc() (as seen from sybmon stack dumps). This was the result of extraordinarily long subordinate PROC_HDR chains where the subordinate PROC_HDR is effectively empty (as seen from sybmon "procmem prphdr <main_phdr_address verbose" command). This has been fixed by freeing and recreating the PROC_HDR as processing proceeds from one input set to the next. Sessions in this state can significantly impact overall system performance.

CR:423035

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

CR:423070

CR Number:   423070 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2006 Fixed 08 Mar 2006 Fixed 08 Mar 2006 Reservation Made 15 Mar 2006 Fixed Description Corrects a performance issue with IN lists If a table t1 has an index i1 on columns (a1,a2,a3) and multiple IN lists are defined e.g. select * from t1 where a1 in (1,2) and a2 in (10,11) and a3 in (100,101) the optimizer would only consider costing subsequent IN lists if the previous IN lists were reasonably selective. The change is to cost all IN lists, since strongly selective IN list can follow weak IN in lists, and then determine whether to avoid some less significant IN lists due to poor selectivity.

CR:423158

CR Number:   423158 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2006 Fixed Description The "quiesce database" status for temporary databases, as shown by the sp_helpdb stored procedure, may unexpectedly survive a server re-start. Workaround Description  Re-execute a full quiesce database sequence : quiesce database test_quiesce hold tempdb quiesce database test_quiesce release

CR:423209

CR Number:   423209 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2006 Fixed 29 Mar 2006 Fixed 05 Apr 2006 Fixed Description Backup Server error 4.141.2.36:[23] "The 'read' call failed for device 'device_name' with error number 14 (Bad address). Refer to your operating system documentation for further details." or error 4.139.2.22: [105] "The 'uncompress' call failed for device 'device_name' with error number 0 (Error 0)." is returned, when a database dump file that was generated with 'with compression=<compression_level>' clause is loaded across platform. Workaround Description  Use old compression syntax (backup api syntax), like, dump database pubs2 to 'compress::9::/....'

CR:423244

CR Number:   423244 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Mar 2006 Fixed 29 Mar 2006 Fixed Description In extremely rare situations, recovery of the current database page timestamp can result in a value a few increments lower than in specified behavior. The practical impact is virtually nil, and any theoretical problem quickly resolves after a few new runtime updates.

CR:423251

CR Number:   423251 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2006 Fixed Description When ASE dataserver is configured for High Availability on Sun Cluster, it may not release database devices during failover if PID of dataserver process(es) is not removed. Workaround Description  Manually restart primary ASE and make sure it is in a consistent state.

CR:423253

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

CR:423255

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

CR:423313

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

CR:423347

CR Number:   423347 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2006 Fixed 09 Mar 2006 Fixed Description While running dbcc upgrade_object() and a syntax error in the source text is found, Msg. 11031 is raised. At the same time the error 'Invalid pointer param number 4, pointer value 0x3' .*s invalid pointer param number 6, pointer value 0x2' is also raised. Workaround Description  update sysmessages manually.

CR:423371

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

CR:423374

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

CR:423383

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

CR:423395

CR Number:   423395 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Apr 2006 Fixed Description When an ANSI outer join query has an equi-join in the ON clause and one of the equi-join columns also has "col=<ct>" in the WHERE clause, the optimizer will not consider using the MergeJoin algorithm, although it's legal under these circumstances.

CR:423396

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

CR:423428

CR Number:   423428 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Mar 2006 Fixed 31 May 2006 Fixed Description The message "current process...infected with 11" may be reported in module "collocate" when a session runs a subquery whose execution requires a work table to be sorted in parallel by ASE. The modules "psort_producer", "subst" and "subconst" will be reported also in the error log. Workaround Description  forcel serial execution of queries at the server or session level.

CR:423441

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

CR:423509

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

CR:423530

CR Number:   423530 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Apr 2006 Presently Not Targeted For Any Future Release Of This Product 30 May 2006 Fixed Description A connection using LDAP authentication retains a lock on syslogins while waiting for the LDAP server to respond, which causes sp_addlogin to hang

CR:423559

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

CR:423575

CR Number:   423575 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2006 Fixed 15 Mar 2006 Fixed 20 Mar 2006 Fixed Description A 625 error may be reported by sp_post_xpload if a user table is updated before index is rebuilt manually or by sp_post_xpload, and after a database dump has been loaded across platform and brought online. Workaround Description  (1)Do not run any DML on user table before sp_post_xpload. There is no guarantee that such a DML succeeds. Indexes on user table may be in a corrupted state after XPDL-DA. (Wrong ordering in the RID part in index, known CR 346317.) or (2)Run sp_post_xpload under a trace flag 3199, for example, dbcc traceon(3199) go sp_post_xpload go dbcc traceoff(3199) go

CR:423583

CR Number:   423583 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Mar 2006 Fixed 13 Mar 2006 Fixed 21 Mar 2006 Fixed Description A UNION query such as: select a from x where 1=2 union select b from y, which contains a predicate that is always false (in this case 1=2) in the first SELECT of the UNION may not return all of the rows of the result set if the query plan chosen by the optimizer contains a hash-based UNION operation. The presence of the hash-based UNION operation in the query plan is shown in showplan by the line: HASH UNION Operator. Target Version  15.0 ESD#2 Workaround Description  Use the command: set hash_union_distinct 0, to disable hash-based UNION operations.

CR:423674

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

CR:423748

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

CR:423783

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

CR:423796

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

CR:423806

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

CR:423836

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

CR:423852

CR Number:   423852 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 May 2006 Fixed Description The stored procedure sp_who "spid" will return 0 rows when the parameter spid belongs to a user with negative suid. Workaround Description  *** Friday, March 10, 2006 10:20:07 AM *** cooperg *** Chnage the code from '@low = 0' to '@low = @@minsuid'

CR:423878

CR Number:   423878 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 May 2007 Fixed 11 Apr 2006 Fixed 14 Nov 2007 Fixed 13 Nov 2007 Reservation Made 15.0.2 ESD#3 28 Nov 2007 Fixed Description Queries on range partitioned tables that contain range predicates that can become SARGs and that contain unknown constants at compile time (i.e. local variables or substituted columns of a join clause) can be used to eliminate scans of some of the partitons of the table based upon the runtime values of the constants. For example: create table t1 (c1 int, c2 int) partition by range (c1) (p1 values <= (50), p2 values <= (100)) declare @v1 int set @v1 = 49 select * from t1 where c1 < @v1 The select statement contains a range predicate (c1 < @v1) that is unknown at compile time. This predicate will be used at the beginning of execution of this statement, when the value of @v1 is known, to determine which partitions of t1 could possibly contain qualifying rows, and will cause the elimination of the partition, p2 from the scan of t1 because its values of c1 are all greater than 49.

CR:423902

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

CR:423913

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

CR:423930

CR Number:   423930 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Mar 2006 Fixed 15 Mar 2006 Fixed 17 Mar 2006 Fixed Description In rare circumstances, column data may not be translated if more than 127 contiguous columns data are non-null values and all the columns require translation and all translation type is same length, when database dump file is loaded across platform.

CR:423931

CR Number:   423931 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Mar 2006 Fixed Description DBCC CHECKTABLE may fail to report error 2510: "Key mismatch between index page <index pno>, partition ID <ptnid>; at offset <indoffset>; and data page <data pno> (row ID <rnum>), partition ID <ptnid>. Drop and re-create index ID <indid> of table '<tabname>' in database '<dbname>'." and abort silently, or return "Invalid parameter" error with 2510 error message.

CR:423962

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

CR:423975

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

CR:424130

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

CR:424132

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

CR:424170

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

CR:424173

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

CR:424174

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

CR:424176

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

CR:424188

CR Number:   424188 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Apr 2006 Fixed Description When command-line trace flag -T450 is set, queries involving a group-by clause (and having 32 or less distinct group-by columns) will have a predicable ordering similar to that of ASE 12.5.x. Namely, in the absence of an explicit order-by clause, ordering will be that of the group-by columns.

CR:424268

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

CR:424281

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