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

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

CR:579941

CR Number:   579941 Product Name:   Adaptive Server Enterprise Product Component:   InstallShield Status:   Closed OS:   Windows Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2009 Fixed Description An installer does not update the existing "Interactive SQL" menu at the time of upgrade installation. Shortcut has pointed out "%SYBASE%\dbisql\bin\dbisqlg.exe -ase". This program name is 12.5.2. The correct value is "%SYBASE%\dbisql\bin\dbisql.exe". Workaround Description  Please change shortcut. The correct program name is "C:\sybase\dbisql\bin\dbisql.exe."

CR:579962

CR Number:   579962 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2009 Fixed 10 Aug 2009 Reservation Made Description Full index scans may be selected over limiting index scans in scenarios where there is a single or no rows in the table and the costings are the same for both indices. An index scan is "limiting" when the key's major attribute has a sarg on it. The full-index scan may be selected if it has a minor optimizable attribute and it's ID is less than that of the limiting index. IDs increase in the order of index creation. Full-index scan strategies were never considerend in pre-15.0. Setting the configuration parameter "mnc_full_index_filter" to 3 or enabling the optcriteria full_index_filter will eliminate full-index-scan strategies. Workaround Description  If the stats are removed on col3 (so we have no histogram for that column) then it can make use of the mnc_full_index_filter criterion if it's enabled.

CR:580008

CR Number:   580008 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2009 Not a Bug Description Cannot replicate accented e in utf8. Workaround Description  Currently none. This problem occurs on warm standby, msa replication and table replication.

CR:580024

CR Number:   580024 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Tables Status:   Closed OS:   NA Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 May 2012 Added to user documentation Description The Reference Manual Volume 4 entry for the sysusers table indicates there is a unique clustered index on suid. The clustered index is actually nonunique and allows duplicate rows.

CR:580042

CR Number:   580042 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2009 Fixed 31 Aug 2009 Fixed 01 Sep 2009 Fixed 31 Aug 2012 Fixed Description sp_dbcc_configreport will report an arithmetic overflow error for databases larger than 2.5TB. Workaround Description  Using MB instead of KB for the DB size in sp_dbcc_run_configreport

CR:580098

CR Number:   580098 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) 11 Aug 2009 Fixed 18 Aug 2009 Fixed 18 Aug 2009 Fixed Description Selecting data from the monOpenObjectActivity table could cause a timeslice whilst there is a heavy load. Workaround Description  NA

CR:580264

CR Number:   580264 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Jul 2009 Fixed 14 Jul 2009 Fixed Description The use of Java within XML constructions in the ASE integrated SqlJ can lead to unpredictable results when their methods are executed within the JavaVM. Workaround Description  None

CR:580422

CR Number:   580422 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2009 Bundled Request Description DBISQL gets a stack trace when closing a connection if the connection was made after changing an expired password.

CR:580530

CR Number:   580530 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2009 Fixed 03 Sep 2009 Duplicate 12 Jan 2010 Added to user documentation 19 Nov 2009 Added to user documentation Description SySAM license quantity should not be affected by 'max online engines'. For CPU license types ASE should check-out a license quantity equal to the number of cores on the machine (or chips, depending on the license type), regardless of any configuration settings. Target Version  aries

CR:580534

CR Number:   580534 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description drop/create clustered index does not evenly distribute data among table partitions.

CR:580537

CR Number:   580537 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2009 Fixed Description monOpenObjectActivity shows incorrect information related to physical lock activity for partitioned table.

CR:580552

CR Number:   580552 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2009 Fixed Description Under very exceptional circumstances a timeslice followed by ungraceful shutdown of the server due to the LDAP_SPIN spinlock being held may be seen involving the housekeeper whilst checking ldap configuration.

CR:580579

CR Number:   580579 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Jul 2009 Fixed 27 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description Error 19991 is seen if imdb or any object in imdb is bound to a normal named cache.

CR:580597

CR Number:   580597 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2009 Consult Complete 23 Dec 2009 Not reproducible with latest version of the product available as of Resolution Date Description infected with 11 in ord_getrowbounds

CR:580606

CR Number:   580606 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Nov 2011 Bundled Request Description Request for non sa/dbo/table owner or role have set indentity_insert on capability.

CR:580834

CR Number:   580834 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2009 Bundled Request Description The error 10364, "Permission denied. You must either be the database/object owner or possess any of the following roles in order to perform this operation: '%.*s'.", is not reported even if user does not have valid permission when load transaction is executed for a temporary database.

CR:580841

CR Number:   580841 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Only replicate SQL statements.

CR:580981

CR Number:   580981 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   all Original Version:   12.5.4 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Aug 2009 Insufficient info provided Description Order by dbid,l.id page in HS statement is space exhaustive on tempdb.

CR:581043

CR Number:   581043 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Aug 2009 Fixed Description Queries from complex views may return no results at all. Running with the diagserver executable shows an assertion failure in res_view.c: "unprocessed view found"

CR:581045

CR Number:   581045 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Oct 2009 Fixed 23 Jun 2010 One-off Provided Description With statement cache\literal parameterization enabled. If a parameterizable statement has a literal value whose precision exceeds the limit of decimal\numeric (38) then a 2756 error may be received on recompile followed by a 706 error and stack trace in the error log involving the function rm_prochdr(). The spid will be terminated.

CR:581086

CR Number:   581086 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   Solaris Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Nov 2011 EOL'd version. Not to be Fixed. Description Queries, running under optimisation goal allrows_dss, that contain aggregate functions using UNION ALL may fail with 'Signal 11' or 'Access Violation' and produce stack trace containing PopMergeUnionAll. Workaround Description  Use compatibility mode or set optgoal to something other than allrows_dss for queries using union_all.

CR:581101

CR Number:   581101 Product Name:   Adaptive Server Generic Docs Product Component:   Utility Guide Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Dec 2012 Added to user documentation Description bcp with indexes is unclear in the docs.

CR:581115

CR Number:   581115 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Jul 2009 Fixed 07 Aug 2009 Presently Not Targeted For Any Future Release Of This Product Description Sometimes, creation of temporary table using 'Create table #table_name .." fails on nt386, win64 platform without giving any error.

CR:581138

CR Number:   581138 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   AIX Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Aug 2009 Duplicate 16 Aug 2009 One-off Provided 14 Nov 2012 Fixed Description Select monCachedObject cause SEGV in mda__set_ptninfo() with spinlock held. This was addressed via CR 539065. Target Version  One-off Review Status  ASE 15.0.2 ESD #6 One-off EBF 17115 Workaround Description  NA

CR:581347

CR Number:   581347 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2009 Fixed 19 Aug 2009 Fixed 27 Aug 2009 Fixed Description The Historical Server memory usage keeps growing.

CR:581380

CR Number:   581380 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Aug 2009 Fixed 16 Aug 2009 Fixed 17 Aug 2009 Reservation Made Description A NULL clause is unnecessarily appended to the ALTER TABLE MODIFY command when it is not explicitly specified in the command statement, resulting in an Oracle ORA-01442 error. This issue is specific only for Oracle and a traceflag 11237 is used to enable this fix. Workaround Description  None

CR:581422

CR Number:   581422 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2009 Fixed Description Recompilation of stored procedures reporting TABMISSING and TEMPMISSING may be seen on case-insensitive servers under traceflag 299 if column names are not consistently specified as upper or lower case in the temp table definition between executions and table re-creation. Workaround Description  Ensure temp table definitions are declared identically for the same table with respect to the case for the column names.

CR:581438

CR Number:   581438 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2010 Fixed Description New built-in function migrate_instance_id() to return the ID of the instance that initiated a task migration in SDC environment.

CR:581483

CR Number:   581483 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Aug 2009 Consult Complete 08 Sep 2009 Presently Not Targeted For Any Future Release Of This Product 08 Sep 2009 Presently Not Targeted For Any Future Release Of This Product 09 Sep 2009 Fixed 14 Sep 2009 Reservation Made 10 Sep 2009 Fixed Description When an insert is running concurrently with a delete and both DMLs are minimally logged, the performance of the insert may suffer as it blocks waiting to allocate pages that have been deallocated by the delete.

CR:581640

CR Number:   581640 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2009 Fixed Description (Internal only) A 12316 error: "Internal error: Attempt to garbage collect a deallocated data page <pageno> in table '<table_name>', database '<dbname>'. Aborting the transaction." may sometimes be raised after failover recovery, if failover recovery had done redo followed by undo of a DEALLOC record.

CR:581724

CR Number:   581724 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2009 Fixed 14 Oct 2009 Fixed 14 Oct 2009 Fixed 21 Dec 2009 One-off Provided Description During worktable creation, SIGSEGVs (infected with 11) may be reported in the errorlog. "crt_work" is usually reported in the stacktrace.

CR:581748

CR Number:   581748 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Aug 2009 Fixed 27 Aug 2009 Fixed Description After a dumped ASE 12.5.4 database was loaded into an ASE 15.0.3 server, if the database includes tables with encrypted columns which reference keys in other databases, onlining the database will cause a stack trace. The database is still brought online and can be used. Workaround Description  Ignore the stacktrace. Server continues to operate correctly.

CR:581760

CR Number:   581760 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description "capture missing statistics" will capture statistics for MDA Tables

CR:581827

CR Number:   581827 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Jul 2009 Fixed 27 Jul 2009 Reservation Made 27 Jul 2009 Fixed 23 Sep 2009 Fixed 23 Sep 2009 Fixed Description If literal autoparam is turn on, in some rare cases, the ISNULL() built-in function could return different result comparing when literal autoparam is turned off if the parameter in the ISNULL() is either a CHAR or VARCHAR datatype. Workaround Description  (zhao 7/22/09) One other simple workaround is to change the isnull(convert(char(8),...)) in the WHERE clause to isnull(convert(varchar(8),...) like: select isnull(convert(char(8),T1.M_EN_DATE,112), '00000000') + str(T1.M_NB_TRN, 11., 0.) + str(T1.M_NB_RULE, 7., 0.) + isnull(convert(char(8),T1.M_VAL_DATE,112), '00000000') + T1.M_EN_DEBIT from b T1 where ( isnull(convert(varchar(8),M_EN_DATE,112), '00000000') + str(T1.M_NB_TRN, 11., 0.) + str(M_NB_RULE, 7., 0.) + isnull(convert(varchar(8),M_VAL_DATE,112), '00000000') + M_EN_DEBIT ) = '20010704 0 48500000000AAA_FX1 ' Any of these are workarouds turn off literal autoparam if possible, remove the isnull() convert isnull statements to case statement. Example from repro 1> select 2> case when T1.M_EN_DATE is null then '00000000' 3> when T1.M_EN_DATE is not null then convert(char(8),T1.M_EN_DATE,112) 4> end 5> + str(T1.M_NB_TRN, 11., 0.) 6> + str(T1.M_NB_RULE, 7., 0.) 7> + case when T1.M_VAL_DATE is null then '00000000' 8> when T1.M_VAL_DATE is not null then convert(char(8),T1.M_VAL_DATE,112) 9> end 10> + T1.M_EN_DEBIT 11> from b T1 12> where 13> ( 14> case when T1.M_EN_DATE is null then '00000000' 15> when T1.M_EN_DATE is not null then convert(char(8),T1.M_EN_DATE,112) 16> end 17> + str(T1.M_NB_TRN, 11., 0.) 18> + str(M_NB_RULE, 7., 0.) 19> + case when T1.M_VAL_DATE is null then '00000000' 20> when T1.M_VAL_DATE is not null then convert(char(8),T1.M_VAL_DATE,112) 21> end 22> + M_EN_DEBIT 23> ) 24> = '20010704 0 48500000000AAA_FX1 ' 25> go ------------------------------------------------------ 20010704 0 48500000000AAA_FX1

CR:581945

CR Number:   581945 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Oct 2009 Fixed 12 Oct 2009 Fixed Description A 3478 error, "During undo the page timestamp value is less than new timestamp from log...", may be reported during ONLINE DATABASE after loading a transaction log from a 12.5 server, into a 15.0 or later server during which the message, "The pre-15.0 log for database '<db>' includes a CREATE INDEX incompatible with this server version and operating environment..." was reported.

CR:581950

CR Number:   581950 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Service Time for disk IO request on ASE devices.

CR:581984

CR Number:   581984 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.2 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2009 Fixed Description In some cases, dbcc checkstorage may incorrectly report the soft error "100041 (Log free space discrepancy error): Current syslogs free space does not match what dbcc counted.".

CR:582000

CR Number:   582000 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   12.5.4 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2009 Fixed 02 Aug 2009 Fixed 09 Aug 2009 One-off Provided Description Reorg rebuild / create index on a table with a CI resets systabstats.datarowsize to initial default of average row length.

CR:582009

CR Number:   582009 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2009 Fixed 23 Mar 2010 Fixed Description Queries accessing remote tables do not return any rows after a connection error even if the remote server is started up later and the connection is established.

CR:582035

CR Number:   582035 Product Name:   Adaptive Server Enterprise Product Component:   Historical Server Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jul 2009 Duplicate Description Monitor Historical Server memory usage keeps growing while creating and dropping temporary objects. Workaround Description  Reboot Historical Server. Or specify filtering criteria on a data item to exclude the data of temporary objects.

CR:582111

CR Number:   582111 Product Name:   Adaptive Server Generic Docs Product Component:   System Administration Guide Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2009 Added to user documentation Description blk for sp_who should be blk_spid

CR:582157

CR Number:   582157 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Jan 2010 Fixed 29 Nov 2010 Fixed Description The stored procedure sp_export_qpgroup raises error 213 " Insert error: column name or number of supplied values does not match table definition in 15.0.3 and higher. New columns were added to sysqueryplans but the procedure was not updated accordingly. Workaround Description  Install this changed version (additional columns added in "create table" statement). /* Sccsid = "%Z% generic/sproc/%M% %I% %G%" */ /* ** Messages for "sp_export_qpgroup" ** ** 17230, "You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure." ** 17260, "Can't run %1! from within a transaction." ** 17703, "The name supplied is not a user, group, or aliased." ** 17756, "The execution of the stored procedure '%1!' in database ** '%2!' was aborted because there was an error in writing the ** replication log record." ** 18639, "There is no query plans group named '%1!' in this database." */ /* ** sp_export_qpgroup exports in an user table (that it creates) ** the SYSQUERYPLANS section that corresponds to an AP group of ** a given user. This table has an opaque format (actually the ** same as SYSQUERYPLANS), and can be used by sp_import_qpgroup, ** maybe after having been transferred to another database or ** server. */ create procedure sp_export_qpgroup @usr varchar(255), @group varchar(255), @tab varchar(255) as declare @gid int, @uid int, @s_gid varchar(10), @s_uid varchar(10), @dbname char(30) set nocount on select @dbname = db_name() if user_id() != 1 and charindex("sa_role", show_role()) = 0 begin /* 17230, "You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure." */ raiserror 17230 return 2 end /* ** AP group handling may not be done within a transaction. */ if @@trancount > 0 begin /* ** 17260, "Can't run %1! from within a transaction." */ raiserror 17260, "sp_export_qpgroup" return 1 end /* Don't start a transaction for the user, he does not expect it. */ set chained off /* Don't hold long READ locks, the user might not appreciate it. */ set transaction isolation level 1 exec sp_aux_get_qpgroup @group, @gid out if @gid is null begin /* 18639, "There is no query plans group named '%1!' in this database." */ raiserror 18639, @group return 1 end select @uid = user_id(@usr) if @uid is null begin /* 17703, "The name supplied is not a user, group, or aliased." */ raiserror 17703 return 2 end /* prepare the UID and GID as VARCHAR, for EXEC ("...") */ select @s_uid = convert(varchar(10), @uid) select @s_gid = convert(varchar(10), @gid) /* create the export table and feed it with the APs */ execute ( "create table " + @tab + " ( uid int, gid int, hashkey int, id int, type smallint, sequence smallint, status int null, text varchar(255) null, dbid int null, qpdate datetime null, sprocid int null, hashkey2 int null, key1 int null, key2 int null, key3 int null, key4 int null )" ) /* ** This transaction also writes a log record for replicating the ** invocation of this procedure. If logexec() fails, the transaction ** is aborted. ** ** IMPORTANT: The name rs_logexec is significant and is used by ** Replication Server. */ begin transaction rs_logexec execute ( "insert into " + @tab + " select * from sysqueryplans where uid = " + @s_uid + "and gid = " + @s_gid ) /* ** Write the log record to replicate this invocation ** of the stored procedure. */ if (logexec() != 1) begin /* ** 17756, "The execution of the stored procedure ** '%1!' in database '%2!' was aborted ** because there was an error in writing ** the replication log record." */ exec ( "drop table " +@tab ) raiserror 17756, "sp_export_qpgroup", @dbname rollback transaction rs_logexec return(1) end commit transaction rs_logexec return 0 /* ### DEFNCOPY: END OF DEFINITION */

CR:582171

CR Number:   582171 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Jul 2009 Fixed 06 Dec 2009 One-off Provided Description In some queries involving distinct and temp tables, if the "capture missing statistics" configuration option is turned on, a stack trace with error "closetable: called with null SDES" can be reported in the errorlog. Workaround Description  disabled the new configuration option "capture missing statistics"

CR:582176

CR Number:   582176 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Feb 2010 Fixed Description With traceflag 3905 on, message prints during beginning a transaction but not during commit or rollback.

CR:582178

CR Number:   582178 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2009 Fixed 22 Jul 2009 Fixed Description Selecting "Tools"->"Adaptive Server Enterprise"->"Preferences" results a NullPointerException when ASE Plug-in is running on a system with Spanish locale.

CR:582201

CR Number:   582201 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2009 Fixed Description Under SMP, sp_cacheconfig a 'strict' cache but got a 'relaxed LRU' cache.

CR:582263

CR Number:   582263 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Apr 2010 Fixed 15 Oct 2009 Fixed 15 Oct 2009 Reservation Made Description If a store procedure use an unpartitioned table and the compatibility mode is turned on, it could return wrong result if later this table is changed to a partitioned table when executing this procedure.

CR:582313

CR Number:   582313 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Sep 2009 Fixed Description The error 15041, "Table Corrupt: Row %d in page %d is in the wrong partition (ID %d). The row should reside in the partition corresponding to ID %d." may be reported while running dbcc checktable() after running load database on a hppa64 platform from a dump which was taken on a linuxamd64 platform.

CR:582328

CR Number:   582328 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15 Jan 2010 Fixed Description Sometimes, the SIG 11 in the module s_handle is reported in the error log along with errors 2601 and 546 while trying to insert into a table with foreign key constraints.

CR:582344

CR Number:   582344 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2009 Fixed Description A timeslice and stack trace usually containing LeOperator*CgpNlJoin::cgpCodeGenTryNaryNLJ may be seen under rare circumstances when executing a query involving group by and aggregation. Workaround Description  Well, for the repro, remove one of the aliases from the query and AP. Or move the 'plan' keyword one character to the left. Or shorten a column name, etc, etc. But in reality, probably the safest workaround is to 'set store_index off'

CR:582396

CR Number:   582396 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   bharani Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2009 Fixed Description New audit event 125 is logged under event type "password" whenever the "disallow simple passwords" policy is violated through the setting of a simple password.

CR:582417

CR Number:   582417 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jul 2009 Fixed Description Internal only: a rolled-back update of a row in APL tables marked for incremental transfer can cause the next transfer to think the row has already been transferred when in fact it has not.

CR:582570

CR Number:   582570 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2009 Presently Not Targeted For Any Future Release Of This Product 13 Aug 2009 Bundled Request Description Currently read-only databases will return 0 via tran_dumpable_status(). This is a request to add a status bit indicating read-only and therefore not dumpable.

CR:582618

CR Number:   582618 Product Name:   SCC Web Framework Product Component:   GUI Status:   Closed OS:   Generic Original Version:   3.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Sep 2009 Fixed 16 Sep 2009 Fixed 16 Oct 2009 Fixed Description To configure SMTP port to desired port number.

CR:582708

CR Number:   582708 Product Name:   Adaptive Server Enterprise Product Component:   JVM Status:   Closed OS:   all Original Version:   12.5.4 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Fixed 05 Aug 2009 Fixed 04 Aug 2009 Fixed 17 Dec 2009 Fixed 17 Dec 2009 Presently Not Targeted For Any Future Release Of This Product Description Separate Kona JVM into a shared library that is shipped only to customers with an ASE Java license.

CR:582772

CR Number:   582772 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Sep 2009 Fixed Description In rare circumstances message "current process infected with 11" in the module 'bufread()' may be reported in the error log while booting cluster.

CR:582815

CR Number:   582815 Product Name:   Adaptive Server Generic Docs Product Component:   Reference Manual:Building Blocks Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Apr 2012 Added to user documentation Description If one of the ISNULL() parameter is CHAR or VARCHAR type and the other parameter is a string literal, in some rare cases, ISNULL() built-in function could return different results when literal autoparam is enabled comparing when literal autoparam is turned off. Workaround Description  The corresponding APs will have to be recreated to get consistent result.

CR:582855

CR Number:   582855 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2009 Fixed 26 Feb 2009 Bundled Request Description ASE errorlog contains "TPM FATAL 'unknown TPM error-level raised' for Task xxx in ThreadID yyy"

CR:582989

CR Number:   582989 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Sep 2009 Fixed 30 Sep 2009 Reservation Made Description INSERT <table> SELECT <scalars> UNION ALL SELECT <scalars> can be non-performant when there are many union sides.

CR:583007

CR Number:   583007 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2009 Bundled Request Description The warning 954, "Warning: The database '%.*s' is using an unsafe virtual device '%.*s'. The recovery of this database can not be guaranteed." is reported for the database which does not need to be recovered.

CR:583013

CR Number:   583013 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2009 Fixed Description A 1265 error may be reported in the errorlog when running DBCC CHECKSTORAGE command.

CR:583151

CR Number:   583151 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2009 Fixed Description ASE server may hit exception stack overflow on hppa64, hpia64 and winx64 due to missing EX_CLEANUP.

CR:583178

CR Number:   583178 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for new sp_dboption to prohibit 'load database'.

CR:583200

CR Number:   583200 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Sep 2009 Fixed Description In some cases, a 3327 error, "During redo, the page timestamp check found page %d needs redo ..." may be reported during LOAD DATABASE of a database dump that was taken of a database with durability NO_RECOVERY or AT_SHUTDOWN and a deallocation occurred while DUMP DATABASE was active. As a workaround, dump the database while there is no transactional activity.

CR:583228

CR Number:   583228 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jul 2009 Fixed Description Internal only: transfer 'for bcp' uses the wrong column length when transferring null decimal or numeric columns.

CR:583378

CR Number:   583378 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Open OS:   Linux Original Version:   15.0.2 ESD#6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description On certain specific platforms, the tape handling in backup server may not perform as expected resulting in the failure of multiple database backups. Workaround Description  The only workaround is to backup each database onto a different tape.

CR:583395

CR Number:   583395 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Bundled Request Description If connecting to a server with a custom agent port (e.g. "localhost:5000;9919"), the next time Connect Dialog displays the server name, the agent port number is duplicated ("localhost:5000;9919;9919) and the dialog's OK button is disabled.

CR:583403

CR Number:   583403 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Fixed 06 Aug 2009 Fixed 26 Aug 2009 Fixed Description A scanner would get a temporarily 12301 error if concurrent task deallocate the page which the scanner is working on and reallocate to same object.

CR:583422

CR Number:   583422 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2009 Fixed Description For SMP dataserver, cache deletion kept the cache entry in the system catalog sysconfigures as deleted. With this fix sysconfigures will not have the entry after the delete operation.

CR:583423

CR Number:   583423 Product Name:   Adaptive Server Enterprise Product Component:   SQL Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 02 Aug 2009 Third Party Problem Description ASE reports an error while creating a proxy table mapping to a remote IQ table name of more than 30 characters.

CR:583442

CR Number:   583442 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Aug 2009 Fixed Description Internal only: add more error reporting around file handling operations for transfer table

CR:583529

CR Number:   583529 Product Name:   XML Model Product Component:   XML Model Status:   Open OS:   all Original Version:   closluce Fixed Version Build Resolution Date Closure Code (If Appropriate) Description XML Model/Schema Definition 1.0: You can base a complex element on an existing complex element and add some elements. Elements should appear within their parent element.

CR:583708

CR Number:   583708 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2009 Fixed Description Internal only: during transfer table, incremental count of rows sent is not visible in monitoring table monProcessStatement.

CR:583727

CR Number:   583727 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request for a consolidated report on password policies in place, listing all global and login-specific settings that might apply from sp_configure, sp_alterlogin, sp_passwordpolicy and login triggers.

CR:583896

CR Number:   583896 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Windows XP Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Aug 2009 Fixed 07 Oct 2009 Fixed 07 Oct 2009 Fixed Description Create Proxy Table Wizard sometimes gets ArrayIndexOutOfBoundsException after clicking Finish.

CR:583910

CR Number:   583910 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Aug 2009 Bundled Request Description If the either of the optcriterias mnc_full_index_filter or full_index_filter is enabled, then explicitly updateable cursors (declare statement contains and update-clause) and dirty reads on APL tables could lead to a 311 error: open mycursor Msg 311, Level 16, State 2: Line 2: The optimizer could not find a unique index which it could use to scan table 'mytab' for cursor 'mycursor'.

CR:584139

CR Number:   584139 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   Linux Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2009 Fixed 27 Aug 2009 Fixed 06 Jan 2010 EOL'd version. Not to be Fixed. Description The dump command does not raise an error message for "No space left on device" on Linux when the device is closed. Workaround Description  n/a

CR:584149

CR Number:   584149 Product Name:   Adaptive Server Enterprise Product Component:   backup server Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2009 Fixed 31 Aug 2009 Fixed Description A simultaneous load operation with the same archive device name fails with 'Device already in use' error. Workaround Description  use external compression API - compress::n::

CR:584160

CR Number:   584160 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Fixed Description Update Sybase Central 6.0.0 to build 4748. This addresses the issue that simplified Chinese was displayed on a traditional Chinese environment. Now English will be displayed instead.

CR:584230

CR Number:   584230 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   12.5.4 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 14 Aug 2009 Fixed Description Server may hit timeslice error when a task tries to free all the page/row level locks associated with an object after having acquired a promoted lock, say, a table-level lock.

CR:584242

CR Number:   584242 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Linux Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Aug 2009 Fixed Description Internal only: command 'alter table ... set transfer table on' encounters a segmentation fault. This is a regression from CR 578672.

CR:584292

CR Number:   584292 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2009 Fixed 01 Sep 2009 Bundled Request 27 Aug 2009 Fixed Description Statements that use the application context builtins such as set_appcontext() while the statement cache is enabled may result in Error 4060.

CR:584296

CR Number:   584296 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2009 Fixed Description sp_displayaudit with "login" option fails with 18004 error on 15.0.x

CR:584298

CR Number:   584298 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2009 Fixed 01 Sep 2009 Fixed Description BY default, dbcc checkalloc(<dbname>) turns on traceflag 3605 with SERVERWIDE scope. This can cause other processes in the ASE to unexpectedly write messages to the errorlog while the checkalloc is running. Workaround Description  Use dbcc traceon(3604) (or 3605) or set switch on 3604 (or 3605) before running dbcc checkalloc().

CR:584332

CR Number:   584332 Product Name:   Adaptive Server Enterprise Product Component:   Sybase Central ASE Plug-in Status:   Closed OS:   Microsoft Windows Original Version:   15.0.3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2009 Fixed 28 Aug 2009 Fixed Description User see msg 'mclib.dll:can't load IA 32-bit .dll on a AMD 64-bit platform' if uses 32bits mclib.dll with 64 bits jre.

CR:584342

CR Number:   584342 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12 Aug 2009 Fixed Description ASE may crash with Signal 11 at CtlibRemoteCaps::generateConstant when it runs out of memory. Workaround Description  Make sure that the ulimit settings for data sizes are set to 'unlimited'.

CR:584457

CR Number:   584457 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Oct 2009 Fixed Description QPMetrics was not capturing ad-hoc statments when enabled statement cache. This was observed after QPMetrics lazy dumping was introduced. The change fixes the problem. Workaround Description  [sogden 12th Aug] dbcc traceon (7724) --disable the lazy dumping feature introduced via CR #451760, they will successfully flush at point of execution. ---- set statement cache off, however performance issue

CR:584467

CR Number:   584467 Product Name:   Adaptive Server Enterprise Product Component:   DBISQL Status:   Closed OS:   Windows XP Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Sep 2009 Fixed 04 Sep 2009 Fixed 30 Sep 2009 Fixed 01 Oct 2009 Fixed 06 Oct 2009 Fixed Description During execution, if the "run script" option is selected for Fix Statistics or QPTune Wizard, a stack trace occurs preventing the execution from finishing. Workaround Description  Run script file outside of the wizards.

CR:584489

CR Number:   584489 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   pyxis Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Aug 2009 Fixed 25 Sep 2009 Fixed 25 Sep 2009 Fixed Description Show 'config file version' as read-only in the output of sp_configure.

CR:584552

CR Number:   584552 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2009 Fixed 20 Aug 2009 Reservation Made 28 Apr 2010 One-off Provided Description If an insert parameterized language request with certain Numeric values is sent to the dataserver and statement caching is enabled, then a SIGSEGV (infected with 11) occurs with function calls execproc, s_setreturns, s_retparams, getvalue on the stack. A regular statement is fine with the same values. This fix is only active when traceflag 7748 is on. Workaround Description  disable statement cachce

CR:584609

CR Number:   584609 Product Name:   Adaptive Server Enterprise Product Component:   srvbuild Status:   Closed OS:   AIX Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Oct 2009 Fixed 21 Oct 2009 Fixed Description Cannot build server on AIX if LC_ALL is set to zh_TW

CR:584647

CR Number:   584647 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 Jul 2012 Fixed Description The values in "Default", "Config value", "Run Value" columns aren't right aligned when the sp_configure command is executed.

CR:584770

CR Number:   584770 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   RH Linux Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2009 Fixed Description For srvbuild, the default available physical memory value of OOB task is shown as 80% of RAM even if this value is larger than the "max shared memory" set on the operating system.

CR:584815

CR Number:   584815 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.2 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Jan 2010 Workaround Description Spike in WaitEvent 250,251 for a small number of queries in hpux and windows Workaround Description  Change the network buffer size to vary the spike in wait even id 251. Increasing the OS network buffer size, reduces the frequency of the spikes and increases the spike value. Reducing the OS network buffer size, the frequency of the spikes increases and its value decreases. One can check the OS network send buffer size with the customer for HPUX platform with ndd -get /dev/tcp tcp_xmit_hiwater_def and set using ndd -set /dev/tcp tcp_xmit_hiwater_def new_value

CR:584834

CR Number:   584834 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Open OS:   AIX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description set fmtonly performs ddl within a stored procedure Workaround Description  Pull out the related query from sproc for investigation.

CR:584851

CR Number:   584851 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UX Original Version:   15.0.3 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Aug 2009 Fixed 27 Aug 2009 Fixed 16 Sep 2009 Fixed 02 Sep 2009 Fixed 03 Sep 2009 Fixed Description If a query involves an extended column (a GROUP BY column which does not appear in the select list) and if the select list includes an encrypted column, the execution of the query will hit a stack trace reporting a null encryption key. An exemplary query is: table t2 (a2 int, b2 int encrypt with key1) select t2.* from t1, t2 where t1.a1 = t2.a2 group by t1.a1

CR:584894

CR Number:   584894 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Solaris Original Version:   15.0.3 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Jun 2010 Fixed Description When installer or "srvbuild[res]" configures an ASE, it may print error message "sh: kctune: not found." or "sh: top: command not found".

CR:585043

CR Number:   585043 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   Windows XP Original Version:   aries Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 Aug 2009 Fixed Description Internal only: The printed parameters for message 7027 are wrong, producing corrupt message text.

CR:585079

CR Number:   585079 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   all Original Version:   15.0.3 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2009 Fixed Description When an instead-of trigger contains a query that accesses the inserted or deleted log tables and the schema counts of the view upon which the instead-of trigger is created and the log (syslogs) do not match, a 11060 error may be raised, resulting from too many (10) attempts to recompile the query plan without succeeding.

CR:585168

CR Number:   585168 Product Name:   Adaptive Server Enterprise Product Component:   dataserver Status:   Closed OS:   HP-UNIX Original Version:   15.0.2 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 13 Aug 2009 Fixed 13 Aug 2009 Reservation Made Description A performance issue might be hit for a query with up to 5 joining tables involving cartesian products and/or theta-only joins.