mysql - SQLAlchemy 相交错误

Question

user1 = User(用户名='john')

user2 = User(用户名='jim')

user1.intersect(user2).all() 在使用 MariaDB 时抛出错误，但在使用 SQLite 时不会抛出错误。

错误如下:

sqlalchemy.exc.ProgrammingError: (_mysql_exceptions.ProgrammingError) (1064, "您的 SQL 语法有错误；请检查与您的 MySQL 服务器版本相对应的手册，以了解在 'INTERSECT SELECT user.id 附近使用的正确语法AS user_id, user.username AS user_username, user.email ' 在第 4 行") [SQL: 'SELECT anon_1.user_id AS anon_1_user_id, anon_1.user_username AS anon_1_user_username, anon_1.user_email AS anon_1_user_email, anon_1.user_password AS anon_1_user_password, anon_1.user_first_name AS anon_1_user_first_name、anon_1.user_last_name AS anon_1_user_last_name、anon_1.user_about_me AS anon_1_user_about_me、anon_1.user_last_seen AS anon_1_user_last_seen、anon_1.user_member_since AS anon_1_user_member_since、anon_1.user_last_message_read_time AS an on_1_user_last_message_read_time, anon_1.user_last_request_read_time AS anon_1_user_last_request_read_time\nFROM (SELECT user.id AS user_id, user.用户名 AS user_username、user.email AS user_email、user.password AS user_password、user.first_name AS user_first_name、user.last_name AS user_last_name、user.about_me AS user_about_me、user.last_seen AS user_last_seen、user.member_since AS user_member_since、user.last_message_read_time AS user_last_message_read_time、user.last_request_read_time AS user_last_request_read_time\n来自用户、友谊\nWHERE Friendships.user_id = %s AND Friendships.friend_id = user.id INTERSECT SELECT user.id AS user_id、user.username AS user_username、user.email AS user_email、用户。密码 AS user_password、user.first_name AS user_first_name、user.last_name AS user_last_name、user.about_me AS user_about_me、user.last_seen AS user_last_seen、user.member_since AS user_member_since、user.last_message_read_time AS user_last_message_read_time、user.last_request_read_time AS user_last_request_read_time\nFROM 用户，友谊\nWHERE Friendships.user_id = %s AND Friendships.friend_id = user.id) AS anon_1'] [参数:(1, 2)](此错误的背景位于:http://sqlalche.me/e/f405 )

Answer 1

MySQL 不支持 INTERSECT。 SQLite 确实如此。 MariaDB 自 version 10.3 开始执行.