Pervasive PSQL V10.00

Patch Release - 11/26/2008

Install Build version 10.01.075
Components Build version 10.01.042

 

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:

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

32-Bit Patched Files

ACBtr732.ocx
bdulb.dll
builder.exe
butil.exe
cobolschemaexec.exe
cobolschemaexecmsgrb.dll
collate.cfg
com.pervasive.jcl_1.0.0.jar
com.pervasive.jdbc.win32_1.0.0.jar
com.pervasive.jdbc_1.0.0.jar
com.pervasive.psql.utilities.javadti.win32_1.0.0.jar
com.pervasive.psql.utilities.external_1.0.0.jar
com.pervasive.psql.utilities.dbeditors_1.0.0.jar
com.pervasive.psql.utilities.sqleditor_1.0.0.jar
com.pervasive.psql.utilities.ddfbuilder_1.0.0.jar
com.pervasive.psql.utilities.ui_1.0.0.jar
com.pervasive.psql.utilities.core_1.0.0.jar
com.pervasive.ui_1.0.0.jar
dbcsipxy.dll
dto2.dll
enginelm.dll
guilcadm.exe
javadti.dll
legacylm.dll
licmgrrb.dll
mkc3.dll
mkdemd.dll
mkderb.dll
ntdbsmgr.exe
ntmkde.dll
pcc.exe
pceurop.dll
Pervasive.Data.SqlClient.dll
poledb.dll
psawizrd.exe
psc.exe
pscl3.dll
pscore3.dll
pscp932.dll
psdom.dll
psql.jar
pssax.dll
pstestct.dll
pstestsp.dll
pstsprb.dll
pvcaUtil.dll
pvinfodg.dll
pvjdbc2.dll
pvjdbc2.jar
pvlocate.exe
pvmdconv.exe
pvmsgrb.dll
pvnetpass.exe
rbldcli.exe
rbldgui.exe
rsiddf.dll
w32btxlt.dll
w3cache.dll
w3cobolschemaexec100.dll
w3csi100.dll
w3dbav75.dll
w3dbav78.dll
w3dbav80.dll
w3dbav90.dll
w3dbsmgr.exe
w3mif190.dll
w3mkde.dll
w3mpm100.dll
w3nsl260.dll
w3odbcci.dll
w3odbccs.dll
w3odbcei.dll
w3odbces.dll
w3sqlmgr.dll
w3sqlqpv.exe
w3sqlspy.dll
w3upi310.dll
w3xlt101.dll

64-Bit Patched Files

ntdbsmgr64.exe
w64csi.dll
w64dbcsipxy.dll
w64licmgrrb.dll
w64mif.dll
w64mkc3.dll
w64mkdemd.dll
w64mkderb.dll
w64mpm.dll
w64nsl.dll
w64ntmkde.dll
w64pceurop.dll
w64pceurop.reg
w64pscl3.dll
w64pscore3.dll
w64pscp932.dll
w64pscp932.reg
w64pvcaUtil.dll
w64upi.dll

Issues Addressed

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

Tracking Number

Description

57588

Engine crashed caused by corrupted file

57675

Engine crashed triggered by query timeout

57685

Random crash in internal ADOTest

57695

Select where date_field IS NULL not returning correct results

57701

Rounding issue with CONVERT

57724

Status 29 seen on executing VAccess's DdfCreateTable

57731

fails to insert multiple rows using parameterized batch inserts on SQL_C_CHAR

57737

psp_indexes() not returning 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

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

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

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

57872

MKDE ZString and WZString index compares can possible corrupt FCR KeyEntry

57879

JDBC is returning only one record running a stored procedure

57895

PCC Export Wizard should use static cursors for export recordset

 

Previous issues addressed in this Patch since PSQL v10 release :

Tracking Number

Description

52192

Engine crash due to memory corruption involving fully qualified domain names

53925

ALTER TABLE ADD PRIMARY KEY on nullable field should not be allowed

54017

PSA Loaded Modules screen picks up single letter files in Windows directory

54132

Insert Loop in Stored Procedure Stops Early

54158

SQLSetStmtAttr SQL_ATTR_PARAM_BIND_OFFSET_PTR causes wrong values to be inserted

54274

Getting status 3106 using URI's after a LOGIN

55318

Query Plan Viewer can't properly display statements with many levels of joins

55343

Calling a recursive SP always returns an error

55615

Often can't stop WGE when files are still locked

55759

Print statement hangs PCC and other GUI tools

55800

Very large insert hangs engine

55842

On 2k3 64-bit server Butil and BDU are not performing as expected for DB authentication

55938

 psp_index fails to return results on DDF files

55954

Engine crashed in rsiddf.dll when capturing an insert event for replication

55955

Psp_columns returns (null) for data type, type name, length, etc. on columns created with type UNIQUEIDENTIFIER

55956

Updating a CLOB data to an empty or null failed with "Invalid column number" error in PCC

55972

Long wait for return of SQL query results

56003

Under certain conditions Insert with an auto-inc field may hang

56022

No results returned when sub query contains TOP 0

56046

Updating a CLOB to a null via PCC crashed the engine

56083

Select query fails when ordered by same field as used in the left operator

56095

Query Plan Viewer displays numerous Error Message boxes when there is no sub-query

56104

DDFBuilder - When creating a new definition the PSQL Types view should be on top

56114

Status 7025 opening more than 100 sessions using DTI

56132

Incorporate the ability to have ANSI_PADDING turned OFF as a default

56139

W3sqlspy.dll and w3sqlqpv.exe fail to set resource version info

56149

Create view with table subquery and union fails with non unique column error

56150

No results on an cccurs tables because a pushdown filter is applied

56152

"Currency Not On Record" returned on query with UNION

56156

Cobolschemaexec turns CASESENSITIVE="true" into CASEINSENSITIVE in DDFs

56170

Pervasive Control Center starts the 64-bit version of ODBC Administrator

56175

MIF hang when quoted path contains a null

56178

Delay on B_Open if network not connected

56191

Incompatible types in Expression with SP & Date parameter

56194

A single user on Vista uses two licenses

56196

can't stop WGE invoking "pvkillwg.exe -f"

56212

MKDE trace file header is incorrect

56216

Query Plan Viewer no longer displays the SQL being analyzed

56218

Error seen on re-installing with temporary license

56220

Query cause Dr Watson in ntdbsmgr.exe

56222

VB/ODBC application gets a multi-step error when the legacy null date value is returned

56238

Fix PCC/Builder LANGUAGE attribute on Win32 binary

56243

Grant login with empty password does not put user in group

56248

LEFT function works differently than v9.50

56252

Engine crash with contops under stress

56254

Query slow, not optimizing correctly

56262

Random crash with VARCHAR column in comparison routine

56273

Engine crashes when running stored procedures

56274

Delete old PSQL ODBC Driver entries from the registry even if they are cruft

56281

Cannot insert into a table with default handle in a stored procedure

56285

Expression Evaluation Error when using IfNull in TimeStampDiff

56296

Query Plan Viewer crashes if something is selected from the subquery menu when no query plan is loaded

56303

Help button on Query Plan Viewer's Open File dialog does not work

56312

Query Plan Viewer crashes when the left hand side of the right hand pane is double-clicked

56322

SELECT INTO #temptable crashed after Timeout

56326

Use of the commandline utility psc with no service name leads to crash

56340

Escapes VB .NET Sample points to fixed IP address

56346

Wrong results on query with table subquery with TOP clause and order by

56352

Longvarchar/longvarbinary variables not working in stored procedures

56364

ALTER TABLE failed with "contraint has already been defined" error

56365

Query run with 9.52 slower than 9.50

56371

Cannot tell whether a view is trusted or not from PCC

56376

Select MIN with LIKE restriction returns incorrect results

56385

Fix for JDBC resource leak when prepareStatement() fails

56391

PCC opens all the databases on the machine when the database tree is expanded

56398

PCC's Data Import and Data Export have an unneeded English title on the dialog

56410

Concatenating strings in stored procedure fails

56412

Nested query is not producing proper results

56416

Query returns Unknown Error -19 in PCC

56424

Query with DISTINCT and CONVERT and UNION and empty returns status 29

56432

PSQL.VisualStudio.DataTools.dll is not registered correctly as a Data Provider

56433

Pervasive Data Provider does not appear in the Add Reference list

56438

Query performance slow compared to v8

56439

Extreme number of temp files and DDFs handles causes pauses and hang

56441

Update ADONETSETUP.EXE to take into account recent changes

56451

MKDE crashes on rebuilding a very large file

56456

Status 2 instead of 54 returned on corrupt file

56478

PCC returns diff number of rows than PsqlDataAdapter

56482

ADO.NET VB.NET samples contain unneeded reference to DDTek.SQLServer

56498

Reading CURRENCY data from a table using ODBC and the SQL_C_NUMERIC (SQL_NUMERIC_STRUCT) data type returns the correct value

56502

Query with union crashes engine

56505

4 byte memory leak by running TabSubQry.xml

56506

Mixed Mode can't be setup with v2 database and DefaultDB

56512

Unable to access Client "Splash Screen" setting from DTI interface on a WGE

56514

MKDE crashes in L2 cache when rebuild very large file

56515

Space() string function with concatenation generates incorrect results

56518

Customer has a database which includes NUMERIC(7,0) fields. When attempting to return a value which is the SUM of this field, the query fails

56519

One byte memory overwrite when CLOB data is more than 65500 bytes

56520

UNION ALL in Stored Procedure can cause an engine crash in PSQL 9.5 Workgroup Engine

56522

DDFBuilder: Column size changes automatically getting applied to next column

56536

Constraint has already been defined error

56544

Creating indexes leads to virtual memory running out

56548

Incorrect results using parameters in a stored procedure

56549

GPF in NSL from DOS application with floating point erroring on some machines

56552

Sql_columns returns null for fields of type GUID and DateTime

56558

Incorrect results with ROUND

56564

Prevent connect error if the JDBC JNI can't load

56570

Client hang. Clean up NSL semaphore

56577

E_FAIL using ODBC with BLOB data

56602

The Edit function for UDF, Sp and view in PCC fails

56607

Engine crash instead of status 12 when trying to open a missing occurs table

56622

PSP_COLUMNS is having problems with legacy datatypes and other types

56694

Query that requests the UNION of two specific views causes an abnormal termination

56698

Using IN Clause in SQL Statement returns "General Error" message

56744

Empty parameters in scalar functions can cause problems

56771

Engine crashes with SELECT in VALUES clause

56772

Restriction on aliased field using COALESCE crashes the engine

56774

Select CASE... AS ALiasID ... WHERE AliasID IS NULL returns no rows

56796

Order By DESC does not return correct results with JOIN

56815

OS handles not released on files in CO

56824

Lost one byte from the stored procedure when it is saved through PCC.

56835

Calling stored procedure with null parameters not returning error

56843

DateTime will not sort correctly with TimeStamp data in DateTime field

56846

v10 Rebuild utility does not use the saved registry value of the File Format

56850

PSQL Engine Crash with a complex view

56853

Engine Crashes when unmatched select list is used with UNION and ORDER BY clause

56867

Large query with UNION and ORDER BY DESC doesn't sort properly

56870

Problem creating database connection when cache engine is on

56904

CAST returns error on numeric/decimal in certain cases

56905

View columns cannot be used as passing parameters for UDF

56906

Alias does not work in table subquery in certain cases

56916

Database Open fails on UNC paths or mapped drives with Workgroup engine

56931

DDFBuilder starts a new session for each file edit

56960

GROUP BY with alias on a complex expression returns an error

56983

Problem caused by unexpected loading of both 6.15 and v10 engines

57099

64 bit PSQL engine L1 cache maxes out at 16 GB

57108

Activex crashes trying to open segmented files

57121

Nested stored procedures not handling parameters correctly

57136

Out of cache error with large temp table

57137

Increase size of the SRDE internal temp file to 4 GB

57154

Support table index hint with stored procedures and user defined functions

57140

PSQL engine hangs due bad tempdb install

57274

Stored procedure out params crash server

57288

TimeStampAdd can produce wrong information

57308

Problem with scrollable result set in Java with JDBC

57313

Pvcopydatabase fails when remote share is at the share level

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 creashes executing DTS package in MS SQLserver

57405

Table subquery is wrongfully considered as a DDL statement

57411

Memory leak in MIF

57424

Cache engine hang due to page invalidation error

57429

Union with local variables in the select list in SP failed

57431

Failure of IOCTL call causing 4GB segments to be created

57459

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

57462

Invalid subquery column reference

57483

SQLMGR crashed when running internal odbc3test

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 bring back records when order by is desc

57587

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

57607

Fix failures in internal DATETIME regression suite

57608

Crash in AllSP on Linux

57666

Application crash during shutdown

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