Skip to content

查询数据重复 #198

Closed
Closed

Description

@zhengdaone

环境信息

  • 系统:
  • JDK:
  • 数据库:
  • APIJSON:

问题描述
https://vincentcheng.github.io/apijson-doc/zh/all.html#功能符
老哥,按照你提供的文档,查询出来的数据全是重复的。没看到官方有什么解决方式,需要自己处理吗?
image

错误信息

Activity

  1. TommyLemon commented on Feb 2, 2021

    @TommyLemon
    Member

    Moment 和 Comment 是一对多,用 LEFF JOIN 本身主表 Moment 就会有重复
    image

    APIJSON 对这种查询有副表 Comment 数据重复 bug (获取缓存问题)
    image

    建议一对多不要用 LEFT JOIN,LEFT JOIN 可以改为不用 JOIN
    image

    或用 APP JOIN
    image

    如果一定要用,对主表 GROUP BY 去重也行
    image

  2. TommyLemon commented on Feb 2, 2021

    @TommyLemon
    Member
  3. zhengdaone commented on Feb 2, 2021

    @zhengdaone
    Author

    谢谢回复。

  4. TommyLemon commented on Feb 1, 2025

    @TommyLemon
    Member

    @zhengdaone 已解决 SQL JOIN 在一对多或多对多时返回单独查询的重复副表数据,而不是 SQL 结果集里的副表数据。
    (之前必须用 DISTINCT / ORDER BY 去重 或 调换主副表顺序(有的还需要把 LEFT JOIN 改为 RIGHT JOIN) 来解决,但可能结果不符合某些需求)
    2f5d947

    Image

    https://apijson.cn/api/?send=true&type=JSON&url=http%3A%2F%2Flocalhost%3A8080%2Fget&json={%22[]%22:{%22count%22:3,%22join%22:%22%3C%2FComment%22,%22User%22:{%22@column%22:%22id%2Cname%22},%22Comment%22:{%22@column%22:%22id%2CuserId%22,%22userId@%22:%22%2FUser%2Fid%22}},%22@explain%22:true}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions