[Maria-developers] [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

Hi! Peter == Peter Laursen peter_laur...@webyog.com writes: Peter Refer http://kb.askmonty.org/v/virtual-columns - the example Peter CREATE TABLE table1 ( Peter a INT NOT NULL, Peter b VARCHAR(32), Peter c INT AS (a MOD 10) virtual, Peter d VARCHAR(5) AS (LEFT(b,5)) persistent); Peter now

Re: [Maria-developers] [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

Hi! Peter == Peter Laursen peter_laur...@webyog.com writes: Peter I have a few more points to consider: Peter CREATE TABLE table1 (as before); Peter SET SQL_MODE = 'strict_all_tables'; Peter INSERT INTO `test`.`table1`(`a`,`b`,`c`,`d`) VALUES ( '1','a',NULL,NULL); -- Peter success Peter

Re: [Maria-developers] [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

I have a few more points to consider: CREATE TABLE table1 (as before); SET SQL_MODE = 'strict_all_tables'; INSERT INTO `test`.`table1`(`a`,`b`,`c`,`d`) VALUES ( '1','a',NULL,NULL); -- success SHOW WARNINGS -- empty set -- this is actually good, even a little inconsistent with what comes next.

Re: [Maria-developers] [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

Hi Peter, all From: Peter Laursen peter_laur...@webyog.com Refer http://kb.askmonty.org/v/virtual-columns - the example CREATE TABLE table1 ( a INT NOT NULL, b VARCHAR(32), c INT AS (a MOD 10) virtual, d VARCHAR(5) AS (LEFT(b,5)) persistent); now SHOW FULL FIELDS FROM table1;