The error occurs because 'row_number' is a reserved keyword in MariaDB, and therefore cannot be used as a column name. SQLAlchemy generates SQL code that includes the column name without quoting it, which leads to a syntax error when MariaDB encounters the reserved keyword. To avoid this error, you should rename the column to something else.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2022-03-23 11:00:00 +0000
Seen: 14 times
Last updated: May 19 '22
What is the method for placing parentheses in column names when creating a table using an SQL query?
What is the issue encountered when attempting to use Spring Batch with MariaDB?
What are the different technology combinations available for LAMP stack?
Why does Mariadb produce an error for a subquery's unknown column, while MySQL runs without issues?
How can I use bash to select rows from a table by referencing another table?
How can I install MariaDB and MySQL on my MacBook Pro?
How can I establish a connection with MariaDB that is running in a Docker container through dbeaver?