Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.3, 13.0
-
None
-
Can result in unexpected behaviour
Description
Test case
CREATE TEMPORARY TABLE t1 (a INT, v INT AS (a+1) VIRTUAL) ; |
INSERT INTO t1 (a, v) VALUES (1, 99); |
SELECT a, v, COUNT(*) AS t1_rows FROM t1; |
DROP TEMPORARY TABLE t1; |
10.11.19-opt>CREATE TEMPORARY TABLE t1 (a INT, v INT AS (a+1) VIRTUAL) ; |
Query OK, 0 rows affected (0.001 sec) |
|
|
10.11.19-opt>INSERT INTO t1 (a, v) VALUES (1, 99); |
Query OK, 1 row affected (0.000 sec)
|
|
|
10.11.19-opt>SELECT a, v, COUNT(*) AS t1_rows FROM t1; |
+------+------+---------+ |
| a | v | t1_rows |
|
+------+------+---------+ |
| 1 | 2 | 1 |
|
+------+------+---------+ |
1 row in set (0.000 sec) |
|
|
10.11.19-opt>DROP TEMPORARY TABLE t1; |
Query OK, 0 rows affected (0.000 sec) |
|
|
10.11.19-opt>
|
INSERT statement fails when executed on the persistent table
10.11.19-opt>CREATE TABLE bt (a INT, v INT AS (a+1) VIRTUAL); |
Query OK, 0 rows affected (0.032 sec) |
|
|
10.11.19-opt>INSERT INTO bt (a, v) VALUES (1, 99); |
ERROR 1906 (HY000): The value specified for generated column 'v' in table 'bt' has been ignored |
10.11.19-opt>
|