Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
Description
Default values are not supported by prepared statements. This slows down batch operations since you need to retrieve the default value for a column from information_schema:
mysqll> CREATE TABLE t1 (a int default 2);
|
mysql_stmt_prepare(stmt, "INSERT INTO t1 VALUES (?)");
|
 |
for (i=0; i < numRows; i++)
|
{
|
if (RowPtr[i] == SQL_COLUMN_IGNORE)
|
{
|
/* since there is no MYSQL_TYPE_DEFAULT we need to retrieve
|
the default value from information_schema. What a pain! */
|
} else
|
{
|
bind[0].buffer_type= MYSQL_TYPE_LONG;
|
bind{0].buffer= &RowValues[i];
|
}
|
mysql_stmt_execute(stmt);
|
}
|
Attachments
Issue Links
- relates to
-
MDEV-9114 Bulk operations (Array binding)
- Closed