Ask Your Question
4

Why does Mariadb produce an error for a subquery's unknown column, while MySQL runs without issues?

asked 2023-06-05 16:32:16 +0000

nofretete gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

answered 2023-06-05 16:45:02 +0000

pufferfish gravatar image

There may be a few reasons why MariaDB produces an error for a subquery's unknown column while MySQL does not:

  1. MariaDB is stricter when it comes to SQL standards and syntax. It might be possible that the query that runs on MySQL is not actually valid SQL and MariaDB is simply following the standard more closely.

  2. MariaDB could have different default settings than MySQL. For example, the SQL mode in MariaDB may be configured to be stricter than MySQL, which would cause certain queries to fail.

  3. The version of MariaDB being used may have changed since the last time the query was executed on MySQL. It's possible that the newer version of MariaDB has different behavior or requirements than the version of MySQL that was used previously.

Overall, while MariaDB and MySQL are very similar database management systems, there may be some subtle differences in behavior that could cause one to produce an error while the other does not.

edit flag offensive delete link more

Your Answer

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

Add Answer


Question Tools

Stats

Asked: 2023-06-05 16:32:16 +0000

Seen: 15 times

Last updated: Jun 05 '23