Problem with joins

[dawidof]

Does not create proper sql when paranoid set on joined table

[mvz]

Hi @dawidof can you please provide a way to reproduce this problem? At first glance, the SQL seems fine, but without the code it's hard to tell.

[dawidof]

Thanks @mvz, yeah you are right, it seems like error in my code.

But I've got another problem with using with_deleted on joined table

[mvz]

@dawidof I'll also need some code to reproduce this. I can't tell from your screen shot what you think is wrong.

[dawidof]

@mvz I've not tested, but I think this code would be enough

class Provider  < ApplicationRecord
  has_many :licences, dependent: :destroy
end

class Licence < ApplicationRecord
  acts_as_paranoid
  belongs_to :provider
end

[mvz]

Can you please also say

• what you're trying to do
• what happens that you didn't expect
• what you expected to happen instead

[dawidof]

E.g. I'm trying to get providers with active and not dependent on deleted_at column licences.

on Provider.joins(:licences).with_deleted.active.count
it throws an error NoMethodError (undefined method 'with_deleted' for #<Provider::ActiveRecord_Relation:0x00007fc7b3a37230>)

I am expecting to get collection with providers, starting AR query request with Provider model

[mvz]

If you start from Provider you only get scopes that are defined in Provider. Since Provider is not paranoid, it does not provide the with_deleted scope. Even after .joins(:licenses), you still will not get scopes defined in License.

There's an open issue about the ability to specify that joined relations should include deleted records here: #110.