[#MDEV-7655] SHOW CREATE TABLE returns invalid DDL when using virtual columns along with a table collation

MariaDB [tmp]> CREATE TABLE vcol_test

         v_col1 varchar(255) as (col1) persistent,

         col1 varchar(50)

     ) COLLATE=latin1_general_ci;

Query OK, 0 rows affected (0.05 sec)

MariaDB [tmp]> SHOW CREATE TABLE vcol_test;

+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table     | Create Table                                                                                                                                                                                                                    |

+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| vcol_test | CREATE TABLE `vcol_test` (

  `v_col1` varchar(255) COLLATE latin1_general_ci AS (col1) PERSISTENT,

  `col1` varchar(50) COLLATE latin1_general_ci DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci |

+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [tmp]> DROP TABLE vcol_test;

Query OK, 0 rows affected (0.03 sec)

MariaDB [tmp]> CREATE TABLE `vcol_test` (

    ->   `v_col1` varchar(255) COLLATE latin1_general_ci AS (col1) PERSISTENT,

    ->   `col1` varchar(50) COLLATE latin1_general_ci DEFAULT NULL

    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS (col1) PERSISTENT,

  `col1` varchar(50) COLLATE latin1_general_ci DEFAULT NUL' at line 2

[MDEV-7655] SHOW CREATE TABLE returns invalid DDL when using virtual columns along with a table collation Created: 2015-03-02 Updated: 2015-12-12 Resolved: 2015-12-12
Status:	Closed
Project:	MariaDB Server
Component/s:	Virtual Columns
Affects Version/s:	10.0.17
Fix Version/s:	5.5.48, 10.0.23, 10.1.10

[MDEV-7655] SHOW CREATE TABLE returns invalid DDL when using virtual columns along with a table collation Created: 2015-03-02 Updated: 2015-12-12 Resolved: 2015-12-12