Pervasive PSQL v9 Service Pack 3 Update 4- README
General Release – Jan 2010

Contents

This document contains the following topics:

General Information

Welcome to the General Release of Pervasive PSQL v9 Service Pack 3 Update 4 (9.71.10). This release delivers functionality to Pervasive PSQL as described in Issues Addressed.

Pervasive PSQL v9 SP 3 Update 4 is a fully tested roll-up of the changes to the product since Pervasive PSQL v9 SP2 was released.

Note  The Installation Notes section contains important information to help you install successfully. Please read this section before attempting to install Pervasive PSQL v9 Service Pack 3 Update 4 or alter your existing configuration.

Installation Notes

Compatibility with Other Releases

This release supports the use of clients from Pervasive PSQL v9 SP1 and Pervasive PSQL v9 SP2 against a new Pervasive PSQL v9 Service Pack 3 Update 4 Server.

Pervasive recommends that you update both your server and clients to Pervasive PSQL v9 Service Pack 3 Update 4.

Note  A compatibility issue with data types BIGINT and NUMERIC and with bookmarks exists between a Pervasive PSQL v9.50 client and the Pervasive PSQL v9 Service Pack 3 Server. The workaround is to upgrade the Pervasive PSQL v9.50 client to a Pervasive PSQL v9 Service Pack 3 (9.71) client.

Using Other Data Management Products

This release supports Pervasive AuditMaster v6.3 (FTF build 6.30.022.000 or later), DataExchange v2.8 (FTF build 2.80.252.012 or later), and Backup Agent v1.1. You can access the downloads from the “Downloads” link on the Pervasive Software Web site (http://www.pervasive.com).

Pervasive PSQL v9 Service Pack 3 is not supported in an environment where AuditMaster v6.2, DataExchange v2.7, or Backup Agent v1.0 are installed.

Windows

Installation Requirements

(See also Environments Supported for the versions of Windows supported.)

  • You must have Administrator rights to install this product.
  • You must terminate all Pervasive PSQL sessions before installing this product.
  • You cannot install Pervasive PSQL from a terminal server session. You must be on the console of the server to install.
  • A local security policy in Windows XP Professional “Sharing and security model for local accounts” can adversely affect network logins. Under the default policy, all network logins to local accounts are authenticated as Guest, no matter what credentials were supplied. This causes your authorization for databases using Mixed or Database mode not to match your OS credentials and can prevent data access you intended to authorize. To resolve this condition, ensure that your policy for “Sharing and security model for local accounts” is set to Classic, which authenticates users as themselves. Windows 2003 already has a default setting of Classic. Windows XP Professional has a default setting of Guest, and Windows 2000 and earlier releases do not have this security policy. To find this policy in Windows XP, open Administrative Tools from the Control Panel, then select Local Security Policy. Under the node Security Settings, expand Local Policies then Security Options.

Installation Steps

1.    From the Pervasive Software Web site, download the Pervasive PSQL v9 Service Pack 3 Update 4 executable for Windows.

Download, or copy, the executable to the machine where your Pervasive PSQL is installed. The executable cannot be run remotely.

2.    Run the executable. The executable automatically detects whether you have Pervasive PSQL Server, Workgroup, or Client installed.

To display a list of available parameters, you can use the “/?” option (filename.exe /?).

Linux

Installation Requirements

(See also Environments Supported for the distributions of Linux supported.)

To use Pervasive PSQL Control Center or the JavaHelp documentation, you must install the Java Runtime Environment (JRE) 1.5.0 or later. You must manually install the JRE, which is available for download from http://java.sun.com.

In general, Pervasive PSQL v9 Service Pack 3 should work on Linux deployments with the following characteristics:

    • Kernel version 2.4 or higher
    • Glibc 2.2 or higher
    • PAM libraries (if PAM is selected for security)

Installation Steps

Pervasive PSQL v9 Service Pack 3 (9.71) for Linux is a complete installation. You must uninstall all components of the previous version of Pervasive PSQL before installing Pervasive PSQL v9 Service Pack 3.

Use the following commands to uninstall components of previous versions. You must be logged in as root to execute the commands.

Command

Use To Uninstall

RPM:

rpm -ev ‘Pervasive.SQL’

TAR (execute the uninstall scripts in the following sequence):

sh /usr/local/psql/etc/clientpreuninstall.sh

sh /usr/local/psql/etc/clientpostuninstall.sh

Server Engine

RPM:

rpm -ev ‘Pervasive.SQL-Client’

TAR (execute the uninstall scripts in the following sequence):

sh /usr/local/psql/etc/clientpreuninstall.sh

sh /usr/local/psql/etc/clientpostuninstall.sh

Client

RPM:

rpm -ev ‘Pervasive.SQL-PCC’

TAR (execute the uninstall scripts in the following sequence):

sh /usr/local/psql/etc/pccpreuninstall.sh

sh /usr/local/psql/etc/pccpostuninstall.sh

Pervasive PSQL Control Center

RPM:

rpm -ev ‘Pervasive.SQL-DOC’

TAR (execute the uninstall scripts in the following sequence):

sh /usr/local/psql/etc/docspreuninstall.sh

sh /usr/local/psql/etc/docspostuninstall.sh

JavaHelp Documentation

Use the following steps to install components of Pervasive PSQL v9 Service Pack 3. You must be logged in as root to execute the commands.

1.    From the Pervasive Software Web site, download the RPM or TAR file.

Download, or copy, the RPM or TAR to the machine where the Pervasive PSQL product was installed.

2.    Install the RPM or TAR using the appropriate commands in the following table.

Command

Use To Install

RPM:

rpm -ivh Pervasive.SQL-release-build.rpm

TAR (execute the installation scripts in the following sequence):

Copy the tar into /usr/local

Unpack the tar using the following command.

tar -xzf Pervasive.SQL-release-build.tar.gz

Change directories to the /usr/local/psql/etc folder where the installation scripts reside then run the following scripts.

sh preinstall.sh

sh postinstall.sh

Server Engine

RPM:

rpm -ivh Pervasive.SQL-Client-release-build.rpm

TAR (execute the installation scripts in the following sequence):

Copy the tar into /usr/local

Unpack the tar using the following command.

tar -xzf Pervasive.SQL-Client-release-build.tar.gz

Change directories to the /usr/local/psql/etc folder where the installation scripts reside then run the following scripts.

sh clientpreinstall.sh

sh clientpostinstall.sh

Client

RPM:

rpm -ivh Pervasive.SQL-PCC-release-build.rpm

TAR (execute the installation scripts in the following sequence):

Copy the tar into /usr/local

Unpack the tar using the following command.

tar -xzf Pervasive.SQL-PCC-release-build.tar.gz

Change directories to the /usr/local/psql/etc folder where the installation scripts reside, then run the following scripts.

sh pccpreinstall.sh

sh pcc postinstall.sh

Pervasive PSQL Control Center

RPM:

rpm -ivh Pervasive.SQL-DOC-release-build.rpm

TAR (execute the installation scripts in the following sequence):

Copy the tar into /usr/local

Unpack the tar using the following command.

tar -xzf Pervasive.SQL-DOC-release-build.tar.gz

Change directories to the /usr/local/psql/etc folder where the installation scripts reside then run the following scripts.

sh docspreinstall.sh

sh docspostinstall.sh

JavaHelp Documentation

(Note: The JavaHelp documentation is the same as that provided for Pervasive PSQL v9 Service Pack 2.)

NetWare

Installation Requirements

(See also Environments Supported for the versions of NetWare supported.)

You must have Admin rights to the NetWare server to install the product.

Installation Steps

1.    From the Pervasive Software Web site, download the Pervasive PSQL v9 Service Pack 3 Update 4 executable for NetWare.

Download, or copy, the executable to a Windows client machine that can connect to Pervasive PSQL Server on NetWare. The executable must be run in client/server mode.

2.    Run the executable.

To display a list of available parameters, you can use the “/?” option (filename.exe /?).

3.    Select the drive mapped to the NetWare server.

The executable defaults to the first network drive mapped, which may not be the one connected to the NetWare server.

Windows Patched Files

bdulb.dll

butil.exe

com.pervasive.psql.utilities.sqleditor_1.0.0

com.pervasive.core_1.0.0

com.pervasive.core.win32_1.0.0

com.pervasive.open.eclipse_1.0.0

com.pervasive.psql.utilities.external_1.0.0

com.pervasive.psql.utilities.core_1.0.0

com.pervasive.psql.utilities.dbeditors_1.0.0

com.pervasive.psql.utilities.ui_1.0.0

com.pervasive.psql.utilities.javadti.win32_1.0.0

com.pervasive.psql.utilities.javadti_1.0.0

com.pervasive.psql.utilities.common_1.0.0

com.pervasive.psql.utilities.core.win32_1.0.0

com.pervasive.ui_1.0.0

jpscs.jar

mkc3.dll

mkderb.dll

ntmkde.dll ----- (WINDOWS SERVER ENGINE)

poledb.dll

poledber.dll

poledbsy.dll

psql.jar

pvdrms.dll

pvjdbc2.jar

pvjdbc2x.ja

rbldcli.exe

rbldgui.exe

rsiddf.dll

w1mif183.dll

w1nsl251.dll

w3cache.dll

w3comsrv.dll

w3csi100.dll

w3csm100.dll

w3csp100.dll

w3mif183.dll

w3mkde.dll ----- (WINDOWS WORKGROUP ENGINE)

w3mpm100.dll

w3nsl251.dll

w3odbcci.dll

w3odbcei.dll

w3sqlmgr.exe

w3sqlmgr.dll

w3upi301.dll

w3xlt101.dll

NetWare Patched Files

brouter.nlm

btcpcom.nlm

mkc3.nlm

mkderb.nlm

nwcsi100.nlm

nwmkde.nlm

nwmpm100.nlm

nwodbcei.nlm

nwsqlmgr.nlm

nwxlt101.nlm

Issues Addressed

Specific issues addressed in Pervasive PSQL v9 SP3 update 4:

Tracking Number

Description

58248

Unable to update table inside stored procedure

58318

SQL Engine may access hang for local connections

58382

Select query with CASE on a view may cause the engine to crash

58407

Invalid date/time/timestamp error from UDF called in a stored procedure

58447

Null value in binary column in legacy table is blank-filled

58565

CREATE INDEX IN DICTIONARY hangs engine when file has multiple keys on the same column

58581

“Currency Not On Record” with Left Outer Join and subquery in join condition

58649

Creating multiple nullable column names with the same first 19-characters except for case returns error “The constraint has already been defined”

58697

SQL engine crashes when accessing a table with a CHAR field with DEFAULT value longer than 255 characters

58704

UPDATE statement with nested subquery correlation is updating too many rows

58715

Continuous repeated execution of SQL statements via ODBC/OLEDB may lead to the engine hanging

 

 

   Previous issues addressed in Pervasive PSQL v9 SP1, SP2, and SP3:

Tracking Number

Description

47042

RTRIM does not remove the trailing space

47261

Period as decimal separator returns wrong error code on European Windows operating systems

47269

Optimizer limits OR-connected predicates to 30

47335

Stored procedure does not update all columns when the procedure has 2 columns of different datatypes

47401

Null in the middle of a longvarchar was terminating the string when accessed through OLEDB application

47405

Query was not optimizing correctly on a >= and creating temp table when not needed

47493

USING is not supported in a stored procedure

47495

Aliases not being resolved

47506

SQLSetPos(SQL_ADD) is called and the row number parameter is larger than the set rowset size

47528

If result of multiplication is zero, incorrect rows returned if the datatypes being used are a mix of decimal and integer

47542

@@IDENTITY not returned properly with INSERT from one statement and the select @@IDENTITY from another

47548

An aggregate in an IF in the selection-list or HAVING clause returning an error

47557

Order By causes status 6 when non-standard ACS is part of the index with CursorLocation as Server and CursorType as Static

47575

ORDER BY was not being correctly handled if it was inside an updateable cursor for Stored Procedure

51854

Additional JCL failures in Linux server cause by XLT

53423

GUID DataType is giving error when used with Pervasive OLEDB Provider

53684

Engine crashes using a query with nested scalar functions in the select list

53698

Running certain View causes error "The number of keys specified is invalid (Btrieve Error 26)"

53759

Tables not flagged correctly for True Nulls (mask 64)

53802

Filter comparisons limited to 256 bytes for LONG character data

53861

Inner join syntax with OR in WHERE clause doesn't return all rows

53862

UNION ALL in stored proc returns no data

53911

Query Timeout is not working correctly

53912

IN clause fails to return rows under certain conditions

53925

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

53948

Invalid Date/Time/Timestamp data type exception with ADO.NET provider

54009

Error "Buffer too small, data truncated" when doing select.

54045

Local Btrieve API access to a WGE does not work if KeyBuffer is not Null-terminated

54046

Selecting a database in PCC and opening a SQL statement should default to the selected database

54051

No such table or object using legacy DDF's on NetWare or Linux

54054

Data truncated error using LIKE parameter

54056

Certain sequence of bytes in Keybuffer on Open command to local WGE causes hang

54060

DSNLess connection was broken in v9 SP2 (9.50)

54062

ODBC error Currency not on a record with subquery in the WHERE clause

54063

V7 to V9 NOTE to LONGVARCHAR gets status 46

54069

Provide ability to enable/disable execute queries asynchronously

54072

B_SET_OWNER(29) is ignored by PCC (still writeable)

54090

Incorrect results from function

54091

Deleting a database while NOT logged in fails to delete the Engine DSN on Linux

54096

SUBST drives do not work in DSNs

54106

Local server's Japanese machine name is garbled on Monitor utility

54108

Undo version 9 change in behavior with binary 0 padded fixed length strings

54109

Top clause does not work in vbSqltester with UseServer/Static/Grid

54117

For very large data files index building may be very slow

54118

Seek on UBigInt doesn't work with V9 SP2

54123

Adding columns using OLEDB returns 0

54128

BUTIL -STAT displays Japanese named extension file names as garbage

54132

Insert Loop in Stored Procedure Stops Early

54139

6.x files updated by 8 or newer engine incompatible with Btrieve 6.10

54151

User displayed in Monitor after BackupAgent has run

54158

SQLSetStmtAttr SQL_ATTR_PARAM_BIND_OFFSET_PTR causes wrong values to be inserted

54159

CREATE TABLE with FOREIGN KEY returns status 5

54161

Incorrect results using MIN or MAX on indexed unsigned integer columns

54167

Random crashes with some web apps talking to several databases on the server

54169

Numeric & NumericSA don't display 0 after decimal via ODBC

54172

Incorrect results using "IS NOT NULL" on indexes

54184

select from select with outer join crashes engine

54192

Running Select query with joins using Dynamic cursor is returning status "Null is not valid"

54204

Prevent FCR key counts from going negative

54205

Status 2 on create index with ACS

54210

Requester needs to recognize the clustername as local

54232

PCC runs the wrong SQL

54274

Getting status 3106 using URI's after a LOGIN

54331

Allow user to set blank password

54334

Cannot connect to remote databases using PCC if not using the default port of 1583

54474

20 character long table name is causing "Table not found" error on an Open

54491

GPF in MIF when doing B_STAT with keybuflen=0

54551

Engine is taking one extra license with PvStart and PVOpendatabase calls

54605

CR 53932 caused hang when DRM & CSI connect to local engine with same Process ID (internal Test)

54644

Abort/End Transaction not sent after network error on another session

54648

Cache Engine not found by PvGetEngineInformation call on Vista

54651

Status 20 on Abort_Transaction to 7.00 PSQL server from WGE

54696

Transaction logging logs incorrect key number

54709

Unexpected status 139 on End Transaction during Roll Forward

54729

DDF's remain open by a client 13x when table properties are viewed in PCC

54730

Reduce chances of large index rebuild hang

54749

When certain strings are used in a scalar string function it behaves incorrectly

54763

Timestamp data not displaying correctly in PCC

54953

Crash in w3comsrv after successful AutoReconnect

54962

Compression overrun cause engine to crash

55033

Getting error on some tables "requested conversion not supported" using .Net

55050

Brouter returns status 12 connecting to remote servers

55334

JDBC driver is adding one hour to the time stored in the database on a UTC function call

55343

Calling a recursive SP always returns an error

55434

German umlauts [öäü]) could not be search with a „LIKE“ statement

55437

Performance slowdown on NW with TCP when client uses client engine & SQL

55497

Token handle leak in MKDE with Continuous Operations

55506

Status 11 to local engine after connecting to 32nd remote server

55700

Crash was in w3xlt101 when calling pvCloseDatabase

55716

Status 7003 in PCC\Database Properties when long data paths defined

55800

Very large insert hangs engine

55810

Setting Use Local Engine to Off causes PSQL services to not start

55851

ADO with OLEDB and Auto Translate=True crashes on Vista

55938

Psp_index fails to return results on DDF files

55955

Psp_columns returns (null) 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

55978

When running with L2 off too many pages getting periodically purged from L1

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

56114

Status 7025 opening more than 100 sessions using DTI

56132

Incorporate the ability to have ANSI_PADDING turned OFF as a default

56149

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

56150

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

56152

Currency Not On Record" returned on query with UNION

56172

Archive logging does not work for Japanese named Btrieve files

56175

MIF hang when quoted path contains a null

56178

Delay on B_Open if network not connected

56186

DDFs left open after table= URI used to access table under RI control

56191

Incompatible types in Expression with SP & Date parameter

56220

Certain queries with AND/OR combination in the restriction can cause a crash in ntdbsmgr.exe

56222

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

56243

Grant login with empty password does not put user in group

56248

LEFT function not working correctly

56252

Engine crash with continuous operations under stress

56254

Query slow, not optimizing correctly

56262

Random crash with VARCHAR column in comparison routine

56273

Engine crashes when running stored procedures with data type/length mismatch with output parameters

56277

Fix for threads not terminating when connecting to remote server

56281

Ca not insert into a table with default handle in a stored procedure

56285

Expression Evaluation Error when using IfNull in TimeStampDiff

56313

Rolling forward Japanese named files by drive letter does not work

56322

SELECT INTO #temptable crashed after Timeout

56342

When rolling forward, if you specify create a dump file, status 62 results

56346

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

56349

Japanese file names in a Roll forward dump file are garbled

56352

Longvarchar/longvarbinary variables not working in stored procedures

56364

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

56365

Query run with 9.52 slower than 9.50

56376

Select MIN with LIKE restriction returns incorrect results

56385

Fix for resource leak when prepareStatement() fails

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, UNION and empty string returns status 29

56438

Query performance slow compared to v8

56439

Pauses and hang on v9 SP2 due to excessive temp files and DDF files handles

56440

Unable to make new Sql connections via odbc on Linux

56456

Status 2 instead of 54 returned on corrupt file

56461

Japanese Rebuild GUI is leaking memory heavily

  56464

 DataExchange opens DDF handles but does not release them until the SQL session is closed

56478

PCC returns different number of rows than PsqlDataAdapter

56498

Writing CURRENCY data from a table using ODBC and the SQL_C_NUMERIC not working correctly

56502

Query with union crashes engine

56504

Failures in Metadata on NetWare

56505

4 byte memory leak by running TabSubQry.xml

56515

Space() string function with concatenation generates incorrect results

56518

Query fail When attempting to return a value which is the SUM of a field which includes NUMERIC(7,0)

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

56536

ALTER TABLE with column defined as NOT nullable and greater than or equal to 18 characters fails

56543

Division using BIGINT truncates results

56548

Incorrect results using parameters in a stored procedure

  56549

 General protection fault in DOS application resulting from floating point stack error

56552

Sql_columns returns null for fields of type GUID and DateTime

56558

Incorrect results with ROUND

56570

Client hang. Clean up NSL semaphore

56577

E_FAIL using ODBC with BLOB data

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 with UNION of two views causes an abnormal termination

56698

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

56731

Extra failures in client-server ODBC3 regression caused by precision changes in FLOAT, BFLOAT8, DOUBLE, REAL, BFLOAT4

56742

View problem with duplicate view columns

56744

Empty parameters in scalar functions can cause problems

56755

W3odbcei crash reading a variable in the DRM

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

56824

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

56830

Create View changes DateAdd/DateDiff parameter

56835

Calling stored procedure with null parameters not returning error

56850

PSQL Engine Crash with a complex view

56853

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

56870

problem creating database connection when cache engine is on

  56892

 General protection fault results when an unknown file referenced in a mapped drive is the target

  56905

 User-defined function cannot use view columns to pass parameters

56960

GROUP BY with alias on a complex expression returns an error

57121

Nested stored procedures not handling parameters correctly

57137

Increase size of the SRDE internal temp file from 2GB to 4GB

57154

Support table index hint with stored procedures and user defined functions

  57274

 Stored procedure “out” parameters crash server

57288

TimeStampAdd can produce wrong information

57308

Problem with scrollable result set in Java with JDBC

57315

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

57316

Relational engine crashes executing DTS package in MS SQLserver

57405

Table subquery is wrongfully considered as a DDL statement

57411

MIF memory leak causing engine to ran out of address space on Linux

  57420

 Data grid in PCC displays only a single row from query with GROUP BY clause

57424

Cache engine hang due to page invalidation error

57429

Union with local variables in the select list in SP failed

  57431

 Failure of call causes 4 GB 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

57526

Files do not fall out of AFL list causing status 86

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

  57588

Corrupted file could cause engine to crash

  57607

 Two failures in internal DATETIME regression suite

  57608

 Crash in AllSP only on Linux

  57675

 Engine crashed triggered by query timeout

  57685

 Random crash in ADOTest

  57695

 Select where date_field IS NULL not returning correct results

  57701

 Rounding problem with CONVERT function

  57731

 Multiple rows fail to insert with parameterized batch inserts on SQL_C_CHAR type

57762

Escaped single-quote in sub-select returns syntax error

57766

Connection string from a text file failing

57777

Cache Engine plus L2 causing L1 filling by not releasing index page hold counts

57802

Simple SQL Query returns the wrong results

  57803

 Table subquery that contains a view with UNION returns “Error in expression” error

57806

Crash in relational interface component due to invalid dbc handle

  57835

 On Linux SuSE, database engine does not start automatically after operating system reboot

  57859

Invalid DDFs could cause engine to crash

  57861

ADO move command on temp file could cause engine to crash

  57865

DELETE statements not captured in query plan

  57866

TIMESTAMPADD returns incorrect year when adding 21 months

  57871

UNION returns extra rows

  57872

 ZString and WZString index compares can corrupt data file

  57879

JDBC only returning one row from stored procedure

  57894

Status 2 not returned to ODBC applications

  57896

INSERT with SELECT succeeds with mismatched columns

  57907

LIKE with wild cards returns incorrect results in stored procedure

  57912

PCC not displaying ACS information for non-indexed columns

  57922

Invalid position could cause engine to crash in v6.x file

  57932

JDBC 2 returns incorrect results with TYPE_SCROLL_SENSITIVE cursor

  57934

Deadlock causes engine to hang

  57937

REPLACE scalar function not working correctly in stored procedure

  57938

ALTER TABLE not changing scale of numeric columns

57950

Running SQL query in MS Access with Ccur function is reteurning “ODBC call failed” message

  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 in PCC Grid mode after ALTER TABLE

  57993

SELECT with OR clause returns duplicate results

  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)

  58052

Multi-step OLEDB error from Excel opening tables with Numeric columns

  58069

SQL Engine crash accessing NUMERIC data containing spaces

  58083

Syntax error "no such table or object" on table subquery with Exists

  58101

SQL Engine crash accessing index.ddf with invalid entries

  58105

Timestamp 0001-01-01 00:00:00.0 returned as null instead of midnight in GMT

  58111

SQL Engine crash from select count(*) with table subquery

  58117

Coalesce does not return correct SQL error status

  58133

SQL Engine crash when using stored procedures with many parameters

  58143

"Error writing to OutPut Parameter 2" error message from stored procedure caused by numeric/decimal overflow

  58185

SQL engine crash from statement with a join to a table subquery

  58220

Deadlock between SQL engine and DX

  58326

Using OLEDB, the MAX function is truncating the last byte of a char data.

  58356

SQL engine crashed when dropping a Cobol table

  58357

Select sum(-Amount_owed) returns error "Numeric value out of range"

  58359

SQL with order by clause returns "Null not valid" error

  58372

SQL Engine crashes on Update using subquery with the same table name

  58386

Engine crashes due to index range comparison with OR (BINARY comparison)

  58389

Engine crash when inserting 160Mgs of binary data

  58391

Random crash using null string with a LIKE clause

 

Environments Supported

Server Engine

The Pervasive PSQL v9 Service Pack 3 Server is supported on the following. Each platform includes the latest service packs, if provided, as of May 2009.

  • Windows 2003 R2 Server 64-bit Edition
  • Windows 2003 Server 64-bit Edition (SP 2)
  • Windows 2003 R2 Server, Small Business Server, and Failover Cluster
  • Windows 2003 R2 Server Terminal Services
  • Windows 2003 Server, Small Business Server, and Failover Cluster (SP 2)
  • Windows 2003 Server Terminal Services (SP 2)
  • Windows 2000 Advanced Server, Server, and Server and Terminal Services (SP 4)
  • Windows 2000 Failover Cluster (SP 4)
  • Citrix MetaFrame Presentation Server, Version 4.0
  • Novell NetWare 6.5 (SP 7)
  • Novell Open Enterprise Server (OES) (NetWare SP 5)
  • Red Hat Enterprise Linux ES 4 64-bit (Update 2)
  • Red Hat Enterprise Linux ES 3 and 4
  • SuSE Linux Enterprise Server 9 64-bit (Update 2)
  • SuSE Linux Enterprise Server 9 (Update 2)
  • SuSE Linux Workstation 10

Workgroup Engine

The Pervasive PSQL v9 Service Pack 3 Workgroup is supported on the following. Each platform includes the latest service packs, if provided, as of May 2009.

  • Windows 2003 R2 Server 64-bit Edition
  • Windows 2003 Server 64-bit Edition (SP 2)
  • Windows 2003 R2 Server and Small Business Server
  • Windows 2003 Server and Small Business Server (SP 2)
  • Windows 2000 Advanced Server, Professional Server, Server, and Small Business Server (SP 4)
  • Windows XP Professional 64-bit Edition (SP 2)
  • Windows XP Professional and Home Edition (SP 3)
  • Window XP Embedded (SP1), and Embedded for Point of Service, assembled from components to be functionally equivalent to Windows XP Professional
  • Windows 98, 98 SE, and ME (all Microsoft patches as of May 2009)

Clients

The Pervasive PSQL v9 Service Pack 3 client is supported on the following. Each platform includes the latest service packs, if provided, as of May 2009.

  • Windows 2003 R2 Server 64-bit Edition
  • Windows 2003 Server 64-bit Edition (SP 2)
  • Windows 2003 R2 Server, Small Business Server, and Terminal Services
  • Windows 2003 Server, Small Business Server, and Terminal Services (SP 2)
  • Windows 2000 Advanced Server, Server and Professional (SP 4)
  • Windows 2000 Advanced Server and Server with Terminal Services (SP 4)
  • Windows XP Professional 64-bit Edition (SP 2)
  • Windows XP Professional and Home Edition (SP 3)
  • Window XP Embedded (SP1), and Embedded for Point of Service, assembled from components to be functionally equivalent to Windows XP Professional
  • Windows NT4 Workstation (SP 6a)
  • Windows 98, 98 SE, and ME (all Microsoft patches as of May 2009)
  • DOS 6.22
  • Red Hat Enterprise Linux ES 4 64-bit (Update 2)
  • Red Hat Enterprise Linux ES 3 and 4
  • SuSE Linux Enterprise Server 9 64-bit (Update 2)
  • SuSE Linux Enterprise Server 9 (Update 2)
  • SuSE Linux Workstation 10

Documentation Notes

This section provides information regarding the documentation included with the Pervasive PSQL v9 Service Pack 3 product.

Note  The JavaHelp documentation is the same as that provided for Pervasive PSQL v9 Service Pack 2.

Documentation Formats

On Windows platforms, the JavaHelp and HTMLHelp (CHM) formats are installed by default with the product. The JavaHelp is installed under the Bin\Plugins directory (by default, C:\PVSW\Bin\Plugins). The HTMLHelp is installed under Program Files\Common Files\Pervasive Software Shared\Doc.

Note  The HTMLHelp (CHM) files are installed as part of Pervasive System Analyzer (PSA). If you perform a silent install and omit PSA, the CHM files are not installed. The installation Registration page contains links to CHM documentation. These links do not work unless PSA is installed.

On Linux, the JavaHelp is a separate installation from the Server, the Client, or the PCC installation. You must manually install the JavaHelp if you want it. By default, the JavaHelp is installed to /usr/local/psql/bin/plugins/. See “Installing PCC and Documentation on Linux” chapter in Getting Started with Pervasive PSQL (Server Edition).

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.  
PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES 
WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING 
THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; 
PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND 
YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE 
SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, 
INCLUDING, FOR EXAMPLE, WITH RESPECT TO 
MERCHANTABILITY, TITLE, OR FITNESS FOR ANY 
PARTICULAR PURPOSE OR ARISING FROM COURSE OF 
DEALING OR USAGE OF TRADE, AMONG OTHERS.  
THIS APPLICATION USES THE FREE unixODBC DRIVER 
MANAGER AS WRITTEN BY PETER HARVEY 
(pharvey@codebydesign.com), MODIFIED AND EXTENDED 
BY NICK GORHAM (nick@easysoft.com), WITH LOCAL 
MODIFICATIONS FROM PERVASIVE SOFTWARE. PERVASIVE 
SOFTWARE WILL DONATE THEIR CODE CHANGES TO THE 
CURRENT MAINTAINER OF THE unixODBC DRIVER MANAGER 
PROJECT, IN ACCORDANCE WITH THE LGPL LICENSE 
AGREEMENT OF THIS PROJECT. THE unixODBC DRIVER 
MANAGER HOME PAGE IS LOCATED AT WWW.UNIXODBC.ORG. 
FOR FURTHER INFORMATION ON THIS PROJECT, CONTACT 
ITS CURRENT MAINTAINER: Nick Gorham 
(nick@easysoft.com)." 
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 ***