Pervasive PSQL V11.10

Patch Release - 7/09/2012

Install Build version 11.11.020
Components Build version 11.11.017

 

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.11.020):

Tracking Number

Description

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

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

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

 

Previous issues addressed since PSQL v11 SP1 (11.10) release:

Tracking Number

Description

56377

PDAC SDK install included extra files

58653

ODBC client cannot retrieve Blob data larger than 64K

59542

Function Executor does not show new COBOL datatypes

59877

Function Executor “View as Any Data Type” window does not show INTEGER data correctly

60390

SQL applications lose connection to server when PARC is enabled

60588

Status 3 in Windows Network Load Balancing environment (cluster)

60597

INSERT with SELECT failed to insert more than 2 chunks of 64k data

60669

Cluster name not being resolved to the host name in a 2008 R2 cluster environment

60699

Clilcadm -c partially removes license information before returning 7224 Lack of Permissions error

60701

OLEDB provider not returning Currency, Numeric or Decimal data correctly

60748

Create view returning message “Currency type changed”

60746

Stored Procedure returning message “Data truncated column 1”

60762

System Stored Procedure PSP_INDEXES() returns duplicate entries for Primary Keys

60764

Alter table doing a PHYSICAL_MOVE of BIT column puts column in wrong place

60772

Engine hang due to deadlock from RI

60773

Complicated full outer join crashes engine

60780

Query returns “Null not valid” if subquery contains outer join with TOP clause

60794

Restriction on CHAR column using UPPER() fails to find rows.

60801

Select into from a non-mergeable view fails

60806

Grant ALL on * does not include CREATESP or CREATEVIEW rights

60811

Adding column NOT Null constraint using existing name consumes memory

60826

Engine crash on SQL Query with Case Statement using constant

60828

Non-Master users should not be able to drop views/SP/tables created by another user.

60857

Currently unsupported syntax GRANT ALL on VIEW/PROCEDURE * crashes engine

60858

Crash in SQLDisconnect when freeing cached stored procedure statements

60859

SQL Engine refuses connection and status 2307 is returned

60885

Linux 32 bit returns numeric value out of range error

60896

Status 85 when using 8.3 forms of long file names like  longfi~1.mkd

60949

Getting status 84 back is delayed ADO.NET application in client server environment

60950

Ability to create triggers in a secure database should require both create procedure and create table rights

60951

Executing a prepared statement multiple times should re-check user’s rights each time

60957

GRANT EXECUTE ON PROCEDURE <function name> should return an error since trusted functions are not currently supported

60962

Query using Btrieve temp sort file and time column not sorting correctly

60963

ADO.NET’s connection string Initial Command Timeout property not working.

60966

Memory leak in DTO retrieving dbnames information

60977

Stored procedure with cursor does not execute completely in some cases

60996

“Phantom/extra” indexes in the DDFs cause extraneous errors in PCC and DDFBuilder

61013

Extra index created by the SQL engine for a CREATE TABLE…IN DICTIONARY with a UNIQUE attribute specified on an Identity column

61019

EXECUTE of a blob variable longer than 64K in a stored procedure will cause the blob to be truncated and produce an error – most likely a Syntax Error.

61127

ODBC connection from client may slow down when the client machine does not have a DNS record.

61143

ODBC connect failed if pvTranslate=auto on Linux(32/64-bit) and 64-bit Windows

61148

Cancelling insert after a SetRange causes stack overflow using PDAC

61156

Win64 ODBC application may crash when connecting to a DSN on a Linux server with pvTranslate set to auto

61169

Incorrect results from query with GROUP BY on decimal column

61172

BUTIL crashes on Linux when doing –STARTBU with security set to “btpasswd

61186

Access violation error on calculated field with PVQuery

61200

Query with restriction on lower() does not find matching data

61213

ODBC Client connection fails if the server is specified by IP address and the port number is not included in the connection string

61228

Query with DISTINCT, GROUP BY, ORDER BY, or UNION on a column larger than 255 bytes may be missing one or more bytes of data

61231

Application using multiple access methods (DTI, ODBC, Btrieve) on the same table(s) may return “Table Not Found” error

61237

SQL Engine crash on Linux when accessing a corrupt file with CLOB data; engine now returns status 103

61241

PVNETPASS not handling the wildcard specified in quotes properly

61253

Incorrect results when casting binary data to integer

61264

Performance hit when cache engine enabled while running a SQL application that uses temporary tables

61265

 Engine crashed when an application’s total handles exceeded 64K

61278

ADO.NET driver ignores a timestamp parameter if the milliseconds are non-zero

61292

Unable to use an IP address when opening a file with the ActiveX control

61305

SELECT… INTO requires a FROM clause when used in stored procedures, functions and triggers

61306

Intermittent ODBC connection failures with Winsock error 10065

61336

Linux client receives “Could not SQLConnect” to remote Windows database

61360

Client application shows “Unknown” in Monitor\SQL\Active Connections for Linux client

61367

SELECT with joins and CASE containing LIKE expressions crashes the engine

61386

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

61389

Engine crash when executing a trigger containing invalid syntax

61391

Using SQLSetPos to update a column in a table with an Update Trigger may cause the engine to crash

61393

“Error in Procedure argument” when calling a stored procedure or user defined function with dynamic parameters and unsigned integers

 

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 ****