Pervasive PSQL V11.20

Patch Release - 9/26/2012

Install Build version 11.21.014
Components Build version 11.21.012

 

Products

This patch applies to the following Pervasive PSQL products:

Executables

This patch applies to the following executables:

 

Installation Notes

Applying a Windows Installer patch does not enable logging by default. To create a patch log file when applying this patch, run the patch executable from a command line and use the /l option.

For example, the following command line creates a verbose log file named "patch_install.log" during installation:

PSQLv11Patch_type.msp /l*v {path}\patch_install.log

 

Uninstalling Notes


In most cases, the changes made by a Pervasive PSQL patch may be reversed by executing the following uninstall command:

   msiexec.exe /uninstall {path}\PSQLv11_Patch_{type}.msp /package {path_to_original_install_source}\PervasivePSQLv11{type}.msi /qb /l*v {path}\patch_uninstall.log

Note that the user executing the command must be able to access the source files installed by the original Pervasive PSQL installation.

In some cases, you may not be able to uninstall a Pervasive PSQL patch depending on the type of changes it made. Instead, you must uninstall Pervasive PSQL entirely to reverse the changes of a patch. For example, if executing the uninstall command above displays the message “Uninstallation of the patch package is not supported,” you must uninstall Pervasive PSQL entirely to reverse the changes made by the patch.

Issues Addressed

Specific issues addressed in this Patch release (Build 11.21.014):

Tracking Number

Description

61629

SELECT with restriction containing LEFT or RTRIM optimizing on segmented index returns too many rows

61630

SQL engine may crash with very large temporary sort file

61633

Query with UNION ALL may return too many rows when a static or dynamic cursor is used

61646

Update table fails via MS SQL Server linked server

61661

SELECT with UNION and signed/unsigned data types returns incorrect results

61668

Random cache engine crash may occur during page refresh

61678

SQL query subtracting timestamp values with ifnull() returns Expression Evaluation Error

 

Previous issues addressed since PSQL v11 SP2 (11.20) release:

Tracking Number

Description

58653

ODBC can only retrieve up to 64K blob

60104

Microkernel may hang when processing a cascade delete

60683

ADO.NET sample “Escapes” raises “Unhandled Exception”

60700

Using PCC to open a table in a new window causes PCC to lose the tree view of engines and databases

61323

SELECT … INTO :X without a FROM clause fails in a user defined function

61342

ADO.NET “Communication Link Failure” with LONGVARCHAR column

61360

Linux client SQL application shows as user “Unknown” in Monitor

61367

SELECT with joins and CASE containing LIKE expression may crash the engine

61386

MAX and MIN aggregates on an Identity column return NULL instead of actual value

61389

Trigger with invalid record alias crashes the engine

61391

Update via SQLSetPos on table containing an Update Trigger may crash the engine

61393

Unsigned integer parameters to a stored procedure or function may return “Error in argument”

61413

Reading/inserting LONGVARCHAR or LONGVARBINARY may crash engine

61414

ADO.NET GetSchemaTable call may return IsKey value as empty

61415

“Numeric value out of range” or “No Argument or default value supplied” may be returned when UTINYINT or UBIGINT are parameters in a user defined function.

61418

SQL application using DAO runs slower due to limited catalog caching

61433

First Terminal Server session may use 2 licenses on Linux

61439

ALTER TABLE to RENAME the table should return an error if table has relational integrity constraints

61441

Accessing table with legacy “pseudo-integer” (with decimal places) may crash the engine

61442

Nested calls to REPLACE() scalar function returns incorrect results when called in a stored procedure

61449

SELECT… WHERE NOT(NOT… may return incorrect results

61461

SET ROWCOUNT along with ODBC SQL_ROWSET_SIZE returns incorrect results

61463

Data may be truncated on multiple calls to SQLBindParam and SQLExec

61464

JDBC is unable to resolve dynamic parameters such as: SELECT * FROM tbl WHERE ? = ?

61478

ODBC SQLSetStmtOption with SQL_MAX_ROWS or SQL_ATTR_MAX_ROWS returns incorrect results

61489

JDBC query returns no rows when using lower-case constants in restrictions on case sensitive columns

61493

ODBC SQLGetInfoW with SQL_INDEX_KEYWORDS was returning “Driver not capable”

61498

DTI function PvAddTable() is deleting the data file if an error occurs during the add

61503

View column alias name longer than 20 characters may cause the SQL engine to crash

61510

Performance issue establishing a connection when there are many (>400) active clients

61536

SELECT with LEFT JOIN to an empty table may cause the SQL engine to hang

61542

Timing window may cause possible file corruption from delta page roll-in from continuous operations

61550

Microkernel may hang when processing a cascade delete

61557

CREATE FUNCTION/PROCEDURE fails with ORDER BY clause

61561

“Currency not on record” returned to FORWARD-ONLY cursor on a statement using both UNION & UNION ALL along with TOP in a Table Subquery 

61565

Status Code 7218 authorizing or de-authorizing a license on Linux

61590

Trigger is case sensitive for field names when referencing new and old values

 

Technical Support

You may obtain technical support from the following Web-based support options:

Disclaimer

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.

Copyright ©2011 Pervasive Software Inc. All Rights Reserved.

 


 

Pervasive Software Inc.
http://www.pervasive.com
12365 Riata Trace Pkwy, Bldg B
Austin, TX 78727 USA
Voice: (512) 231-6000
Fax: (512) 231-6010
Online Pervasive Contacts

*** END OF README ****