[GSOC]Firebird Integration Weekly Update 08

[Andrzej Hunt]

Hello all,

The week's progress:

- Made all columns displayable when viewing a column in Base.
- Implemented get{Column|Table}Privileges.
- Implemented some of getTypeInfo.
- Fixed the registry details which seemingly got messed up when
  I changed the driver build.
- Add the correct authentication flags for firebird to not pay
  attention to the user when using embedded files (meaning 
  files can actually be shared amongst users now).
- Implemented some more of DatabaseMetaData.
- Implemented getPrimaryKeys().
- Added some SQL Identifier sanitisation: at the moment
  firebird returns identifiers as being 93 characters long
  (the correct length is <=31), these worked fine with SELECT
  statements but doesn't for DROP and ALTER statements where
  we need to cut the length down. I'm still trying to find
  why this happens.
- Implemented Embedded DB selector allowing selecting between
  Firebird and HSQLDB (and any further embedded dbs should
  anyone implement one).

Currently the driver allows creation and dropping of tables and columns
therein, and specifying most datatypes. There is still a problem whereby
dropped columns don't disappear (but appear empty) when viewing the
entire table (i.e. using SELECT *), I'm still figuring out why that is
(running the same sequence of commands via flamerobin doesn't have any
such issues, so it's possibly something to do with the transaction
settings or other options used in LO).

Next week I'll try and finish off most of PreparedStatement (setting
parameters), and then actually start adding and implementing various
sdbcx interfaces which should allow for adding of data to the database
(via the GUI).

I've also been looking at the ICU issues in more detail, it looks like
they should be quite easy to deal with (based on the debian scripts)--
I'll probably wait for a few weeks to do this though (i.e. until I have
my new system set up with enough drive space to have builds with
different ICU version in parallel for testing how things actually work).

Cheers,

	Andrzej