Pervasive PSQL V10.31

Patch Release - 03/29/2012

Install Build version 10.31.045
Components Build version 10.31.040

 

Products

This patch applies to the following Pervasive PSQL products:

  This patch will not apply to versions of Pervasive PSQL v10 prior to Service Pack 3.

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:

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

Issues Addressed

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

Tracking Number

Description

58653

ODBC client cannot retrieve Blob data larger than 64K

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

61390

“Disconnect Error: Transaction rolled back” due to excess SQL threads not being released

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 in this Patch since PSQL v10.30 release:

Tracking Number

Description

 

57109

Remote access to engine hangs when PARC is enabled

 

57657

Two dash characters in text data causes PCC to view subsequent statements as comments.

 

58090

ADO.NET provider cannot connect to Japanese database names

 

58318

Local SQL connections may hang under long running conditions

 

58358

PCC & DDFB task bar icons do not display correctly on Windows 7

 

58423

PDAC-TPvQuery is not able to handle milliseconds value

 

58484

.NET provider displays columns names with hyphens incorrectly in Visual Studio

 

58585

“Error in Expression” on table subquery with ORDER BY on a UDF

 

58649

Creating a table with multiple 20 character column names where the first 19 characters are the same returns error "The constraint has already been defined”

 

58670

Reusing a command in ADO.NET with a different statement could cause an application crash

 

58671

Reusing a command in ADO.NET could result in some parameters set to null, which could overwrite data or produce “column not nullable” error

 

58672

An Update command restricting on an Identity column on a re-used ADO.NET command fails to update

 

58675

New ADO.NET connection option LongDataChunkSize (LDCS) for controlling the size of BLOB/CLOB data sent to the server

 

58677

.NET application may hang if there is a datatype mismatch of a date/time parameter

 

58685

Continuous Operations interfere with the creation of a new file extension.

 

58697

SRDE crashes when a table with a CHAR field with a DEFAULT value longer than 254 bytes is accessed

 

58704

UPDATE statement with more than one level of nested correlated subquery may update too many rows

 

58711

SELECT statement utilizing a table subquery may return incomplete results

 

58712

Phantom status 2 when using cache engine on slower clients with limited memory

 

58715

Continuous repeated execution of remote ODBC application may cause the SQL engine to hang

 

58712

Status 2 may be returned when cache engine is used with 6.x and 7.x files

 

58736

Dropping a “not null” constraint causes table to be rebuilt incorrectly, producing an invalid table definition

 

58750

"Currency not on record" returned when using a Btrieve Null key for optimization on query involving an OR condition

 

58752

Convert() scalar function on a longvarchar fails in JDBC/PCC with java.io.eofexception

 

58766

SQL engine could return a status 80 on an UPDATE

 

58780

Incorrect results returned on query with COALESCE involving columns from multiple tables

 

58789

Invalid Exception from the .NET provider (status -19 from the SQL engine) on query involving an indexed date/timestamp parameter on a non-equal comparison

 

58791

No data returned by the .NET provider on query with a GROUP BY and DATE parameters

 

58800

“View coalesce error” on query with nested subqueries

 

58815

“Invalid Argument Value” from stored procedure using a date parameter in a scalar functions DATEDIFF, TIMESTAMPDIFF, etc.

 

58827

“String length exceeds column length parameter #1 Data Truncated” error from MS Query on date/time/timestamp columns

 

58846

Dynamic parameters not getting resolved in table subquery with UNION

 

58847

Presence of parentheses () changes SQL execution.

 

58857

Exception caused by the ADO.NET provider for JOIN statement with TOP selecting numeric data with scale 0

 

58883

ADO.NET Managed Provider updated to v3.2.22.522

 

58884

“Invalid cursor position; no keyset defined” error returned by OLEDB on large VARCHAR/CHAR columns

 

58904

Inserting binary data literal via select corrupts input data

 

58975

SQLProcedures always returns 0 for Procedure_Type

 

58993

SQL scalar function RAND() returning incorrect values on Linux

 

59004

Date operations returns “Error in row”

 

59009

SQLExtendedFetch command crashes with forward only cursor and array fetch used.

 

59010

SRDE crash when optimizer evaluates index with 0 unique values.

 

59036

GetSchema with .NET provider returns incorrect information for indexes

 

59073

“Cannot locate named database” error against V2 metadata.

 

59075

License may be disabled on 64bit PSQL when Preallocate is set to “Yes”

 

59085

Reset button in Add Rows dialog in PCC is disabling the dialog usage.

 

59086

Syntax error compiling procedure with FOR UPDATE on SELECT with INTO

 

59105

Corrupt page compression data cause MKDE crash.

 

59137

Rand() function not producing random values.

 

59139

SQLTables return incorrect results if DBName is 20 characters long

 

59162

“Error in Predicate” message may returns from SQL statement with parentheses.

 

59163

Union with group by using NULL returns “Null not valid” error.

 

59164

Query against metadata v2 database causes engine crash.

 

59170

Subquery with dynamic parameters performance problem

 

59205

Maximum size of stored procedure text has been increased from 64K to 512K

 

59216

Status 2 may be returned when using cache engine

 

59241

“Error in Row” may be returned when calling a UDF in a stored procedure

 

59242

“Null not Valid” may be returned on query run on a dynamic cursor

 

59255

Extra blank padding may be returned on CHAR columns in some queries involving UNION

 

59263

Added thread-safe code to prevent possible crash when freeing metadata objects

 

59290

Multi-threaded application could get a status 71 after a thread issues a reset operation

 

59294

Invalid timestamp string literal not returning error

 

59324

Incorrect results with a CASE expression in a user defined function

 

59326

Edit table in PCC takes too long to load table definition

 

59327

Incorrect results from view with TOP clause when used in a subquery

 

59339

BUTIL –LOAD not handling segmented input file resulting from large blob data

 

59357

Incorrect results from query with mixed AND and OR clauses

 

59360

DTO hangs during a CreateObject call from a self hosted service

 

59366

View with a TOP clause should not be updateable

 

59373

Incorrect results from a view with duplicate column names

 

59376

SQL Engine will fail to DROP TABLE when no columns are defined

 

59383

New SQLEditor preference “Show context help” is now available

 

59410

Linux 64-bit Offline License Authorization fails running licgetauth

 

59414

Correct PCC jar file included in update

 

59450

SQLBindParamter on legacy Note/LVAR data corrupts heap and could cause engine to crash

 

59530

License keys become disabled if locale is switched to Japanese

 

59542

Function Executor does not show new COBOL datatypes

 

59547

BIT data imported incorrectly with SQL import

 

59576

Incorrect results with Left Outer Join on table subquery

 

59590

Windows 2008 R2 handles share names differently than Windows 2008, causing file access contention

 

59593

PARC sometimes resets running sessions when workstation reboots and reconnects very quickly

 

59610

PCC Edit Table, SQL View shows primary key incorrectly in the CREATE statements

 

59612

Create\Open files with blank-terminated names when Embedded Spaces=On is slow in v10

 

59627

Alter table allows negative number to be converted to unsigned bigint

 

59631

 

Error "The MaxOutputArrayCount property is only supported for output parameters" returned when calling a stored procedure with parameters with the .NET provider.

 

59632

Error “The output buffer is too small to contain the encoded data” is returned when inserting character data longer than 8001 bytes to a Pervasive Longvarchar datatype using the .NET provider.

 

59655

Union query with ambiguous table aliases in order by causes server crash

 

59673

ADO.Net 3.2 consumes extra license when run on Win2008R2 terminal services

 

59716

PCC Edit Procedure returns “No such table or object” when saving procedure

 

59767

 

Round function does not allow more than 6 decimal places

 

59795

Select * into…” fails with “Constraint name is too long”

 

59798

Port scanner can cause engine pause or crash when it scans port 3351

 

59804

Status 116 returned by Workgroup Engine when opening a file containing a tilde (~) character

 

59854

Status 5 possible with metadata statements in a V2 database

 

59877

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

 

59879

Select into a table is empty if a view is used in the “from” clause.

 

59880

Results contains all Nulls after called Stored Procedure twice

 

59885

Previous Update 6 causes license to be disable in vm environments

 

59886

Status 80’s and 4’s seen when using cache engine

 

59893

Complex union query crashes SRDE engine when process in PCC

 

59903

Stored Procedure returns incorrect results when table subquery is involved in left outer join

 

59911

Missing record in result set when fetching backwards after fetching forwards on statement with Join

 

59912

ADO.NET provider returns “Specified cast is invalid” when running a stored procedure

 

59921

Missing record in result set when fetching backwards after fetching forwards on statement with Join on table subquery

 

59924

Rows returned in incorrect order when fetching in different directions in a stored procedure

 

59930

Rowset results in reverse order when fetching backwards from a Stored Procedure using bookmarks

 

59945

Executing SQL_DESC_BASE_TABLE_NAME or SQL_DESC_TABLE_NAME on a view returns the table name rather than the view name

 

59975

“Error in Expression” returned by ADO.NET provider when using parameterized scalar functions

 

59998

“General Error” returned when running a stored procedure multiple times.

 

60019

BMon fails to continue logging after receiving error 7008, 7010, or 7015.

 

60025

SQL Engine crashes when fetch last is issued after a SQLSetPos & SQL_UPDATE

 

60081

Query with computed join field not optimizing on available index

 

60097

Memory allocations not released if Monitor SQL Connections screen is left open & refreshing

60103

Disconnect\Transaction Rolled back, and Memory Allocation errors seen when SQL engine runs low of available virtual memory

60118

TIMESTAMPADD returns incorrect value when leap year dates are involved

 

60123

Possible SQL engine crash when clearing users in Monitor

 

60148

Incorrect results or possible exception when retrieving 4096 byte longvarchar from a stored procedure called from ADO.NET

 

60156

Combination of CREATETAB/CREATEVIEW/CREATESP rights not working correctly together

 

60157

SQL Engine may hang when clearing SQL connections via Monitor

60164

Possible SQL Engine crash when executing a stored procedure which used a complex view involving scalar functions with dynamic parameters

 

60166

SQL Engine may crash on INSERT statement when IF condition used in a VALUES clause

60169

“Numeric value out of range” on unsigned integer data types when using the COALESCE scalar function

 

60178

Incorrect results from stored procedure executing a statement with an expression using LIKE and a dynamic parameter

60191

Possible SQL engine crash running FULL OUTER JOIN

60192

Incomplete results from query using UNION ALL in a stored procedure with a forward-only cursor and default rowset size

60208

SQL Engine may crash on multi-level nested table subqueries

60229

ActiveX may cause application to crash when RefreshLocation is set to True

60233

Incorrect results from SQU query using UNION ALL requiring a temp table with timestamp/date/time columns

60235

JCL returning incorrect results for tables using multiple consecutive non-null bit columns

60249

UPDATE view with subquery which specifies a TOP clause updates too many rows

60251

@@IDENTITY returns incorrect result on table with multiple IDENTITY columns

60252

Invalid GROUP BY clause should produce syntax error

60258

Error “SQLBindParameter has not been called” on query containing a comment with a ? character

60253

Requester delay due to named pipe not available (new setting)

60269

SQL engine may crash if attempting string scalar functions on numeric data types

60272

Cannot view relational constraints on database originally created with v8 or older engines

60273

Repeated connect/disconnect from a client OLEDB application leaks memory

60280

Closing a Statement object in JDBC does not implicitly close the Result Set object

60304

Memory allocation problem in resolving non-existent path name on Linux

60335

Invalid GRANT should return syntax error: GRANT SELECT ON Person.ID TO ‘Bill’; should be written as GRANT SELECT (ID) ON Person TO ‘Bill’;

60340

JCL insert NULL in true-null date column does not initialize the date value to 0000-00-00

60345

Additional trace information for failed connections added to trace components

60358

Error returned on query with embedded block comment containing single quote character

60362

Possible deadlock with multiple calls to SQLPrimaryKeys when accessing multiple databases

60366

“Error in assignment” returned when using the Concat() scalar function on non-string data types such as double, bit, binary, datetime and timestamp

60370

“Invalid date, time, or timestamp value” returned when using a datetime or timestamp column in the soundex() scalar function

60380

ALTER TABLE to designate an existing column as a primary key does not create the key in the physical file

60389

Installing over version 2000i does not detect the previous install

60395

“Expression evaluation error” returned by the CHAR() and ASCII() scalar functions when passed a value outside the 0-255 range

60397

Query with multiple conditions on the same column connected with OR may not return all results

60440

“Invalid trigger column reference” returned when executing trigger on a column with spaces in the name

60447

Btrieve STAT calls (and subsequently, OPEN operations) on Japanese machines are slower in v10 than previous versions

60451

The expression “NOT(5=3)” should return all data, but no data is returned

60513

Incorrect results from view with DISTINCT and ORDER BY

60523

ALTER TABLE to RENAME a table fails on Linux

60524

Results from STUFF scalar function may be truncated incorrectly

60548

INSERT INTO ”#t1” SELECT * FROM ”#t1” fails to insert

60550

CREATE PROCEDURE fails when it includes a query that references a table created in the same procedure

60561

STUFF() scalar function using datatype length instead of display length when processing

60565

Incorrect results using STUFF() scalar function on binary column

60597

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

60600

Gui Rebuild does not use pagesize selected

60701

OLEDB provider not returning Currency, Numeric or Decimal data correctly

60746

Stored Procedure returning message “Data truncated column 1”

60748

Create view returned message “Currency type changed”

60764

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

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

 

60849

Currently unsupported syntax GRANT ALL on VIEW/PROCEDURE * crashes Engine.

 

60857

SQL query with select subquery with ORDER BY not sorting properly

 

60858

Crash in SQLDisconnect when freeing cached stored procedure statements

 

60859

SQL Engine refuses new connections and returns status 2307

 

60863

CPSResourceBundle leaks on Japanese OS

 

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

Rights not being checked when creating triggers in a secure database

 

60951

Prepared statement does not re-check access rights when executed multiple times

 

60957

SQL engine crashes when executing statement GRANT EXECUTE ON PROCEDURE when a function name is specified

 

60963

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

 

60966

Memory leak in DTO retrieving dbnames information

 

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

 

61034

Changing user’s right in a secure database returns “Unsupported SQL command”

 

61148

Cancelling an insert after a SetRange cause stack overflow using PDAC

 

61169

Incorrect results from query with GROUP BY on decimal column

 

61172

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

 

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

 

61285

Application using get directs receives status 84 from insert after deleting 2 records

 

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

 

 

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