# GUPTA SQLBase 8.5.00 - Program Temporary Fixes (PTFs)

# List of Defects Fixed

Program Temporary Fixes (PTFs) offer quick resolution to specific known problems in a given release. Therefore, PTFs do not go through the same extensive quality assurance and field testing as do Maintenance Releases or Major Product Releases.

This document contains a list of known bugs present in SQLBase Version 8.5.0 and for which verified fixes have since been made in the base version. Since PTFs are cumulative, those fixes listed in a given PTF are available only in combination with all fixes listed for earlier PTFs.

## PTF4 (Build 13493)

Defect ID | Description
65491 | Using ROWID in the WHERE clause of a view definition causes SQLBase to crash.
78307 | Updating date/time column using bind updates with null value.
78951 | When using NLS Comparison, a specific query returns 4 rows in Windows while it only returns 2 rows in NetWare, possibly due to the way the strings are compared in Netware.
79600 | A statement using an EXISTS clause takes much longer in SQLBase Version 8.5 than in 7.6.1.
79715 | When doing a straight select without ANSI99 syntax, data is returned quickly. When using an inner join sequence, the data is returned very slowly.
79887 | @SCAN() function returns wrong results with long strings.
79933 | No rows returned in a query when an ORDER BY clause is inserted.
79997 | Difference in results when using ROWID in an IN clause.
80077 | SQLBase crashes without writing either a fail.sql or process activity log entry when doing a particular UPDATE.
80173 | UNION behaves differently from UNION ALL in some circumstances.
80207 | Performance problem running a query that has been made a view.
80233 | SQLBase returns rows when a LIKE clause is used on the null column.
80268 | Wrong data in results for JOINS(combination of IJ,LOJ and ROJ) made of 4 or more tables after creation of unique index.
80318 | SQLBase stops responding to clients after 1801 error.
80323 | sql.ini SERVERPATH keyword has a limit of 255 characters
80731 | When @NULLVALUE(aaa,0) is used with NOT IN, the wrong result set is returned.
80778 | Autoconversion problem. Certain query crashes SQLBase.
80815 | SQLBase crashes with 00732 VIO MZU. Page being modified has a zero use count.
80817 | A select with DISTINCT and a NULL column returns all NULL Values.
80872 | Getting an error 00504 WSP CRP - Cannot relocate pointer when trying to drop a view.
80968 | "00702 Fatal SQLBase System Failure (VIO PNO)" occurs in a test which uses 10 or more concurrent clients.
81189 | When database name length is 16 characters, unable to connect when sql.ini is configured for client specifying the database name.
81557 | Performance issue in selects with the NOT IN clause.
81670 | Conditional operators are not working with bind variables that contain negative values fetched from tables.
81794 | Partitioned database no longer reachable after unloading old database and creating a new database. Error message appeared before losing database: "10724 - PFS MDC Incorrect extent table entries in the main database"
82066 | SQLBase server hangs sometimes when executing a join between a table and a view containing large amount of data.
82097 | TD 3.1.0 SQLBase API sqlfgt() version 8.5 error 1307 against older SQLBase pre-8.0
82136 | Apparent autoconversion problem. An unload of a 8.5 database that was autoconverted from 7.5.1 fails to load back under 8.5.
82165 | Performance problem running a query that has been made from a view which in turn is made of tables and views.

## PTF3 (Build 13492)

Defect ID | Description
79264 | Inappropriate 849 error message with IN operator.
79598 | A SELECT query may crash the server when using large IN clauses.
79791 | With a particular query, if the cache is set to 57373, 2,423 rows are returned. If the cache is set to 57374, no rows are returned.
79828 | The attached sql script crashes the SQLBase Server (no fail.sql). The error is reproducible with versions 7.6.1 and 8.5.
79908 | With ANSI Joins,when using USING clause,if we give the column name prefixed with NON-EXISTing table name or alias name, no error thrown.
79914 | Under similiar circumstances to defect 79961, the SQLBase server crashes without any fail.sql entry.
79923 | With 8.5 PTF1 and PTF2 (5 Users),Backup snapshot with a database size of approximately more than 500 MB gives 3208 error.
79961 | The SQLBase server crashes without any fail.sql entry.
79971 | Selects with subselects on the same table return wrong values in some cases.
80014 | Wrong result in two queries out of 6 in a particular script.
80044 | SELECT and DELETE do not work the same way with identical WHERE conditions involving a subselect.
80089 | A particular query with DISTINCT and IN clause hangs the Netware database engine. With Windows the same query works fine.
80108 | Data corruption - Error 839 ROW CNL
80123 | Performance problems with multiple UNION statements. CPU usage goes to 100%.
80206 | HAVING clause on a column which has nulls yields wrong results.
80216 | Data missing for RIGHT OUTER JOIN on views made of more than 4 tables with GROUP BY and HAVING clause.
80217 | Incorrect number of rows for LOJ made of more than 4 tables with GROUP BY and HAVING clause after creation of unique index.
80291 | After creation of unique index, incorrect count of rows are returned for queries with multiple outer joins.

## PTF2 (Build 13491)

Defect ID | Description
79264 | Inappropriate 849 error with IN operator.
79454 | A LEFT OUTER JOIN doesn't use an index and is taking a very long time.
79696 | Database Engine will crash when we do a SELECT after dropping all the columns in the table.
79714 | The results of executing a SELECT using a view returns a different result set than when executing the plain SELECT.
79731 | Executing a simple query on a view causes server crash when a SQLBase 761 database is autoconverted to SQLBase 8.5
79732 | Selecting from a view returns 476 rows. Selecting from the same view but ordering the data returns 4 rows.
79779 | Creation of view with NATURAL JOIN crashes DBEngine.
79781 | Views created with more than 2 table ANSI JOINS and GROUP BY returns 0 Records.
79782 | Select on views created with more than 4 table ANSI RIGHT OUTER JOIN and GROUP BY crashes the DBEngine.
79783 | DBEngine crashes for any query after a particular NATURAL JOIN query.
79845 | When a PREPAREd query contains ORDER BYand if EXECUTE and FETCH is in loop, then in the resultsets, for any column, if we encounter a null value in fetch, then the consecutive EXECUTE and FETCH results in NULL even when column has NON-NULL value.
79850 | After applying PTF1, starting the Netware n-user server causes error message "dbnwsrv.bin is not in the same path as dbnwsrv.nlm"
79869 | When using INSERT INTO clause with multiple table IJ/LOJ/ROJ ANSI JOIN Selects, for some instances correct number of records are not inserted and for some instances data got inserted with values missing in some of the columns.

## PTF1 (Build 13490)

Defect ID | Description
64269 | Error messages should be given when invalid values of all Keywords, such as centuradefaultmode, character set, cmdtimeout, commit server, users, workalloc, and work limit, are entered in Server Configuration - Advanced menu.
69009 | Correlated update (using sub-Selects) fails when using bind variables; works fine when using literals.
69347 | Serious Performance problem when using complex queries with views.
73581 | A store of a procedure produces error 09913 PRS MLD Missing line delimiter when run as part of a load script, but works fine as a command within SQLTalk.
74165 | Either the server or SQLTalk comes down or incorrect results are returned when doing an aggregate select with a 'having' clause.
74856 | Referential Integrity: Before Update Trigger using NUMBER Null causes error 00382 EXE UFV Unmatched foreign key values on a valid update.
78034 | Creating a foreign key having columns that can have NULL value using ALTER TABLE command generates an error 388. The same can be created using CREATE TABLE command without any problem.
78129 | A particular query with an aggregate returns incorrect results.
78872 | Join between 2 views, which are created using either ANSI syntax or with Native syntax for a particular query are taking high CPU usage and takes high processing time compared to SQL Server and Oracle.
78972 | The query with @coalesce (col1, col2) = ""IS NOT NULL"" in the WHERE clause is returning incorrect records.
78975 | A certain query with multiple LOJ sometimes returns incorrect output for the data in the last columns.
79060 | SELECT with a WHERE clause from a View, which has been created using ANSI left outer joins returns incorrect number of records.
79085 | A particular query with views and EXISTS clause is taking high CPU usage and taking 12 hrs to return correct records.
79414 | Attempt to make concurrent connections with local and remote databases gives the error - error 00184(invalid server name).
79565 | Connectivity Administrator does not allow entry of hyphen (-) character as part of the Client name.

Copyright © Gupta Technologies LLC. GUPTA, the GUPTA logo, Centura, and all GUPTA products are licensed or registered trademarks of Gupta Technologies, LLC., All other products are trademarks or registered trademarks of their respective owners. Copyright © 2001-2005 Gupta Technologies