You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The following query does not returns correct rows :
select count(*)
from systemuser
inner join Audit on systemuserid = userid
where systemuserid='...'
I take the systemuserid of a user.
So I find 1 user in systemuser.
This user have 183 rows in audit table.
So when we are making an inner join between this 2 datasets, I except to have 183 rows.
Instead, we have 1234874 rows.
Note that 1234874 is also the number of rows of Audit table...
Regards
Sybaris
The text was updated successfully, but these errors were encountered:
sybaris
changed the title
Inner join does not returns expected result...
Inner join with audit does not returns expected result...
Jun 18, 2024
Thanks for the details. It looks like the server is interpreting the inner joins as outer joins. With some more testing I've found some more attributes that it doesn't seem to support filtering on either, listing them here for my reference to fix shortly:
attributemask
userid & callinguserid (with eq-userid and ne-userid conditions)
Hi
The following query does not returns correct rows :
I take the systemuserid of a user.
So I find 1 user in systemuser.
This user have 183 rows in audit table.
So when we are making an inner join between this 2 datasets, I except to have 183 rows.
Instead, we have 1234874 rows.
Note that 1234874 is also the number of rows of Audit table...
Regards
Sybaris
The text was updated successfully, but these errors were encountered: