Debian Codegraph @

doc/WhatsNew

raw
1 **************************
2 * v3.0.14
3 **************************
4
5 * Improvement #8922
6 Update Windows distributions with zlib version 1.3.2
7 Contributor(s): Vlad Khorsun
8
9 * Improvement #8553
10 Get the modification time of a config file with a higher precision to fix cases when it's not reloaded after modification/replacement
11 Contributor(s): Ilya Eremin
12
13 * Bugfix #8926
14 Indexes may not be used for multiple ORed conditions containing both field and non-field references
15 Contributor(s): Dmitry Yemanov
16
17 * Bugfix #8903
18 Use of some switches with parameter in gbak's command line before name of database in '-SE' mode breaks access to databases with non-default security database
19 Contributor(s): Alexander Peshkov
20
21 * Bugfix #8850
22 Firebird 3.0.13 Win32: KERNEL32.GetThreadId import breaks Windows XP (regression vs 3.0.12)
23 Contributor(s): Vlad Khorsun
24
25 * Bugfix #8817
26 Fatal lock manager error: invalid lock id
27 Contributor(s): Vlad Khorsun
28
29 * Bugfix #8799
30 BUGCHECK "decompression overran buffer (179)" when WITH LOCK clause is used
31 Contributor(s): Ilya Eremin
32
33 * Bugfix #8739
34 Wrong SQLSTATE in case of table alias conflict
35 Contributor(s): Mark Rotteveel
36
37 * Bugfix #8665
38 SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies
39 Contributor(s): Adriano dos Santos Fernandes
40
41 * Bugfix #8644
42 Connection error via Loopback provider if it's the first in the Providers parameter
43 Contributor(s): Alexander Peshkov
44
45 * Bugfix for vulnerability GHSA-7pxc-h3rv-r257
46 Path traversal when declaring external routine (CVE-2026-40342)
47 Contributor(s): VladimirEliTokarev, Alexander Peshkov
48
49 * Bugfix for vulnerability GHSA-g99w-prq5-29c6
50 DoS via malicious slice descriptor in the slice packet (CVE-2026-35215)
51 Contributor(s): Artyom Ivanov, Alexander Peshkov
52
53 * Bugfix for vulnerability GHSA-7jq3-6j3c-5cm2
54 DoS via `op_response` packet from client (CVE-2026-34232)
55 Contributor(s): Artyom Ivanov
56
57 * Bugfix for vulnerability GHSA-89mq-229g-x47p
58 Buffer overflow on parsing corrupted slice packet (CVE-2026-33337)
59 Contributor(s): Artyom Ivanov
60
61 * Bugfix for vulnerability GHSA-xrcw-wpjx-pr9
62 CryptCallback DoS (CVE-2026-28224)
63 Contributor(s): Ev3nt
64
65 * Bugfix for vulnerability GHSA-6crx-4g37-7j49
66 Pre-Auth DoS (CVE-2026-27890)
67 Contributor(s): Artyom Ivanov
68
69 * Bugfix for vulnerability GHSA-7cq5-994r-jhrf
70 Server hangs when using specific clumplet on batch creation (CVE-2026-28214)
71 Contributor(s): Artyom Ivanov
72
73 * Bugfix for vulnerability GHSA-9884-9qm3-hqch
74 One packet (`op_slice`) DoS (CVE-2026-28212)
75 Contributor(s): Alexey Mochalov
76
77 * Bugfix for vulnerability GHSA-mfpr-9886-xjhg
78 Information leak vulnerability in firebird3 client when used with newer (>= 4) server (CVE-2025-65104)
79 Contributor(s): Alexander Peshkov
80
81
82 **************************
83 * v3.0.13
84 **************************
85
86 * Bugfix #8588
87 Error doing a backup when database file name has extended ASCII chars
88 Contributor(s): Alexander Peshkov
89
90 * Bugfix #8554
91 Vulnerability GHSA-7qp6-hqxj-pjjp / ZDI-CAN-26486
92 Contributor(s): Alexander Peshkov
93
94 * Bugfix #8520
95 Error in iTransaction.getInfo() on embedded connection
96 Contributor(s): Alexander Peshkov
97
98 * Bugfix #8485
99 Segfault/AV on incorrect databases.conf starting with subconfig (without line alias=database_path)
100 Contributor(s): Alexander Peshkov
101
102 * Bugfix #8449
103 Races when server is closed during forced database shutdown
104 Contributor(s): Alexander Peshkov
105
106 * Bugfix #8437
107 Segmentation fault when running query with PARTITION BY and subquery
108 Contributor(s): Adriano dos Santos Fernandes
109
110 * Bugfix #8417
111 Negative statement ID in trace output
112 Contributor(s): Dmitry Yemanov
113
114 * Bugfix #8416
115 Hang when opening shared memory file
116 Contributor(s): Alexander Peshkov
117
118 * Bugfix #8412
119 Fix potential deadlock when starting the encryption thread
120 Contributor(s): Alexey Mochalov
121
122 * Bugfix #8389
123 Unnecessary reload of the encryption plugin in the SuperServer architecture
124 Contributor(s): Alexey Mochalov
125
126 * Bugfix #8237
127 Database access error when nbackup is starting
128 Contributor(s): Alexander Peshkov
129
130 * Bugfix #8222
131 Fix a case of deleted memory modification
132 Contributor(s): Ilya Eremin
133
134 * Bugfix #8219
135 Database creation in 3.0.12, 4.0.5 and 5.0.1 is slower than in previous releases
136 Contributor(s): Adriano dos Santos Fernandes
137
138 * Bugfix #8215
139 Rare sporadic segfaults in test for CORE-6142 on Windows
140 Contributor(s): Alexander Peshkov
141
142 * Bugfix #8182
143 IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
144 Contributor(s): Mark Rotteveel
145
146
147 **************************
148 * v3.0.12
149 **************************
150
151 * Improvement #8181
152 Ensure the standalone CS listener on Linux uses the SO_REUSEADDR socket option
153 Contributor(s): Dmitry Yemanov
154
155 * Improvement #8030
156 Better cardinality estimation when empty data pages exist
157 Contributor(s): Vlad Khorsun
158
159 * Improvement #7978
160 Update Windows distributions with zlib version 1.3.1
161 Contributor(s): Vlad Khorsun
162
163 * Bugfix #8178
164 Fix boolean conversion to string inside DataTypeUtil::makeFromList()
165 Contributor(s): Dmitry Yemanov
166
167 * Bugfix #8156
168 Can not specify concrete IPv6 address in ES/EDS connection string
169 Contributor(s): Vlad Khorsun
170
171 * Bugfix #8151
172 Deadlock happens when run 'List Trace Sessions' service and there are many active trace sessions
173 Contributor(s): Vlad Khorsun
174
175 * Bugfix #8149
176 The hung or crash could happen when connection fires TRACE_EVENT_DETACH event and new trace session created concurrently
177 Contributor(s): Vlad Khorsun
178
179 * Bugfix #8110
180 Firebird 5 crash On Android API level 34
181 Contributor(s): Vlad Khorsun
182
183 * Bugfix #8101
184 Firebird crashes if a plugin factory returns nullptr and no error in status
185 Contributor(s): Vlad Khorsun, Dimitry Sibiryakov
186
187 * Bugfix #8089
188 AV when attaching database while low of free memory
189 Contributor(s): Vlad Khorsun
190
191 * Bugfix #8079
192 Engine could crash when executing some trigger(s) while another attachment modifies them
193 Contributor(s): Vlad Khorsun
194
195 * Bugfix #8027
196 Broken gbak statistics
197 Contributor(s): Alexander Peshkov
198
199 * Bugfix #7993
200 Unexpected results when using CASE WHEN with RIGHT JOIN
201 Contributor(s): Dmitry Yemanov
202
203 * Bugfix #7985
204 Hang in case of error when sweep thread is attaching to database (Classic Server)
205 Contributor(s): Alexander Peshkov
206
207 * Bugfix #7979
208 Hang when database with disconnect trigger using MON$ tables is shutting down
209 Contributor(s): Alexander Peshkov
210
211 * Bugfix #7950
212 Unable to restore database when .fbk was created on host with other ICU
213 Contributor(s): Alexander Peshkov
214
215 * Bugfix #7917
216 Hang in case of error when sweep thread is attaching to database
217 Contributor(s): Alexander Peshkov
218
219 * Bugfix #7860
220 Crash potentially caused by BETWEEN operator
221 Contributor(s): Vlad Khorsun
222
223 * Bugfix #7844
224 Removing first column with SET WIDTH crashes ISQL
225 Contributor(s): Adriano dos Santos Fernandes
226
227 * Bugfix #7839
228 Potential bug in BETWEEN operator
229 Contributor(s): Vlad Khorsun
230
231 * Bugfix #7817
232 Memory leak is possible for UDF array arguments
233 Contributor(s): Dmitry Yemanov
234
235 * Bugfix #7812
236 Service backup does not work in multiple engines configuration
237 Contributor(s): Alexander Peshkov
238
239 * Bugfix #7779
240 Firebird is constantly crashing with the same symptoms (fbclient.dll)
241 Contributor(s): Vlad Khorsun
242
243 * Bugfix #7762
244 Crash on "Operating system call pthread_mutex_destroy failed. Error code 16" in log
245 Contributor(s): Alexander Peshkov
246
247 * Bugfix #7747
248 Fix an issue where the garbage collection in indexes and blobs is not performed in VIO_backout()
249 Contributor(s): Ilya Eremin
250
251 * Bugfix #7738
252 Crash on multiple connections/disconnections
253 Contributor(s): Alexander Peshkov
254
255 * Bugfix #7737
256 Fix cases where the precedence relationship between a record page and a blob page is not set
257 Contributor(s): Ilya Eremin
258
259 * Bugfix #7713
260 FOR SELECT statement can not see any changes made in DO block
261 Contributor(s): Vlad Khorsun
262
263 * Bugfix #7522
264 Shared memory area is probably already created by another engine instance in another Windows session, failed to create database
265 Contributor(s): Vlad Khorsun
266
267 * Bugfix #7480
268 Firebird server stops accepting new connections after some time
269 Contributor(s): Alexander Peshkov
270
271
272 **************************
273 * v3.0.11
274 **************************
275
276 * Improvement #7539
277 RDB$GET/SET_CONTEXT(): enclosing in apostrophes or double quotes of a missed namespace/variable will made output more readable
278 Contributor(s): Vlad Khorsun
279
280 * Improvement #7494
281 Firebird performance issue - non necessary index reads
282 Contributor(s): Vlad Khorsun
283
284 * Improvement #7468
285 Add switch to control in guardian timeout before killing firebird server process
286 Contributor(s): Alexander Peshkov
287
288 * Improvement #7437
289 zlib version 1.2.13 released 2022-10-13
290 Contributor(s): Vlad Khorsun
291
292 * Improvement #7418
293 Reliability of plugin manager
294 Contributor(s): Alexander Peshkov
295
296 * Improvement #7259
297 Remove TcpLoopbackFastPath and use of SIO_LOOPBACK_FAST_PATH
298 Contributor(s): Vlad Khorsun
299
300 * Bugfix #7665
301 Wrong result ordering in LEFT JOIN query
302 Contributor(s): Dmitry Yemanov
303
304 * Bugfix #7664
305 DROP TABLE executed for a table with big records may lead to "wrong page type" or "end of file" error
306 Contributor(s): Vlad Khorsun, Ilya Eremin
307
308 * Bugfix #7662
309 Peformance issues in prepare_update()
310 Contributor(s): Ilya Eremin
311
312 * Bugfix #7661
313 FB3 CS rejects new connections
314 Contributor(s): Vlad Khorsun
315
316 * Bugfix #7626
317 Segfault when new attachment is done to shutting down database
318 Contributor(s): Alexander Peshkov
319
320 * Bugfix #7556
321 FB Classic can hang when attempts to attach DB while it is starting to encrypt/decrypt
322 Contributor(s): Alexander Peshkov
323
324 * Bugfix #7555
325 Invalid configuration for random fresh created database may be used after drop of another one with alias in databases.conf
326 Contributor(s): Alexander Peshkov
327
328 * Bugfix #7537
329 Wrong name in error message when unknown namespace is passed into RDB$SET_CONTEXT()
330 Contributor(s): Vlad Khorsun
331
332 * Bugfix #7517
333 Successful compiling of procedure with wrong PLAN(s) used by some of its statement(s)
334 Contributor(s): Dmitry Yemanov
335
336 * Bugfix #7514
337 Segfault when detaching after deleting shadow on Classic
338 Contributor(s): Alexander Peshkov
339
340 * Bugfix #7510
341 Firebird regularly crashes soon after unload of udr_engine plugin
342 Contributor(s): Alexander Peshkov
343
344 * Bugfix #7501
345 Precision of standalone unit may differ from packaged one in SQL dialect 1
346 Contributor(s): Vlad Khorsun
347
348 * Bugfix #7499
349 Problem with restore
350 Contributor(s): Vlad Khorsun
351
352 * Bugfix #7473
353 Client application crash when processing callback requests from server during attachDatabase
354 Contributor(s): Alexander Peshkov
355
356 * Bugfix #7467
357 Simple sql crashes firebird: select cast(rdb$db_key as integer) from rdb$database
358 Contributor(s): Alexander Peshkov
359
360 * Bugfix #7465
361 Restore success illegally reported when gbak was unable to activate all indices
362 Contributor(s): Alexander Peshkov
363
364 * Bugfix #7446
365 Attempt to use data in destroyed transaction pool
366 Contributor(s): Alexander Peshkov
367
368 * Bugfix #7444
369 isql crashes when executing test from QA suite
370 Contributor(s): Alexander Peshkov
371
372 * Bugfix #7434
373 Crash or error in SUBSTRING()'s regexp parser with UTF-8 encoding
374 Contributor(s): Alexey Mochalov
375
376 * Bugfix #7428
377 Problem with editing procedures being in use
378 Contributor(s): Vlad Khorsun
379
380 * Bugfix #7415
381 DbCrypt/KeyHolder plugins key changing issues on running server
382 Contributor(s): Alexey Mochalov
383
384 * Bugfix #7413
385 Regression: bad plan in FB 3.0.9+ (correct in FB 3.0.8)
386 Contributor(s): Dmitry Yemanov
387
388 * Bugfix #7406
389 Regression - trusted role does not work with version 3.0.10
390 Contributor(s): Alexander Peshkov
391
392 * Bugfix #7402
393 Server crashes on startup error
394 Contributor(s): Alexander Peshkov
395
396 * Bugfix #7393
397 Access violation after double fault in attachDatabase()
398 Contributor(s): Alexander Peshkov
399
400 * Bugfix #7370
401 Segfault under OOM conditions
402 Contributor(s): Alexander Peshkov
403
404 * Bugfix #7365
405 Client side aliases do not work in databases.conf
406 Contributor(s): Alexander Peshkov
407
408 * Bugfix #7349
409 Contradictory licensing/distribution statements in several charset-support files
410 Contributor(s): Mark Rotteveel
411
412 * Bugfix #7314
413 Multitreaded activating indices restarts server process
414 Contributor(s): Vlad Khorsun
415
416 * Bugfix #7299
417 gfix hangs on disconnect when transactions trace active
418 Contributor(s): Alexander Peshkov
419
420 * Bugfix #7298
421 Unreliable info result parsing
422 Contributor(s): Alexander Peshkov
423
424 * Bugfix #7296
425 During shutdown op_disconnect may be sent to invalid handle
426 Contributor(s): Alexander Peshkov
427
428 * Bugfix #7295
429 Unexpected message 'Error reading data from the connection' when fbtracemgr is closed using ctrl-C
430 Contributor(s): Alexander Peshkov
431
432 * Bugfix #7314
433 Sporadic crash on 3.0.10.33106
434 Contributor(s): Vlad Khorsun
435
436 * Bugfix #7237
437 Starting operator become unstable on indexed varchar fields
438 Contributor(s): Adriano dos Santos Fernandes
439
440 * Bugfix #7233
441 Slow database restore when Classic server mode is used
442 Contributor(s): Ilya Eremin
443
444 * Bugfix #6947
445 Query to mon$ tables does not return data when the encryption/decryption thread is running
446 Contributor(s): Alexander Peshkov
447
448 * Bugfix #6941
449 Dummy (always true) conditions may change the join order
450 Contributor(s): Dmitry Yemanov
451
452 * Bugfix #5853
453 Wrong formatting of "Elapsed time" in isql
454 Contributor(s): Jiri Cincura
455
456 * Bugfix #4729
457 Grant and Revoke update (field)
458 Contributor(s): Alexander Peshkov
459
460 * Bugfix #3810
461 Wrong or missing IS NULL optimization (regression)
462 Contributor(s): Vlad Khorsun
463
464
465 **************************
466 * v3.0.10
467 **************************
468
469 * Improvement #7194
470 Make it possible to avoid fbclient dependency in Pascal programs using firebird.pas
471 Contributor(s):
472 Alex Peshkov <peshkoff at mail.ru>
473
474 * Improvement #7161
475 Update zlib to 1.2.12
476 Contributor(s):
477 Vlad Khorsun <hvlad at users.sourceforge.net>
478
479 * Improvement #7093
480 Improve indexed lookup speed of strings when the last keys characters are part of collated contractions
481 Contributor(s):
482 Adriano dos Santos Fernandes <adrianosf at gmail.com>
483
484 * Improvement #6872
485 Faster execution of indexed STARTING WITH with UNICODE collation
486 Contributor(s):
487 Adriano dos Santos Fernandes <adrianosf at gmail.com>
488
489 * Bugfix #7197
490 Segfault in Linux CS after successful detach from a database
491 Contributor(s):
492 Alex Peshkov <peshkoff at mail.ru>
493
494 * Bugfix #7191
495 gstat fails, but return 0 error code with incorrect databases.conf
496 Contributor(s):
497 Alexey Mochalov <aleksey.mochalov at red-soft.ru>
498
499 * Bugfix #7184
500 gbak output is not being flushed to disk
501 Contributor(s):
502 Alex Peshkov <peshkoff at mail.ru>
503
504 * Bugfix #7176
505 Incorrect error "Invalid token. Malformed string." with union + blob + non-UTF8 varchar
506 Contributor(s):
507 Adriano dos Santos Fernandes <adrianosf at gmail.com>
508
509 * Bugfix #7160
510 Missing checkout in trace manager when performing user mapping may cause server hang
511 Contributor(s):
512 Alex Peshkov <peshkoff at mail.ru>
513
514 * Bugfix #7158
515 Serious issue with SYSDBA user after a Windows install with EnableLegacyClientAuth
516 Contributor(s):
517 Paul Reeves <preeves at ibphoenix.com>
518
519 * Bugfix #7147
520 Problems with use of big timeout (or no timeout at all) in trace service
521 Contributor(s):
522 Alex Peshkov <peshkoff at mail.ru>
523
524 * Bugfix #7141
525 Services manager breaks long lines into 1023 bytes portions when using isc_info_svc_line in Service::query()
526 Contributor(s):
527 Alex Peshkov <peshkoff at mail.ru>
528
529 * Bugfix #7140
530 Wrong select result in case of special sort character
531 Contributor(s):
532 Adriano dos Santos Fernandes <adrianosf at gmail.com>
533
534 * Bugfix #7138
535 Problems accessing FB4 database, copied from another host
536 Contributor(s):
537 Alex Peshkov <peshkoff at mail.ru>
538
539 * Bugfix #7137
540 Optimizer regression: bad plan (HASH instead of JOIN) is chosen for some inner joins
541 Contributor(s):
542 Dmitry Yemanov <dimitr at firebirdsql.org>
543
544 * Bugfix #7135
545 Firebird engine randomly fails when delivering mapping clear to other processes
546 Contributor(s):
547 Alex Peshkov <peshkoff at mail.ru>
548
549 * Bugfix #7128
550 Incorrect error message with isc_sql_interprete()
551 Contributor(s):
552 Vlad Khorsun <hvlad at users.sourceforge.net>
553
554 * Bugfix #7122
555 Invalid state of mapping cache after replacement of database
556 Contributor(s):
557 Alex Peshkov <peshkoff at mail.ru>
558
559 * Bugfix #7121
560 Mapping error when server tries to use mapping rules from database in full shutdown state
561 Contributor(s):
562 Alex Peshkov <peshkoff at mail.ru>
563
564 * Bugfix #7106
565 Wrong detection of must-be-delimited user names
566 Contributor(s):
567 Alex Peshkov <peshkoff at mail.ru>
568
569 * Bugfix #7094
570 Incorrect indexed lookup of strings when the last keys characters are part of collated contractions and there is multi-segment insensitive descending index
571 Contributor(s):
572 Adriano dos Santos Fernandes <adrianosf at gmail.com>
573
574
575 **************************
576 * v3.0.9
577 **************************
578
579 * Bugfix #7119
580 Database statistics service could not find existing table(s)
581 Contributor(s):
582 Vlad Khorsun <hvlad at users.sourceforge.net>
583
584 * Bugfix #7118
585 Chained JOIN .. USING across the same column names may be optimized badly
586 Contributor(s):
587 Dmitry Yemanov <dimitr at firebirdsql.org>
588
589 * Bugfix #7115
590 Server hangs in trace code when it tries to update mapping cache
591 Contributor(s):
592 Alex Peshkov <peshkoff at mail.ru>
593
594 * Bugfix #7112
595 Avoid unload of plugins in MacOS due to problematic reload of them
596 Contributor(s):
597 Adriano dos Santos Fernandes <adrianosf at gmail.com>
598
599 * Bugfix #7109
600 Content of DB file can be overwritten with zero characters in some (rare) cases
601 Contributor(s):
602 Vlad Khorsun <hvlad at users.sourceforge.net>
603
604 * Bugfix #7103
605 FB service hangs and cannot be stopped after several 'DELETE FROM MON$STATEMENTS' being issued in order to stop ES/EDS which waits record for updating
606 Contributor(s):
607 Vlad Khorsun <hvlad at users.sourceforge.net>
608
609 * Bugfix #7084
610 Creating unique constraints on MacOS fails on larger tables
611 Contributor(s):
612 Adriano dos Santos Fernandes <adrianosf at gmail.com>
613
614 * Bugfix #7067
615 Deadlock when using not initialized security database
616 Contributor(s):
617 Alex Peshkov <peshkoff at mail.ru>
618
619 * Bugfix #7060
620 Deadlock when execute test for CORE-4337
621 Contributor(s):
622 Alex Peshkov <peshkoff at mail.ru>
623
624 * Bugfix #7057
625 Client-side positioned updates work wrongly with scrollable cursors
626 Contributor(s):
627 Dmitry Yemanov <dimitr at firebirdsql.org>
628
629 * Bugfix #7056
630 Fetching from a scrollable cursor may overwrite user-specified buffer and corrupt memory
631 Contributor(s):
632 Dmitry Yemanov <dimitr at firebirdsql.org>
633
634 * Bugfix #7043
635 Wrong message when user has no access to /tmp/firebird
636 Contributor(s):
637 Alex Peshkov <peshkoff at mail.ru>
638
639 * Bugfix #6966
640 Status vector for ES(<EMPTY_STRING>) is unstable if another execute block with correct statement was executed before
641 Contributor(s):
642 Alex Peshkov <peshkoff at mail.ru>
643
644 * Bugfix #3357
645 Bad execution plan if some stream depends on multiple streams via a function
646 Contributor(s):
647 Dmitry Yemanov <dimitr at firebirdsql.org>
648
649
650 **************************
651 * v3.0.8
652 **************************
653
654 * Improvement #6957
655 Add database creation time to the output of ISQL's command SHOW DATABASE
656 Contributor(s):
657 Vlad Khorsun <hvlad at users.sourceforge.net>
658
659 * Improvement #6769 (CORE-6542)
660 More efficient implementation of SUBSTRING for UTF8 character set
661 Contributor(s):
662 Adriano dos Santos Fernandes <adrianosf at gmail.com>
663
664 * Improvement #6748 (CORE-6519)
665 Freeing a statement using DSQL_drop or DSQL_unprepare should send free packet immediately
666 Contributor(s):
667 Vlad Khorsun <hvlad at users.sourceforge.net>
668
669 * Improvement #5913 (CORE-5647)
670 Increase number of formats/versions of views from 255 to 32K
671 Contributor(s):
672 Adriano dos Santos Fernandes <adrianosf at gmail.com>
673
674 * Improvement #5137 (CORE-4841)
675 Make message about missing password being always displayed as reply on attempt to issue CREATE new login without PASSWORD clause
676 Contributor(s):
677 Alex Peshkov <peshkoff at mail.ru>
678
679 * Bugfix #7044
680 Validation error: Data page N {sequence M} marked as secondary but contains primary record versions in table T
681 Contributor(s):
682 Vlad Khorsun <hvlad at users.sourceforge.net>
683
684 * Bugfix #7036
685 Unexpected messages '"Missing security context ...' in firebird.log
686 Contributor(s):
687 Alex Peshkov <peshkoff at mail.ru>
688
689 * Bugfix #7034
690 Scroll cursor server crash
691 Contributor(s):
692 Dmitry Yemanov <dimitr at firebirdsql.org>
693
694 * Bugfix #7031
695 gbak -b fails with "invalid transaction handle (expecting explicit transaction start)"
696 Contributor(s):
697 Vlad Khorsun <hvlad at users.sourceforge.net>
698
699 * Bugfix #6999
700 GBAK removes database and backup files if finished unsuccessfully
701 Contributor(s):
702 Ilya Eremin <ilya071294 at gmail.com>
703 Alex Peshkov <peshkoff at mail.ru>
704
705 * Bugfix #6987
706 DATEDIFF does not support fractional value for MILLISECOND
707 Contributor(s):
708 Adriano dos Santos Fernandes <adrianosf at gmail.com>
709
710 * Bugfix #6984
711 Committed transaction could be marked as dead in some very special and rare case
712 Contributor(s):
713 Vlad Khorsun <hvlad at users.sourceforge.net>
714 Dmitry Yemanov <dimitr at firebirdsql.org>
715
716 * Bugfix #6967
717 PIO_read / PIO_write may falsely return success in a case when block was read/written incompletely
718 Contributor(s):
719 Alex Peshkov <peshkoff at mail.ru>
720
721 * Bugfix #6949
722 On Windows, engine may hang on initialization when another instance with different lock directory is running
723 Contributor(s):
724 Vlad Khorsun <hvlad at users.sourceforge.net>
725
726 * Bugfix #6932
727 GTT's pages are not released while dropping it
728 Contributor(s):
729 Ilya Eremin <ilya071294 at gmail.com>
730 Vlad Khorsun <hvlad at users.sourceforge.net>
731
732 * Bugfix #6918
733 Service detach is always traced
734 Contributor(s):
735 Vlad Khorsun <hvlad at users.sourceforge.net>
736
737 * Bugfix #6896
738 Client forcing server to encryption
739 Contributor(s):
740 Alex Peshkov <peshkoff at mail.ru>
741
742 * Bugfix #6866
743 Orphan records are left in RDB$SECURITY_CLASSES and RDB$USER_PRIVILEGES after DROP PROCEDURE/FUNCTION
744 Contributor(s):
745 Vlad Khorsun <hvlad at users.sourceforge.net>
746
747 * Bugfix #6854
748 Crash occurs when SIMILAR TO is used
749 Contributor(s):
750 Adriano dos Santos Fernandes <adrianosf at gmail.com>
751
752 * Bugfix #6836
753 fb_shutdown() does not wait for self completion in other thread
754 Contributor(s):
755 Alex Peshkov <peshkoff at mail.ru>
756
757 * Bugfix #6817
758 -fetch_password passwordfile does not work with GFIX
759 Contributor(s):
760 Alex Peshkov <peshkoff at mail.ru>
761
762 * Bugfix #6796
763 Buffer overflow when padding line with national characters causes ISQL to crash
764 Contributor(s):
765 Adriano dos Santos Fernandes <adrianosf at gmail.com>
766
767 * Bugfix #6782
768 Cannot get "records fetched" counter for procedures/functions in trace
769 Contributor(s):
770 Vlad Khorsun <hvlad at users.sourceforge.net>
771
772 * Bugfix #6781
773 Crashing (due to UDF exception) server process hangs
774 Contributor(s):
775 Vlad Khorsun <hvlad at users.sourceforge.net>
776
777 * Bugfix #6780
778 firebird.msg is missing in Firebird Android builds
779 Contributor(s):
780 Alex Peshkov <peshkoff at mail.ru>
781
782 * Bugfix #6777
783 AV when engine shut down and cancels attachment that is waiting in lock manager
784 Contributor(s):
785 Vlad Khorsun <hvlad at users.sourceforge.net>
786
787 * Bugfix #6768 (CORE-6542)
788 Backup cannot be restored on a raw device (error during "open O_CREAT" operation for file "/dev/sda1")
789 Contributor(s):
790 Alex Peshkov <peshkoff at mail.ru>
791
792 * Bugfix #6759 (CORE-6532)
793 Results of concatenation with blob has no info about collation of source columns (which are declared with such info)
794 Contributor(s):
795 Vlad Khorsun <hvlad at users.sourceforge.net>
796
797 * Bugfix #6758 (CORE-6531)
798 COMPUTED BY column looses charset and collate of source field <F> when <F> is either of type BLOB or VARCHAR casted to BLOB
799 Contributor(s):
800 Vlad Khorsun <hvlad at users.sourceforge.net>
801
802 * Bugfix #6755 (CORE-6528)
803 Connect to a database that contains broken pages can lead to server crash
804 Contributor(s):
805 Alex Peshkov <peshkoff at mail.ru>
806
807 * Bugfix #6752 (CORE-6525)
808 Segfaults in fbclient when receiving invalid / unexpected data from server
809 Contributor(s):
810 Alex Peshkov <peshkoff at mail.ru>
811
812 * Bugfix #6751 (CORE-6524)
813 Various segfaults in fbclient
814 Contributor(s):
815 Alex Peshkov <peshkoff at mail.ru>
816
817 * Bugfix #6750 (CORE-6521)
818 CAST of infinity values to FLOAT doesn't work
819 Contributor(s):
820 Alex Peshkov <peshkoff at mail.ru>
821
822 * Bugfix #6747 (CORE-6518)
823 Wrong message when connecting to tiny trash database file
824 Contributor(s):
825 Alex Peshkov <peshkoff at mail.ru>
826
827 * Bugfix #6746 (CORE-6517)
828 CREATE DATABASE fails with 'Token unknown' error when DB name is enclosed in double quotes and 'DEFAULT CHARACTER SET' is specified after DB name
829 Contributor(s):
830 Adriano dos Santos Fernandes <adrianosf at gmail.com>
831
832 * Bugfix #6731 (CORE-6501)
833 Segfault when shutting down database which got encrypted by another process
834 Contributor(s):
835 Alex Peshkov <peshkoff at mail.ru>
836
837 * Bugfix #6729 (CORE-6499)
838 GSTAT with switch -t executed via services fails with "found unknown switch" error
839 Contributor(s):
840 Alex Peshkov <peshkoff at mail.ru>
841
842 * Bugfix #6724 (CORE-6494)
843 Inconsistent translation "string->timestamp->string->timestamp" in the Dialect 1
844 Contributor(s):
845 Adriano dos Santos Fernandes <adrianosf at gmail.com>
846
847 * Bugfix #6719 (CORE-6489)
848 User without ALTER ANY ROLE privilege can use COMMENT ON ROLE
849 Contributor(s):
850 Alex Peshkov <peshkoff at mail.ru>
851
852 * Bugfix #6718 (CORE-6488)
853 Event delivery could be missed when local (XNET) protocol is used
854 Contributor(s):
855 Vlad Khorsun <hvlad at users.sourceforge.net>
856
857 * Bugfix #6717 (CORE-6487)
858 FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last
859 Contributor(s):
860 Dmitry Yemanov <dimitr at firebirdsql.org>
861
862 * Bugfix #6716 (CORE-6486)
863 FETCH RELATIVE has an off by one error for the first row
864 Contributor(s):
865 Dmitry Yemanov <dimitr at firebirdsql.org>
866
867 * Bugfix #6710 (CORE-6479)
868 COMMENT ON USER can only apply comment on user defined by the default UserManager plugin
869 Contributor(s):
870 Alex Peshkov <peshkoff at mail.ru>
871
872 * Bugfix #6708 (CORE-6477)
873 Rare race condition in Plugin Manager could lead to the server crash
874 Contributor(s):
875 Vlad Khorsun <hvlad at users.sourceforge.net>
876
877 * Bugfix #6700 (CORE-6468)
878 Wire compression causes sporadic "Error reading data from the connection" errors
879 Contributor(s):
880 Alex Peshkov <peshkoff at mail.ru>
881
882 * Bugfix #6698 (CORE-6466)
883 Comments before the first line of code are removed
884 Contributor(s):
885 Adriano dos Santos Fernandes <adrianosf at gmail.com>
886
887 * Bugfix #6683 (CORE-6450)
888 Races in cache of opened security databases
889 Contributor(s):
890 Alex Peshkov <peshkoff at mail.ru>
891
892 * Bugfix #6680 (CORE-6447)
893 Unexpectedly different text of message for parameterized expression starting from second run
894 Contributor(s):
895 Vlad Khorsun <hvlad at users.sourceforge.net>
896
897 * Bugfix #6679 (CORE-6446)
898 CLOOP envelopes are wrong regarding IStatus
899 Contributor(s):
900 Alex Peshkov <peshkoff at mail.ru>
901
902 * Bugfix #2367 (CORE-6441)
903 Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)
904 Contributor(s):
905 Alex Peshkov <peshkoff at mail.ru>
906
907 * Bugfix #6674 (CORE-6440)
908 Expression indexes containing COALESCE inside cannot be matched by the optimizer after migration from v2.5 to v3.0
909 Contributor(s):
910 Dmitry Yemanov <dimitr at firebirdsql.org>
911
912 * Bugfix #6672 (CORE-6437)
913 GFIX cannot set big value for buffers
914 Contributor(s):
915 Vlad Khorsun <hvlad at users.sourceforge.net>
916
917 * Bugfix #6670 (CORE-6433)
918 Firebird server crashes during a daily maintenance / set statistics index
919 Contributor(s):
920 Alex Peshkov <peshkoff at mail.ru>
921
922 * Bugfix #6669 (CORE-6432)
923 Possible buffer overflow in client library in Attachment::getInfo() call
924 Contributor(s):
925 Alex Peshkov <peshkoff at mail.ru>
926
927 * Bugfix #6650 (CORE-6412)
928 Firebird freezes when trying to manage users via triggers
929 Contributor(s):
930 Alex Peshkov <peshkoff at mail.ru>
931
932 * Bugfix #6646 (CORE-6408)
933 RETURNING clause in MERGE cannot reference column in aliased target table using qualified reference (alias.column) if DELETE action present
934 Contributor(s):
935 Adriano dos Santos Fernandes <adrianosf at gmail.com>
936
937 * Bugfix #6624 (CORE-6385)
938 Wrong line and column information after IF statement
939 Contributor(s):
940 Adriano dos Santos Fernandes <adrianosf at gmail.com>
941
942 * Bugfix #6265 (CORE-6015)
943 Segfault when using expression index with complex expression
944 Contributor(s):
945 Vlad Khorsun <hvlad at users.sourceforge.net>
946
947 * Bugfix #6220 (CORE-5966)
948 Slow performance when executing SQL scripts as non-SYSDBA user
949 Contributor(s):
950 Roman Simakov <roman.simakov at red-soft.biz>
951
952 * Bugfix #5877 (CORE-5611)
953 Higher memory consumption for prepared statements
954 Contributor(s):
955 Adriano dos Santos Fernandes <adrianosf at gmail.com>
956
957 * Bugfix #5534 (CORE-5255)
958 String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters
959 Contributor(s):
960 Adriano dos Santos Fernandes <adrianosf at gmail.com>
961
962 * Bugfix #5173 (CORE-4878)
963 Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK)
964 Contributor(s):
965 Ilya Eremin <ilya071294 at gmail.com>
966
967 * Bugfix #5082 (CORE-4783)
968 Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction
969 Contributor(s):
970 Ilya Eremin <ilya071294 at gmail.com>
971
972 * Bugfix #3886 (CORE-3529)
973 RECREATE TABLE T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode
974 Contributor(s):
975 Ilya Eremin <ilya071294 at gmail.com>
976
977 * Bugfix #1210 (CORE-2917)
978 Server hangs on I/O error during "open" operation for file "/tmp/firebird/fb_trace_ksVDoc"
979 Contributor(s):
980 Alex Peshkov <peshkoff at mail.ru>
981
982 * Bugfix #2469 (CORE-2032)
983 Stored procedure recursively called by calculated field fails after reconnect
984 Contributor(s):
985 Vlad Khorsun <hvlad at users.sourceforge.net>
986
987
988 **************************
989 * v3.0.7
990 **************************
991
992 * Improvement CORE-6413
993 Remove PIDFile/-pidfile option from Super(Server/Classic) systemd unit
994 Contributor(s):
995 Alex Peshkov <peshkoff at mail.ru>
996
997 * Improvement CORE-6362
998 Better diagnostic for the 'Missing security context' error
999 Contributor(s):
1000 Alex Peshkov <peshkoff at mail.ru>
1001
1002 * Improvement CORE-6339
1003 Detach server from the security database when missing plugin data structures are causing an error
1004 Contributor(s):
1005 Alex Peshkov <peshkoff at mail.ru>
1006
1007 * Bugfix CORE-6411
1008 FB crashes attempting to create a table with >5460 fields
1009 Contributor(s):
1010 Dmitry Yemanov <dimitr at firebirdsql.org>
1011
1012 * Bugfix CORE-6396
1013 Unknown tag (0) in isc_svc_query() results
1014 Contributor(s):
1015 Alex Peshkov <peshkoff at mail.ru>
1016
1017 * Bugfix CORE-6392
1018 Space in database path prevent working gbak -se ... -b "pat to/database" backup
1019 Contributor(s):
1020 Alex Peshkov <peshkoff at mail.ru>
1021
1022 * Bugfix CORE-6388
1023 Client asserts when closing the event thread in the debug build
1024 Contributor(s):
1025 Alex Peshkov <peshkoff at mail.ru>
1026
1027 * Bugfix CORE-6370
1028 Server leaks memory when a computed field containing COALESCE/CAST is selected
1029 Contributor(s):
1030 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1031
1032 * Bugfix CORE-6367
1033 Segfault when receiving a malformed packet from the network
1034 Contributor(s):
1035 Alex Peshkov <peshkoff at mail.ru>
1036
1037 * Bugfix CORE-6364
1038 Wrong reference counting in the UDR trigger sample
1039 Contributor(s):
1040 Vlad Khorsun <hvlad at users.sourceforge.net>
1041
1042 * Bugfix CORE-6360
1043 Engine may hang due to races when starting the crypt thread and simultaneous shutdown
1044 Contributor(s):
1045 Alex Peshkov <peshkoff at mail.ru>
1046
1047 * Bugfix CORE-6358
1048 Adding NOT NULL column with DEFAULT value may cause default values to be volatile or have the wrong charset
1049 Contributor(s):
1050 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1051
1052 * Bugfix CORE-6351
1053 Inter-dependent computed fields could be wrongly evaluated as NULL in some cases
1054 Contributor(s):
1055 Vlad Khorsun <hvlad at users.sourceforge.net>
1056
1057 * Bugfix CORE-6348
1058 Wire compression causes server freezes
1059 Contributor(s):
1060 Alex Peshkov <peshkoff at mail.ru>
1061
1062 * Bugfix CORE-6347
1063 New connections to the server sometimes stall, when there is an existing connection to the database
1064 Contributor(s):
1065 Vlad Khorsun <hvlad at users.sourceforge.net>
1066
1067 * Bugfix CORE-6346
1068 New connection to the server hangs
1069 Contributor(s):
1070 Vlad Khorsun <hvlad at users.sourceforge.net>
1071
1072 * Bugfix CORE-6340
1073 Alternate quoting does not work on some particular cases
1074 Contributor(s):
1075 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1076
1077 * Bugfix CORE-6253
1078 Server may crash sue to the locked fb_lock file
1079 Contributor(s):
1080 Vlad Khorsun <hvlad at users.sourceforge.net>
1081
1082 * Bugfix CORE-6147
1083 Script with extracted (using isql -x) metadata may fail creating the global mapping
1084 Contributor(s):
1085 Alex Peshkov <peshkoff at mail.ru>
1086
1087
1088 **************************
1089 * v3.0.6
1090 **************************
1091
1092 * New feature CORE-4933
1093 Better transaction control in ISQL
1094 Contributor(s):
1095 Vlad Khorsun <hvlad at users.sourceforge.net>
1096
1097 * Improvement CORE-6334
1098 Missing relocation support on MacOS
1099 Contributor(s):
1100 Alex Peshkov <peshkoff at mail.ru>
1101
1102 * Improvement CORE-6274
1103 Increase parsing speed of long queries
1104 Contributor(s):
1105 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1106
1107 * Improvement CORE-6237
1108 Performance problem when using SRP plugin
1109 Contributor(s):
1110 Alex Peshkov <peshkoff at mail.ru>
1111
1112 * Bugfix CORE-6345
1113 Server crashes on overflow of division result
1114 Contributor(s):
1115 Alex Peshkov <peshkoff at mail.ru>
1116
1117 * Bugfix CORE-6343
1118 Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY
1119 Contributor(s):
1120 Dmitry Yemanov <dimitr at firebirdsql.org>
1121
1122 * Bugfix CORE-6331
1123 Memory leak with some statements and expressions
1124 Contributor(s):
1125 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1126
1127 * Bugfix CORE-6329
1128 GBAK with service_mgr and WinSSPI authentication raises error in clumplet API
1129 Contributor(s):
1130 Alex Peshkov <peshkoff at mail.ru>
1131
1132 * Bugfix CORE-6323
1133 File-system ID may be duplicated among databases located on different volumes
1134 Contributor(s):
1135 Dmitry Yemanov <dimitr at firebirdsql.org>
1136
1137 * Bugfix CORE-6319
1138 NBACKUP locks database file after error
1139 Contributor(s):
1140 Vlad Khorsun <hvlad at users.sourceforge.net>
1141
1142 * Bugfix CORE-6317
1143 Server is crashing on long GRANT statement
1144 Contributor(s):
1145 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1146
1147 * Bugfix CORE-6314
1148 Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit
1149 Contributor(s):
1150 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1151
1152 * Bugfix CORE-6310
1153 VARCHAR length limit is not enforced when assigning string with trailing spaces in MBCS
1154 Contributor(s):
1155 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1156
1157 * Bugfix CORE-6309
1158 FBSVCMGR can not decode information buffer returned by gfix list limbo service
1159 Contributor(s):
1160 Alex Peshkov <peshkoff at mail.ru>
1161
1162 * Bugfix CORE-6296
1163 Many connections results in poor performance
1164 Contributor(s):
1165 Vlad Khorsun <hvlad at users.sourceforge.net>
1166
1167 * Bugfix CORE-6295
1168 Incomplete header files in distributed packages
1169 Contributor(s):
1170 Vlad Khorsun <hvlad at users.sourceforge.net>
1171 Paul Reeves <preeves at ibphoenix.com>
1172
1173 * Bugfix CORE-6290
1174 Hex number used at end of statement (for example with CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions
1175 Contributor(s):
1176 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1177
1178 * Bugfix CORE-6283
1179 isNullable() in message metadata, returned by metadata builder, does not match with datatype set by setType() in metadata builder
1180 Contributor(s):
1181 Alex Peshkov <peshkoff at mail.ru>
1182
1183 * Bugfix CORE-6280
1184 MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations
1185 Contributor(s):
1186 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1187
1188 * Bugfix CORE-6269
1189 Server (on Linux) ignores KeepAlive settings, when client connection is lost the corresponding server connection/process is not killed
1190 Contributor(s):
1191 Alex Peshkov <peshkoff at mail.ru>
1192
1193 * Bugfix CORE-6266
1194 Deleting records from MON$ATTACHMENTS using ORDER BY clause doesn't close the corresponding attachments
1195 Contributor(s):
1196 Dmitry Yemanov <dimitr at firebirdsql.org>
1197
1198 * Bugfix CORE-6265
1199 Mapping rules destroyed by backup / restore
1200 Contributor(s):
1201 Alex Peshkov <peshkoff at mail.ru>
1202
1203 * Bugfix CORE-6264
1204 GBAK with PIPE to stdout: invalid content if user '-se <host>:service_mgr' command switch
1205 Contributor(s):
1206 Alex Peshkov <peshkoff at mail.ru>
1207
1208 * Bugfix CORE-6260
1209 Warnings are not always displayed in ISQL
1210 Contributor(s):
1211 Alex Peshkov <peshkoff at mail.ru>
1212
1213 * Bugfix CORE-6254
1214 AV in engine when using SET TRANSACTION and ON TRANSACTION START trigger uses EXECUTE STATEMENT against current transaction
1215 Contributor(s):
1216 Vlad Khorsun <hvlad at users.sourceforge.net>
1217
1218 * Bugfix CORE-6253
1219 Crash caused by the locked fb_lock file
1220 Contributor(s):
1221 Vlad Khorsun <hvlad at users.sourceforge.net>
1222
1223 * Bugfix CORE-6252
1224 UNIQUE CONSTRAINT violation
1225 Contributor(s):
1226 Vlad Khorsun <hvlad at users.sourceforge.net>
1227
1228 * Bugfix CORE-6251
1229 Regression: crash when built-in function LEFT() or RIGHT() missed 2nd argument (number of characters to be taken)
1230 Contributor(s):
1231 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1232
1233 * Bugfix CORE-6250
1234 Signature mismatch when creating package body on identical packaged procedure header
1235 Contributor(s):
1236 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1237
1238 * Bugfix CORE-6246
1239 [fbclient] Problem with too many number of columns in resultset
1240 Contributor(s):
1241 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1242
1243 * Bugfix CORE-6233
1244 Wrong dependencies of stored function on view after backup and restore
1245 Contributor(s):
1246 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1247
1248 * Bugfix CORE-6231
1249 Access violation on shutdown of XNET connection to local database when events have been registered
1250 Contributor(s):
1251 Vlad Khorsun <hvlad at users.sourceforge.net>
1252
1253 * Bugfix CORE-6230
1254 Unable to connect with database if security.db reference is removed from databases.conf file
1255 Contributor(s):
1256 Alex Peshkov <peshkoff at mail.ru>
1257
1258 * Bugfix CORE-6227
1259 isc_info_svc_user_dbpath always returns alias of main security database
1260 Contributor(s):
1261 Alex Peshkov <peshkoff at mail.ru>
1262
1263 * Bugfix CORE-6224
1264 Server may crash due double destruction of the rem_port object
1265 Contributor(s):
1266 Vlad Khorsun <hvlad at users.sourceforge.net>
1267
1268 * Bugfix CORE-6221
1269 Incorrect (throw-based) allocFunc for zlib1 (possible memory leak)
1270 Contributor(s):
1271 Alex Peshkov <peshkoff at mail.ru>
1272
1273 * Bugfix CORE-6217
1274 [inet.cpp] Wrong work with pointer: delete ptr; ptr=new ;
1275 Contributor(s):
1276 Alex Peshkov <peshkoff at mail.ru>
1277
1278 * Bugfix CORE-6212
1279 Authentication plugin on server may get garbage data from client instead of empty packet
1280 Contributor(s):
1281 Alex Peshkov <peshkoff at mail.ru>
1282
1283 * Bugfix CORE-6208
1284 CREATE DATABASE grant is lost in security.db after backup/restore cycle
1285 Contributor(s):
1286 Alex Peshkov <peshkoff at mail.ru>
1287
1288 * Bugfix CORE-6189
1289 Building bundled libtommath fails
1290 Contributor(s):
1291 Alex Peshkov <peshkoff at mail.ru>
1292
1293 * Bugfix CORE-6130
1294 Creating backup to stdout using service manager is broken
1295 Contributor(s):
1296 Alex Peshkov <peshkoff at mail.ru>
1297
1298 * Bugfix CORE-6116
1299 Metadata script extracted using ISQL -X of a database restored from a FB 2.5 backup is invalid when a table has COMPUTED BY field
1300 Contributor(s):
1301 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1302
1303 * Bugfix CORE-6110
1304 64-bit transaction IDs are not stored properly in the status vector
1305 Contributor(s):
1306 Ilya Eremin <ilya071294 at gmail.com>
1307
1308 * Bugfix CORE-5972
1309 External engine trigger crashing server if a table has computed field
1310 Contributor(s):
1311 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1312
1313 * Bugfix CORE-5862
1314 VARCHAR computed column without explicit type does not populate RDB$CHARACTER_LENGTH
1315 Contributor(s):
1316 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1317
1318 * Bugfix CORE-5364
1319 gfix -online normal <db> does not produce error when there is a parallel SYSDBA attachment
1320 Contributor(s):
1321 Alex Peshkov <peshkoff at mail.ru>
1322
1323 * Bugfix CORE-2251
1324 GBAK doesn't return error code
1325 Contributor(s):
1326 Alex Peshkov <peshkoff at mail.ru>
1327
1328
1329 **************************
1330 * v3.0.5
1331 **************************
1332
1333 * Bugfix CORE-6204
1334 Server crashes because TraceSvcJrd::checkPrivileges can pass NULL in 'alias'
1335 Contributor(s):
1336 Vlad Khorsun <hvlad at users.sourceforge.net>
1337
1338 * Bugfix CORE-6203
1339 "Error reading data from the connection" is raised sometimes when using non-default authentication plugin
1340 Contributor(s):
1341 Alex Peshkov <peshkoff at mail.ru>
1342
1343 * Bugfix CORE-6197
1344 Memory leak in INET_connect()
1345 Contributor(s):
1346 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1347
1348 * Bugfix CORE-6185
1349 Some (wrong ?) parameters of ENCRYPT() leads FB to crash
1350 Contributor(s):
1351 Alex Peshkov <peshkoff at mail.ru>
1352
1353 * Bugfix CORE-6182
1354 Firebird's internal timer incorrectly resets existing timer entries
1355 Contributor(s):
1356 Vlad Khorsun <hvlad at users.sourceforge.net>
1357
1358 * Bugfix CORE-6171
1359 Error "no current record for fetch operation" with queries with aggregated subselect
1360 Contributor(s):
1361 Dmitry Yemanov <dimitr at firebirdsql.org>
1362
1363 * Bugfix CORE-6163
1364 Generator pages are not encrypted
1365 Contributor(s):
1366 Alex Peshkov <peshkoff at mail.ru>
1367
1368 * Bugfix CORE-6150
1369 Bugcheck when PK\UK\FK constraint check read record already marked as damaged
1370 Contributor(s):
1371 Vlad Khorsun <hvlad at users.sourceforge.net>
1372
1373 * Bugfix CORE-6144
1374 Inconsistent behaviour of the NEW context variable in AFTER UPDATE OR DELETE triggers
1375 Contributor(s):
1376 Ilya Eremin <ilya071294 at gmail.com>
1377
1378 * Bugfix CORE-6143
1379 Error 'Multiple maps found for ...' is raised in not appropriate case
1380 Contributor(s):
1381 Alex Peshkov <peshkoff at mail.ru>
1382
1383 * Bugfix CORE-6142
1384 Error "connection lost to database" could happen when application creates few local attachments (using XNET) simultaneously
1385 Contributor(s):
1386 Vlad Khorsun <hvlad at users.sourceforge.net>
1387
1388 * Bugfix CORE-6141
1389 fbsvcmgr action_repair rpr_list_limbo_trans does not show list of transactions in LIMBO state
1390 Contributor(s):
1391 Alex Peshkov <peshkoff at mail.ru>
1392
1393 * Bugfix CORE-6138
1394 Inconsistent behavior regarding visibility of master record on detail inserts
1395 Contributor(s):
1396 Vlad Khorsun <hvlad at users.sourceforge.net>
1397
1398 * Bugfix CORE-6137
1399 Server crashes when it run SQL
1400 Contributor(s):
1401 Vlad Khorsun <hvlad at users.sourceforge.net>
1402
1403 * Bugfix CORE-6134
1404 Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...')
1405 Contributor(s):
1406 Alex Peshkov <peshkoff at mail.ru>
1407
1408 * Bugfix CORE-6122
1409 UDFs in Firebird 3.0.4 on macOS Mojave - when trying to call UDF from fbudf.dylib in isql, a message "Statement failed, SQLSTATE = 39000 invalid request BLR at offset 35" is displayed
1410 Contributor(s):
1411 Paul Beach <pbeach at ibphoenix.com>
1412
1413 * Bugfix CORE-6108
1414 Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters
1415 Contributor(s):
1416 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1417
1418 * Bugfix CORE-6104
1419 Incorrect error "invalid request handle" is thrown when an embedded user doesn't have SELECT permissions
1420 Contributor(s):
1421 Dmitry Yemanov <dimitr at firebirdsql.org>
1422
1423 * Bugfix CORE-6097
1424 Connection does not see itself in the MON$ATTACHMENTS when Domain/Username (using SSPI) is exactly 31 bytes long
1425 Contributor(s):
1426 Dmitry Yemanov <dimitr at firebirdsql.org>
1427
1428 * Bugfix CORE-6090
1429 BLOB fields may be suddenly set to NULLs during UPDATE after a table format change
1430 Contributor(s):
1431 Dmitry Yemanov <dimitr at firebirdsql.org>
1432
1433 * Bugfix CORE-6089
1434 BLOBs are unnecessarily copied during UPDATE after a table format change
1435 Contributor(s):
1436 Dmitry Yemanov <dimitr at firebirdsql.org>
1437
1438 * Bugfix CORE-6087
1439 Problem with casting within UNION
1440 Contributor(s):
1441 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1442
1443 * Bugfix CORE-6086
1444 Creating of the large procedure crashes the server
1445 Contributor(s):
1446 Vlad Khorsun <hvlad at users.sourceforge.net>
1447
1448 * Bugfix CORE-6078
1449 Permissions for CREATE OR ALTER statements are not checked
1450 Contributor(s):
1451 Alex Peshkov <peshkoff at mail.ru>
1452
1453 * Bugfix CORE-6068
1454 Server hangs when compiling big package with error
1455 Contributor(s):
1456 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1457
1458 * Bugfix CORE-6067
1459 Memory leak in fbclient
1460 Contributor(s):
1461 Vlad Khorsun <hvlad at users.sourceforge.net>
1462
1463 * Bugfix CORE-6063
1464 FB3 (protocol 13) returns op_accept instead op_accept_data
1465 Contributor(s):
1466 Dmitry Kovalenko <dmitry.lipetsk at gmail.com>
1467
1468 * Bugfix CORE-6050
1469 When FB 3 fbclient.dll connects to a remote FB 2.5 server, it tries to open local (client-side) directories and files
1470 Contributor(s):
1471 Alex Peshkov <peshkoff at mail.ru>
1472
1473 * Bugfix CORE-6045
1474 Segmentation fault in fbtracemgr when closing it using ctrl-C
1475 Contributor(s):
1476 Alex Peshkov <peshkoff at mail.ru>
1477
1478 * Bugfix CORE-6043
1479 GTTs do not release used space
1480 Contributor(s):
1481 Vlad Khorsun <hvlad at users.sourceforge.net>
1482
1483 * Bugfix CORE-6040
1484 Metadata script extracted using ISQL is invalid/incorrect when table has COMPUTED BY field
1485 Contributor(s):
1486 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1487
1488 * Bugfix CORE-6038
1489 SRP user manager sporadically creates users which can not attach
1490 Contributor(s):
1491 Alex Peshkov <peshkoff at mail.ru>
1492
1493 * Bugfix CORE-6031
1494 Little valgrind memory leak in isc_attach_database
1495 Contributor(s):
1496 Alex Peshkov <peshkoff at mail.ru>
1497
1498 * Bugfix CORE-6028
1499 Trigger on system table is restored in FB3 database and can't be deleted
1500 Contributor(s):
1501 Alex Peshkov <peshkoff at mail.ru>
1502
1503 * Bugfix CORE-6027
1504 Server hangs on new attachment right after trace session stop
1505 Contributor(s):
1506 Alex Peshkov <peshkoff at mail.ru>
1507
1508 * Bugfix CORE-6026
1509 Alignment issue with FB_MESSAGE C++ macro (as well UDR macros) and BIGINT/DECFLOAT types in Linux 32-bits
1510 Contributor(s):
1511 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1512
1513 * Bugfix CORE-6015
1514 Segfault when using expression index with complex expression
1515 Contributor(s):
1516 Alex Peshkov <peshkoff at mail.ru>
1517
1518 * Bugfix CORE-6009
1519 I/O error during "open" operation for file "/tmp/firebird/fb_trace_*" in firebird.log
1520 Contributor(s):
1521 Alex Peshkov <peshkoff at mail.ru>
1522
1523 * Bugfix CORE-6007
1524 Firebird does not build on Mac with fresh toolchain
1525 Contributor(s):
1526 Alex Peshkov <peshkoff at mail.ru>
1527
1528 * Bugfix CORE-6000
1529 GBAK reports "Your user name and password are not defined" when command switch "-fe(tch_password) ..." is specified when run as service
1530 Contributor(s):
1531 Alex Peshkov <peshkoff at mail.ru>
1532
1533 * Bugfix CORE-5995
1534 Creator user name is empty in user trace sessions
1535 Contributor(s):
1536 Vlad Khorsun <hvlad at users.sourceforge.net>
1537
1538 * Bugfix CORE-5993
1539 When creation of audit log file fails, there is no error message in firebird.log
1540 Contributor(s):
1541 Vlad Khorsun <hvlad at users.sourceforge.net>
1542
1543 * Bugfix CORE-5991
1544 Trace could not work correctly with quoted file names in trace configurations
1545 Contributor(s):
1546 Vlad Khorsun <hvlad at users.sourceforge.net>
1547
1548 * Bugfix CORE-5989
1549 iconv / libiconv 1.15 vs libc / libiconv_open | common/isc_file.cpp
1550 Contributor(s):
1551 Alex Peshkov <peshkoff at mail.ru>
1552
1553 * Bugfix CORE-5986
1554 Incorrect evaluation of NULL IS [NOT] {FALSE | TRUE}
1555 Contributor(s):
1556 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1557
1558 * Bugfix CORE-5985
1559 Regression: ROLE does not passed in ES/EDS (specifying it in the statement is ignored)
1560 Contributor(s):
1561 Alex Peshkov <peshkoff at mail.ru>
1562
1563 * Bugfix CORE-5982
1564 Read permission error for a BLOB field, when it's input/output procedure's parameter
1565 Contributor(s):
1566 Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
1567
1568 * Bugfix CORE-5980
1569 Firebird crashes due to concurrent operations with expression indices
1570 Contributor(s):
1571 Vlad Khorsun <hvlad at users.sourceforge.net>
1572
1573 * Bugfix CORE-5972
1574 External engine trigger crashing server if table have computed field
1575 Contributor(s):
1576 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1577
1578 * Bugfix CORE-5966
1579 Slow performance when executing SQL scripts as non-SYSDBA user
1580 Contributor(s):
1581 Alex Peshkov <peshkoff at mail.ru>
1582
1583 * Bugfix CORE-5965
1584 FB 3.0 optimizer chooses less efficient plan than FB 2.5 optimizer
1585 Contributor(s):
1586 Dmitry Yemanov <dimitr at firebirdsql.org>
1587
1588 * Bugfix CORE-5959
1589 Firebird returns wrong time after changes of time zone
1590 Contributor(s):
1591 Vlad Khorsun <hvlad at users.sourceforge.net>
1592
1593 * Bugfix CORE-5955
1594 Unable to init binreloc with ld >= 2.31
1595 Contributor(s):
1596 Roman Simakov <roman.simakov at red-soft.biz>
1597
1598 * Bugfix CORE-5950
1599 Deadlock when attaching to bugchecked database
1600 Contributor(s):
1601 Alex Peshkov <peshkoff at mail.ru>
1602
1603 * Bugfix CORE-5949
1604 Bugcheck could happen when read-only database with non-zero linger is set to read-write mode
1605 Contributor(s):
1606 Vlad Khorsun <hvlad at users.sourceforge.net>
1607
1608 * Bugfix CORE-5943
1609 Server crashes preparing a query with both DISTINCT/ORDER BY and non-field expression in the select list
1610 Contributor(s):
1611 Dmitry Yemanov <dimitr at firebirdsql.org>
1612
1613 * Bugfix CORE-5936
1614 Firebird server segfaults in the end of database backup
1615 Contributor(s):
1616 Vlad Khorsun <hvlad at users.sourceforge.net>
1617
1618 * Bugfix CORE-5935
1619 Bugcheck 165 (cannot find tip page)
1620 Contributor(s):
1621 Vlad Khorsun <hvlad at users.sourceforge.net>
1622
1623 * Bugfix CORE-5934
1624 gpre_boot fails to link using cmake, undefined reference 'dladdr' and 'dlerror'
1625 Contributor(s):
1626 Alex Peshkov <peshkoff at mail.ru>
1627
1628 * Bugfix CORE-5927
1629 With some non-standard authentication plugins providing correct crypt key wire anyway remains not encrypted
1630 Contributor(s):
1631 Alex Peshkov <peshkoff at mail.ru>
1632
1633 * Bugfix CORE-5926
1634 Attempt to create mapping with non-ASCII user name which is encoded in single-byte codepage (win1251) leads to the 'malformed string' error
1635 Contributor(s):
1636 Alex Peshkov <peshkoff at mail.ru>
1637
1638 * Bugfix CORE-5918
1639 Memory pool statistics is not accurate
1640 Contributor(s):
1641 Alex Peshkov <peshkoff at mail.ru>
1642
1643 * Bugfix CORE-5907
1644 Regression: can not launch trace if its 'database' section contains regexp pattern with curvy brackets to enclose quantifier
1645 Contributor(s):
1646 Alex Peshkov <peshkoff at mail.ru>
1647
1648 * Bugfix CORE-5902
1649 Add Firebird Event fails with error "While isc_que_events - Failed to establish a secondary connection for event processing."
1650 Contributor(s):
1651 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1652 Vlad Khorsun <hvlad at users.sourceforge.net>
1653
1654 * Bugfix CORE-5888
1655 Firebird server on Android has problem with numerics
1656 Contributor(s):
1657 Alex Peshkov <peshkoff at mail.ru>
1658
1659 * Bugfix CORE-5845
1660 ORDER BY on index can cause suboptimal index choices
1661 Contributor(s):
1662 Dmitry Yemanov <dimitr at firebirdsql.org>
1663
1664 * Bugfix CORE-5823
1665 No permission for SELECT access to blob field in stored procedure
1666 Contributor(s):
1667 Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
1668
1669 * Bugfix CORE-5800
1670 Indices by expression on computed field are not working properly after backup/restore
1671 Contributor(s):
1672 Dmitry Yemanov <dimitr at firebirdsql.org>
1673
1674 * Bugfix CORE-5795
1675 ORDER BY clause on compound index may disable usage of other indices
1676 Contributor(s):
1677 Dmitry Yemanov <dimitr at firebirdsql.org>
1678
1679 * Bugfix CORE-5784
1680 Lock folder inizialization is not multi-process safe
1681 Contributor(s):
1682 Alex Peshkov <peshkoff at mail.ru>
1683
1684 * Bugfix CORE-5639
1685 Mapping rule using WIN_SSPI plugin: windows user group conversion to firebird role does not work
1686 Contributor(s):
1687 Alex Peshkov <peshkoff at mail.ru>
1688
1689 * Bugfix CORE-5395
1690 Invalid data type for negation (minus operator)
1691 Contributor(s):
1692 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1693 Dmitry Yemanov <dimitr at firebirdsql.org>
1694
1695 * Bugfix CORE-5118
1696 Indices on computed fields are broken after restore (all keys are NULL)
1697 Contributor(s):
1698 Dmitry Yemanov <dimitr at firebirdsql.org>
1699
1700 * Bugfix CORE-5074
1701 Lost the charset ID in selection of array element
1702 Contributor(s):
1703 Dmitry Kovalenko <dmitry.lipetsk at gmail.com>
1704
1705 * Bugfix CORE-5070
1706 Compound index cannot be used for filtering in some ORDER/GROUP BY queries
1707 Contributor(s):
1708 Dmitry Yemanov <dimitr at firebirdsql.org>
1709
1710 * Bugfix CORE-3925
1711 Creating self-referential FK crashes database (bug-check) whether constraint violation had place
1712 Contributor(s):
1713 Vlad Khorsun <hvlad at users.sourceforge.net>
1714
1715 * Bugfix CORE-2440
1716 Restoring DB with computed index on computed field provides wrong index and wrong select results
1717 Contributor(s):
1718 Dmitry Yemanov <dimitr at firebirdsql.org>
1719
1720 * Improvement CORE-6072
1721 Ensure providers compatibility across versions
1722 Contributor(s):
1723 Alex Peshkov <peshkoff at mail.ru>
1724
1725 * Improvement CORE-6004
1726 Add a configuration switch to disable the "TCP Loopback Fast Path" option (Windows only)
1727 Contributor(s):
1728 KarloX2 <info at ait-software.de>
1729
1730 * Improvement CORE-5948
1731 Make WIN_SSPI plugin produce keys for the wirecrypt plugin
1732 Contributor(s):
1733 Alex Peshkov <peshkoff at mail.ru>
1734
1735 * Improvement CORE-5928
1736 Make it possible for AuthClient plugin to access authentication block from DPB
1737 Contributor(s):
1738 Alex Peshkov <peshkoff at mail.ru>
1739
1740 * Improvement CORE-5741
1741 Replace word "fixing" with "adjusting" in GBAK output
1742 Contributor(s):
1743 Alex Peshkov <peshkoff at mail.ru>
1744
1745 * Improvement CORE-5724
1746 Add ability to use "install.sh -path /opt/my_path" without need to install FB first in the default folder ("/opt/firebird")
1747 Contributor(s):
1748 Alex Peshkov <peshkoff at mail.ru>
1749
1750 * Improvement CORE-4462
1751 Make it possible to restore compressed .nbk files without explicitly decompressing them
1752 Contributor(s):
1753 Alex Peshkov <peshkoff at mail.ru>
1754 Vlad Khorsun <hvlad at users.sourceforge.net>
1755
1756
1757 **************************
1758 * v3.0.4
1759 **************************
1760
1761 * Bugfix CORE-5911
1762 Connection could hung after no activity for 60 seconds
1763 Contributor(s):
1764 Vlad Khorsun <hvlad at users.sourceforge.net>
1765
1766 * Bugfix CORE-5905
1767 Inconsistencies with PSQL FUNCTION vs UDF
1768 Contributor(s):
1769 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1770
1771 * Bugfix CORE-5904
1772 An attempt to create global mapping with long (> SQL identifier length) FROM field fails
1773 Contributor(s):
1774 Alex Peshkov <peshkoff at mail.ru>
1775
1776 * Bugfix CORE-5900
1777 Login attempts while engine is shutting down caused unnecessary delays in shutdown process
1778 Contributor(s):
1779 Alex Peshkov <peshkoff at mail.ru>
1780
1781 * Bugfix CORE-5899
1782 Memory leak in GBAK code when used as service
1783 Contributor(s):
1784 Alex Peshkov <peshkoff at mail.ru>
1785
1786 * Bugfix CORE-5898
1787 ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
1788 Contributor(s):
1789 Vlad Khorsun <hvlad at users.sourceforge.net>
1790
1791 * Bugfix CORE-5893
1792 GBAK may crash database when mixing alias with full database name
1793 Contributor(s):
1794 Alex Peshkov <peshkoff at mail.ru>
1795
1796 * Bugfix CORE-5891
1797 Invalid events are released in mapping shared memory when dead process is detected
1798 Contributor(s):
1799 Alex Peshkov <peshkoff at mail.ru>
1800
1801 * Bugfix CORE-5886
1802 Nbackup does not work after 32K of backups iterations
1803 Contributor(s):
1804 Alex Peshkov <peshkoff at mail.ru>
1805
1806 * Bugfix CORE-5884
1807 Initial global mapping from Srp plugin does not work
1808 Contributor(s):
1809 Alex Peshkov <peshkoff at mail.ru>
1810
1811 * Bugfix CORE-5881
1812 Network server ignores any error that took place in KeyHolderPlugin when establishing initial callback with client
1813 Contributor(s):
1814 Alex Peshkov <peshkoff at mail.ru>
1815
1816 * Bugfix CORE-5880
1817 Unhandled: C0000005.ACCESS_VIOLATION
1818 Contributor(s):
1819 Vlad Khorsun <hvlad at users.sourceforge.net>
1820
1821 * Bugfix CORE-5879
1822 Error reading/writing data to connection
1823 Contributor(s):
1824 Vlad Khorsun <hvlad at users.sourceforge.net>
1825
1826 * Bugfix CORE-5872
1827 Database validation reports false errors "Record XXX has bad transaction" and\or "Record XXX is wrong length" when record transaction number is greater than 2^32
1828 Contributor(s):
1829 Vlad Khorsun <hvlad at users.sourceforge.net>
1830
1831 * Bugfix CORE-5870
1832 ISQL's "show database" command works wrong with 64-bit numbers
1833 Contributor(s):
1834 Vlad Khorsun <hvlad at users.sourceforge.net>
1835
1836 * Bugfix CORE-5869
1837 Sweep can't move OIT value over 2^32, when Next already greater than 2^32 (4'294'967'296)
1838 Contributor(s):
1839 Vlad Khorsun <hvlad at users.sourceforge.net>
1840
1841 * Bugfix CORE-5865
1842 Alignment error on x86_64
1843 Contributor(s):
1844 Alex Peshkov <peshkoff at mail.ru>
1845
1846 * Bugfix CORE-5863
1847 Classic process crashes when client has disconnected
1848 Contributor(s):
1849 Vlad Khorsun <hvlad at users.sourceforge.net>
1850
1851 * Bugfix CORE-5852
1852 There is no check of existance generator and exception when privileges are granted
1853 Contributor(s):
1854 Roman Simakov <roman.simakov at red-soft.biz>
1855
1856 * Bugfix CORE-5847
1857 "Malformed string" instead of key value in PK violation error message
1858 Contributor(s):
1859 Vlad Khorsun <hvlad at users.sourceforge.net>
1860
1861 * Bugfix CORE-5846
1862 CREATE VIEW issues "Implementation of text subtype 512 not located"
1863 Contributor(s):
1864 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1865
1866 * Bugfix CORE-5844
1867 Firebird freezes for new connections
1868 Contributor(s):
1869 Vlad Khorsun <hvlad at users.sourceforge.net>
1870
1871 * Bugfix CORE-5843
1872 Wrong handling of failures of TRANSACTION START trigger
1873 Contributor(s):
1874 Vlad Khorsun <hvlad at users.sourceforge.net>
1875
1876 * Bugfix CORE-5840
1877 Reference privilege is ignored
1878 Contributor(s):
1879 Roman Simakov <roman.simakov at red-soft.biz>
1880
1881 * Bugfix CORE-5837
1882 Inconsistent results when working with GLOBAL TEMPORARY TABLE ON COMMIT PRESERVE ROWS
1883 Contributor(s):
1884 Vlad Khorsun <hvlad at users.sourceforge.net>
1885
1886 * Bugfix CORE-5833
1887 DDL triggers for some object types (views, exceptions, roles, indexes, domains) are lost in backup-restore process
1888 Contributor(s):
1889 Adriano dos Santos Fernandes <adrianosf at gmail.com>
1890
1891 * Bugfix CORE-5831
1892 Not user-friendly output of GSTAT at encrypted database
1893 Contributor(s):
1894 Alex Peshkov <peshkoff at mail.ru>
1895
1896 * Bugfix CORE-5830
1897 Encryption Interface crashing Firebird process when working on big db file
1898 Contributor(s):
1899 Alex Peshkov <peshkoff at mail.ru>
1900
1901 * Bugfix CORE-5829
1902 GSEC does not release user manager plugin
1903 Contributor(s):
1904 Alex Peshkov <peshkoff at mail.ru>
1905
1906 * Bugfix CORE-5824
1907 Segmentation fault during install on Linux
1908 Contributor(s):
1909 Alex Peshkov <peshkoff at mail.ru>
1910
1911 * Bugfix CORE-5822
1912 Client gets SQLSTATE = 28000 ("user/password not defined") if WireCrypt = Disabled is used on client side
1913 Contributor(s):
1914 Alex Peshkov <peshkoff at mail.ru>
1915
1916 * Bugfix CORE-5819
1917 Attachment might not gone after it was deleted FROM MON$ATTACHMENTS
1918 Contributor(s):
1919 Vlad Khorsun <hvlad at users.sourceforge.net>
1920
1921 * Bugfix CORE-5817
1922 Unable to compile Firebird with ICU 60 or higer
1923 Contributor(s):
1924 Alex Peshkov <peshkoff at mail.ru>
1925
1926 * Bugfix CORE-5815
1927 Server hangs for 60/120 seconds if client exits during database encryption key transfer callback
1928 Contributor(s):
1929 Alex Peshkov <peshkoff at mail.ru>
1930
1931 * Bugfix CORE-5804
1932 Multiple errors in REVOKE operator
1933 Contributor(s):
1934 Roman Simakov <roman.simakov at red-soft.biz>
1935
1936 * Bugfix CORE-5801
1937 All database blobs can be acceses by any user (id iteration may be used for unauthorized access)
1938 Contributor(s):
1939 Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
1940
1941 * Bugfix CORE-5796
1942 GSTAT may produce faulty report about presence of some none-encrypted pages in database
1943 Contributor(s):
1944 Alex Peshkov <peshkoff at mail.ru>
1945
1946 * Bugfix CORE-5793
1947 Error returned from DbCryptPlugin::setKey() is not shown
1948 Contributor(s):
1949 Alex Peshkov <peshkoff at mail.ru>
1950
1951 * Bugfix CORE-5791
1952 ODS for windows builds and linux-x64 (on the one side) and linux-x86 (on the other side) does not match
1953 Contributor(s):
1954 Alex Peshkov <peshkoff at mail.ru>
1955
1956 * Bugfix CORE-5790
1957 User with DROP DATABASE privilege can't drop database
1958 Contributor(s):
1959 Roman Simakov <roman.simakov at red-soft.biz>
1960
1961 * Bugfix CORE-5788
1962 Security Patch: Replacement of use of SHA-1 in the SRP Client Proof with SHA-256
1963 Contributor(s):
1964 Tony Whyman <tony.whyman at mccallumwhyman.com>
1965 Alex Peshkov <peshkoff at mail.ru>
1966
1967 * Bugfix CORE-5783
1968 EXECUTE STATEMENT ignores the text of the SQL-query after a comment of the form "-"
1969 Contributor(s):
1970 Vlad Khorsun <hvlad at users.sourceforge.net>
1971
1972 * Bugfix CORE-5780
1973 Server hangs when client tries to send too long DB encryption key(s)
1974 Contributor(s):
1975 Alex Peshkov <peshkoff at mail.ru>
1976
1977 * Bugfix CORE-5778
1978 install.sh fails if -path argument contains "firebird"
1979 Contributor(s):
1980 Alex Peshkov <peshkoff at mail.ru>
1981
1982 * Bugfix CORE-5776
1983 "Input parameter mismatch" error after altering external function into PSQL function
1984 Contributor(s):
1985 Vlad Khorsun <hvlad at users.sourceforge.net>
1986
1987 * Bugfix CORE-5773
1988 PSQL cursor doesn't see inserted record
1989 Contributor(s):
1990 Vlad Khorsun <hvlad at users.sourceforge.net>
1991
1992 * Bugfix CORE-5772
1993 Client hangs when working with events under high load
1994 Contributor(s):
1995 Alex Peshkov <peshkoff at mail.ru>
1996
1997 * Bugfix CORE-5769
1998 Database crypt plugin sample on Pascal is broken
1999 Contributor(s):
2000 Alex Peshkov <peshkoff at mail.ru>
2001
2002 * Bugfix CORE-5765
2003 Missing directives in Firebird.pas
2004 Contributor(s):
2005 Tony Whyman <tony.whyman at mccallumwhyman.com>
2006 Alex Peshkov <peshkoff at mail.ru>
2007
2008 * Bugfix CORE-5764
2009 Installation of Firebird 3.0.3 on SLES 12 SP3 fails with ''Could not find acceptable ICU library"
2010 Contributor(s):
2011 Alex Peshkov <peshkoff at mail.ru>
2012
2013 * Bugfix CORE-5762
2014 Wrong transaction number in RDB$PAGES relation may cause infinite recusrion in engine and segfault
2015 Contributor(s):
2016 Alex Peshkov <peshkoff at mail.ru>
2017
2018 * Bugfix CORE-5760
2019 Server process crashes while restoring database
2020 Contributor(s):
2021 Vlad Khorsun <hvlad at users.sourceforge.net>
2022
2023 * Bugfix CORE-5757
2024 Deadlock with events
2025 Contributor(s):
2026 Alex Peshkov <peshkoff at mail.ru>
2027
2028 * Bugfix CORE-5756
2029 FB crashes when trying to recreate table that is in use by DML
2030 Contributor(s):
2031 Dmitry Yemanov <dimitr at firebirdsql.org>
2032
2033 * Bugfix CORE-5755
2034 No error if the GRANT target object does not exist
2035 Contributor(s):
2036 Roman Simakov <roman.simakov at red-soft.biz>
2037
2038 * Bugfix CORE-5754
2039 ALTER TRIGGER check privilege for alter database instead of table
2040 Contributor(s):
2041 Roman Simakov <roman.simakov at red-soft.biz>
2042
2043 * Bugfix CORE-5753
2044 Parser should not allow to use GRANT OPTION for FUNCTION and PACKAGE
2045 Contributor(s):
2046 Roman Simakov <roman.simakov at red-soft.biz>
2047
2048 * Bugfix CORE-5747
2049 User can grant usage privilege by himself
2050 Contributor(s):
2051 Roman Simakov <roman.simakov at red-soft.biz>
2052
2053 * Bugfix CORE-5745
2054 GRANT privileges error during database restore
2055 Contributor(s):
2056 Alex Peshkov <peshkoff at mail.ru>
2057
2058 * Bugfix CORE-5743
2059 Conversion error when both GROUP/ORDER BY expressions and WHERE expressions contain literals
2060 Contributor(s):
2061 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2062
2063 * Bugfix CORE-5742
2064 Incorrect error message in iSQL when trying to create database with wrong password
2065 Contributor(s):
2066 Alex Peshkov <peshkoff at mail.ru>
2067
2068 * Bugfix CORE-5737
2069 Invalid parameters of gds transaction in ISQL
2070 Contributor(s):
2071 Alex Peshkov <peshkoff at mail.ru>
2072
2073 * Bugfix CORE-5702
2074 Firebird Handle Leak Windows
2075 Contributor(s):
2076 Vlad Khorsun <hvlad at users.sourceforge.net>
2077
2078 * Bugfix CORE-5436
2079 SuperClassic server hangs (under load test)
2080 Contributor(s):
2081 Vlad Khorsun <hvlad at users.sourceforge.net>
2082
2083 * Bugfix CORE-4964
2084 Real errors during connect to security database are hidden by Srp user manager
2085 Contributor(s):
2086 Alex Peshkov <peshkoff at mail.ru>
2087
2088 * Bugfix CORE-405
2089 Garbage vs indices/constraints
2090 Contributor(s):
2091 Vlad Khorsun <hvlad at users.sourceforge.net>
2092
2093 * Improvement CORE-5913
2094 Add context variables with compression and encryption status of current connection
2095 Contributor(s):
2096 Vlad Khorsun <hvlad at users.sourceforge.net>
2097
2098 * Improvement CORE-5908
2099 Enhance dynamic libraries loading related error messages
2100 Contributor(s):
2101 Alex Peshkov <peshkoff at mail.ru>
2102
2103 * Improvement CORE-5876
2104 Provide name of udf function for "arithmetic exception, numeric overflow, or string truncation"
2105 Contributor(s):
2106 Alex Peshkov <peshkoff at mail.ru>
2107
2108 * Improvement CORE-5860
2109 Support auth_plugin_list dpb/spb item from application to client
2110 Contributor(s):
2111 Alex Peshkov <peshkoff at mail.ru>
2112
2113 * Improvement CORE-5853
2114 Forward-compatible expressions LOCALTIME and LOCALTIMESTAMP
2115 Contributor(s):
2116 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2117
2118 * Improvement CORE-5746
2119 Remove the restriction on create/delete, enable/disable the user-defined indexes in system tables
2120 Contributor(s):
2121 Rashid Abzalov <rashid.abzalov at gmail.com>
2122 Vlad Khorsun <hvlad at users.sourceforge.net>
2123
2124
2125 **************************
2126 * v3.0.3
2127 **************************
2128
2129 * Bugfix CORE-5735
2130 Additional keyholder opens unauthorized connections to encrypted database
2131 Contributor(s):
2132 Alex Peshkov <peshkoff at mail.ru>
2133
2134 * Bugfix CORE-5730
2135 Connection to server may hang when working with encrypted databases over non-TCP protocol
2136 Contributor(s):
2137 Alex Peshkov <peshkoff at mail.ru>
2138
2139 * Bugfix CORE-5721
2140 Information items isc_info_length and fb_info_crypt_state have the same code
2141 Contributor(s):
2142 Alex Peshkov <peshkoff at mail.ru>
2143
2144 * Bugfix CORE-5720
2145 Sweep in Firebird 3 in CS mode could run too slow when there is big load on server
2146 Contributor(s):
2147 Vlad Khorsun <hvlad at users.sourceforge.net>
2148
2149 * Bugfix CORE-5719
2150 FB 3 crashes when restoring backup made by FB 2.5
2151 Contributor(s):
2152 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2153
2154 * Bugfix CORE-5713
2155 Field alias disappears in complex query
2156 Contributor(s):
2157 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2158
2159 * Bugfix CORE-5707
2160 Begin and end of physical backup in the same transaction could crash engine
2161 Contributor(s):
2162 Vlad Khorsun <hvlad at users.sourceforge.net>
2163
2164 * Bugfix CORE-5706
2165 Trace config with misplaced "{" lead Firebird to crash
2166 Contributor(s):
2167 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2168
2169 * Bugfix CORE-5695
2170 Position function does not consider the collation for blob
2171 Contributor(s):
2172 Vlad Khorsun <hvlad at users.sourceforge.net>
2173
2174 * Bugfix CORE-5694
2175 Duplicate values in columns with a unique constraint
2176 Contributor(s):
2177 Vlad Khorsun <hvlad at users.sourceforge.net>
2178
2179 * Bugfix CORE-5686
2180 Firebird 3.0.2 allows any protocol version >= 10 to connect, including interbase protocol 14
2181 Contributor(s):
2182 Mark Rotteveel <mark at lawinegevaar.nl>
2183
2184 * Bugfix CORE-5684
2185 Error "no current record for fetch operation" is raised while deleting record from MON$ATTACHMENTS using ORDER BY clause
2186 Contributor(s):
2187 Dmitry Yemanov <dimitr at firebirdsql.org>
2188
2189 * Bugfix CORE-5681
2190 AV when external statement is executed and local transaction is rolled back
2191 Contributor(s):
2192 Vlad Khorsun <hvlad at users.sourceforge.net>
2193
2194 * Bugfix CORE-5675
2195 isc_vax_integer() and isc_portable_integer() work wrongly with short negative numbers
2196 Contributor(s):
2197 Dimitry Sibiryakov <sd at ibphoenix.com>
2198
2199 * Bugfix CORE-5673
2200 Unique constraint not working in encrypted database on first command
2201 Contributor(s):
2202 Alex Peshkov <peshkoff at mail.ru>
2203
2204 * Bugfix CORE-5667
2205 Message "CTE 'X' has cyclic dependencies" appear when 'X' is alias for resultset and there is previous CTE part with the same name 'X' in the query
2206 Contributor(s):
2207 Vlad Khorsun <hvlad at users.sourceforge.net>
2208
2209 * Bugfix CORE-5659
2210 Bad PLAN generated for query on Firebird v3.0
2211 Contributor(s):
2212 Dmitry Yemanov <dimitr at firebirdsql.org>
2213
2214 * Bugfix CORE-5655
2215 isc_info_sql_relation_alias reports incorrect alias for CTE or nested queries
2216 Contributor(s):
2217 Vlad Khorsun <hvlad at users.sourceforge.net>
2218
2219 * Bugfix CORE-5654
2220 Mixed intermediate build files for plugins examples
2221 Contributor(s):
2222 Alex Peshkov <peshkoff at mail.ru>
2223
2224 * Bugfix CORE-5653
2225 GBAK restore with large number of small blobs is very slow using Linux Classic
2226 Contributor(s):
2227 Roman Simakov <roman.simakov at red-soft.biz>
2228
2229 * Bugfix CORE-5651
2230 Problem migrating users to V3.0
2231 Contributor(s):
2232 Alex Peshkov <peshkoff at mail.ru>
2233
2234 * Bugfix CORE-5650
2235 Segfault when procedure is being dropped on Classic server
2236 Contributor(s):
2237 Alex Peshkov <peshkoff at mail.ru>
2238
2239 * Bugfix CORE-5649
2240 isc_add_user / isc_modify_user produce unusable user record
2241 Contributor(s):
2242 Alex Peshkov <peshkoff at mail.ru>
2243
2244 * Bugfix CORE-5645
2245 Wrong transaction can be passed to the external engine
2246 Contributor(s):
2247 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2248
2249 * Bugfix CORE-5643
2250 Message "Operating system call munmap failed" can appear in firebird.log under heavy load (2.5.x, CS, SC)
2251 Contributor(s):
2252 Alex Peshkov <peshkoff at mail.ru>
2253
2254 * Bugfix CORE-5638
2255 Wrong result with index on case-insensitive collation using NUMERIC-SORT
2256 Contributor(s):
2257 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2258
2259 * Bugfix CORE-5630
2260 Cannot create the shadow file
2261 Contributor(s):
2262 Alex Peshkov <peshkoff at mail.ru>
2263
2264 * Bugfix CORE-5624
2265 Using backslash in alias on Linux does not work
2266 Contributor(s):
2267 Alex Peshkov <peshkoff at mail.ru>
2268
2269 * Bugfix CORE-5618
2270 Part of the pages of the second level blobs is not released when deleting relations
2271 Contributor(s):
2272 Denis Logashov <den.logash at gmail.com>
2273
2274 * Bugfix CORE-5613
2275 SuperServer could hung when changing physical backup state under high load
2276 Contributor(s):
2277 Vlad Khorsun <hvlad at users.sourceforge.net>
2278
2279 * Bugfix CORE-5605
2280 Incorrect check for existing MAP in a case when pre-FB3 security database is used
2281 Contributor(s):
2282 Alex Peshkov <peshkoff at mail.ru>
2283
2284 * Bugfix CORE-5600
2285 Invalid blob id when add a new blob column of type text and update another field
2286 Contributor(s):
2287 Vlad Khorsun <hvlad at users.sourceforge.net>
2288
2289 * Bugfix CORE-5598
2290 Error "block size exceeds implementation restriction" while inner joining large datasets with a long key using the HASH JOIN plan
2291 Contributor(s):
2292 Dmitry Yemanov <dimitr at firebirdsql.org>
2293
2294 * Bugfix CORE-5591
2295 Engine hangs soon after some errors during transaction start
2296 Contributor(s):
2297 Alex Peshkov <peshkoff at mail.ru>
2298
2299 * Bugfix CORE-5588
2300 DbInfo interface is not passed to ancillary instances of plugin
2301 Contributor(s):
2302 Alex Peshkov <peshkoff at mail.ru>
2303
2304 * Bugfix CORE-5580
2305 Signature of packaged functions is not checked for mismatch with [NOT] DETERMINISTIC attribute
2306 Contributor(s):
2307 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2308
2309 * Bugfix CORE-5579
2310 Request synchronization error in the GBAK utility (during restore)
2311 Contributor(s):
2312 Vlad Khorsun <hvlad at users.sourceforge.net>
2313
2314 * Bugfix CORE-5576
2315 Bugcheck on queries containing WITH LOCK clause
2316 Contributor(s):
2317 Roman Simakov <roman.simakov at red-soft.biz>
2318
2319 * Bugfix CORE-5570
2320 Negative infinity (double) shown incorrectly without sign in ISQL
2321 Contributor(s):
2322 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2323
2324 * Bugfix CORE-5569
2325 ISQL incorrectly pads UNICODE_FSS/UTF8 columns when they use a collation
2326 Contributor(s):
2327 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2328
2329 * Bugfix CORE-5567
2330 Direct system table modifications are not completely prohibited
2331 Contributor(s):
2332 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2333
2334 * Bugfix CORE-5566
2335 Server crashes while restoring backup if the shadow file already exists
2336 Contributor(s):
2337 Dmitry Yemanov <dimitr at firebirdsql.org>
2338
2339 * Bugfix CORE-5562
2340 Firebird crashes when UDF gets loaded and unloaded frequently
2341 Contributor(s):
2342 Alex Peshkov <peshkoff at mail.ru>
2343
2344 * Bugfix CORE-5555
2345 Firebird 3 error handling for SELECT WITH LOCK breaks compatibility with 2.5
2346 Contributor(s):
2347 Vlad Khorsun <hvlad at users.sourceforge.net>
2348
2349 * Bugfix CORE-5553
2350 Database cannot be encrypted if DatabaseAccess is set to None
2351 Contributor(s):
2352 Alex Peshkov <peshkoff at mail.ru>
2353
2354 * Bugfix CORE-5550
2355 Computed decimal field in a view has wrong RDB$FIELD_PRECISION
2356 Contributor(s):
2357 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2358
2359 * Bugfix CORE-5549
2360 Errors building / running FB on non-SSE enabled HW
2361 Contributor(s):
2362 Alex Peshkov <peshkoff at mail.ru>
2363
2364 * Bugfix CORE-5547
2365 Server crashes while compiling stored procedure with nested references to query-based computed fields
2366 Contributor(s):
2367 Dmitry Yemanov <dimitr at firebirdsql.org>
2368
2369 * Bugfix CORE-5542
2370 Database-level triggers related to TRANSACTION events (start/commit/rollback) do not take in account their POSITION index
2371 Contributor(s):
2372 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2373
2374 * Bugfix CORE-5540
2375 Every other execution of embedded ISQL is slow
2376 Contributor(s):
2377 Vlad Khorsun <hvlad at users.sourceforge.net>
2378
2379 * Bugfix CORE-5535
2380 Garbage value in RDB$FIELD_SUB_TYPE in RDB$FUNCTION_ARGUMENTS after altering function
2381 Contributor(s):
2382 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2383
2384 * Bugfix CORE-5533
2385 Crash on 3.0 and 4.0 when DB contains database-level trigger
2386 Contributor(s):
2387 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2388
2389 * Bugfix CORE-5528
2390 internal Firebird consistency check (limbo impossible (184), file: vio.cpp line: 2379)
2391 Contributor(s):
2392 Vlad Khorsun <hvlad at users.sourceforge.net>
2393
2394 * Bugfix CORE-5527
2395 External routines does not receive default values for they output parameters
2396 Contributor(s):
2397 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2398
2399 * Bugfix CORE-5526
2400 External routines receives parameters with incorrect length or datatype
2401 Contributor(s):
2402 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2403
2404 * Bugfix CORE-5521
2405 Race condition between event notification and event registration
2406 Contributor(s):
2407 Vlad Khorsun <hvlad at users.sourceforge.net>
2408
2409 * Bugfix CORE-5517
2410 Classic server periodically raise "Global mapping memory overflow" and need to be restarted to accept new connections
2411 Contributor(s):
2412 Alex Peshkov <peshkoff at mail.ru>
2413
2414 * Bugfix CORE-5516
2415 Firebird service crashes when stopping
2416 Contributor(s):
2417 Vlad Khorsun <hvlad at users.sourceforge.net>
2418
2419 * Bugfix CORE-5510
2420 Firebird 3+ may send status vector with more then 20 items to old clients and cause disconnect
2421 Contributor(s):
2422 Roman Simakov <roman.simakov at red-soft.biz>
2423
2424 * Bugfix CORE-5416
2425 Memory leak: Firebird does not release memory after load tests
2426 Contributor(s):
2427 Vlad Khorsun <hvlad at users.sourceforge.net>
2428
2429 * Bugfix CORE-5415
2430 [security3.fdb] wrong page type page 22 is of wrong type (expected pointer, found index root)
2431 Contributor(s):
2432 Vlad Khorsun <hvlad at users.sourceforge.net>
2433
2434 * Bugfix CORE-4492
2435 OR/IN predicates for RDB$DBKEY lead to NATURAL plan
2436 Contributor(s):
2437 Dmitry Yemanov <dimitr at firebirdsql.org>
2438
2439 * Bugfix CORE-2853
2440 Bugcheck: page N, page type 5 lock conversion denied (215)
2441 Contributor(s):
2442 Vlad Khorsun <hvlad at users.sourceforge.net>
2443
2444 * Bugfix CORE-2731
2445 Recursive EXECUTE STATEMENT works wrong
2446 Contributor(s):
2447 Vlad Khorsun <hvlad at users.sourceforge.net>
2448
2449 * Bugfix CORE-2502
2450 Aliases and error about cyclic dependencies in CTE
2451 Contributor(s):
2452 Vlad Khorsun <hvlad at users.sourceforge.net>
2453
2454 * Bugfix CORE-2284
2455 Records left in RDB$PAGES after rollback of CREATE TABLE statement
2456 Contributor(s):
2457 Roman Simakov <roman.simakov at red-soft.biz>
2458 Dmitry Yemanov <dimitr at firebirdsql.org>
2459
2460 * Improvement CORE-5727
2461 Faster engine response on cancel/shutdown signals when scanning long list of pointer pages
2462 Contributor(s):
2463 Vlad Khorsun <hvlad at users.sourceforge.net>
2464
2465 * Improvement CORE-5712
2466 Access to the name of DB encryption key
2467 Contributor(s):
2468 Alex Peshkov <peshkoff at mail.ru>
2469
2470 * Improvement CORE-5704
2471 Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible
2472 Contributor(s):
2473 Vlad Khorsun <hvlad at users.sourceforge.net>
2474
2475 * Improvement CORE-5676
2476 Consider equivalence classes for index navigation
2477 Contributor(s):
2478 Dmitry Yemanov <dimitr at firebirdsql.org>
2479
2480 * Improvement CORE-5674
2481 Allow unused Common Table Expressions
2482 Contributor(s):
2483 Vlad Khorsun <hvlad at users.sourceforge.net>
2484
2485 * Improvement CORE-5660
2486 Make flush of big number of dirty pages faster
2487 Contributor(s):
2488 Vlad Khorsun <hvlad at users.sourceforge.net>
2489
2490 * Improvement CORE-5648
2491 Avoid serialization of isc_attach_database calls issued by EXECUTE STATEMENT implementation
2492 Contributor(s):
2493 Vlad Khorsun <hvlad at users.sourceforge.net>
2494
2495 * Improvement CORE-5629
2496 GSTAT output does not include datetime of analysis
2497 Contributor(s):
2498 Alex Peshkov <peshkoff at mail.ru>
2499
2500 * Improvement CORE-5614
2501 Physical backup merge stage could run too long, especially with huge page cache
2502 Contributor(s):
2503 Vlad Khorsun <hvlad at users.sourceforge.net>
2504
2505 * Improvement CORE-5610
2506 Provide info about database (or alias) which was in use during "Error during sweep: connection shutdown"
2507 Contributor(s):
2508 Alex Peshkov <peshkoff at mail.ru>
2509
2510 * Improvement CORE-5602
2511 ALTER DOMAIN is slow if many dependencies exist
2512 Contributor(s):
2513 Vlad Khorsun <hvlad at users.sourceforge.net>
2514
2515 * Improvement CORE-5601
2516 Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call
2517 Contributor(s):
2518 Alex Peshkov <peshkoff at mail.ru>
2519
2520 * Improvement CORE-5543
2521 Restore of pre ODS 11.1 database can leave RDB$RELATION_TYPE null
2522 Contributor(s):
2523 Dmitry Yemanov <dimitr at firebirdsql.org>
2524
2525 * Improvement CORE-4913
2526 Database backup using Nbackup is getting slow when directed to NAS over SMB protocol
2527 Contributor(s):
2528 Jan Hejda <jan.hejda at lim.cz>
2529 Vlad Khorsun <hvlad at users.sourceforge.net>
2530
2531 * Improvement CORE-3295
2532 Estimate the actual record compression ratio in the optimizer
2533 Contributor(s):
2534 Dmitry Yemanov <dimitr at firebirdsql.org>
2535
2536
2537 **************************
2538 * v3.0.2
2539 **************************
2540
2541 * Bugfix CORE-5503
2542 Classic Server has a maximum of 64 connections when using systemd init scripts
2543 Contributor(s):
2544 Alex Peshkov <peshkoff at mail.ru>
2545
2546 * Bugfix CORE-5501
2547 CORE-5501: Unclear gstat's diagnostics when damaged page in DB file appears encrypted
2548 Contributor(s):
2549 Alex Peshkov <peshkoff at mail.ru>
2550
2551 * Bugfix CORE-5498
2552 Cannot create connection for events processing
2553 Contributor(s):
2554 Vlad Khorsun <hvlad at users.sourceforge.net>
2555
2556 * Bugfix CORE-5496
2557 Creating SRP SYSDBA with explicit admin (-admin yes in gsec or grant admin role in create user) creates two SYSDBA accounts
2558 Contributor(s):
2559 Alex Peshkov <peshkoff at mail.ru>
2560
2561 * Bugfix CORE-5489
2562 Bad performance for NULLs filtering inside a navigational index scan
2563 Contributor(s):
2564 Dmitry Yemanov <dimitr at firebirdsql.org>
2565
2566 * Bugfix CORE-5484
2567 Database on NFS share is unavailable when accessed using mount point path
2568 Contributor(s):
2569 Alex Peshkov <peshkoff at mail.ru>
2570
2571 * Bugfix CORE-5477
2572 Trace duplicates ascii_char(13) in its output (Windows only)
2573 Contributor(s):
2574 Vlad Khorsun <hvlad at users.sourceforge.net>
2575
2576 * Bugfix CORE-5474
2577 'Restrict UDF' is not effective, because fbudf.so is dynamically linked against libc
2578 Contributor(s):
2579 Alex Peshkov <peshkoff at mail.ru>
2580 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2581
2582 * Bugfix CORE-5472
2583 Problems with dbcrypt key transfer
2584 Contributor(s):
2585 Alex Peshkov <peshkoff at mail.ru>
2586
2587 * Bugfix CORE-5470
2588 Trace INCLUDE_FILTER with [[:WHITESPACE:]]+ does not work when statement contains newline is issued
2589 Contributor(s):
2590 Vlad Khorsun <hvlad at users.sourceforge.net>
2591
2592 * Bugfix CORE-5464
2593 AV in fbclient when reading blob stored in incompatible encoding
2594 Contributor(s):
2595 Vlad Khorsun <hvlad at users.sourceforge.net>
2596
2597 * Bugfix CORE-5458
2598 Connections fail due to dead NFS mount points
2599 Contributor(s):
2600 Alex Peshkov <peshkoff at mail.ru>
2601
2602 * Bugfix CORE-5457
2603 Bugcheck 167 (invalid SEND request)
2604 Contributor(s):
2605 Dmitry Yemanov <dimitr at firebirdsql.org>
2606
2607 * Bugfix CORE-5456
2608 Migrating Firebird 2.5.2 to 3.0.1 gbak restore crashes at the end always
2609 Contributor(s):
2610 Dmitry Yemanov <dimitr at firebirdsql.org>
2611
2612 * Bugfix CORE-5452
2613 Segfault when engine's dynamic library is unloaded right after closing worker threads (GC and/or cache writer)
2614 Contributor(s):
2615 Alex Peshkov <peshkoff at mail.ru>
2616
2617 * Bugfix CORE-5448
2618 FB3 bugchecks when creating view on table which has column with character set NONE, database default charset is UTF8, and default collation is UNICODE
2619 Contributor(s):
2620 Vlad Khorsun <hvlad at users.sourceforge.net>
2621
2622 * Bugfix CORE-5447
2623 EXECUTE STATEMENT <e> when <e> starts with '--' (comment) issues "Unexpected end of command" error with wrong column number
2624 Contributor(s):
2625 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2626
2627 * Bugfix CORE-5435
2628 Badly selective index could be used for extra filtering even if selective index is used for sorting
2629 Contributor(s):
2630 Dmitry Yemanov <dimitr at firebirdsql.org>
2631
2632 * Bugfix CORE-5432
2633 Performance regression in Classic Server: too much time is spent during context switches
2634 Contributor(s):
2635 Dmitry Yemanov <dimitr at firebirdsql.org>
2636
2637 * Bugfix CORE-5428
2638 Rare segfault when preparing request working with a table with triggers
2639 Contributor(s):
2640 Alex Peshkov <peshkoff at mail.ru>
2641
2642 * Bugfix CORE-5425
2643 Server hangs under load test
2644 Contributor(s):
2645 Alex Peshkov <peshkoff at mail.ru>
2646
2647 * Bugfix CORE-5422
2648 Decompression overran buffer after rollback
2649 Contributor(s):
2650 Vlad Khorsun <hvlad at users.sourceforge.net>
2651
2652 * Bugfix CORE-5421
2653 Performance degradation in FB 3.0.2 compared to FB 2.5.7
2654 Contributor(s):
2655 Dmitry Yemanov <dimitr at firebirdsql.org>
2656
2657 * Bugfix CORE-5417
2658 Engine could hang up if auto-sweep is starting while database is shutting down
2659 Contributor(s):
2660 Vlad Khorsun <hvlad at users.sourceforge.net>
2661
2662 * Bugfix CORE-5414
2663 Error restoring on FB 3.0 from FB 2.5: bugcheck 221 (cannot remap)
2664 Contributor(s):
2665 Dmitry Yemanov <dimitr at firebirdsql.org>
2666
2667 * Bugfix CORE-5410
2668 Dependencies are not stored when using some type of constructions in subroutines
2669 Contributor(s):
2670 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2671
2672 * Bugfix CORE-5393
2673 Bad optimization of some operations with views containing subqueries
2674 Contributor(s):
2675 Dmitry Yemanov <dimitr at firebirdsql.org>
2676
2677 * Bugfix CORE-5392
2678 BUGCHECK 179 (decompression overran buffer) or unexpected lock conflict may happen during record versions backout
2679 Contributor(s):
2680 Dmitry Yemanov <dimitr at firebirdsql.org>
2681
2682 * Bugfix CORE-5390
2683 ISQL crashes corrupting memory when statement length is greater than 10 MB
2684 Contributor(s):
2685 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2686
2687 * Bugfix CORE-5384
2688 Plugin manager fails to provide appropriate config information when name of configuration file is set in plugins.conf
2689 Contributor(s):
2690 Alex Peshkov <peshkoff at mail.ru>
2691
2692 * Bugfix CORE-5383
2693 Dependencies in PSQL packages are not recognised
2694 Contributor(s):
2695 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2696
2697 * Bugfix CORE-5382
2698 Incorrect processing (truncation) of SQL statement longer than 10MB
2699 Contributor(s):
2700 Dmitry Yemanov <dimitr at firebirdsql.org>
2701
2702 * Bugfix CORE-5381
2703 Regression: could not execute query (select from view with nested view)
2704 Contributor(s):
2705 Dmitry Yemanov <dimitr at firebirdsql.org>
2706
2707 * Bugfix CORE-5368
2708 Regression: client application hangs or throw AV on selecting from multiple threads using 1 embedded connection
2709 Contributor(s):
2710 Alex Peshkov <peshkoff at mail.ru>
2711
2712 * Bugfix CORE-5367
2713 Regression: (boolean) parameters as search condition no longer allowed
2714 Contributor(s):
2715 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2716
2717 * Bugfix CORE-5366
2718 Regression: could not use CASE expression with more than 255 conditions
2719 Contributor(s):
2720 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2721
2722 * Bugfix CORE-5359
2723 New API - MessageMetadata's getScale() returns int but MetadataBuilder's setScale() wants unsigned
2724 Contributor(s):
2725 Alex Peshkov <peshkoff at mail.ru>
2726
2727 * Bugfix CORE-5350
2728 Assertion in CachedMasterInterface::set
2729 Contributor(s):
2730 Vlad Khorsun <hvlad at users.sourceforge.net>
2731
2732 * Bugfix CORE-5314
2733 UDFs declared with large varchars take excessive time to execute
2734 Contributor(s):
2735 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2736
2737 * Bugfix CORE-5120
2738 Configure: snprintf function is already defined on MSVC 2015
2739 Contributor(s):
2740 Vlad Khorsun <hvlad at users.sourceforge.net>
2741
2742 * Bugfix CORE-3530
2743 BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"
2744 Contributor(s):
2745 Dmitry Yemanov <dimitr at firebirdsql.org>
2746
2747 * Bugfix CORE-1894
2748 Circular dependencies between computed fields crashs the engine
2749 Contributor(s):
2750 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2751
2752 * Improvement CORE-5475
2753 Provide ability to filter out info and warnings from trace log
2754 Contributor(s):
2755 Vlad Khorsun <hvlad at users.sourceforge.net>
2756
2757 * Improvement CORE-5442
2758 Enhance control upon ability to share database crypt key between attachments in SS
2759 Contributor(s):
2760 Alex Peshkov <peshkoff at mail.ru>
2761
2762 * Improvement CORE-5441
2763 Cache physical numbers of often used data pages to reduce number of fetches of pointer pages
2764 Contributor(s):
2765 Vlad Khorsun <hvlad at users.sourceforge.net>
2766
2767 * Improvement CORE-5434
2768 Read-only transactions in SuperServer could avoid immediate write of Header and TIP pages after change
2769 Contributor(s):
2770 Vlad Khorsun <hvlad at users.sourceforge.net>
2771
2772 * Improvement CORE-5374
2773 Make database name available to crypt plugin
2774 Contributor(s):
2775 Alex Peshkov <peshkoff at mail.ru>
2776
2777 * Improvement CORE-5257
2778 Enable nested keys in plugin configuration
2779 Contributor(s):
2780 Vlad Khorsun <hvlad at users.sourceforge.net>
2781
2782 * Improvement CORE-5204
2783 Build the Linux code with --enable-binreloc and create an option in the installer
2784 to install in different locations than /opt/firebird
2785 Contributor(s):
2786 Alex Peshkov <peshkoff at mail.ru>
2787
2788 * Improvement CORE-4486
2789 Trace: provide filter to INCLUDE / EXCLUDE errors by their mnemonical names
2790 Contributor(s):
2791 Vlad Khorsun <hvlad at users.sourceforge.net>
2792
2793 * Improvement CORE-3637
2794 Port for Linux/m68k
2795 Contributor(s):
2796 Alex Peshkov <peshkoff at mail.ru>
2797
2798 * Improvement CORE-1095
2799 Support BETWEEN predicate for select expressions
2800 Contributor(s):
2801 Dmitry Yemanov <dimitr at firebirdsql.org>
2802
2803 * New feature CORE-5332
2804 libfbclient.so for Android (x86/x86-64/arm64)
2805 Contributor(s):
2806 Marius Adrian Popa <mapopa at gmail.com>
2807
2808 * New feature CORE-4563
2809 Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality
2810 Contributor(s):
2811 Vlad Khorsun <hvlad at users.sourceforge.net>
2812
2813 * New feature CORE-3885
2814 Android port (arm32)
2815 Contributor(s):
2816 Alex Peshkov <peshkoff at mail.ru>
2817
2818
2819 **************************
2820 * v3.0.1
2821 **************************
2822
2823 * Bugfix CORE-5355
2824 XpbBuilder fails to create new TPB
2825 Contributor(s):
2826 Alex Peshkov <peshkoff at mail.ru>
2827
2828 * Bugfix CORE-5351
2829 LEFT JOIN incorrectly pushes UDF into the inner stream causing wrong results
2830 Contributor(s):
2831 Dmitry Yemanov <dimitr at firebirdsql.org>
2832
2833 * Bugfix CORE-5348
2834 Databases created at build process are owned by Windows administrator, not SYSDBA
2835 Contributor(s):
2836 Vlad Khorsun <hvlad at users.sourceforge.net>
2837
2838 * Bugfix CORE-5347
2839 Races when initializing wire compression
2840 Contributor(s):
2841 Alex Peshkov <peshkoff at mail.ru>
2842
2843 * Bugfix CORE-5341
2844 User collate doesn't work with blobs
2845 Contributor(s):
2846 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2847
2848 * Bugfix CORE-5339
2849 Assertion in createDatabase() when doing overwrite check
2850 Contributor(s):
2851 Alex Peshkov <peshkoff at mail.ru>
2852
2853 * Bugfix CORE-5337
2854 Subquery in the insert list expression ignores the changes made earlier in the same executable block
2855 Contributor(s):
2856 Vlad Khorsun <hvlad at users.sourceforge.net>
2857
2858 * Bugfix CORE-5335
2859 Segfault when op_que_events is used on a port not prepared for events processing
2860 Contributor(s):
2861 Alex Peshkov <peshkoff at mail.ru>
2862
2863 * Bugfix CORE-5329
2864 Database gets partially corrupted in the "no-reserve" mode
2865 Contributor(s):
2866 Vlad Khorsun <hvlad at users.sourceforge.net>
2867 Dmitry Yemanov <dimitr at firebirdsql.org>
2868
2869 * Bugfix CORE-5327
2870 BUGCHECK 165 (cannot find tip page)
2871 Contributor(s):
2872 Vlad Khorsun <hvlad at users.sourceforge.net>
2873
2874 * Bugfix CORE-5322
2875 Cascade deletion in self-referencing table could raise "no current record for fetch operation" error
2876 Contributor(s):
2877 Vlad Khorsun <hvlad at users.sourceforge.net>
2878
2879 * Bugfix CORE-5313
2880 Data type unknown error with LIST
2881 Contributor(s):
2882 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2883
2884 * Bugfix CORE-5308
2885 ISQL hangs in BLOBVIEW command
2886 Contributor(s):
2887 Alex Peshkov <peshkoff at mail.ru>
2888
2889 * Bugfix CORE-5307
2890 Random "invalid transaction handle" errors are returned from the engine
2891 Contributor(s):
2892 Dmitry Yemanov <dimitr at firebirdsql.org>
2893
2894 * Bugfix CORE-5305
2895 CASCADE UPDATE fails for self-referencing FK
2896 Contributor(s):
2897 Vlad Khorsun <hvlad at users.sourceforge.net>
2898
2899 * Bugfix CORE-5302
2900 Performance regression when bulk inserting into table with indices
2901 Contributor(s):
2902 Vlad Khorsun <hvlad at users.sourceforge.net>
2903
2904 * Bugfix CORE-5296
2905 Error in network protocol when performing callback to client for database crypt key
2906 Contributor(s):
2907 Alex Peshkov <peshkoff at mail.ru>
2908
2909 * Bugfix CORE-5295
2910 Validation could read after the end-of-file when handle multifile database
2911 Contributor(s):
2912 Vlad Khorsun <hvlad at users.sourceforge.net>
2913
2914 * Bugfix CORE-5294
2915 Memory leak when use SHOW GRANTS on new empty database
2916 Contributor(s):
2917 Alex Peshkov <peshkoff at mail.ru>
2918
2919 * Bugfix CORE-5292
2920 Database corrupted when trying to encrypt it but appropriate key is missing
2921 Contributor(s):
2922 Alex Peshkov <peshkoff at mail.ru>
2923
2924 * Bugfix CORE-5289
2925 Small memory leak when resultset is empty
2926 Contributor(s):
2927 Vlad Khorsun <hvlad at users.sourceforge.net>
2928
2929 * Bugfix CORE-5285
2930 Segfault when attachment is closed before it's request/statement/etc.
2931 Contributor(s):
2932 Alex Peshkov <peshkoff at mail.ru>
2933
2934 * Bugfix CORE-5284
2935 Firebird fails to build with USE_VALGRIND
2936 Contributor(s):
2937 Alex Peshkov <peshkoff at mail.ru>
2938
2939 * Bugfix CORE-5279
2940 Granting access rights to view is broken
2941 Contributor(s):
2942 Alex Peshkov <peshkoff at mail.ru>
2943
2944 * Bugfix CORE-5278
2945 Some SPB parameters fail in FB 3.0
2946 Contributor(s):
2947 Alex Peshkov <peshkoff at mail.ru>
2948
2949 * Bugfix CORE-5277
2950 Parameters with multibyte character sets allow to bypass the character limit of VARCHAR fields
2951 Contributor(s):
2952 Adriano dos Santos Fernandes <adrianosf at gmail.com>
2953
2954 * Bugfix CORE-5275
2955 Expression index may become inconsistent if CREATE INDEX was interrupted after b-tree creation but before commiting
2956 Contributor(s):
2957 Dmitry Yemanov <dimitr at firebirdsql.org>
2958
2959 * Bugfix CORE-5270
2960 FBSVCMGR does not produce error while attempting to shutdown a database without specified timeout (prp_force_shutdown N)
2961 Contributor(s):
2962 Alex Peshkov <peshkoff at mail.ru>
2963
2964 * Bugfix CORE-5268
2965 Nested OR conditions may lead to incorrest results
2966 Contributor(s):
2967 Dmitry Yemanov <dimitr at firebirdsql.org>
2968
2969 * Bugfix CORE-5264
2970 Database cannot be unlocked (nbackup) if located on a raw device
2971 Contributor(s):
2972 Alex Peshkov <peshkoff at mail.ru>
2973
2974 * Bugfix CORE-5249
2975 Incorrect use of readlink() system call
2976 Contributor(s):
2977 Alex Peshkov <peshkoff at mail.ru>
2978
2979 * Bugfix CORE-5248
2980 Improve consistency in GRANT syntax between roles and privileges according to SQL standard
2981 Contributor(s):
2982 Alex Peshkov <peshkoff at mail.ru>
2983
2984 * Bugfix CORE-5246
2985 String truncation error while selecting from MON$ tables if some user-defined context variable exceeds 255 bytes in length
2986 Contributor(s):
2987 Dmitry Yemanov <dimitr at firebirdsql.org>
2988
2989 * Bugfix CORE-5244
2990 Wrong error message when trying to execute SELECT statement using isc_dsql_execute_immediate()
2991 Contributor(s):
2992 Alex Peshkov <peshkoff at mail.ru>
2993
2994 * Bugfix CORE-5241
2995 Affected rows are not counted for some update operations with views
2996 Contributor(s):
2997 Dmitry Yemanov <dimitr at firebirdsql.org>
2998
2999 * Bugfix CORE-5236
3000 IN/ANY/ALL predicates may cause sub-optimal (late filtering) execution of joins
3001 Contributor(s):
3002 Dmitry Yemanov <dimitr at firebirdsql.org>
3003
3004 * Bugfix CORE-5234
3005 Access violation on UDF crashes server
3006 Contributor(s):
3007 Vlad Khorsun <hvlad at users.sourceforge.net>
3008
3009 * Bugfix CORE-5233
3010 Unaligned memory access in MET_format() causes segfault on big-endian machines
3011 Contributor(s):
3012 James Clarke <jrtc27 at jrtc27.com>
3013
3014 * Bugfix CORE-5232
3015 32-bit locks on big-endian systems lead to deadlock
3016 Contributor(s):
3017 James Clarke <jrtc27 at jrtc27.com>
3018
3019 * Bugfix CORE-5231
3020 EXECUTE STATEMENT: BLR error if more than 256 output parameters exist
3021 Contributor(s):
3022 Dmitry Yemanov <dimitr at firebirdsql.org>
3023
3024 * Bugfix CORE-5228
3025 Restore may hang if the database contains more than 4 billion records
3026 Contributor(s):
3027 Dmitry Yemanov <dimitr at firebirdsql.org>
3028
3029 * Bugfix CORE-5226
3030 Incorrect result set (missing records) may be returned by the ORDER plan query navigating on a descending index
3031 Contributor(s):
3032 Dmitry Yemanov <dimitr at firebirdsql.org>
3033
3034 * Bugfix CORE-5225
3035 Authentication end with first plugin that has the user but auth fails (should continue with next plugin)
3036 Contributor(s):
3037 Alex Peshkov <peshkoff at mail.ru>
3038
3039 * Bugfix CORE-5224
3040 Transaction id tags for services API do not support new 48 bit transaction ids
3041 Contributor(s):
3042 Dmitry Yemanov <dimitr at firebirdsql.org>
3043
3044 * Bugfix CORE-5222
3045 SELECT WITH LOCK may raise unexpected update conflict errors under concurrent load
3046 Contributor(s):
3047 Dmitry Yemanov <dimitr at firebirdsql.org>
3048
3049 * Bugfix CORE-5220
3050 ISQL -X: double quotes are missed for COLLATE <C> of CREATE DOMAIN statement when <C> is from any non-ascii charset
3051 Contributor(s):
3052 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3053
3054 * Bugfix CORE-5218
3055 Explicitly defined names for NOT NULL constraints are not exported into script by ISQL -x
3056 Contributor(s):
3057 Dmitry Yemanov <dimitr at firebirdsql.org>
3058
3059 * Bugfix CORE-5217
3060 ISQL -x may crash while exporting an exception with message text length > 127 bytes
3061 Contributor(s):
3062 Dmitry Yemanov <dimitr at firebirdsql.org>
3063
3064 * Bugfix CORE-5213
3065 Database may get decrypted after changing couple of bytes in database header w/o 'agreement' from crypt plugin
3066 Contributor(s):
3067 Alex Peshkov <peshkoff at mail.ru>
3068
3069 * Bugfix CORE-5210
3070 Firebird 3.0 + fbclient 3.0 - POST_EVENT won't work
3071 Contributor(s):
3072 Vlad Khorsun <hvlad at users.sourceforge.net>
3073
3074 * Bugfix CORE-5207
3075 ISQL -X may generate invalid GRANT USAGE statements for domains
3076 Contributor(s):
3077 Dmitry Yemanov <dimitr at firebirdsql.org>
3078
3079 * Bugfix CORE-5203
3080 Single CPU core fully utilized with trace session
3081 Contributor(s):
3082 Alex Peshkov <peshkoff at mail.ru>
3083
3084 * Bugfix CORE-5193
3085 Precedence problem with operator IS
3086 Contributor(s):
3087 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3088
3089 * Bugfix CORE-5183
3090 Regression: line/column numbering may be twisted if alias.name syntax is used
3091 Contributor(s):
3092 Dmitry Yemanov <dimitr at firebirdsql.org>
3093
3094 * Bugfix CORE-5154
3095 Services API don't work with non-ASCII database names
3096 Contributor(s):
3097 Dimitry Sibiryakov <sd at ibphoenix.com>
3098
3099 * Bugfix CORE-5142
3100 Error "no current record to fetch" if some record is to be deleted both by the statement itself and by some trigger fired during statement execution
3101 Contributor(s):
3102 Vlad Khorsun <hvlad at users.sourceforge.net>
3103
3104 * Bugfix CORE-1746
3105 Expression index can be created while doing inserts into table
3106 Contributor(s):
3107 Vlad Khorsun <hvlad at users.sourceforge.net>
3108
3109 * Improvement CORE-5266
3110 Allow statement 'create OR ALTER user sysdba password ...' to initialize empty securityN.fdb as 'CREATE user ...'
3111 Contributor(s):
3112 Alex Peshkov <peshkoff at mail.ru>
3113
3114 * Improvement CORE-5257
3115 Enable nested keys in plugin configuration
3116 Contributor(s):
3117 Alex Peshkov <peshkoff at mail.ru>
3118
3119 * Improvement CORE-5229
3120 Allow to enforce IPv4 or IPv6 in URL-like connection strings
3121 Contributor(s):
3122 Michal Kubeček <mike at mk-sys.cz>
3123
3124 * Improvement CORE-5216
3125 Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK
3126 Contributor(s):
3127 Dmitry Yemanov <dimitr at firebirdsql.org>
3128
3129 * Improvement CORE-5205
3130 Add a switch to build linux binaries with builtin libtommath
3131 Contributor(s):
3132 Alex Peshkov <peshkoff at mail.ru>
3133
3134 * Improvement CORE-5201
3135 Return nonzero result code when restore fails on activating and creating deferred user index
3136 Contributor(s):
3137 Alex Peshkov <peshkoff at mail.ru>
3138
3139 * Improvement CORE-5167
3140 Allow implicit conversion between boolean and string
3141 Contributor(s):
3142 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3143
3144
3145 **************************
3146 * v3.0 Final Release
3147 **************************
3148
3149 * Bugfix CORE-5194
3150 Invalid COMPUTED BY definition generated by ISQL (extract metadata)
3151 Contributor(s):
3152 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3153
3154 * Bugfix CORE-5189
3155 Codes of operation of user management plugin are missing in public API
3156 Contributor(s):
3157 Alex Peshkov <peshkoff at mail.ru>
3158
3159 * Bugfix CORE-5184
3160 Assertion in cloop dispatcher when trying to save exception information in status interface
3161 Contributor(s):
3162 Alex Peshkov <peshkoff at mail.ru>
3163
3164 * Bugfix CORE-5182
3165 Inconsistent effects of subsequent statement execution if failing during record refetch
3166 Contributor(s):
3167 Dmitry Yemanov <dimitr at firebirdsql.org>
3168
3169 * Bugfix CORE-5181
3170 Build fails when HAVE_MMAP is not defined
3171 Contributor(s):
3172 Alex Peshkov <peshkoff at mail.ru>
3173
3174 * Bugfix CORE-5179
3175 Database-level statistics (MON$STAT_GROUP = 0) may contain multiple rows under concurrent load
3176 Contributor(s):
3177 Dmitry Yemanov <dimitr at firebirdsql.org>
3178
3179 * Bugfix CORE-5166
3180 Wrong error message with UNIQUE BOOLEAN field
3181 Contributor(s):
3182 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3183
3184 * Bugfix CORE-5165
3185 HAVING COUNT(*) NOT IN ( <Q> ) prevent record from appearing in outer resultset when it should be there (<Q> = resultset without nulls)
3186 Contributor(s):
3187 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3188
3189 * Bugfix CORE-5162
3190 SEC$ tables and tag/attributes
3191 Contributor(s):
3192 Alex Peshkov <peshkoff at mail.ru>
3193
3194 * Bugfix CORE-5161
3195 Unique index could be created on non-unique data
3196 Contributor(s):
3197 Vlad Khorsun <hvlad at users.sf.net>
3198
3199 * Bugfix CORE-5159
3200 Regression: engine may throw transliteration errors when running from non-ASCII system path
3201 Contributor(s):
3202 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3203
3204 * Bugfix CORE-5157
3205 Server goes into infinite loop when data is sent from client to the service in small packets
3206 Contributor(s):
3207 Alex Peshkov <peshkoff at mail.ru>
3208
3209 * Bugfix CORE-5155
3210 [CREATE OR] ALTER USER statement: clause PASSWORD (if present) must be always specified just after USER
3211 Contributor(s):
3212 Alex Peshkov <peshkoff at mail.ru>
3213
3214 * Bugfix CORE-5153
3215 Regression: Server crashes when aggregate functions are used together with NOT IN predicate
3216 Contributor(s):
3217 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3218
3219 * Bugfix CORE-5149
3220 Regression: LEFT JOIN incorrectly pushes COALESCE into the inner stream causing wrong results
3221 Contributor(s):
3222 Dmitry Yemanov <dimitr at firebirdsql.org>
3223
3224 * Bugfix CORE-5147
3225 CREATE TRIGGER fails with "ambiguous field name between table B and table A" error
3226 Contributor(s):
3227 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3228
3229 * Bugfix CORE-5146
3230 Suboptimal join order if one table has a selective predicate and MIN is calculated for the other one
3231 Contributor(s):
3232 Dmitry Yemanov <dimitr at firebirdsql.org>
3233
3234 * Bugfix CORE-5144
3235 Deadlock when database is encrypted or decrypted under high parallel load
3236 Contributor(s):
3237 Alex Peshkov <peshkoff at mail.ru>
3238
3239 * Bugfix CORE-5143
3240 GBAK restore fails when there is SQL function accessing table and switch -O(NE_AT_A_TIME) is used
3241 Contributor(s):
3242 Dmitry Yemanov <dimitr at firebirdsql.org>
3243
3244 * Bugfix CORE-5140
3245 Wrong error message when user tries to set number of page buffers into not supported value
3246 Contributor(s):
3247 Vlad Khorsun <hvlad at users.sf.net>
3248
3249 * Bugfix CORE-5134
3250 Samples of dbcrypt-related plugins contain references to internal files
3251 Contributor(s):
3252 Alex Peshkov <peshkoff at mail.ru>
3253
3254 * Bugfix CORE-5133
3255 ALTER SEQUENCE RESTART WITH does not change the initial value
3256 Contributor(s):
3257 Dmitry Yemanov <dimitr at firebirdsql.org>
3258
3259 * Bugfix CORE-5130
3260 Message about "invalid request BLR" attempting to compile wrong DDL of view with both subquery and "WITH CHECK OPTION" in its DDL
3261 Contributor(s):
3262 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3263
3264 * Bugfix CORE-5122
3265 Expression index may not be used by the optimizer if created and used in different connection charsets
3266 Contributor(s):
3267 Dmitry Yemanov <dimitr at firebirdsql.org>
3268
3269 * Bugfix CORE-4645
3270 Internal Firebird consistency check (cannot find tip page (165), file: tra.cpp line: 2375)
3271 Contributor(s):
3272 Vlad Khorsun <hvlad at users.sf.net>
3273
3274 * Improvement CORE-5180
3275 Do not require root rights to build linux package
3276 Contributor(s):
3277 Alex Peshkov <peshkoff at mail.ru>
3278
3279
3280 **************************
3281 * v3.0 Release Candidate 2
3282 **************************
3283
3284 * Bugfix CORE-5110
3285 False PK\FK violation could be reported when attachment used isc_dpb_no_garbage_collect flag
3286 Contributor(s):
3287 Vlad Khorsun <hvlad at users.sf.net>
3288
3289 * Bugfix CORE-5107
3290 SET AUTODDL OFF and sequence of CREATE + ALTER + DROP VIEW leads to server crash
3291 Contributor(s):
3292 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3293
3294 * Bugfix CORE-5105
3295 Deadlocks when database is initially encrypted
3296 Contributor(s):
3297 Alex Peshkov <peshkoff at mail.ru>
3298
3299 * Bugfix CORE-5104
3300 External data source selects became slow
3301 Contributor(s):
3302 Vlad Khorsun <hvlad at users.sf.net>
3303 Alex Peshkov <peshkoff at mail.ru>
3304
3305 * Bugfix CORE-5102
3306 fbclient.dll API calls modify FPU control word
3307 Contributor(s):
3308 Vlad Khorsun <hvlad at users.sf.net>
3309
3310 * Bugfix CORE-5101
3311 Restore is slow when the database contains many small tables with indices
3312 Contributor(s):
3313 Vlad Khorsun <hvlad at users.sf.net>
3314
3315 * Bugfix CORE-5097
3316 COMPUTED-BY expressions are not converted to their field type inside the engine
3317 Contributor(s):
3318 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3319
3320 * Bugfix CORE-5093
3321 ALTER does not change type of a computed field
3322 Contributor(s):
3323 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3324
3325 * Bugfix CORE-5092
3326 ISQL extract command lose COMPUTED BY field types
3327 Contributor(s):
3328 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3329
3330 * Bugfix CORE-5089
3331 Metadata extration (ISQL -X): "CREATE PROCEDURE/FUNCTION" statement contains reference to column of table(s)
3332 that not yet exists if this procedure had parameter of such type when it was created
3333 Contributor(s):
3334 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3335
3336 * Bugfix CORE-5088
3337 Segmentation fault when 'gstat -h' is closing
3338 Contributor(s):
3339 Alex Peshkov <peshkoff at mail.ru>
3340
3341 * Bugfix CORE-5087
3342 Database shutdown can cause server crash if multiple attachments run EXECUTE STATEMENT
3343 Contributor(s):
3344 Vlad Khorsun <hvlad at users.sf.net>
3345
3346 * Bugfix CORE-5082
3347 Server does not validate correctness of user/password pair provided in EXECUTE STATEMENT operator
3348 Contributor(s):
3349 Alex Peshkov <peshkoff at mail.ru>
3350
3351 * Bugfix CORE-5078
3352 "Invalid BLOB ID" error is thrown unexpectedly
3353 Contributor(s):
3354 Vlad Khorsun <hvlad at users.sf.net>
3355
3356 * Bugfix CORE-5075
3357 Trigger on DISCONNECT with EXECUTE STATEMENT: 1) does not work in 3.0; 2) leads FB to crash when it is recreated
3358 Contributor(s):
3359 Vlad Khorsun <hvlad at users.sf.net>
3360
3361 * Bugfix CORE-5067
3362 Blocking new connections as a consequence of the sweeping the security database too long
3363 Contributor(s):
3364 Vlad Khorsun <hvlad at users.sf.net>
3365
3366 * Bugfix CORE-5062
3367 CHAR_TO_UUID on column with index throws "expression evaluation not supported"
3368 Contributor(s):
3369 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3370
3371 * Bugfix CORE-5061
3372 ISQL plan output is unexpectedly truncated after a query is simplified to become shorter
3373 Contributor(s):
3374 Dmitry Yemanov <dimitr at firebirdsql.org>
3375
3376 * Bugfix CORE-5060
3377 Cannot CREATE VIEW that selects from a system table, despite having all grants
3378 Contributor(s):
3379 Alex Peshkov <peshkoff at mail.ru>
3380
3381 * Bugfix CORE-5056
3382 Write-lock of database file is cleared when retrieving the database statistics via the Services API
3383 Contributor(s):
3384 Alex Peshkov <peshkoff at mail.ru>
3385
3386 * Bugfix CORE-5053
3387 changeServerMode.sh can mess with configuration
3388 Contributor(s):
3389 Alex Peshkov <peshkoff at mail.ru>
3390
3391 * Bugfix CORE-5049
3392 Incorrect calculation of byte-length for view columns
3393 Contributor(s):
3394 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3395
3396 * Bugfix CORE-5047
3397 mapUser() routine establish secondary attach using wrong provider
3398 Contributor(s):
3399 Alex Peshkov <peshkoff at mail.ru>
3400
3401 * Bugfix CORE-5044
3402 Pages are encrypted for each shadow separately
3403 Contributor(s):
3404 Alex Peshkov <peshkoff at mail.ru>
3405
3406 * Bugfix CORE-5042
3407 FB3 client cannot create database on FB2.5 server
3408 Contributor(s):
3409 Alex Peshkov <peshkoff at mail.ru>
3410
3411 * Bugfix CORE-5041
3412 Database may get corrupted after ALTER DATABASE ENCRYPT/DECRYPT issued multiple times per database open time
3413 Contributor(s):
3414 Alex Peshkov <peshkoff at mail.ru>
3415
3416 * Bugfix CORE-5039
3417 Connecting to service with invalid servicename yields incorrect error message
3418 Contributor(s):
3419 Alex Peshkov <peshkoff at mail.ru>
3420
3421 * Bugfix CORE-5034
3422 At least 5 seconds delay on disconnect could happen if disconnect happens close after Event Manager initialization
3423 Contributor(s):
3424 Vlad Khorsun <hvlad at users.sf.net>
3425
3426 * Bugfix CORE-5033
3427 File fb_user_mapping could be left in Firebird lock directory after correct shutdown of all Firebird worker processes
3428 Contributor(s):
3429 Vlad Khorsun <hvlad at users.sf.net>
3430
3431 * Bugfix CORE-5032
3432 Cannot connect to a database which have own security database without security3.fdb
3433 Contributor(s):
3434 Alex Peshkov <peshkoff at mail.ru>
3435
3436 * Bugfix CORE-5029
3437 Crash in fbclient when multi-threaded application uses XNET protocol
3438 Contributor(s):
3439 Vlad Khorsun <hvlad at users.sf.net>
3440
3441 * Bugfix CORE-5026
3442 Firebird authentication gives up after first common plugin
3443 Contributor(s):
3444 Alex Peshkov <peshkoff at mail.ru>
3445
3446 * Bugfix CORE-5020
3447 ORDER BY clause on compound index may disable usage of other indices
3448 Contributor(s):
3449 Dmitry Yemanov <dimitr at firebirdsql.org>
3450
3451 * Bugfix CORE-5018
3452 Non-indexed predicates may not be applied immediately after retrieval when tables are being joined
3453 Contributor(s):
3454 Dmitry Yemanov <dimitr at firebirdsql.org>
3455
3456 * Bugfix CORE-5017
3457 Interrupt of aux connection during TCP setup phase causes server exit due to unhandled exception
3458 Contributor(s):
3459 Alex Peshkov <peshkoff at mail.ru>
3460
3461 * Bugfix CORE-5016
3462 Server crashes during GC when DELETE is executed after adding new referencing column
3463 Contributor(s):
3464 Dmitry Yemanov <dimitr at firebirdsql.org>
3465
3466 * Bugfix CORE-5015
3467 Server may crash when event is posted from ON DISCONNECT trigger
3468 Contributor(s):
3469 Vlad Khorsun <hvlad at users.sf.net>
3470
3471 * Bugfix CORE-5014
3472 Interrupt of aux connection during TCP setup phase causes unclear error messages in firebird.log
3473 Contributor(s):
3474 Alex Peshkov <peshkoff at mail.ru>
3475
3476 * Bugfix CORE-5002
3477 Windows installer includes malformed strings
3478 Contributor(s):
3479 Paul Reeves <preeves at ibphoenix.com>
3480
3481 * Bugfix CORE-4999
3482 Deadlock when trying to access database with invalid crypt key
3483 Contributor(s):
3484 Alex Peshkov <peshkoff at mail.ru>
3485
3486 * Bugfix CORE-4998
3487 Both client and server could not close connection after failed authentification
3488 Contributor(s):
3489 Vlad Khorsun <hvlad at users.sf.net>
3490
3491 * Bugfix CORE-4997
3492 Races when two threads try to establish first enbedded connections to engine simultaneously
3493 Contributor(s):
3494 Alex Peshkov <peshkoff at mail.ru>
3495
3496 * Bugfix CORE-4991
3497 Key holder plugin is loaded on connect to database but not on create
3498 Contributor(s):
3499 Alex Peshkov <peshkoff at mail.ru>
3500
3501 * Bugfix CORE-4990
3502 Database is not decrypted completely
3503 Contributor(s):
3504 Alex Peshkov <peshkoff at mail.ru>
3505
3506 * Bugfix CORE-4982
3507 Server crashes during "select from procedure" if exception is thrown while backing out the current savepoint
3508 Contributor(s):
3509 Dmitry Yemanov <dimitr at firebirdsql.org>
3510
3511 * Bugfix CORE-4980
3512 Operator REVOKE can modify rights granted to system tables at DB creation time
3513 Contributor(s):
3514 Alex Peshkov <peshkoff at mail.ru>
3515
3516 * Bugfix CORE-4969
3517 SEC$USERS table is unavailable in case of any error in any configured user manager plugin
3518 Contributor(s):
3519 Alex Peshkov <peshkoff at mail.ru>
3520
3521 * Bugfix CORE-4964
3522 Real errors during connect to security database are hidden by Srp user manager
3523 Contributor(s):
3524 Alex Peshkov <peshkoff at mail.ru>
3525
3526 * Bugfix CORE-4910
3527 Firebird build on Windows fail if path to sources contains spaces
3528 Contributor(s):
3529 Dimitry Sibiryakov <sd at ibphoenix.com>
3530
3531 * Bugfix CORE-4885
3532 Error retrieving current user name when using Windows trusted authentication and OS user name contains non-ASCII characters.
3533 Contributor(s):
3534 Alex Peshkov <peshkoff at mail.ru>
3535 Dmitry Yemanov <dimitr at firebirdsql.org>
3536
3537 * Bugfix CORE-4862
3538 ibase.h from x64 package includes non-existing file
3539 Contributor(s):
3540 Dmitry Yemanov <dimitr at firebirdsql.org>
3541
3542 * Bugfix CORE-4842
3543 Installer script fails in some Linux environments
3544 Contributor(s):
3545 Alex Peshkov <peshkoff at mail.ru>
3546 Mykhaylo Masyk <miwaonline at gmail.com>
3547
3548 * Bugfix CORE-4840
3549 Transactions with isc_tpb_autocommit can hang the server
3550 Contributor(s):
3551 Dmitry Yemanov <dimitr at firebirdsql.org>
3552
3553 * Bugfix CORE-4708
3554 Content of MON$EXPLAINED_PLAN in MON$STATEMENTS is truncated if exceeds the 32KB limit
3555 Contributor(s):
3556 Dmitry Yemanov <dimitr at firebirdsql.org>
3557
3558 * Bugfix CORE-4179
3559 Unable to read MON$ tables when there's intensive disk-bound load
3560 Contributor(s):
3561 Dmitry Yemanov <dimitr at firebirdsql.org>
3562
3563 * Bugfix CORE-2923
3564 Problem with dependencies with views
3565 Contributor(s):
3566 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3567
3568 * Improvement CORE-5112
3569 Improve error messages for malformed SQDLA
3570 Contributor(s):
3571 Dimitry Sibiryakov <sd at ibphoenix.com>
3572
3573 * Improvement CORE-5100
3574 Improve control over database crypt keys
3575 See also:
3576 /doc/sql.extensions/README.ddl.txt
3577 Contributor(s):
3578 Alex Peshkov <peshkoff at mail.ru>
3579
3580 * Improvement CORE-5083
3581 Provide method to correcty set offsets in implemented by user IMessageMetadata
3582 Contributor(s):
3583 Alex Peshkov <peshkoff at mail.ru>
3584
3585 * Improvement CORE-5077
3586 ISQL does not show encryption status of database
3587 Contributor(s):
3588 Alex Peshkov <peshkoff at mail.ru>
3589
3590 * Improvement CORE-5063
3591 Make SHOW DATABASE command to show numbers of used and free pages in database
3592 Contributor(s):
3593 Vlad Khorsun <hvlad at users.sf.net>
3594
3595 * Improvement CORE-5028
3596 Report the remote port number in MON$ATTACHMENTS
3597 Contributor(s):
3598 Vlad Khorsun <hvlad at users.sf.net>
3599
3600 * Improvement CORE-4978
3601 Improve validation and fixup of lost data pages
3602 Contributor(s):
3603 Roman Simakov <roman.simakov at red-soft.biz>
3604 Vlad Khorsun <hvlad at users.sf.net>
3605
3606 * Improvement CORE-2493
3607 Append the IP address of the remote host to error messages in firebird.log for TCP connections
3608 Contributor(s):
3609 Vlad Khorsun <hvlad at users.sf.net>
3610
3611 * New feature CORE-4996
3612 Need some SECURITY2.FDB --> SECURITY3.FDB upgrade feature
3613 Contributor(s):
3614 Alex Peshkov <peshkoff at mail.ru>
3615
3616 * New feature CORE-1538
3617 Add an option to isc_database_info() API to return the number of free pages in a database
3618 Contributor(s):
3619 Vlad Khorsun <hvlad at users.sf.net>
3620
3621
3622 **************************
3623 * v3.0 Release Candidate 1
3624 **************************
3625
3626 * Bugfix CORE-4984
3627 Ordering by compound index together with a range condition gives wrong results
3628 Contributor(s):
3629 Dmitry Yemanov <dimitr at firebirdsql.org>
3630
3631 * Bugfix CORE-4954
3632 Packaged procedure with value by default isn't called if this parameter isn't specified
3633 Contributor(s):
3634 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3635
3636 * Bugfix CORE-4952
3637 SuperServer could hung on database shutdown
3638 Contributor(s):
3639 Vlad Khorsun <hvlad at users.sf.net>
3640
3641 * Bugfix CORE-4951
3642 Message "Incorrect parameters provided to internal function INF_transaction_info Invalid token"
3643 is reported when trying to commit 2PC transaction
3644 Contributor(s):
3645 Alex Peshkov <peshkoff at mail.ru>
3646
3647 * Bugfix CORE-4950
3648 Statistics for any system index can not be updated/recalculated
3649 Contributor(s):
3650 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3651
3652 * Bugfix CORE-4947
3653 Compound ALTER TABLE statement with ADD and DROP the same check constraint fails
3654 Contributor(s):
3655 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3656
3657 * Bugfix CORE-4943
3658 Dialect 1 casting date to string breaks when in the presence a domain with a check constraint
3659 Contributor(s):
3660 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3661
3662 * Bugfix CORE-4940
3663 Add label about deterministic flag for stored function in SHOW and extract commands
3664 Contributor(s):
3665 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3666
3667 * Bugfix CORE-4938
3668 Cannot complete operations (get statistics, change FW, make backup) on database when FB works in embedded mode
3669 Contributor(s):
3670 Vlad Khorsun <hvlad at users.sf.net>
3671
3672 * Bugfix CORE-4929
3673 Cannot compile source with "ELSE IF ( <expr> ) THEN" statement and commands to manipulate explicit cursor inside
3674 Contributor(s):
3675 Dmitry Yemanov <dimitr at firebirdsql.org>
3676
3677 * Bugfix CORE-4928
3678 Impossible to save the connection information in the ON CONNECT trigger if the connection is created by GBAK
3679 Contributor(s):
3680 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3681 Dmitry Yemanov <dimitr at firebirdsql.org>
3682
3683 * Bugfix CORE-4921
3684 Predicate IS [NOT] DISTINCT FROM is not pushed into unions/aggregates thus causing sub-optimal plans
3685 Contributor(s):
3686 Dmitry Yemanov <dimitr at firebirdsql.org>
3687
3688 * Bugfix CORE-4919
3689 Classic server (all processes) hangs after death of one process (AIX / SOLARIS)
3690 Contributor(s):
3691 Alex Peshkov <peshkoff at mail.ru>
3692
3693 * Bugfix CORE-4917
3694 ALTER DOMAIN ... TO <new_name> allows to specify <new_name> matching to 'RDB$[[:DIGIT:]]*'
3695 Contributor(s):
3696 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3697
3698 * Bugfix CORE-4914
3699 Moving database to 'full shutdown' state can corrupt index (at least) on long-key text field
3700 Contributor(s):
3701 Vlad Khorsun <hvlad at users.sf.net>
3702
3703 * Bugfix CORE-4909
3704 MERGE / HASH JOINs produce incorrect results when VARCHAR join keys differ only by trailing spaces
3705 Contributor(s):
3706 Dmitry Yemanov <dimitr at firebirdsql.org>
3707
3708 * Bugfix CORE-4906
3709 AV when server is shut down with active trace session(s)
3710 Contributor(s):
3711 Vlad Khorsun <hvlad at users.sf.net>
3712
3713 * Bugfix CORE-4904
3714 Index corruption when add data in long-key-indexed field
3715 Contributor(s):
3716 Vlad Khorsun <hvlad at users.sf.net>
3717
3718 * Bugfix CORE-4902
3719 Assertion (m_format->fmt_length == m_data.getCount()) failure
3720 Contributor(s):
3721 Dmitry Yemanov <dimitr at firebirdsql.org>
3722 Vlad Khorsun <hvlad at users.sf.net>
3723
3724 * Bugfix CORE-4899
3725 GFIX -online: message "IProvider::attachDatabase failed when loading mapping cache" appears in Classic (only) if access uses remote protocol
3726 Contributor(s):
3727 Alex Peshkov <peshkoff at mail.ru>
3728
3729 * Bugfix CORE-4897
3730 FBSVCMGR can produce broken log when restoring database
3731 Contributor(s):
3732 Alex Peshkov <peshkoff at mail.ru>
3733
3734 * Bugfix CORE-4890
3735 Placing comment (single-lined or multi-lined) between final `END` of creating SP code and terminal character (^)
3736 produces compiling error when tool uses old API
3737 Contributor(s):
3738 Alex Peshkov <peshkoff at mail.ru>
3739
3740 * Bugfix CORE-4889
3741 FBSVCMGR with `action_trace_start` prevents in 3.0 SuperServer from connecting using local protocol
3742 Contributor(s):
3743 Vlad Khorsun <hvlad at users.sf.net>
3744
3745 * Bugfix CORE-4887
3746 AFTER CREATE/ALTER PACKAGE DDL triggers runs in incorrect moment
3747 Contributor(s):
3748 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3749
3750 * Bugfix CORE-4884
3751 Crash on parsing of script containing `execute block` with lot of nested begin..end statements
3752 Contributor(s):
3753 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3754
3755 * Bugfix CORE-4882
3756 ISQL input command (or -i option) reads large (> 64K) lines incorrectly
3757 Contributor(s):
3758 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3759
3760 * Bugfix CORE-4876
3761 Named trace session (launched by fbsvcmgr with non-empty value for 'trc_name' parameter) can not be stopped using its name
3762 Contributor(s):
3763 Vlad Khorsun <hvlad at users.sf.net>
3764
3765 * Bugfix CORE-4872
3766 v3 fbclient cannot work with servers older than v2.5 via the remote protocol
3767 Contributor(s):
3768 Dmitry Yemanov <dimitr at firebirdsql.org>
3769
3770 * Bugfix CORE-4870
3771 SET COUNT ON: issuing UPDATE on view which was created WITH CHECK OPTION produces wrong number of affected rows
3772 Contributor(s):
3773 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3774
3775 * Bugfix CORE-4865
3776 Online validation could wrongly report double allocated pages
3777 Contributor(s):
3778 Vlad Khorsun <hvlad at users.sf.net>
3779
3780 * Bugfix CORE-4864
3781 CREATE DATABASE fails with ISQL
3782 Contributor(s):
3783 Alex Peshkov <peshkoff at mail.ru>
3784
3785 * Bugfix CORE-4861
3786 Segmentation fault when working with saved exception in request
3787 Contributor(s):
3788 Alex Peshkov <peshkoff at mail.ru>
3789
3790 * Bugfix CORE-4860
3791 Online validation fails on WINDOWS if `dbname` argument contains forward slash ('/') and concurrent attachment which also uses '/' exists
3792 Contributor(s):
3793 Vlad Khorsun <hvlad at users.sf.net>
3794
3795 * Bugfix CORE-4859
3796 Firebird v3 embedded cannot work without folder C:\ProgramData\firebird
3797 Contributor(s):
3798 Vlad Khorsun <hvlad at users.sf.net>
3799
3800 * Bugfix CORE-4855
3801 Online validation during DML activity in other connection leads to errors:
3802 "Error while trying to read from file" and "page in use during flush (210)"
3803 Contributor(s):
3804 Vlad Khorsun <hvlad at users.sf.net>
3805
3806 * Bugfix CORE-4854
3807 Client library incorrectly handles non-UTF8 representation of international characters in SPB
3808 Contributor(s):
3809 Alex Peshkov <peshkoff at mail.ru>
3810
3811 * Bugfix CORE-4848
3812 MERGE ... WHEN NOT MATCHED ... RETURNING returns wrong (non-null) values when no insert is performed
3813 Contributor(s):
3814 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3815
3816 * Bugfix CORE-4846
3817 Altering a trigger indicating other table than the original does not reflect the change
3818 Contributor(s):
3819 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3820
3821 * Bugfix CORE-4836
3822 GRANT UPDATE(c) ON T TO U01 WITH GRANT OPTION: user U01 will not be able to revoke this privilege if some DML is executed before revoke
3823 Contributor(s):
3824 Alex Peshkov <peshkoff at mail.ru>
3825
3826 * Bugfix CORE-4710
3827 Invalid request BLR at offset 361 context already in use (BLR error)
3828 Contributor(s):
3829 Dmitry Yemanov <dimitr at firebirdsql.org>
3830
3831 * Bugfix CORE-4680
3832 Possible deadlock in firebird connect
3833 Contributor(s):
3834 Vlad Khorsun <hvlad at users.sf.net>
3835
3836 * Bugfix CORE-4585
3837 Cannot create a column check constraint when the column is domain based
3838 Contributor(s):
3839 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3840
3841 * Bugfix CORE-4497
3842 Regression: wrong handling in FOR-cursor when NOT EXISTS( select from <VIEW> ) statement is used to check results obtained from SP
3843 Contributor(s):
3844 Dmitry Yemanov <dimitr at firebirdsql.org>
3845
3846 * Bugfix CORE-4292
3847 Server ignores asynchronous (monitoring or cancellation) requests while preparing a query with lot of windowed functions
3848 Contributor(s):
3849 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3850
3851 * Bugfix CORE-4279
3852 Invalid error message: "CHARACTER SET OCTETS is not defined" on db creation with isc_dpb_lc_ctype = OCTETS
3853 Contributor(s):
3854 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3855
3856 * Bugfix CORE-4277
3857 It is possible to create a database with invalid character set
3858 Contributor(s):
3859 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3860
3861 * Bugfix CORE-4276
3862 Error on CREATE TABLE with "CHARACTER SET DOS775" field
3863 Contributor(s):
3864 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3865
3866 * Bugfix CORE-4107
3867 Wrong resultset (subquery + derived table + union)
3868 Contributor(s):
3869 Dmitry Yemanov <dimitr at firebirdsql.org>
3870
3871 * Bugfix CORE-3717
3872 Anomalies between 3 methods of user management regarding valid user names and passwords
3873 Contributor(s):
3874 Alex Peshkov <peshkoff at mail.ru>
3875
3876 * Bugfix CORE-3548
3877 GFIX returns an error after correctly shutting down a database
3878 Contributor(s):
3879 Alex Peshkov <peshkoff at mail.ru>
3880
3881 * Bugfix CORE-3545
3882 Inconsistent domain's constraint validation in PSQL
3883 Contributor(s):
3884 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3885
3886 * Improvement CORE-4965
3887 Extend the transaction ID space beyond 2^32 transactions
3888 Contributor(s):
3889 Dmitry Yemanov <dimitr at firebirdsql.org>
3890
3891 * Improvement CORE-4955
3892 Define a new option for DROP SHADOW command to leave the shadow file in the filesystem
3893 Contributor(s):
3894 Alex Peshkov <peshkoff at mail.ru>
3895
3896 * Improvement CORE-4939
3897 Make I/O operations with nbackup backup file aligned at page size boundary
3898 Contributor(s):
3899 Vlad Khorsun <hvlad at users.sf.net>
3900
3901 * Improvement CORE-4936
3902 Reduce internal contention in background garbage collector
3903 Contributor(s):
3904 Vlad Khorsun <hvlad at users.sf.net>
3905
3906 * Improvement CORE-4935
3907 Increase performance of backout of dead record version (or undo of just created
3908 primary record version) when backversions chain is too long
3909 Contributor(s):
3910 Vlad Khorsun <hvlad at users.sf.net>
3911
3912 * Improvement CORE-4923
3913 Add ability to track domains rename in DDL triggers
3914 See also:
3915 /doc/sql.extensions/README.ddl_triggers.txt
3916 Contributor(s):
3917 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3918
3919 * Improvement CORE-4911
3920 Providers enumeration should not be continued on most of errors taking place in the provider
3921 Contributor(s):
3922 Alex Peshkov <peshkoff at mail.ru>
3923
3924 * Improvement CORE-4898
3925 Speed up function creation and loading when there are many functions in the database
3926 Contributor(s):
3927 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3928
3929 * Improvement CORE-4881
3930 Increase maximum string literal length to 64KB while setting a lower limit (of characters)
3931 for multi-byte charsets based on their maximum character length
3932 Contributor(s):
3933 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3934
3935 * Improvement CORE-4880
3936 Better performance of creating packages containing many functions
3937 Contributor(s):
3938 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3939
3940 * Improvement CORE-4879
3941 Minor inconvenience in user management via services API
3942 Contributor(s):
3943 Alex Peshkov <peshkoff at mail.ru>
3944
3945 * Improvement CORE-4851
3946 Make tracing/audit aware of multiple security databases authentication
3947 Contributor(s):
3948 Alex Peshkov <peshkoff at mail.ru>
3949
3950 * Improvement CORE-3782
3951 Convert password/user name into UTF-8 before encryption
3952 Contributor(s):
3953 Alex Peshkov <peshkoff at mail.ru>
3954
3955 * Improvement CORE-1999
3956 Timestamps in the GBAK output
3957 Contributor(s):
3958 Vlad Khorsun <hvlad at users.sf.net>
3959
3960
3961 *************
3962 * v3.0 Beta 2
3963 *************
3964
3965 * Bugfix CORE-4839
3966 SHOW GRANTS does not display info about exceptions which were granted to user
3967 Contributor(s):
3968 Dmitry Yemanov <dimitr at firebirdsql.org>
3969
3970 * Bugfix CORE-4831
3971 Revoke all on all from role <R> -- failed with "SQL role <R> does not exist in security database"
3972 Contributor(s):
3973 Alex Peshkov <peshkoff at mail.ru>
3974
3975 * Bugfix CORE-4821
3976 Ensure CREATE DATABASE right is granted only to roles that do exist in security database
3977 Contributor(s):
3978 Alex Peshkov <peshkoff at mail.ru>
3979
3980 * Bugfix CORE-4819
3981 EXECUTE PROCEDURE's RETURNING_VALUES and EXECUTE STATEMENT's INTO does not check validity of assignments targets leading to bugcheck
3982 Contributor(s):
3983 Adriano dos Santos Fernandes <adrianosf at gmail.com>
3984
3985 * Bugfix CORE-4817
3986 ISQL doesn`t show number of affected rows for "MERGE ... WHEN MATCHING" in case when this number surely > 0
3987 Contributor(s):
3988 Claudio Valderrama C. <cvalde at usa.net>
3989
3990 * Bugfix CORE-4809
3991 HASH/MERGE JOIN is not used for more than two streams if they are joined via USING/NATURAL clauses
3992 and join is based on DBKEY concatenations
3993 Contributor(s):
3994 Dmitry Yemanov <dimitr at firebirdsql.org>
3995
3996 * Bugfix CORE-4807
3997 Regression: List of aggregation is not checked properly
3998 Contributor(s):
3999 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4000
4001 * Bugfix CORE-4806
4002 Regression: generators can be seen/modified by unprivileged users
4003 Contributor(s):
4004 Dmitry Yemanov <dimitr at firebirdsql.org>
4005
4006 * Bugfix CORE-4802
4007 GRANT UPDATE(<some_column>) on <T> acts like grant update on ALL columns of <T>
4008 Contributor(s):
4009 Alex Peshkov <peshkoff at mail.ru>
4010
4011 * Bugfix CORE-4798
4012 Regression: MIN/MAX with a join ignores possible index navigation
4013 Contributor(s):
4014 Dmitry Yemanov <dimitr at firebirdsql.org>
4015
4016 * Bugfix CORE-4795
4017 fbclient executes event callback function twice
4018 Contributor(s):
4019 Alex Peshkov <peshkoff at mail.ru>
4020
4021 * Bugfix CORE-4794
4022 isc_cancel_events() returns error invalid events id (handle) (code: 335545021) if event is no longer queued
4023 Contributor(s):
4024 Alex Peshkov <peshkoff at mail.ru>
4025
4026 * Bugfix CORE-4789
4027 Prohibit ability to cast timestamps that out of valid range to [VAR]CHAR
4028 Contributor(s):
4029 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4030
4031 * Bugfix CORE-4788
4032 SuperClassic server hangs when receiving network packet
4033 Contributor(s):
4034 Alex Peshkov <peshkoff at mail.ru>
4035
4036 * Bugfix CORE-4786
4037 Problematic key value (when attempt to insert duplicate in PK/UK) is not shown where length of key >= 127 characters
4038 Contributor(s):
4039 Dmitry Yemanov <dimitr at firebirdsql.org>
4040
4041 * Bugfix CORE-4785
4042 Bad packet of op_execute kills the server
4043 Contributor(s):
4044 Alex Peshkov <peshkoff at mail.ru>
4045
4046 * Bugfix CORE-4782
4047 Command `SHOW TABLE` fails when the table contains field with unicode collation in its DDL
4048 Contributor(s):
4049 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4050
4051 * Bugfix CORE-4781
4052 Maximum string length (32765 bytes) is not validated by the parser
4053 Contributor(s):
4054 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4055
4056 * Bugfix CORE-4774
4057 Table aliasing is unnecessary required when doing UPDATE ... RETURNING RDB$ pseudo-columns
4058 Contributor(s):
4059 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4060
4061 * Bugfix CORE-4768
4062 CREATE USER ... TAGS ( argument_1 = 'value1', ..., argument_N = 'valueN' ) - wrong results of statement when there are many arguments
4063 Contributor(s):
4064 Alex Peshkov <peshkoff at mail.ru>
4065
4066 * Bugfix CORE-4767
4067 CREATE USER ... TAGS ( attr = "prefix #suffix" ): "suffix" will be removed from storage because of character # in the value of attribute
4068 Contributor(s):
4069 Alex Peshkov <peshkoff at mail.ru>
4070
4071 * Bugfix CORE-4766
4072 AV when trying to manage users list using EXECUTE STATEMENT on behalf of non-SYSDBA user which has RDB$ADMIN role
4073 Contributor(s):
4074 Vlad Khorsun <hvlad at users.sf.net>
4075
4076 * Bugfix CORE-4760
4077 Cannot create user with non-ascii (multi-byte) characters in the name
4078 Contributor(s):
4079 Alex Peshkov <peshkoff at mail.ru>
4080
4081 * Bugfix CORE-4759
4082 Request synchronization error when building an expression index
4083 Contributor(s):
4084 Vlad Khorsun <hvlad at users.sf.net>
4085
4086 * Bugfix CORE-4756
4087 Firebird 3 events broken
4088 Contributor(s):
4089 Alex Peshkov <peshkoff at mail.ru>
4090
4091 * Bugfix CORE-4755
4092 Parameterized exception: wrong output when number of arguments greater than 7
4093 Contributor(s):
4094 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4095
4096 * Bugfix CORE-4754
4097 Manipulations with GTT from several attachments (using ES/EDS and different roles) leads to:
4098 "internal Firebird consistency check (invalid SEND request (167), file: JrdStatement.cpp line: 325)"
4099 Contributor(s):
4100 Vlad Khorsun <hvlad at users.sf.net>
4101
4102 * Bugfix CORE-4753
4103 Firebird hangs in the embedded mode
4104 Contributor(s):
4105 Vlad Khorsun <hvlad at users.sf.net>
4106
4107 * Bugfix CORE-4752
4108 EXECUTE STATEMENT using BLOB parameters results in "Invalid BLOB ID" error
4109 Contributor(s):
4110 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4111
4112 * Bugfix CORE-4747
4113 Error "invalid BLOB ID" can occur when retrieving MON$STATEMENTS.MON$SQL_TEXT using ES/EDS and db_connect argument is not specified
4114 Contributor(s):
4115 Vlad Khorsun <hvlad at users.sf.net>
4116
4117 * Bugfix CORE-4744
4118 ALTER DATABASE SET DEFAULT CHARACTER SET: 1) take effect only for once for current attachment; 2) does not check that new char set exists untill it will be used
4119 Contributor(s):
4120 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4121
4122 * Bugfix CORE-4743
4123 Granted role does not work with non-ASCII user name
4124 Contributor(s):
4125 Alex Peshkov <peshkoff at mail.ru>
4126
4127 * Bugfix CORE-4740
4128 SIMILAR TO with quantifier {n,} in the pattern: 1) fails on 2.5 ("Invalid pattern"), 2) strange result in 3.0
4129 Contributor(s):
4130 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4131
4132 * Bugfix CORE-4733
4133 Command "ALTER TABLE <T> ALTER TYPE <C> DOMAIN_WITH_NOT_NULL" does not verifies data in column <C> and makes incorrect assignments in <C> to ZERO / JULIAN_DATE / ASCII(0) for types INT, TIMESTAMP and VARCHAR
4134 Contributor(s):
4135 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4136
4137 * Bugfix CORE-4725
4138 Inconsistencies with ALTER DOMAIN and ALTER TABLE with DROP NOT NULL and PRIMARY KEYs
4139 Contributor(s):
4140 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4141
4142 * Bugfix CORE-4719
4143 Message "Statement failed, SQLSTATE = 00000 + unknown ISC error 0" appears when issuing REVOKE ALL ON ALL FROM <existing_user>
4144 Contributor(s):
4145 Alex Peshkov <peshkoff at mail.ru>
4146
4147 * Bugfix CORE-4715
4148 Restore of shadowed database fails using -k ("restore without shadow") switch
4149 Contributor(s):
4150 Alex Peshkov <peshkoff at mail.ru>
4151
4152 * Bugfix CORE-4713
4153 "BLOB not found" error at rollback after insert into table with expression index
4154 Contributor(s):
4155 Vlad Khorsun <hvlad at users.sf.net>
4156
4157 * Bugfix CORE-4712
4158 Messages "Error in isc_release_request() ... when working with legacy security database" appear in firebird.log for CLASSIC server when connecting with legacy auth
4159 Contributor(s):
4160 Alex Peshkov <peshkoff at mail.ru>
4161
4162 * Bugfix CORE-4706
4163 ISQL pads blob columns wrongly when the column alias has more than 17 characters
4164 Contributor(s):
4165 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4166
4167 * Bugfix CORE-4705
4168 FB3 SC crashes at disconnect after running EXECUTE STATEMENT as non-current user
4169 Contributor(s):
4170 Dmitry Yemanov <dimitr at firebirdsql.org>
4171
4172 * Bugfix CORE-4704
4173 Generator/exception permissions get corrupted after backup/restore
4174 Contributor(s):
4175 Dmitry Yemanov <dimitr at firebirdsql.org>
4176
4177 * Bugfix CORE-4702
4178 Join order in v3 is less optimal than in v2.x
4179 Contributor(s):
4180 Dmitry Yemanov <dimitr at firebirdsql.org>
4181
4182 * Bugfix CORE-4698
4183 Typing "add -user SYSDBA -pw masterkey -admin yes" into GSEC crashes firebird.exe
4184 Contributor(s):
4185 Vlad Khorsun <hvlad at users.sf.net>
4186 Alex Peshkov <peshkoff at mail.ru>
4187
4188 * Bugfix CORE-4684
4189 Error while preparing a complex query ("Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256")
4190 Contributor(s):
4191 Dmitry Yemanov <dimitr at firebirdsql.org>
4192
4193 * Bugfix CORE-4675
4194 Conditions like WHERE <field> = <cursor>.<field> don't use existing index
4195 Contributor(s):
4196 Dmitry Yemanov <dimitr at firebirdsql.org>
4197
4198 * Bugfix CORE-4673
4199 Computed index based on a computed column stores NULL for all its keys
4200 Contributor(s):
4201 Dmitry Yemanov <dimitr at firebirdsql.org>
4202
4203 * Bugfix CORE-4670
4204 Constraint violation error may be swallowed in some cases
4205 Contributor(s):
4206 Dmitry Yemanov <dimitr at firebirdsql.org>
4207
4208 * Bugfix CORE-4668
4209 SELECT FROM MON$TABLE_STATS doesn`t work on SC and CS
4210 Contributor(s):
4211 Dmitry Yemanov <dimitr at firebirdsql.org>
4212
4213 * Bugfix CORE-4665
4214 Wrong result when use "where <field_C> STARTING WITH <:value> ORDER BY <field_N>' and field_C is leading part
4215 of compound index key: { field_C, field_N }
4216 Contributor(s):
4217 Dmitry Yemanov <dimitr at firebirdsql.org>
4218
4219 * Bugfix CORE-4659
4220 Error "Missing security context for .....\SECURITY3.FDB"
4221 Contributor(s):
4222 Alex Peshkov <peshkoff at mail.ru>
4223
4224 * Bugfix CORE-4656
4225 Server could hang chasing dead record versions
4226 Contributor(s):
4227 Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
4228
4229 * Bugfix CORE-4655
4230 MSVC8 and MSVC9 builds failed
4231 Contributor(s):
4232 Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
4233
4234 * Bugfix CORE-4653
4235 Crash on infinite mutual SP calls (instead of "Too many concurrent executions of the same request.")
4236 Contributor(s):
4237 Vlad Khorsun <hvlad at users.sf.net>
4238
4239 * Bugfix CORE-4648
4240 No permission for CREATE access to DATABASE (for RDB$ADMIN)
4241 Contributor(s):
4242 Alex Peshkov <peshkoff at mail.ru>
4243
4244 * Bugfix CORE-4646
4245 Attach failure when using LegacyAuth on server and default configuration on client
4246 Contributor(s):
4247 Alex Peshkov <peshkoff at mail.ru>
4248
4249 * Bugfix CORE-4644
4250 Get open database errors under heavy concurrent load
4251 Contributor(s):
4252 Alex Peshkov <peshkoff at mail.ru>
4253
4254 * Bugfix CORE-4639
4255 Linux server may reject connections with a transliteration error
4256 Contributor(s):
4257 Dmitry Yemanov <dimitr at firebirdsql.org>
4258
4259 * Bugfix CORE-4634
4260 ORDER BY via an index + WHERE clause: error "no current record for fetch operation"
4261 Contributor(s):
4262 Dmitry Yemanov <dimitr at firebirdsql.org>
4263
4264 * Bugfix CORE-4631
4265 Lock manager "out of room" error hides the real cause of this problem
4266 Contributor(s):
4267 Dmitry Yemanov <dimitr at firebirdsql.org>
4268
4269 * Bugfix CORE-4624
4270 Firebird handles ':' characters in mount table entries invalid
4271 Contributor(s):
4272 Alex Peshkov <peshkoff at mail.ru>
4273
4274 * Bugfix CORE-4623
4275 PSQL "Domain" and "Type Of" based variables referring BLOB with sub_type < 0 no longer work
4276 Contributor(s):
4277 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4278
4279 * Bugfix CORE-4622
4280 Trigger with UPDATE OR INSERT statement and IIF() not working as expected
4281 Contributor(s):
4282 Dmitry Yemanov <dimitr at firebirdsql.org>
4283
4284 * Bugfix CORE-4618
4285 Rollback doesn`t undo changes when MERGE statement updates the same target rows multiple times and PLAN MERGE is used
4286 Contributor(s):
4287 Dmitry Yemanov <dimitr at firebirdsql.org>
4288
4289 * Bugfix CORE-4604
4290 EXECUTE STATEMENT raises CHAR_LENGTH() size for VARCHARs
4291 Contributor(s):
4292 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4293
4294 * Bugfix CORE-4599
4295 REPLACE function works incorrectly with multibyte charsets
4296 Contributor(s):
4297 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4298
4299 * Bugfix CORE-4583
4300 FB 3 embedded tries to load ICU DLLs from PATH folders
4301 Contributor(s):
4302 Alex Peshkov <peshkoff at mail.ru>
4303
4304 * Bugfix CORE-4582
4305 Within linger period some database properties cannot be changed
4306 Contributor(s):
4307 Alex Peshkov <peshkoff at mail.ru>
4308
4309 * Bugfix CORE-4581
4310 FB3 embedded server loads UDFs from wrong place
4311 Contributor(s):
4312 Vlad Khorsun <hvlad at users.sf.net>
4313
4314 * Bugfix CORE-4578
4315 INPUT file not properly closed
4316 Contributor(s):
4317 Alex Peshkov <peshkoff at mail.ru>
4318
4319 * Bugfix CORE-4572
4320 Incorrect error for PSQL function when the number of actual arguments does not match the number of formal arguments
4321 Contributor(s):
4322 Dmitry Yemanov <dimitr at firebirdsql.org>
4323
4324 * Bugfix CORE-4571
4325 Can't select from table with ICU columns when database is created on Linux with ICU 4.2.1 and then copied to Windows
4326 Contributor(s):
4327 Alex Peshkov <peshkoff at mail.ru>
4328
4329 * Bugfix CORE-4561
4330 BUGCHECK(183) when use cursor with "order by ID+0" and "for update with lock"
4331 Contributor(s):
4332 Dmitry Yemanov <dimitr at firebirdsql.org>
4333
4334 * Bugfix CORE-4539
4335 Server does not accept the right plan
4336 Contributor(s):
4337 Dmitry Yemanov <dimitr at firebirdsql.org>
4338
4339 * Bugfix CORE-4507
4340 Unable delete procedure source on Firebird 3.0 Alpha 2.0
4341 Contributor(s):
4342 Dmitry Yemanov <dimitr at firebirdsql.org>
4343
4344 * Bugfix CORE-4503
4345 ISQL command SHOW USERS display only the current user
4346 Contributor(s):
4347 Alex Peshkov <peshkoff at mail.ru>
4348
4349 * Bugfix CORE-4472
4350 Message "Modifying function <F> which is currently in use" when <F> is called from internal function declared in other unit
4351 Contributor(s):
4352 Dmitry Yemanov <dimitr at firebirdsql.org>
4353
4354 * Bugfix CORE-4471
4355 Legacy_Auth plugin does not connect from FB3 to FB2.5 server when tried after Win_Sspi
4356 Contributor(s):
4357 Alex Peshkov <peshkoff at mail.ru>
4358
4359 * Bugfix CORE-4384
4360 Problems when a table grows beyond 65535 pointer pages
4361 Contributor(s):
4362 Dmitry Yemanov <dimitr at firebirdsql.org>
4363
4364 * Bugfix CORE-4383
4365 Index and BLOBs garbage collection doesn't work for in-place updates
4366 Contributor(s):
4367 Dimitry Sibiryakov <sd at ibphoenix.com>
4368 Dmitry Yemanov <dimitr at firebirdsql.org>
4369
4370 * Bugfix CORE-4382
4371 User savepoints are not released on commit
4372 Contributor(s):
4373 Dimitry Sibiryakov <sd at ibphoenix.com>
4374
4375 * Bugfix CORE-4369
4376 BUGCHECK(177) for MERGE with multiple matches
4377 Contributor(s):
4378 Dmitry Yemanov <dimitr at firebirdsql.org>
4379
4380 * Bugfix CORE-4280
4381 Stored PSQL functions accept duplicate input arguments
4382 Contributor(s):
4383 Dmitry Yemanov <dimitr at firebirdsql.org>
4384
4385 * Bugfix CORE-4259
4386 Don't call setlocale(LC_CTYPE, "") in ISQL for Windows
4387 Contributor(s):
4388 Frank Schlottmann-Goedde <frank at schlottmann-goedde.de>
4389 Dmitry Yemanov <dimitr at firebirdsql.org>
4390
4391 * Bugfix CORE-4161
4392 Cannot insert records into table with column "GENERATED BY DEFAULT AS IDENTITY" in its DDL
4393 Contributor(s):
4394 Dmitry Yemanov <dimitr at firebirdsql.org>
4395
4396 * Bugfix CORE-4075
4397 Server bugchecks or crashes on exception in calculated index
4398 Contributor(s):
4399 Dmitry Yemanov <dimitr at firebirdsql.org>
4400
4401 * Bugfix CORE-3632
4402 Crash after calling fork() in a process using libfbembed.so
4403 Contributor(s):
4404 Alex Peshkov <peshkoff at mail.ru>
4405
4406 * Bugfix CORE-3373
4407 It is possible to store string with lenght 31 chars into column VARCHAR(25)
4408 Contributor(s):
4409 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4410
4411 * Bugfix CORE-2932
4412 Wrong field position after ALTER POSITION
4413 Contributor(s):
4414 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4415
4416 * Bugfix CORE-2848
4417 Page-level "lock conversion denied" or "lock denied" errors
4418 Contributor(s):
4419 Vlad Khorsun <hvlad at users.sf.net>
4420
4421 * Bugfix CORE-214
4422 COUNT (DISTINCT ...) is too slow
4423 Contributor(s):
4424 Dmitry Yemanov <dimitr at firebirdsql.org>
4425
4426 * Improvement CORE-4811
4427 Make user names behave according to SQL identifiers rules
4428 Contributor(s):
4429 Alex Peshkov <peshkoff at mail.ru>
4430
4431 * Improvement CORE-4791
4432 Make INSERTING/UPDATING/DELETING reserved words to fix ambiguity with boolean expresions
4433 Contributor(s):
4434 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4435
4436 * Improvement CORE-4735
4437 Expression 'where bool_field IS true | false' should also use index as 'where bool_field = true | false' (if such index exists)
4438 Contributor(s):
4439 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4440
4441 * Improvement CORE-4731
4442 Prohibit an ability to issue DML or DDL statements on RDB$ tables
4443 Contributor(s):
4444 Claudio Valderrama C. <cvalde at usa.net>
4445 Alex Peshkov <peshkoff at mail.ru>
4446
4447 * Improvement CORE-4729
4448 Add a flag to mon$database helping to decide what type of security database is used - default, self or other
4449 Contributor(s):
4450 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4451
4452 * Improvement CORE-4696
4453 Avoid flushing dirty pages to disk after creation of temporary table index
4454 Contributor(s):
4455 Vlad Khorsun <hvlad at users.sf.net>
4456
4457 * Improvement CORE-4685
4458 Accessing DB in invalid manner when links (hard or symbolic) are used for it
4459 Contributor(s):
4460 Alex Peshkov <peshkoff at mail.ru>
4461
4462 * Improvement CORE-4671
4463 Release internal temporary blobs early to free some memory\disk space
4464 Contributor(s):
4465 Vlad Khorsun <hvlad at users.sf.net>
4466
4467 * Improvement CORE-4610
4468 Report a tag name in diagnostics when transliteration errors in Parameter Block values occur
4469 Contributor(s):
4470 Alex Peshkov <peshkoff at mail.ru>
4471
4472 * Improvement CORE-4607
4473 Add support for having multiple UserManager's in firebird.conf and use them from SQL
4474 Contributor(s):
4475 Alex Peshkov <peshkoff at mail.ru>
4476
4477 * Improvement CORE-4605
4478 Rename CryptPlugin configuration parameter to WireCryptPlugin
4479 Contributor(s):
4480 Alex Peshkov <peshkoff at mail.ru>
4481
4482 * Improvement CORE-4590
4483 Change resulting data type of CHAR_LENGTH/BIT_LENGTH/OCTET_LENGTH of BLOBs to BIGINT
4484 Contributor(s):
4485 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4486
4487 * Improvement CORE-4386
4488 Report more details for "object in use" errors
4489 Contributor(s):
4490 Dmitry Yemanov <dimitr at firebirdsql.org>
4491
4492 * Improvement CORE-3526
4493 Support for WHEN SQLSTATE error handlers in PSQL
4494 Contributor(s):
4495 Dmitry Yemanov <dimitr at firebirdsql.org>
4496
4497 * Improvement CORE-3234
4498 Support for text BLOBs >= 32K as first argument for TRIM()
4499 Contributor(s):
4500 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4501
4502 * Improvement CORE-3226
4503 IPv6 support
4504 Contributor(s):
4505 Michal Kubeček <mike at mk-sys.cz>
4506
4507 * Improvement CORE-733
4508 Compress data over the network
4509 Contributor(s):
4510 Alex Peshkov <peshkoff at mail.ru>
4511
4512 * New feature CORE-4722
4513 Aggregate linear regression functions
4514 See also:
4515 /doc/sql.extensions/README.regr_functions.txt
4516 Contributor(s):
4517 Hajime Nakagami <nakagami at gmail.com>
4518 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4519
4520 * New feature CORE-4717
4521 Aggregate statistical functions COVAR_SAMP, COVAR_POP and CORR
4522 See also:
4523 /doc/sql.extensions/README.statistical_functions.txt
4524 Contributor(s):
4525 Hajime Nakagami <nakagami at gmail.com>
4526 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4527
4528 * New feature CORE-4714
4529 Aggregate statistical functions STDDEV_POP, STDDEV_SAMP, VAR_POP and VAR_SAMP
4530 See also:
4531 /doc/sql.extensions/README.statistical_functions.txt
4532 Contributor(s):
4533 Hajime Nakagami <nakagami at gmail.com>
4534 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4535
4536 * New feature CORE-4707
4537 Ability to validate tables and indices online (without exclusive access to the database)
4538 Contributor(s):
4539 Vlad Khorsun <hvlad at users.sf.net>
4540
4541 * New feature CORE-4526
4542 Support SQL-2008 compliant OFFSET/FETCH clauses instead of FIRST/SKIP or ROWS/TO clauses
4543 Contributor(s):
4544 Mark Rotteveel <mark at lawinegevaar.nl>
4545
4546 * New feature CORE-4438
4547 Add support for UPDATE OR INSERT statement to Embedded SQL
4548 Contributor(s):
4549 Dmitry Yemanov <dimitr at firebirdsql.org>
4550
4551 * New feature CORE-4437
4552 Add support for the RETURNING clause to Embedded SQL
4553 Contributor(s):
4554 Dmitry Yemanov <dimitr at firebirdsql.org>
4555
4556 * New feature CORE-803
4557 Server bi-directional (aka scrollable) cursors
4558 See also:
4559 /doc/sql.extensions/README.scrollable_cursors.txt
4560 Contributor(s):
4561 Dmitry Yemanov <dimitr at firebirdsql.org>
4562
4563
4564 *************
4565 * v3.0 Beta 1
4566 *************
4567
4568 * Bugfix CORE-4576
4569 Cache writer thread could not start
4570 Contributor(s):
4571 Vlad Khorsun <hvlad at users.sf.net>
4572
4573 * Bugfix CORE-4575
4574 Server crashes in the garbage collector thread at disconnect of last attachment
4575 Contributor(s):
4576 Vlad Khorsun <hvlad at users.sf.net>
4577
4578 * Bugfix CORE-4574
4579 Regression: Incorrect result in subquery with aggregate
4580 Contributor(s):
4581 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4582
4583 * Bugfix CORE-4570
4584 Wrong error at ALTER PACKAGE
4585 Contributor(s):
4586 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4587
4588 * Bugfix CORE-4568
4589 Server may crash while disconnecting from the database under load
4590 Contributor(s):
4591 Dmitry Yemanov <dimitr at firebirdsql.org>
4592
4593 * Bugfix CORE-4566
4594 Incorrect size of the output parameter/argument when execute block, procedure or function use system field in metadata charset
4595 Contributor(s):
4596 Alex Peshkov <peshkoff at mail.ru>
4597
4598 * Bugfix CORE-4565
4599 GDSCODE can have value = 0 in WHEN-section under some concurrent env., only in SC or CS (not in SS)
4600 Contributor(s):
4601 Vlad Khorsun <hvlad at users.sf.net>
4602
4603 * Bugfix CORE-4555
4604 DDL trigger remains active after dropped
4605 Contributor(s):
4606 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4607
4608 * Bugfix CORE-4530
4609 DB_KEY based join of two tables may be ineffective
4610 Contributor(s):
4611 Dmitry Yemanov <dimitr at firebirdsql.org>
4612
4613 * Bugfix CORE-4522
4614 DDL permission do not protect against removal BLOB filters
4615 Contributor(s):
4616 Roman Simakov <roman.simakov at red-soft.biz>
4617
4618 * Bugfix CORE-4515
4619 Regression: trace reports UPDATES in statistics when doing INSERT into <some_table>
4620 Contributor(s):
4621 Dmitry Yemanov <dimitr at firebirdsql.org>
4622
4623 * Bugfix CORE-4510
4624 Database validation bug can cause server to crash
4625 Contributor(s):
4626 Vlad Khorsun <hvlad at users.sf.net>
4627
4628 * Bugfix CORE-4506
4629 Server crashes when execute most of "show ..." commands after reconnect
4630 Contributor(s):
4631 Alex Peshkov <peshkoff at mail.ru>
4632
4633 * Bugfix CORE-4505
4634 Use of named cursor fails if statement was not executed
4635 Contributor(s):
4636 Alex Peshkov <peshkoff at mail.ru>
4637
4638 * Bugfix CORE-4500
4639 Firebird crashes after unsuccessful remapping of the lock table's shared memory
4640 Contributor(s):
4641 Dmitry Yemanov <dimitr at firebirdsql.org>
4642
4643 * Bugfix CORE-4498
4644 Server crashes when getting an explained plan for a DBKEY based retrieval
4645 Contributor(s):
4646 Dmitry Yemanov <dimitr at firebirdsql.org>
4647
4648 * Bugfix CORE-4489
4649 Error: statement already has a cursor <cursor_name> assigned
4650 Contributor(s):
4651 Alex Peshkov <peshkoff at mail.ru>
4652
4653 * Bugfix CORE-4488
4654 Wrong results of FOR SELECT <L> FROM <T> AS CURSOR <C> and table <T> is modified inside cursor's begin...end block
4655 Contributor(s):
4656 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4657
4658 * Bugfix CORE-4480
4659 ISQL issues warning: "Bad debug info format" when connect to database with stored function after it's restoring
4660 Contributor(s):
4661 Dmitry Yemanov <dimitr at firebirdsql.org>
4662
4663 * Bugfix CORE-4478
4664 Failure to load provider/plugin is reported nowhere
4665 Contributor(s):
4666 Alex Peshkov <peshkoff at mail.ru>
4667
4668 * Bugfix CORE-4477
4669 Field RDB$MAP_TO_TYPE is not present in RDB$TYPES
4670 Contributor(s):
4671 Alex Peshkov <peshkoff at mail.ru>
4672
4673 * Bugfix CORE-4470
4674 GBAK fails to restore database containing dependency between views and packaged functions
4675 Contributor(s):
4676 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4677
4678 * Bugfix CORE-4468
4679 CREATE USER GRANT ADMIN ROLE does not work
4680 Contributor(s):
4681 Alex Peshkov <peshkoff at mail.ru>
4682
4683 * Bugfix CORE-4464
4684 Duplicate tags for CREATE/ALTER USER are not handled correctly
4685 Contributor(s):
4686 Alex Peshkov <peshkoff at mail.ru>
4687
4688 * Bugfix CORE-4461
4689 NBACKUP prints error messages to stdout instead of stderr
4690 Contributor(s):
4691 Alex Peshkov <peshkoff at mail.ru>
4692
4693 * Bugfix CORE-4453
4694 Regression: NOT NULL constraint, declared in domain, does not work
4695 Contributor(s):
4696 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4697
4698 * Bugfix CORE-4447
4699 Positioned UPDATE statement prohibits index usage for the subsequent cursor field references
4700 Contributor(s):
4701 Dmitry Yemanov <dimitr at firebirdsql.org>
4702
4703 * Bugfix CORE-4444
4704 Engine could hung and block all attachments in out of disk space condition during physical backup
4705 Contributor(s):
4706 Vlad Khorsun <hvlad at users.sf.net>
4707
4708 * Bugfix CORE-4440
4709 ISQL crashes without connect when execute command "show version"
4710 Contributor(s):
4711 Alex Peshkov <peshkoff at mail.ru>
4712
4713 * Bugfix CORE-4435
4714 After calling release() for attachment to database (instead detach) in embedded mode attachment remains active forever
4715 Contributor(s):
4716 Alex Peshkov <peshkoff at mail.ru>
4717
4718 * Bugfix CORE-4433
4719 GlobalRWLock could not downgrade EX lock to SH if readers are present
4720 Contributor(s):
4721 Vlad Khorsun <hvlad at users.sf.net>
4722
4723 * Bugfix CORE-4430
4724 Properties of user created in Legacy_UserManager padded with space up to 10 character
4725 Contributor(s):
4726 Alex Peshkov <peshkoff at mail.ru>
4727
4728 * Bugfix CORE-4425
4729 User-collations based on UNICODE are not upgrade to newer ICU version on restore
4730 Contributor(s):
4731 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4732
4733 * Bugfix CORE-4422
4734 Server crashes when using ROW_NUMBER()over( PARTITION BY x) in ORDER by clause
4735 Contributor(s):
4736 Dmitry Yemanov <dimitr at firebirdsql.org>
4737
4738 * Bugfix CORE-4419
4739 Server crashes while sorting records longer than 128KB
4740 Contributor(s):
4741 Dmitry Yemanov <dimitr at firebirdsql.org>
4742
4743 * Bugfix CORE-4417
4744 GBAK: cannot commit index; primary key with german umlaut
4745 Contributor(s):
4746 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4747
4748 * Bugfix CORE-4415
4749 Useless extraction of generic DDL trigger
4750 Contributor(s):
4751 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4752
4753 * Bugfix CORE-4396
4754 Incorrect query result if it is executed via EXECUTE STATEMENT
4755 Contributor(s):
4756 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4757
4758 * Bugfix CORE-4395
4759 EXECUTE STATEMENT ON EXTERNAL doesn't find Firebird 2.5 database
4760 Contributor(s):
4761 Alex Peshkov <peshkoff at mail.ru>
4762
4763 * Bugfix CORE-4394
4764 Cursor not found error when using legacy API
4765 Contributor(s):
4766 Alex Peshkov <peshkoff at mail.ru>
4767
4768 * Bugfix CORE-4388
4769 SELECT WITH LOCK may enter an infinite loop for a single record
4770 Contributor(s):
4771 Dmitry Yemanov <dimitr at firebirdsql.org>
4772
4773 * Bugfix CORE-4381
4774 Incorrect line/column information in runtime errors
4775 Contributor(s):
4776 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4777
4778 * Bugfix CORE-4380
4779 ISQL truncates blob when reading an empty segment
4780 Contributor(s):
4781 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4782
4783 * Bugfix CORE-4379
4784 Poor performance of explicit cursors containing correlated subqueries in the select list
4785 Contributor(s):
4786 Dmitry Yemanov <dimitr at firebirdsql.org>
4787
4788 * Bugfix CORE-4376
4789 Preparation of erroneous DDL statement does not show the main command failed
4790 Contributor(s):
4791 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4792
4793 * Bugfix CORE-4375
4794 Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
4795 Contributor(s):
4796 Dmitry Yemanov <dimitr at firebirdsql.org>
4797
4798 * Bugfix CORE-4374
4799 Truncation error when using EXECUTE STATEMENT with a blob
4800 Contributor(s):
4801 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4802
4803 * Bugfix CORE-4373
4804 Duplicate names in package are not checked
4805 Contributor(s):
4806 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4807
4808 * Bugfix CORE-4372
4809 Deadlock is possible when two data pages contains record fragments pointing to each other
4810 Contributor(s):
4811 Vlad Khorsun <hvlad at users.sf.net>
4812
4813 * Bugfix CORE-4371
4814 Create function/sp which references to non-existent exception: error message is "Error while parsing function's BLR"
4815 instead of "exception not defined"
4816 Contributor(s):
4817 Dmitry Yemanov <dimitr at firebirdsql.org>
4818
4819 * Bugfix CORE-4366
4820 Wrong result of WHERE predicate when it contains NULL IS NOT DISTINCT FROM (select min(NULL) from ...)
4821 Contributor(s):
4822 Dmitry Yemanov <dimitr at firebirdsql.org>
4823
4824 * Bugfix CORE-4365
4825 Equality predicate distribution does not work for some complex queries
4826 Contributor(s):
4827 Dmitry Yemanov <dimitr at firebirdsql.org>
4828
4829 * Bugfix CORE-4360
4830 SELECT from derived table which contains GROUP BY on field with literal value returns wrong result
4831 Contributor(s):
4832 Dmitry Yemanov <dimitr at firebirdsql.org>
4833
4834 * Bugfix CORE-4354
4835 Parsing of recursive query returns error "Column does not belong to referenced table" for source having such a column
4836 Contributor(s):
4837 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4838
4839 * Bugfix CORE-4353
4840 Sorting records are larger than really necessary
4841 Contributor(s):
4842 Dmitry Yemanov <dimitr at firebirdsql.org>
4843
4844 * Bugfix CORE-4346
4845 v3 GBAK cannot restore backups on pre-v3 server versions
4846 Contributor(s):
4847 Dmitry Yemanov <dimitr at firebirdsql.org>
4848
4849 * Bugfix CORE-4344
4850 Error "no current record for fetch operation" when table inner join procedure inner join table
4851 Contributor(s):
4852 Dmitry Yemanov <dimitr at firebirdsql.org>
4853
4854 * Bugfix CORE-4334
4855 Resources (e.g. sort files) owned by trigger may not be released when it's interrupted asynchronously
4856 Contributor(s):
4857 Dmitry Yemanov <dimitr at firebirdsql.org>
4858
4859 * Bugfix CORE-4331
4860 LAG, LEAD and NTH_VALUE raise error when the second argument is NULL
4861 Contributor(s):
4862 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4863
4864 * Bugfix CORE-4330
4865 Incorrect result for function LAG if OFFSET value is assigned from a table
4866 Contributor(s):
4867 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4868
4869 * Bugfix CORE-4327
4870 Error in QLI when copying NULL blobs between databases
4871 Contributor(s):
4872 Alex Peshkov <peshkoff at mail.ru>
4873
4874 * Bugfix CORE-4326
4875 Keyword SET should not be required in ALTER USER statement
4876 Contributor(s):
4877 Alex Peshkov <peshkoff at mail.ru>
4878
4879 * Bugfix CORE-4322
4880 Engine crashes when use aggregate or window functions in recursive query
4881 Contributor(s):
4882 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4883
4884 * Bugfix CORE-4321
4885 Regression: ISQL does not destroy the SQL statement
4886 Contributor(s):
4887 Alex Peshkov <peshkoff at mail.ru>
4888
4889 * Bugfix CORE-4320
4890 Regression: ISQL crashes when receiving statistics of execution of sql query
4891 Contributor(s):
4892 Vlad Khorsun <hvlad at users.sf.net>
4893
4894 * Bugfix CORE-4319
4895 Engine crashes when trace config contains line "connection_id=NN" and we attempt to connect to non-existent database/alias
4896 Contributor(s):
4897 Vlad Khorsun <hvlad at users.sf.net>
4898
4899 * Bugfix CORE-4318
4900 Regression: Predicates involving PSQL variables/parameters are not pushed inside the aggregation
4901 Contributor(s):
4902 Dmitry Yemanov <dimitr at firebirdsql.org>
4903
4904 * Bugfix CORE-4313
4905 Error "Attempt to reopen an open cursor" may be raised if the query handle is reused in a different transaction
4906 Contributor(s):
4907 Dmitry Yemanov <dimitr at firebirdsql.org>
4908
4909 * Bugfix CORE-4309
4910 'Cache Writer' record in MON$ATTACHMENTS dissapear when delete other connection that running some 'heavy update' on big table
4911 via delete from MON$ATTACHMENTS
4912 Contributor(s):
4913 Vlad Khorsun <hvlad at users.sf.net>
4914
4915 * Bugfix CORE-4307
4916 Fields present only in WHERE clause of views WITH CHECK OPTION causes invalid CHECK CONSTRAINT violation
4917 Contributor(s):
4918 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4919
4920 * Bugfix CORE-4304
4921 Engine crashes when attempt to REcreate table with FK after syntax error before such recreating
4922 Contributor(s):
4923 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4924
4925 * Bugfix CORE-4303
4926 Possible races while service destruction
4927 Contributor(s):
4928 Alex Peshkov <peshkoff at mail.ru>
4929
4930 * Bugfix CORE-4301
4931 Non-ASCII data in SEC$USERS is not read correctly
4932 Contributor(s):
4933 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4934
4935 * Bugfix CORE-4286
4936 "Statement already has a cursor assigned" error when trying to execute another SQL statement using different cursor name
4937 Contributor(s):
4938 Alex Peshkov <peshkoff at mail.ru>
4939
4940 * Bugfix CORE-4275
4941 CREATE DATABASE fault if fbclient.dll loaded from another directory (Providers = Engine12)
4942 Contributor(s):
4943 Vlad Khorsun <hvlad at users.sf.net>
4944
4945 * Bugfix CORE-4118
4946 Expression index may be not used for derived fields or view fields
4947 Contributor(s):
4948 Dmitry Yemanov <dimitr at firebirdsql.org>
4949
4950 * Bugfix CORE-3305
4951 "BLOB not found" error after creation/altering of the invalid trigger
4952 Contributor(s):
4953 Dmitry Yemanov <dimitr at firebirdsql.org>
4954
4955 * Bugfix CORE-2350
4956 Too long column name for select alias should be rejected
4957 Contributor(s):
4958 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4959
4960 * Bugfix CORE-2350
4961 Too long column name for select alias should be rejected
4962 Contributor(s):
4963 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4964
4965 * Bugfix CORE-1475
4966 Database which has active attachments can not be replaced from backup file even after database shut down
4967 Contributor(s):
4968 Dmitry Yemanov <dimitr at firebirdsql.org>
4969
4970 * Improvement CORE-4573
4971 Avoid need in fake -pas switch when using GSEC in embedded mode
4972 Contributor(s):
4973 Alex Peshkov <peshkoff at mail.ru>
4974
4975 * Improvement CORE-4564
4976 Add per-table performance counters to the monitoring tables
4977 Contributor(s):
4978 Dmitry Yemanov <dimitr at firebirdsql.org>
4979
4980 * Improvement CORE-4562
4981 Split all validation messages to critical and minor ones
4982 Contributor(s):
4983 Vlad Khorsun <hvlad at users.sf.net>
4984
4985 * Improvement CORE-4556
4986 Allocate data pages in group of sequential ordered pages (extents)
4987 Contributor(s):
4988 Vlad Khorsun <hvlad at users.sf.net>
4989
4990 * Improvement CORE-4528
4991 Allow hash/merge joins for non-field (dbkey or derived expression) equalities
4992 Contributor(s):
4993 Dmitry Yemanov <dimitr at firebirdsql.org>
4994
4995 * Improvement CORE-4487
4996 Maintain package body after ALTER/RECREATE PACKAGE
4997 Contributor(s):
4998 Adriano dos Santos Fernandes <adrianosf at gmail.com>
4999
5000 * Improvement CORE-4484
5001 Description (COMMENT ON) for package procedures and functions, and its parameters
5002 Contributor(s):
5003 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5004
5005 * Improvement CORE-4469
5006 Add field in SEC$USERS reflecting whether a user has RDB$ADMIN role in security database
5007 Contributor(s):
5008 Alex Peshkov <peshkoff at mail.ru>
5009
5010 * Improvement CORE-4457
5011 DATEADD should support fractional value for MILLISECOND
5012 Contributor(s):
5013 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5014
5015 * Improvement CORE-4451
5016 Allow trace output to show the explained plan
5017 Contributor(s):
5018 Vlad Khorsun <hvlad at users.sf.net>
5019
5020 * Improvement CORE-4445
5021 Extend main database file faster when physical backup state changed from stalled to merge
5022 Contributor(s):
5023 Vlad Khorsun <hvlad at users.sf.net>
5024
5025 * Improvement CORE-4443
5026 Use fast file grow on those Linux systems that support it
5027 Contributor(s):
5028 Vlad Khorsun <hvlad at users.sf.net>
5029
5030 * Improvement CORE-4439
5031 Raise the 1024 connections limit (FD_SETSIZE) on Windows SS/SC
5032 Contributor(s):
5033 Paul Beach <pbeach at ibphoenix.com>
5034
5035 * Improvement CORE-4434
5036 Extend the use of colon prefix for read/assignment OLD/NEW fields and assignment to variables
5037 Contributor(s):
5038 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5039
5040 * Improvement CORE-4432
5041 Let attachments to not block others when allocation table is read first time
5042 Contributor(s):
5043 Vlad Khorsun <hvlad at users.sf.net>
5044
5045 * Improvement CORE-4431
5046 Reduce contention for allocation table lock while database is in stalled physical backup state
5047 Contributor(s):
5048 Vlad Khorsun <hvlad at users.sf.net>
5049
5050 * Improvement CORE-4403
5051 Allow referencing cursors as record variables in PSQL
5052 Contributor(s):
5053 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5054 Dmitry Yemanov <dimitr at firebirdsql.org>
5055
5056 * Improvement CORE-4398
5057 Provide ability to specify extra-long name of log when doing gbak to avoid "attempt to store 256 bytes in a clumplet" message
5058 Contributor(s):
5059 Alex Peshkov <peshkoff at mail.ru>
5060
5061 * Improvement CORE-4387
5062 IStatement::execute() and IAttachment::execute() functions should return on error pointer to old transaction interface
5063 Contributor(s):
5064 Alex Peshkov <peshkoff at mail.ru>
5065
5066 * Improvement CORE-4345
5067 Ability to trace stored functions execution
5068 Contributor(s):
5069 Vlad Khorsun <hvlad at users.sf.net>
5070
5071 * Improvement CORE-4310
5072 DATEADD: change input <amount> argument from INT to BIGINT
5073 Contributor(s):
5074 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5075
5076 * Improvement CORE-4252
5077 Add table name to text of validation contraint error message, to help identify error context
5078 Contributor(s):
5079 Vlad Khorsun <hvlad at users.sf.net>
5080
5081 * Improvement CORE-3881
5082 Extend the error reported for index/constraint violations to include the problematic key value
5083 Contributor(s):
5084 Dmitry Yemanov <dimitr at firebirdsql.org>
5085
5086 * Improvement CORE-3242
5087 Recursive stored procedure should not require execute right to call itself
5088 Contributor(s):
5089 Alex Peshkov <peshkoff at mail.ru>
5090
5091 * Improvement CORE-2897
5092 Don't send full length of field over the wire when field is null
5093 Contributor(s):
5094 Dmitry Yemanov <dimitr at firebirdsql.org>
5095
5096 * Improvement CORE-2530
5097 Denser data stream and better prefetch logic in the network protocol
5098 Contributor(s):
5099 Dmitry Yemanov <dimitr at firebirdsql.org>
5100
5101 * Improvement CORE-2303
5102 Include PLAN in mon$statements
5103 Contributor(s):
5104 Dmitry Yemanov <dimitr at firebirdsql.org>
5105
5106 * Improvement CORE-2224
5107 Upgrade ICU to version 52.1
5108 Contributor(s):
5109 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5110
5111 * Improvement CORE-2119
5112 Use entries in restrict list of ExternalFileAccess parameter to mangle filenames with relative path
5113 Contributor(s):
5114 Alex Peshkov <peshkoff at mail.ru>
5115
5116 * Improvement CORE-1900
5117 Windows authentication: grant privileges to Windows groups
5118 Contributor(s):
5119 Alex Peshkov <peshkoff at mail.ru>
5120
5121 * Improvement CORE-1482
5122 Make optimizer to consider ORDER BY optimization when making decision about join order
5123 Contributor(s):
5124 Dmitry Yemanov <dimitr at firebirdsql.org>
5125
5126 * New feature CORE-3368
5127 Make it possible to specify non-default security database for specific database
5128 Contributor(s):
5129 Alex Peshkov <peshkoff at mail.ru>
5130
5131 * New feature CORE-2208
5132 New gbak option to ignore specific tables data during the backup
5133 Contributor(s):
5134 Dmitriy Starodubov <dmitry.starodubov at red-soft.biz>
5135 Alex Peshkov <peshkoff at mail.ru>
5136
5137 * New feature CORE-1377
5138 Add an ability to change role without reconnecting to database
5139 Contributor(s):
5140 Alex Peshkov <peshkoff at mail.ru>
5141
5142 * New feature CORE-735
5143 User rights for metadata changes
5144 Contributor(s):
5145 Roman Simakov <roman.simakov at red-soft.biz>
5146 Dmitry Yemanov <dimitr at firebirdsql.org>
5147
5148 **************
5149 * v3.0 Alpha 2
5150 **************
5151
5152 * Bugfix CORE-4302
5153 Descending index could be very inefficient for some keys
5154 Contributor(s):
5155 Vlad Khorsun <hvlad at users.sf.net>
5156
5157 * Bugfix CORE-4298
5158 fbsvcmgr doesn't recognise sts_record_versions and other sts switches
5159 Contributor(s):
5160 Alex Peshkov <peshkoff at mail.ru>
5161
5162 * Bugfix CORE-4297
5163 GFIX crashes when description of limbo transaction have size large than 1KB
5164 Contributor(s):
5165 Vlad Khorsun <hvlad at users.sf.net>
5166
5167 * Bugfix CORE-4293
5168 Server crashes on SELECT with long/complex list of compound AND/OR'd predicates
5169 Contributor(s):
5170 Dmitry Yemanov <dimitr at firebirdsql.org>
5171
5172 * Bugfix CORE-4289
5173 NOT NULL field from derived table becomes NULL when referred outside DT
5174 Contributor(s):
5175 Dmitry Yemanov <dimitr at firebirdsql.org>
5176
5177 * Bugfix CORE-4283
5178 Resource temporarily unavailable errors while simultaneously registering events
5179 Contributor(s):
5180 Alex Peshkov <peshkoff at mail.ru>
5181
5182 * Bugfix CORE-4281
5183 TYPE OF arguments of stored functions hang the server if depending domain or column is changed
5184 Contributor(s):
5185 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5186
5187 * Bugfix CORE-4271
5188 Engine crashs in case of recreation of an erratic package body
5189 Contributor(s):
5190 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5191
5192 * Bugfix CORE-4270
5193 Error in case of subquery with windowed function + where <field> IN(select ...)
5194 Contributor(s):
5195 Dmitry Yemanov <dimitr at firebirdsql.org>
5196
5197 * Bugfix CORE-4269
5198 Wrong output when field with result of windowed function is used in query
5199 with useless WHERE 0=0 and GROUP BY clause
5200 Contributor(s):
5201 Dmitry Yemanov <dimitr at firebirdsql.org>
5202
5203 * Bugfix CORE-4268
5204 Server may crash while disconnecting from a database
5205 Contributor(s):
5206 Dmitry Yemanov <dimitr at firebirdsql.org>
5207
5208 * Bugfix CORE-4267
5209 Server crashes while sweeping the database
5210 Contributor(s):
5211 Dmitry Yemanov <dimitr at firebirdsql.org>
5212
5213 * Bugfix CORE-4265
5214 Unexpected lock conflict error may be raised while connecting to a heavily loaded database
5215 Contributor(s):
5216 Dmitry Yemanov <dimitr at firebirdsql.org>
5217
5218 * Bugfix CORE-4262
5219 Context parsing error with derived tables and CASE functions
5220 Contributor(s):
5221 Dmitry Yemanov <dimitr at firebirdsql.org>
5222
5223 * Bugfix CORE-4261
5224 Wrong result of join when joined fields are created via row_number() function
5225 Contributor(s):
5226 Dmitry Yemanov <dimitr at firebirdsql.org>
5227
5228 * Bugfix CORE-4259
5229 setlocale(LC_CTYPE, "") in ISQL should not be called on Windows
5230 Contributor(s):
5231 Frank Schlottmann-Goedde <frank at schlottmann-goedde.de>
5232
5233 * Bugfix CORE-4258
5234 Wrong boundary for minimum value for BIGINT/DECIMAL(18)
5235 Contributor(s):
5236 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5237
5238 * Bugfix CORE-4255
5239 Parametrized queries using RDB$DB_KEY do not work
5240 Contributor(s):
5241 Dmitry Yemanov <dimitr at firebirdsql.org>
5242
5243 * Bugfix CORE-4251
5244 Guardian service could write garbage after the end of message in the Event Log
5245 Contributor(s):
5246 Vlad Khorsun <hvlad at users.sf.net>
5247
5248 * Bugfix CORE-4250
5249 AV in guardian at process shutdown
5250 Contributor(s):
5251 Vlad Khorsun <hvlad at users.sf.net>
5252
5253 * Bugfix CORE-4247
5254 Positioned DELETE (WHERE CURRENT OF <CURSOR>) fails for tables with newly added fields
5255 Contributor(s):
5256 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5257
5258 * Bugfix CORE-4244
5259 Problem with creation procedure which contain adding text in DOS864 charset
5260 Contributor(s):
5261 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5262
5263 * Bugfix CORE-4241
5264 Empty password will pass login
5265 Contributor(s):
5266 Alex Peshkov <peshkoff at mail.ru>
5267
5268 * Bugfix CORE-4240
5269 Recursive query in SQL query returns incorrect results if more than one branch bypass
5270 Contributor(s):
5271 Dmitry Yemanov <dimitr at firebirdsql.org>
5272
5273 * Bugfix CORE-4237
5274 FB3 vs FB2.5. Different metadata for UDF return argument
5275 Contributor(s):
5276 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5277
5278 * Bugfix CORE-4236
5279 Database shutdown is reported as successfully completed before all active connections are in fact interrupted
5280 Contributor(s):
5281 Dmitry Yemanov <dimitr at firebirdsql.org>
5282
5283 * Bugfix CORE-4235
5284 Deadlock is possible while accessing the monitoring tables under concurrent load
5285 Contributor(s):
5286 Dmitry Yemanov <dimitr at firebirdsql.org>
5287 Vlad Khorsun <hvlad at users.sf.net>
5288
5289 * Bugfix CORE-4234
5290 Error with IF (subfunc()) when subfunc returns a boolean
5291 Contributor(s):
5292 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5293
5294 * Bugfix CORE-4229
5295 Bidirectional cursor is not positioned by the first call of FETCH LAST
5296 Contributor(s):
5297 Dmitry Yemanov <dimitr at firebirdsql.org>
5298
5299 * Bugfix CORE-4227
5300 Wrong evaluation of BETWEEN and boolean expressions due to parser conflict
5301 Contributor(s):
5302 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5303
5304 * Bugfix CORE-4225
5305 Server crashes when attempting to trace activity on database having a db-level trigger
5306 Contributor(s):
5307 Vlad Khorsun <hvlad at users.sf.net>
5308
5309 * Bugfix CORE-4219
5310 Regular expressions with double-slash fail in trace
5311 Contributor(s):
5312 Alex Peshkov <peshkoff at mail.ru>
5313
5314 * Bugfix CORE-4216
5315 Memory leak with TRIGGER ON TRANSACTION COMMIT
5316 Contributor(s):
5317 Vlad Khorsun <hvlad at users.sf.net>
5318
5319 * Bugfix CORE-4214
5320 GTT should not reference permanent relation
5321 Contributor(s):
5322 Vlad Khorsun <hvlad at users.sf.net>
5323
5324 * Bugfix CORE-4212
5325 Dropping FK on GTT crashes server
5326 Contributor(s):
5327 Vlad Khorsun <hvlad at users.sf.net>
5328
5329 * Bugfix CORE-4211
5330 Embedded engine hangs for 5 seconds when closing, errors about timeout in shutdown process
5331 and invalid mutex are written into firebird.log
5332 Contributor(s):
5333 Alex Peshkov <peshkoff at mail.ru>
5334
5335 * Bugfix CORE-4205
5336 ISQL -x does not output the START WITH clause of generators/sequences
5337 Contributor(s):
5338 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5339
5340 * Bugfix CORE-4203
5341 Cannot create packaged routines with [VAR]CHAR parameters
5342 Contributor(s):
5343 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5344
5345 * Bugfix CORE-4202
5346 Backup/Restore from old version to v3.0 fails with BLR error
5347 Contributor(s):
5348 Dmitry Yemanov <dimitr at firebirdsql.org>
5349
5350 * Bugfix CORE-4201
5351 Computed field returns null value inside BEFORE INSERT trigger
5352 Contributor(s):
5353 Dmitry Yemanov <dimitr at firebirdsql.org>
5354
5355 * Bugfix CORE-4200
5356 An uncommitted select of the pseudo table sec$users blocks new database connections
5357 Contributor(s):
5358 Alex Peshkov <peshkoff at mail.ru>
5359
5360 * Bugfix CORE-4198
5361 Incorrect "token unknown" error when the SQL string ends with a hex number literal
5362 Contributor(s):
5363 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5364
5365 * Bugfix CORE-4185
5366 Server crashes with "invalid lock id (NNNNN)"
5367 Contributor(s):
5368 Alex Peshkov <peshkoff at mail.ru>
5369
5370 * Bugfix CORE-4184
5371 Error is raised while executing empty EXECUTE BLOCK with NOT NULL output parameter
5372 Contributor(s):
5373 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5374
5375 * Bugfix CORE-4180
5376 CREATE COLLATION does not verify base collation charset
5377 Contributor(s):
5378 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5379
5380 * Bugfix CORE-4178
5381 New API should return proper metadata properties, not the historical artifacts
5382 Contributor(s):
5383 Alex Peshkov <peshkoff at mail.ru>
5384
5385 * Bugfix CORE-4177
5386 Problem with some boolean expressions not being allowed
5387 Contributor(s):
5388 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5389
5390 * Bugfix CORE-4176
5391 Monitoring tables return incomplete information in SC/CS configurations
5392 Contributor(s):
5393 Dmitry Yemanov <dimitr at firebirdsql.org>
5394
5395 * Bugfix CORE-4173
5396 Setting generator value twice in single transaction will set it to zero
5397 Contributor(s):
5398 Dmitry Yemanov <dimitr at firebirdsql.org>
5399
5400 * Bugfix CORE-4168
5401 Backup containing procedures or triggers that select from external tables
5402 cannot be restored with ExternalFileAccess=None
5403 Contributor(s):
5404 Dmitry Yemanov <dimitr at firebirdsql.org>
5405
5406 * Bugfix CORE-4164
5407 Owner name is missing for generators/exceptions restored from a backup
5408 Contributor(s):
5409 Dmitry Yemanov <dimitr at firebirdsql.org>
5410
5411 * Bugfix CORE-4163
5412 Configuration fbtrace.conf contains syntax errors
5413 Contributor(s):
5414 Alex Peshkov <peshkoff at mail.ru>
5415
5416 * Bugfix CORE-4162
5417 Warnings are not returned from attachDatabase() call
5418 Contributor(s):
5419 Alex Peshkov <peshkoff at mail.ru>
5420
5421 * Bugfix CORE-4160
5422 The parameterized exception does not accept not ASCII characters as parameter
5423 Contributor(s):
5424 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5425
5426 * Bugfix CORE-4159
5427 Incorrect memory statistics is reported
5428 Contributor(s):
5429 Dmitry Yemanov <dimitr at firebirdsql.org>
5430
5431 * Bugfix CORE-4158
5432 LIKE with escape doesn't work
5433 Contributor(s):
5434 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5435
5436 * Bugfix CORE-4156
5437 RDB$GET_CONTEXT/RDB$SET_CONTEXT parameters incorrectly described as CHAR NOT NULL instead of VARCHAR NULLABLE
5438 Contributor(s):
5439 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5440
5441 * Bugfix CORE-4155
5442 External routines DDL in packages wrongly report error for termination with semi-colon
5443 Contributor(s):
5444 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5445
5446 * Bugfix CORE-4153
5447 Attempting to use Legacy_Auth directly after install doesn't work, restart of service is required
5448 Contributor(s):
5449 Paul Reeves <preeves at ibphoenix.com>
5450
5451 * Bugfix CORE-4149
5452 New permission types are not displayed by ISQL
5453 Contributor(s):
5454 Dmitry Yemanov <dimitr at firebirdsql.org>
5455
5456 * Bugfix CORE-4145
5457 Memory leak when preparing EEXECUTE BLOCK which uses domains
5458 Contributor(s):
5459 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5460
5461 * Bugfix CORE-3989
5462 Bad performance / slow response when many concurrent sorts are executed
5463 Contributor(s):
5464 Dmitry Yemanov <dimitr at firebirdsql.org>
5465
5466 * Bugfix CORE-3921
5467 Bugcheck 186 (record disappeared) and 100% CPU load (when bugcheckabort=1 and sweep starts at gap ~21000)
5468 Contributor(s):
5469 Vlad Khorsun <hvlad at users.sf.net>
5470
5471 * Bugfix CORE-2648
5472 NBACKUP's delta file ignored Forced Writes database setting
5473 Contributor(s):
5474 Vlad Khorsun <hvlad at users.sf.net>
5475
5476 * Bugfix CORE-2165
5477 Unnecessary 1 index read may occur when using strict inequality condition
5478 Contributor(s):
5479 Vlad Khorsun <hvlad at users.sf.net>
5480
5481 * Bugfix CORE-362
5482 Impossible to enter certain characters in ISQL
5483 Contributor(s):
5484 Frank Schlottmann-Goedde <frank at schlottmann-goedde.de>
5485
5486 * Improvement CORE-4290
5487 Extensible property support which can add properties (name-value pairs)
5488 to users (stored in the security database and managed in some way)
5489 Contributor(s):
5490 Alex Peshkov <peshkoff at mail.ru>
5491
5492 * Improvement CORE-4285
5493 Choose the best matching index for navigation
5494 Contributor(s):
5495 Dmitry Yemanov <dimitr at firebirdsql.org>
5496
5497 * Improvement CORE-4273
5498 Per-database control on access to database from remote stations
5499 Contributor(s):
5500 Alex Peshkov <peshkoff at mail.ru>
5501
5502 * Improvement CORE-4222
5503 Provide ability to know which authentication method was used for user connection
5504 Contributor(s):
5505 Dmitry Yemanov <dimitr at firebirdsql.org>
5506
5507 * Improvement CORE-4218
5508 Add database owner to MON$DATABASE
5509 Contributor(s):
5510 Dmitry Yemanov <dimitr at firebirdsql.org>
5511
5512 * Improvement CORE-4215
5513 Execution of SET STATISTICS INDEX statement could block or slow execution of concurrent attachments
5514 Contributor(s):
5515 Vlad Khorsun <hvlad at users.sf.net>
5516
5517 * Improvement CORE-4206
5518 Add RESTART [WITH] clause for alter identity columns
5519 Contributor(s):
5520 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5521
5522 * Improvement CORE-4199
5523 Add optional START WITH clause to identity columns
5524 Contributor(s):
5525 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5526
5527 * Improvement CORE-4165
5528 Replace the hierarchical union execution with the plain one
5529 Contributor(s):
5530 Dmitry Yemanov <dimitr at firebirdsql.org>
5531
5532 * Improvement CORE-4154
5533 Firebird.conf should list names of (standard) authentication + usermanager plugins
5534 Contributor(s):
5535 Alex Peshkov <peshkoff at mail.ru>
5536
5537 * Improvement CORE-4148
5538 Increase ISQL command buffer size from 64 KB to 10 MB to match the new engine limits
5539 Contributor(s):
5540 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5541
5542 * Improvement CORE-4085
5543 Add systemd init scripts
5544 Contributor(s):
5545 Alex Peshkov <peshkoff at mail.ru>
5546
5547 * Improvement CORE-3931
5548 SQL commands to query/alter users description
5549 Contributor(s):
5550 Alex Peshkov <peshkoff at mail.ru>
5551
5552 * Improvement CORE-3365
5553 Extend syntax for ALTER USER CURRENT_USER
5554 Contributor(s):
5555 Alex Peshkov <peshkoff at mail.ru>
5556
5557 * Improvement CORE-1846
5558 Allow index walk (ORDER plan) when there's a composite index {A, B}
5559 and the query looks like WHERE A = ? ORDER BY B
5560 Contributor(s):
5561 Dmitry Yemanov <dimitr at firebirdsql.org>
5562
5563 * New feature CORE-4263
5564 Database linger
5565 Contributor(s):
5566 Alex Peshkov <peshkoff at mail.ru>
5567
5568 * New feature CORE-2063
5569 CREATE OR ALTER USER command
5570 Contributor(s):
5571 Alex Peshkov <peshkoff at mail.ru>
5572
5573 * New feature CORE-2004
5574 ALTER USER XXX INACTIVE command
5575 Contributor(s):
5576 Alex Peshkov <peshkoff at mail.ru>
5577
5578
5579 **************
5580 * v3.0 Alpha 1
5581 **************
5582
5583 * Bugfix CORE-4144
5584 Error "context already in use (BLR error)" when preparing a query with UNION
5585 Contributor(s):
5586 Vlad Khorsun <hvlad at users.sf.net>
5587
5588 * Bugfix CORE-4137
5589 Wrong metadata output script generate by ISQL / CHARACTER SETISO8859_1 syntax error
5590 Contributor(s):
5591 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5592
5593 * Bugfix CORE-4136
5594 Sharp-S character treated incorrectly in UNICODE_CI_AI collation
5595 Contributor(s):
5596 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5597
5598 * Bugfix CORE-4135
5599 Sweep blocks establishment of concurrent attachments in SuperServer
5600 Contributor(s):
5601 Vlad Khorsun <hvlad at users.sf.net>
5602
5603 * Bugfix CORE-4134
5604 Race condition when auto-sweep is started
5605 Contributor(s):
5606 Vlad Khorsun <hvlad at users.sf.net>
5607
5608 * Bugfix CORE-4074
5609 Computed by columns and POSITION function
5610 Contributor(s):
5611 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5612
5613 * Bugfix CORE-4027
5614 Creating table with computed fields containing "SELECT FIRST" produces corrupted result
5615 Contributor(s):
5616 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5617
5618 * Bugfix CORE-4018
5619 Using system domain in procedures arguments/returns cause the SP to be unchangeable
5620 Contributor(s):
5621 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5622
5623 * Bugfix CORE-4005
5624 Wrong error message with recursive CTE
5625 Contributor(s):
5626 Vlad Khorsun <hvlad at users.sf.net>
5627
5628 * Bugfix CORE-3973
5629 Original table name and column name and owner missing from SQLDA for aliased column in grouped query
5630 Contributor(s):
5631 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5632
5633 * Bugfix CORE-3947
5634 Wrong results when the column with collation using option (NUMERIC-SORT=1) is in WHERE clause
5635 Contributor(s):
5636 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5637
5638 * Bugfix CORE-3941
5639 Memory alignment problem with unique expression index
5640 Contributor(s):
5641 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5642
5643 * Bugfix CORE-3929
5644 Invalid error "attempted update of read-only column" when selecting MINVALUE from list with more than 255 elements
5645 Contributor(s):
5646 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5647
5648 * Bugfix CORE-3894
5649 Wrong numbers in error message for decreasing char/varchar columns
5650 Contributor(s):
5651 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5652
5653 * Bugfix CORE-3874
5654 Computed column appears in non-existant rows of left join
5655 Contributor(s):
5656 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5657
5658 * Bugfix CORE-3820
5659 RDB$TYPES contains duplicate character sets
5660 Contributor(s):
5661 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5662
5663 * Bugfix CORE-3754
5664 SIMILAR TO works wrongly
5665 Contributor(s):
5666 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5667
5668 * Bugfix CORE-3737
5669 EXECUTE BLOCK parameters definitions are not respected and may cause wrong behavior related to character sets
5670 Contributor(s):
5671 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5672
5673 * Bugfix CORE-3735
5674 Unprivileged user can delete from RDB$DATABASE, RDB$COLLATIONS, RDB$CHARACTER_SETS
5675 Contributor(s):
5676 Dmitry Yemanov <dimitr at firebirdsql.org>
5677
5678 * Bugfix CORE-3718
5679 Client library hangs after unsuccessful connection to remote auxiliary (events) port
5680 Contributor(s):
5681 Alex Peshkov <peshkoff at mail.ru>
5682
5683 * Bugfix CORE-3694
5684 Internal consistency check in query with grouping by subquery+stored procedure+aggregate
5685 Contributor(s):
5686 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5687
5688 * Bugfix CORE-3672
5689 Computed index by SUBSTRING function for long columns
5690 Contributor(s):
5691 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5692
5693 * Bugfix CORE-3638
5694 Introduce FR_CA_CI_AI collation and change FR_FR and FR_FR_CI_AI to be identical to FR_CA and FR_CA_CI_AI respectively
5695 Contributor(s):
5696 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5697
5698 * Bugfix CORE-3575
5699 Support of backup volumes with size more than 4GB
5700 Contributor(s):
5701 Alex Peshkov <peshkoff at mail.ru>
5702
5703 * Bugfix CORE-3545
5704 Inconsistent domain's constraint validation in PSQL
5705 Contributor(s):
5706 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5707
5708 * Bugfix CORE-3476
5709 LIST function wrongly concatenates binary blobs
5710 Contributor(s):
5711 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5712
5713 * Bugfix CORE-3475
5714 Parameters inside the CAST function are described as not nullable
5715 Contributor(s):
5716 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5717
5718 * Bugfix CORE-3431
5719 ISQL pads UTF-8 data incorrectly
5720 Contributor(s):
5721 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5722
5723 * Bugfix CORE-3416
5724 Inserting Kase into a CHARACTER SET ASCII column succeeds
5725 Contributor(s):
5726 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5727
5728 * Bugfix CORE-3401
5729 Collation errors with [type of] <domain>, type of column
5730 Contributor(s):
5731 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5732
5733 * Bugfix CORE-3338
5734 Regression: code changes disabled support for expression indexes with COALESCE, CASE and DECODE
5735 Contributor(s):
5736 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5737
5738 * Bugfix CORE-3317
5739 Success of deleting rows depending on order of row insertion
5740 Contributor(s):
5741 Vlad Khorsun <hvlad at users.sf.net>
5742
5743 * Bugfix CORE-3310
5744 RDB$GET_CONTEXT and BETWEEN in views
5745 Contributor(s):
5746 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5747
5748 * Bugfix CORE-3269
5749 When server gets unavailbale, client does not perform detach correctly
5750 Contributor(s):
5751 Alex Peshkov <peshkoff at mail.ru>
5752
5753 * Bugfix CORE-3260
5754 Interlock.h not portable
5755 Contributor(s):
5756 Alex Peshkov <peshkoff at mail.ru>
5757
5758 * Bugfix CORE-3250
5759 Cannot start firebird server under any username other than "root", "firebird" , "interbas"or "interbase"
5760 Contributor(s):
5761 Alex Peshkov <peshkoff at mail.ru>
5762
5763 * Bugfix CORE-3239
5764 UTF8 UNICODE_CI collate can not be used in compound index
5765 Contributor(s):
5766 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5767
5768 * Bugfix CORE-3204
5769 Constraint violation error of CAST is not raised inside views
5770 Contributor(s):
5771 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5772
5773 * Bugfix CORE-3201
5774 ATAN2 returns incorrect value for (0, 0)
5775 Contributor(s):
5776 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5777
5778 * Bugfix CORE-3174
5779 Expression index with TRIM may lead to incorrect indexed lookup
5780 Contributor(s):
5781 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5782
5783 * Bugfix CORE-3114
5784 Attempt to drop non-existing generator produces bad error
5785 Contributor(s):
5786 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5787
5788 * Bugfix CORE-3056
5789 Problems may happen when issuing DDL commands in the same transaction after CREATE COLLATION was issued
5790 Contributor(s):
5791 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5792
5793 * Bugfix CORE-3055
5794 Variable/argument name could be absent or be wrong in error messages when more than 256 variables are used
5795 Contributor(s):
5796 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5797
5798 * Bugfix CORE-3052
5799 Wrong resultset for comparisons involving multiple index segments
5800 Contributor(s):
5801 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5802
5803 * Bugfix CORE-3047
5804 Wrong logic is used to resolve EXECUTE BLOCK parameters collations
5805 Contributor(s):
5806 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5807
5808 * Bugfix CORE-2988
5809 Concurrent transaction number not reported if lock timeout occurs
5810 Contributor(s):
5811 Nickolay Samofatov <skidder at users.sf.net>
5812
5813 * Bugfix CORE-2957
5814 COUNT(*) from a big table returns negative result
5815 Contributor(s):
5816 Dmitry Yemanov <dimitr at firebirdsql.org>
5817
5818 * Bugfix CORE-2952
5819 Case-sensitive character class names in SIMILAR TO
5820 Contributor(s):
5821 Dimitry Sibiryakov <sd at ibphoenix.com>
5822
5823 * Bugfix CORE-2922
5824 Character set used in constants is not registered as a dependency
5825 Contributor(s):
5826 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5827
5828 * Bugfix CORE-2913
5829 COLLATE expressions are applied incorrectly
5830 Contributor(s):
5831 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5832
5833 * Bugfix CORE-2798
5834 Incomplete plan output (lack of view names) when selecting from views containing procedures inside
5835 Contributor(s):
5836 Dmitry Yemanov <dimitr at firebirdsql.org>
5837
5838 * Bugfix CORE-2796
5839 DB_KEY is always zero for external tables
5840 Contributor(s):
5841 Dmitry Yemanov <dimitr at firebirdsql.org>
5842
5843 * Bugfix CORE-2788
5844 ISQL extracts the array dimensions after the character set name
5845 Contributor(s):
5846 Claudio Valderrama C. <cvalde at usa.net>
5847
5848 * Bugfix CORE-2784
5849 Guardian creates more and more threads each time FBServer dies
5850 Contributor(s):
5851 Claudio Valderrama C. <cvalde at usa.net>
5852
5853 * Bugfix CORE-2740
5854 GBAK restores invalid views without any warning to the user
5855 Contributor(s):
5856 Claudio Valderrama C. <cvalde at usa.net>
5857
5858 * Bugfix CORE-2699
5859 Common table expression context could be used with parameters
5860 Contributor(s):
5861 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5862
5863 * Bugfix CORE-2696
5864 ALTER TABLE command can add a field which has NOT NULL definition
5865 Contributor(s):
5866 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5867
5868 * Bugfix CORE-2678
5869 Full outer join cannot use available indices (very slow execution)
5870 Contributor(s):
5871 Dmitry Yemanov <dimitr at firebirdsql.org>
5872
5873 * Bugfix CORE-2606
5874 Multibyte CHAR value requested as VARCHAR is returned with padded spaces
5875 Contributor(s):
5876 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5877
5878 * Bugfix CORE-2547
5879 Utilities need to honor their minimum number of characters to recognize an option
5880 Contributor(s):
5881 Claudio Valderrama C. <cvalde at usa.net>
5882
5883 * Bugfix CORE-2545
5884 Lack of several validations in GBAK
5885 Contributor(s):
5886 Claudio Valderrama C. <cvalde at usa.net>
5887
5888 * Bugfix CORE-2543
5889 NBACKUP may hide the real cause of failure
5890 Contributor(s):
5891 Claudio Valderrama C. <cvalde at usa.net>
5892
5893 * Bugfix CORE-2508
5894 Tricky index names can defeat the parsing logic when generating a human readable plan
5895 Contributor(s):
5896 Dmitry Yemanov <dimitr at firebirdsql.org>
5897
5898 * Bugfix CORE-2484
5899 Success message when connecting to tiny trash database file
5900 Contributor(s):
5901 Claudio Valderrama C. <cvalde at usa.net>
5902
5903 * Bugfix CORE-2431
5904 String values in error messages are not converted to connection charset
5905 Contributor(s):
5906 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5907
5908 * Bugfix CORE-2238
5909 UTF8 and large varchar fields, IS DISTINCT FROM causes error "Implementation limit exceeded"
5910 Contributor(s):
5911 Dmitry Yemanov <dimitr at firebirdsql.org>
5912
5913 * Bugfix CORE-2204
5914 Constraints on SP output parameters are checked even when the SP returns zero rows
5915 Contributor(s):
5916 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5917
5918 * Bugfix CORE-2155
5919 Join of SP with view or table may fail with error "No current record for fetch operation"
5920 Contributor(s):
5921 Dmitry Yemanov <dimitr at firebirdsql.org>
5922
5923 * Bugfix CORE-1748
5924 Unrestorable backup
5925 Contributor(s):
5926 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5927
5928 * Bugfix CORE-1712
5929 Buffer overflow in conversion
5930 Contributor(s):
5931 Claudio Valderrama C. <cvalde at usa.net>
5932
5933 * Bugfix CORE-1620
5934 Incorrect error message (column number) if the empty SQL string is prepared
5935 Contributor(s):
5936 Dmitry Yemanov <dimitr at firebirdsql.org>
5937
5938 * Bugfix CORE-1605
5939 Bugcheck 232 (invalid operation) for an aggregated query
5940 Contributor(s):
5941 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5942
5943 * Bugfix CORE-1595
5944 Tray icon of Firebird Guardian disappears after Windows Explorer crash
5945 Contributor(s):
5946 Claudio Valderrama C. <cvalde at usa.net>
5947
5948 * Bugfix CORE-1550
5949 Unnecessary index scan happens when the same index is mapped to both WHERE and ORDER BY clauses
5950 Contributor(s):
5951 Dmitry Yemanov <dimitr at firebirdsql.org>
5952
5953 * Bugfix CORE-1518
5954 Adding a non-null restricted column to a populated table renders the table inconsistent
5955 Contributor(s):
5956 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5957
5958 * Bugfix CORE-1355
5959 Zero is displayed instead of NULL
5960 Contributor(s):
5961 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5962
5963 * Bugfix CORE-1188
5964 STARTING WITH :param (empty string) doesn't work if using index with many fields
5965 Contributor(s):
5966 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5967
5968 * Bugfix CORE-634
5969 Bad treatment of FIRST/SKIP in sub-selects
5970 Contributor(s):
5971 Vlad Khorsun <hvlad at users.sf.net>
5972
5973 * Bugfix CORE-304
5974 Metadata security hole - any user can alter/drop generators and exceptions
5975 Contributor(s):
5976 Dmitry Yemanov <dimitr at firebirdsql.org>
5977
5978 * Bugfix CORE-92
5979 Infinite insertion cycle
5980 Contributor(s):
5981 Vlad Khorsun <hvlad at users.sf.net>
5982
5983 * Improvement CORE-3972
5984 Allow selection of SQL_INT64, SQL_DATE and SQL_TIME in dialect 1
5985 Contributor(s):
5986 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5987
5988 * Improvement CORE-3919
5989 Improve SIMILAR TO performance
5990 Contributor(s):
5991 Adriano dos Santos Fernandes <adrianosf at gmail.com>
5992
5993 * Improvement CORE-3879
5994 Make FB_LOCK_PRINT a bit more handy
5995 Contributor(s):
5996 Vlad Khorsun <hvlad at users.sf.net>
5997
5998 * Improvement CORE-3788
5999 Make all utilities follow same rules when expanding database name
6000 Contributor(s):
6001 Alex Peshkov <peshkoff at mail.ru>
6002
6003 * Improvement CORE-3779
6004 Report OS user name in MON$ATTACHMENTS
6005 See also:
6006 /doc/README.monitoring_tables
6007 Contributor(s):
6008 Dmitry Yemanov <dimitr at firebirdsql.org>
6009
6010 * Improvement CORE-3704
6011 Add new context variables to the SYSTEM namespace
6012 Contributor(s):
6013 Dmitry Yemanov <dimitr at firebirdsql.org>
6014
6015 * Improvement CORE-3639
6016 Allow the use of multiple WHEN MATCHED / NOT MATCHED clauses in MERGE, as per the SQL 2008 specification
6017 See also:
6018 /doc/README.merge.txt
6019 Contributor(s):
6020 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6021
6022 * Improvement CORE-3594
6023 Include expected and actual string lenght into error message for sqlcode -802
6024 Contributor(s):
6025 Alex Peshkov <peshkoff at mail.ru>
6026
6027 * Improvement CORE-3588
6028 More details in the error message "wrong page type"
6029 Contributor(s):
6030 Alex Peshkov <peshkoff at mail.ru>
6031
6032 * Improvement CORE-3546
6033 Aliases for the RETURNING clause
6034 See also:
6035 /doc/sql.extensions/README.returning
6036 Contributor(s):
6037 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6038
6039 * Improvement CORE-3343
6040 Support for the RETURNING clause in positioned (WHERE CURRENT OF) UPDATE and DELETE statements
6041 See also:
6042 /doc/sql.extensions/README.returning
6043 Contributor(s):
6044 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6045
6046 * Improvement CORE-3251
6047 Use SSL/TLS support for both encryption and user authentication
6048 Contributor(s):
6049 Alex Peshkov <peshkoff at mail.ru>
6050
6051 * Improvement CORE-3085
6052 Add clause ALTER DOMAIN <name> {DROP | SET} NOT NULL
6053 See also:
6054 /doc/sql.extensions/README.ddl.txt
6055 Contributor(s):
6056 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6057
6058 * Improvement CORE-3076
6059 Better performance for (table.field = :param or :param = -1) in the WHERE clause
6060 Contributor(s):
6061 Dmitry Yemanov <dimitr at firebirdsql.org>
6062
6063 * Improvement CORE-3057
6064 Allow the usage of blobs in COMPUTED BY expressions
6065 Contributor(s):
6066 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6067
6068 * Improvement CORE-3020
6069 Add RETURNING ... INTO ... clause to the MERGE statement
6070 See also:
6071 /doc/sql.extensions/README.returning, /doc/README.merge.txt
6072 Contributor(s):
6073 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6074
6075 * Improvement CORE-2868
6076 Increase trigger and stored procedure body size above 32KB
6077 Note(s):
6078 Available via the new API only
6079 Contributor(s):
6080 Dmitry Yemanov <dimitr at firebirdsql.org>
6081
6082 * Improvement CORE-2812
6083 Prohibit any improper mixture of explicit and implicit joins
6084 Contributor(s):
6085 Dmitry Yemanov <dimitr at firebirdsql.org>
6086
6087 * Improvement CORE-2787
6088 Make RDB$SYSTEM_FLAG not null
6089 Contributor(s):
6090 Claudio Valderrama C. <cvalde at usa.net>
6091
6092 * Improvement CORE-2780
6093 Include client library version and protocol version into MON$ATTACHMENTS
6094 See also:
6095 /doc/README.monitoring_tables
6096 Contributor(s):
6097 Dmitry Yemanov <dimitr at firebirdsql.org>
6098
6099 * Improvement CORE-2724
6100 Validate or transform string of DML queries so that engine internals don't receive malformed strings
6101 Contributor(s):
6102 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6103
6104 * Improvement CORE-2712
6105 Do not print "invalid request BLR" for par.cpp errors with valid BLR
6106 Contributor(s):
6107 Claudio Valderrama C. <cvalde at usa.net>
6108
6109 * Improvement CORE-2697
6110 Support the "? in (SELECT some_col FROM some_table)" subqueries
6111 Contributor(s):
6112 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6113
6114 * Improvement CORE-2575
6115 Make ISQL "input" command open relative filenames based on the directory
6116 of last opened (and not closed) input file
6117 Contributor(s):
6118 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6119
6120 * Improvement CORE-2565
6121 Many hardcoded messages in Trace Manager
6122 Contributor(s):
6123 Claudio Valderrama C. <cvalde at usa.net>
6124
6125 * Improvement CORE-2554
6126 Grant execute permissions for UDFs
6127 Contributor(s):
6128 Dmitry Yemanov <dimitr at firebirdsql.org>
6129
6130 * Improvement CORE-2553
6131 Grants access on generators (gen_id, next value for)
6132 Contributor(s):
6133 Dmitry Yemanov <dimitr at firebirdsql.org>
6134
6135 * Improvement CORE-2542
6136 QLI and NBACKUP accept arbitrary input after the first letter of an option
6137 Contributor(s):
6138 Claudio Valderrama C. <cvalde at usa.net>
6139
6140 * Improvement CORE-2541
6141 Too many hardcoded messages in NBACKUP
6142 Contributor(s):
6143 Claudio Valderrama C. <cvalde at usa.net>
6144
6145 * Improvement CORE-2540
6146 Utilities need a more coherent way to show help and version
6147 Contributor(s):
6148 Claudio Valderrama C. <cvalde at usa.net>
6149
6150 * Improvement CORE-2187
6151 Return the client host name in MON$ATTACHMENTS
6152 See also:
6153 /doc/README.monitoring_tables
6154 Contributor(s):
6155 Dmitry Yemanov <dimitr at firebirdsql.org>
6156
6157 * Improvement CORE-2006
6158 SUBSTRING with regular expression (SIMILAR TO) capability
6159 See also:
6160 /doc/README.substring_similar.txt
6161 Contributor(s):
6162 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6163
6164 * Improvement CORE-2005
6165 Support SQL 2008 syntax for MERGE statement with DELETE extension
6166 See also:
6167 /doc/README.merge.txt
6168 Contributor(s):
6169 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6170
6171 * Improvement CORE-1906
6172 Allow interactive arguments (seconds and intervals) of fb_lock_print to be 32-bit integers
6173 Contributor(s):
6174 Dmitry Yemanov <dimitr at firebirdsql.org>
6175
6176 * Improvement CORE-1898
6177 Increased the password length from 8 characters, removed support
6178 for LegacyHash and Authentication parameters in firebird.conf.
6179 Support of pre-2.0 hashes is dropped, authentication is overridden
6180 by AuthServer parameter.
6181 Contributor(s):
6182 Alex Peshkov <peshkoff at mail.ru>
6183
6184 * Improvement CORE-1609
6185 Remove limit of PSQL output parameter size
6186 Note(s):
6187 Available via the new API only
6188 Contributor(s):
6189 Dmitry Yemanov <dimitr at firebirdsql.org>
6190
6191 * Improvement CORE-1180
6192 DDL syntax to change (not) nullable state of columns
6193 See also:
6194 /doc/sql.extensions/README.ddl.txt
6195 Contributor(s):
6196 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6197
6198 * Improvement CORE-1117
6199 Remove or extend limit of command text length (64K)
6200 Note(s):
6201 Available via the new API only
6202 Contributor(s):
6203 Dmitry Yemanov <dimitr at firebirdsql.org>
6204
6205 * Improvement CORE-832
6206 Add support for parameterized exceptions
6207 See also:
6208 /doc/sql.extensions/README.exception_handling
6209 Contributor(s):
6210 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6211
6212 * Improvement CORE-800
6213 Easy metadata extract improvements
6214 Contributor(s):
6215 Claudio Valderrama C. <cvalde at usa.net>
6216
6217 * Improvement CORE-675
6218 Add entries to RDB$Types
6219 Contributor(s):
6220 Dmitry Yemanov <dimitr at firebirdsql.org>
6221
6222 * Improvement CORE-672
6223 "Over the wire" connection encryption
6224 Contributor(s):
6225 Alex Peshkov <peshkoff at mail.ru>
6226
6227 * New feature CORE-4089
6228 Runtime architecture configuration
6229 Contributor(s):
6230 Alex Peshkov <peshkoff at mail.ru>
6231 Vlad Khorsun <hvlad at users.sf.net>
6232
6233 * New feature CORE-3626
6234 Subfunctions in PSQL and EXECUTE BLOCK
6235 See also:
6236 /doc/sql.extensions/README.subroutines.txt
6237 Contributor(s):
6238 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6239
6240 * New feature CORE-3621
6241 Window functions: NTH_VALUE
6242 See also:
6243 /doc/sql.extensions/README.window_functions.txt
6244 Contributor(s):
6245 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6246
6247 * New feature CORE-3620
6248 Window functions: LAST_VALUE
6249 See also:
6250 /doc/sql.extensions/README.window_functions.txt
6251 Contributor(s):
6252 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6253
6254 * New feature CORE-3619
6255 Window functions: FIRST_VALUE
6256 See also:
6257 /doc/sql.extensions/README.window_functions.txt
6258 Contributor(s):
6259 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6260
6261 * New feature CORE-3364
6262 Blob filter to translate internal debug info into text representation
6263 Contributor(s):
6264 Vlad Khorsun <hvlad at users.sf.net>
6265
6266 * New feature CORE-3332
6267 Provide more detailed information about the query execution plan
6268 Contributor(s):
6269 Dmitry Yemanov <dimitr at firebirdsql.org>
6270
6271 * New feature CORE-3291
6272 New pseudocolumn (RDB$RECORD_VERSION) to get number of the transaction
6273 that created a record version
6274 Contributor(s):
6275 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6276
6277 * New feature CORE-3018
6278 RECREATE and CREATE OR ALTER SEQUENCE/GENERATOR statements
6279 See also:
6280 /doc/sql.extensions/README.ddl.txt
6281 Contributor(s):
6282 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6283 Dmitry Yemanov <dimitr at firebirdsql.org>
6284
6285 * New feature CORE-2884
6286 New object rights for enhanced security
6287 Contributor(s):
6288 Dmitry Yemanov <dimitr at firebirdsql.org>
6289
6290 * New feature CORE-2869
6291 Window functions: LAG and LEAD
6292 See also:
6293 /doc/sql.extensions/README.window_functions.txt
6294 Contributor(s):
6295 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6296
6297 * New feature CORE-2830
6298 Window functions: DENSE_RANK, RANK and ROW_NUMBER
6299 See also:
6300 /doc/sql.extensions/README.window_functions.txt
6301 Contributor(s):
6302 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6303
6304 * New feature CORE-2823
6305 Window functions: ORDER BY clause
6306 See also:
6307 /doc/sql.extensions/README.window_functions.txt
6308 Contributor(s):
6309 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6310
6311 * New feature CORE-2777
6312 Make possible to alter the default database character set without manual update of system table
6313 Contributor(s):
6314 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6315
6316 * New feature CORE-2744
6317 Inverse hyperbolic trigonometric functions as native functions
6318 See also:
6319 /doc/sql.extensions/README.builtin_functions.txt
6320 Contributor(s):
6321 Claudio Valderrama C. <cvalde at usa.net>
6322
6323 * New feature CORE-2700
6324 C++ API supporting functions, triggers and stored procedures
6325 Contributor(s):
6326 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6327
6328 * New feature CORE-2639
6329 Pseudo-table with list of users, available for management to current user
6330 Contributor(s):
6331 Alex Peshkov <peshkoff at mail.ru>
6332
6333 * New feature CORE-2470
6334 Support for alternate format of strings literals
6335 See also:
6336 /doc/sql.extensions/README.alternate_string_quoting.txt
6337 Contributor(s):
6338 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6339
6340 * New feature CORE-2312
6341 PSQL packages
6342 See also:
6343 /doc/sql.extensions/README.packages.txt
6344 Contributor(s):
6345 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6346
6347 * New feature CORE-2310
6348 DDL triggers
6349 See also:
6350 /doc/sql.extensions/README.ddl_triggers.txt
6351 Contributor(s):
6352 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6353
6354 * New feature CORE-2133
6355 Window functions: PARTITION BY clause
6356 See also:
6357 /doc/sql.extensions/README.window_functions.txt
6358 Contributor(s):
6359 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6360
6361 * New feature CORE-2090
6362 Window functions: Support OVER () clause with current aggregate functions
6363 See also:
6364 /doc/sql.extensions/README.window_functions.txt
6365 Contributor(s):
6366 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6367
6368 * New feature CORE-2047
6369 User-defined PSQL functions
6370 Contributor(s):
6371 Dmitry Yemanov <dimitr at firebirdsql.org>
6372
6373 * New feature CORE-1952
6374 Deprecate implementation IDs in ODS, thus simplifying new ports
6375 Contributor(s):
6376 Alex Peshkov <peshkoff at mail.ru>
6377
6378 * New feature CORE-1385
6379 Identity columns
6380 See also:
6381 /doc/sql.extensions/README.identity_columns.txt
6382 Contributor(s):
6383 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6384
6385 * New feature CORE-1288
6386 Subprocedures in PSQL and EXECUTE BLOCK
6387 See also:
6388 /doc/sql.extensions/README.subroutines.txt
6389 Contributor(s):
6390 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6391
6392 * New feature CORE-1209
6393 CONTINUE statement
6394 See also:
6395 /doc/sql.extensions/README.ddl.txt
6396 Contributor(s):
6397 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6398
6399 * New feature CORE-816
6400 Stored procedures, triggers and functions in Java
6401 See also:
6402 /doc/README.external_routines.txt
6403 Contributor(s):
6404 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6405
6406 * New feature CORE-775
6407 True SMP support for SuperServer
6408 Contributor(s):
6409 Vlad Khorsun <hvlad at users.sf.net>
6410
6411 * New feature CORE-726
6412 Boolean data type
6413 See also:
6414 /doc/README.data_types
6415 Contributor(s):
6416 Adriano dos Santos Fernandes <adrianosf at gmail.com>
6417
6418 * New feature CORE-685
6419 Location of user lists (DB permission)
6420 Contributor(s):
6421 Alex Peshkov <peshkoff at mail.ru>
6422
6423 * New feature CORE-657
6424 Database encryption
6425 Contributor(s):
6426 Alex Peshkov <peshkoff at mail.ru>
6427
6428 * New feature CORE-462
6429 New option in addition to -V switch to specify a custom verbose interval
6430 Contributor(s):
6431 Claudio Valderrama C. <cvalde at usa.net>