Firebird Weekly News #5

This is the list of firebird related news from week 21-28 June

Firebird and FirebirdClient used in IBM’s AppScan Standard Edition. Read more.
Pave Cisar is happy to announce the public release of PowerConsole v0.7.5 and
Firebird Pack for PowerConsole v0.9.1.
Embarcadero officialy announces participation on FDD.
Firebird positive feedback from customers.
Firebird V2.1.3 Release Candidate 1 is available for testing.
Firebird Centos prerelease repository announced on Philippe Makowski’s blog (firebird 2.1.3 rc1).
Do you want a faster communication protocol for Firebird? Please vote for this feature.
Local protocol and multi-core processors and interesting situations with gbak.
Howto add job-event based plugin to Pentaho Data Integration (PDI), aka Kettle.
New php 5.2.10 firebird repository for CentOS announced.
PHP 5.3.0 RC4 repository for centos, fedora announced with firebird support.
New features in Entity Framework v4 and Firebird.

Firebird Interesting Source Patches and Commits:
MONDAY JUNE 22 2009
robocop committed 4d6d428 , d67d46e
Isolate even more the scrollable cursors-related code.
TUESDAY JUNE 23 2009
robocop committed 0bc6559
fixed CORE-1411 and CORE-1412.
WEDNESDAY JUNE 24 2009
hvlad committed 90808fa
Fixed bug CORE-2268 : GFIX causes BUGCHECK errors with non valid transaction numbers.
hvlad committed 8423160
Fixed bug CORE-2523 : gfix reports "unknown ISC error 0" in some cases.
hvlad committed b3c3c6d , 03d1f16
New feature 2524 : Command line utility to work with Trace Service.

THURSDAY JUNE 25 2009
asfernandes committed 1f8f19f
Add fbtracemgr to POSIX builds.
robocop committed be7d835
CORE-756 and CORE-2528.
robocop committed 3b45dd2
Convert goto into a for() loop.
robocop committed e0f3749
Some paranoid checks.
robocop committed 545d857
Apply the same trick as in evl.cpp for scrollable cursors' conditional code.
robocop committed ef02be0
I'm putting this strange assertion because I bet this code will never be called.
hvlad committed df5facb
Replace hard-coded array with isc_info_svc_timeout by correct endianess code.

FRIDAY JUNE 26 2009
robocop committed 8580b59
Moved DEFAULT_CLASS to constants.h;
SATURDAY JUNE 27 2009
robocop committed cdd2669
Avoid variableshadowing.
dimitr committed ed111c8
Fixed CORE-2462: 2.5 beta 1 has huge, fast-growing log files.So the bird was saved


SUNDAY JUNE 28 2009
hvlad committed 7e4a7cc
Fixed bug CORE-2532 : Incorrect size of volumes in multi volume database





.:(firebird):..:(databases):..:(sql):.

Firebird Weekly News #4

This is the list of firebird related news from week 14-21 June

Slackware 12.2 and firebird user introduction on LQ.
Firebird ODBC Acrobat and JavaScript question of the day.
Firebird 2.1.2 is included in OpenSUSE 10.3.
Here is an interview with Vlad Khorsun, done for the Brazilian ActiveDelphi Magazine.
New poll at FirebirdNews.org .We have a new poll running on the site. Vote now (look at the sidebar).
Dmitry Kuzmenko wrote on his own blog What is sort? Part 1 and 2 articles
Prism9’s HelixGL Accounting System – powered by Firebird.
mojoPortal 2.3.0.8 Released
Tunnelling a Firebird Backup with SSH.
Hugues Van Landeghem reports that DevGems DataModeler supports Firebird.

Open Source Delphi based ERP with Firebird.

Firebird Interesting Source Patches and Commits:

WEDNESDAY JUNE 17 2009
robocop committed b764edb
Use our common code to deal with NaN and Infinity.
committed 4d14694
Fix CORE-2505: beware of built-in functions returning NaN and Inf. Some functions were added, but they are called from the debugger only because they aren't exposed through DSQL.
asfernandes committed 0c145b0
Make the VC++ Express build not show a popup everytime setenv.bat is called - one time is enough

THURSDAY JUNE 18 2009
robocop committed 0eef56c
CORE-2509. Took the opportunity to fix several data types.
asfernandes committed c3cab2d
Fix build
FRIDAY JUNE 19 2009
asfernandes committed 5a01b8b
Put apples and oranges in different baskets
aafemt committed 60280f3
Fix parsing of constructions like /*/ and /**/*
dimitr committed 4ad2806
Fixed some issues with the optimizer, namely: (1) incorrect cost calculation for indexed retrievals in joins and (2) too pessimistic heuristics for indices with zero selectivity.
paulbeach committed e6fafc0
O_DIRECT and MacOSX problem (lack of)
hvlad committed 79ae46e
Initialize variables before it could be used.
paulbeach committed 1629d25
O_DIRECT and MacOSX problem (lack of) - better ifdefs (I hope)

asfernandes committed 04d9688
Revert this change. HEAD was fine.

asfernandes committed 76a3d7a
Fixed CORE-2516 - Wrong processing SP parameters with arrays

SUNDAY JUNE 21 2009
robocop committed 664ebab
Give idx_id and associated values a consistent data type and treatment.
robocop committed 83a57c6
Validations (do not crash).
hvlad committed 651528d
Fixed bug CORE-2519 : GSTAT output is incorrect for tables with more than 2 billion records

.:(firebird):..:(databases):..:(sql):.

Firebird Weekly News #3

This is the firebird related news from week 7-14 June
News around firebird world:
Firebird django backend call for testing help and progress.
Firebird 2.1.2 included in SourceMage Linux.
Flamerobin 0.9.2 packages into Fedora Linux and epel repository
Fedora 11 released with Firebird included in the main repository

New IBProvider version with enhanced Firebird 2.5 support
About FB support in Delphi Weaver
How to Query the Firebird Fisheye
Firebird: Deal with Unavailable Database
Firebird DTP Plugin for Eclipse released

Firebird Source Patches and Commits:
Fix CORE-2370: SQL Plan greater than 2048 characters is not printed at all in ISQL.
This is the client side fix. Server-side fixes will follow.
We should be careful to not upset FB2.1 and before.
New messages to fix CORE-2505: beware of built-in functions returning NaN and Inf. Code will follow in one day.
Better input type for SQZ_decompress plus a bit of style
Apply Alex/Bill/Jerry/me patch re. portability in redefinition of operator new
Sign extension problem, thanks Bill Oliver.
Update logic for ininf() in POSIX and use macro isnan instead of _isnan in Windows.
Update to-do a tad.
Locking something in AST turns out to be a bad idea. Let's use a "dirty read" approach and honestly return the "unknown" state for a not initialized backup manager (quite rare situation in practice).
The third incarnation of the monitoring internals. I'm not happy to commit such big changes into the point release, but this is the only solution for the AST signal safety issues in POSIX (see CORE-2483).
The change consists of a few parts

Remove unneeded reference to isc_ipc, since this file is not needed to build gpre_boot
In 3.0 binreloc should be turned on

Opportunist developer sees the place to constify the code.
:-)
Undo huge and not friendly fix for Sun compiler. Missed file
Patch by DS and VKh to speed up SQZ in some cases
Avoid sign extension problems in CVT
Much more easy way to please Sun compiler and not touch anything more
isc_ipc usage cleanup

Though we do not actively use signals since 2.5, let's better initialize paths before setting handlers

Rename function as agreed with Alex and Dmitry.

Don't be strictive with compiler warnings

Reworked class Semaphore:

1. Mach semaphores on Darwin.
2. No more local SysV semaphores.
3. Fixed bugs in conditional var based semaphore.
4. Moved big methods from .h to .cpp file.

Mac port - use correct full name for libib_util

Fix CORE-2501: bin_shl and bin_shr shouldn't accept negative shifts.

Put bad_port_context() in alphabetical order and created a little helper, send_error().

Use PORT_FILE for port file lock - thanks to Claudio

Make initialization distributed - each subsystem does what it needs when needs, removed gds.cpp:init()

Backport improvement CORE-1171: make floating point's exponential format the same across platforms.

After asking Alex, he confirms that calling fb_shutdown_callback in isql is for everything except WIN_NT (make code equivalent to previous versions).

Improvement CORE-1171: make floating point's exponential format the same across platforms.

Declare exported functions correctly - thanks to Paul Beach

Robocop added Paranoid checks in server.cpp

Slightly improve the retry loops in inet.cpp. Let's give up as soon as the call fails with any unexpected error.

CORE-2263: RemoteAuxPort for SuperClassic and regular Classic.
This change also fixes the possible races in SuperServer (possible after getting rid of the global mutex in the remote subsystem).

robocop is Minimizing casts (reinterpret_cast).

Fixed use of monitoring tables in on disconnect trigger, make pool for DatabaseSnapshot independent

.:(firebird):..:(databases):..:(sql):.

Firebird Weekly News #2

This is the firebird related news from week 1-7 June
News around firebird world:
phpBB “quite furry” 3.0.5 released
Under the Firebird umbrella - site updates
Lazarus and Firebird Embedded tutorial on Windows 32 bits
Embarcadero Tools and FB , news from Delphi Day Italy

Here is an interview with Jim Davis, SAS Institute SVP and Chief Marketing Officer.

Firebird Source Patches and Commits:
Improvement CORE-2498 - Make a single attachment usabe by more than one simultaneous threads in embedded

Fixed CORE-2499 - Implementation limit of DISTINCT items are not enforced, causing generation of incorrect BLR
Backported changes extending range of usable auto* tools

What is new and fixed in Version 2.1.x

Backport fix for bug CORE-2348 : More problems with transaction numbers overflowing 32-bit signed integer and corrupting database

Backport sub-task CORE-1647 : Close external table's file even if it used by some cached (inactive) requests.
It also fixed bug CORE-2475 : External table data not visible to other sessions in Classic.

Backport fix for bug CORE-2416 : AV preparing a query with aggregate over derived table

Minor cleanup by robocop

Dimitry Added timeouts to the network event listener code.
Fixed wrong usage of SO_REUSEADDR on Windows.

Alex Fixed Sun compiler warnings

Fixed CORE-2483: Database permanent pool may get corrupted when working with monitoring tables.

Better way to compile utilities/ntrace/os/*/platform.cpp for different platforms

Alex Fixed SYSV semaphores + const correctness + cleanup

Code simplification by robocop (claudio)

This is already a Windows file, no need to check for the WIN_NT macro.

Alex Fixed posix build