Patent · US Active

Provision of position data for query runtime errors

US10324929B2 · kind B2 · utility

3Cited by

4References

12Claims

0Family size

Assignee

SAP SE · DE

Inventors

Weimin Qi · Xi'an, CN
Jaehyok Chong · Seoul, KR
Kihong Kim · Seoul, KR
Yu Wang · Xi'an, CN
Di Wu · Tangxia, CN

Key dates

Filing date	Oct 31, 2016
Grant date	Jun 18, 2019
Priority date	—
Expiry date	Sep 16, 2037

Classification

Technology area (CPC G)Physics
CPC primaryG06F8/427
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

A query is parsed and positions of symbols of the query are determined. A parse tree including the positions of the symbols is generated based on the parsed query. The parse tree is sent to a DBMS optimizer. The parse tree is transformed into an optimizer tree. The optimizer tree includes the positions of the symbols of the query.Based on the optimizer tree, a query execution plan is generated for the execution of the query. The positions of the symbols of the query is copied from the optimizer tree into the query execution plan. The query execution plan is sent to a query execution engine.The query is executed in accordance with the query execution plan. When a runtime error is detected, an exception message associated with the runtime error is displayed. The error message includes an error code and the positions of the symbols of the query.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.