Issue with the spelling of between

[sayansinha2019]

WARNING:root:update: query generated error - not successful - SELECT SUM(SalesVolume) FROM customer1 WHERE Date BETWE 01/04/24 AND ProductCode = 'Iphone-15'

As you can see, its generating "BETWE" not "BETWEEN".

How to resolve this?

[doberst]

@sayansinha2019 - thanks for sharing this case. There may not be a perfect solution - likely will require a little bit of experimentation and trial and error.... We will note this, as we are taking the model through additional rounds of training. One question: how are you calling the model, and have you set sample=False and temperature=0.0 (this will help if the "BETWE" error is a function of sampling) ...