Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
10.5.5, 10.6.0
Description
When INSERT ... RETURNING fails, it sends metadata and afterwards error packet:
rc= mysql_query(mysql, "CREATE TEMPORARY TABLE t1 (a int not null auto_increment primary key, b json)");
|
check_mysql_rc(rc, mysql);
|
|
|
rc= mysql_query(mysql, "INSERT INTO t1 (a,b) VALUES (NULL, '[incorrect json]') RETURNING a");
|
check_mysql_rc(rc, mysql); /* <- this should fail */
|
|
|
result= mysql_store_result(mysql);
|
mysql_free_result(result);
|
|
|
diag("Error: %s", mysql_error(mysql));
|
Output:
Error: CONSTRAINT `t1.b` failed for `test`.`t1`
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Issue Type | Task [ 3 ] | Bug [ 1 ] |
| Affects Version/s | 10.6.0 [ 24431 ] |
| Affects Version/s | 10.5.5 [ 24423 ] |
| Labels | django |
| Component/s | Data Manipulation - Insert [ 10101 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Assignee | Rucha Deodhar [ rucha174 ] |
| Assignee | Rucha Deodhar [ rucha174 ] | Oleksandr Byelkin [ sanja ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Rucha Deodhar [ rucha174 ] |
| Fix Version/s | 10.5.10 [ 25204 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Not a Bug [ 6 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Resolution | Not a Bug [ 6 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Resolution | Not a Bug [ 6 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 113686 ] | MariaDB v4 [ 158384 ] |