Pervasive PSQL V11.30

Patch Release - 6/15/2016

Install Build version 11.31.101
Components Build version 11.31.070

 

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

Tracking Number

Description

PSQL-3222

Adding an owner name with encryption produced many extended files

PSQL-3258

PCC is repeating index columns when viewing indexes in SQL view

PSQL-3276

OLEDB application may crash when inserting SQL_BINARY data into a NOTE column

PSQL-3289

UNION ALL query returns more records than expected when index is used for IN list restriction

PSQL-3310

Incorrect results re-executing query with mixed UNION/UNION ALL and TOP clause

PSQL-3340

Re-executing batch sql statements with dynamics parameters may return SQLBindParameter errors

PSQL-3440

Added support for PDAC XE8 and XE10

PSQL-3452

Monitor max worker threads should show Unlimited instead of displaying a value exceeding 256

PSQL-3497

Possible engine crash when dynamic parameter fails to indicate a large chunk of data as LONGVARCHAR

PSQL-3531

Substring did not handle arguments that referenced positions beyond the end of the string

PSQL-3557

Incorrect results from using ACOS() scalar function when column is indexed

PSQL-3576

SQLProcedureColumns does not return default value for UDF functions.

PSQL-3590

Possible crash when dropping a database when another database exists that points to same location

PSQL-3604

Incorrect results from ADO.NET when executing stored procedure with a  select into a temporary table followed by a select query

PSQL-3622

Query Plan Viewer chops strings inside filter window

PSQL-3633

Create database sql command created unneeded windows folder when using shift-jis character in folder name

PSQL-3659

PSQL engine stopped responding when executing  select query with excessive predicates

PSQL-3663

PSQL engine does not ignore ? inside quotes when followed by comment marker inside the quotes

PSQL-3665

“Maximum number of sort columns exceeded” error is possible when using forward-only cursor

PSQL-3702

SQL Engine reports Memory Allocation Error on SELECT query with many OR predicates

PSQL-3720

Message to close Notification Viewer is confusing in cluster environment

PSQL-3723

Possible crash in w3odbc.dll when PARC is enabled

PSQL-3829

ADO.NET 4.1 provider sending incorrect parameter set to server when query has multiple statements with parameters passed in ANSI mode

PSQL-3858

Nested subquery returns syntax error

PSQL-3866

Uninstall hangs if the PSQL services are set to manual and stopped before uninstalling

PSQL-3867

 SRDE allows multiple users into the database when setting security on database

PSQL-3913

Client64 installed on WGE environment corrupts ADO.NET machine.config file when updates are apply to it.

 

 

 

 

Previous issues addressed since PSQL v11 SP3 (11.30) release:

Tracking Number

Description

N/A

ADO.NET Provider version 4.1 added

56790

Repair RI database name feature added to PCC

59978

Query should not be re-executed when returning to a SQL Window in PCC

60430

Possible corruption with page compression and heavy load during continuous operations

60600

GUI Rebuild does not use the selected page size

61616

Status 1 returned on End Transaction operation when Version call is made inside transaction

61668

Random crash in the client cache engine

61773

Status 5 when performing many concurrent transactional inserts on a multi-core machine

61765

Correct Windows certificates on pre-Windows 8/2012 operating systems

61808

Status 3/73/170/171 may be seen when many users access an RI-bound database over a long time

61820

Engine may crash during shutdown while releasing resources

61830

General Error returned from a query with an outer join containing a constant value in the select list

61836

Problem with psp_indexes() function may cause indexes to be created with duplicate column entries

61856

SQL engine may crash on parameterized query with a SELECT list column name containing a ‘?’

61881

Various customer-requested enhancements to the new Monitor in PCC

61882

PCC may hang when opening a SQL script file with many comments containing double-byte characters

61928

VSS Freeze stage may never complete if an EndTransaction was in progress

61933

LIKE with multiple wildcards may not find all matching rows

61941

Various display fixes & enhancements in Capacity Usage Viewer

61953

EOF or Syntax Error creating a Function which contains CASE via PCC

61954

Function Executor does not create file with non-sequential key numbers specified

61955

Function Executor KeyNum list does not include all key numbers for a file with non-sequential keys

61958

Added support for STDEVP group aggregate (Standard Deviation of a Population)

61964

Added support for VAR & VARP group aggregates (Variance of a Population)

61965

Added support for DATEFROMPARTS, TIMEFROMPARTS, DATETIMEFROMPARTS, and DATETIMEOFFSETFROMPARTS scalar functions

61967

SQL Engine deadlock when running with DX

61971

SELECT DISTINCT query with joined tables may not return distinct values

61972

Legacy tables not working properly with ADO.NET Entity Framework

61975

Invalid Column Definition error when accessing a stored view in PSQL from a linked server connection in MS SQLServer

61978

General Error returned on parameterized Select …WHERE ? BETWEEN column1 AND column2

61985

File name in key buffer gets truncated when embedded spaces=On and file name contains multi-byte characters

61993

Incorrect results or SQL engine crash from REVERSE() on binary data on a Japanese OS

62007

ODBC application may crash when run locally on a server whose name contains Japanese characters

62013

PCC Server Monitor does not delete active sessions

62014

Various fixes to DATEFROMPARTS, TIMEFROMPARTS, DATETIMEFROMPARTS, DATETIMEOFFSETFROMPARTS scalar functions

62020

New Monitor does not show Japanese datasource or client host names on the SQL Active Sessions screen

62022

Error message truncated or not returned when calling a stored procedure with an invalid parameter

62023

Added status code 117 to be returned when corruption in a delta file is detected

62024

Function Executor list of recent files opened may not be correctly maintained

62041

NullPointerException error may be returned in PCC when viewing table properties

62043

ORDER BY an aliased column in a table subquery returns Error in Expression

62045

Possible Access Violation in SQL Server when using a Linked Server to PSQL

62047

Status 3 returned when reading a corrupt file instead of Status 2

62052

Workgroup Engine failing to autoload on first open request

62059

Add IPv6 support for Linux

62060

Add IPv6 support for PDAC and OLEDB

62061

Add IPv6 support to pvdbpass and pvddl command line utilities

62069

Incorrect results from query with multiple instances of the same alias

62072

Incorrect results returned when calling DATETIMEOFFSETFROMPARTS with Fractions parameters set to 0

62074

Count_Big() aggregate function added

62075

Status 12 possible on multi-core machine running multiple Btrieve applications

62093

Delete Session functionality of Monitor is not removing sessions

62094

OLEDB application connecting via IPv6 is using multiple licenses

62097

Status 3012 on first call to Workgroup Engine because it fails to autoload

62109

Possible engine crash when opening a database that has a large number of data paths defined

62119

User defined function is returning cached results instead of re-querying the database

62129

Possible SQL Engine crash when using ALTER TABLE to add an IDENTITY column on a large file

62131

Engine may crash when applying updates if “Accept Remote Requests” is off

62151

Possible status 85 in a Windows 2012 Cluster environment

62155

SQL engine returns incorrect results when query optimizes on a true null column’s index

62158

User Defined Function returns no padding spaces for fixed length strings

62161

Install build 024 for patch required original install files in order to complete

62164

Possible incorrect data used when modifying a DBMemo (longvarchar) via PDAC

62173

New Monitor & DTI do not properly handle Japanese machine names

62178

Trace requesters intermix results from different threads

62179

Possible segmentation fault when accessing a database through PHP using a web browser

62180

Workgroup engine may return status 2 opening empty data file using 512 page size on a Win2008 machine with a 4K block size

62181

LEFT & RIGHT scalar functions may not return correct results for binary data

62184

Error -3390 was returned when attempting to drop a database you have a session with, even if you are the only user with a session

62197

Unexpected deadlock when user is selecting on a primary key in a legacy table while another user in inserting into that table

62202

Slow down may be seen when license validation is executing

62209

The ClientWait perfmon counter was not properly decrementing

62210

L2 Cache size may be calculated incorrectly

62237

Possible status 54 and/or engine hang from Update Chunk operation following an Update

62239

Possible status 88 when ending continuous operations

62253

Double values may lose precision in ODBC applications

62262

Scale is missing when casting to Currency data type

62263

Multiple executions of cached stored procedure that has UNION or UNION ALL may not execute correctly

62267

Incorrect results when re-execution of  query with UNION or UNION ALL

62268

ADO.NET provider may use an additional license on a Vista machine

62277

SQL engine may crash or return error when inserting a row with a LongVarBinary column populated via a SELECT

62278

Incorrect results when re-executing a table query with both union & union all

62289

Inserting and updating a binary column with an integer value produces different values

62293

SQL OR optimization no longer requires columns to be specified in the same order as the index

62298

SQL engine returns “currency not on record” instead of status 82

62299

JDBC returns error or incorrect results on SELECT with subquery

62307

SELECT with UNION and mismatched data types may return “Numeric value out of range”

62310

MS Access 2013 64-bit may crash when connecting

62313

ALTER TABLE to change a BINARY to VARCHAR does not properly transform the data

62315

Added support for double-byte database names to Repair RI Database Name feature

62323

Increased the limit to 5000 for the maximum number of databases open at one time (64-bit only)

62324

PCC option to add data file to database not showing browse/ellipsis option on Japanese OS

62326

Possible engine crash when creating a table via ODBC using very long paths; now path can be 1024 bytes

62337

Precision error from SELECT with DISTINCT on a decimal column when using OLEDB

62338

11.30 engine may crash when executing SELECT INTO <temp table>

62339

SELECT with UNION between bigint and ubigint returns SQL_ERROR -1

62443

ADO.NET PSQLException only has the SQLSTATE Property set if SRDE’s SQLSTATE property is set to numeric

62344

SELECT with UNION between longvarchar and numeric returns SQL_ERROR -1

62346

Temp tables may not all get deleted after connection is closed

62347

PSQL OLEDB memory leak

62352

ALTER TABLE from legacy NOTE/LVAR to char/varchar corrupts data and may crash engine

62355

"Invalid Index Name; index not found" on INSERT with JOINed subselect using named index

62356

Incorrect Xf$Flags values for new tables created in V2 Metadata database

62358

License Self Repair may fail when BackupAgent, DataExchange or AuditMaster is installed.

62359

Possible engine crash if block comment indicator “/*” is used in a string constant

62360

CREATE TABLE with column DEFAULT specifying a UDF fails if UDF doesn't exist yet

62361

Inconsistent upper/lower case results when fetching view names via catalog function dbo.fsqltables

62367

"Not authorized to perform the operation" may be returned when calling a stored procedure created with ‘Execute as Master’

62368

CREATE TABLE IN DICTIONARY with USING index number clause fails if the data file doesn't exist

62369

Syntax error from ADO.NET provider if statement has a semicolon at the end

62371

Added support for PDAC XE4 and XE5

62373

Possible crash when stored procedure has typo in table name

62377

Patch may not install over a custom installation of PSQL v11 SP3

62379

Oledb not handling terminal service ID correctly, could cause crash

62386

Setting the Client DSN Array Buffer Size to 64 disables the buffer

62387

SQLBulkOperations() inserts incorrect data when auto translation is enabled and a non-default code page is in use

62388

Incorrect data inserted using arrays of parameters with auto translation

62391

Incorrect results may be returned from a Stored Procedure containing a SELECT with GROUP BY 

62393

BUTIL –STAT using URI format (btrv:///demodata?dbfile=file.ddf) may cause the engine to hang

62405

Fixed length strings may not be returned correctly when concatenated in a stored procedure or function

62408

Engine crash when running stored procedure that use clob field.

62411

The client id had all zeroes in the PARC timeout messages

62413

Triggers may not properly handle LONGVARCHAR/NOTE/LVAR data

62416

Concatenating LongVarChar data in stored procedure not being handled correctly

67617

Possible engine crash with key inserts into file with compressed pages and several indexes

62421

Incorrect date return with stored procedure using UDF and ORDER BY DESC

62422

SQLBindCol() + SQLFetch of longvarchar data does not return all the data

62423

SQLGETData for multichunk data returns incorrect results for UTF8 database with auto translation

62425

Alter table to change default to shorter value doesn’t set value correctly

62427

ADO.NET batch statement not executing all statements

62429

Possible hang on engine shutdown

62431

Alter Table can change data type of Primary Key

62432

Update trigger may crashes with recursive updates on CLOB column

62433

Possible memory overrun when calling a Stored Procedure with UDF and view

62439

Engine crash with an update trigger on longvarchar field

62440

Stored procedure with group by may crash Engine when result set contains only 1 row.

 

Added Support for XE6 PDAC

62442

SQL LIKE operator does not work properly on strings with private characters

62448

Possible engine crash with very large query exceeding 64k in length

62450

SQL Catalog function DBO.FSQLSTATISTICS does not return all unique indexes

62450

PDAC does not accept decimals with commas as decimal separators

62451

General Error returned from Stored Procedure instead of actual error when message is too long

62453

64-bit Microsoft Word crashes with ODBC DSN Connection on Windows 8 and Server 2012

62458

UNION ALL on LONGVARCHAR returns incorrect results

62459

PSQLDataAdapter does not work with Japanese named tables

62460

Excel 2013 64bit crashes on loading DSN with MSDASQL

62461

ADO.NET may lose a row from resultset when ReturnValue parameter is set

62463

Engine may crash creating index on large file because of  a problem related to page compression

62466

Added Support for XE7 PDAC

62467

JDBC error on SQLBINDPARM or engine crash when updating LONGVARCHAR/BINARY columns in PCC grid when multiple columns of the same data type exist

62468

Queries using LIKE are slower in v11 SP3 than in v9 SP2 on Japanese OS.

62469

Incorrect first row may be returned from Stored Procedure calling SELECT with GROUP BY

62470

INSERT fails on table where CHAR column has DEFAULT longer than column

62471

IFNULL returns Expression Evaluation Error

62472

SQL’s temp table closes may not be handled properly by the MKDE engine in some cases

62473

Random PDAC access violation errors using TPVQuery to retrieve data

62474

Possible crash on query containing parameterized value if incorrectly resolved.

62475

System.Access.ViolationException seen on  ADODB.RecordSetClass.Move with dynamic cursor

62477

Application using CP1250 encoding with ADO.NET 4.1 does not return data.

62478

Stored Procedure returns incorrect results with ADO.NET 4.0, 4.2 and “invalid cast” error with 4.1

62480

“Null not Valid” returned from view which has an UDF.

PSQL-1998

Possible status 3’s during validation process using defrag rebuild

PSQL-2247

ActiveX application crashes when opening file on non-existent drive mapping

PSQL-2275

Fujitsu Cobol ODBC sample is not working correctly with Psql ODBC

PSQL-2279

SQL query not executed in PCC because of single quotes

PSQL-2285

PVSW.Log has excessive messages, “the system cache will be used for file”

PSQL-2287

Data truncation error on Select statement with GROUP BY on LONGVARCHAR column

PSQL-2297

Constraint in Create statement does not create index

PSQL-2298

Cross Join query with table subquery may crash database engine

PSQL-2327

Memory leak in PDAC TPVQuery on table with LONGVARCHAR or NOTE field.

PSQL-2330

Problems with create table or create  procedure column defaults

PSQL-2350

ISQL on Linux does not display all characters when run against Windows server.

PSQL-2397

Deleting database name on bound database was deleting the ddfs

PSQL-2414

SQL Engine crash with query including a User Defined Function that returned many rows

PSQL-2449

Problem using ODBC translation dll under Psql v12

PSQL-2473

Bind/unbind v2 metadata returns "General_Error"

PSQL-2548

JCL error 3103 when URI contains Domain\\username

PSQL-2570

Decimal precision not handled properly in some cases

PSQL-2571

CAST decimal value as CHAR should maintain 0 place holders

PSQL-2576

Memory in use by V11.31.071 PSQL server may increase when opening and closing 1000s of files

PSQL-2629

Possible crashes from jdbc multithreaded application when one thread closes file while second thread is still fetching records

PSQL-2632

Possible crash rebuilding large segmented file into single segment file using file maintenance

PSQL-2635

Incompatible types in expression error after creating an index on one of the columns in the query.in ODBC application

PSQL-2638

Repair Bound database is not padding the Database Name with spaces

PSQL-2643

IFNULL/ISNULL() in other scalar functions causes "Expression evaluation error"

PSQL-2677

Multiple triggers on same table are not respecting execution ORDER specified

PSQL-2960

IndexoutOfRange exception returned by PSQL ADO.NET 4.0 and 4.1 providers.

PSQL-2725

ADO.Net returns “incompatible types in expression” after creating an index on one of the columns in the query

PSQL-2774

SQL statement is not returning the right results with ANSI_PADDING=off with temp table

PSQL-2789

ADO.NET fails with random error if there are nested datareaders

PSQL-3018

Currency Not On Record error returned with Case expression in WHERE clause

PSQL-3020

Currency Not on Record error with ORDER BY on temp table with Case Expression

PSQL-3036

File corruption may be seen in file with page compression after running rebuild

PSQL-3042

Underscore (_) in name cause other table records to  show in table properties

PSQL-3045

Create Database SQL statement with blanks in the DDF or Data path causes errors

PSQL-3046

SRDE should create paths that do not exist when used in CREATE DATABASE

PSQL-3051

Use <dbname>; statement fails due to trailing semicolon

PSQL-3052

Select from view with UNION and invalid ORDER BY may crash the engine

PSQL-3110

ADO.NET 4.1 provider: INOUT is not working with Command.Text

PSQL-3177

CREATE TABLE with USING clause specifying a path that does not exist should create the necessary folders and the file

PSQL-3178

CREATE…IN DICTIONARY…USING should succeed even if the specified file cannot be opened

PSQL-3215

ADO.Net application is not returning the record count correctly with Global table

 

 

 

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