2087928 - Targeted CR List for ASE 15.0 ESD #1

CR number

Description

169417

A 696 error "An attempt was made to fetch logical page ... Restart of SQL Server will clear the error ..." may be raised when using char_length() built-in function on TEXT/IMAGE columns from within a TRIGGER.

334942

Installer may hangs if NFS mounted devices are inaccessible.

358598

The message "infected with 11" together with a stacktrace containing the modules 'apg__setop', 'ap_generate' and 's_ap_capture' is printed in the errorlog when "abstract plan dump" is configured and a SELECT containing a UNION with a simple SELECT like SELECT " < string value > " is executed.

373858

If a command is sent to ASE which contains a huge number of syntax errors (eg thousands), then the ASE task handling the command may hang in 'send sleep'. This is because the client machine has not yet called ct_results to retrieve input, and the large number of syntax error messages sent back to the client may fill the client's tcp/ip receive buffer. To prevent this, only the first 25 syntax errors in any single command batch will be reported.

386931

Previously DBISQL does not display query result similar to the that of command-line isql. This has been addressed by adding a "Text" output mode, in addition to existing "Grid" output mode. To turn on Text output, open Options dialog by selecting menu item "Tools"- > "Options...". On Options dialog, select "Results" from the left-hand-side list and select "Text" radio button to enable text output.

389076

The message "current process infected with 11" may be raised in module bufdlink() when the sysindexes system catalog and the database where it resides are bound to different named caches, and when the clustered index of sysindexes is not explicitly bound to a named cache.

392463

syconfig.exe or sybatch.exe creates "%SYBASE%\data\sybsysdb.dat" device during the ASE upgrade.

399077

Some memory usage improvement to histogram merging during optimization. This can significantly reduce the compilation time and the procedure cache consumption for some queries.

399640

A Null pointer exception may be reported by the ASE Installer during a TYPICAL installation of ASE.

399678

Under certain circumstances, if ASE is startted with '-w master', then immediately restarted with '-w model', then restarted with '-m' followed by 'disk reinit' and 'disk refit', recovering tempdb may fail with error 806: Could not find virtual page for logical page 1280 in database 'tempdb'.

399952

When a local index is created on a partitioned table with a large number of partitions, then a large number of locks will be required to perform the implicit updates to sysstatistics. This fix will greatly reduce the number of locks required in this scenario to be a fraction of the previously required locks.

400053

Previously Make Permanent button of Options dialog does not save preferences permanently. This has been fixed in build 3204.

400058

A message indicating that the query enountered a signal 10 or signal 11 may occur in the server errorlog when a query is performed on the monProcessObject table. When this happens the query will be aborted and must be resubmitted.

400361

sqlupgrade and sqlupgraderes reported "Adaptive Server failed to restart" if one or more databases failed to recover.

400452

An UPDATE of a local table joined to a proxy table, where the local text column is set to the value of a remote text column, can result in a stack trace that includes the routine syb10_text_read_init and omni_txcp_rem2txpgs.

400479

Previously DBISQL command "output to" does not work for saving a single result set from a stored procedure, such as: sp_helpartition go output to sp_helpartition.txt go This has been fixed.

401279

Error 632, Severity: 20, State 9, during upgrade to 15.0, if the pre-15.0 installation had system catalogs bound to named caches and if the caches are not defined in the config file used during upgrade. This problem will not occur if the upgrade is performed through sqlupgrade.

401336

This fixed the following wrong result bug: if you have an equi-join clause between two different length char() and char()/varchar() type columns and also use char_length() on one of the columns, the result of the char_length() is indeterminate and is a function of the final plan because we have different truncate models for the equi-join and char_length() on char() type columns. Here is an example: create table t1 (sid char(8), styp char(5)) go create table t2 (sid char(16)) go select char_length(a.sid) from t1 a, t2 b where a.sid=b.sid and styp = 'R1' go The same for binary() and varbinary() with data_length(), unichar() and univarchar() with char_length().

401397

Previously DBISQL does not refresh database dropdown list when "create database" statement is inside a if...else statement. This has been fixed.

401442

If an exception occurs during an internal sort, a subsequent query execution will result in the process termination with Error 706, Severity 20 and State 3.

401537

508: Correct the bug that table items cannot be access by up and down arrow.

401546

508: When SQL Preview dialog close, focus should go back to the dialog that spawns the Preview dialog.

401656

The installer's generated options file has incorrect Job Scheduler property names configJSPanel.getManagementDevice, configJSPanel.getManagementDeviceSize, and configJSPanel.getManagementDatabaseSize. The correct property names are configJSPanel.managementDevice, configJSPanel.managementDeviceSize, and configJSPanel.managementDatabaseSize.

401680

When ASE's default charset is multi-byte charset, if a specified object name string contains more than three dots (full object name is in the format of server_name.db_name.owner_name.obj_name), server stack traces.

401682

When the 15.0 server runs against an installation created by ASE version 12.0, and the 15.0 server is started using the 'DE' license, it will print a message stating that a graced license has expired. ASE will then shut down. This problem does not occur when using the 'EE' license.

401684

When an error is encountered by the server during recompilation of a stored procedure the session may be killed, and a stack trace may occur with error 216: "Attempt to automatically drop temporary table failed." This error is spurious and no temporary object will remain in the temporaray database.

401753

This fixes a stacktrace for parallel plan when the plan is inserting into a table with identity column using SELECT DISTINCT and one of the SELECT DISTINCT list items is an expression.

401779

When a 11.9 or 12.0 installation is upgraded to 15.0, dbcc checkstorage() on the master database may report faults 100029 , 100038 on the first page of the syscharsets text index.

401895

Error 1204 occurs during installjsdb after an upgrade to ASE 15.0 and if the configuration parameter 'number of locks' is insufficient. The preupgrade utility has been augmented to report the required number of locks.

401927

When configuration parameter 'enable real time messaging' is set to enable the RTMS feature on Windows, initialization fails during ASE startup sequence with an unhandled exception error for ExceptionCode: c0000005. This makes the RTMS feature of ASE unusable on Windows platform in ASE15.0 GA release.

402082

On the HP platform HTTPS (SSL) is not available for ASE WebServices. The HTTP transport is not affected, however.

402099

Many tools need to get an estimated cost from a query plan without executing the query. This cost is used to compare estimated plan cost in 15.0 vs the actual cost in pre 15.0 query plan. A new "set option" called show_final_plan_xml has been added that prints a query plan before the query gets executed along with its estimated logical and physical I/O.

402102

Job Scheduler utility scripts fail on Windows platforms due to error in statement to set an environment variable.

402212

When the 'optimization timeout limit' option is configured via sp_configure, then the newly configured value is not reflected in the session (visible via the @@opttimeout global variable) that invokes sp_configure. The query plans generated in the invoking session may thus be based on the previous 'optimization timeout limit' value instead of the newly configured value.

402435

Previously in 15.0 GA, DBISQL launch script "dbisql.bat" (Windows) and "dbisql" (Unix platforms) contained invalid argument "-path" that caused the script to fail. This has been fixed. (The correct argument is "-Dpath".)'

402610

On the Windows platform, the message "KERNEL structure not padded correctly - size = 5288" appears at the start of the ASE boot sequence.

402694

A SELECT SUBSTRING(...) statement on a proxy table mapped to a remote table on DB2 using the DirectConnect/DRDA results in an ILLEGAL SYMBOL error from DB2.

402717

After the cross platform dump and load (XPDL), the space utilization is not handled correctly, and an index is unnecessarily rebuilt by sp_post_xpload, if variable length index key was greater than 252 bytes. Also some page corruptions happen in DOL index root page, in DOL non-leaf index page for UNICHAR NOT NULL index key in some cases, and in a special case of slice control page if the database dump is from 11.9.x.

402725

UNION queries may return wrong results in very limited circumstances. This may occur if the select list of the first SELECT contains duplicate column references.

402733

"alter table drop" command with more than 9 text columns fails with signal 11 in oh_insert.

402918

Running ASE 15.0 GA, Load Database performed upon a 12.5.x dump of a database that has replicated stored procedures can fail on this error: Error: 632, Severity: 20, State: 2 Attempt to move memory with an incorrect length of -166. Maximum allowed length is 16384.

402920

After dropping a column using ALTER TABLE, the computed columns defined after the dropped column as well as any function-based indexes do not work properly.

402925

A stacktrace may occur when an error is raised while executing a query that has a hash join, a hash distinct or a hash union operator in its plan. This stacktrace contains the functions : LeHashOp::_LeClose() and soextdealloc().

403384

The sqlupgrade utility may initiate the upgrade process for the server before all databases in the server have completed recovery.

403391

Auditinit now ported to ASE15.0 in ESD1 on IBM64.

403392

When an update command tries to update a column with the result from a cursor fetch and a deferred update causes the cursor position to be lost, a signal 11 and stack trace including LeDMLOp::_LeOpClose() may occur.

403662

Fixed possible wrong result for queries whose plan contains a DistinctSorting and one of the DistinctSorting's projection is a column with a search clause < the column > =constant on it. The wrong result typically only showed up under heavy server load.

403797

The XML for showplan_in_xml has been enhanced to cater to the changes in ASE for 15.0 ESD #1. The new XML has information that tries to bridge more gap between the text version of showplan and the xml version. For all Objects/Nodes the following Important attributes are added 1) Abstract Plan 2) Overall Cost 3) Resource 4) Optimizer Metrics 5) Optimizer Statistics [Including object for which stats is missing]

403837

When running the Linux/x86 installer on Linux/Opteron, the JRE core dump.

403910

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

404090

The use of HAaseAgent for ASE 15.0 may lead to the failure of thorough probe for HAase resource on Veritas Cluster Server.

404391

If a license acquired by ASE is not a permenent license or a license cannot be acquired and is awarded on grace, a new error message with severity 17, non fatal but requiring action, is printed to the dataserver's errorlog. This error message is to inform DBA that license will expire at a stated date.

404470

UPDATE PARTITION STATISTICS raises error 9810 with a stacktrace containing the function call sl_update_ctrlpg_pagecnt

404472

Added support for allowing plan generation for multiple queries separated by GO statement.

404489

When doing text upgrade for compiled objects in ASE 15.0, the upgrade might fail with error 705.

404654

A signal 11 could occur in queries with non-correlated subqueries that are executed with subquery cache statistics enabled. The stack trace will include printSqCacheStats.

404728

When resource manager and parallelism are enabled, we run into error 3630 and 11002, which aborts a query saying that it had exceeded its resource limit. This happens with queries which contain UNION/UNION ALL operators, because the query optimizer was incorrectly estimating the cost of those queries to be cheaper than they ought to be.

404953

Fixed a potential sig 11 stacktrace during code generation for CIS query involving subquery.

405028

The system stored procedure sp_statistics returns extra data. In addition the order of data are not consistant with documentation.

405034

Error 3121 "Index sysobjects.ncsysobjects (objid=1, indid=2) may be invalid..." maybe reported in the error log during ONLINE DATABASE, after loading the database that is dumped by a server using a different charset id than the current server. A table created in pre-15.0 system and then altered into range-partitioned table with char/varchar partition key column(s) may be marked as SUSPECT and thus read-only during sort order/char set change that normally wouldn't make the range partition suspect.

405328

Union queries that use a NULL constant in the select list of the union's first select statement and are the source for an insert statement may return wrong result or stacktrace. The following union provides an example: insert foo (c1, c2, c3) select c1, c2, c3 = null from t1 union select c1, c2, c3 = c1 from t2 The problem may not occur depending on how columns are aligned in the underlying data row.

405330

Some queries containing hash operators may attempt to allocate large private buffer pools. These pools could require a large chunk of contiguous memory which could lead to 701 errors even though there is ample free space in the procedure cache. A 701 error can be traced to this problem by rerunning problem query with traceflag 751 enabled. If the resulting stacktrace contains sort_auxbufinstall(), then this is the problem.

405739

Due to change in system catalog DDLGen was generating wrong DDL for database. This fixes the problem, by generating correct value of the database size.

405763

ASEPlugin reported wrong value for device size for data servers with 4k, 8k and 16k page sizes. This is fixed to show the right values

406003

Database Properties Usage page is modified. It now only reports the following information: database size, reserved space, used space (by data and indexes), unused space, and unreserved space.

406004

15.0 GA suffered the following problems CR 406159 : Wrong Device Size in creation and the current CR, i.e duplicate context menu items for a db created for load These are fixed

406129

For Server SQL Execution: Make it Modeless Add SQL Execution Time, Number of rows returned in Messages tab Use split panel between SQL Editor and output

406300

Fixed error 586/16/5 when running query with ORDER BY and IDENTITY.

406303

Upgrade process and system stored procedure sp_checkreswords cannot identify the following new ase15.0 keywords: "count_big", "materialized", "tracefile", "semi_sensitive", "insensitive", "scroll".

406934

The following problems have been addressed in DBISQL: - CR401397 Previously DBISQL does not refresh database dropdown list when "create database" statement is inside a if...else statement. This has been fixed. - CR404078 Previously in 15.0 GA, DBISQL launch script "dbisql.bat" (Windows) and "dbisql" (Unix platforms) contained invalid argument "-path" that caused the script to fail. This has been fixed. (The correct argument is "-Dpath".)' - CR399694 DBISQL failed to import Excel 2.1 worksheet. This has ben fixed. - CR400053 Previously Make Permanent button of Options dialog does not save preferences permanently. This has been fixed in build 3204. - CR400479 Previously DBISQL command "output to" does not work for saving a single result set from a stored procedure, such as: sp_helpartition go output to sp_helpartition.txt go This has been fixed. - CR402435 DBISQL cannot be launched using the script file on Unix($SYBASE/DBISQL/bin/dbisql) and Windows (%SYBASE%\\DBISQL\\bin\\dbisql.bat).' - CR386931 Previously DBISQL does not display query result similar to the that of command-line isql. This has been addressed by adding a "Text" output mode, in addition to existing "Grid" output mode. To turn on Text output, open Options dialog by selecting menu item "Tools"- > "Options...". On Options dialog, select "Results" from the left-hand-side list and select "Text" radio button to enable text output.

407057

A 702 error may be generated from queries that contain hash operators with large estimated hash table sets ( > 5.8 Gbytes).

407327

TSQL statements that return rows wider than a database's page and contain distinct clauses, unions, or group by clauses may generate a 702 error if a hash operator is used.

407345

Dissociate index intersection and index union: don't try index intersection anymore together with an OR clause index union when SET INDEX_INTERSCET is OFF. Also, when index intersection properties (as partitioning) don't match, abandon gracefully instead of continuing up to a failure.

407679

When an allpages table with more than one nonclustered index is updated, if a nonclustered index is safe (index columns are not updated) and if the second nonclustered index has one row in the root page, the update may fail with error 2601 if the index is safe index is unique. If the index is not unique, duplicate index row will be inserted.

407754

A stack trace with command aborted message may occur while doing an insert into a table with indices. Stack trace with error 2618, "couldn't find duplicate key group" will be seen.

408047

When a select statement has a predicate on a column, which is part of an inner table of an outer join, extra incorrect row(s) are returned. This is due to some plan for an outerjoin query could miss a predicate on a column of an outerjoin inner table.