2087819 - Targeted CR List for ASE 15.0.2 ESD #6

CR number

Description

392749

When nested VIEWs are used (i.e. VIEWs defined by referencing other VIEWs), then it is possible that the query will not be correctly processed and result in an error in which the session could be terminated. If this is suspected, then it can be verified by using the diagserver and looking for an assertion such as the following: "Assertion (infinite_loop != vrangep) failed"

394172

License Monitoring is counting spids supporting the Job Scheduler as licensed users.

406502

The message "process infected with signal 11" in the module 'procstat_get' may be reported in the error log together with a stack trace which includes the modules 'exec_dbcc' and 'memusage' when a DBCC MEMUSAGE command has been previously run against a busy ASE system resulting in ASE shutting down itself.

421607

More efficient mergejoin/hashjoin plan might not be possible for MATCHNULL equijoin query. This includes the sybase extended column syntax query and the MATCHNULL join predicate coming from the predicate transformation on "r.a = s.a OR (r.a IS NULL and s.a IS NULL)".

423396

DBISQL now allows user to change password if the login's password has expired.

426791

ASE hangs or crashes when 3604 flag is enabled along with 7825, 7826 or 7827 flags.

432469

There is no error message in the errorlog indicating shared memory is locked successfully into physical memory or otherwise.

436330

Under rare conditions querying the monOpenObjectActivity table may result in error 14108 or a stack trace reported in the error log including the modules "mda_populate_monOpenObjectActivity", "mda__accumulate_ptnstats_for_obj" and "ind__get_sysindrow".

432469

There is no error message in the errorlog indicating shared memory is locked successfully into physical memory or otherwise.

437551

When an unloaded archive database exists the execution of SP_CACHECONFIG will report error 966 followed by either error 18140 or error 10855 when respectively an attempt to create a logonly cache or an attempt to drop a cache is made.

440159

syconfig.exe utility shows corrupted Chinese characters when the default language is set to Traditional Chinese.

443526

Disable installer console (text) mode on Windows because some license terms are not viewable on Command Prompt.

453374

Concurrent executions of pageinfo built-in give different kinds of errors and stacktraces, like Error 833, "Attempt to read logical page into a buffer, that is hashed".

456736

The DBCC DBCACHEREMOVE command is allowed to uncache a user defined temporary database from cache.

464192

In some circumstances, the message "current process infected with 11" together with a stack trace that includes the modules "fdpr_glue_tramp_align__fdpr", "conn_hdlr__fdpr", may be reported when using XML features on IBM Linux Pseries platform.

465823

Floating point overflow is not always detected correctly.

465917

Adaptive Server Enterprise running on the Windows platform may encounter "SERIOUS UNHANDLED EXCEPTION" with exception number e06d7363.

467500

A SELECT query with GROUP BY ALL and a scalar subquery like (SELECT 1) may report a signal 11 with a stack trace containing the module 'NormalizeScalar'.

479830

xmltable() function may not work correctly if statement cache is enabled.

482398

If an attempt is made to use DISK INIT/DISK RESIZE to add more space to a device than is actually available, the command aborts on some systems and on some systems the commands executes to add as much space as is available.

482398

If an attempt is made to use DISK INIT/DISK RESIZE to add more space to a device than is actually available, the command aborts on some systems and on some systems the commands executes to add as much space as is available.

484353

Unexpected exception is reported in the space_est report when it tries to estimate the space for a proxy table on a remote host that is down.

485661

When a query on a base table with partitions is executed, and if some of its partitions are eliminated, the parallelism degree reported in the 'Abstract plan' might be incorrect.

487452

sp_helpdevice runs slow after changing sortorder using sqlloc.

488479

In rare circumstances, the message, "Stack guardword corrupted", might be printed in the errorlog when executing at higher nesting levels.

488581

With a query having predicate like (COND1) OR (COND1 AND COND2) where COND2 contains a subquery then a stacktrace may be hit along with a server crash. The stacktrace contains the function name '_IcsAccumulatePeId' in it.

490767

Previously DBISQL failed to edit datetime field. This has been fixed in DBISQL 9.0.2 Build 3620.

491232

When we create a database with log on option, and then if we alter database to same log device (using override option) more than once, the extended device fragments (except the first extended fragment) are marked as "data and log".

491453

Update Sybase Central 4.3 to Build 2468 to better support Windows Vista. Interactive SQL is updated to Build 3620.

491600

Foreign key constraint is not checked when isolation level set to 1.

491882

Historical Server doesn't respond anymore after hs_create_recording_session is issued

492289

Previously DBISQL sometimes was not able to reliably cancel a query. This has been fixed

492688

Performance issue might be hit for a query with upto 5 joining tables involving cartesian products and/or theta-only joins.

492717

In ASE 15.0 and later, a procedure referencing a temporary table created in a caller procedure may result in signal 11 if the indexes created on the temporary table changes between executions of the caller procedure. This change of indexes on the temporary table could be caused by index creation failure due to resource issues.

492796

In rare circumstances, ASE may not start with the error message, "Error: ld.so.1: ./dataserver: fatal: libsbgse2.so: open failed: No such file or directory" when $SYBASE/$SYBASE_OCS/lib3p64 is not included in LD_LIBRARY_PATH_64.

493057

Using built-in character set conversions, ASE does not raise error 2402 and prevent the insertion of characters that are considered invalid in the client character set.

493143

Set LD_POINTER_GUARD environment variable to workaround the Adaptive Server segmentation fault.

493227

Optimizer doesn't choose the (join) SARGs present on multiple columns in an index when the columns happen to belong to same tcid i.e. are joined to only one column from outer table.

493476

Incorrect SQL generated when querying a proxy table with an IN clause that compares a constant to a list of columns.

493736

During UPDATE STATISTICS, the number of extended steps, that is, the product of the requested step count and the histogram tuning factor, is restricted to the maximum of 10% of the number of rows in the table and the requested step count. However, if the histogram tuning factor is at the default value of 20 and the proposed number of extended steps is greater than 400, then the actual number of steps in the histogram is restricted to a maximum of the requested step count and 400.

493935

Sometimes, even if all the rows on a page get deleted the page is not deallocated.

493937

A signal 11 may occured with a stacktrace involving 'ResRelOp' called from 'OptFindLegacyOj' for an OUTERJOIN query whose inner table is a VIEW with a CASE expression in the SELECT list and the CASE expression from the VIEW is also referenced in a correlated subquery above the OUTERJOIN.

494095

On some Linux platforms, installer cannot display Chinese characters correctly.

494180

When a procedure is created by sa (or a user with sa_role) and accesses an object in another database and the access permission on the object is granted to dbo through a group, then a user (who is aliased to dbo in both databases) executing the procedure may get a permission error on the object.

494321

Migrate existing Sybase Central plugins on Vista.

494337

The message "current process infected with 11" together with a stack trace which includes the modules 'cursor_process_error' and 's_handle' maybe be reported in the error log if a client session with a distributed transaction having open cursors had to be aborted.

494690

In sp_sysmon, "Total ULC Flushes" under Transaction Management gives the total PLC flushes. At present, the PLC discards are also displayed under the column "by Other" in the PLC flushes section. This leads to erroneous counter value for PLC flushes.

494711

When there is a DDL statement in a batch, at the time executing DDL statement, entire batch is getting displayed instead of single DDL statement that is currently being executed.

495259

Need to install suite_conn_ocs_lang_en regardless of Open Client is chosen or not.

495544

When an online database has previously been used to bring an archive database online a timeslice error may be reported in the error log. In this case, the timeslice error will be accompanied by a stack trace which includes the modules 'online_database' and 'th__recover_altered_logsegment'.

495725

In very rare cases, when large scale allocation is enabled, alter table lock change may run into 1142 error: "Invalid OAM Page 0. ..."

495826

The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'ptn_rowcopy' or 'ptn_nextcopy' along with 'ind__get_sysindrow' when previously running the DBCC commands EXTENTCHECK and LISTOAM.

495847

A select statement which will return results against a local table will return error 403 against a proxy table. 125x version returned the same results for local and remote tables. The select clause evaluates to "where (null is null)" in the 15x version.

495877

Signal 11 (SIGSEGV) could happen in the module 'ResRelOp' when compiling a query qualified for a general OR plan (e.g. with IN predicate). Also it would only happen when the index used for the general OR doesn't cover all search clause columns of the table and there is some equijoin on the column which is not part of the index.

496178

Sub-optimal performance can be seen for queries involving MIN/MAX aggregates in the SELECT list and a equality predicate on the same aggregate column in the WHERE clause.

496225

In some rare circumstances, a query which involves VIEW column (which returns a subquery) in an OR term having a subquery may fail with a stack trace being printed in the error log containing the functions 'sqx__do_transform' and 'GtcChildOptBlock*GtqSingleSubqScan::GtInterestingTcIdBm'.

496247

In cases where the "max resource granularity" is set very low and/or a tempdb's pagesize cache pool is small, the hash operator could SEGV during the probe phase of processing. This case will only occur in underconfigured systems.

496352

A 2546 error, "Table Corrupt: Extent id < pageno1 > on allocation < pageno2 > has objid < objid > , indid < indid > , and used bit on, but reference bit off", may be reported by DBCC CHECKALLOC if a sort was active just prior to an instance or a server being shut down abnormally.

496556

When running SELECT command, if two columns end up having same names, and if one of those columns is used in the ORDER BY list also, then ordering of the result might be done on a wrong column with the same name.

496932

sp_configure would allow "max resource granularity" to be set to 0. Valid values are documented to be between 1 and 100 inclusively. Using sp_configure to attempt to set "max resource granularity" to 0 will now generate an error.

497066

A NOT IN subquery transformed into NOT EXISTS might use table scans instead of available indexes when isnull() builtin is used on either side of the NOT IN.

497142

The le_execerr() routine could SEGV if it is dispatched a second time and the Lava context has been cleaned up. That is, if a second exception occurs while cleaning up for an initial exception. In these cases, the stack will show that there is some intervening handler before le_execerr(). In the typcial case, le_execerr() is the first handler dispatched below the exec_lava() routine and there is no problem.

497170

The buffer size used by the SQL debugger command 'show where' to display stored procedure's parameters and their values is too small. It has been expanded to 2K.

497663

The message "A listener with protocol < network_protocol > , host < hostname > , port < port_number > , engine < engine_number > already exists." may be encountered while starting a new listener on the abnormally terminated listener port. The status of that listener is listed as active. However, no logins can be made to ASE using that listener port.

498007

The message, "Current process infected with signal 11" in the module 'col_encrypt' together with a stacktrace which includes the modules 'LeEvRun' and 'LeRun' may be reported in the error log when using encrypted column in a WHERE clause in a UNION query

497920

Installer built with Generic Platform Pak searches and uses the JRE in PATH first. This can be a problem if the JRE version/vendor is not the supported JRE.

498192

Error log may show errors like "kpsched: kpid #### bad status 0x440" when server is in heavy load and killing of ASE task(spid) has been happening.

498196

ASE boots using normal mode if shmat fails to attach Intimate Shared Memory (ISM) for SUN. With traceflag 1656, ASE will not boot using normal mode if shmat fails with ISM.

498257

A 8419 error, "Could not find index descriptor for objid < value > , indid < value > in dbid < value > " together with a stack trace which includes the modules 'ind_getrow' and 'startscan' maybe reported when a stored procedure which uses temporary tables (or tables create inside) and conditionally creates different indexes on them is executed reusing a query plan from a previous execution.

498285

LOAD DATABASE command may change segment maps on the target database wrongly if a smaller database dump is loaded and the target database has more than 7 device fragments.

498414

insert into a view on proxy table fails if column name is aliased.

498592

When the RAND builtin function is used without a seed value or with a literal seed value and the RAND builtin appears in a SQL WHILE loop, the same value of RAND will be used in each iteration of the WHILE loop. An example is: delcare @v int select @v = 1 while @v < 10 begin if (rand() < .5) select 1 select @v = @v + 1 end go The result of rand() in the IF statement will not change for each of the 9 iterations of the WHILE loop.

498631

A SQL statement containing an IN-list and an OR-clause, and with at least one NOT in the OR- clause such as: declare @v varchar(20) select 1 where @v IN ('abc', 'def') OR (@v in ('data') and NOT exists (select 1 from sysobjects where name = 'foo')) can return incorrect results. If the query is executed with the diagserver, and assertion will fire: Assertion (pNode->sym.node.type == AND) failed in file .../generic/source/preprocess/resrelop.cpp

498685

Adding a column to a table using ALTER TABLE that already has an existing functional index can cause error 2780 "maxlen (10) is less than length (16)" or similar when a SELECT is executed.

498734

When the RAND2 builtin function is used in a SQL statement that contains no table references, it will return incorrect results. An example SQL statement that returns wrong results is: if (rand2() < .5)

498740

AP load might fail to load a previous dumped AP for query with comments.

498764

When a user with sso_role executes a select into from a table in a database of which he is not an assigned user and which has no guest user, error 2736 is returned.

499000

Network performance may degrade due to disabled "tcp no delay" config parameter if ASE has both tli and tcp master entries in interfaces file.

499037

A error 8402 may be reported when we didn't find the requested index in table. The message "process infected with signal 15" may also be reported in the error log together with a stack trace which includes the module 'ind_refresh_ides'.

499058

Improved "insert into < table > values " performance when statement cache is off.

499092

Update variable assignment expression involving subquery was being evaluated at the Subquery Filter operator in order to improve subquery performance and avoid possible exception. But this led to some undefined behavior change compared to pre-15.0 with respect to some form of variable assignment. This happens only because we use a form on non-deterministic SQL syntax that is well documented. The fix here is temporary in nature using trace flag 15322 so that customers could use the old semantics with the possible caveat that this could lead to run time exceptions or performance issues.

499147

When a stored procedure that accesses an externally created temporary table (#) is re-executed after the temporary table has been dropped and re-created, an assertion may fire when the diagserver is used instead of the dataserver. The calling stack that is printed as part of the assertion output will print out the filename, useful.c and line number 13251.

499413

Include available sort order options all the time when using sqlloc with X.

499490

Compilation of an UPDATE query that contains a join and at least one IN-list or OR clauses on the same column can choose deferred update mode, when direct update mode is possible. As a result performance of the UPDATE query can be negatively impacted. An example query is: update t1 set c2 = 3 from t1, t2 where t1.c1 in (1,2,3,4,5,6,7,8,9) and t1.c2 = t2.d2 where table t1 is being updated and the query joins tables t1 and t2 and there is a IN-list on column c1 of table t1.

499747

Jsagent opens the port on all IP addresses.

500071

Post-Commit Optimization performs poorly for transactions with large number of DELETEs.

500116

A 332 error may be reported during a query that involves multiple nested VIEWs below a UNION VIEW.

500299

Page size information was not presented in ASE Plug-in. Now, server page size information is displayed in the server's General tab of the Properties dialog.

500311

A relocated join may get error 207 when joining on a column with upper case in the column name.

500546

Incorporated SQLTEXT printing for CREATE PROC, CREATE RULE, CREATE DEFAULT and CREATE TRIGGER statements when application tracing and show_sqltext options are turned on.

500872

After a database dump and load, ASE may not be able to access the SQL UDFs created before the dump.

523704

While doing DISK MIRROR/REMIRROR/UNMIRROR for an inactive disk, a stacktrace with SIGSEGV may be reported.

528381

The following message is seen in the error log upon server startup: "kernel Warning: Cannot resolve LDAP function ldap_search_ext_s".

528407

In some circumstances, Adaptive Server may throw a message "current process infected with 11, in the module CgpUnion::_CgpInitProjection, together with a stacktrace which includes modules like CgpMergeUnionAll::cgpInit", when a UNION ALL query is being executed.

528551

Error 530 may be reported when using output from SQLJ function on outer column of a join.

528815

Java does not recognize UTF-8 byte order "EF BB BF" in *.txt license files.

529215

The message "Invalid column length: < value > . Value must be between 0 and < value > for 'data-only' row with minimum row length of < value > ." may be reported in the error log followed by a stack trace in module 'collocate' when the DBCC PAGE command is run with the print option value of 4 on a datarows-only-locked table that has variable length columns with a size value greater than 256. The modules 'prvarlen_cols' and 'prDOL_ROWS' will also be reported in the stack trace.

529400

When an encrypted column uses a key that requires an explicit password and has declared a decrypt default, then a reference to that column in a WHERE clause that uses an OR operator may return Error 15469 to a user who lacks decrypt permission.

529699

The message 2834 may be reported in the error log when an ALTER TABLE DROP PARTITION or ALTER TABLE ADD PARTITION command is run while concurrent activity on the target table takes place.

529787

Unexpected results could be returned under some circumstances when executing a query using CASE expressions involving inside comparisons to NULL literal values and ANSINULL session option is not active.

529792

Adaptive Server might terminate the execution of a query containing GROUP BY ALL and a subquery in the WHERE clause.

530186

RIDjoin (for OR predicate) inner to outerjoin operator could sometimes lead to execution error message 623,624 or 806 related to retrieving a row via its RID.

530220

Kerberos logins with connection failover support fail to connect to ASE when HA is configured.

530311

Export_options is enabled by default on the first login but not subsequent ones.

531062

When configuration value "number of worker processes" is updated using 'sp_configure', its value printed by 'set option show long' is not updated until the next reboot of the server.

531176

In rare circumstances, the message "timeslice -501, current process infected" together with a stack trace which includes the modules 'memalloc' or 'mempagecount' may be reported in the error log when running a complex query.

531177

Under some circumstances the message "current process infected with signal 11" in the module 's_free' together with a stack trace which includes the modules 'metrics_proc_dump' and 's_cleanframe' may be reported in the error log when a session executing a stored procedure is killed and the configuration option "enable metrics capture" was set to 1.

531748

Spurious error message 2513 "Table Corrupt: Object id 892527182 (object name = v1) does not match between syscolumns and sysattributes" is given when decrypt default is defined on an encrypted column and a VIEW is defined on the table with the encrypted column and decrypt default and DBCC CHECKCATALOG is run on the database.

531782

To completely turn off ASE Plug-in's "remember passwords" feature, the system administrator can execute this command: "$SYBASE_JRE/bin/java -jar $SYBROOT/ASEP/lib/ASEPlugin.jar -s Setting.RememberPassword false". Once turned off, ASE Plug-in will always ask for password while attempting a connection. Furthermore, the "Remember passwords..." check boxes will not be shown on the plug-in Preferences page ("Tools"- > "Adaptive Server Enterprise"- > "Preferences").

531997

Error message 942 "Database cannot be opened because a system descriptor cannot be installed." is enhanced to include the database name and the object ID of the system table whose table descriptor could not be installed. Similarly error message 952 "Database '%.*s' cannot be opened because a system index descriptor cannot be installed." is enhanced to include the object ID of the system table whose index descriptor could not be installed.

532511

In ASE 12.5, cursors with DISTINCT, ORDER BY, GROUP BY or UNION in their defining SQL statements would often have their result rows stored in a worktable when the cursor OPEN command is executed. Subsequent cursor FETCH commands would read rows from the worktable, thus insulating the cursor from changes to the tables upon which the cursor was defined, in between FETCH commands. In ASE 15, the optimizer attempts to avoid creating worktables for better performance. In this CR, command line trace flag 457 has been introduced to force ASE 15 to internally convert many of the cursors that would have used a worktable in ASE 12.5, but would not use on in ASE 15 to insensitive cursors to force materialization of the cursor rows when the cursor OPEN command is executed.

532645

A join containing an MDA table may stacktrace with a signal 10 if a Nested Loop Join is used.

532648

In rare circumstances, a signal 11 may be encountered in the 'xls_getnext' routine at transaction commit time, with the stack trace showing modules 'xls_getnext' and 'xact__postcommit_processing'.

532743

Running a query with large joins of more than six tables may get a stacktrace in the module 'stat_add_sample'.

533277

A query involving a UNION such that 1) one side of the UNION is a SELECT from a derived table involving a join between two tables with a DISTINCT on the projection; and 2) the other side of the UNION is a SELECT < constant > might lead to wrong results. An example query would be: select et.col1 from (select DISTINCT et.col1 from et, cl clkp where et.col2 = clkp.col2 and clkp.col1 = 'Dependency' ) et UNION select 'All'

533331

Scheduled jobs stop unexpectedly after running a few months on nt386 platform.

533767

Error 511 could be raised incorrectly for queries having unknown result length if trace flag 244 is turned on.

533945

Job Scheduler Agent on NT uses IPv4 even if IPv6 is enabled on the host machine.

534281

Sybase Central ASE Plug-in needs to allow for sysindexes.fill_factor being NULL. If it is null, it will be displayed as 0 in the table Properties/Locking Scheme page. And the label is changed from "Fill factor (1 - 100)" to "Fill factor (0 - 100)".

534688

On IPv6 enabled machines, the sp_listener stop/suspend command fails to stop/suspend a listener after starting the listener successfully by the command "sp_listerner start".

534827

Query with AND/OR clauses may stacktrace for certain order of OR clauses in the query.

534890

Arithmetic overflow for numeric +/- expression involving more than 2 operands could happen during execution.

535392

Procedural query compiled in the deferred compilation mode may fail producing stack traces if during the compilation the server has to perform the internal upgrade of the DEFAULT clause. Errorlog indicates modules 'add_default', 's_getTreeOrPlan', 's_reinstallProcTree' and 's_normalize'.

535666

TEXT values returned by remote procedure calls with CIS RPC handling could be corrupted when UTF-8 character set is used.

535719

When turning on statement cache, subsequent execution of a query on VIEWs that fires an instead-of trigger and involves LOB may hit SIGSEGV and stack trace from the module 'eval_locator_bi'.

536912

Loading a 12.5 transaction dump including REORG REBUILD log records into a 15.x ASE may fail with a segfault error showing the modules 'bt__rebld_row' and 'bt__rebld_prepdestrow'.

537570

SEGV in the module 'CgpInplaceUpdateVars' could happen when the query has a subquery under an OR predicate and there are more than 6 joining tables.

537601

Executing a query having more than 6 tables may hit a 540 error when the optimizer's alternative greedy algorithm leaves tables opened in the event of an exception.

538910

In rare circumstances, a stack trace may be reported in the errorlog involving the modules 'GtuUnion::_GtcNTopPopsGenerate' and 'GtcChildOptBlockN::_GtcBestArgsGenerate' during a query that involves both more than 4 UNION sides, parallelism and one UNION side with a distinct projection and greater than 6 tables.

539103

Monitor Server crashes in comn__sig_accept_thread upon receiving SIGHUP.

539355

Job Scheduler fails to start on Windows with IPv6 enabled.

539821

Wrong result could happen for MERGE or HASH join when there is an equijoin predicate t1.c1 = < expression on t2.c2 > and another redundant or equivalent equijoin predicate t2.c2 = < expression on t1.c1 > is added which is simply a transformation from the first one. For example, t1.c1 = t2.c2-1 and t2.c2 = t1.c1+1

540770

In rare circumstances, the message "Infect with 11" in modules 'memcpy' and 'com__dateadd_both' may appear in the errorlog during a query involving more than 6 tables, Nested Loop Joins and SARGs with convert(), dateadd(), getdate() and datepart().

540794

If statement cache is turned on and 'enable metrics capture' is also set, executing a query referencing temp tables will hit SIGSEV in the module 'memalloc' along with stack trace in the module 'metrics_dump' and 'ssql_purge_stmt_hastemp'.

541324

The UPDATE STATISTICS command ignores the setting of the histogram tuning factor resulting in many fewer steps created when updating statistics. This can cause bad plans to be chosen due to the innacurate statistics.

542143

When an instead-of trigger is defined on a VIEW that involves LOB columns and proxy tables, then executing a statement on the VIEW that fires the instead-of trigger may fail with message 3621, "Command has been aborted."

544679

Executing UPDATE queries involving NULL LOBs may hit error 691, "Encountered invalid logical page 0 ..." with a stack trace in the modules 'updtext()' and 'wrongpage()'.

545058

ASE running on Sun Solaris machines which do not have ISM configured within the kernel will cause additional engines to SEGV during their online operation.