Query validator
According to some embodiments, a method and apparatus are provided to receive a syntax correct query, analyze the syntax correct query, and output a message associated with the syntax correct query.
1. A method comprising:
receiving, from a log file, a syntax correct structured query language (“SQL”) based query after the syntax correct SQL based query has been successfully executed;
analyzing, via a processor, the syntax correct SQL based query, wherein analyzing comprises determining potential issues that may cause the syntax correct SQL based query to stop functioning properly based on a list of predetermined known potential issues associated with the syntax correct SQL based query, one of the known potential issues comprising a join between two tables that fails to utilize a field that is found in each table where the field comprises a same name and type or is explicitly defined as a foreign key; and
outputting a message associated with the syntax correct SQL based query, wherein the message comprises a warning.
2. The method of claim 1 , wherein the message further comprises a SQL based query change recommendation.
3. The method of claim 1 , wherein one of the known potential issues comprises a SQL based query that will return too much data.
4. The method of claim 1 , wherein one of the known potential issues comprises a SQL based query that may return potentially wrong data.
5. The method of claim 1 , wherein one of the known potential issues comprises a SQL based query that is susceptible to failure.
6. The method of claim 1 , wherein one of the known potential issues comprises a SQL based query that is susceptible to slow performance.
7. A non-transitory computer-readable medium comprising instructions that when executed by a processor perform a method, the method comprising:
receiving, from a log file, a syntax correct SQL based query after the syntax correct query has been executed;
analyzing, via a processor, the syntax correct SQL based query, wherein analyzing comprises determining potential issues that may cause the syntax correct SQL based query to stop functioning properly based on a list of predetermined known potential issues associated with the syntax correct SQL based query, one of the known potential issues comprising a join between two tables that fails to utilize a field that is found in each table where the field comprises a same name and type or is explicitly defined as a foreign key; and
outputting a message associated with the syntax correct SQL based query, wherein the message comprises a warning.
8. The medium of claim 7 , wherein the message further comprises a SQL based query change recommendation.
9. The medium of claim 7 , wherein one of the known potential issues comprises a SQL based query that will return too much data.
10. The medium of claim 7 , wherein one of the known potential issues comprises a SQL based query that may return potentially wrong data.
11. The medium of claim 7 , wherein one of the known potential issues comprises a SQL based query that is susceptible to failure.
12. The medium of claim 7 , wherein one of the known potential issues comprises a SQL based query that is susceptible to slow performance.
13. An apparatus comprising:
a processor;
a non-transitory computer-readable medium comprising instructions that when executed by the processor perform a method, the method comprising:
receiving, from a log file, a syntax correct SQL based query from a log file or a trace file after the syntax correct SQL based query has been successfully executed;
analyzing the syntax correct query, wherein analyzing comprises determining potential issues that may cause the syntax correct SQL based query to stop functioning properly based on a list of predetermined known potential issues associated with the syntax correct SQL based query, one of the known potential issues comprising a join between two tables that fails to utilize a field that is found in each table where the field comprises a same name and type or is explicitly defined as a foreign key; and
outputting a message associated with the syntax correct SQL based query, wherein the message comprises a warning.
14. The apparatus of claim 13 , wherein the message further comprises a SQL based query change recommendation.
15. The apparatus of claim 13 , wherein one of the known potential issues comprises a SQL based query that will return too much data, a SQL based query that may return potentially wrong data, a SQL based query that is susceptible to failure, or a SQL based query that is susceptible to slow performance.