joins 关联表没有自动对软删除进行过滤

[shangyin2024]

使用join关联查询数据时候发现关联表没有自动过滤掉软删除的数据

代码：

    err := DB.Debug().Model(artistModel).
        Select([]string{"artists.name"}).
        Joins("left join song_artists on artists.id = song_artists.artist_id").
        Where("song_artists.song_id = ?", songID).
        Scan(artistsNameArr).Error

• 期望输出

  SELECT artists.name FROM `artists` left join song_artists on artists.id = song_artists.artist_id WHERE song_artists.song_id = "003dc512121c4dfb898184565b92e8e8" AND `artists`.`deleted_at` IS NULL AND song_artists.`deleted_at` IS NULL 

• 实际输出

  SELECT artists.name FROM `artists` left join song_artists on artists.id = song_artists.artist_id WHERE song_artists.song_id = "003dc512121c4dfb898184565b92e8e8" AND `artists`.`deleted_at` IS NULL