                           Pervasive.SQL 2000 v7.9
                               Service Pack 3
                        History of Enhancements and Fixes
                                  February 2001
                                  HISTORY.TXT

NEW FEATURES IN SERVICE PACK 3 are documented in the "What's New" document
which is installed as part of your regular install.  Please read that
document before using your new install of Service Pack 3 so you will be
fully aware of changed behaviors.

www.pervasive.com/support/technical/product/index.html

===================================
2. FIXES IN SERVICE PACK 3
===================================

The following is a list of incidents fixed in Pervasive.SQL 2000 v7.9 Service 
Pack 3 for server and workstation products.

If you have access to the Web, visit the Pervasive Web site for the same 
information:

http://www.pervasive.com
or
http://www.pervasive.com/support/ 

MicroKernel Database Engine (MKDE)
==================================
Change 
Request#   Description
======    ======================================================================
sc954	    Get Extended operations are not optimizing on segmented keys that is 
          based on the filter. 
sc13510   Return Status 43, not 2, when GetDirect is issued on a reused page.
23583	    Files marked as "Delete Inhibit" on Netware can be overwritten by    	    Create (14) 
25094	    A disk full error could potentially cause your database engine to GPF
          if received during an async write.
27531     Gateway Redirection not working correctly if "=>..\" used in a read-
	    only locator file on Windows 95.  

28131	    Machines without CLNWIN32 will error when CALWIN32 is loaded. 
27623	    When the "Max Pages" limit has been reached status 2 will be returned,
          then when closing the file the database engine may hang.
27577	    The Key Buffer is modified with a Linked Duplicate File during a GET   	    NEXT
27625	    Status call with key # FF randomly fails to return file version info
27874	    Shares to a subdirectory and multiple shares to the same location
          could cause status 11s to be returned when accessing files through 
          the WGE locator file.
28392     Status 11 returned when opening gateway locator file that is manually
          created and not padded to expected length.  
28803	    Ability to handle local "Get Position" calls within MIF.  Added to 	 	    boost performance as handling it locally is much faster. 
	
28446	    Performance improvements for ISR string comparison

29242	    Get Next retrieves the wrong record if the key buffer has been 
          modified after an Update.
29359	    Get Direct is now invalidating parent stack
29364	    Btrieve Operation GetNext (6) failing to return the next record
29318	    Engine could hang either starting or stopping continuous operations
	    during heavy activity
30186     Long timeout when trying to connecting to a permanent gateway machine
          that is not running.  
31524     MicroKernel interface will fail if a gateway locator is pointing to 
          the root.  
31660     Engine would go to 100% CPU usage when a stop/start BU was issued 
          during certain async IO writes.  



Communications
==============
Change 
Request#   Description
======    ======================================================================
26778     16bit Btrieve interface returns active clients for the process only 
          sometimes causing clients to be left open on the server.  
27603	    Multi-threaded application fails to restart the Micro Kernel Data 	  	    Engine.
28045	    Status 94 trying to connect to local files with Workgroup Engine after           	    a connection to an NT Server Engine.
28276	    Requester returns "error 91" when server is Multi-homed.
28331     Slow performance in ODBC when running locally on a NT machine which is 
          a Primary Domain Controller. 
28403	    Repeatedly opening and quickly closing a file could eventually cause a 
          status 3119 to be returned.
28428     Bdosstub.exe would not load on Windows ME.  
29781	    BIF not checking for valid Position Block before checking key length.                     	    Returns status 21.  
30195     Using Domain user name (DOMAIN\user), DTO(and Monitor) will not 
          connect even though domain user is listed in both the Administrator 
          and Pervasive_Admin group of the NT server.  
30328     Sped up connect times by not retrying a connect a second time after 
          the first fails.  
30359     Sped up connect times by using a SAT entry from a successful
          connect on a protocol and not trying to resolve other protocols.  
30582     Made connections quicker by not waiting for a second protocol to 
          connect when another has already succeeded.  Also shortened the 
          timeout on named pipe when machine is not connected to the 
          network. 
30686     Bdosstub.exe did not release all memory when /U option was used. 


SQL Relational Engine (SRDE)
============================
Change 
Request#   Description
======    ======================================================================
20981     Stored Procedures were incorrectly recognizing small identity as an 
	    identity and returning an error
21006     Stored Procedures don't return the appropriate values when the return 	    datatype is identity 
23271     Column level security does not work correctly with Btrieve owner names 
23930     Column level security not behaving correctly  
25469     Engine would fail when trying to create a view name >=40 
26079     Added the ability to use single quotes on a numeric field in a SELECT
26208     Column level privileges not enforced correctly on RO files 
26359     Calling CURDATE within MONTHNAME returns no columns 
26631	    Stored Procedure with numeric data concatenated to string returns the 	    wrong data.
26757     Can't specify NULL on create or alter table   
27055     AS Modifier within from clause is not working correctly
27299     CREATE INDEX with more than 18 columns fails w/ illegal dup key
27383	    A syntax error is received when calling procedure using DSN.Procedure 	    Name
27383     Stored Procedure call statement did not support DBQ.storedprocname
27619     AS keyword returns an error when used for creating column alias 
27650     Insert with a subquery that involves a DB name fails w/syntax error
27875     SRDE should not attempt to optimize on a manual Null key when it 	    	    encounters one 
28026     Updating a longvarbinary to a NULL would cause the engine to fail  
28050	    Performance issue when performing "Select" queries on large databases 	    with the use of "LIKE".
28331	    Performance problem with local databases on NT Primary Domain    	  	    Controllers
28332     Ordering by a utinyint returned incorrect results  
28353	    Incorrect results are being returned when using "ORDER BY DESCENDING"
28426	    Problems reading correct results from a legacy NOTE datatype  
28681     Table is corrupted after altering a table by adding a column to a 
          legacy table that contains a NOTE/LVAR column
28774     Alter table by adding a column with a constraint that uses the same 
	    constraint name as the other column fails with 'Illegal duplicate 
          key'
28778     Drop constraint does not delete the name of the constraint from 
	    x$field.ddf
28821     Alter table by dropping a primary key column is very slow to return 
	    failure 
29055	    Out of memory errors are received with extremely large result sets 
29244     Stored Procedure formatted where it could optionally have included a 
          NOT clause could cause NetWare to abend.  
29585	    SUM function with "GROUP BY" on two fields does not SUM correctly
29705     Memory Allocation Error on conditional INSERT stmt in the form of:
          insert into aa(c1) select c2 from bb where c2 =1 and c2 not in(select
          c4 from cc) 
29750	    When performing a SQL Select w/ Varchar Data types using If, and 	 	    concat an ODBC error occurs.
29896     Error would be returned when two columns tried to reference the same 
          ACS 
29979     Trying to insert a BLOB >64KB could cause a connection failure  
30044     Inconsistent results returned based on some subqueries used with a 
	    UNION
30047     Engine could fail if using a column name that was the same as the 
	    table name 
30172     Trying to create a very large view which should return an error would
          cause the engine to crash  
30193     SRDE improvements for optimization multiple table joins  
30243     Optimizing on a Cartesian join caused and assignment error to be 
          returned from incorrect references to indexes across temporary tables
          used for the optimization  
30244     Executing a VB6 RDO program hundreds of times in a row which uses
          triggers can causes a Memory Allocation Error 
30272     Mixing some numeric datatypes as operands in the IF function, could 
	    cause the result to be promoted to the incorrect datatype 
30466     LIKE returned incorrect results with segmented key referencing the
          same ACS on legacy datatype   
30825     Negative numericsa value displayed as a positive number 
30918     If binding more than 255 bytes to a varchar engine should return  
	    success with info.  
31156     Not treating double quotes correctly for all strings/values in SQL
          statements.  
31240     Running an application with the UNC method, the requester drops the 
          first letter of the path and the status 11 is returned.
31267     Rounding problems when converting some values for printf in stored
          procedures.  
31426     Nested OR or AND in a trigger could cause engine to GPF. 
31481     Select on a table with an unsigned tinyint as the primary key will 
          return an error.  
31514     Should accept anything non-zero for BIT columns as Boolean true or 1.  
31732     RI would get out of sync if child table was dropped and then recreated
31585     Engine very slow connecting to a large database with a lot of tables
          under the same name.  
31767     Single quotes around an unsigned integer would cause an error 
31851     #Delete in MS Access 2000 with all char fields with over 200 
          characters of data - OK with Access 97   
31848     Status 7 opening legacy DB w/ security and table privileges



Distributed Tuning Interface (DTI)
==================================
Change 
Request#   Description
======    ======================================================================


Pervasive Control Center (PCC) & SQL Data Manager (SQLDM)
=========================================================
Change 
Request#   Description
======    ======================================================================
20213     Adding and removing columns over and over in the add database wizard
          could cause a GPF in the wizard and also could cause some columns to
          not be correctly inserted into the table.
20388     SQL statements with a space between the last character and the end of
          line indicator would cause SQLDM to skip the next line.   
22844     Precision of some datatypes is not correctly shown in Table 
          Information Manager.
22911     Cannot stop statement execution if machine runs out of memory 
          reading and caching statement.
23009     Hitting ENTER while editing new table information in the grid 
          causes the wizard to move to the next screen rather than the next 
          field in the grid.  
23018     Inconsistent results when entering characters in the middle of an 
          existing data field when using the SQLDM grid.
24232     SQL statement erased if you hit cancel from the save/browse file name
          window.
24331     PCC was allowing you to register a server name with more than 15
          characters, but it was chopping off the characters over 15.  
24380     Add ability to view RI constraints on a database to properties. BIT columns showing as unknown in Table Information Manager.
24754     Check database fails if the table has a segmented index on an 
          autoinc field.
25135     Clicking on an empty row and then hitting the delete button would 
          cause the Create Table wizard to fail.
25497     Display problem with char fields in SQLDM.  Last character would be
          cut off, but column display could be resized and display would be
    correct.
25526     Changing the statement separator to ";" would not take effect in 
          PCC until the tool was stopped and restarted.  
25572     Query builder tool did not correctly format INSERT statements.
25806     Adding and removing relations between tables over and over could cause
          the wizard to fail.
26835     Check DB was failing is there was a CHAR of 254 nullable field.  
27025     After one bad index definition was found running Check DB, all 
          subsequent index tests would fail.
27240     Adding and removing data file and dictionary locations in the DBNames
          config could potentially mess up other DBNames.cfg.  
27264     If an index is set on a Btrieve LOGICAL_TYPE Check DB wizard would
          return inconsistency errors.
27425     Create Table wizard does not build SQL statements using the same
          Long Servernames in Novell Networks are being truncated and connect
          Fails.  
30308     If the file location is set to an invalid file the statistics window
          appears blank and you cannot use that method to correct the incorrect
          value.
30317     Changing the name of a column that has an index assigned to it would 
          fail.
30476     Indexes are always created in descending order when using the create
           table wizard.
30665     If you save a query to a file, then open a different file and re-save
          it, the save will incorrectly be under the first name and it will 
          overwrites your original queries. 
31387     When sniffing an existing Btrieve file to create a table the wizard
          correctly creates the file, but the SQL script displayed in the 
          wizard was sometimes missing the last field.

 


Monitor Utility
===============
Change 
Request#   Description
======    ======================================================================
24879     If files of greater than 253 characters are open monitor could GPF 
          when requesting active files or active users screens.  
27988     User name with repeated first letter display wrong in monitor.



Gateway Locator Utility
========================
Change 
Request#   Description
======    ======================================================================
27821     Problem setting up locator file pointing to remote data access for a 
	    local engine when the mapping from the client station is different.  

Butil 
=================
Change 
Request#   Description
======    ======================================================================

26460	     Butil -save, Butil -recover, the /j option is not working.
31671      Butil -create to the NetWare root volume would fail with a status 11.



******************************* END OF HISTORY.TXT *****************************
