Bug related to SoftDelete

[nadar]

I am not sure yet, just saw the error, have to research. maybe related to #542

Update with potential Fix

In order to fix querys with SoftDeleteTrait like this:

UserOnline::find()
->select(['lock_pk', 'lock_table', 'last_timestamp', 'u.firstname', 'u.lastname', 'u.id'])
->where(['!=', 'u.id', $userId])
->joinWith('user as u')
->asArray()
->all()

use instead the full table name in the field selection (and where condition)

UserOnline::find()
->select(['lock_pk', 'lock_table', 'last_timestamp', 'firstname', 'lastname', 'admin_user.id'])
->where(['!=', 'admin_user.id', $userId])
->joinWith('user')
->asArray()
->all()

[nadar]

@boehsermoe if the table name is aliased your proposed solution won't work. Maybe we should use $query["{{%$field}}"] = (is_array($value)) ? $value[1] : !$value; instead which is the yii table prefix syntax

I have prepared a PR with the test situation which is failing #548

[boehsermoe]

Looks like a bigger problem 😕 yiisoft/active-record#33