Troubleshooting MariaDB-specific error codes From Error 1900 to 1909

SQLServerF1

MariaDB ERROR 1900
ER_VCOL_BASED_ON_VCOL
A computed column cannot be based on a computed column
MariaDB ERROR 1046
No database selected
MariaDB ERROR 1901
ER_VIRTUAL_COLUMN_FUNCTION_IS_NOT_ALLOWED
Function or expression is not allowed for column ‘%s’
MariaDB ERROR 1046
No database selected
MariaDB ERROR 1902
ER_DATA_CONVERSION_ERROR_FOR_VIRTUAL_COLUMN
Generated value for computed column ‘%s’ cannot be converted to type ‘%s’

MariaDB ERROR 1046
No database selected
MariaDB ERROR 1903
ER_PRIMARY_KEY_BASED_ON_VIRTUAL_COLUMN
Primary key cannot be defined upon a computed column
MariaDB ERROR 1046
No database selected
MariaDB ERROR 1904
ER_KEY_BASED_ON_GENERATED_VIRTUAL_COLUMN
Key/Index cannot be defined on a non-stored computed column
MariaDB ERROR 1046
No database selected

MariaDB ERROR 1905
ER_WRONG_FK_OPTION_FOR_VIRTUAL_COLUMN
Cannot define foreign key with %s clause on a computed column
MariaDB ERROR 1046
No database selected
MariaDB ERROR 1906
ER_WARNING_NON_DEFAULT_VALUE_FOR_VIRTUAL_COLUMN
The value specified for computed column ‘%s’ in table ‘%s’ ignored
MariaDB ERROR 1046
No database selected
MariaDB ERROR 1907
ER_UNSUPPORTED_ACTION_ON_VIRTUAL_COLUMN
This is not yet supported for computed columns
MariaDB ERROR 1046
No database selected
MariaDB ERROR 1908
ER_CONST_EXPR_IN_VCOL
Constant expression in computed column function is not allowed
MariaDB ERROR 1046
No database selected
MariaDB ERROR 1909
ER_ROW_EXPR_FOR_VCOL
Expression for computed column cannot return a row

Above are list of MariaDB-specific error codes or Error Messages or Warnings from Error 1900 to 1909 received while performing certain operation against MariaDB related products.

What are MariaDB-specific error code Messages?

MariaDB-specific error codes are a set of error codes for use by all MariaDB products. Every MariaDB-specific error message returned by MariaDB, is self explanatory and contains the object name in cases where required.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about MariaDB error code Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *