History
File for Pervasive PSQL v11 SP1
General Release
Enhancements
and Problems Fixed
July
2011
|
Tracking
Number |
Component |
Description |
|
|
ActiveX |
Automation error using ActiveX control in v10 or v11. |
|
|
ADO.NET |
Cannot get parameter markers in scalar function SQL query to work when using ADO.NET |
|
|
ADO.NET |
ADO.NET Copy Definition Functionality doesn't seem to be working |
|
|
ADO.NET |
Data provider is not able to fetch the store generated values for all IDENTITY columns in a given table |
|
|
Btrieve |
Btrieve Create Supplemental Index operation is slow on Linux |
|
|
Btrieve |
|
|
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. |
|
|
Communication |
Database engine (commsrv) is not logging messages to the pvsw.log |
|
|
Communication |
Number of NumSatEntries limited to 255 |
|
|
Communication |
Pervasive Auto Reconnect sometimes resets running sessions |
|
|
Communication |
Remote
read-only access to active users and files in the monitor should not be
allowed. |
|
|
DTI |
ddf.h has arguments backwards for DTI functions |
|
|
DTI |
Access violation in w3upi310 when pvsw.log is read only |
|
|
DTI |
DTI call PvGetDBNamesData crashes UPI if too many databases |
|
|
DTO |
Provide .NET DTO COM object that will compile for "AnyCPU" |
|
|
DTO |
DTO PvRemoveUserFromGroup arguments should be swapped |
|
|
Install |
CLSIDs/Program Identifiers from previous releases being removed from PSQL COM components |
|
|
Install |
Patches fail to install on Windows cluster. |
|
|
Install |
Modify PSQL install to prevent combining the PSQL MSI install w/ an MSP patch using the MSI command line. |
|
|
Install |
Incorrect file name in preinstall.sh install script. |
|
|
Install |
XIO shortcut name is "Statictics" instead of "Statistics" |
|
|
Install |
v11 upgrade from v9 does not detect ActiveX SDKs installed. |
|
|
Install |
On multihomed server, second profile in use is not opened in firewall during install. |
|
|
Install |
Linux64 client RPM does not install on top of Linux32 client RPM |
|
|
Install |
PSQL v11 64-bit does not install on Red Hat 6 64-bit |
|
|
Install |
PSQL v11.0 install does not uninstall PSQL 2000i during upgrade |
|
|
Install |
PSQL Engine start script on Linux needs to be updated |
|
|
JCL |
JCL application returns incorrect data on 2nd run |
|
|
JCL |
JCL null insert with true-null date column fills in a date |
|
|
JDBC |
Closing a Statement in JDBC does not close the ResultSet |
|
|
MicroKernel |
An update using a second handle is releasing the lock set by the first handle. |
|
|
MicroKernel |
Operation counter goes negative in large MKDE Trace. |
|
|
MicroKernel |
Exception may be thrown when cache engine exits. |
|
|
MicroKernel |
Pervasive Event Log (PVSW.LOG) Cannot be deleted or edited while the engine is running. |
|
|
MicroKernel |
File corruption during roll-back post disk full error |
|
|
MicroKernel |
Create Supplemental Index operation slow on Linux |
|
|
MicroKernel |
Tilde in filename generates a status 116 in WKG environment |
|
|
MicroKernel |
Can't change working directory setting on Linux |
|
|
MicroKernel |
Corrupt file causes 64-bit engine to crash |
|
|
MicroKernel |
MKDE crashes when two different clients attempt to start Continuous Operations on the same file |
|
|
MicroKernel |
Occasional status 2 when using Continuous Ops under heavy load |
|
|
MicroKernel |
L2 cache sometimes becomes very small on Linux |
|
|
MicroKernel |
Improve notification of licensing issues |
|
|
MicroKernel |
Status 11 on trying to open Btrieve file in Japanese named directory when path is padded with spaces. |
|
|
ODBC |
Support 64-bit ODBC on Linux |
|
|
OLEDB |
OLEDB uses two licenses locally |
|
|
OLEDB |
Repeating remote connect/disconnect in an OLEDB app leaks memory |
|
|
PDAC |
Database names are not listed for PvQuery and PvTable during design time |
|
|
PDAC |
Add RAD Studio XE support for PDAC |
|
|
PDAC |
Memory leak in PDAC |
|
|
SQL |
Stored procedure out parameters crash server. |
|
|
SQL
|
"Error in expression" or incorrect results when using a table subquery and an Order by on UDF |
|
|
SQL
|
Next autoincrement value varies after delete in transaction |
|
|
SQL
|
Incorrect result from a view with duplicate view column names |
|
|
SQL
|
Alter table allows a negative number to be converted to unsigned bigint |
|
|
SQL
|
UNION with ambiguous ORDER BY crashes server |
|
|
SQL
|
ROUND function does not allow more than six (6) decimal places |
|
|
SQL
|
"Select * into ..." fails with "Constraint name is too long" |
|
|
SQL
|
Table is empty after "SELECT INTO the table" when view is involved in the FROM clause |
|
|
SQL
|
Result set contains all NULLs after calling the same SP twice |
|
|
SQL
|
Query crashes server if the same column appears in different items in the selection list along with UNION in table subquery |
|
|
SQL
|
SP returns incorrect results when a table subquery is involved in left outer join |
|
|
SQL
|
Missing record in a rowset with INNER or OUTER JOIN when fetching backwards |
|
|
SQL
|
A missing record in a rowset with INNER or OUTER JOIN and a table subquery when fetching backwards |
|
|
SQL
|
The result is reversed in the very first result set when fetching backwards from calling an SP with outer join |
|
|
SQL
|
All rowsets are reversed when fetching backwards from calling an SP with SQL_UB_ON |
|
|
SQL
|
SQL parser should not be particular about the order of column attributes in a create table statement |
|
|
SQL
|
SQLColAttribute with SQL_DESC_BASE_TABLE_NAME/SQL_DESC_TABLE_NAME returns incorrect result on mergable views |
|
|
SQL
|
SQL engine crashed when running SRDE regressions against a v2 metadata |
|
|
SQL
|
Entity Framework provider is not able to support inheritance due to incorrect result |
|
|
SQL
|
Multiple calls to a stored procedure generates General Error |
|
|
SQL
|
|
|
|
SQL
|
Query with outer join on computed fields not optimizing on index |
|
|
SQL
|
Engine eventually runs out of memory if Monitor is left running |
|
|
SQL
|
Disconnect/transaction rolled back messages and Memory Allocation errors |
|
|
SQL
|
TIMESTAMPADD returns incorrect value on leap year days |
|
|
SQL
|
SRDE crashed after selecting Monitor\delete all users |
|
|
SQL
|
Longvarchar value is retrieved using .net provider using a Stored procedure ,one character is dropped |
|
|
SQL
|
Erratic behavior for users with createview & createsp rights |
|
|
SQL
|
SQL Engine hangs/deadlock when clearing SQL connections via Monitor |
|
|
SQL
|
Possible crash in 64-bit SQL engine |
|
|
SQL
|
Engine crashed by running a stored procedure with a complex view |
|
|
SQL
|
Possible SQL engine crash on IF statement in VALUES clause |
|
|
SQL
|
|
|
|
SQL
|
Null results from stored procedures when sp cache enabled |
|
|
SQL
|
Engine crash running FULL OUTER JOIN query |
|
|
SQL
|
Running stored procedure returns less number of rows |
|
|
SQL |
SQL Engine crash on multi-level nested subquery |
|
|
SQL
|
Something is broken between "union all" and "timestampadd" |
|
|
SQL
|
Query with select top N updates all the records |
|
|
SQL
|
@@IDENTITY is not returning the value of the IDENTITY column that is the table's primary key |
|
|
SQL
|
SRDE engine not reporting error for GROUP BY on AGGREGATE function |
|
|
SQL
|
Comment with ? mark return2 "SQLBindParameter has not been called" |
|
|
SQL
|
$Relate column changed names from Xr$Pindex to Xr$Index in v9 |
|
|
SQL
|
Crash when running a SQL query in customer application |
|
|
SQL
|
Bad database name causes SQL engine to crash on 64-bit Linux |
|
|
SQL
|
|
|
|
SQL
|
Customer would like SQL to support the 4th byte of TIME data |
|
|
SQL
|
Deadlock in SQL engine when using SQLPrimaryKeys |
|
|
SQL
|
Concat does not work with some data types |
|
|
SQL
|
ALTER TABLE ADD PRIMARY KEY on a column with the same type only updates DDFs without generating a physical index |
|
|
SQL
|
CHAR, ASCII scalar functions return incorrect results |
|
|
SQL
|
Query with OR returns only results matching the first condition |
|
|
SQL
|
SQL Engine should auto-add missing system table definitions even if the ddfs exist |
|
|
SQL
|
|
|
|
SQL
|
The expression "NOT(5=3)" should return all data, but no data is returned |
|
|
SQL
|
Incorrect results with DISTINCT in VIEW with ORDER BY |
|
|
SQL
|
Stored Procedure runs slower on a static cursor than on a forward-only cursor |
|
|
SQL
|
Results from STUFF scalar function may be truncated incorrectly |
|
|
SQL
|
Create primary key fails in SP |
|
|
SQL
|
Failed to execute "insert into #t1 select * from #t1" |
|
|
SQL
|
Create SP failed if table SQ contains a table created in SP |
|
|
Utilities |
Customer requests utilities that monitor database performance |
|
|
Utilities |
Double Dashes "--" in PCC force other SQL statements to become comments. |
|
|
Utilities
|
DDFBuilder's Table check generate confusing warning |
|
|
Utilities
|
PCC's Add Rows dialog's Reset button clears everything |
|
|
Utilities
|
PSA Network Test does not work with Ipv6 addresses |
|
|
Utilities
|
The Maintenance Utility Page Size window only displays four digits |
|
|
Utilities
|
Add an option to disable the context help in SQL editor |
|
|
Utilities
|
PCC and ddfbuilder have an incorrect error if creating a DB to an invalid directory |
|
|
Utilities
|
PCC import wizard BIT data type import problem |
|
|
Utilities
|
PCC's SQL view is incorrect when using a primary key |
|
|
Utilities
|
butil -endbu failing to Linux 64 under heavy load |
|
|
Utilities
|
PCC Stored Procedure Editor returns "No such table or object" when editing proc |
|
|
Utilities
|
BMon stops monitoring on status 7008, 7010 and 7015 |
|
|
Utilities
|
Guipaadm authorization code incorrect under Win7 |
|
|
Utilities
|
New functions "stdev" and "reverse" are not syntax colored in PCC |
|
|
Utilities
|
Maintenance utility is a little slower than Butil |
|
|
Utilities
|
bcfg crashed on Linux |