CUBRID Perl Driver 8.4.0 Release Note

Below you can find the revision history for DBD::cubrid.

DBD-cubrid 8.4.0.0002

This version was released on January 20, 2012. After a vigorous testing, this release provides many bug fixes and several new features such as lob object related functions.

ENHANCEMENTS

• Added cubrid_lob_get: This method can get a column of the lob object from CUBRID database.
• Added cubrid_lob_export: This method will export a lob object as a file.
• Added cubrid_lob_import: This method will import a file in CUBRID database.
• Added cubrid_lob_close: This method will close the lob object that cubrid_lob_get gets.
• Added type_info_all/type_info: APIS-63
  
  
• Implemented foreign_key_info: we just gave an interface not implemented it in last version.
• Supported BLOB/CLOB in bind_param

BUG FIXES

1. APIS-54 - Fixed the bug that Data only be inserted into fixed database
2. APIS-55 - Fixed the bug that connection method isn't correct
3. APIS-60 - Fixed the bug that result of "SELECT 4 + '5.2'" will be round
4. APIS-61 - Fixed the bug that return value of double type isn't correct
5. APIS-62 - Fixed the bug that return values of column_info isn't in proper order
6. APIS-64 - Fixed the bug that return value of DATA_TYPE isn't correct
7. APIS-70 - Fixed the bug that return values of nullable are not correct
8. APIS-71 - Fixed the bug that method of tables() can't return values
9. APIS-73 - Fixed the bug that get_info(18) couldn't return database version
10. APIS-78 - Fixed the bug that error doesn't appear when bound an error type to cubrid_lob_import method
11. APIS-84 - Fixed the bug that table_info didn't report an error when the parameter was wrong
12. APIS-86 - Fixed the bug that get_info can't support passing SQL_IDENTIFIER_QUOTE_CHAR parameter
13. APIS-86 - Fixed the bug that error will appear when calling cubrid_lob_import method 1019 times

DBD-cubrid 8.4.0

First public release of DBD::cubrid module on November 15, 2011. This version provides the basic functionality to access the CUBRID database server. The following is a list of supported functions.

Driver Handle Methods:

• connect(): Establishes a database connection

Database Handle Methods:

• prepare(): Prepares a statement for later execution and returns a reference to a statement handle object.
• commit(): Commit (make permanent) the most recent series of database changes if the database supports transactions and AutoCommit is off.
• rollback(): Rollback (undo) the most recent series of uncommitted database changes if the database supports transactions and AutoCommit is off.
• disconnect(): Disconnects the database from the database handle.
• ping(): Check whether the database server is still running and the connection to it is still working.
• last_insert_id(): Returns a value identifying the row just inserted
• do(): Prepare and execute a single statement.
• selectrow_array(): This utility method combines "prepare", "execute" and "fetchrow_array" into a single call.
• selectrow_arrayref(): This utility method combines "prepare", "execute" and "fetchrow_arrayref" into a single call.
• selectrow_hashref(): This utility method combines "prepare", "execute" and "fetchrow_arrayref" into a single call.
• selectall_arrayref(): This utility method combines "prepare", "execute" and "fetchrow_arrayref" into a single call.
• selectall_hashref(): This utility method combines "prepare", "execute" and "fetchrow_arrayref" into a single call.
• selectcol_arrayref(): This utility method combines "prepare", "execute", and fetching one column from all the rows, into a single call.
• table_info(): Returns an active statement handle that can be used to fetch information about tables and views that exist in the database.
• tables(): Simple interface to table_info(), returns a list of matching table names.
• column_info(): Returns an active statement handle that can be used to fetch information about columns in specified tables.
• primary_key_info(): Returns an active statement handle that can be used to fetch information about columns that make up the primary key for a table.
• primary_key(): Simple interface to the primary_key_info() method. Returns a list of the column names that comprise the primary key of the specified table. The list is in primary key column sequence order.
• foreign_key_info(): Returns an active statement handle that can be used to fetch information about foreign keys in and/or referencing the specified table(s).
• get_info(): Returns information about the implementation, i.e. driver and data source capabilities, restrictions etc.

Database Handle Attributes:

• AutoCommit: Type: Boolean. If true, then database changes cannot be rolled-back (undone). If false, then database changes automatically occur within a "transaction", which must either be committed or rolled back using the commit or rollback methods.
• Statement: Type: String, read-only. Returns the statement string passed to the most recent "prepare" or "do" method called in this database handle, even if that method failed.

Statement Handle Methods:

• bind_param(): Bind a param to a placeholder embedded in the prepared statement.
• bind_param_array(): Bind an array of values to a placeholder embedded in the prepared statement.
• execute(): Perform whatever processing is necessary to execute the prepared statement.
• execute_array(): Execute the prepared statement once for each parameter tuple
• fetchrow_arrayref(): Fetches the next row of data and returns a reference to an array holding the field values.
• fetchrow_array(): An alternative to fetchrow_arrayref. Fetches the next row of data and returns it as a list containing the field values.
• fetchrow_hashref(): An alternative to fetchrow_arrayref. Fetches the next row of data and returns it as a reference to a hash containing field name and field value pairs.
• fetchall_arrayref(): Fetches all the data to be returned from a prepared and executed statement handle.It returns a reference to an array that contains one reference per row.
• fetchall_hashref(): Fetches all the data to be returned from a prepared and executed statement handle.It returns a hash containing a key for each distinct value of the column that was fetched.

Statement Handle Attributes

• rows: Returns the number of rows affected by the last row affecting command, or -1 if the number of rows is not known or not available.
• Statement: Type: String, read-only. Returns the statement string passed to the most recent "prepare" or "do" method called in this database handle, even if that method failed.
• NUM_OF_FIELDS: Type: integer, read-only. Number of fields (columns) in the data the prepared statement may return.
• NUM_OF_PARAMS: Type: integer, read-only. The number of parameters (placeholders) in the prepared statement.
• NAME: Type: array-ref, read-only. Returns a reference to an array of field names for each column.
• TYPE: Type: array-ref, read-only. Returns a reference to an array of integer values for each column. The value indicates the data type of the corresponding column.
• PRECISION: Type: array-ref, read-only. Returns a reference to an array of integer values for each column.
• SCALE: Type: array-ref, read-only. Returns a reference to an array of integer values for each column.
• NULLABLE: Type: array-ref, read-only. Returns a reference to an array indicating the possibility of each column returning a null.