Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
MariaDB [test]> create or replace table t1 with system versioning as select 1 as i;
|
ERROR 1364 (HY000): Field 'i' doesn't have a default value
|
|
|
MariaDB [test]> create or replace table t1 (i int) with system versioning as select 1 as i;
|
ERROR 1060 (42S21): Duplicate column name 'i'
|
Without system versioning clause both variants work, of course.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Sergei Golubchik [ serg ] | Aleksey Midenkov [ midenok ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Summary | Unexpected ER_NO_DEFAULT_FOR_FIELD or ER_DUP_FIELDNAME upon CREATE TABLE .. WITH SYSTEM VERSIONING AS SELECT ... | Unexpected errors upon CREATE TABLE .. WITH SYSTEM VERSIONING AS SELECT ... |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Assignee | Aleksey Midenkov [ midenok ] | Sergei Golubchik [ serg ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Labels | contribution foundation |
| Description |
{code:sql}
MariaDB [test]> create or replace table t1 with system versioning as select 1 as i; ERROR 1364 (HY000): Field 'i' doesn't have a default value MariaDB [test]> create or replace table t1 (i int) with system versioning as select 1 as i; ERROR 1060 (42S21): Duplicate column name 'i' {code} Without system versioning clause both variants work, of course. |
{noformatl}
MariaDB [test]> create or replace table t1 with system versioning as select 1 as i; ERROR 1364 (HY000): Field 'i' doesn't have a default value MariaDB [test]> create or replace table t1 (i int) with system versioning as select 1 as i; ERROR 1060 (42S21): Duplicate column name 'i' {noformat} Without system versioning clause both variants work, of course. |
| Description |
{noformatl}
MariaDB [test]> create or replace table t1 with system versioning as select 1 as i; ERROR 1364 (HY000): Field 'i' doesn't have a default value MariaDB [test]> create or replace table t1 (i int) with system versioning as select 1 as i; ERROR 1060 (42S21): Duplicate column name 'i' {noformat} Without system versioning clause both variants work, of course. |
{noformat}
MariaDB [test]> create or replace table t1 with system versioning as select 1 as i; ERROR 1364 (HY000): Field 'i' doesn't have a default value MariaDB [test]> create or replace table t1 (i int) with system versioning as select 1 as i; ERROR 1060 (42S21): Duplicate column name 'i' {noformat} Without system versioning clause both variants work, of course. |
| Labels | contribution foundation |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.3.6 [ 23003 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 85744 ] | MariaDB v4 [ 153864 ] |