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

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

CR:448433

CR Number:   448433 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2006 Fixed 23 Mar 2009 Presently Not Targeted For Any Future Release Of This Product 04 Dec 2006 Reservation Made 22 Jan 2007 Fixed 03 May 2009 Presently Not Targeted For Any Future Release Of This Product 15 Jan 2009 Fixed Description Enhancements to dbcc tablestats command.

CR:448485

CR Number:   448485 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) 12 Feb 2007 Fixed Description Support Direct I/O on Solaris Opteron 64 (AMD).

CR:448507

CR Number:   448507 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jun 2007 Fixed Description If an earlier release maps a proxy table to a later release and the remote table makes use of functionality not available in the earlier release, this can result in errors. This is limitation. Ex.1) A column is defined using bigint implemented in ASE 15.0, ASE 12.5.x CIS does not recognize bigint data type and will map to varchar. Ex.2) If you maps a proxy table to ASE 15.0.x and run update statistics command on the proxy table on ASE 12.5.x, error 207 will occur.

CR:448519

CR Number:   448519 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Mar 2007 Fixed 16 Feb 2007 Fixed Description AP warning message may be displayed when executing nested subquery with forceplan on. Workaround Description  Don't use 'set forceplan on'

CR:448533

CR Number:   448533 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) 21 Mar 2007 Not a Bug Description sp_configure should avoid/warn if conflict between max mem and os shmmax

CR:448556

CR Number:   448556 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) 12 Dec 2006 Fixed 11 May 2007 Added to user documentation 27 Mar 2007 Fixed 22 Aug 2007 Fixed Description Interactive SQL on Windows used to be launched by a batch file "dbisql.bat". This is now replaced by a Windows native launhcer.

CR:448617

CR Number:   448617 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) 30 Jan 2007 Fixed Description Executing sp_showplan and passing in the spid of a running bcp process can result in a stack trace which includes the module le_showE_Stmt. Workaround Description  The client can avoid calling sp_showplan and passing spid of bcp process by including the option 'BULK INSERT' in the query in sp__showplan:- select spid,program_name,suid,cpu,physical_io,dbid,id from master..sysprocesses where cmd not in ("AWAITING COMMAND","NETWORK HANDLER","DEADLOCK TUNE", "MIRROR HANDLER","HOUSEKEEPER","CHECKPOINT SLEEP","ASTC HANDLER", "BULK INSERT") and spid <> @@spid

CR:448618

CR Number:   448618 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) 13 Dec 2006 Fixed Description sp_helprotect <permission_name> should provide information for any specific permission granted in a given database.

CR:448650

CR Number:   448650 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Digital UNIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Nov 2009 Not reproducible with latest version of the product available as of Resolution Date Description Under some circumstances optdiag output shows negative values for the forwarded and/or deleted row counts for DOL tables.

CR:448661

CR Number:   448661 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) 17 Dec 2006 Fixed 18 Dec 2006 Fixed Description When the stored procedure sp_modifystats is issued with MODIFY_DENSITY option, Error Msg 553: "The number of parameters/variables in the FETCH INTO clause does not match the number of columns in cursor 'new_densities' result set." is raised. The output for 'Column Group' may be incorrect (show NULL) if multiple columns are involved e.g. composite index.

CR:448676

CR Number:   448676 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Mar 2007 Fixed Description with Cell based HP Itanium server SPDC fails generate a license if the partition number is appended or SYSAM-2_0 fails to recognize generated licenses without partition number Workaround Description  Ask the customer to generate the required license(s) or generate the licenses on behalf of the customer (but using customer's account/entitlement - please note only limited CS&S folks have this capabilit) by specifying the HostID without the partition part. E.g. use 76758260-e689-11da-ad92-532f0cec20cf not 76758260-e689-11da-ad92-532f0cec20cf_P0 Once generated, change the HOSTID in the license to the correct value, TAR up all the licenses and send them to help_sysam@sybase.com (NOTE this is an internal email alias and should not be disclosed to customers) Someone on that alias will then re-generate the licenses and return them.

CR:448725

CR Number:   448725 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) 01 Dec 2006 Fixed 05 Dec 2006 Fixed Description A timeslice error followed by the all_active_devices() and modules db_fill() may be raised when loading a very big archive database. Workaround Description  If the server is used only for maintenance then the 'cpu grace time' can be increased to a very high value in order to pass the critical point where the DBTABLE is instantiated.

CR:448733

CR Number:   448733 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2006 Fixed 04 Jan 2007 Fixed Description A stack trace may occur when opening a cursor against a prepared dynamic statement with parameters that references proxy tables.

CR:448868

CR Number:   448868 Product Name:   Adaptive Server Platform_Specific Docs Product Component:   Configuration Guide for UNIX Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Jan 2007 Fixed Description Sort Order ID 53 should be case insensitive in Table 7-17 (Configuration Guide for UNIX) or Table 6-17 (for Windows).

CR:448872

CR Number:   448872 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Nov 2006 Fixed 11 Dec 2006 Fixed 12 Mar 2007 Fixed Description Process afftected with sig11 in GtqSingleSubqScan::GtInitGcPerGt(OptBlock*) for 15.0.1 esd1 binary when there is a subquery under OR and a LIKE predicate under OR at the same time. Here is an example: ... where (user_name(o.uid) like @uname or (@nouname = 1 and not exists (select 1 from sysobjects o2 where o2.name=o.name and user_name(o2.uid)=@uname) and user_name(o.uid) = "dbo" ) )

CR:448907

CR Number:   448907 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2014 Fixed 09 May 2014 One-off Provided 12 Feb 2014 Reservation Made 10 Apr 2014 Fixed 15.7 SP130 11 Apr 2014 Reservation Made 26 Jun 2014 Fixed Description Adds the PREPARE DATABASE command. This command is very similar to the QUIESCE DATABASE command, with the exception that it does not block write activity during the HOLD phase. The HOLD/RELEASE options can be used to execute a mirror split or snapshot on the database using a certified agent, to create a copy of a database on which transaction logs can be loaded.

CR:448911

CR Number:   448911 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Nov 2006 Fixed Description Queries containing a UNION ALL and an ORDER BY clause and having a column with a datatype of TEXT, IMAGE or UNITEXT in the select list on one side of the UNION ALL and a CONVERT builtin function to convert a literal string to a TEXT, IMAGE or UNITEXT datatype will result in a segmentation violation with the function, sendtext in the stack trace.

CR:448912

CR Number:   448912 Product Name:   Sybase SQL Server Product Component:   dataserver Status:   Closed OS:   Unknown Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Feb 2007 Fixed Description Internal indexes created on replicate tables with text/image columns will use as index ID the firt free starting from 250, in decrease order.

CR:448978

CR Number:   448978 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2007 Fixed 14 Mar 2008 Not reproducible with latest version of the product available as of Resolution Date 05 Nov 2008 Fixed Description Under some rare conditions, the message "current process infected with 11" in the module 'qualpage' together with a stacktrace which includes the module 'getpage_with_validation' may be reported in the error log if a query is executed with materialized derived table.

CR:448987

CR Number:   448987 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2006 Fixed 26 Jan 2007 Fixed Description Wrong result could happen for union/unionall over outer join when one of union/unionall projection is a column from an outer join inner table.

CR:449011

CR Number:   449011 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   all Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2006 Fixed 30 Nov 2006 Presently Not Targeted For Any Future Release Of This Product 24 Jul 2007 Presently Not Targeted For Any Future Release Of This Product 20 Sep 2007 Presently Not Targeted For Any Future Release Of This Product Description Job Scheduler templates fail to install on Solaris.

CR:449021

CR Number:   449021 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2007 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description In a server configured to use a multi-byte character set by default, the replication of text being bulk copied could fail if the BCP client is using a single-byte character set.

CR:449048

CR Number:   449048 Product Name:   Adaptive Server Enterprise Product Component:   Language Modules Status:   Closed OS:   Solaris Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Feb 2010 Duplicate Description Customer needs Russian localization files

CR:449148

CR Number:   449148 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Dec 2006 Fixed 01 Dec 2006 Fixed Description The stored procedure sp_plan_dbccdb may incorrectly display archive database devices as recommended devices on which to install the 'dbccdb' database.

CR:449177

CR Number:   449177 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2006 Fixed 29 Jan 2007 Fixed 05 Jan 2007 Fixed Description The message: current process infected with 11 within the function, CgLavaUtils::CgSetAlign, and a stack trace that includes the function, CgGenLava::CGConsMJOp can occur when the optimizer chooses a query plan with a MergeJoin operation that includes literal values in the projection list of the inner stream of rows to the MergeJoin operator. Target Version  One-off

CR:449203

CR Number:   449203 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Dec 2006 One-off Provided Description This problem only occurs in systems using a non-binary sortorder. This problem only occurs in distinct queries with an order-by clause. Further, the target list must contain an expression, and there must be a character type column in the target list or order-by clause, and the number of columns in the target list plus order-by clause must exceed 32 columns. If all of these conditions hold, then the query may return the wrong number of rows. Workaround Description  set distinct_sorting 0 go

CR:449293

CR Number:   449293 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jan 2007 Fixed 12 Apr 2007 Fixed 16 Apr 2007 Presently Not Targeted For Any Future Release Of This Product Description If there is a cursor fetch statement right before calling sp_helpartition and if that fetch is from an empty table, 515 error might be raised from sp_helpartition.

CR:449301

CR Number:   449301 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Feb 2007 Fixed 12 Feb 2007 Fixed 19 Feb 2007 Fixed Description A 510 error, "Bad eop type 0x...", may be reported in the errorlog together with a stack trace which includes the modules 'execproc' and 'tdsrecv__dynexec' when executing a dynamic parameterized sql statement which used one of the following string manipulation functions: SUBSTRING(), LTRIM(), RTRIM(), RIGHT(), LEFT(), UPPER() or REVERSE() and the parameter's length value exceeds 255 characters. Workaround Description  Open client library 12.5.1 ESD12 may detect big CHAR parameter for the dynamic execute command. Use traceflag -T244 to use MAXSTRLEN for unknown result length and dynamic SQL '?' parameters.

CR:449327

CR Number:   449327 Product Name:   Adaptive Server Enterprise Product Component:   diagserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Nov 2006 Fixed Description The following sequencer of queries will cause a segmentation violation: 1> set plan for show_execio_xml to client on 2> go 1> select showplan_in_xml(0) 2> go The call stack will include the function, resetTraceObj.

CR:449408

CR Number:   449408 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Sep 2007 Fixed 11 Oct 2007 Fixed 11 Oct 2007 Fixed Description When a parallel query needs a runtime adjustment the runtime recompilation may incorrectly identify query objects and raise spurious errors like 'Table not found' or 'Permission denied'

CR:449417

CR Number:   449417 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) 01 Jan 2007 Fixed 28 Apr 2008 Presently Not Targeted For Any Future Release Of This Product Description 'select on syscomments.text' configuration parameter doesn't restrict access to syscomments.text. Workaround Description  Run the command: 'revoke select on syscomments(text) from public'

CR:449423

CR Number:   449423 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2006 Fixed 03 Jan 2007 Fixed 10 Jan 2007 Fixed Description In rare circumstances the error 403 will be raised and caused by the version 15.0.1 ESD#1. Adding a convert() is a good workaround. Workaround Description  it looks like code generation is trying to convert the character to a length of -1 instead of 255. It looks like a workaround may be to an explicit conversion to override the implicit conversion, something like. select o.uid, o.name from sysindexes i, sysobjects o where o.name like "%" and o.name = convert(char(255), object_name(o.id)) and i.id = o.id

CR:449478

CR Number:   449478 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2007 Added to user documentation Description ASE 15.0 System Administration Guide says that default values for abstract plan cache, abstract plan dump, abstract plan load and abstract plan replace are 1 (on). But in fact they are 0 (off).

CR:449492

CR Number:   449492 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Dec 2006 Fixed 10 Feb 2007 Fixed 08 May 2007 Fixed Description It was impossible to change configuration parameter 'messaging memory' when 'enable real time messaging' equals 0 (RTDS option disabled). That CR addresses that issue, allowing the user to modify 'messaging memory' configuration parameter before enabling RTDS.

CR:449498

CR Number:   449498 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 Jun 2009 Fixed 01 Feb 2008 Fixed 23 Mar 2009 Fixed 30 Apr 2009 Fixed 05 Jun 2009 Reservation Made Description New feature "deferred name resolution" that allows the creation of stored procedures postponing the name resolution phase to the stored procedure execution time.

CR:449502

CR Number:   449502 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows W2k Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Jan 2007 Fixed 09 Jan 2007 Fixed Description An existing Job Scheduler installation fails to start after 15.0.2 upgrade. Workaround Description  Edit scripts/installjsdb, search for ssql_sid=20, in sql below this change the line SELECT isnull(max(srvid),0)+1 ,@status ,'SYB_JSTASK' ,'%s' ,7 ,NULL ,1000 to SELECT isnull(max(srvid),0)+1 ,@status ,'SYB_JSTASK' ,'%s' ,7 ,NULL ,1000, 0 Drop sybmgmtdb or delete from js_seqsql where ssql_sid=20 then re-run installjsdb

CR:449518

CR Number:   449518 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2006 Fixed 16 Jan 2007 Fixed 05 Jan 2007 Fixed 07 Aug 2007 Bundled Request Description It is possible to run ONLINE DATABASE after a LOAD TRANSACTION command that failed during recovery of the database. Workaround Description  N/A

CR:449584

CR Number:   449584 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Dec 2006 Fixed 19 Dec 2006 One-off Provided 04 Dec 2006 Fixed 05 Dec 2006 Fixed 31 Jan 2007 Fixed 01 Feb 2007 Fixed Description ASE will use kernel asynchronous i/o on Linux. Traceflags 1630, 1639, and 1649 are now obsolete. Synchronous i/o will be used on file system devices that do not support kaio, such as tmpfs.

CR:449709

CR Number:   449709 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Dec 2006 Fixed 14 Dec 2006 Reservation Made 20 Dec 2006 Fixed 06 Feb 2007 One-off Provided 26 Jan 2007 Fixed Description A query has a SQL derived table and the derived table has a column from a subquery. If the query joins between the column on the derived table and a column on another table using LEFT OUTER JOIN clause, the query will get error 325 (Adaptive Server finds no legal query plan for this statement.). Workaround Description  Avoid using the derived table with a subquery in the select list. But usually our customers' queries are too complicated to be changed.

CR:449756

CR Number:   449756 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.4 ESD#3 08 Dec 2006 Fixed 17 Aug 2005 Presently Not Targeted For Any Future Release Of This Product Description Adaptive Server Enterprise 12.5.4 ESD#2 running on unix platforms fails to provide a stack trace when an engine encounters a signal condition. Instead, the message "engine exited with signal <number>" is seen without any further diagnostics. Workaround Description  Upgrade to 12.5.4 ESD#3 or later release.

CR:449779

CR Number:   449779 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Dec 2006 Fixed 08 Mar 2007 Fixed Description Stack trace could occur during joins between local and remote tables with IN clauses.

CR:449888

CR Number:   449888 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2007 Fixed Description A "select into" with a partition clause from a view that contains a union may cause a stacktrace.

CR:449908

CR Number:   449908 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for the ability to generate a shared memory dump for any error that causes ASE to shutdown because the spid was holding a spinlock.

CR:449961

CR Number:   449961 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Enable a group of users working together to have equivalent object permissions for any objects created by a user in the same group, including dropping objects. Workaround Description  Giving SA role to the users. This is not acceptable to the user who required this Feature to be requested.

CR:450005

CR Number:   450005 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) 23 Feb 2007 Fixed 06 Aug 2007 Fixed 14 May 2007 One-off Provided 26 Jul 2007 Fixed Description When a stored procedure involving joins on regular tables and a derived table must be recompiled due to a schema change, column names might not be resolved correctly, yielding an erroneous "ambiguous column" error. Workaround Description  create procedure sel_actions_syb as select d_a.xxx as cloud_id from netcool_actions na, event_actions ea, (select a.cloud_id from actions a, #action_ids t where a.cloud_id = t.cloud_id ) d_a (xxx) where na.cloud_id = d_a.xxx and ea.cloud_id = na.cloud_id go

CR:450010

CR Number:   450010 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) 22 Jan 2007 Fixed Description Partition elimination does not happen if a disjunctive predicate is given to a query where each side of the disjunction can result in partition elimination and the same set of predicates on partitioning columns appear in each side of the disjunction. Ex. (col1 = 10 AND col2=20) or (col1=10 AND col2=30) will be rewritten by the predicate factoring functionality as (col1 = 10) AND (col2 = 20 or col2 = 30), which results in a partial match of the columns used in partitioning i.e. col1 and col2 with the conjunctive predicates and prevents partition elimination.

CR:450039

CR Number:   450039 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Open OS:   Solaris Original Version:   12.5.4 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description srvbuild/srvbuildres:The order of -s parameters is different in RUN_Server files Workaround Description  Modify -s parameter to first position in RUN_SERVER file.

CR:450045

CR Number:   450045 Product Name:   Adaptive Server Enterprise Product Component:   Job Scheduler Status:   Closed OS:   Windows W2k Original Version:   12.5.4 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Sep 2007 Fixed 21 Nov 2007 Fixed Description Job Scheduler work abnormally when startdate is earlier than 83 days from present date. Workaround Description  Modificated the sched_startdate of js_schedules to the current date which should be the current date or very closed.

CR:450066

CR Number:   450066 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   One-off Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Jan 2007 Fixed Description Get msg 11060 when exec procedure which has SELECT INTO with encrypted columns.

CR:450105

CR Number:   450105 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Dec 2006 Fixed 18 Jan 2007 Fixed 21 Jan 2008 Fixed Description The message 'current process infected with 11' in module 'level0_restart' may be reported in the error log when SP_SHOWPLAN is run or the configuration option 'plan text pipe active' is set and concurrent activity on table Syscolumns takes place. Modules 'showplan', 'showKeys' and 'getcolname_level0_fromcache' will also be reported in the stack trace. Workaround Description  Try turn off "plan text pipe active" if it was set.

CR:450130

CR Number:   450130 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jan 2007 Fixed 23 Jan 2007 Fixed 18 Jan 2007 Fixed 22 Jan 2007 Fixed Description The error 8207 "Couldn't find an available descriptor for an object. Raise the value of the configuration parameter 'number of open objects' for more descriptors." may be raised in general, after errors 1204 were reported "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS." when ASE runs out of locks during the instantiation phase of a descriptor's meta-data, resulting in leaking free descriptors mistakenly. Workaround Description  Increase "number of locks" to prevent error 1204. Or increase "number of open objects" to get more free DES structures.

CR:450238

CR Number:   450238 Product Name:   Adaptive Server Enterprise Product Component:   syconfig - PC Status:   Closed OS:   Microsoft Windows Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2006 Fixed Description When execute "sybatch.exe -r <resource file" to upgrade an ASE server, an error msg is printed to the console saying it can't find RUN_<server>.bat file in the new %SYBASE%\%SYBASE_ASE%\install directory. Workaround Description  * Manually boot the old ASE. To boot the old ASE, do the following in a command prompt: - Set PATH, SYBASE, SYBASE_ASE, and SYBASE_OCS environment variables to the old ASE directories - Execute the old %SYBASE%\%SYBASE_ASE%\install\RUN_<server>.bat * Execute new "sybatch.exe -r <resource file>" while the old ASE is running

CR:450254

CR Number:   450254 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) 09 Jan 2007 Fixed Description Tables with large number of partitions may spawn a whole bunch of worker processes without getting any positive scaling. This is due to the fact that the optimizer makes an assumption that a large number of partitions mean that the table can support a parallel scan with the same number of threads as the number of partitions, which may not be the case. Often times, users have a large number of partitions because of manageability. This bugfix allows user to configure the maximal number of threads for a table or an index using the sp_chgattribute stored procedure.

CR:450261

CR Number:   450261 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Jan 2007 Fixed 25 Jan 2007 Fixed Description There are 2 types of OR optimization (i.e. predicates involving IN list or OR lists) One is the general OR optimization which requires a HASH operator to remove duplicate RIDs and another which removes duplicate keys (e.g. sorts the IN list to remove duplicates, which can be done at compile time if none of the keys are variables). The general OR optimization is usually takes more elapsed time, and the duplicate key approach should be preferred. This change corrects costing that prefers the duplicate key approach which could improve performance in some cases. An example of the type of query that may be helped by this is the following. select * from sysusers where name in ('dbo', 'sa_role', 'guest', 'probe') go

CR:450288

CR Number:   450288 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 Dec 2006 Fixed 14 Dec 2006 Fixed Description When it is a 13941 error where the expected message is " Cannot partition table xxx because your release level does not support partitioning.", it shows up as a 4941 error whose message is, " You cannot drop a column on which constraints are defined. Drop the constraints before dropping this column.".

CR:450359

CR Number:   450359 Product Name:   Adaptive Server Enterprise Product Component:   MDA/Monitoring Tables Status:   Closed OS:   AIX 5.1 Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Dec 2006 Fixed 28 Feb 2007 Fixed 24 Apr 2007 Fixed Description sp_monitor aborts with an error reporting that the server "loopback" does not exist. Workaround Description  Define a remote server called "loopback" using the sp_addserver stored procedure: sp_addserver "loopback", NULL, <any server name>

CR:450395

CR Number:   450395 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Dec 2006 Fixed Description Previously Query Editor sometimes would not populate tables correctly. This has been fixed.

CR:450398

CR Number:   450398 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Jan 2007 Fixed 06 Feb 2007 Fixed Description Subsequent execution of a stored procedure with insensitive cursor with constant literal in the select list may give incorrect result.

CR:450458

CR Number:   450458 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2007 Fixed 11 Jan 2007 Fixed Description When performing 'disk refit' after 'load database master', ASE can find allocation units on disk that are no longer part of a database and so should not be reflected in sysusages. Attempting to remove the extraneous entries can encounter a segmentation fault and stack trace, causing disk refit to fail.

CR:450459

CR Number:   450459 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Feb 2007 Fixed Description Expressions on sargs were not always evaluated when it should have been possible to obtain a temporary value to be used for histogramming estimation. When this was not done then default selectivities were used for estimates which could result in incorrect join orders. All possible constant expressions are now evaluated at compile time, if it could help with producing a histogramming sarg. for example, "r.a > <some constant case expression>" would not be used for histogramming estimates, and instead the default selectivity of 0.33 would be used for this sarg.

CR:451308

CR Number:   451308 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Oct 2007 Fixed 02 Oct 2007 Reservation Made 05 Oct 2007 Fixed 10 Jul 2009 Insufficient priority to fix 27 Oct 2014 Insufficient priority to fix Description New feature to support plan sharing of cached statements across different users. Trace flag 7738 needs to be turned on to enable the feature.

CR:451323

CR Number:   451323 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) 15 Jan 2007 Fixed Description Add new options 'expire login passwords', 'expire role passwords', 'expire stale login passwords' and 'expire stale role passwords' to sp_passwordpolicy procedure to expire login and role passwords.

CR:451355

CR Number:   451355 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2007 Fixed 19 Jan 2007 Fixed Description There is a short-term memory leak for Lava hash operators that appear in the inner side of a nested-loop join strategy or beneath a subquery. A relatively small amount of memory is temporarily lost for each outer or correlated row in the NLJ strategy or subquery respectively. If there are a lot of rows in the outer side of an NLJ strategy or in the outer block of a subquery, then the cumulative amount of memory temporarily lost can be quite large. Note that this memory is given back to the system once the query completes.

CR:451412

CR Number:   451412 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) 19 Jul 2007 Fixed 07 Aug 2009 Fixed Description In isolation 2, when we are doing ridjoin we are not holding locks on the pages till the end of the transaction.

CR:451448

CR Number:   451448 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 Feb 2007 Fixed 08 Oct 2007 Fixed Description Queries that use the special or startegy and have a descending order by clause may return results in the wrong order. This will occur if one or more of the columns in the disjuncts always reference the same literal value.

CR:451453

CR Number:   451453 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Dec 2007 Fixed 01 Apr 2008 Not a Bug Description A low risky stacktrace occurs when sending a message to Tibco JMS messaging bus if the Tibco JMS has been enabled before dataserver is booted and the dataserver is booted without setting environment variable "SYBASE_JRE".

CR:451456

CR Number:   451456 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SYSAM2.0: If the Sysam Option file is modified to direct log files to a non-default location, the default log file is still created due to the '-l <logFile>' arguments coded into the sysam startup script. Workaround Description  Modify the sysam.bat script (or platform equivalent) and remove the '-l "%dbglog%' agrs from the command line.

CR:451524

CR Number:   451524 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2007 Fixed 29 Mar 2007 One-off Provided 08 Nov 2007 Fixed 27 Nov 2007 Fixed Description DUMP DATABASE WITH COMPRESSION will generate an invalid dump if the archive is a library created using the backup API. For example, DUMP DATABASE dbname TO "compress::myfile" WITH COMPRESSION=n.

CR:451549

CR Number:   451549 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) 22 Dec 2006 Fixed 03 Jan 2007 Fixed 03 Jan 2007 Reservation Made 11 Jan 2007 Fixed 26 Jan 2007 Fixed Description server might hit sig11 in CgpGlobal::CgpGenerate() when executing a query involving a DISTINCT view and the part of the DISTINCT columns has a unique index on them. Workaround Description  A quick workaround for this query is to remove the "distinct" from the view definition, because that is not necessary due to the existence of the unique index.

CR:451650

CR Number:   451650 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request to provide a way to estimate the amount of space required for a table containing encrypted columns automatically. Workaround Description  Calculate actual length of encrypted columns based on the manual "Using Encrypted Columns in Adaptive Server". And then create a dummy table and run sp_estspace on it. 1> create table test_normal ( 2> key1 numeric(10) identity, 3> data1 varbinary(33), 4> data2 varbinary(33), 5> data3 varbinary(33) 6> ) 7> go 1> sp_estspace test_normal, 100000, NULL, "data1,data2,data3" 2> go test_normal has no indexes name type idx_level Pages Kbytes --------------------------------- ------------ --------- ------------ ------------ test_normal data 0 5777 11555 (1 row affected) Total_Mbytes ----------------- 11.28 (return status = 0) 1>

CR:451682

CR Number:   451682 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jan 2007 Fixed 07 Feb 2007 Fixed Description Variables within derived table expressions within cursor declarations within stored procedures are not initialized correctly during execution of the stored procedure.

CR:451690

CR Number:   451690 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) 23 Jan 2007 Presently Not Targeted For Any Future Release Of This Product 20 Dec 2006 Fixed 23 Jan 2007 Fixed 17 Jan 2007 Fixed Description There was an overestimate of PIO for tables which are bound to a large buffer pool, and also have a reserved page count significantly higher than the table pages. This was due to a double costing of the page cluster ratio, in addition to the sparseness of rows in the extent. Adjustments were made to avoid the double costing so that PIO estimates for large IO are more accurate

CR:451696

CR Number:   451696 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) 26 Feb 2008 Consult Complete 16 Jan 2008 Fixed Description Secure role passwords by storing them using SHA-256 in syssrvroles.

CR:451739

CR Number:   451739 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 Feb 2007 Presently Not Targeted For Any Future Release Of This Product 08 Feb 2007 Fixed 28 Feb 2007 One-off Provided Description QPmetrics are not captured for non-CIS related query after CIS connection has been established within a particular session

CR:451749

CR Number:   451749 Product Name:   XML Model Product Component:   XML Model Status:   Closed OS:   all Original Version:   telemaque Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Feb 2007 Fixed 19 Feb 2007 Fixed Description Fail to consolidate repository when Item sequence changed in XML model.

CR:451751

CR Number:   451751 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2007 Fixed Description The authentication mechanism may be missing or truncated in the audit trail for a login event when a Kerberos principal name and mapped user login name approaches 30 bytes in length.

CR:451760

CR Number:   451760 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) 30 May 2008 Presently Not Targeted For Any Future Release Of This Product 02 Sep 2007 Fixed 03 Sep 2007 Fixed 19 Jun 2012 Added to user documentation Description When statement cache is configured, the QPmetrics for ad-hoc statement using statement cache will not be dumped into the SYSQUERYMETRICS system catalog instantly. Instead, the QPmetrics of respective ad-hoc statements will be dumped when the statement is flushed out from the statement cache or by commands such as sp_metrics 'flush' and dbcc purgesqlcache.

CR:451812

CR Number:   451812 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jan 2007 Fixed 25 Jan 2007 Fixed 23 Jan 2007 Reservation Made Description In some cases, intelligent index scan may cause low LIO estimate and wrong index is chosen for the plan resulting in poor performance. Workaround Description  The customer said they cannot use abstract plan to workaround the problem due to the query has views with tables stored in different databases. Has asked them to provide more precise statistics to see if it can help or not.

CR:451821

CR Number:   451821 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jun 2007 Fixed Description Deadlock occurs when a successful LDAPUA updates the syslogins password or the syslogins lastlogindate is being updated for the first time. This occurs when the update is on the same login row by two different login tasks.

CR:451837

CR Number:   451837 Product Name:   Adaptive Server Enterprise Product Component:   Language Modules Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Sep 2012 EOL'd version. Not to be Fixed. 14 Sep 2012 Insufficient info provided Description Default LANG of Japanese RHEL4.0 is "ja-JP.UTF-8." But "ja_JP.UTF-8" is not included in Linux section of locales.dat. Please add the following lines to linux section of locales.dat. locale = ja_JP.UTF-8, japanese, utf8 Workaround Description  Please add the following lines to linux section of locales.dat. locale = ja_JP.UTF-8, japanese, utf8

CR:451875

CR Number:   451875 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) 05 Dec 2007 Duplicate Description Excessive procedure cache used when too many statistics steps are configured. Consider reducing number of steps or histogram tuning factor. Workaround Description  1) reduce the number of histogram steps, since they are way too large, especially when histogram tuning factor is taken into consideration.

CR:451898

CR Number:   451898 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) 11 Jan 2007 Fixed 12 Jan 2007 Fixed Description There are some inconsistencies in pre-15.0 statistics that are corrected during upgrade. In this case, there were range cells and yet the range density was zero, which occurs occasionally due to a pre-15.0 problem in update statistics in which the range cell only exists in the last cell of the histogram and the remaining cells are frequency cells. The inconsistency are now corrected during upgrade to 15.0.

CR:451900

CR Number:   451900 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 May 2007 Presently Not Targeted For Any Future Release Of This Product 15 May 2007 Fixed 15 May 2007 Presently Not Targeted For Any Future Release Of This Product Description Error 1013 will be raised if japanese object name is specified in an abstract plan.

CR:451902

CR Number:   451902 Product Name:   Adaptive Server Enterprise Product Component:   FTS SDS Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Feb 2007 Fixed Description If you create a table and add a numeric identity column to the table, sp_create_text_index fails on the table with a message "Datatype numeric ( Column 'xxx' ) is not supported in a text index.".

CR:451928

CR Number:   451928 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) 16 Oct 2008 Fixed Description When no valid license is available for the platform on which ASE is running, but licenses are available for other platforms, then ASE may crash on startup with a signal 11 after reporting "SySAM: Using licenses from" . Target Version  15.0.3 Workaround Description  Removed the DEMO license for non-solaris platform and just keep the right license.

CR:451934

CR Number:   451934 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Feb 2007 Fixed 21 Feb 2007 Fixed 27 Feb 2007 Bundled Request Description Selecting from a decrypt_default table from a different database causes segment fault error.

CR:451944

CR Number:   451944 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Dec 2006 Fixed 28 Jun 2007 Fixed Description Loading a compressed archive database may hang if the size of the compression memory pool is set to the minimum size required that is the double of the dump blocksize. Even if the LOAD command succeeds, the hang can happen at anytime because the compression memory gets fragmented.

CR:451945

CR Number:   451945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jan 2007 Fixed 27 Jun 2007 Not a Bug Description When loading an archive database, the message 'Unable to determine the size of the device '<devname>'' will be raised for each device installed that is unavailable.

CR:451966

CR Number:   451966 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Mar 2007 Fixed 05 Mar 2007 Fixed 12.5.4 05 Mar 2007 Fixed Description HA command, sp_companion may fail for HA-enabled dataserver on Sun Cluster 3.1 running on Solaris 10.

CR:452023

CR Number:   452023 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Jan 2007 Fixed 11 Jan 2007 Fixed Description Union query with subquery could cause staktrace in s__mergelock_in_sub_steps(). This will happen only when there is datetype mismatch and implicit conversion is need and also involve subquery in expression.

CR:452033

CR Number:   452033 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   HP-UNIX Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Jun 2008 Fixed 07 Aug 2008 Fixed 24 Oct 2008 One-off Provided Description Backup Server needs to print Open Server operating system related error message in error log as well as standard error.

CR:452045

CR Number:   452045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Feb 2007 Duplicate Description Provide encrypted colums support in the 12.5.4 64 bit linux release.

CR:452118

CR Number:   452118 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX 5.1 Original Version:   15.0.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jan 2007 Fixed 24 Jan 2007 Fixed 24 Jan 2007 Reservation Made 29 Jan 2007 Fixed 20 Mar 2007 Fixed Description If estimation errors occur with join cardinality estimations, or estimates with index scans on DOL tables, then update statistics with this fix may correct those estimates. The problem of inaccurate statistics occurs when the "with consumers" phrase is used on update statistics or a clustered index is created on a partitioned table.

CR:452160

CR Number:   452160 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Feb 2007 Not a Bug Description When it connects with server from Sybase Central v4.3 attached to ASE 15.0.x, Explanation of "number of open partitions" is wrong. This Explanation is "cpu grace time."

CR:452178

CR Number:   452178 Product Name:   Adaptive Server Enterprise Product Component:   optdiag Status:   Closed OS:   all Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Apr 2009 Insufficient priority to fix 05 Aug 2008 Fixed Description Optdiag input mode may fail with error message "At step <n> of the histogram for <column>, the step value is not increasing" for variable length datatypes. Workaround Description  Use the binary mode of optdiag.

CR:452189

CR Number:   452189 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   12.5.4 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Feb 2007 Fixed 04 Mar 2007 One-off Provided 05 Mar 2007 Fixed 17 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date Description Incorrect code execution on ibmaix64 for fbo mode may lead to difference in selectivities for sarg.

CR:452198

CR Number:   452198 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2007 Duplicate Description Bad offset in variable length offset table causes 9289 from RA Workaround Description  Since using the trace flag 9217 is not available on this customer's release/EBF level, the only option is to move the secondary truncation point to the next page in the log and restart up the RA.

CR:452199

CR Number:   452199 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Feb 2007 Fixed Description Stored procedre creating a table with complex CHECK clause may fail with stack trace when the execution is performed from the cached plan. Workaround Description  Execute procedure with recompile

CR:452221

CR Number:   452221 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 2008 Added to user documentation Description ASE uses @@opttimeoutlimit and ASE documents use @@opttimeout as a server global variable for the current optimization timeout limit.

CR:452280

CR Number:   452280 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.1 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jan 2007 Fixed Description The message "current process infected with 11" in the module 'close_range' together with a stack trace which includes the modules 's_estmt_loopend' and 's_execute' may be reported in the error log if a DML statement is executed involving a high number of tables, the table being modified has many referential constraints and there is a trigger defined on it.