Processing correlated calculated fields in correlated subqueries
The present disclosure involves systems, software, and computer implemented methods for processing correlated calculated fields in correlated subqueries. One example method includes receiving a request to process a database query that includes at least one subquery and processing each subquery. A determination is made as to whether each subquery includes a correlated calculated field that is a calculated field that is not included in a first datasource queried by the subquery but is included in a second datasource queried by an outer query that includes the subquery. If the subquery does not include a correlated calculated field, the subquery is processed without modification. If the subquery includes a correlated calculated field, metadata is retrieved for the outer query of the subquery that queries the second datasource and includes the correlated calculated field. The subquery is rewritten using the metadata and the rewritten subquery is processed.
1. A computer-implemented method comprising:
receiving a request to process a database query that includes at least one subquery; and
processing each subquery included in the database query, including:
determining whether the subquery includes any correlated calculated fields, wherein a correlated calculated field is a calculated field that is not included in a first datasource queried by the subquery but is included in a second datasource queried by an outer query that includes the subquery;
in response to determining that the subquery does not include any correlated calculated fields, processing the subquery without modification; and
in response to determining that the subquery includes a first correlated calculated field:
identifying the outer query of the subquery that queries the second datasource that includes the first correlated calculated field;
retrieving metadata associated with the outer query and the first correlated calculated field;
rewriting the subquery using the metadata to generate a rewritten subquery that no longer includes the first correlated calculated field; and
processing the rewritten subquery.
2. The computer-implemented method of claim 1 , wherein the first correlated calculated field includes an operation involving at least one field of the second datasource.
3. The computer-implemented method of claim 2 , wherein the metadata includes information about the operation and schema and datasource qualifications for each field of the second datasource involved in the operation.
4. The computer-implemented method of claim 3 , wherein rewriting the subquery using the metadata comprises including the operation in the subquery.
5. The computer-implemented method of claim 4 , wherein rewriting the subquery using the metadata comprises qualifying, in the rewritten subquery, each field of the second datasource involved in the operation with respective schema and datasource qualifications.
6. The computer-implemented method of claim 1 , wherein the database query includes multiple subqueries that include respective correlated calculated fields.
7. The computer-implemented method of claim 6 , wherein processing each subquery includes rewriting each subquery of the multiple subqueries that includes a respective correlated calculated field.
8. The computer-implemented method of claim 1 , wherein the outer query is an immediately-adjacent query to the subquery.
9. The computer-implemented method of claim 1 , wherein the outer query is not an immediately-adjacent query to the subquery and identifying the outer query comprises evaluating multiple levels of outer queries of the subquery to identify the outer query.
10. A system comprising:
one or more computers; and
a computer-readable medium coupled to the one or more computers having instructions stored thereon which, when executed by the one or more computers, cause the one or more computers to perform operations comprising:
receiving a request to process a database query that includes at least one subquery; and
processing each subquery included in the database query, including:
determining whether the subquery includes any correlated calculated fields, wherein a correlated calculated field is a calculated field that is not included in a first datasource queried by the subquery but is included in a second datasource queried by an outer query that includes the subquery;
in response to determining that the subquery does not include any correlated calculated fields, processing the subquery without modification; and
in response to determining that the subquery includes a first correlated calculated field:
identifying the outer query of the subquery that queries the second datasource that includes the first correlated calculated field;
retrieving metadata associated with the outer query and the first correlated calculated field;
rewriting the subquery using the metadata to generate a rewritten subquery that no longer includes the first correlated calculated field; and
processing the rewritten subquery.
11. The system of claim 10 , wherein the first correlated calculated field includes an operation involving at least one field of the second datasource.
12. The system of claim 11 , wherein the metadata includes information about the operation and schema and datasource qualifications for each field of the second datasource involved in the operation.
13. The system of claim 12 , wherein rewriting the subquery using the metadata comprises including the operation in the subquery.
14. The system of claim 13 , wherein rewriting the subquery using the metadata comprises qualifying, in the rewritten subquery, each field of the second datasource involved in the operation with respective schema and datasource qualifications.
15. The system of claim 10 , wherein the database query includes multiple subqueries that include respective correlated calculated fields.
16. A computer program product encoded on a non-transitory storage medium, the product comprising non-transitory, computer readable instructions for causing one or more processors to perform operations comprising:
receiving a request to process a database query that includes at least one subquery; and
processing each subquery included in the database query, including:
determining whether the subquery includes any correlated calculated fields, wherein a correlated calculated field is a calculated field that is not included in a first datasource queried by the subquery but is included in a second datasource queried by an outer query that includes the subquery;
in response to determining that the subquery does not include any correlated calculated fields, processing the subquery without modification; and
in response to determining that the subquery includes a first correlated calculated field:
identifying the outer query of the subquery that queries the second datasource that includes the first correlated calculated field;
retrieving metadata associated with the outer query and the first correlated calculated field;
rewriting the subquery using the metadata to generate a rewritten subquery that no longer includes the first correlated calculated field; and
processing the rewritten subquery.
17. The computer program product of claim 16 , wherein the first correlated calculated field includes an operation involving at least one field of the second datasource.
18. The computer program product of claim 17 , wherein the metadata includes information about the operation and schema and datasource qualifications for each field of the second datasource involved in the operation.
19. The computer program product of claim 18 , wherein rewriting the subquery using the metadata comprises including the operation in the subquery.
20. The computer program product of claim 19 , wherein rewriting the subquery using the metadata comprises qualifying, in the rewritten subquery, each field of the second datasource involved in the operation with respective schema and datasource qualifications.