Chloe

Support between/not between operator

3

*Issue #, if available:* #1058 *Description of changes:* - Supported between / not between operator in SQL following the PostgreSQL syntax and return type (boolean): https://www.postgresqltutorial.com/postgresql-between/ - Added tests -...

Geopoint type is not supported in JDBC and raw formats

2

The response from the ES supports the geopoint type, and the csv format suppports geopoint as well, as shows below. Query: ``` `select geoip.location from kibana_sample_data_ecommerce limit 3` ``` Response:...

Extract `Limit` from `Head` and `RareTopN`

The date and time functions we are planning to support can be referring to [MySQL Reference Manual](https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html). For those with implicit definitions or argument/return types, refer to BigQuery reference manual...

[BUG] LIKE escape special characters with '\' not working

5

**What is the bug?** We followed MySQL syntax and tried to escape special character like '%' and '_' with the escape char ‘\\', because MySQL uses '\\' as the escape...

Currently the unit tests and cypress are not included in the cicd workflows, need to fix the failed tests (if any) and add testing step in the workflows to enforce...