sqlvalidator icon indicating copy to clipboard operation
sqlvalidator copied to clipboard

Add interval expression

Open wammaster opened this issue 11 months ago • 0 comments

The current version doesn't handle well the interval statement. If we try to validate this SQL code:

SELECT * FROM table WHERE date >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 7 DAY)

we lose the day parameter of the interval, here is what is output:

SELECT *
FROM table
WHERE date >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 7)

With this PR we will stop losing the unit of time.

wammaster avatar Mar 14 '24 17:03 wammaster