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

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

CR:401927

CR Number:   401927 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2005 Fixed Description When configuration parameter 'enable real time messaging' is set to enable the RTMS feature on Windows, initialization fails during ASE startup sequence with an unhandled exception error for ExceptionCode: c0000005. This makes the RTMS feature of ASE unusable on Windows platform in ASE15.0 GA release.

CR:401954

CR Number:   401954 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   11.5.1.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2005 Fixed Description New feature request to set a maximum wait time limit to SHUTDOWN. The new syntax is SHUTDOWN [WITH WAIT [ = "xx:xx:xx" ] | WITH NOWAIT ] Workaround Description  *** Thursday, August 25, 2005 9:58:57 AM *** cooperg *** N/A

CR:401988

CR Number:   401988 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2006 Fixed 27 Aug 2005 Fixed 20 Dec 2006 Fixed Description Syconfig and other client applications will not able to connect to the Adaptive Server if it was booted with named pipe. Workaround Description  Remove the named pipe directory service from the interfaces file before upgrade the ASE.

CR:402002

CR Number:   402002 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) 21 Sep 2005 Fixed 19 Oct 2005 Fixed 25 Oct 2005 Fixed Description The message 'Legal optimizer criteria must be INT' is printed when running some 'SET' commands.

CR:402029

CR Number:   402029 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2006 Fixed 31 Mar 2006 Fixed 06 Apr 2006 Fixed 03 Mar 2008 Presently Not Targeted For Any Future Release Of This Product Description When performing a post error cleanup ASE may enter in the infinite loop trying to allocate memory. Very long stack trace will show multiple occurances of following sequence of calls : {s_handle,s_cleanframe,s_copytmps,memcreate,ex_raise}

CR:402044

CR Number:   402044 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) 11 Oct 2005 Fixed Description Incorect value may be assignment to the local variable if the query is executed in the parallel and the query has a scalar aggregate. This problem may happen if the showplan output shows multiple query steps with "Parallel result buffer merge" execution strategy. Workaround Description  Add a dummy expression: max(id) + 0 See also the workarounds in the P&T Guide, When parallel query results can differ, Achieving consistent results.

CR:402075

CR Number:   402075 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed Description When upgrading to 15.0 from 12.5.x, if the configured 'procedure cache size' is the default, upgrade may fail due to Error 701. To work around this, ensure that the procedure cache size is at least 12000.

CR:402082

CR Number:   402082 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) 08 Sep 2005 Fixed Description On the HP platform HTTPS (SSL) is not available for ASE WebServices. The HTTP transport is not affected, however.

CR:402099

CR Number:   402099 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 Sep 2005 Fixed Description Many tools need to get an estimated cost from a query plan without executing the query. This cost is used to compare estimated plan cost in 15.0 vs the actual cost in pre 15.0 query plan. A new "set option" called show_final_plan_xml has been added that prints a query plan before the query gets executed along with its estimated logical and physical I/O.

CR:402102

CR Number:   402102 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Oct 2005 Fixed 29 Aug 2005 Fixed 30 Aug 2005 Bundled Request Description Job Scheduler utility scripts fail on Windows platforms due to error in statement to set an environment variable.

CR:402115

CR Number:   402115 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) 12 Sep 2005 Fixed Description On sol64 platform ,jcs.jar file didn't exist in the dir decripted by the former testcase ($SYBASE/ASE-12_5/Sample/JavaSqlXml/SQLX-examples). The jcs.jar file exist in the dir ($SYBASE/lib).So must be modified the testcase.

CR:402171

CR Number:   402171 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) 27 Nov 2005 Fixed Description (OPTIMIZER) The estimated total cost of the final plan as displayed by the output of traceflag 310 may be incorrect in the case of a query with joins on more than 4 tables.

CR:402212

CR Number:   402212 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2005 Fixed Description When the 'optimization timeout limit' option is configured via sp_configure, then the newly configured value is not reflected in the session (visible via the @@opttimeout global variable) that invokes sp_configure. The query plans generated in the invoking session may thus be based on the previous 'optimization timeout limit' value instead of the newly configured value.

CR:402274

CR Number:   402274 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2005 Fixed 12 Jan 2006 Not reproducible with latest version of the product available as of Resolution Date Description Query with equi-sargs predicates containing IS NULL on indexed columns can result in wrong selectivity estimation.

CR:402310

CR Number:   402310 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) 26 Sep 2005 Not a Bug Description ASE does not allow creation of tables with Unicode characters. ASE will report the following error when trying to use Unicode characters in a table or column name: Msg 102, Level 15, State 1: Server 'ase_125', Line 2: Incorrect syntax near '琴'. Workaround Description  Create tables and columns with non-utf8 characters.

CR:402324

CR Number:   402324 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2005 Fixed Description The sybmon stack command has been extended to support dumping metadata for all threads running a parallel query plan. The new command is: stack family <alfa_spid> Note, that alfa_spid must be the spid of the parallel plan's alfa thread.

CR:402353

CR Number:   402353 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.3.a Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Sep 2005 Bundled Request Description If a SQL update statement uses an assignment of an encrypted column into a T/SQL local variable or parameter (@variable), Adaptive Server may return Msg 15445: "The datatype of the ciphertext data (NUMERIC) is incorrect for column ''."

CR:402355

CR Number:   402355 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2005 Fixed 07 Sep 2005 Fixed Description The message, process infected with 11 in 'proc__setdb_derived_table' is printed in the errorlog together with a stacktrace containing the modules 's_getTreeOrPlan', 'proc_setdb' and 'proc__setdb_tree' when a SELECT statement containing a derived table expression is executed. ASE must be configured with user defined tempdbs and statement cache on.

CR:402362

CR Number:   402362 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2005 Not a Bug Description ECDA DB2 UDB: ASE/CIS cursor date parameter was bound as datetime. The date parameter is now bound as date.

CR:402435

CR Number:   402435 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2005 Fixed Description Previously in 15.0 GA, DBISQL launch script "dbisql.bat" (Windows) and "dbisql" (Unix platforms) contained invalid argument "-path" that caused the script to fail. This has been fixed. (The correct argument is "-Dpath".)'

CR:402438

CR Number:   402438 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) 18 Sep 2005 Fixed 01 Sep 2005 Not reproducible with latest version of the product available as of Resolution Date 02 Nov 2005 Not reproducible with latest version of the product available as of Resolution Date Description sub-optimal performance may result when a query is executed in execute immediate mode.

CR:402441

CR Number:   402441 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) 01 Mar 2006 Fixed Description This CR implements 'dynamic partition elimination': when predicates such as 'where part_col = @v' appear in a query on a table that is semantically partitioned on 'part_col', the query execution engine will determine the partition that could contain matching values based upon the semantic partitioning conditions, at execution time, when the value of @v is known. The partitions that cannot contain matching values are eliminated from the scan operation. Dynamic partition elimination will also be applied to nested-loop join operations, where the substituted value of the column of the outer table is known before the inner table is scannned. A new message will appear in showplan output when dynamic partitioning is active: [ Using Dynamic Partition Elimination ] Target Version  15.0 ESD#2

CR:402472

CR Number:   402472 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Aug 2008 Fixed 26 Aug 2008 Fixed Description Historical Server playback mode returns incorrect information on 64bit platforms. Workaround Description  Use a 32bit version of the Historical Server.

CR:402476

CR Number:   402476 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) 16 Nov 2005 Not reproducible with latest version of the product available as of Resolution Date 13 Jun 2006 Fixed 25 Aug 2006 Fixed Description The message "An internal memory management error has occured. Error code: Invalid slot id." may be reported in the error log when Adaptive Server encounters some problems while distributing the work among worker processes and ends up without proper clean-up of the worker processes in some rare cases.

CR:402536

CR Number:   402536 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2005 Fixed 05 Dec 2005 Fixed 09 Nov 2005 Fixed 24 Nov 2005 Duplicate Description XPServer fails to start on linuxia64 platform with default value of "esp execution stacksize" parameter. Workaround Description  Increase the "esp execution stacksize" using sp_configure.

CR:402574

CR Number:   402574 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a way to have serverwide dbcc traceflag output go to a log file other than the errorlog.

CR:402610

CR Number:   402610 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2005 Fixed Description On the Windows platform, the message "KERNEL structure not padded correctly - size = 5288" appears at the start of the ASE boot sequence.

CR:402615

CR Number:   402615 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2005 Fixed Description Report values of SYBASE_LICENSE_FILE and LM_LICENSE_FILE environment variables as they are used to find licenses, if set.

CR:402632

CR Number:   402632 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Apr 2006 Fixed 09 Jul 2006 Fixed Description Backupserver might delete shared memory with id 0 when dump command fails.

CR:402694

CR Number:   402694 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Sep 2005 Fixed Description A SELECT SUBSTRING(...) statement on a proxy table mapped to a remote table on DB2 using the DirectConnect/DRDA results in an ILLEGAL SYMBOL error from DB2.

CR:402717

CR Number:   402717 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) 27 Sep 2005 Fixed 23 Sep 2005 Fixed Description After the cross platform dump and load (XPDL), the space utilization is not handled correctly, and an index is unnecessarily rebuilt by sp_post_xpload, if variable length index key was greater than 252 bytes. Also some page corruptions happen in DOL index root page, in DOL non-leaf index page for UNICHAR NOT NULL index key in some cases, and in a special case of slice control page if the database dump is from 11.9.x.

CR:402725

CR Number:   402725 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2005 Fixed Description UNION queries may return wrong results in very limited circumstances. This may occur if the select list of the first SELECT contains duplicate column references.

CR:402732

CR Number:   402732 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2005 Fixed 02 Jan 2006 Fixed 31 Oct 2005 Fixed 03 Mar 2006 Fixed 10 Jan 2006 Fixed 09 Jan 2006 Fixed 03 Feb 2006 Fixed Description This fix enhances the query optimizer's ability to find optimal query plans for complex queries more quickly without compromising on plan quality. The enhancement primarily comes from changes made to the ASE query optimizer's optimization timeout mechanism and greedy search strategy. The following user interface changes have also been made for the optimization timeout mechanism: At the server level: sp_configure "optimization timeout limit", <0..1000> - this option is now valid for ad-hoc queries only - the range has changed from <1..1000> to <0..1000> - the value 0 represents "no timeout" - the default is still 10 sp_configure "sproc optimize timeout limit", <0..4000> - this option has been introduced for stored procedure queries - the is from <0..4000> - the value 0 represents "no timeout" at server level - the default is 40 At the session level set plan opttimeout <0..4000> - this can be specified for both ad-hoc queries or stored procedures - the range has changed from <1..1000> to <0..4000> - the value 0 represents "no-timeout" at session level - for ad-hoc queries, values specified above 1000 are discarded and default of 10 is used At query level select * from TabA ... plan "(use opttimeoutlimit <0..4000>)" - only <0..1000> can be specified for ad-hoc queries - <0..4000> can be specified for stored procedures - a value of "0" represents no-timeout at the query level Workaround Description  Place the empty #tmp table at the beginning of the FROM list

CR:402733

CR Number:   402733 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) 07 Oct 2005 Fixed 25 Oct 2005 Fixed Description ALTER TABLE DROP command with more than 9 text columns fails with signal 11 in oh_insert. Workaround Description  Break the "alter table drop" command into two commands, eg alter table call_req DROP z_srvc_impdesc1,z_srvc_impdesc2, z_srvc_impdesc3,z_srvc_impdesc4, z_srvc_impdesc5 go alter table call_req DROP z_srvc_impdesc6, z_srvc_impdesc7, z_srvc_impdesc8,z_srvc_impdesc9, z_srvc_impdesc10 go

CR:402768

CR Number:   402768 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Loading a dump of a smaller database into a larger one may cause the segmaps of fragments beyond the size of the dump to change.

CR:402835

CR Number:   402835 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) 09 Sep 2005 Fixed Description The message "current process infected with 11" in the module 'dbt_unkeep' followed by a stack trace may be reported in the error log when a session is detaching from an external transaction and the revert to the database that was active at the time of the attach has failed. The modules 'xact__detach_external' and 'closedb' will also be reported. As a result an implicit shut down of ASE will occur.

CR:402846

CR Number:   402846 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) 26 Nov 2005 Fixed Description The error 1945 "Cannot create unique index 'ix1' on table 't'. The table partition condition and the specified index keys make it impossible to enforce index uniqueness across partitions." will be reported only when the user tries to create a unique local index; the issue doesn't apply to a unique global index.

CR:402855

CR Number:   402855 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) 03 Oct 2005 Fixed 30 Aug 2006 Fixed Description A SELECT INTO using the the identity() function generates zeros for some rows when using a derived table based on a UNION ALL or a view containing a UNION ALL. Workaround Description  Use trace 4404

CR:402897

CR Number:   402897 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) 19 Oct 2005 Fixed 03 Feb 2006 Fixed Description Performance problem could occur when a query has 2 or more IN lists that can be applied to the same composite index on different keys. The behavior was that the index will likely be chosen in the query plan, but if this index was a weak choice, then there could be a performance problem. e.g. select * from T where T.a IN (1,2) and T.b IN (5,6) and ... some other predicates suppose an index existed on T(a,b) and all rows of the index qualified with the above predicate, then a full index scan with lookup of all data rows will occur, which would normally be much slower than a simple table scan or some other index scan with the remaining predicates.

CR:402902

CR Number:   402902 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 Jan 2006 Fixed 10 Mar 2006 Fixed Description For an INSERT ... SELECT query a 14108 error or 605 error can occur if all of the following conditions are met: The rows to be inserted contain at least one LOB column (TEXT, IMAGE or UNITEXT); The SELECT that generates the values to be inserted must access at least two distinct tables, each with a LOB column; The query plan must use a HashDistinct operation, i.e. the showplan output contains: HASH DISTINCT Operator. The 14108 error can occur if at least one table in the query has no LOB columns. If all tables in the query have LOB columns, the 605 error can occur. Target Version  15.0 ESD#2

CR:402918

CR Number:   402918 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 Sep 2005 Fixed Description Running ASE 15.0 GA, Load Database performed upon a 12.5.x dump of a database that has replicated stored procedures can fail on this error: Error: 632, Severity: 20, State: 2 Attempt to move memory with an incorrect length of -166. Maximum allowed length is 16384. Workaround Description  Perform Dump Database when there are no active transactions.

CR:402920

CR Number:   402920 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) 13 Sep 2005 Fixed Description After dropping a column using ALTER TABLE, the computed columns defined after the dropped column as well as any function-based indexes do not work properly.

CR:402922

CR Number:   402922 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) 13 Oct 2005 Fixed Description After 32bit <-> 64 bit or cross-platform dump load, if server is shutdown and boot again, accessing semantically partitioned table or roundrobin partitioned table with global clustered/placement index may run into segv. Workaround Description  No Workaround.

CR:402925

CR Number:   402925 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) 13 Sep 2005 Fixed Description A stacktrace may occur when an error is raised while executing a query that has a hash join, a hash distinct or a hash union operator in its plan. This stacktrace contains the functions : LeHashOp::_LeClose() and soextdealloc().

CR:402986

CR Number:   402986 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2005 Fixed Description Installjsdb released with ASE 1253 ESD#3 on Mac OS is an incorrect version and causes Job Scheduler not to function on Mac. This affects only Mac OS platform. ASE reports in errorlog messages like "Incorrect Job Scheduler sequencer version found within 'sybmgmtdb'", "Job Scheduler can not operate, Expected 0:27:27, Actual 0:26:26", "Job Scheduler failed installing its required sequencer code", "Job Scheduler Task failed to initialize", "Job Scheduler Task state set to stop".

CR:403071

CR Number:   403071 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Sep 2005 Fixed 08 Oct 2005 Fixed Description Update auditinit for sunx86 platform. Previous release has incorrectly shipped auditinit from other platform.

CR:403075

CR Number:   403075 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   HP-UNIX Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2005 Fixed 15 Sep 2005 Fixed 21 Sep 2005 Fixed Description Update auditinit for HPIA64 platform. Previous release has incorrectly shipped auditinit from other platform.

CR:403077

CR Number:   403077 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   macosx Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2005 Fixed 05 Apr 2006 Fixed 03 Apr 2006 Fixed Description Installjsdb released with ASE 1253 ESD#3 on Mac OS is an incorrect version and causes Job Scheduler not to function on Mac. This affects only Mac OS platform. ASE reports in errorlog messages like "Incorrect Job Scheduler sequencer version found within 'sybmgmtdb'", "Job Scheduler can not operate, Expected 0:27:27, Actual 0:26:26", "Job Scheduler failed installing its required sequencer code", "Job Scheduler Task failed to initialize", "Job Scheduler Task state set to stop".

CR:403079

CR Number:   403079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Dec 2006 Fixed 21 Dec 2006 Reservation Made Description When a transaction is aborted due to excessive stack usage, ASE prints only diagnostics related to offending task. It doesn't produce diagnostics regarding query context available before abort. This CR addresses problem by printing information on stored procedure nesting level and open transactions under new traceflag.

CR:403129

CR Number:   403129 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) 30 Sep 2005 Fixed Description The message 4408, "The query and the views in it exceed the limit of 50 tables." is raised with severity 19. This severity is too high and should be 16. Workaround Description  n/a

CR:403130

CR Number:   403130 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) 31 Mar 2006 Fixed Description Some option settings may not be exported from login trigger to the session level.

CR:403208

CR Number:   403208 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Mar 2010 Insufficient priority to fix Description the EBF/ESD installer should give option to run installmaster script...and... ...other scripts... installmaster (instmstr on Windows) Script installcommit (instcomm on Windows) Script installsecurity (instsecu on Windows) Script instmsgs.ebf Script inst_ha_scripts.sh Script (Sun Solaris only) installhasvss (insthasv on Windows) Script installdbccdb (instdbcdb on Windows) Script ...after all the files for the EBF/ESD are placed on the hard drive. Workaround Description  http://www.sybase.com/detail?id=1013610

CR:403382

CR Number:   403382 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) 05 Oct 2005 Fixed Description CIS: In some circumstances, running sp_showplan on a multi-engine server with sessions involving CIS query or MDA tables may be infected with signal 10 or 11 and core dumps, or causes ASE to hang.

CR:403384

CR Number:   403384 Product Name:   Adaptive Server Enterprise Product Component:   sqlupgrade Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2005 Fixed 14 Mar 2006 Fixed 02 Jun 2006 Bundled Request Description The sqlupgrade utility may initiate the upgrade process for the server before all databases in the server have completed recovery.

CR:403391

CR Number:   403391 Product Name:   Adaptive Server Enterprise Product Component:   auditinit Status:   Closed OS:   AIX Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 11 Sep 2005 Fixed Description Auditinit now ported to ASE15.0 in ESD1 on IBM64.

CR:403392

CR Number:   403392 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 Sep 2005 Fixed 10 Oct 2005 Fixed 10 Oct 2005 Fixed Description When an update command tries to update a column with the result from a cursor fetch and a deferred update causes the cursor position to be lost, a signal 11 and stack trace including LeDMLOp::_LeOpClose() may occur.

CR:403461

CR Number:   403461 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2006 Fixed 22 Mar 2006 Fixed 05 May 2006 Fixed Description This fix is to update logic of counting physical processors considering introduction of SMT (Simultaneous multithreading) capable Power5 processors.

CR:403462

CR Number:   403462 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) 12 Oct 2005 Fixed 20 Mar 2006 Fixed 20 Mar 2006 Fixed Description This fix is to support additional license type "EV" for evaluation period license.

CR:403476

CR Number:   403476 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Apr 2006 Fixed Description The Sysprocesses.time_blocked column unexpectedly shows a NULL value for server tasks being blocked by a detached distributed transaction.

CR:403537

CR Number:   403537 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   SunOS Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jun 2009 Duplicate Description When using large 'sql text pipe max messages' and 'plan text pipe max messages', changing "current audit table" from 1 to 2 could causes MDA/FDP error. Workaround Description  *** Monday, September 12, 2005 1:35:56 PM *** cooperg *** N/A

CR:403564

CR Number:   403564 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   12.5.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2005 Duplicate Description sp_displayaudit returns arithmetic overflow on Windows XP when auditing is configured at the database level.

CR:403592

CR Number:   403592 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 Sep 2005 Fixed 03 Apr 2006 Fixed Description Error 4022 should have a severity of 10, but a severity of 16 is raised which results in ODBC connections being refused. Workaround Description  None.

CR:403597

CR Number:   403597 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 Jan 2006 Presently Not Targeted For Any Future Release Of This Product Description sp_monitorconfig may report more active locks than found in syslocks.

CR:403600

CR Number:   403600 Product Name:   Adaptive Server Enterprise Product Component:   sybmon Status:   Closed OS:   HP-UNIX Original Version:   12.5.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2005 One-off Provided 19 Jan 2006 Fixed 23 Feb 2006 Fixed 14 Feb 2006 Fixed Description On HP-UX Itanium platform, the stacktrace in case of a crash doesn't include all the frames and may also report wrong function names even though we have the correct instruction pointer.

CR:403638

CR Number:   403638 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 2006 Bundled Request Description The warning message 9827 reading "Control page <PageNumber> upgrade for partition number <PartitionNumber> for object ID <ObjectId> in database <DatabaseName> may not have been done correctly ..." may wrongly be reported under the previous object section for DBCC checkalloc.

CR:403662

CR Number:   403662 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) 20 Sep 2005 Fixed Description Fixed possible wrong result for queries whose plan contains a DistinctSorting and one of the DistinctSorting's projection is a column with a search clause <the column>=constant on it. The wrong result typically only showed up under heavy server load. Target Version  15.0 ESD#1

CR:403678

CR Number:   403678 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.3 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2005 Fixed Description In ASE 12.5.3 ESD#1, ESD#2 and ESD#3 coverletter on Windows platform, instructions for removing the "sybase" account from Windows system-defined group "Administrators" after performing the steps needed to improve security is missing. This can leave the "sybase" account with a higher privilege than needed.

CR:403797

CR Number:   403797 Product Name:   Adaptive Server Enterprise Product Component:   Graphical Plan Viewer Status:   Closed OS:   NA Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Sep 2005 Fixed 20 Sep 2005 Fixed Description The XML for showplan_in_xml has been enhanced to cater to the changes in ASE for 15.0 ESD #1. The new XML has information that tries to bridge more gap between the text version of showplan and the xml version. For all Objects/Nodes the following Important attributes are added 1) Abstract Plan 2) Overall Cost 3) Resource 4) Optimizer Metrics 5) Optimizer Statistics [Including object for which stats is missing]

CR:403831

CR Number:   403831 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) 24 Oct 2005 Fixed Description Msg 12802, "Invalid partition number <number>. Valid partition number is a positive integer." is raised when the UPDATE PARTITION STATISTICS command is executed. The partition number is omitted but instead the WITH SAMPLING <number> clause is used.

CR:403842

CR Number:   403842 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) 03 Nov 2005 Fixed Description In rare circumstances the message "current process infected with 11" in the module 'senderror' may be reported in the error log together with a stack trace when executing a prepared dynamic statement. Workaround Description  N/A

CR:403910

CR Number:   403910 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) 19 Sep 2005 Bundled Request Description A 14108 error "Could not find partition descriptor for objid 8, indid 255, ptnid 8 in dbid <value>." followed by the message "ASE is terminating this process." may be raised when using datalength() built-in function on TEXT/IMAGE columns within a TRIGGER. The stack trace being reported in the error log will show modules 'LeRun', 'textsize', 'gettxtpage' and 'open_partition'.

CR:403968

CR Number:   403968 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 Oct 2005 Fixed Description REORG REBUILD on a single data partition is not supported yet. Added an error message 11935 in rbld_main() to warn the user.

CR:403972

CR Number:   403972 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Oct 2005 Fixed Description On SuSE 32 bit Linux platform (SuSE 9 SP1 or later), ASE incorrectly identifies AIO to be KAIO while using Posix AIO. This can lead to ASE hang. Solution is to start ASE with trace flag 1630.

CR:403975

CR Number:   403975 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 May 2006 Not a Bug Description If ASE has a default character set of utf8 and a client application uses this same charset, then ASE may return the wrong number of characters for the given column descriptor when a built-in function such as left() is executed.

CR:403978

CR Number:   403978 Product Name:   Adaptive Server Generic Docs Product Component:   XA Guide for CICS Encina and Tuxedo Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2005 Fixed Description Change... Chapter 2 Understanding Component Integration Services Proxy tables Using the create proxy_table command ... This section should also include the statement...create proxy_table...updates system tables sysobjects, syscolumns, and sysindexes ... ...making it similar to the previous section on create existing table.

CR:403979

CR Number:   403979 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Oct 2005 Fixed Description Enables CTLIB API checking for dataserver. This is done through Traceflag 11297.

CR:403986

CR Number:   403986 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) 04 Nov 2005 Fixed Description In certain rare types of operations on non-clustered indexes, fatal error 539 may be seen when out of log space.

CR:403989

CR Number:   403989 Product Name:   Adaptive Server Enterprise Product Component:   preupgrade Status:   Closed OS:   all Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2006 Fixed Description When a database has almost, but not quite, enough available space for upgrade, and the upgrade will need to create new tables in that database, the preupgrade utility may fail to detect that the database needs to be made larger.

CR:403991

CR Number:   403991 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Solaris Original Version:   12.5.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Apr 2006 Not a Bug Description The compression API does not support multiple dump files per device.

CR:403996

CR Number:   403996 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Solaris Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2005 Fixed 12 Jan 2006 Fixed Description Job Scheduler Agent has problems with Japanese job command text.

CR:404078

CR Number:   404078 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Sep 2005 Duplicate Description Previously in 15.0 GA, DBISQL launch script "dbisql.bat" (Windows) and "dbisql" (Unix platforms) contained invalid argument "-path" that caused the script to fail. This has been fixed. (The correct argument is "-Dpath".) Workaround Description  Edit the call to java to remove the "-path=$path" option in the $SYBASE/DBISQL/bin/dbisql script. before "$JAVAHOME/bin/java" -Disql.helpFolder="$DBISQL_DIR/help" -Djava.security.policy="$DBISQL_DIR/lib/java.policy" -path="$path" -classpath "$DBISQL_ DIR/lib/:$isql_jar:$jlogon_jar:$jodbc_jar:$xml4j_jar:$jconn_jar:$dsparser_jar:$helpmanager_jar:$jcomponents_jar:$jh_jar:$jsyblib_jar:$planviewer_ jar:$sceditor_jar:$uafclient_jar:$jinicore_jar:$jiniext_jar:$jmxremote_jar:$jmxri_jar:$commonslogging_jar:$log4j_jar" sybase.isql.ISQLLoader -ase $@ after "$JAVAHOME/bin/java" -Disql.helpFolder="$DBISQL_DIR/help" -Djava.security.policy="$DBISQL_DIR/lib/java.policy" -classpath "$DBISQL_DIR/lib/:$isq l_jar:$jlogon_jar:$jodbc_jar:$xml4j_jar:$jconn_jar:$dsparser_jar:$helpmanager_jar:$jcomponents_jar:$jh_jar:$jsyblib_jar:$planviewer_jar:$sceditor _jar:$uafclient_jar:$jinicore_jar:$jiniext_jar:$jmxremote_jar:$jmxri_jar:$commonslogging_jar:$log4j_jar" sybase.isql.ISQLLoader -ase $@

CR:404090

CR Number:   404090 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) 15.0 ESD#1 18 Sep 2005 Fixed Description The use of HAaseAgent for ASE 15.0 may lead to the failure of thorough probe for HAase resource on Veritas Cluster Server.

CR:404123

CR Number:   404123 Product Name:   Adaptive Server Enterprise Product Component:   omni Status:   Closed OS:   Microsoft Windows NT Original Version:   12.5.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Oct 2005 Fixed Description CIS: When a table is marked for replication with sp_setreptable, updating the table with text or image data using UPDATE or INSERT-SELECT command from a proxy XFS table results in 605 or 806 error. Workaround Description  Insert contents from XFS table to local table A. Create local table B. Turn replication on for local table B. Insert from local table A to local table B.

CR:404195

CR Number:   404195 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Microsoft Windows Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Oct 2005 Not reproducible with latest version of the product available as of Resolution Date Description ASE 15.0 uninstall leaves files and registry key entries behind.

CR:404291

CR Number:   404291 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) 02 Oct 2005 Fixed 05 Jan 2006 Fixed Description QPMETRICS: Implementing a new 'filter' command for sp_metrics. The syntax will be: sp_metrics 'filter', '@gid', '@predicate' e.g. sp_metrics 'filter', '1', 'lio_max < 100' which will delete all qpmetrics records in group 1 where lio_max < 100.

CR:404306

CR Number:   404306 Product Name:   SySAM Product Component:   SyLAPI/C Status:   Closed OS:   NA Original Version:   1.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jun 2006 Fixed Description The SySAM License Server has been updated to use version 10.8.0.7 of the Macrovision FLEXnet Licensing components. Additionally, the sysam script has been converted to Bourne Shell (previously Korn Shell) and modified to return an exit status.

CR:404355

CR Number:   404355 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2005 Fixed 07 Oct 2005 Presently Not Targeted For Any Future Release Of This Product 10 Oct 2005 Presently Not Targeted For Any Future Release Of This Product Description The system stored procedure SP_HELPCACHE may report an inacurrate name value for a given user-defined cache, if it was created with a long name initially.

CR:404391

CR Number:   404391 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) 05 Oct 2005 Fixed 07 Oct 2005 Fixed Description If a license acquired by ASE is not a permenent license or a license cannot be acquired and is awarded on grace, a new error message with severity 17, non fatal but requiring action, is printed to the dataserver's errorlog. This error message is to inform DBA that license will expire at a stated date.

CR:404470

CR Number:   404470 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Sep 2005 Bundled Request 23 Sep 2005 Bundled Request Description UPDATE PARTITION STATISTICS raises error 9810 with a stacktrace containing the function call sl_update_ctrlpg_pagecnt Workaround Description  Unpartition the table before dumping the database.

CR:404472

CR Number:   404472 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   NA Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Sep 2005 Fixed 21 Sep 2005 Fixed Description Added support for allowing plan generation for multiple queries separated by GO statement.

CR:404487

CR Number:   404487 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) 13 Jan 2006 Fixed Description Monitor counters reporting Run-Time adjustment of parallel queries are functional Monitor counters are: total number of parallel queries number of run-time-adjusted queries due to thread limit ('max parallel degree' or session 'parallel_degree' setting.) number of run-time-adjusted queries due to a lack of available processes.

CR:404489

CR Number:   404489 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) 29 Sep 2005 Fixed Description When doing text upgrade for compiled objects in ASE 15.0, the upgrade might fail with error 705.

CR:404493

CR Number:   404493 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) 05 Dec 2005 Fixed Description A 953 error may be unexpectedly raised while running the 'LOAD DATABASE' command for the master database, if ever one of the database living on the master device has been extended onto another disk device.

CR:404643

CR Number:   404643 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) 21 Nov 2005 Fixed 03 Jan 2006 Fixed Description CIS: When an error occurs while inserting data into proxy tables within a local transaction, it results in partial commits on remote pre-DTM servers.

CR:404649

CR Number:   404649 Product Name:   Adaptive Server Enterprise Product Component:   Graphical Plan Viewer Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Oct 2005 Fixed Description Fixes missing information about plan version, statement number and line number for a stored procedure.

CR:404650

CR Number:   404650 Product Name:   Adaptive Server Enterprise Product Component:   Graphical Plan Viewer Status:   Open OS:   Microsoft Windows NT Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description For scan operators in some sqls the detailed report (xhtml tab) was not shown. This cr fixes that problem.

CR:404651

CR Number:   404651 Product Name:   Adaptive Server Enterprise Product Component:   Graphical Plan Viewer Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Nov 2005 Fixed 07 Dec 2005 Fixed Description Out of many Per Key attribute for an index scan operator, only the first one was shown. This fix now shows all the perKeys for an indexScan

CR:404654

CR Number:   404654 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   Solaris Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Sep 2005 Fixed Description A signal 11 could occur in queries with non-correlated subqueries that are executed with subquery cache statistics enabled. The stack trace will include printSqCacheStats.

CR:404666

CR Number:   404666 Product Name:   Adaptive Server Enterprise Product Component:   Graphical Plan Viewer Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2005 Fixed Description Advanced tab is not shown for the versions of servers where it is inapplicable

CR:404728

CR Number:   404728 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) 25 Sep 2005 Fixed Description When resource manager and parallelism are enabled, we run into error 3630 and 11002, which aborts a query saying that it had exceeded its resource limit. This happens with queries which contain UNION/UNION ALL operators, because the query optimizer was incorrectly estimating the cost of those queries to be cheaper than they ought to be.