This patch applies to the following Pervasive
PSQL products:
This patch applies to the following
executables:
bdulb.dll
butil.exe
com.pervasive.core.win32_1.0.0
com.pervasive.core_1.0.0
com.pervasive.open.eclipse_1.0.0
com.pervasive.psql.utilities.common_1.0.0
com.pervasive.psql.utilities.core.win32_1.0.0
com.pervasive.psql.utilities.core_1.0.0
com.pervasive.psql.utilities.dbeditors_1.0.0
com.pervasive.psql.utilities.external_1.0.0
com.pervasive.psql.utilities.javadti.win32_1.0.0
com.pervasive.psql.utilities.javadti_1.0.0
com.pervasive.psql.utilities.sqleditor_1.0.0
com.pervasive.psql.utilities.ui_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
w3cache.dll
w3comsrv.dll
w3csi100.dll
w3csm100.dll
w3csp100.dll
w3mkde.dll -----
(WINDOWS WORKGROUP ENGINE)
w3mpm100.dll
w1mif183.dll
w3mif183.dll
w1nsl251.dll
w3nsl251.dll
w3odbcci.dll
w3odbcei.dll
w3sqlmgr.dll
w3sqlmgr.exe
w3upi301.dll
w3xlt101.dll
btcpcom.nlm
brouter.nlm
mkc3.nlm
mkderb.nlm
nwcsi100.nlm
nwmkde.nlm
nwmlm100.nlm
nwmpm100.nlm
nwodbcei.nlm
nwsqlmgr.nlm
nwxlt101.nlm
Specific issues addressed in this HotFix release (Build 9.52.60) :
|
Tracking
Number |
Description |
|
56815 |
OS handles not released on files in CO |
|
56843 |
DateTime will not sort correctly with TimeStamp data in DateTime
field |
|
56867 |
Large query with UNION and ORDER BY DESC doesn't
sort properly |
|
56892 |
16-bit requester causes GPF on second using mapped
drive |
|
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 |
Previous issues addressed in this HotFix since PSQL v9.5 release :
|
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,
and is using an updateable cursor multiple times |
|
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 were not being resolved in any SELECTs
except the first if a UNION is present and aliases in subquerys
were not being resolved |
|
47506 |
SQLSetPos(SQL_ADD) is called and the row
number parameter, the second parameter, is larger than the set rowset size |
|
47528 |
Incorrect rows returned doing comparison to zero
result from mix datatypes of integer and decimal
multiplication expression |
|
47542 |
@@IDENTITY is not returned properly if the insert
was done from one statement and the select @@identity from another |
|
47548 |
An aggregate in an IF in the selection-list or
HAVING clause should be allowed but was returning an error |
|
47557 |
Order By is causing 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 don't work in DSNs |
|
54103 |
Fix failures in sqlforkey
testcases |
|
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" error |
|
54204 |
Prevent FCR key counts from going negative |
|
54205 |
Status 2 on create index with ACS |
|
54210 |
Requester needs to recognize the cluster name 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 |