RQG: Virtual persistent columns not computed properly for default NULL values

Here is another example:

--disable_abort_on_error
DROP TABLE t1;
DROP TABLE t2;

CREATE TABLE t1 ( f1 CHAR(32) NOT NULL, v1 INT AS ( f1 ) PERSISTENT );
INSERT INTO t1 () VALUES ();

CREATE TABLE t2 ( f1 CHAR(32) NOT NULL, v1 INT AS ( f1 ) VIRTUAL );
INSERT INTO t2 () VALUES ();

SELECT f1, v1 FROM t1;
SELECT f1, v1 FROM t2;

What happens here is that if you use an INSERT that does not explicitly list all the columns in the table, some of the columns will get the default value. If such default values are then used in a virtual column computation, the result from the computation will be incorrect.

If you use an INSERT form where all fields are specified and thus no defaults kick in, virtual columns are computed correctly.