Ankur Gupta

`IS NOT NULL` with alias throws SemanticCheckException

3

Using `IS NOT NULL` with alias throws SemanticCheckException. Example query: ``` SELECT dest_city_name AS dc FROM all_flights WHERE dc IS NOT NULL ``` Error: ``` Caused by: org.opensearch.jdbc.protocol.http.HttpException: HTTP Code:...

Data type 'Date' backward compatibility issue

1

Prior 1.13 driver release `Date` type was mapped `java.sql.TimeStamp` which carries time information but using `java.sql.Date` drops time information and set values to `00:00:00.000`. This makes the driver backward incompatible....

[BUG] IS NOT NULL with alias throws SemanticCheckException

9

**Describe the bug** Using `IS NOT NULL` with alias throws SemanticCheckException. **To Reproduce** Sample query: ``` SELECT dest_city_name AS dc FROM all_flights WHERE dc IS NOT NULL ``` **Expected behavior**...

[BUG] [JDBC] GetColumns fails with StringIndexOutOfBoundsException

1

**What is the bug?** Listing columns from index ending with hyphen (example: `people-detection-poc-`) throws StringIndexOutOfBoundsException. ``` Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 42 at java.lang.String.charAt(String.java:658) ~[?:1.8.0_322] at com.amazon.opendistroforelasticsearch.jdbc.internal.util.SqlParser.locateCommentEnd(SqlParser.java:59)...