Oracle Queries not considering UI selected schema in query and failing with syntax error

[scherue2]

Is there an existing issue for this?

• I have searched the existing issues

Description

Below error when not specifying schema name even that is selected from UI:
(cx_Oracle.DatabaseError) ORA-00942: table or view "MYSCHEMA"."MYTABLE" does not exist [SQL: select * from mytable] (Background on this error at: http://sqlalche.me/e/4xp6)

It seems to me that cx_oracle connection attribute "Connection.current_schema" is not properly set when use chooses different schema in UI.

Steps To Reproduce

1. Create user with access to multiple schemas in Oracle database
2. User enters HUE with initial schema: "myschema"
3. User switches to schema "myschema2" via UI -> schema metadata (tables, columns) is correctly refreshed in UI
4. User executes query for table in "myschema2"
5. Oracle Error is shown

Logs

No response

Hue version

4.11