2005-12-23 16:39:11 +01:00
|
|
|
********************************************************************************
|
|
|
|
|
LIST OF KNOWN INCOMPATIBILITIES
|
2013-04-13 09:09:21 +02:00
|
|
|
between versions 2.x and 3.0
|
2005-12-23 16:39:11 +01:00
|
|
|
********************************************************************************
|
|
|
|
|
|
2013-04-13 09:09:21 +02:00
|
|
|
This document describes all the changes that make v3.0 incompatible in any way
|
2009-01-29 13:53:59 +01:00
|
|
|
as compared with the previous releases and hence could affect your databases and
|
2005-12-23 16:39:11 +01:00
|
|
|
applications.
|
|
|
|
|
|
|
|
|
|
Please read the below descriptions carefully before upgrading your software to
|
|
|
|
|
the new Firebird version.
|
|
|
|
|
|
|
|
|
|
INSTALLATION/CONFIGURATION
|
|
|
|
|
--------------------------
|
|
|
|
|
|
2013-04-13 09:09:21 +02:00
|
|
|
* Priorly deprecated parameters CompleteBooleanEvaluation, OldColumnNaming and
|
|
|
|
|
OldSetClauseSemantics of firebird.conf are not supported anymore and have been removed.
|
|
|
|
|
|
|
|
|
|
* Parameters UsePriorityScheduler, PrioritySwitchDelay, PriorityBoost, LegacyHash,
|
|
|
|
|
LockGrantOrder of firebird.conf have no use anymore and therefore were removed.
|
2009-04-08 04:14:03 +02:00
|
|
|
|
2005-12-27 11:57:39 +01:00
|
|
|
SQL SYNTAX
|
|
|
|
|
--------------------------
|
|
|
|
|
|
|
|
|
|
* A number of new reserved keywords are introduced. The full list is available
|
|
|
|
|
here: /doc/sql.extentions/README.keywords. Please ensure your DSQL
|
|
|
|
|
statements and procedure/trigger sources don't contain those keywords as
|
|
|
|
|
identifiers. Otherwise, you'll need to either use them quoted (in Dialect 3
|
|
|
|
|
only) or rename them.
|
|
|
|
|
|
2013-04-13 09:09:21 +02:00
|
|
|
* Improperly mixed explicit and implicit joins are not supported anymore, as per
|
|
|
|
|
the SQL specification. It also means that in the explicit A JOIN B ON <condition>,
|
|
|
|
|
the condition is not allowed to reference any stream except A and B.
|
|
|
|
|
See ticket CORE-2812 in the Firebird tracker for more details.
|
|
|
|
|
|
2005-12-23 16:39:11 +01:00
|
|
|
SQL EXECUTION RESULTS
|
|
|
|
|
--------------------------
|
|
|
|
|
|
2013-04-13 09:09:21 +02:00
|
|
|
* [to be written]
|
2005-12-23 16:39:11 +01:00
|
|
|
|
2009-01-29 13:53:59 +01:00
|
|
|
UTILITIES
|
2005-12-23 16:39:11 +01:00
|
|
|
--------------------------
|
|
|
|
|
|
2013-04-13 09:09:21 +02:00
|
|
|
* [to be written]
|
2005-12-28 07:06:24 +01:00
|
|
|
|
|
|
|
|
API
|
|
|
|
|
--------------------------
|
|
|
|
|
|
2013-04-13 09:09:21 +02:00
|
|
|
* [to be written]
|
2009-01-29 16:44:11 +01:00
|
|
|
|
|
|
|
|
SECURITY
|
|
|
|
|
--------------------------
|
|
|
|
|
|
2013-04-13 09:09:21 +02:00
|
|
|
* [to be written]
|
