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.036) :
|
Tracking Number
|
Description
|
|---|---|
| 57136 | Out of cache error with large temp table |
| 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 | Relataional engine creashes executing DTS package in MS SQLserver |
| 57411 | Memory leak in MIF |
| 57424 | Cache engine hang due to page invalidation error |
| 57431 | Failure of IOCTL call causing 4GB segments to be created |
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 |
| 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 |
| 57137 | Increase size of the SRDE internal temp file to 4 GB |
| 57313 | Pvcopydatabase fails when remote share is at the share level |
| 57154 | Support table index hint with stored procedures and user defined functions |
| 57140 | PSQL engine hangs due bad tempdb install |
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. 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 ***