12/1/2007 HOT FIX RELEASE FOR PERVASIVE.SQL V9.50 ***********************************IMPORTANT*************************************** THIS HOT FIX IS FOR PERVASIVE.SQL WINDOWS/NETWARE SERVER OR WORKGROUP ENGINE V9.50. *********************************************************************************** EXECUTABLE NAME: PSQLHotFixSetup.exe (Build 9.52.51.0) This Hot Fix is for Windows environments where there is an existing install of --- Pervasive.SQL V9.50 Windows Server Engine --- Pervasive.SQL V9.50 Windows Workgroup Engine --- Pervasive.SQL V9.50 Windows Clients PSQLHotFixSetup-NW.exe (Build 9.52.50.0) This Hot Fix is for NetWare environments where there is an existing install of --- Pervasive.SQL V9.50 NetWare Server Engine WINDOWS COMPONENTS UPDATED: bdulb.dll butil.exe 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 PCC COMPONENTS UPDATED: \plugins\com.pervasive.core.win32_1.0.0 \plugins\com.pervasive.core_1.0.0 \plugins\com.pervasive.open.eclipse_1.0.0 \plugins\com.pervasive.psql.utilities.common_1.0.0 \plugins\com.pervasive.psql.utilities.core.win32_1.0.0 \plugins\com.pervasive.psql.utilities.core_1.0.0 \plugins\com.pervasive.psql.utilities.dbeditors_1.0.0 \plugins\com.pervasive.psql.utilities.external_1.0.0 \plugins\com.pervasive.psql.utilities.javadti.win32_1.0.0 \plugins\com.pervasive.psql.utilities.javadti_1.0.0 \plugins\com.pervasive.psql.utilities.sqleditor_1.0.0 \plugins\com.pervasive.psql.utilities.ui_1.0.0 \plugins\com.pervasive.ui_1.0.0 NETWARE COMPONENTS UPDATED: btcpcom.nlm brouter.nlm mkc3.nlm mkderb.nlm nwcsi100.nlm nwmkde.nlm nwmlm100.nlm nwmpm100.nlm nwodbcei.nlm nwsqlmgr.nlm nwxlt101.nlm LIST OF CHANGE REQUESTS IN THIS HOT FIX: MKDE ************** 54096 SUBST drives don't work in DSNs 54117 For very large data files index building may be very slow 54139 6.x files updated by 8 or newer engine incompatible with Btrieve 6.10 54151 User displayed in Monitor after BackupAgent has run 54106 Local server's Japanese machine name is garbled on Monitor utility 54204 Prevent FCR key counts from going negative 54205 Status 2 on create index with ACS 54605 CR 53932 caused hang when DRM & CSI connect to local engine with same Process ID (internal Test) 54709 Unexpected status 139 on End Transaction during Roll Forward 54730 Reduce chances of large index rebuild hang 54962 Compression overrun cause engine to crash 55497 Token handle leak in MKDE with Continuous Operations 55700 Crash was in w3xlt101 when calling pvCloseDatabase 55800 Very large insert hangs engine 55978 When running with L2 off too many pages getting periodically purged from L1 56172 Archive logging does not work for Japanese named Btrieve files 56252 Engine crash with contops under stress 56003 Under certain conditions Insert with an auto-inc field may hang 56349 Japanese file names in a Roll forward dump file are garbled SRDE ************** 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 When performing a comparison to zero on a multiplication expression where the result of the multiplication is zero, incorrect rows would be returned if the datatypes being used in the multiplication were a mix of decimal and integer 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 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. 54051 No such table or object using legacy DDF's on NetWare or Linux 54054 Data truncated error using LIKE parameter 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 54103 Fix failures in sqlforkey testcases 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 54123 Adding columns using OLEDB returns 0 54132 Insert Loop in Stored Procedure Stops Early 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" erroreing optimizing on an index segment that was not the first segment and optimization involved an OR connected condition was causing a fatal error 54749 When certain strings are used in a scalar string function it behaves incorrectly 55343 Calling a recursive SP always returns an error 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 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 56132 Incorporate the ability to have ANSI_PADDING turned OFF as a default 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 56186 DDFs left open after table= URI used to access table under RI control 56191 Incompatible types in Expression with SP & Date parameter 56220 Certain queries with AND/OR combination in the restriction can cause a crash in ntdbsmgr.exe 56222 VB/ODBC application gets a multi-step error when the legacy null date value is returned 56243 Grant login with empty password does not put user in group 56248 LEFT function not working correctly 56254 Query slow, not optimizing correctly 56262 Random crash with VARCHAR column in comparison routine 56273 Engine crashes when running stored procedures with data type/length mismatch with output parameters 56281 Can't insert into a table with default handle in a stored procedure 56285 Expression Evaluation Error when using IfNull in TimeStampDiff 56322 SELECT INTO #temptable crashed after Timeout 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 56376 Select MIN with LIKE restriction returns incorrect results 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, UNION and empty string returns status 29 56439 Pauses and hang on v9 SP2 due to excessive temp files and DDF files handles 56440 Unable to make new Sql connections via odbc on Linux W3COM ************** 54953 Crash in w3comsrv after successful AutoReconnect W3UPI ************** 54648 Cache Engine not found by PvGetEngineInformation call on Vista 55810 Setting Use Local Engine to Off causes PSQL services to not start 56114 Status 7025 opening more than 100 sessions using DTI OLEDB ************** 53423 GUID DataType is giving error when used with Pervasive OLEDB Provider 54118 Seek on UBigInt doesn't work with V9 SP2 54474 20 character long table name is causing "Table not found" error on an Open 55033 Getting error on some tables "requested conversion not supported" using .Net 55434 German umlauts [öäü]) could not be search with a „LIKE“ statement 55851 ADO with OLEDB and Auto Translate=True crashes on Vista MIF ************** 54045 Local Btrieve API access to a WGE does not work if KeyBuffer is not Null-terminated 54056 Certain sequence of bytes in Keybuffer on Open command to local WGE causes hang 54128 BUTIL -STAT displays Japanese named extension file names as garbage 54210 Requester needs to recognize the clustername as local 54274 Getting status 3106 using URI's after a LOGIN 54491 GPF in MIF when doing B_STAT with keybuflen=0 54551 Engine is taking one extra license with PvStart and PVOpendatabase calls 54644 Abort/End Transaction not sent after network error on another session 54651 Status 20 on Abort_Transaction to 7.00 PSQL server from WGE 55506 Status 11 to local engine after connecting to 32nd remote server 56175 MIF hang when quoted path contains a null 56178 Delay on B_Open if network not connected 56313 Rolling forward Japanese named files by drive letter does not work 56342 When rolling forward, if you specify create a dump file, status 62 results JDBC ************** 55334 JDBC driver is adding one hour to the time stored in the database on a UTC function call 56277 Fix for threads not terminating when connecting to remote server 56385 Fix for resource leak when prepareStatement() fails PCC ************** 54046 Selecting a database in PCC and opening a SQL statement should default to the selected database 54091 Deleting a database while NOT logged in fails to delete the Engine DSN on Linux 54232 PCC runs the wrong SQL 54331 Allow user to set blank password 54334 Cannot connect to remote databases using PCC if not using the default port of 1583 55716 Status 7003 in PCC\Database Properties when long data paths defined 54729 DDF's remain open by a client 13x when table properties are viewed in PCC 54763 Timestamp data not displaying correctly in PCC BTCPCOM ************** 55437 Performance slowdown on NW with TCP when client uses client engine & SQL BTCROUTER ************** 54696 Transaction logging logs incorrect key number 55050 Brouter returns status 12 connecting to remote servers