suyuz

Unexpected results when comparing NULL value in WHERE clause

1

### Describe the bug Considering the test case below. ```sql CREATE TABLE t0(c1 INT); INSERT INTO t0 (c1) VALUES (1); SELECT * FROM t0; -- 1 SELECT NOT (0 >...

Potential issue when multi-threading testing using virtuoso jdbc driver

8

I am currently testing Virtuoso by building docker image following this: https://github.com/openlink/vos-reference-docker. Recently I frequently triggered the following crash in Virtuoso (I could reproduce on latest manual build from 604fdc7,...

Consider the test case below. It is unexpected that the second query return an empty result, as the first query return `NULL`, and the subsequent queries with `ORDER BY` shouldn't...

Unexpected results when comparing string with type conversion

3

Considering the test case below: ```sql CREATE TABLE t0(c1 VARCHAR(500), PRIMARY KEY(c1)); -- PK is needed to reproduce the issue INSERT INTO t0 (c1) VALUES ('a'); SELECT * FROM t0;...

Crash by `INNER JOIN`

2

The following test case crashed go-mysql-server. ```sql CREATE TABLE t0(c0 VARCHAR(500)); CREATE TABLE t1(c0 INTEGER, PRIMARY KEY(c0)); INSERT INTO t1(c0) VALUES (0); INSERT INTO t0(c0) VALUES ('a'); INSERT INTO t1(c0)...

Crash when `INNER JOIN` with `CONTAINS`

1

**Describe the bug** Consider the test cases below. It would crash the monetdb server. The server log (`merovingian.log`) would show: `2024-02-27 09:53:35 MSG merovingian[159]: database 'monetdb' (2897) has crashed with...

**Describe the bug** Consider the test case below. It is unexpected that the third query returns `true`, since the second query returns `null`, which means that the `WHERE` clause in...

Potential issue when using `ROUND`

11

Consider the following test cases, the queries execute slowly. ```sql sql> SELECT ROUND(1, -9999999); 0 0 (1 row, 2717 ms) sql> SELECT ROUND(1, -99999999); 0 0 (1 row, 74565 ms)...

Unexpected result when comparing `IN` expression and integer

2

> Please make sure that the version you're using is still supported (you can find the list [here](https://github.com/ClickHouse/ClickHouse/blob/master/SECURITY.md#scope-and-supported-versions)). > You have to provide the following information whenever possible. **Company or...

**Describe the bug** Consider the following test cases. The `STARTSWITH` function checks if the string in `t0.c0` starts with the character 'a' with case sensitive, and it should be evaluated...