Pervasive SQL9 SP2 PostFix .

[Dimerson]

********************************************************************
DISCLAIMER

Pervasive Software Inc provides this software AS IS.

Pervasive Software Inc. makes no representations or warranties
with respect to its software, and specifically disclaims any
express or implied warranties of merchantability, title, or
fitness for a particular purpose.

Distribution of any Pervasive Software Inc software is forbidden
without the express written consent of Pervasive Software Inc.
Further, Pervasive Software reserves the right to discontinue
distribution of any Pervasive Software software.

Pervasive Software is not responsible for lost profits or revenue,
loss of use of the software, loss of data, costs of re-creating lost
data, the cost of any substitute equipment or program, or claims by
any party other than you. Pervasive Software strongly recommends
a backup be made before any software is installed. Technical
support for this software may be provided at the discretion of
Pervasive Software.
*******************************************************************


1. Pervasive.SQL SRDE version 9.50 (SP2) FTF
Released 04/09/2007
Build 9.52.023
Pervasive.SQL MKDE version V9 SP2 (V9.50) FTF
Released: 02/12/2007
Build: 9.51.034 - MKDE


2. Components included in this FTF are listed below:

Netware Engines
NWODBCEI.NLM 2,935 Kbytes 04/09/2007
NWMPM100.NLM 331 Kbytes 04/09/2007
NWSQLMGR.NLM 1,399 Kbytes 04/09/2007
MKC3.NLM 250 Kbytes 04/09/2007
NWXLT101.NLM 969 Kbytes 04/09/2007
NWCSI100.NLM 747 Kbytes 04/09/2007
NWMKDE.NLM 948 KBytes 02/12/2007
MKDERB.NLM 211 KBytes 02/12/2007


3. Test Environment:
This engine was tested with the Pervasive.SQL version 9 SP2 (9.50).

Tests:
MKDE Regression
SRDE Regression
Customer Reported test cases


4. Special Instructions for this FTF:


NetWare Server

1. All users must disconnect from the Pervasive.SQL Database
Server.
2. From the NetWare console, enter "MGRSTOP". When it successfully
unloads, enter "BSTOP".
3. NOTE: If you performed your initial product installation
with default settings, please run the
statements below. However, if you customized the
installation directory, please change "SYS" to indicate
your custom install location on the workstation.
Please ensure:
- you have the rights to "write" to SYS:Volume
- the files being replaced are NOT flagged "read-only".\

Copy NWODBCEI.NLM SYS:\ODBC\DRIVER
Copy NWCSI100.NLM SYS:\SYSTEM
Copy NWSQLMGR.NLM SYS:\SYSTEM
Copy NWXLT101.NLM SYS:\SYSTEM
Copy NWMPM100.NLM SYS:\SYSTEM
Copy MKC3.NLM SYS:\SYSTEM
Copy NWMKDE.NLM SYS:\SYSTEM
Copy MKDERB.NLM SYS:\SYSTEM


4. Bring down the NetWare server and restart to unload
BTRIEVE.NLM. This is because various NetWare components, such
as CSL.NLM, have dependencies on it.
5. Unless you have Pervasive.SQL auto-starting when
NetWare loads, you will need to enter "MGRSTART" from
the console.




5. Specific SRDE issues addressed in this FTF release are:

------------------------------------------------------------------------
Ref Abstract
----- ----------------------------------------------------------------

54421 Engine crashed when DDFB creates table definition for existing
Btrieve file
54719 Select with ANY or ALL, crashes the engine
54749 When a REPLACE command is used on a Japanese character it behaves
incorrectly
54762 Syntax error if parameter name is named in Japanese in stored
procedure
54875 UPPER string function is behaving incorrectly with double-byte
characters in V9
54896 SQLBindParameter sql_output_param crash engine if value length
of SQL_NTS is -3
54915 Customer gets java.io.EOFException when running a Select Replace
statement
54919 REPLACE comparisons in WHERE clauses not working if LONGVARCHAR
is involved
54920 Building strings with '+' fails; Concat() works
54940 Engine crashed running metadata.xml
54944 Setting ASYNCENABLE=0 causes query to fail
54945 Crystal Reports crashes running report with Asynchronous Queries
enabled
54954 Engine crashed running SSP.xml
54961 Engine crashed when running a filter on a certain table in
Insight 5.4
54980 1-byte memory overrun in CI/SQLMGR with inputoutput parameter
54988 Engine crashes on insert to table with LONGVARCHAR with default
55005 Truncated results with string functions on V9
55008 Disable btrieve writes on file with triggers
55019 Engine crashed on query with OptimizeInnerJoin=YES
55025 Open on NetWare using URI with table= or dbfile= gets Status 171



6. All SRDE issues addressed since the Pervasive.SQL 9 SP2 (9.50) release:

------------------------------------------------------------------------
Ref Abstract
----- ----------------------------------------------------------------

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
53948 Invalid Date/Time/Timestamp data type exception with ADO.NET
provider
54051 No such table or object using legacy DDF's on NetWare or Linux
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)
53912 IN clause fails to return rows under certain conditions
54009 Error "Buffer too small, data truncated" when doing select.
54054 Data truncated error using LIKE parameter
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
54123 Adding columns using OLEDB returns 0
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
54121 ALTER TABLE DROP BIT column corrupts data
54198 IF with two conditions in FUNCTION produces GENERAL ERROR
54206 Crash in mkded when both SQL and Btrieve access
54207 Union of left and right outer joins with orderby clause is
producing crash
54208 Subquery with an Order By is crahing the engine using Static
cursor
54222 VIEW with a UNION of two tables is returning incorrect results
querying the view
54227 NOT NULL entry was added for legacy table with ALTER TABLE
statement
54230 Fetch doesn't stop when data no longer matches restriction
54245 Status 22 on alter table drop column
54247 Running Select query with UNION using Dynamic cursor is
returning status "Null is not valid" error
54109 Top clause does not work in vbSqltester with UseServer/Static/Grid
54263 Pervasive v9 OLEDB provider in complex join leaves nulls on field
defined as a VARCHAR
54266 Insert into a binary column with a null terminated binary byte
string fails with bind parameter
54267 Insert into a guid column with the same binary data return
incorrect result
54269 Unknown error using BETWEEN clause
54278 Incorrect result with correlated subquery that contains a TOP
clause
54279 Query with aggregate in restriction crashes engine
54284 Update with subquery gets 84 if one of the record is locked by
other user
54316 Access displays #Deleted for table with NumericSA column
54324 SQL error in view when using ORDER BY clause
54325 Query crashed when ansi_padding is set to off
54241 When you click "Edit" on this 706 field table, the fields are
out of order, and the data is truncated.
54323 Error in Assignment caused by mis-matched decimal separator
settings
54343 Performance problem when DDF's file version are version 6 and
older
54344 Select with multiple OR conditions returns incomplete results
54376 delete that have a IN clause will only delete 1 record when
the tables have RI
54392 Query with IN list and GUID type returned "Error in assignment"
54393 INSERT with SELECT does not insert default unique guid value
54396 Status 3 returned when OLEBD through ADODB closes
54386 Access to databases on Linux server fails with status 7004
54424 Linux engine crashes when updating records through ADO
51854 Additional JCL failures in Linux server cause by XLT
54233 PCC fails to show table properties when database names and data
paths combined are more than about 24 Japanese letters
54465 The Monitor shows an excessive and growing number of sessions
that can't be terminated
54471 SQL query returns zero records when many should be returned
54472 CREATE INDEX IN DICTIONARY does not update link-dups/
repeating-dups/key-null flags in index.ddf
54479 Record is inserted via SQL even though record is not totally
defined
54497 Add a registry entry disableStepNextExtFilter in MKC to
disable STEP NEXT EXT
54500 Views not displayed alphabetically in PCC
54514 Server crashed during disconnect
54442 Aborting ALTER TABLE locks down DDFs on NetWare
54473 EXISTS with DROP/CREATE VIEW does not work correctly in SP
54536 Convert (id, sql_char) returns error in expression
54551 Engine is taking one extra license with PvStart and
PVOpendatabase calls
54556 Error in Expression returned when executing UDF multiple times
54563 Pervasive serivces are hanging, possibly becuase of uncompleted
sql queries
54594 Unexpected behavior using MS SQL Linked server with P.SQL V9.5
54595 Multiple 'ntdbsmgr.exe abnormal program termination' errors
54514 Server crashed during disconnect due to freed Stored Procedure handle
54598 Query with long alias name crashed the engine
54604 Select query on cobol tables dont return expected rows
54607 The OUT values in a Char and Varchar fields in a stored procedure
are padded with binary zeros instead of spaces
54665 W3DBSMGR.EXE crashes on records with BLOB fields
54669 Select Top 1 clause is not returning row when prepared and
executed repeatedly
54654 Running subquery with group By causes "currency not on record" error
54688 Certain sql query run slower compare to V8
54689 Query with subqueries in CASE expression returns an error
54690 Prepared update doesn't update all records
54693 ROUND scalar function is generating DOUBLE type column
54707 Query not returning correct rows on Varchar with trailing spaces
54715 Possible corrupted on uninitialized local variables
54725 Accessing 7x View.ddf causes 9.5x to crash
54474 20 character long table name is causing "Table not found" error
on an Open
54684 Select from view with й in column names returns error in expression
54706 Status 5 on alter table with null-Any segment Btrieve keys
54735 Replication engine crash with Variable Length Data & replication
54736 UPDATE trigger doesn't work correctly with multiple columns updates
54737 Invalid cursor position - no keyset defined when BLOB column
appears in SELECT list
54740 "S1104 Invalid Precision Value" error seen from RDO program
54780 SQL Extended Fetch is overwriting 19 bytes when only 5bytes
should be being returned
54825 DATEADD function fails with "expression evaluation error"
54827 SQL returns "Currency not on a record" error against V9 SP2
but working using V9 SP1
54828 String Date Format allowed for the CONVERT scalar function
does not conform to ODBC standards
54829 SQLRowCount does not working



6. Specific MKDE issues addressed in this FTF release :

CR # Description
----- --------------

54709 Unexpected status 139 on End Transaction during Roll Forward
54730 Reduce chances of large index rebuild hang



7. All MKDE issues addressed since the Pervasive.SQL V9 SP1 release:

CR # Description
----- --------------

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)

********* END OF README **********

[Boris Morozov]

И в рассылке нету? Откуда это?

[Dimerson]

И в рассылке нету? Откуда это?

Это FTF - http://rapidshare.com/files/28296148/9. ... e.zip.html

[Boris Morozov]

У меня все вроде и так работает, SQL не волнует.
Единственный вопрос по ихнему DDF Builder. В упор не запускается, ругается на какой-то Illegal pattern character 'M'. Пока влом разбираться, устраивает старый заслуженный 96 года.