Repository navigation
TIMESTAMPDIFF function issue #83
Description
So the problem is pretty simple:
The original:
TIMESTAMPDIFF(SECOND, uc_call.created_at, uc_call.ended_at) - uc_call.duration as waitingThe result:
TIMESTAMPDIFF(`SECOND`, `uc_call`.`created_at`, `uc_call`.`ended_at`) - `uc_call`.`duration` AS waitingSo, it makes the first argument as a ColRef, but should as... I even don't know :) Because I didn't find any class which can be matched with the date/time reserved words.
Activity
homersimpsons commentedon Oct 11, 2021
Hello @NikitaKharkov, thank you for your report.
The parser is in fact returning this as a
ColRef(instead of aReserved). You can avoid the issue using theSQL_TSI_*constants as such:homersimpsons commentedon Oct 11, 2021
After a bit of digging this issue comes from https://github.com/greenlion/PHP-SQL-Parser and it seems that it has already been reported: greenlion/PHP-SQL-Parser#212.