This patch applies to the following Pervasive
PSQL products:
This patch applies to the following
executables:
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
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
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
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 |
You may
obtain technical support from the following Web-based support options:
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. |
*** END
OF README ***