CUBRID PHP Driver 8.4.0 Release Note

8.4.0.0005

Changed and Enhanced Features:

1. Add two functions, cubrid_pconnect and cubrid_pconnect_with_url, to support the persistent connection like mysql_pconnect
2. Add a form of the url argument in cubrid_connect_with_url function

8.4.0.0004

Changed and Enhanced Features:

1. According to mysql_fetch_field, Add 4 properties(primary_key blob unsigned zerofill) in cubrid_fetch_field

Fixed bugs:

1. Fix a bug about last_connect_id: if applications don't close all the connections, at some point retrieving data from database seems to be successfully but it does not return anything, only a warning message in the error_log that says someting like this: "11 is not a valid CUBRID-Connect resource"

Changed and Enhanced Features:

1. Getting the isolation level value when connectiong to CUBRID will causes less performance on PHP application, so remove it.

Fixed bugs:

1. Fix a bug in cubrid_next_result: new version cci_next_result will reuse the request handle, so do not close it before calling cci_next_result.
2. Fix a bug about life cycle management of PHP resource T_CUBRID_REQUEST: The CCI request on new database connection may be closed when php garbage collector release the resource T_CUBRID_REQUEST on last database connection.

8.4.0.0001

2008 R4.0 Release

This release is a major release. Several new features have been added to this version including auto commit, multiple SQL statements support, named parameter and so on. Accordingly new functions are added, and several bugs have been fixed.

Functionality added:

The following functions have been added:

• cubrid_next_result
• cubrid_set_autocommit
• cubrid_get_autocommit
• cubrid_set_db_parameter

Changed and Enhanced Features:

1. Add named parameter support:
   
   cubrid_bind() supports both positioal and named parameter when binding parameters for SQL statement.
   
   
2. Add multiple SQL statements support:
   
   cubrid_execute() supports multiple SQL statements when the option CUBRID_EXEC_QUERY_ALL is set. The return value of cubrid_execute() is the result of the first query, and you can use cubrid_next_result() to get the result of next query if it is executed successfully.
   
   
3. Add auto commit support:
   
   CUBRID PHP supports auto-commit mode. You can set auto-commit mode when connecting to CUBRID by using cubrid_connect_with_url(). You can also get auto-commit mode of current connection by using cubrid_get_autocommit() and change it by using cubrid_set_autocommit().
   
   
4. Add database parameter setting support:
   
   cubrid_set_db_parameter() can be used to set the database transaction isolation level and lock timeout value.
   
   
5. cubrid_insert_id() returns only one value:
   
   cubrid_insert_id() will not return an array, instead it will return a string representing the ID generated by the AUTO_INCREMENT column which is updated by the previous INSERT query.
   
   CUBRID supports AUTO_INCREMENT for more than one columns in a table. In most cases, there will be a single AUTO_INCREMENT column in a table. If there are multiple AUTO_INCREMENT columns, the cubrid_insert_id() should not be used even if it will return a value.
   
   
6. cubrid_lob_size() return value type changes:
   
   cubrid_lob_size() will return the lob size as a string.

Fixed bugs

1. Fix a bug in cubrid_fetch_object: cubrid_fetch_object can't work with php-5.2.x;
2. Fix a bug in cubrid_put: There may be column name string copy error if the length of column name is more than 4;
3. Fix a bug which may casue memory leak: After calling array_init(return_value), if error occures, it should destroy the array before returning false;
4. Fix a bug about BLOB/CLOB: When inserting LOB data, if the data size is large enough, it will fails. And if the LOB data is in a file, and it is too large to be put into memory, you can bind a file path name when binding the LOB data;
5. Fix a bug about CLOB: When binding data type is CLOB, it will fail when inserting it into CUBRID.