Firebird News

Wednesday, September 11, 2013

Django and Firebird support

I have started to read the django book and i could make it work with firebird without issues

Bellow are the instructions for Chapter 2 : Getting started


Install django using pip

pip install django

check django version from python console

>>> import django
>>> django.VERSION
(1, 5, x, 'final', 0)

pip install django-firebird

create a new project
django-admin.py startproject wordpress_clone

cd wordpress_clone

python manage.py runserver

load in browser http://localhost:8000



Step 02 completed , we now should do the step 03
http://djangobook.com/en/2.0/chapter03/

Chapter 3 is quite easy to read mainly hello world application here is the screenshot
after finising it (no modifications needed or related to firebird)



Chapter 04 is only related to templates so no modifications needed related to firebird.

So we reached chapter 05 the db and the The MTV Development Pattern (Beavis and Butthead pattern maybe )
http://djangobook.com/en/2.0/chapter05/

In a way i like the Dumb pattern ViewController
Only the View and the Controller and The Model is in database anyway (triggers/rules/procedures and business logic)

I have created an empty database in /var/lib/firebird/2.5/data/firedjango.fdb
with flamerobin

Ok so the the shell worked with my firebird db config in settings.py

$python manage.py shell
>>> from django.db import connection
>>> cursor = connection.cursor()

So the next thing was to create the models and generate the db

$ python manage.py validate
$ python manage.py sqlall books

and here is the output

After that sync worked
$ python manage.py syncdb
import md5
Creating table books_publisher
Creating table books_book
Creating table books_author
Installing index for books.Book model

$ python manage.py shell
(InteractiveConsole)
>>> from books.models import Publisher
>>> p1 = Publisher(name='Apress', address='2855 Telegraph Avenue',
... city='Berkeley', state_province='CA', country='U.S.A.',
... website='http://www.apress.com/')
>>> p1.save()
>>> p2 = Publisher(name="O'Reilly", address='10 Fawcett St.',
... city='Cambridge', state_province='MA', country='U.S.A.',
... website='http://www.oreilly.com/')
>>> p2.save()
>>> publisher_list = Publisher.objects.all()
>>> publisher_list
[, ]



after i have added the _unicode method

$ python manage.py shell

>>> from books.models import Publisher
>>> publisher_list = Publisher.objects.all()
>>> publisher_list
[<Publisher: Apress>, <Publisher: O'Reilly>]




Monday, December 20, 2010

News for week 12 - 19 December 2010 : Boolean landing , ibphoenix redesign

The best news seems to be boolean landing in the trunk.
Ibphoenix does have a new face for holidays.
Driver for Django 1.2.x is quite usable these days , this is why firebirdsql.ro works with the latest stable django .
We will have full reference (that means full docs) at the end of winter
Trace support landed in the .dot net driver
Php 5.3.4 is released with the firebird driver enabled (for pdo too) but only for the Visual C++ 9 builds
If you like the firebirdsql console (isql-fb) then there is the add command to interactively insert records/blobs
There is a fixed bug for trunk Fixed the crash about NEXT VALUE FOR reported in fb-devel
Port forward fix for bug CORE-3119 : 100% CPU USAGE with Unilimited Loop & Index corrupted

Wednesday, January 06, 2010

Firebird Weekly News #33

This is the list of firebird related news from week 2 January 2010 - 9 January 2010

Firebird Roadmap for 2009 and the reality : At the end of the year 2009 we see what Firebird development plans were and what is the reality.
Django meets Firebird: Nice blog post about firebird and django.
Philippe Makowski wrote a nice article comparing the performance of Firebird database on different linux file systems.



Firebird Interesting Source Patches and Commits in this week

asfernandes committed 9fa0ccd Thu, 7 Jan 2010 00:16:43 +0000:Feature CORE-832 - Parameterized exceptions
asfernandes committed a60936e Wed, 6 Jan 2010 22:38:20 +0000:Misc
hvlad committed d22e381 Wed, 6 Jan 2010 17:38:54 +0000:Cleanup : remove tree of dirty pages in favor of list based implementation.
dimitr committed a914924 Wed, 6 Jan 2010 15:40:39 +0000:Implement the lazy caching mode. Rows are stored in the buffer while fetching forward. The switch to the fully cached mode is performed upon the first positioned access.
dimitr committed d679186 Wed, 6 Jan 2010 14:16:21 +0000:Fixed the sorting.
robocop committed 248fadb Wed, 6 Jan 2010 12:53:23 +0000:I want to be able to pass const input params.
dimitr committed 2551d2a Wed, 6 Jan 2010 09:32:21 +0000:Added the missing public entrypoint.
asfernandes committed 2c0b883 Tue, 5 Jan 2010 17:32:39 +0000:1) Refactor the EXCEPTION statement 2) Cleanup DSQL nod_abort
robocop committed 95cd4ec Tue, 5 Jan 2010 04:10:25 +0000:Commenting unused sym_type values.
robocop committed a3811b5 Tue, 5 Jan 2010 04:08:46 +0000:Probably this completes Dmitry Sibiryakov's fix.
robocop committed f793ca8 Tue, 5 Jan 2010 04:07:55 +0000:Misc.
aafemt committed ecc92bc Mon, 4 Jan 2010 21:53:24 +0000:Fix BOF on truncation of reference action
hvlad committed 1d49a82 Mon, 4 Jan 2010 09:05:16 +0000:Make RELEASE build compilable
dimitr committed 7312db1 Mon, 4 Jan 2010 07:57:29 +0000:Added the missing license.
dimitr committed 087da87 Mon, 4 Jan 2010 07:54:26 +0000:Simplified the code a bit more (removed the redundant processing).
robocop committed c8313be Mon, 4 Jan 2010 05:09:38 +0000:Misc.
asfernandes committed 798cac7 Mon, 4 Jan 2010 00:43:44 +0000:Misc
asfernandes committed afba8cf Mon, 4 Jan 2010 00:43:41 +0000:Misc
asfernandes committed e03111d Sun, 3 Jan 2010 20:56:37 +0000:Support for new types and support for getters in ResultSet
asfernandes committed 59f89c7 Sun, 3 Jan 2010 18:23:22 +0000:Always use the dialect 3 for system SQL queries
asfernandes committed ec5734b Sun, 3 Jan 2010 15:21:13 +0000:The easy fix to the dialect problem
robocop committed dfb6d00 Sun, 3 Jan 2010 12:43:40 +0000:Show me the backup level when restoring with verbose option.
robocop committed fca10b3 Sun, 3 Jan 2010 10:46:37 +0000:Put more strings into the msg db.
dimitr committed 682f543 Sun, 3 Jan 2010 10:33:21 +0000:Small refactoring (code simplification).
robocop committed b1e392d Sun, 3 Jan 2010 03:45:01 +0000:Finally use the same logic to detect ODS capabilities in backup and restore.
asfernandes committed 33256c1 Sun, 3 Jan 2010 00:19:13 +0000:Some syntactic sugar
asfernandes committed bcd7ac0 Sat, 2 Jan 2010 23:29:32 +0000:Convert an uncached GDML query to equivalent SQL with PreparedStatement
asfernandes committed aac237b Sat, 2 Jan 2010 21:46:11 +0000:Tweaks to PreparedStatement::Builder and support for output parameters (without "demo" code yet)
asfernandes committed 96b1f3e Sat, 2 Jan 2010 21:34:39 +0000:Fix segmentation fault running tcs SVC_API_SWEEP_DB
robocop committed 179e773 Sat, 2 Jan 2010 09:38:40 +0000:Put more strings into the msg db.
robocop committed ed20886 Sat, 2 Jan 2010 06:19:50 +0000:Advancing towards the same logic to detect ODS capabilities in backup and restore.
robocop committed 32d7bb5 Sat, 2 Jan 2010 06:16:06 +0000:Misc.
robocop committed fed57ea Sat, 2 Jan 2010 02:22:25 +0000:Advancing towards the same logic to detect ODS capabilities in backup and restore.
robocop committed 844d20a Sat, 2 Jan 2010 02:02:12 +0000:Style.

Firebird Weekly News #32

This is the list of firebird related news from week 26 December 2009 - 2 January 2010
FBNews is back ;-) seems that The big increase in the website visitors extrapolated (for the first time) it's bandwidth limit.

Firebird 2.5 rc1 package is now uploaded to debian experimental.

Firebird Interesting Source Patches and Commits in this week

The author of change aac237b was asfernandes Sat, 2 Jan 2010 21:46:11 +0000, The title was:Tweaks to PreparedStatement::Builder and support for output parameters (without "demo" code yet)
The author of change 96b1f3e was asfernandes Sat, 2 Jan 2010 21:34:39 +0000, The title was:Fix segmentation fault running tcs SVC_API_SWEEP_DB
The author of change 179e773 was robocop Sat, 2 Jan 2010 09:38:40 +0000, The title was:Put more strings into the msg db.
The author of change ed20886 was robocop Sat, 2 Jan 2010 06:19:50 +0000, The title was:Advancing towards the same logic to detect ODS capabilities in backup and restore.
The author of change 32d7bb5 was robocop Sat, 2 Jan 2010 06:16:06 +0000, The title was:Misc.
The author of change fed57ea was robocop Sat, 2 Jan 2010 02:22:25 +0000, The title was:Advancing towards the same logic to detect ODS capabilities in backup and restore.
The author of change 844d20a was robocop Sat, 2 Jan 2010 02:02:12 +0000, The title was:Style.
The author of change 7862bb4 was asfernandes Fri, 1 Jan 2010 20:23:47 +0000, The title was:Misc
The author of change 42b6ffe was asfernandes Fri, 1 Jan 2010 18:45:27 +0000, The title was:Misc
The author of change 2b42452 was asfernandes Fri, 1 Jan 2010 18:39:39 +0000, The title was:Do not pass -RAW to GPRE in the build, to facilitate the analyse of generated files
The author of change 2b83948 was asfernandes Fri, 1 Jan 2010 18:10:31 +0000, The title was:Remove the noisy of msgs.h when new messages are added
The author of change 26460cf was robocop Fri, 1 Jan 2010 09:53:40 +0000, The title was:Set ODS8 (IB4.0) as the minimum requirement to backup a db. Establish previous enhancements (belonging to older ODS versions) as always present, then clean the code. Added two messages, too.
The author of change 34d925a was asfernandes Fri, 1 Jan 2010 03:00:25 +0000, The title was:Simplification
The author of change 077db07 was asfernandes Thu, 31 Dec 2009 17:08:04 +0000, The title was:A new way to use PreparedStatement. That one preserves code readability and is very like the preprocessed code.
The author of change 5fa150e was asfernandes Thu, 31 Dec 2009 14:58:12 +0000, The title was:1) Write the function return type as domain, like the parameters. 2) Fix storeGlobalField to always store RDB.
The author of change 3700654 was asfernandes Thu, 31 Dec 2009 11:24:22 +0000, The title was:Make referencing and execution (try) of unimplemented packaged routines work correctly
The author of change aac2ba7 was robocop Thu, 31 Dec 2009 09:07:59 +0000, The title was:Silence these two warnings for now.
The author of change 6352c25 was alexpeshkoff Wed, 30 Dec 2009 15:24:12 +0000, The title was:Introduce isc_dpb_version2 - format is WideTagged.
The author of change 5f8fa34 was alexpeshkoff Wed, 30 Dec 2009 15:16:32 +0000, The title was:removed wrong assertion
The author of change 080c985 was asfernandes Wed, 30 Dec 2009 14:50:17 +0000, The title was:Try to collect function signatures like procedures. Not good yet.
The author of change f6a9091 was alexpeshkoff Wed, 30 Dec 2009 12:55:50 +0000, The title was:Removed a number of unused and suspicious functions
The author of change 805a342 was robocop Wed, 30 Dec 2009 04:24:31 +0000, The title was:Misc.
The author of change 461aa5e was asfernandes Wed, 30 Dec 2009 01:40:38 +0000, The title was:Unify even more procedure and function handling. While at it, fix a wrong access to req_procedure when validating function.
The author of change 3681496 was asfernandes Wed, 30 Dec 2009 00:50:34 +0000, The title was:Misc
The author of change 855a7ef was asfernandes Tue, 29 Dec 2009 15:27:53 +0000, The title was:Fixes and completions for packages
The author of change d313dee was robocop Tue, 29 Dec 2009 12:56:09 +0000, The title was:Comment unused items.
The author of change 1a457b6 was hvlad Tue, 29 Dec 2009 12:46:53 +0000, The title was:All memory allocations should be ALLOC_ALLIGMENT aligned. It fixed bug in Win64 DEBUG build.
The author of change d437012 was robocop Tue, 29 Dec 2009 11:32:57 +0000, The title was:Misc.
The author of change 4c2df7c was dimitr Tue, 29 Dec 2009 10:54:08 +0000, The title was:Support the -D switch on Windows.
The author of change 38e02c1 was robocop Tue, 29 Dec 2009 09:07:08 +0000, The title was:Nicer fix for isql v/s v3 schemas.
The author of change d7c2125 was robocop Tue, 29 Dec 2009 08:42:32 +0000, The title was:Support Dmitry's new system fields in backup/restore. Isql is still missing the needed pieces.
The author of change b3ff3ee was robocop Tue, 29 Dec 2009 07:08:56 +0000, The title was:Misc.
The author of change 650aafa was asfernandes Mon, 28 Dec 2009 22:18:40 +0000, The title was:Support for named parameters for PreparedStatement using C++ variables
The author of change 03794a1 was asfernandes Mon, 28 Dec 2009 15:31:08 +0000, The title was:Store the view context type when it doesn't came from backup and simplify the code. Still problems altering procedures used in views.
The author of change b0398c2 was dimitr Mon, 28 Dec 2009 13:25:11 +0000, The title was:Cleanup the deprecated configuration stuff.
The author of change 5d58e2a was robocop Mon, 28 Dec 2009 11:59:36 +0000, The title was:Prevent isql from creating a db when we want to create a schema or worse, that it drops a db when we want to drop a schema. Of course, in the new ODS 12. Probably the change should be backported to avoid disasters with FB2.5 isql working with FB3.0 server.
The author of change f9bd426 was robocop Mon, 28 Dec 2009 11:54:49 +0000, The title was:Change this confusing ROWCOUNT feature to MAXROWS (there's also COUNT) but the old name is accepted for compatibility with FB2.5.
The author of change a002cac was robocop Mon, 28 Dec 2009 11:46:52 +0000, The title was:Misc.
The author of change a88e45b was asfernandes Mon, 28 Dec 2009 10:21:51 +0000, The title was:Misc
The author of change eeedc64 was hvlad Mon, 28 Dec 2009 09:34:17 +0000, The title was:More detailed statistics : fragments, big records and blobs info are now available when records analisys is performed.
The author of change 4637b39 was hvlad Mon, 28 Dec 2009 09:11:20 +0000, The title was:Swept flag implementation. A little optimisation of mark_full() - don't call it if not necessary, don't mark PP if its flags already matched to DP flags.
The author of change 0426cdf was hvlad Mon, 28 Dec 2009 09:08:31 +0000, The title was:Better name for FIRST_SCN_PAGE constant
The author of change e48a296 was robocop Mon, 28 Dec 2009 07:44:46 +0000, The title was:Temporary measure to compile until Adriano finds a better way.
The author of change c902969 was asfernandes Mon, 28 Dec 2009 01:06:35 +0000, The title was:Make packaged functions work
The author of change 767d481 was asfernandes Sun, 27 Dec 2009 22:05:15 +0000, The title was:1) Make procedures and functions member of the same hierarchy (Routine class) 2) Some completion for external functions
The author of change 0c4151f was asfernandes Sun, 27 Dec 2009 19:05:38 +0000, The title was:Consts
The author of change fe26e77 was asfernandes Sun, 27 Dec 2009 16:49:44 +0000, The title was:Misc
The author of change 6891657 was asfernandes Sun, 27 Dec 2009 16:49:23 +0000, The title was:Fix another problem in cursor handling changes
The author of change 34ef450 was asfernandes Sat, 26 Dec 2009 22:06:22 +0000, The title was:Transform two GDML STORE statements that run on database creation time to DSQL statements and preload DSQL cache objects to make that possible
The author of change 1c5acb0 was robocop Sat, 26 Dec 2009 13:24:37 +0000, The title was:More appropriate name.
The author of change aa557ec was robocop Sat, 26 Dec 2009 13:23:29 +0000, The title was:Check.
The author of change 8825a6a was robocop Sat, 26 Dec 2009 13:22:52 +0000, The title was:Totally misc.
The author of change cd99a13 was asfernandes Sat, 26 Dec 2009 02:21:56 +0000, The title was:Fix problem of mixing dbkey and record version on the same internal parameter

Saturday, December 26, 2009

Firebird Weekly News #31

This is the list of firebird related news from week 19 December 2009 - 26 December 2009

Firebird Interesting Source Patches and Commits in this week

The author of change 1c5acb0 was robocop Sat, 26 Dec 2009 13:24:37 +0000, The title was:More appropriate name.
The author of change aa557ec was robocop Sat, 26 Dec 2009 13:23:29 +0000, The title was:Check.
The author of change 8825a6a was robocop Sat, 26 Dec 2009 13:22:52 +0000, The title was:Totally misc.
The author of change cd99a13 was asfernandes Sat, 26 Dec 2009 02:21:56 +0000, The title was:Fix problem of mixing dbkey and record version on the same internal parameter
The author of change 084f137 was asfernandes Fri, 25 Dec 2009 19:29:49 +0000, The title was:Misc
The author of change 2ebe019 was dimitr Fri, 25 Dec 2009 15:37:24 +0000, The title was:Misc.
The author of change 7aa86f7 was dimitr Fri, 25 Dec 2009 14:37:43 +0000, The title was:PSQL functions (support for default parameters).
The author of change 8794dd9 was dimitr Fri, 25 Dec 2009 13:30:38 +0000, The title was:PSQL functions (continued).
The author of change 5aa1fd6 was dimitr Fri, 25 Dec 2009 12:58:06 +0000, The title was:PSQL functions (security).
The author of change 3339bc6 was dimitr Fri, 25 Dec 2009 12:28:05 +0000, The title was:Corrections.
The author of change 5300c5c was dimitr Fri, 25 Dec 2009 11:24:34 +0000, The title was:Misc.
The author of change 5d20849 was dimitr Fri, 25 Dec 2009 11:16:20 +0000, The title was:We don't need an EOS slot for PSQL functions.
The author of change c09fe8e was dimitr Fri, 25 Dec 2009 11:15:13 +0000, The title was:Now PSQL functions should start [basically] working.
The author of change 3dfdbd4 was dimitr Fri, 25 Dec 2009 10:49:52 +0000, The title was:Corrections.
The author of change b5b3b33 was robocop Fri, 25 Dec 2009 10:30:24 +0000, The title was:Misc.
The author of change 28bb573 was robocop Fri, 25 Dec 2009 10:25:16 +0000, The title was:Put class Attachment in its own files by brute force.
The author of change f2c7e32 was robocop Fri, 25 Dec 2009 10:19:45 +0000, The title was:Put class Attachment in its own files by brute force.
The author of change cc8b844 was robocop Fri, 25 Dec 2009 09:55:01 +0000, The title was:Put class Attachment in its own files by brute force.
The author of change 39e82e0 was dimitr Fri, 25 Dec 2009 09:50:35 +0000, The title was:Corrections.
The author of change ee4ca09 was dimitr Fri, 25 Dec 2009 07:25:49 +0000, The title was:Correction.
The author of change 4ea6810 was dimitr Fri, 25 Dec 2009 07:24:09 +0000, The title was:Misc.
The author of change 42147e8 was dimitr Fri, 25 Dec 2009 07:09:02 +0000, The title was:I believe this code has been originally intended to work this way.
The author of change 2733ea3 was dimitr Fri, 25 Dec 2009 06:52:09 +0000, The title was:Corrections.
The author of change e60a06d was robocop Fri, 25 Dec 2009 05:18:07 +0000, The title was:Tabify and style.
The author of change 3cfe4ed was robocop Fri, 25 Dec 2009 04:41:10 +0000, The title was:Misc.
The author of change 835acb1 was asfernandes Fri, 25 Dec 2009 00:13:46 +0000, The title was:Fix Linux SS build
The author of change aeec060 was dimitr Thu, 24 Dec 2009 15:41:39 +0000, The title was:An alternative way to assign auto-generated metadata IDs while restoring a database. It doesn't require system triggers. If nobody objects, I will migrate procedure/exception/generator IDs to this approach and then redo my system triggers cleanup.
The author of change f59255d was dimitr Thu, 24 Dec 2009 15:27:30 +0000, The title was:Misc.
The author of change 9677b4b was dimitr Thu, 24 Dec 2009 14:29:18 +0000, The title was:Sorry, this was a bad idea. Backup/restore cycle doesn't preserve IDs. To be reconsidered some other day.
The author of change 00f6984 was dimitr Thu, 24 Dec 2009 14:24:04 +0000, The title was:Cleanup. These system triggers are not required anymore, IDs are assigned by the engine itself.
The author of change 5fbb0ec was dimitr Thu, 24 Dec 2009 14:15:21 +0000, The title was:Metadata cache support for PSQL functions.
The author of change 2311f72 was robocop Thu, 24 Dec 2009 12:56:31 +0000, The title was:Shortcut.
The author of change f9780de was dimitr Thu, 24 Dec 2009 12:02:29 +0000, The title was:Corrections.
The author of change 6847d4f was robocop Thu, 24 Dec 2009 11:49:15 +0000, The title was:I copied this code from another place, but I'm not sure how to proceed in case of errors.
The author of change 7aa447e was robocop Thu, 24 Dec 2009 11:48:17 +0000, The title was:Misc and cleanup.
The author of change e92cbb1 was robocop Thu, 24 Dec 2009 10:42:31 +0000, The title was:Misc.
The author of change a1c8618 was dimitr Thu, 24 Dec 2009 10:32:06 +0000, The title was:Corrections.
The author of change 026a768 was asfernandes Wed, 23 Dec 2009 21:43:34 +0000, The title was:Misc
The author of change c1090b1 was dimitr Wed, 23 Dec 2009 14:19:02 +0000, The title was:Cleanup.
The author of change f1e0dda was asfernandes Wed, 23 Dec 2009 01:19:18 +0000, The title was:Misc
The author of change 1fb89bb was asfernandes Wed, 23 Dec 2009 00:57:02 +0000, The title was:More refactoring: name changes, accessors, consts, removed not good references (statement referencing scratch and metadata indirectly)
The author of change 2f9c597 was asfernandes Tue, 22 Dec 2009 15:36:06 +0000, The title was:Getters and setters for DsqlCompiledStatement and consts
The author of change 5419482 was asfernandes Tue, 22 Dec 2009 14:26:49 +0000, The title was:Fix MSVC8 build
The author of change 14b529c was alexpeshkoff Tue, 22 Dec 2009 10:30:47 +0000, The title was:Cleanup - two flags are always set to true starting with ODS > 10
The author of change 5fde954 was dimitr Tue, 22 Dec 2009 05:32:05 +0000, The title was:Correction, thanks to Adriano.
The author of change 24921de was asfernandes Tue, 22 Dec 2009 00:08:43 +0000, The title was:Some fixes; Misc.
The author of change b43a8ab was asfernandes Mon, 21 Dec 2009 20:55:03 +0000, The title was:1) Make it build in Linux; 2) Fix some warnings
The author of change 5c8776b was dimitr Mon, 21 Dec 2009 17:55:05 +0000, The title was:Fixed project files.
The author of change 65d33b3 was dimitr Mon, 21 Dec 2009 17:53:49 +0000, The title was:Support for PSQL functions (other JRD changes). Still work in progress.
The author of change eee5dee was dimitr Mon, 21 Dec 2009 17:42:58 +0000, The title was:Support for PSQL functions (other JRD changes). Still work in progress.
The author of change 4c3438e was dimitr Mon, 21 Dec 2009 17:31:34 +0000, The title was:Support for PSQL functions (misc JRD changes). Still work in progress.
The author of change 23ab1e0 was dimitr Mon, 21 Dec 2009 17:29:12 +0000, The title was:Misc.
The author of change c2e5aa4 was dimitr Mon, 21 Dec 2009 17:23:07 +0000, The title was:Support for PSQL functions (only the DSQL part so far). Still work in progress.
The author of change 55912d2 was dimitr Mon, 21 Dec 2009 16:54:27 +0000, The title was:Support for PSQL functions.
The author of change a01b9ef was dimitr Mon, 21 Dec 2009 16:53:21 +0000, The title was:Misc.
The author of change 30cd113 was dimitr Mon, 21 Dec 2009 16:44:05 +0000, The title was:Support for PSQL functions.
The author of change cdd87b2 was dimitr Mon, 21 Dec 2009 16:37:48 +0000, The title was:Error codes introduced for PSQL functions.
The author of change c589cf3 was dimitr Mon, 21 Dec 2009 16:35:18 +0000, The title was:New system fields (ODS change).
The author of change 2af7952 was asfernandes Mon, 21 Dec 2009 15:43:23 +0000, The title was:Use the correct translation files in posix build, pointed by Claudio
The author of change c2a72b2 was asfernandes Mon, 21 Dec 2009 15:11:57 +0000, The title was:Just started some separation of concerns
The author of change c675854 was asfernandes Mon, 21 Dec 2009 14:56:10 +0000, The title was:Make dsql_req::statement constant
The author of change fb1fbc7 was asfernandes Mon, 21 Dec 2009 14:20:26 +0000, The title was:Misc
The author of change 2e3dbe7 was alexpeshkoff Mon, 21 Dec 2009 11:58:26 +0000, The title was:Fixed error reporting in nbackup
The author of change de18d9a was robocop Mon, 21 Dec 2009 07:01:22 +0000, The title was:Get rid of the obsolete option CompleteBooleanEvaluation in the config file. We always do short-circuit boolean logic.
The author of change 2f9381e was asfernandes Sun, 20 Dec 2009 23:41:45 +0000, The title was:Consts
The author of change 1ee3a05 was hvlad Sun, 20 Dec 2009 23:12:58 +0000, The title was:ODS change : implemented SCN inventory pages to make diffrential backup faster not reading pages which was not changed since previous backup. Corresponding nbackup and validation code changes also done. PAG code refactored a bit.
The author of change 79a2e0c was asfernandes Sun, 20 Dec 2009 22:42:42 +0000, The title was:Separate the scratch, statement and request flags. Don't ask me why I didn't change them to bools.
The author of change 038b4f4 was asfernandes Sun, 20 Dec 2009 21:01:04 +0000, The title was:Refactor DSQL, continuing the work I started in 2.5: - Renamed CompiledStatement to DsqlCompilerScratch and removed inheritance to dsql_req. - Introduced DsqlCompilerStatement, moving things from dsql_req - not completelly shareable yet. - Make dsql_req reference a DsqlCompilerStatement. DsqlCompilerScratch may be discarded in the future. - Replaced AlterCharSetNode usage by PreparedStatement for the default collation in database creation. - Changed METD API.
The author of change b7016d8 was asfernandes Sun, 20 Dec 2009 20:49:47 +0000, The title was:Fix Linux build
The author of change 0569cd9 was robocop Sun, 20 Dec 2009 09:19:14 +0000, The title was:Misc.
The author of change 623437f was asfernandes Sat, 19 Dec 2009 22:52:17 +0000, The title was:Push more state out of dsql_parameter
The author of change 6896711 was asfernandes Sat, 19 Dec 2009 21:20:36 +0000, The title was:Separating run state from compiled statements
The author of change ecd818d was asfernandes Sat, 19 Dec 2009 21:13:47 +0000, The title was:READ BLOB command has one input parameter...
The author of change f19feea was asfernandes Sat, 19 Dec 2009 18:50:34 +0000, The title was:Replaced linked list of dsql parameters by array
The author of change 16df636 was asfernandes Sat, 19 Dec 2009 15:39:23 +0000, The title was:Misc
The author of change 160c4e8 was asfernandes Sat, 19 Dec 2009 15:06:56 +0000, The title was:Detect charset not found
The author of change 20b13c8 was asfernandes Sat, 19 Dec 2009 15:00:15 +0000, The title was:Changed parameters to unsigned; Misc
The author of change f354cc4 was hvlad Sat, 19 Dec 2009 13:03:18 +0000, The title was:Fixed AV
The author of change 6d3e0bf was robocop Sat, 19 Dec 2009 12:48:50 +0000, The title was:GDEF is dead. In practice, it was dead in 1994 since Borland didn't provide a binary for it in IB4.
The author of change 95b49ae was robocop Sat, 19 Dec 2009 09:16:59 +0000, The title was:Trying to reflect better what nbackup options do.
The author of change 167bd2c was robocop Sat, 19 Dec 2009 09:02:50 +0000, The title was:Correction (worked thanks to legacy-aware code).
The author of change 712dfc5 was robocop Sat, 19 Dec 2009 04:11:19 +0000, The title was:Fixing the indentation of two gbak messages.
The author of change 227c3c1 was asfernandes Sat, 19 Dec 2009 02:08:53 +0000, The title was:It's 2009 - thanks to Alex :)
The author of change 172e151 was asfernandes Sat, 19 Dec 2009 01:32:00 +0000, The title was:Fixed unregistered bug: Query string crashes 2.5RC1

Saturday, December 19, 2009

Firebird Weekly News #30

This is the list of firebird related news from week 12 December 2009 - 19 December 2009

Firebird Interesting Source Patches and Commits in this week

The author of change 6896711 was asfernandes Sat, 19 Dec 2009 21:20:36 +0000, The title was:Separating run state from compiled statements
The author of change ecd818d was asfernandes Sat, 19 Dec 2009 21:13:47 +0000, The title was:READ BLOB command has one input parameter...
The author of change f19feea was asfernandes Sat, 19 Dec 2009 18:50:34 +0000, The title was:Replaced linked list of dsql parameters by array
The author of change 16df636 was asfernandes Sat, 19 Dec 2009 15:39:23 +0000, The title was:Misc
The author of change 160c4e8 was asfernandes Sat, 19 Dec 2009 15:06:56 +0000, The title was:Detect charset not found
The author of change 20b13c8 was asfernandes Sat, 19 Dec 2009 15:00:15 +0000, The title was:Changed parameters to unsigned; Misc
The author of change f354cc4 was hvlad Sat, 19 Dec 2009 13:03:18 +0000, The title was:Fixed AV
The author of change 6d3e0bf was robocop Sat, 19 Dec 2009 12:48:50 +0000, The title was:GDEF is dead. In practice, it was dead in 1994 since Borland didn't provide a binary for it in IB4.
The author of change 95b49ae was robocop Sat, 19 Dec 2009 09:16:59 +0000, The title was:Trying to reflect better what nbackup options do.
The author of change 167bd2c was robocop Sat, 19 Dec 2009 09:02:50 +0000, The title was:Correction (worked thanks to legacy-aware code).
The author of change 712dfc5 was robocop Sat, 19 Dec 2009 04:11:19 +0000, The title was:Fixing the indentation of two gbak messages.
The author of change 227c3c1 was asfernandes Sat, 19 Dec 2009 02:08:53 +0000, The title was:It's 2009 - thanks to Alex :)
The author of change 172e151 was asfernandes Sat, 19 Dec 2009 01:32:00 +0000, The title was:Fixed unregistered bug: Query string crashes 2.5RC1
The author of change d79b8bd was alexpeshkoff Fri, 18 Dec 2009 16:33:57 +0000, The title was:Enhanced fbsvcmgr usage print - list all known switches if -? is specified
The author of change 1ee5258 was alexpeshkoff Fri, 18 Dec 2009 14:15:22 +0000, The title was:Frontported detection of missing/invalid parameter in fbsvcmgr
The author of change fdb4d45 was alexpeshkoff Fri, 18 Dec 2009 14:06:18 +0000, The title was:Frontported changes to make -Direct switch of nbackup accept on/off parameter
The author of change 391785f was alexpeshkoff Fri, 18 Dec 2009 12:42:14 +0000, The title was:Frontported - fixed delivery of status vector from service thread
The author of change 886ff5c was robocop Fri, 18 Dec 2009 12:01:39 +0000, The title was:Move more hardcoded messages to the msg db.
The author of change 9ff1e01 was asfernandes Fri, 18 Dec 2009 10:26:32 +0000, The title was:Fixed unregistered bug: ALTER VIEW drops permissions
The author of change 054b48a was robocop Fri, 18 Dec 2009 07:46:45 +0000, The title was:Cleanup.
The author of change d660aaf was robocop Fri, 18 Dec 2009 07:16:02 +0000, The title was:When the two loops were joined, the value for rdb$context_type was different and this part was ignored, therefore a bug was introduced where views based on packaged procedures can't find their base fields. Since adjusting the two conditions in the same loop was cumbersome and the condition I needed to add made the statement a mess, I preferred to have two loops again. Better a tad of redundancy but with readable and correct code.
The author of change af8ecdf was asfernandes Thu, 17 Dec 2009 23:59:04 +0000, The title was:Misc
The author of change 5c04f81 was asfernandes Thu, 17 Dec 2009 23:57:14 +0000, The title was:I insist again, we're in December (and counting from 1) :)
The author of change cd51caa was asfernandes Thu, 17 Dec 2009 23:25:11 +0000, The title was:Cleanup
The author of change c0ffed1 was sboyd Thu, 17 Dec 2009 21:55:07 +0000, The title was:Fixed a memory leak.
The author of change 9de609c was hvlad Thu, 17 Dec 2009 19:29:29 +0000, The title was:Caller should know reason why LM denied its request
The author of change 2b89c7f was asfernandes Thu, 17 Dec 2009 15:07:00 +0000, The title was:Work in progress on RDB$VIEW_RELATIONS
The author of change b58861f was robocop Thu, 17 Dec 2009 10:50:34 +0000, The title was:Make more error messages non-hardcoded.
The author of change 7bfae98 was robocop Thu, 17 Dec 2009 10:45:17 +0000, The title was:Correction.
The author of change b846dd5 was robocop Thu, 17 Dec 2009 10:44:32 +0000, The title was:Misc.
The author of change 6e71c4a was hvlad Thu, 17 Dec 2009 10:25:23 +0000, The title was:Misc : rename PageSpace::ppFirst to pipFirst
The author of change 961080e was hvlad Thu, 17 Dec 2009 09:50:28 +0000, The title was:ODS change : implement dpg_secondary flag. Other : make table scan skip secondary data pages, propagate record type to the store_big_record to allow record head be stored at the primary record page.
The author of change 4f0235a was dimitr Thu, 17 Dec 2009 09:04:52 +0000, The title was:Restored the validation that was formerly related to FUN_resolve() which has been cleaned up.
The author of change f629d50 was asfernandes Thu, 17 Dec 2009 01:36:33 +0000, The title was:Cleanup
The author of change 48e8151 was asfernandes Thu, 17 Dec 2009 00:43:37 +0000, The title was:Fix COMMENT ON ... IS NULL
The author of change 944da40 was asfernandes Thu, 17 Dec 2009 00:38:55 +0000, The title was:Cleanup
The author of change 96878e7 was asfernandes Thu, 17 Dec 2009 00:07:23 +0000, The title was:Cleanup
The author of change 80c82da was asfernandes Wed, 16 Dec 2009 21:51:50 +0000, The title was:Misc
The author of change d51b1d4 was dimitr Wed, 16 Dec 2009 18:35:55 +0000, The title was:Cleanup.
The author of change 827f33e was alexpeshkoff Wed, 16 Dec 2009 17:28:47 +0000, The title was:Added switch to nbackup, controlling direct access to database file
The author of change 9323b20 was alexpeshkoff Wed, 16 Dec 2009 13:40:19 +0000, The title was:Some more changes suggested by Claudio
The author of change 5e4ddc4 was alexpeshkoff Wed, 16 Dec 2009 13:10:12 +0000, The title was:Make libib_util usable with old server versions
The author of change 7709283 was alexpeshkoff Wed, 16 Dec 2009 12:34:11 +0000, The title was:It was bad idea to try to make fbsvcmgr more intellectual than it should be - rolled back part of my changes
The author of change 8195398 was alexpeshkoff Wed, 16 Dec 2009 11:45:28 +0000, The title was:Fixed an issue with gsec compatibility with previous versions
The author of change e283ee8 was alexpeshkoff Wed, 16 Dec 2009 11:25:44 +0000, The title was:Fixed an issue with gsec compatibility with previous versions
The author of change b033ada was alexpeshkoff Wed, 16 Dec 2009 11:19:46 +0000, The title was:Forgotten file?
The author of change a867e0f was robocop Wed, 16 Dec 2009 10:58:08 +0000, The title was:Distinguish between table and view in verbose mode.
The author of change 724ec44 was robocop Wed, 16 Dec 2009 09:34:24 +0000, The title was:I'll put this code to test when I find a suitable syntax to push comments.
The author of change 95684a7 was robocop Wed, 16 Dec 2009 09:31:36 +0000, The title was:Warning.
The author of change 1c0ecf0 was robocop Wed, 16 Dec 2009 08:12:56 +0000, The title was:Localization: one needed message and two messages to be used.
The author of change 6e7470e was robocop Wed, 16 Dec 2009 08:06:48 +0000, The title was:Misc.
The author of change 7a3b154 was robocop Wed, 16 Dec 2009 08:05:41 +0000, The title was:Correction.
The author of change 62693d0 was robocop Tue, 15 Dec 2009 14:08:23 +0000, The title was:Make views know exactly what type of source their fields have: include a type of context and a package name in rdb$view_relations. Debugged with a small script. To be reviewed & completed by Adriano. Full rebuild, please.
The author of change f54b3c0 was alexpeshkoff Tue, 15 Dec 2009 13:55:35 +0000, The title was:fixed gcc warnings
The author of change af6d72d was dimitr Tue, 15 Dec 2009 12:25:42 +0000, The title was:Cleanup.
The author of change f425dbf was asfernandes Mon, 14 Dec 2009 23:55:50 +0000, The title was:Misc
The author of change 94b32cf was dimitr Mon, 14 Dec 2009 16:43:47 +0000, The title was:Misc.
The author of change 9793d97 was dimitr Mon, 14 Dec 2009 16:01:06 +0000, The title was:Simplification.
The author of change f147244 was asfernandes Mon, 14 Dec 2009 15:16:50 +0000, The title was:Front-port fix for CORE-2804 - Problems with COMMENT ON and strings using introducer (charset)
The author of change 8b98745 was dimitr Mon, 14 Dec 2009 14:29:20 +0000, The title was:Optimization: avoid reading the underlying streams in the case of "FIRST 0".
The author of change 57398e7 was alexpeshkoff Mon, 14 Dec 2009 14:26:17 +0000, The title was:Fixed CORE-2807: Problem with tracing on linux
The author of change 18194bf was alexpeshkoff Mon, 14 Dec 2009 13:55:58 +0000, The title was:Fixed bug in my last commit - init handle
The author of change fb7618d was dimitr Mon, 14 Dec 2009 12:56:27 +0000, The title was:Scrollable cursors: work continued.
The author of change 7cb5495 was dimitr Mon, 14 Dec 2009 12:31:03 +0000, The title was:Fixed CORE-2806: Views based on procedures can't be created if the proc's output fields participate in an expression.
The author of change b95c315 was alexpeshkoff Mon, 14 Dec 2009 12:14:35 +0000, The title was:Ugly fix to avoid detaching security database before attach is really complete. Will not be beeded after moving auth to remote level.
The author of change 2f612ba was alexpeshkoff Mon, 14 Dec 2009 12:13:17 +0000, The title was:Better way to deal with exceptions in catch blocks
The author of change bf865c2 was alexpeshkoff Mon, 14 Dec 2009 12:09:49 +0000, The title was:fixed posix build
The author of change ccf4fa4 was hvlad Mon, 14 Dec 2009 11:41:47 +0000, The title was:Misc
The author of change de28d13 was dimitr Mon, 14 Dec 2009 11:40:26 +0000, The title was:Misc.
The author of change c426e02 was hvlad Mon, 14 Dec 2009 11:38:40 +0000, The title was:Forgotten changes
The author of change e379938 was dimitr Mon, 14 Dec 2009 11:33:13 +0000, The title was:Cleanup.
The author of change effba78 was dimitr Mon, 14 Dec 2009 11:19:45 +0000, The title was:Cleanup.
The author of change 9242d76 was dimitr Mon, 14 Dec 2009 11:19:10 +0000, The title was:Let's transfer procedure aliases to the engine similarly to how it is done for relations. This allows more precise plan reporting. I hate to waste the BLR space in such a vandal way, so I'm open to any better suggestions.
The author of change 2ed2d05 was hvlad Mon, 14 Dec 2009 09:46:14 +0000, The title was:A couple of ODS changes : - abandon page checksums and use page number for validation - PIP have now pip_used field to track number of allocated pages - two more flag bits per data page is now reserved on pointer page. One is for the swept flag and second is still not used but makes calculations easy - misc changes Don't forget to rebuild your DBs !
The author of change 5672da5 was dimitr Mon, 14 Dec 2009 09:23:27 +0000, The title was:Misc.
The author of change 266054c was dimitr Mon, 14 Dec 2009 09:17:05 +0000, The title was:Rollback to the prior revision, as the latest commit crashes the engine.
The author of change 94fce8d was dimitr Mon, 14 Dec 2009 07:27:05 +0000, The title was:Misc.
The author of change 9685cf6 was hvlad Sun, 13 Dec 2009 21:16:29 +0000, The title was:Let use correct rsb type in PLAN output
The author of change 0a86270 was robocop Sun, 13 Dec 2009 13:49:38 +0000, The title was:Cleanup.
The author of change d155809 was dimitr Sun, 13 Dec 2009 12:08:02 +0000, The title was:Misc.
The author of change e20d4cd was dimitr Sun, 13 Dec 2009 11:50:27 +0000, The title was:Cleanup the unneeded routines.
The author of change 0286375 was robocop Sun, 13 Dec 2009 11:07:05 +0000, The title was:Unused functions, unused parameters, unused vars.
The author of change 920a4ae was robocop Sun, 13 Dec 2009 11:06:24 +0000, The title was:Misc.
The author of change cf4d6b1 was robocop Sun, 13 Dec 2009 10:56:15 +0000, The title was:Applying the vacuum cleaner to this header.
The author of change 0b70287 was robocop Sun, 13 Dec 2009 10:55:32 +0000, The title was:It's easy to streamline the code when another person did the hard job before. :-)
The author of change 31d8102 was robocop Sun, 13 Dec 2009 10:42:55 +0000, The title was:Correction (paying attention to warnings can help really).
The author of change 976a41d was robocop Sun, 13 Dec 2009 10:41:49 +0000, The title was:Misc, style and unused vars.
The author of change 036290d was aafemt Sun, 13 Dec 2009 09:43:02 +0000, The title was:Fix MinGW build
The author of change 0e42755 was dimitr Sun, 13 Dec 2009 08:17:32 +0000, The title was:Set up the ANY/ALL boolean at the compile time instead of runtime.
The author of change 1bf3595 was dimitr Sun, 13 Dec 2009 07:38:26 +0000, The title was:Fixed the binary plan output, thanks to Claudio.
The author of change 33e7d91 was asfernandes Sat, 12 Dec 2009 21:02:01 +0000, The title was:Misc
The author of change 2e7b501 was asfernandes Sat, 12 Dec 2009 20:56:11 +0000, The title was:Misc
The author of change 86b38be was asfernandes Sat, 12 Dec 2009 20:36:54 +0000, The title was:Sort maps refactor
The author of change a59dcdf was asfernandes Sat, 12 Dec 2009 19:00:41 +0000, The title was:Remove usage of plain array with count in [0] in the new classes
The author of change 8864b02 was dimitr Sat, 12 Dec 2009 17:57:48 +0000, The title was:Misc.
The author of change 5da2e06 was hvlad Sat, 12 Dec 2009 17:15:56 +0000, The title was:Fixed bug CORE-2797 : Problem with default value of SP parameter
The author of change dfd4296 was dimitr Sat, 12 Dec 2009 14:54:33 +0000, The title was:Misc.
The author of change 37cbb0d was dimitr Sat, 12 Dec 2009 14:44:28 +0000, The title was:Fixed a not-initialized pointer.
The author of change 304ca89 was dimitr Sat, 12 Dec 2009 10:23:14 +0000, The title was:Please Claudio and make the flags unique across all RecordSource implementors.

Saturday, December 12, 2009

Firebird Weekly News #29

This is the list of firebird related news from week 5 December 2009 - 12 December 2009

Firebird Interesting Source Patches and Commits in this week

The author of change 33e7d91 was asfernandes Sat, 12 Dec 2009 21:02:01 +0000, The title was:Misc
The author of change 2e7b501 was asfernandes Sat, 12 Dec 2009 20:56:11 +0000, The title was:Misc
The author of change 86b38be was asfernandes Sat, 12 Dec 2009 20:36:54 +0000, The title was:Sort maps refactor
The author of change a59dcdf was asfernandes Sat, 12 Dec 2009 19:00:41 +0000, The title was:Remove usage of plain array with count in [0] in the new classes
The author of change 8864b02 was dimitr Sat, 12 Dec 2009 17:57:48 +0000, The title was:Misc.
The author of change 5da2e06 was hvlad Sat, 12 Dec 2009 17:15:56 +0000, The title was:Fixed bug CORE-2797 : Problem with default value of SP parameter
The author of change dfd4296 was dimitr Sat, 12 Dec 2009 14:54:33 +0000, The title was:Misc.
The author of change 37cbb0d was dimitr Sat, 12 Dec 2009 14:44:28 +0000, The title was:Fixed a not-initialized pointer.
The author of change 304ca89 was dimitr Sat, 12 Dec 2009 10:23:14 +0000, The title was:Please Claudio and make the flags unique across all RecordSource implementors.
The author of change 64cdb0d was asfernandes Fri, 11 Dec 2009 14:48:15 +0000, The title was:Misc
The author of change 71683f6 was asfernandes Fri, 11 Dec 2009 14:47:41 +0000, The title was:Make WITH LOCK work with window functions
The author of change 30a16e2 was dimitr Fri, 11 Dec 2009 07:01:52 +0000, The title was:Misc.
The author of change 1cd6827 was dimitr Thu, 10 Dec 2009 20:09:23 +0000, The title was:Misc.
The author of change 84870b5 was dimitr Thu, 10 Dec 2009 16:26:11 +0000, The title was:Restored the code from rse.cpp that was forgotten during refactoring.
The author of change f776dd9 was dimitr Thu, 10 Dec 2009 15:50:16 +0000, The title was:Boundary check.
The author of change 0b561bb was dimitr Thu, 10 Dec 2009 15:27:17 +0000, The title was:Forgotten changes from a few prior commits.
The author of change 67b986e was dimitr Thu, 10 Dec 2009 15:25:39 +0000, The title was:Fixed the merge join algorithm. Thanks to Adriano.
The author of change eb3d231 was dimitr Thu, 10 Dec 2009 15:03:56 +0000, The title was:Fixed the plan output (reversed order of view sub-elements) in HEAD (also broken by my yesterday's commit).
The author of change 8d073e2 was dimitr Thu, 10 Dec 2009 14:48:42 +0000, The title was:Fixed the plan output (table names) in HEAD (broken by my yesterday's commit).
The author of change 4529def was dimitr Thu, 10 Dec 2009 14:47:51 +0000, The title was:Fixed (hopefully) CORE-2798: Incomplete plan output (lack of view names) when selecting from views containing procedures inside.
The author of change 1368677 was asfernandes Thu, 10 Dec 2009 13:46:16 +0000, The title was:Rename file to match class name
The author of change ede7a8f was dimitr Thu, 10 Dec 2009 12:45:16 +0000, The title was:Misc.
The author of change e015c46 was asfernandes Thu, 10 Dec 2009 12:16:57 +0000, The title was:Misc
The author of change fec6d30 was dimitr Thu, 10 Dec 2009 10:13:22 +0000, The title was:Corrected the logic. Thanks to Adriano.
The author of change 945861a was robocop Thu, 10 Dec 2009 07:24:13 +0000, The title was:Do not hardcode anymore the backup versions allowed.
The author of change df8d8e0 was dimitr Thu, 10 Dec 2009 05:20:20 +0000, The title was:Fixed the build.
The author of change f4b2f48 was dimitr Thu, 10 Dec 2009 05:09:33 +0000, The title was:Simplified the code, thanks to Adriano.
The author of change ebcaaee was asfernandes Thu, 10 Dec 2009 01:32:44 +0000, The title was:Misc / Constant for aggregate state
The author of change fa5a9e5 was asfernandes Thu, 10 Dec 2009 00:29:41 +0000, The title was:Fix window functions
The author of change edf6754 was asfernandes Thu, 10 Dec 2009 00:02:00 +0000, The title was:Misc / warnings
The author of change 6e725bf was hvlad Wed, 9 Dec 2009 23:06:29 +0000, The title was:Fixed bug CORE-2783 : AV using recursive query as subquery in SELECT list and ORDER'ing by them
The author of change ca2c1ed was hvlad Wed, 9 Dec 2009 23:05:47 +0000, The title was:Fix MSVC8 build - follow recent MSVC9 changes
The author of change 7c44e95 was asfernandes Wed, 9 Dec 2009 20:55:08 +0000, The title was:Make it build in Linux
The author of change 23edadf was dimitr Wed, 9 Dec 2009 18:45:25 +0000, The title was:Refactored the whole RSB stuff into classes. They're inside the /recsrc sub-directory now. Fixed the layering for WITH LOCK and (partially) ANY/ALL predicates. Cleaned up the outdated code that never worked (mapping DISTINCT to an index, some VMS remainings). Wiped out a lot of the pre-ODS11 optimizer logic. Some minor adjustments there. Re-implemented the full outer join from scratch. This resolves CORE-2678 (full outer join cannot use available indices). Resolved CORE-2796: DB_KEY is always zero for external tables. Implemented the core part of the scrollable PSQL cursors. Implementation is still incomplete, but ready for testing. Some other changes I don't recall at the moment ;-)
The author of change 8541b42 was dimitr Wed, 9 Dec 2009 18:37:26 +0000, The title was:Refactored the whole RSB stuff into classes. They're inside the /recsrc sub-directory now. Fixed the layering for WITH LOCK and (partially) ANY/ALL predicates. Cleaned up the outdated code that never worked (mapping DISTINCT to an index, some VMS remainings). Wiped out a lot of the pre-ODS11 optimizer logic. Some minor adjustments there. Re-implemented the full outer join from scratch. This resolves CORE-2678 (full outer join cannot use available indices). Resolved CORE-2796: DB_KEY is always zero for external tables. Implemented the core part of the scrollable PSQL cursors. Implementation is still incomplete, but ready for testing. Some other changes I don't recall at the moment ;-)
The author of change 8921de8 was dimitr Wed, 9 Dec 2009 18:34:46 +0000, The title was:Refactored the whole RSB stuff into classes. They're inside the /recsrc sub-directory now. Fixed the layering for WITH LOCK and (partially) ANY/ALL predicates. Cleaned up the outdated code that never worked (mapping DISTINCT to an index, some VMS remainings). Wiped out a lot of the pre-ODS11 optimizer logic. Some minor adjustments there. Re-implemented the full outer join from scratch. This resolves CORE-2678 (full outer join cannot use available indices). Resolved CORE-2796: DB_KEY is always zero for external tables. Implemented the core part of the scrollable PSQL cursors. Implementation is still incomplete, but ready for testing. Some other changes I don't recall at the moment ;-)
The author of change 539dde8 was asfernandes Wed, 9 Dec 2009 14:54:57 +0000, The title was:Fix assertion error in VIO, reported by Dmitry
The author of change e8c7a5b was alexpeshkoff Tue, 8 Dec 2009 15:02:04 +0000, The title was:Frontported fixed of bugs, found during 2.5.0.RC1 QA - incorrect message when lockdir is not accessible; broken yValve behavior when lockdir is not accessible; bad access rights on lockdir in init.d startup scripts
The author of change 42878b0 was asfernandes Tue, 8 Dec 2009 14:28:50 +0000, The title was:Corrections
The author of change 33d49b3 was alexpeshkoff Tue, 8 Dec 2009 14:24:41 +0000, The title was:fixed compile error
The author of change 1ff25a3 was asfernandes Mon, 7 Dec 2009 18:26:48 +0000, The title was:Feature CORE-2777 - Make possible to alter the default database character set without manual update of system table
The author of change 6b1c362 was dimitr Mon, 7 Dec 2009 16:22:39 +0000, The title was:Fixed the interactive lock print header for waits. It was showing non-supported columns.
The author of change 22fa22f was asfernandes Mon, 7 Dec 2009 15:55:38 +0000, The title was:Misc
The author of change 826206f was dimitr Mon, 7 Dec 2009 10:44:29 +0000, The title was:Cleanup. Page numbers are not expected to be 64-bit in the foreseeable future.
The author of change e3cdd51 was dimitr Mon, 7 Dec 2009 09:47:00 +0000, The title was:Implemented CORE-1906: Allow interactive arguments (seconds and intervals) of fb_lock_print to be 32-bit integers.
The author of change 7be7a65 was robocop Mon, 7 Dec 2009 08:54:29 +0000, The title was:Put an indication in case of string truncation when backing up.
The author of change d65e771 was robocop Mon, 7 Dec 2009 08:53:02 +0000, The title was:Misc.
The author of change 56b1896 was robocop Mon, 7 Dec 2009 05:32:05 +0000, The title was:Make clearer that we are working with binary, untranslatable blobs.
The author of change 8ab1f06 was robocop Mon, 7 Dec 2009 05:30:42 +0000, The title was:After Adriano's changes, DYN_get_string does not transliterate anymore, therefore I'm cleaning the code (macros GET_STRING and GET_BYTES retained for readability, although they are the same now).
The author of change c4da0a2 was robocop Mon, 7 Dec 2009 05:28:16 +0000, The title was:I find it more readable now (following our style at 100 columns).
The author of change e0d64b5 was asfernandes Sun, 6 Dec 2009 19:22:01 +0000, The title was:Misc
The author of change 9b088ae was asfernandes Sun, 6 Dec 2009 19:11:22 +0000, The title was:Move and rename methods
The author of change 5a88521 was asfernandes Sun, 6 Dec 2009 14:13:24 +0000, The title was:Warning
The author of change a0895a1 was asfernandes Sun, 6 Dec 2009 14:13:07 +0000, The title was:No need to convert sql_state and fallback to original exception logic in "catch (...)" to preserve status vector - things noticed by Claudio
The author of change 9138073 was asfernandes Sun, 6 Dec 2009 13:51:03 +0000, The title was:Fix possible problem with the transliteration buffer size - thanks to Claudio
The author of change 4e05d30 was robocop Sun, 6 Dec 2009 11:27:42 +0000, The title was:Avoid warning.
The author of change 7e7fb24 was robocop Sun, 6 Dec 2009 11:27:14 +0000, The title was:Comment now unused functionality.
The author of change e1d0a49 was robocop Sun, 6 Dec 2009 11:21:16 +0000, The title was:Misc.
The author of change 6ca4180 was aafemt Sun, 6 Dec 2009 10:38:37 +0000, The title was:No hardcoded library extension, please
The author of change 39dae34 was hvlad Sun, 6 Dec 2009 09:49:58 +0000, The title was:Don't use with x64 build Win32 targets
The author of change 700a933 was hvlad Sun, 6 Dec 2009 09:36:52 +0000, The title was:Fix fb_lock_print compilation
The author of change c9de470 was asfernandes Sun, 6 Dec 2009 02:40:01 +0000, The title was:Misc
The author of change fad7966 was asfernandes Sun, 6 Dec 2009 02:28:00 +0000, The title was:Fixed SYS5 code
The author of change 4a431a9 was asfernandes Sun, 6 Dec 2009 02:07:04 +0000, The title was:Remove definitions not used by btyacc
The author of change 59a5547 was asfernandes Sun, 6 Dec 2009 01:34:52 +0000, The title was:Remove usage of tdbb (and tdbb->tdbb_status_vector) in the lock manager
The author of change 48bfc36 was asfernandes Sat, 5 Dec 2009 20:10:57 +0000, The title was:Cleanup
The author of change 1999a65 was asfernandes Sat, 5 Dec 2009 15:08:18 +0000, The title was:Extract and show DDL triggers types
The author of change 16fb7f6 was asfernandes Sat, 5 Dec 2009 14:21:46 +0000, The title was:1) Use metadata character set in DSQL cache 2) Make exceptions in metadata charset and convert them to the client charset - this should fix CORE-2431 3) Support for "internal" (engine) DSQL statements and use in COMMENT ON
The author of change a763fc0 was robocop Sat, 5 Dec 2009 12:51:12 +0000, The title was:CORE-2792: Bad extraction syntax for procedure's parameter based on table's field
The author of change 81577bf was robocop Sat, 5 Dec 2009 12:39:46 +0000, The title was:isql: collapse a lot of copy/paste into a single function.
The author of change 017b24d was robocop Sat, 5 Dec 2009 05:24:59 +0000, The title was:CORE-800: Easy metadata extract improvements
The author of change fbff918 was asfernandes Sat, 5 Dec 2009 01:08:10 +0000, The title was:Fix Linux build