Virtual columns do not work with CREATE ... SELECT
Bug #607168 reported by
Philip Stoev
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MariaDB |
Fix Released
|
High
|
Igor Babaev | ||
Bug Description
Virtual columns do not work properly with CREATE ... SELECT and likely all other similar constructs:
CREATE TABLE t1 (f1 INTEGER, v1 INTEGER AS (f1) VIRTUAL);
CREATE TABLE t2 AS SELECT v1 FROM t1;
returns this error
1054: Unknown column 'f1' in 'virtual column function'
which is incorrect. My guess is that the server tries to find v1 in t2 instead of t1. It would be interesting what would happen if t2 did have a column named f1.
| Changed in maria: | |
| importance: | Undecided → High |
| Changed in maria: | |
| status: | New → Confirmed |
| assignee: | nobody → Igor Babaev (igorb-seattle) |
| affects: | maria → ariella |
| affects: | ariella → maria |
| Changed in maria: | |
| status: | Confirmed → Fix Committed |
| Changed in maria: | |
| milestone: | none → 5.2 |
| Changed in maria: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
