Jinsheng Ba

Improvement of PQS Expression Logic

4

```sql SELECT ('')IS(FALSE); ``` In SQLite3, the above expression is evaluated TRUE, but SQLancer evaluates it FALSE.

## General Question I am trying to start the playground for the latest dev version of TiDB on Ubuntu 16.04, but it fails. ```shell $ tiup playground v6.2.0-alpha-nightly-20220615 tiup is...

SQLException: The prepared statement has been finalized

5

Hi, when I execute the query ";" in the JDBC and get the "The prepared statement has been finalized" error, but there is no error when I execute the query...

Unexpected Empty Reducer Folder

5

@oraluben @ColinYoungTaro Great job for your reducer! I am quite interested in it and have several questions when using it. ```sql java -jar sqlancer-2.0.0.jar --num-threads 20 --use-reducer --reduce-ast --username root...

Many DBMSs use similar logic to make sure every table is non-empty. However, this method has some not handled situations: * Expected errors may happen, so tables can not be...

ERROR 1105 (HY000): interface conversion

2

## Bug Report ### 1. Minimal reproduce step (Required) ```sql CREATE TABLE t0(c0 BLOB); CREATE VIEW v0(c0) AS SELECT NULL FROM t0 GROUP BY NULL; SELECT t0.c0 FROM t0 NATURAL...

Runtime Error: index out of range

6

## Bug Report ### 1. Minimal reproduce step (Required) ```sql create table t0(c0 INT); create view v1 as select exists( select 6 from t0 union select c_0 from t0 )...

slice bounds out of range

3

## Bug Report ### 1. Minimal reproduce step (Required) ```sql select distinct avg(nullif(77.15, PI())); --runtime error: slice bounds out of range [:1] with capacity 0 ``` ### 2. What did...

Unexpected Result in Windows Function inTiFlash

3

## Bug Report ### 1. Minimal reproduce step (Required) ```sql CREATE TABLE t0 (c0 INT); INSERT INTO t0 (c0) VALUES (1); ALTER TABLE t0 SET TIFLASH REPLICA 1; SELECT AVG(0)...

[YSQL] Unexpected truncated data returned by MAX()

3

Jira Link: [DB-15997](https://yugabyte.atlassian.net/browse/DB-15997) ### Description Please see this test case: ```sql CREATE TABLE t1(c0 CHAR(100)); INSERT INTO t1(c0) VALUES('a'); SELECT MAX(t1.c0) FROM t1; ``` The query returns the column with...