Query with error in PLSQL does not throw an error in Qlik Sense and returns partial results
Hey everyone,
A rather unusual issue here: Using the Oracle connector from Qlik Sense, I am running a specific single query - SELECT * FROM RANDOM_VIEW - which includes single-row subqueries in the SELECT statement of the view. Due to an issue in the underlying data, this query should fail with an ORA-01427 (single-row subquery returns more than one row) message. This is indeed the case when I run the query from PL/SQL Developer, but when I run the same query from Qlik Sense, it behaves oddly; Instead of throwing an error message and stopping, it doesn't throw an error message and returns partial data (up to the point where the ORA-01427 occurred).
I have not changed the ErrorMode defaults.
Has anyone experienced this issue or anything similar to it, where a query returns partial data instead of failing with an error as it should? I'm stumped as to how to further troubleshoot this issue.
