For Error Cases we have a Fallback to Select 1 , which is okay if our agent really couldnt generate. But when the SQLAgent realizes the query is nonsense, such as "Who is VIP Customers?", when it returns nothing (as expected), the fallback activates which makes our agent incorrect. We need to fix this, so we only use the Select 1 fallback, when there was an error during CorrectingSyntax wihtin the Validator agent or within semantically correcting it. Otherwise, if SQL agent returns nothng, its probably for a good reason.
For Error Cases we have a Fallback to
Select 1, which is okay if our agent really couldnt generate. But when the SQLAgent realizes the query is nonsense, such as "Who is VIP Customers?", when it returns nothing (as expected), the fallback activates which makes our agent incorrect. We need to fix this, so we only use the Select 1 fallback, when there was an error during CorrectingSyntax wihtin the Validator agent or within semantically correcting it. Otherwise, if SQL agent returns nothng, its probably for a good reason.