version: 1.0.0-rc.1
SQL:SELECT * FROM ( select if(s2 > 0, s1 + 1, s1) as hour from ( select timestampdiff(hour, rent.rent_start, rent.rent_end) as s1, timestampdiff(second, rent.rent_start, rent.rent_end)%3600 as s2 from biz_man_share_rent rent where rent.share_id = $SHAREID$ ) as hours ) AS DATART_VTABLE LIMIT 1000 OFFSET 0
DB: MYSQL
EXCEPTION:org.apache.calcite.sql.parser.SqlParseException: Encountered "hour" at line 1, column 54.
Was expecting one of:
<QUOTED_STRING> ...
<BRACKET_QUOTED_IDENTIFIER> ...
<QUOTED_IDENTIFIER> ...
<BACK_QUOTED_IDENTIFIER> ...
<HYPHENATED_IDENTIFIER> ...
...
<UNICODE_QUOTED_IDENTIFIER> ...