Automatic detection of queries missing order-by via unit test

• US 9,767,219 B2
• Filed: 10/27/2014
• Issued: 09/19/2017
• Est. Priority Date: 10/27/2014
• Status: Active Grant

• Current Assignee: Successfactors Incorporated (SAP SE)
• Original Assignee: Successfactors Incorporated (SAP SE)
• Inventors: Wong, Joseph
• Primary Examiner(s): Ly, Anh
• Application Number:
  US14/524,803
• Publication Number:
  US 20160117416A1
• Time in Patent Office: 1,058 Days
• CPC Class Codes: G06F 16/903 Querying for retrieval from the web G06F16/953

Abstract

In one aspect, there is provided a method. The method may intercepting a result provided by a database in response to a query; modifying the intercepted result to enable detection of an order by problem; and detecting, based on the modified intercepted result, whether the query is missing an order by clause. Related systems, methods, and articles of manufacture are also disclosed.

Claims

1. A non-transitory computer-readable storage medium including program code that, when executed by at least one programmable processor, causes the at least one programmable processor to perform operations comprising:

intercepting, as part of testing of an application, a query sent by the application to a database, the database comprising a database management system that makes default sort order guarantees;

modifying the query by at least defining the query to return a plurality of results, the modified query enabling detection of whether the query causes an order by error at the application, the order by error representing an error at the application caused by at least the query not including an order by instruction and caused based on at least whether the plurality of results provided by the database to the application are out of order;

sending the modified query to the database;

intercepting a query result provided by the database in response to the modified query, the modified query including the plurality of results;

modifying, in response to the modified query not including the order by instruction, the intercepted query result by at least re-ordering the plurality of results;

sending the re-ordered plurality of results to the application to enable the determination of whether the re-ordered plurality of results cause the order by error at the application; and

detecting the query causes the order by error at the application, in response to the re-ordered plurality of results causing the error at the application.

2. The computer-readable storage medium of claim 1, wherein the order by error is related to order-sensitive and/or sequential access, by the application, of the re-ordered plurality of results.

3. The computer-readable storage medium of claim 2, wherein the order by error at the application triggers an exception to be thrown.

4. The computer-readable storage medium of claim 1, wherein the modifying the intercepted query comprises reversing the order of the plurality of results.

5. The computer-readable storage medium of claim 1, wherein the database comprises a column-store database.

6. The computer-readable storage medium of claim 1, wherein the order by instruction orders the query result based on one or more columns of the database.

7. The computer-readable storage medium of claim 1, wherein the query comprises a select query.

8. A method comprising:

intercepting, as part of testing of an application, a query sent by the application to a database, the database comprising a database management system that makes default sort order guarantees;

modifying the query by at least defining the query to return a plurality of results, the modified query enabling detection of whether the query causes an order by error at the application, the order by error representing an error at the application caused by at least the query not including an order by instruction and caused based on at least whether the plurality of results provided by the database to the application are out of order;

sending the modified query to the database;

intercepting a query result provided by the database in response to the modified query, the modified query including the plurality of results;

modifying, in response to the modified query not including the order by instruction, the intercepted query result by at least re-ordering the plurality of results;

sending the re-ordered plurality of results to the application to enable the determination of whether the re-ordered plurality of results cause the order by error at the application; and

detecting the query causes the order by error at the application, in response to the re-ordered plurality of results causing the error at the application.

9. The method of claim 8, wherein the order by error is related to order-sensitive and/or sequential access, by the application, of the re-ordered plurality of results.

10. The method of claim 9, wherein the order by error at the application triggers an exception to be thrown.

11. The method of claim 8, wherein the database comprises a column-store database.

12. The method of claim 8, wherein the order by instruction orders the query result based on one or more columns of the database.

13. The method of claim 8, wherein the modifying the intercepted query comprises reversing the order of the plurality of results.

14. The method of claim 8, wherein the query comprises a select query.

15. A system comprising:

at least one physical processor; and

at least one memory including program code which when executed by the at least one processor causes operations comprising;

intercepting, as part of testing of an application, a query sent by the application to a database, the database comprising a database management system that makes default sort order guarantees;

modifying the query by at least defining the query to return a plurality of results, the modified query enabling detection of whether the query causes an order by error at the application, the order by error representing an error at the application caused by at least the query not including an order by instruction and caused based on at least whether the plurality of results provided by the database to the application are out of order;

sending the modified query to the database;

intercepting a query result provided by the database in response to the modified query, the modified query including the plurality of results;

modifying, in response to the modified query not including the order by instruction, the intercepted query result by at least re-ordering the plurality of results;

sending the re-ordered plurality of results to the application to enable the determination of whether the re-ordered plurality of results cause the order by error at the application; and

detecting the query causes the order by error at the application, in response to the re-ordered plurality of results causing the error at the application.

16. The system of claim 15, wherein the order by error is related to order-sensitive and/or sequential access, by the application, of the re-ordered plurality of results.

17. The system of claim 15, wherein the order by error at the application triggers an exception to be thrown.

18. The system of claim 15, wherein the modifying the intercepted query comprises reversing the order of the plurality of results.

19. The system of claim 15, wherein the database comprises a column-store database.

20. The system of claim 15, wherein the query comprises a select query.