FerreroJeremy/ln2sql

The last punctuation character is kept in value extraction

FerreroJeremy opened this issue · 0 comments

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?';