MySQL – ERROR 3105 (HY000) – Generated Column Error

You can use mysqldump and mysql.exe for backup and restoration after installing MariaDB using the sudo yum install mariadb.x86 64 command in your EC2 instance. However, the backup will succeed but the restoration will fail if your database tables have generated columns.

The following error will appear.

ERROR 3105 (HY000) at line 1348: The value specified for generated column ‘EndBalance’ in table ‘tblCustomerBalance’ is not allowed. 

In other words, this issue arises when using MariaDB’s mysqldump with virtual generated columns. Although MySQL only takes DEFAULT as a value for a virtual generated column, MariaDB’s mysqldump appears to dump the generated values.

So the solution is, inorder to accurately dump and restore virtual generated columns on a MySQL server, use mysqldump from MySQL, instead of using MariaDB.

Click here to view the solution if you are receiving this error while using the MySQL version in place of MariaDB.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s