comdesk

Results 4 comments of comdesk

pymysql.err.OperationalError: (1903, 'Primary key cannot be defined upon a generated column')

Thanks for the answer, I look forward to using it in MariaDB!

pymysql.err.OperationalError: (1903, 'Primary key cannot be defined upon a generated column')

> Released support in version 2.0.12 for MariaDB >= 10.7. Please try and let me know if you encounter any issues. Thanks for the support. But, When I run the...

pymysql.err.OperationalError: (1903, 'Primary key cannot be defined upon a generated column')

The collation for the 4 tables looks like the following photo. ![Image](https://github.com/user-attachments/assets/e87570ad-4a98-4781-86cd-f83150ffa006) The version of my MariaDB is `mariadb Ver 15.1 Distrib 10.11.2-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper`. I'm...

pymysql.err.OperationalError: (1903, 'Primary key cannot be defined upon a generated column')

The result of running the sql query: "SHOW VARIABLES LIKE 'collation_server';" is shown in the following picture. ![Image](https://github.com/user-attachments/assets/fd43e20c-a842-4113-8c8e-bf3aef0fb448) The result of running the sql query: "SELECT SCHEMA_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA...