History File for Pervasive PSQL v11 SP1
General Release

Enhancements and Problems Fixed

July 2011

 

Tracking Number

Component

Description

60229

ActiveX

Automation error using ActiveX control in v10 or v11.

59975

ADO.NET

Cannot get parameter markers in scalar function SQL query to work when using ADO.NET

60100

ADO.NET

ADO.NET Copy Definition Functionality doesn't seem to be working

60289

ADO.NET

Data provider is not able to fetch the store generated values for all IDENTITY columns in a given table

59396

Btrieve

Btrieve Create Supplemental Index operation is slow on Linux

60447

Btrieve

BSTAT call is slow

56874

Communication

Every file opens takes around 20 seconds with Port 139 closed on the server.

57109

Communication

Remote access to PSQL engine sometimes hangs when PARC is enabled.

58399

Communication

Database engine (commsrv) is not logging messages to the pvsw.log

58811

Communication

Number of NumSatEntries limited to 255

59593

Communication

Pervasive Auto Reconnect sometimes resets running sessions

59666

Communication

Remote read-only access to active users and files in the monitor should not be allowed.

59913

DTI

ddf.h has arguments backwards for DTI functions

60042

DTI

Access violation in w3upi310 when pvsw.log is read only

60112

DTI

DTI call PvGetDBNamesData crashes UPI if too many databases

59070

DTO

Provide .NET DTO COM object that will compile for "AnyCPU"

59914

DTO

DTO PvRemoveUserFromGroup arguments should be swapped

57092

Install

CLSIDs/Program Identifiers from previous releases being removed from PSQL COM components

57949

Install

Patches fail to install on Windows cluster.

58041

Install

Modify PSQL install to prevent combining the PSQL MSI install w/ an MSP patch using the MSI command line.

58328

Install

Incorrect file name in preinstall.sh install script.

58698

Install

XIO shortcut name is "Statictics" instead of "Statistics"

59744

Install

v11 upgrade from v9 does not detect ActiveX SDKs installed.

59965

Install

On multihomed server, second profile in use is not opened in firewall during install.

59989

Install

Linux64 client RPM does not install on top of Linux32 client RPM

60136

Install

PSQL v11 64-bit does not install on Red Hat 6 64-bit

60389

Install

PSQL v11.0 install does not uninstall PSQL 2000i during upgrade

60558

Install

PSQL Engine start script on Linux needs to be updated

60235

JCL

JCL application returns incorrect data on 2nd run

60340

JCL

JCL null insert with true-null date column fills in a date

60280

JDBC

Closing a Statement in JDBC does not close the ResultSet

58381

MicroKernel

An update using a second handle is releasing the lock set by the first handle.

58718

MicroKernel

Operation counter goes negative in large MKDE Trace.

59029

MicroKernel

Exception may be thrown when cache engine exits.

59055

MicroKernel

Pervasive Event Log (PVSW.LOG) Cannot be deleted or edited while the engine is running.

59380

MicroKernel

File corruption during roll-back post disk full error

59396

MicroKernel

Create Supplemental Index operation slow on Linux

59804

MicroKernel

Tilde in filename generates a status 116 in WKG environment

59997

MicroKernel

Can't change working directory setting on Linux

60038

MicroKernel

Corrupt file causes 64-bit engine to crash

60063

MicroKernel

MKDE crashes when two different clients attempt to start Continuous Operations on the same file

60430

MicroKernel

Occasional status 2 when using Continuous Ops under heavy load

60529

MicroKernel

L2 cache sometimes becomes very small on Linux

60545

MicroKernel

Improve notification of licensing issues

60586

MicroKernel

Status 11 on trying to open Btrieve file in Japanese named directory when path is padded with spaces.

60353

ODBC

Support 64-bit ODBC on Linux

60248

OLEDB

OLEDB uses two licenses locally

60273

OLEDB

Repeating remote connect/disconnect in an OLEDB app leaks memory

59439

PDAC

Database names are not listed for PvQuery and PvTable during design time

60158

PDAC

Add RAD Studio XE support for PDAC

60706

PDAC

Memory leak in PDAC

57274

SQL

Stored procedure out parameters crash server.

58585

SQL

"Error in expression" or incorrect results when using a table subquery and an Order by on UDF

57355

SQL

Next autoincrement value varies after delete in transaction

59373

SQL

Incorrect result from a view with duplicate view column names

59627

SQL

Alter table allows a negative number to be converted to unsigned bigint

59655

SQL

UNION with ambiguous ORDER BY crashes server

59767

SQL

ROUND function does not allow more than six (6) decimal places

59795

SQL

"Select * into ..." fails with "Constraint name is too long"

59879

SQL

Table is empty after "SELECT INTO the table" when view is involved in the FROM clause

59880

SQL

Result set contains all NULLs after calling the same SP twice

59893

SQL

Query crashes server if the same column appears in different items in the selection list along with UNION in table subquery

59903

SQL

SP returns incorrect results when a table subquery is involved in left outer join

59911

SQL

Missing record in a rowset with INNER or OUTER JOIN when fetching backwards

59921

SQL

A missing record in a rowset with INNER or OUTER JOIN and a table subquery when fetching backwards

59924

SQL

The result is reversed in the very first result set when fetching backwards from calling an SP with outer join

59930

SQL

All rowsets are reversed when fetching backwards from calling an SP with SQL_UB_ON

59943

SQL

SQL parser should not be particular about the order of column attributes in a create table statement

59945

SQL

SQLColAttribute with SQL_DESC_BASE_TABLE_NAME/SQL_DESC_TABLE_NAME returns incorrect result on mergable views

59963

SQL

SQL engine crashed when running SRDE regressions against a v2 metadata

59976

SQL

Entity Framework provider is not able to support inheritance due to incorrect result

59998

SQL

Multiple calls to a stored procedure generates General Error

60025

SQL

Engine crashed when fetch last after SQLSetPos/SQL_UPDATE with static/dynamic cursor

60081

SQL

Query with outer join on computed fields not optimizing on index

60097

SQL

Engine eventually runs out of memory if Monitor is left running

60103

SQL

Disconnect/transaction rolled back messages and Memory Allocation errors

60118

SQL

TIMESTAMPADD returns incorrect value on leap year days

60123

SQL

SRDE crashed after selecting Monitor\delete all users

60148

SQL

Longvarchar value is retrieved using .net provider using a Stored procedure ,one character is dropped

60156

SQL

Erratic behavior for users with createview & createsp rights

60157

SQL

SQL Engine hangs/deadlock when clearing SQL connections via Monitor

60161

SQL

Possible crash in 64-bit SQL engine

60164

SQL

Engine crashed by running a stored procedure with a complex view

60166

SQL

Possible SQL engine crash on IF statement in VALUES clause

60169

SQL

"Numeric value out of range" on utinyint with value > 128 and COALESCE

60178

SQL

Null results from stored procedures when sp cache enabled

60191

SQL

Engine crash running FULL OUTER JOIN query

60192

SQL

Running stored procedure returns less number of rows

60208

SQL

SQL Engine crash on multi-level nested subquery

60233

SQL

Something is broken between "union all" and "timestampadd"

60249

SQL

Query with select top N updates all the records

60251

SQL

@@IDENTITY is not returning the value of the IDENTITY column that is the table's primary key

60252

SQL

SRDE engine not reporting error for GROUP BY on AGGREGATE function

60258

SQL

Comment with ? mark return2 "SQLBindParameter has not been called"

60272

SQL

$Relate column changed names from Xr$Pindex to Xr$Index in v9

60293

SQL

Crash when running a SQL query in customer application

60304

SQL

Bad database name causes SQL engine to crash on 64-bit Linux

60335

SQL

Invalid GRANT syntax should return error

60336

SQL

Customer would like SQL to support the 4th byte of TIME data

60362

SQL

Deadlock in SQL engine when using SQLPrimaryKeys

60366

SQL

Concat does not work with some data types

60380

SQL

ALTER TABLE ADD PRIMARY KEY on a column with the same type only updates DDFs without generating a physical index

60395

SQL

CHAR, ASCII scalar functions return incorrect results

60397

SQL

Query with OR returns only results matching the first condition

60406

SQL

SQL Engine should auto-add missing system table definitions even if the ddfs exist

60440

SQL

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

60451

SQL

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

60513

SQL

Incorrect results with DISTINCT in VIEW with ORDER BY

60515

SQL

Stored Procedure runs slower on a static cursor than on a forward-only cursor

60524

SQL

Results from STUFF scalar function may be truncated incorrectly

60542

SQL

Create primary key fails in SP

60548

SQL

Failed to execute "insert into #t1 select * from #t1"

60550

SQL

Create SP failed if table SQ contains a table created in SP

56568

Utilities

Customer requests utilities that monitor database performance

57657

Utilities

Double Dashes "--" in PCC force other SQL statements to become comments.

59011

Utilities

DDFBuilder's Table check generate confusing warning

59085

Utilities

PCC's Add Rows dialog's Reset button clears everything

59248

Utilities

PSA Network Test does not work with Ipv6 addresses

59342

Utilities

The Maintenance Utility Page Size window only displays four digits

59383

Utilities

Add an option to disable the context help in SQL editor

59478

Utilities

PCC and ddfbuilder have an incorrect error if creating a DB to an invalid directory

59547

Utilities

PCC import wizard BIT data type import problem

59610

Utilities

PCC's SQL view is incorrect when using a primary key

59638

Utilities

butil -endbu failing to Linux 64 under heavy load

59716

Utilities

PCC Stored Procedure Editor returns "No such table or object" when editing proc

60019

Utilities

BMon stops monitoring on status 7008, 7010 and 7015

60092

Utilities

Guipaadm authorization code incorrect under Win7

60265

Utilities

New functions "stdev" and "reverse" are not syntax colored in PCC

60270

Utilities

Maintenance utility is a little slower than Butil

60295

Utilities

bcfg crashed on Linux