Top Level :: Database

Package Information: MDB2_Driver_sqlite 0.2.0

Show All Changelogs
» Version » Information
1.5.0b1 2008-03-15     beta
1.5.0a2 2007-12-06     alpha
1.5.0a1 2007-10-28     alpha
1.4.1 2007-05-03     stable
1.4.0 2007-03-13     stable
1.3.0 2006-11-03     stable
1.2.1 2006-08-21     stable
1.2.0 2006-07-23     stable
1.1.0 2006-06-15     stable
1.0.2 2006-05-14     stable
1.0.1 2006-04-16     stable
1.0.0 2006-02-09     stable
0.2.4 2006-02-05     beta
0.2.3 2006-01-13     beta
0.2.2 2005-12-30     beta
0.2.1 2005-12-28     beta
0.2.0Download

Release date: 2005-12-21 11:26 UTC
Release state: beta

Changelog:

- do not fix case in listUsers()
- unified case fixing in the list*() methods
- support sorting order in createIndex()
- tweaked lob and text handling in mapNativeDatatype()
- fixed getTableFieldDefinition()
- use getConnection() to access connection property
- split index and constraint handling
- quote identifiers where possible inside the manager methods depending on
the new 'quote_identifier' option (defaults to off)
- refactored get*Declaration() methods to use getTypeDeclaration()
- setting in_transaction to false on disconnect
- added new Function modules to handle difference in SQL functions
- force rollback() with open transactions on disconnect
- added alterTable() (only does table name change and column adding)
- escape floats to make sure they do not contain evil characters (bug #5608)
- split off manipulation queries into exec() method from the query() method *BC BREAK*
- only if result_types is set to false in prepare() method the query will be
handled as a DML statement *BC BREAK*
- use a proper default value if a field is set to not null in _getDeclaration*() (bug #5930)
- added ability to determine unsigned in mapNativeDatatype()
(only really implemented in the mysql(i) drivers) (bug #6054)
- use lastInsertID() method in nextID()
- added getServerVersion()
- unified array structure in mapNativeDatatype() *BC BREAK*
- added 'mdbtype' to tableInfo() output that is generated from mapNativeDatatype()
- changed 'len' to 'length' in tableInfo() output *BC BREAK*

open todo items:
- a number of the manager test cases fail because sqlite does not support adding
primary keys to existing tables
- the alter table test fails because this is unsupported in sqlite2
- the test replace test fails because sqlite reports an incorrect affected rows
value when no existing data was replaced
- the testnow and testsubstring tests fail

Dependencies:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.0b1 or newer
  • PEAR Package: MDB2 2.0.0RC1 or newer
  • PHP Extension: sqlite
0.1.0 2005-06-08     beta