Added some Alpha 3 changes
**************
* v2.0 Alpha 3
**************
* DDL improvement
Allow to create foreign key constraints without need to get exclusive lock
on whole database
Contributor(s):
Vlad Horsun
* Fixed unregistered bug
Fix 'partner index not found' error when one classic process
dropped FK and another process trying to delete master record
Contributor(s):
Vlad Horsun
* ISQL improvement
Make SQLDA_DISPLAY display input SQLDA parameters of INSERTs, UPDATEs and DELETEs
Contributor(s):
Adriano dos Santos Fernandes
* Fixed unregistered bug
Server crashed when PLAN for VIEW is specified but no table alias was given
Contributor(s):
Vlad Horsun
* Fixed Alpha 2 bug (SF #1184591)
Invalid ROW_COUNT variable value after DELETE
Contributor(s):
Dmitry Yemanov
* Fixed unregistered bugs
1) redundant attempts to get an exclusive database lock during shutdown
2) inaccurate timeout counting
3) database lock is not released after bringing database online in the exclusive mode
4) removed a 5 sec timeout when bringing database online in the shared mode
Contributor(s):
Dmitry Yemanov
* Fixed bug SF #1016040
Missing external libraries causes engine exception
Contributor(s):
Adriano dos Santos Fernandes
* DML enhancement
Implemented RETURNING clause for the INSERT statement
See also:
/doc/sql.extentions/README.returning
Contributor(s):
Dmitry Yemanov
* Fixed bug SF #1186607
Foreign key relation VARCHAR <-> INT
Contributor(s):
Vlad Horsun
* Fixed bug SF #1211325
BLOBs in external tables
Contributor(s):
Vlad Horsun
* New charsets/collations
1) KOI8-R (Russian language) and KOI8-U (Ukrainian language) charsets and dictionary collations
2) WIN1257_LV (Latvian), WIN1257_LT (Lithuanian), WIN1257_EE (Estonian) collations
Contributor(s):
Oleg Loa
Aleksey Karyakin
* Parser improvement
Try report the line/column of an incomplete statement.
Contributor(s):
Claudio Valderrama
* Fixed unregistered bugs
1) Charset/collation issues for expression-based view columns
2) Lost charset/collation for local PSQL variables
Contributor(s):
Dmitry Yemanov
* Fixed Alpha 2 bug (SF #1171256)
Local Protocol (XNET) isn't using aliases
Contributor(s):
Dmitry Yemanov
* Fixed unregistered bug
Database alises didn't work in WNET
Contributor(s):
Dmitry Yemanov
* Fixed bug SF #1211354
Redundant evaluations in COALESCE
Contributor(s):
Arno Brinkman
* Fixed unregistered bug
Client crashed while disconnecting with active event listener
Contributor(s):
Dmitry Yemanov
* Fixed SF bug #1208932
SHOW GRANT does not distinguish object types
Contributor(s):
Claudio Valderrama
* Optimizer improvement
Use more realistic cost value for unique retrieval
Contributor(s):
Arno Brinkman
* Fixed SF bug #494981
Bad exception report
Contributor(s):
Claudio Valderrama
* DDL enhancement
Implemented ALTER EXTERNAL FUNCTION to change the entry_point or the module_name when the UDF cannot be dropped due to existing dependecies
Contributor(s):
Claudio Valderrama
* Fixed Alpha 2 bugs
1) bug with selectivity of non-equality comparisons
2) changed the invertions selection code to help in both MERGE and JOIN paths
3) implemented metadata extract for expression indices
4) the threading issues in fbembed
Contributor(s):
Dmitry Yemanov
* DDL enhancement
Implemented the COMMENT statement to set the metadata descriptions
See also:
/doc/sql.extentions/README.ddl.txt
Contributor(s):
Claudio Valderrama
* Fixed bug SF #908319
1.5 wrong err msg using gbak with service_mgr
Contributor(s):
Vlad Horsun
* Fixed unregistered bug
A few internal buffer overflows are fixed
Contributor(s):
Alex Peshkov
* Fixed unregistered bug
After an attempt to "create view v(c1) as select 1 from v" all clones of system request remained active forever
Contributor(s):
Alex Peshkov
* Fixed Alpha 2 bug
Server crashed in incorrect written EXECUTE BLOCK statement
Example(s):
EXECUTE BLOCK AS BEGIN
INSERT INTO DUMMY (ID) VALUES(?);
END
Contributor(s):
Vlad Horsun
* Fixed unregistered bug
ISQL_disconnect_database overwriting the Quiet flag permanently
Contributor(s):
Miroslav Penchev
Claudio Valderrama
* Fixed unregistered bug
Server crashed during the table metadata scan in some cases
Contributor(s):
Dmitry Yemanov
* Fixed unregistered bug
Error "index key too big" when creating a descending index
Contributor(s):
Vlad Horsun
* Fixed SF bug #1191006
Using where params in SUM return incorrect results
Contributor(s):
Arno Brinkman
* Fixed Alpha 2 bug
Problem with distributing sort to deeper RSE
Example(s):
SELECT RDB$RELATION_NAME FROM (SELECT FIRST 10 * FROM RDB$RELATIONS ORDER BY RDB$RELATION_NAME DESC) ORDER BY RDB$RELATION_NAME
Contributor(s):
Arno Brinkman
* Fixed SF bug #1122344
gbak -kill option drops existing shadow
Contributor(s):
Dmitry Yemanov
* Fixed SF bug #750662
Multiple declaration of blob filters
Contributor(s):
Dmitry Yemanov
* Parser improvement
UNIONs are allowed in ANY/ALL/IN subqueries
Contributor(s):
Dmitry Yemanov
* Fixed SF bug #743679
FIRST / SKIP not well implemented
Contributor(s):
Dmitry Yemanov
* Optimizer improvement
NOT conditions are simplified and optimized via index when possible
Example(s):
(NOT NOT A = 0) -> (A = 0)
(NOT A > 0) -> (A <= 0)
Contributor(s):
Dmitry Yemanov
* Fixed SF bug #450404
ISQL uppercases role in the command line
Contributor(s):
Claudio Valderrama
* Fixed unregistered bug
100% CPU load when an I/O error causes a rollover to non-existing shadow
Contributor(s):
Dmitry Yemanov
* Fixed Alpha 2 bug (SF #1173988)
Minor glitches in GBAK output
Contributor(s):
Claudio Valderrama
* Fixed unregistered bug
Fix for the -b (Bail On Error) option when SQL commands are issued and no db connection exists yet.
Apply Miroslav Penchev's patch for bug with -Q always returning 1 to the operating system, discovered by Ivan Prenosil.
Contributor(s):
Claudio Valderrama
* New INTL interface
A new interface allowing the following enhancements and features
Contributor(s):
Nickolay Samofatov
* INTL enhancements
1) Well-formedness checks of string constants and parameters
2) Uppercase and lowercase all possible (and not only ASCII) characters in default collation orders
3) Check length of characters (and not bytes) for new MBCS (including UTF8)
4) Inform original character set in sqlsubtype of XSQLVAR when connecting with NONE
Contributor(s):
Adriano dos Santos Fernandes
* BLOB enhancements
1) Allow usage of collations
2) Perform comparison using entire content
3) Convert between character sets when assigning from string or BLOB
Contributor(s):
Adriano dos Santos Fernandes
* Unicode 4.0 support
UTF8 character set with collations UCS_BASIC and UNICODE
Contributor(s):
Adriano dos Santos Fernandes
* Brazilian collations
1) Collation PT_BR for ISO8859_1 and WIN1252 character sets
2) Collation WIN_PTBR for WIN1252 character set
Contributor(s):
Adriano dos Santos Fernandes
Paulo Henrique Albanez
* New string functions
LOWER, BIT_LENGTH, CHAR_LENGTH/CHARACTER_LENGTH, OCTET_LENGTH, TRIM.
See also:
/doc/sql.extentions/README.length
/doc/sql.extentions/README.trim
Contributor(s):
Adriano dos Santos Fernandes
* INTL plugins
Character sets and collations are installed using a manifest file. Server write to the log when conflicts exist.
Contributor(s):
Adriano dos Santos Fernandes
* Fixed SF #1073212
Order by big columns (collate) terminates server
Contributor(s):
Adriano dos Santos Fernandes
* Fixed SF #939844
Queries > 263 chars with UNICODE DB throws GDS Exception
Contributor(s):
Adriano dos Santos Fernandes
* Fixed SF #977785
Wrong character lengths MBCS (UTF-8, East-Asian charsets)
Contributor(s):
Adriano dos Santos Fernandes
* Fixed SF #536243
UNICODE_FSS charset and UPPER function
Contributor(s):
Adriano dos Santos Fernandes
* Fixed SF #942726
UPPER does not convert aacute to Aacute for ISO8859_1
Contributor(s):
Adriano dos Santos Fernandes
* Fixed SF #544630
Problems when connecting using UNICODE
Contributor(s):
Adriano dos Santos Fernandes
* Fixed SF #540547
Concatenation, numeric fields & charset
Contributor(s):
Adriano dos Santos Fernandes
* Fixed unregistered bug
Query produce different result depending on index presence when the last character of the string is the first character of a compression pair
Contributor(s):
Adriano dos Santos Fernandes
* Fixed unregistered bug
SUBSTRING and multi-byte BLOB don't work correctly
Contributor(s):
Adriano dos Santos Fernandes
* Fixed unregistered bug
Pattern matching with multi-byte BLOB is performed in binary mode
Contributor(s):
Adriano dos Santos Fernandes
* Fixed unregistered bug
It's not safe to connect with MBCS if database has columns using different character set
Contributor(s):
Adriano dos Santos Fernandes
..::firebird::..
No comments:
Post a Comment