This patch applies to the following Pervasive
PSQL products:
This patch applies to the following
executables:
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.
Specific issues addressed in this Patch
release (Build 11.11.014):
|
Tracking
Number |
Description
|
|
56377 |
PDAC SDK install included extra files |
|
58653 |
ODBC
client cannot retrieve Blob data larger than 64K |
|
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 |
Previous issues addressed since PSQL v11 SP1
(11.10) release:
|
Tracking
Number |
Description
|
|
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 |
You may
obtain technical support from the following Web-based support options:
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. |
*** END
OF README ****