RELEASE 2.0.4a - 2006-03-07 - Fix on picoserv, Windows version only RELEASE 2.0.4 - 2006-03-02 - Fix bug on standard authentication - Fix client: closesocket() called when connection fails RELEASE 2.0.3a - 2006-02-08 - Fix client: closesocket() called when connection fails RELEASE 2.0.3 - 2006-02-06 - Fix on SQLFreeConnection on client side RELEASE 2.0.2 - 2004-09-09 - Fix on SQLExtendedFetch (odbccom.c, message.c, odbcserv.c) - Added addiction and subtraction with TIMESTAMP - Added function NOW RELEASE 2.0.1 - 2004-01-13 - Fix on ALTER TABLE with SERIAL attributes - Fix on picosqlnet e picoODBC for Big Endian CPU RELEASE 2.0 - 2003-12-01 - Fix on ALTER TABLE (SERIAL, BLOB) - Fix on exporting tables from ACCESS (memo NULL) - Fix on picosqlnet on dates in exceptional cases: CORBA underflow - SERIAL type accepts a predefined value in INSERT statement RELEASE 2.0beta - 2003-09-18 - added stored procedures in C language - augmented precision of decimal number to 32 digits - improved pIcheck analysis - added SysUser feature for permissions - added SELECT SERIAL syntax to get the last inserted serial value RELEASE 1.5.2 - 2003-07-09 - Minor bug fix on ALTER TABLE, CREATE INDEX - Improved performances on ALTER TABLE, DROP TABLE, DROP VIEW - Fix on alias name after COUNT(*) - Accepted NOT NULL syntax - Accepted LONGVARCHAR as CLOB RELEASE 1.5.1 - 2003-06-17 - Fix on ALTER TABLE RELEASE 1.5 - 2003-06-04 - Fix on DATE and TIME order in ORDER BY clause (regression from 1.3beta) RELEASE 1.5beta - 2003-05-06 - added the positional update - added the positional delete - added the following ODBC API * SQLDescribeParam * SQLPrimaryKeys * SQLMoreResults - PHP compilation: added the following dummy ODBC API * SQLDataSources (DM) * SQLColumnPrivileges * SQLForeignKeys * SQLProcedureColumns * SQLProcedures * SQLTablePrivileges RELEASE 1.4 - 2003-05-06 - no changes RELEASE 1.4beta - 2003-04-03 - added SERIAL data type (autoincrementing integer) - added LIMIT and OFFSET clauses to the SELECT statement - added functions YEAR, MONTH, DAYOFMONTH, HOUR, MINUTE, SECOND and MILLISECOND RELEASE 1.3 - 2003-04-03 - fix on SELECT ... FOR UPDATE RELEASE 1.3beta - 2003-03-07 - added ALTER TABLE [RENAME|ADD|DROP] - added TIME data type - compilaton on ARM Zaurus RELEASE 1.2 - 2003-02-07 - no changes RELEASE 1.2beta - 2003-02-05 - the views consisting of only one table now are updatable - added the WITH CHECK OPTION clause to the CREATE VIEW statement - added the REPLACE statement, that is similar to the INSERT statement except that if an old record in the table has the same value as a new record on a UNIQUE index or PRIMARY KEY, the old record is fully replaced. RELEASE 1.1.1 - 2003-01-14 - bug fix on CREATE VIEW xxxx (n1, n2 ...) AS ...: picoSQL forgot n1, n2 etc. RELEASE 1.1 - 2003-01-10 - bug fix on CREATE VIEW and DROP VIEW statements - expression evaluation in UPDATE statement ('set a = a + 1' now work) - emulated advisory lock on Windows, so it is allowed to read locked rows RELEASE 1.1beta - 2002-11-26 - added CREATE VIEW and DROP VIEW statements RELEASE 1.0.1 - 2002-10-29 - comparison between string and number allowed in WHERE clause - PRIMARY KEY clause supported in CREATE TABLE statement - INT type supported RELEASE 1.0 - 2002-10-07 - NULL value is now supported on BLOB and CLOB fields. - Better optimization on descending sort. RELEASE 1.0beta5 - 2002-07-16 - fix on jdbc driver: DatabaseMetaData.getColumns() and null objects in PreparedStatement.setObject; RELEASE 1.0beta4 - 2002-07-11 - fix bug when an ORDER BY clause with some BLOB attribute was specified. RELEASE 1.0beta3 - 2002-07-09 - improved concurrency on WinNT systems. RELEASE 1.0beta2 - 2002-06-27 - fix bug when a condition with NULL (ex. A IS NULL) there was in WHERE clause. RELEASE 1.0beta - 2002-05-13 - first release