cursor_execute_doesnt_return_anything_in_django_but_it_works_on_mysq

Question

所以我有一个查询，我想在Django中使用光标.执行公司名称：

def get_user_history(user_id):
with connection.cursor() as cursor:
    cursor.execute("""
        SET @user_id = %s;
        SELECT * FROM (
            SELECT channel_id, NULL as article_id, NULL as comment_id,
                NULL as friend_id, NULL as followed_channel_id,
                NULL as liked_article_id, created_at
                FROM channel WHERE user_id = @user_id
            UNION ALL
            SELECT channel_id, article_id, NULL as comment_id,
                NULL as friend_id, NULL as followed_channel_id,
                NULL as liked_article_id, created_at
                FROM article WHERE channel_id in
                    (SELECT channel_id from channel where user_id = @user_id)
            UNION ALL
            SELECT NULL as channel_id, article_id, comment_id,
                NULL as friend_id, NULL as followed_channel_id,
                NULL as liked_article_id, created_at
                FROM comment WHERE user_id = @user_id
            UNION ALL
            SELECT NULL as channel_id, NULL as article_id, NULL as comment_id,
                friend_id, NULL as followed_channel_id,
                NULL as liked_article_id, created_at
                FROM user_friends WHERE user_id = @user_id
            UNION ALL
            SELECT NULL as channel_id, NULL as article_id, NULL as comment_id,
                NULL as friend_id, channel_id as followed_channel_id,
                NULL as liked_article_id, created_at
                FROM user_follows_channel WHERE user_id = @user_id
            UNION ALL
            SELECT NULL as channel_id, NULL as article_id, NULL as comment_id,
                NULL as friend_id, NULL as followed_channel_id,
                article_id as liked_article_id, created_at
                FROM user_likes_article WHERE user_id = @user_id
            ) T1
        ORDER BY created_at;
        """, [user_id])
    if cursor.fetchall():
        return dictfetchall(cursor)
    else:
        return {'error': 'history is empty'}

但是它返回一个空的object[]，但是当我在mariaDB中运行与

^{pr2}$

它返回我想要的正确结果：

+------------+------------+------------+-----------+---------------------+------------------+---------------------+

    | channel_id | article_id | comment_id | friend_id | followed_channel_id | liked_article_id | created_at          |
    +------------+------------+------------+-----------+---------------------+------------------+---------------------+
    |          3 |       NULL |       NULL |      NULL |                NULL |             NULL | 2017-12-04 01:44:35 |
    |          3 |          5 |       NULL |      NULL |                NULL |             NULL | 2017-12-04 15:40:23 |
    |          3 |          6 |       NULL |      NULL |                NULL |             NULL | 2017-12-04 16:34:57 |
    +------------+------------+------------+-----------+---------------------+------------------+---------------------+

我完全被难住了。在