The last punctuation character is kept in value extraction
FerreroJeremy opened this issue · 0 comments
FerreroJeremy commented
A punctuation sign in end of sentence (like in english) can distort the detection of the last value of the WHERE.
This sentence:
Count how many city there are where the score is greater than 2?
give:
SELECT COUNT(*)
FROM city
INNER JOIN emp
ON emp.cityId = city.id
WHERE emp.score > '2?';