Pervasive PSQL V10.10

Patch Release - 6/23/2009

Install Build version 10.13.060
Components Build version 10.13.040

 

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:

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

32-Bit Patched Files

ACBtr732.ocx

bdulb.dll

clilcadm.exe

cobolschemaexec.exe

com.pervasive.jdbc_1.0.0.jar

com.pervasive.psql.utilities.dbeditors_1.0.0.jar

com.pervasive.psql.utilities.ddfbuilder_1.0.0.jar

com.pervasive.psql.utilities.sqleditor_1.0.0.jar

com.pervasive.ui_1.0.0.jar

enginelm.dll

guilcadm.exe

legacylm.dll

licmgrrb.dll

mkdemd.dll

mkderb.dll

ntbtrv.exe

ntmkde.dll

poledb.dll

pvjdbc2.jar

readme.htm

rsiddf.dll

w3cache.dll

w3csi100.dll

w3dbsmgr.exe

w3els.dll

w3mif190.dll

w3mkde.dll

w3mif190.dll

w3mpm100.dll

w3nsl260.dll

w3odbcci.dll

w3odbcei.dll

w3sqlmgr.exe

w3upi310.dll

w3xlt101.dll

XioCache.sys

64-Bit Patched Files

w64clilcadm.exe

w64csi.dll

w64els.dll

w64enginelm.dll

w64legacylm.dll

w64licmgrrb.dll

w64mkdemd.dll

w64mkderb.dll

w64mif.dll

w64mpm.dll

w64ntmkde.dll

w64nsl.dll

w64pvcaUtil.dll

w64upi.dll

 

Issues Addressed

Specific issues addressed in this Patch release (Components Build 10.13.040):

Tracking Number

Description

 58052

“Multiple-step OLEDB error” from MS Excel when accessing table with Numeric data

 58069

Engine crash when joining a character string to a numeric column

 58083

Error “No such table or object” returned for query with a correlated subquery within a table subquery

 58087

Engine crash when new connection is made from a remote client while the engine is in “minimal state”

 58101

Engine crash resulting from invalid INDEX.DDF entry

 58105

Timestamp value “0001-01-01 00:00:00.0” returned as Null instead of midnight when using GMT time zone

 58111

Engine crash from query: Select count(*) from (Select count(distinct first_name) from person)

 58133

Engine crash from stored procedure with at least 63 parameters & variables


Previous issues addressed in this Patch since PSQL v10.10 release.

Tracking Number

Description

56570

NSL hang during LockSat() in NSL

57032

Allow Export Table Schema to Recognize Legacy Data Types

57184

PCC page down does not work correctly in Linux when grid is resized

57274

Stored procedure out params crash server

57291

Fails to create table with non-Ascii chars table name to secure database

57315

Engine crash when trying to set up a pushdown filter for a time column by parsing a non-null terminated string

57316

Relataional engine crashes executing DTS package in MS SQLserver

57352

XIO not cache files after install

57391

SQL Engine not matching index definition to existing Btrieve key

57405

Table subquery wrongfully considered as a DDL statement

57411

Simultaneous remote ODBC requests from server may cause memory leak

57420

PCC when running a query with group by clause, the grid only displays a single row

57424

Cache engine hangs on Get Equal after detecting page inconsistency

57429

Union with local variables in the select list in SP failed

57431

Failure of IOCTL call causing 4GB segments to be created

57452

PCC config file has typo that causes folders to be created each time PCC is run

57457

Internal DTI regression test causes crash

57459

Select count(*) from a view that contains aggregate functions with no GROUP BY fails with an error

57462

Invalid subquery column reference

57476

Export Table Schema Function Works Improperly if the USING Clause is Selected

57483

SQLMGR crashed when running internal odbc3test

57509

Monitor displays errors and eventually hangs when Japanese files are used

57551

ADO.Net app returns an error after numerous calls to a user defined function

57557

Error in Row when using Nested CAST and IFNULL

57565

Slow Performance with Pervasive.Data.SQLClient

57568

Query restriction ignored when order by is desc

57587

Dynamic paramters in a subquery expression appearing a select list returns error

57592

PvGetOpenFileName changed for jajp and causes BA not to work the way it worked before

57607

Fix failures in internal DATETIME regression suite

57608

Crash in AllSP on Linux

57615

PCC Data Grid Returns only 200 Records

57650

Engine crash when currency datatype value is updated via dynamic parameter

57664

DDFBuilder corrupting indexes with legacy binary bit flag

57665

ODBC returns "unknown encoding" if regional settings set to Chinese

57666

Crash during shutdown of NSL

57685

Random crash in internal ADOTest

57675

Engine crashed triggered by query timeout

57689

Unable to access databases secured in v9.5 with 8 character passwords

57695

Select where date_field IS NULL not returning correct results

57697

Instances of data or file deletion on Open (Btrieve Status 105)

57701

ESC 178254: Rounding issue with CONVERT

57704

CSI crash found running with DX

57720

Select Statement returns only 200 records in Grid Mode

57724

Status 29 seen on executing VAccess's DdfCreateTable

57729

File/data deleted when Btrieve CREATE issued w/ invalid Key Number

57731

Customers program fails to insert multiple rows using parameterized batch inserts on SQL_C_CHAR

57737

psp_indexes() not returning results

57738

PCC grid mode not showing all results

57762

Escaped single-quote in sub-select returns Syntax Error

57766

Reading 193 characters long including trailing spaces connection string from a text file causes error

57777

Cache Engine L2 causing status 100 by not releasing index page hold counts in certain situations

57800

57800: (10.13) Archival logging file is created with last letter missing

57802

Simple SQL Query returns the wrong results due to GetNextExt filter not setup correctly

57803

Error in expression error with a table subquery that contains a view with UNION

57804

Engine Crash on SQL Statement against COBOLSCHEMAEXEC created tables

57806

Crashed in sqlmgr due to invalid dbc handle

57809

Engine crash running UNION ALL query with "empty quote" Select appears before UNION ALL clause in the statement

57810

Engine crashes running Select CAST query

57815

Linux engine crash in licensing code during DTI test

57878

MKDE is not resolving the cluster name to the local host name in a Windows 2008 cluster

57859

Bad DDFs crash engine - should return error

57861

SQL Engine crashes on ADO move command against a temp file

57865

Query Plan doesn't capture DELETE statements

57866

TIMESTAMPADD returns incorrect year when adding 21 months

57871

UNION returns two extra rows via ODBCTest; correct results with PCC

57872

MKDE ZString and WZString index compares can possible corrupt FCR KeyEntry

57879

JDBC is returning only one record running a stored procedure. Works fine in PCC.

57881

MKDE crash with 9.5 monitor with many files open

57894

Status 2 errors are not reported back to the calling ODBC program

57896

INSERT with SELECT succeeds even though the column doesn't exist

57897

OEM/ANSI conversion causes problems in a PDAC app

57907

LIKE comparisons with wild cards return incorrect results in stored procedures

57912

Uses Alternate Collating Sequence in PCC should include any column, not only indexes

57922

Engine crash with invalid position

57932

JDBC 2 returns wrong results with TYPE_SCROLL_SENSITIVE cursor

57934

Server hung due to deadlock

57937

Problem with REPLACE in Stored Procedure

57938

Alter table to change the scale of numeric fails

57948

1 byte memory corruption in SQL Engine with Temp Tables

57950

Running SQL query in MS Access with Ccur function is returning "ODBC call failed" message.

57954

PCC was not determining the number of rows for the grid properly

57955

"CB001: Unknown Error" in cobolschemaexec

57956

Updating a Numeric or Decimal column is failing in ADO when cursor location is set to server.

57963

OLEDB returns error PS_MSG_N4821 when DDFs and data files are in different locations.

57964

SQL Engine crash accessing cached stored procedure.

57973

SQL Engine crash on query containing combination of ANSI and traditional joins in the FROM clause.

57985

Fix to auto-launch Query Plan Viewer for associated .qpf files.

57987

Incorrect results for query executed in grid mode after ALTER TABLE

57993

SELECT with OR clause returns rows multiple times

57997

OLEDB application crash in msvcr80.dll.

57998

Incorrect results for query with subquery column

57999

View, trigger, and stored procedure names displayed out of order in secure database when viewed by non-Master user

58012

Procedure does not execute all statements if an empty begin/end block is encountered

58018

Status 80 on UPDATE statement with READ_COMMITTED

58020

Query fails: “Select * from Person UNION Select * from Person ORDER BY first_name

58037

ALTER TABLE returns “Table in Use” instead of “You are not authorized” (Linux only)

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