AOR Report shows no result for no admin user

I’m using SuiteCRM version 7.8.1. When creating a report for example all accounts that have ‘Test’ in their name and list account id, name, description, date created and linked contact id fields. When this report runs from an admin user results are shown but when non admin user runs the report no resullts are shown and following query is logged in suitecrm.log.

Query Failed: SELECT accounts.id AS ‘ID0’, accounts.name AS ‘Name1’, accounts.date_entered AS ‘Date_Created2’, accounts.assigned_user_id AS ‘Assigned_to3’, accounts:contacts.id AS ‘ID4’, accounts.id AS ‘accounts_id’, accounts:contacts.id AS ‘accounts:contacts_id’ FROM accounts LEFT JOIN accounts_contacts accounts|accounts:contacts ON accounts.id=accounts|accounts:contacts.account_id AND accounts|accounts:contacts.deleted=0

LEFT JOIN contacts accounts:contacts ON accounts:contacts.id=accounts|accounts:contacts.contact_id AND accounts:contacts.deleted=0
AND ( contacts.assigned_user_id =‘8a535fb3-523e-1414-507a-58aecd1c2c70’ or EXISTS (SELECT 1
FROM securitygroups secg
INNER JOIN securitygroups_users secu
ON secg.id = secu.securitygroup_id
AND secu.deleted = 0
AND secu.user_id = ‘8a535fb3-523e-1414-507a-58aecd1c2c70’
INNER JOIN securitygroups_records secr
ON secg.id = secr.securitygroup_id
AND secr.deleted = 0
AND secr.module = ‘Contacts’
WHERE secr.record_id = contacts.id
AND secg.deleted = 0) ) WHERE ( accounts.name LIKE CONCAT(’%’, ‘Test’ ,’%’) ) AND accounts.deleted = 0 AND ( accounts.assigned_user_id =‘8a535fb3-523e-1414-507a-58aecd1c2c70’ or EXISTS (SELECT 1
FROM securitygroups secg
INNER JOIN securitygroups_users secu
ON secg.id = secu.securitygroup_id
AND secu.deleted = 0
AND secu.user_id = ‘8a535fb3-523e-1414-507a-58aecd1c2c70’
INNER JOIN securitygroups_records secr
ON secg.id = secr.securitygroup_id
AND secr.deleted = 0
AND secr.module = ‘Accounts’
WHERE secr.record_id = accounts.id
AND secg.deleted = 0) ) LIMIT 0,20: MySQL error 1054: Unknown column ‘contacts.assigned_user_id’ in ‘on clause’

Tracking this issue shows that when access query is added to the report query the module joined name is used instead of alias.

Has any one encountered this issue. This issue is also on Fresh 7.8.1 version sugar.
Help needed!