qwebug

[GPU Logic Bug] SELECT DISTINCT <column> FROM <table> ORDER BY 1 DESC LIMIT 10 Brings Errors

1

### Describe: Using SELECT DISTINCT \ FROM \ ORDER BY 1 DESC LIMIT 10 brings different results , when set EXECUTOR\_DEVICE 'CPU' and 'GPU'. #### ***SQL:*** ```sql CREATE TABLE t0(c0...

### Describe: Using CAST('Infinity' AS INT)  brings different results , when set EXECUTOR\_DEVICE 'CPU' and 'GPU'. #### ***SQL:*** ```sql CREATE TABLE IF NOT EXISTS t0(c0 DOUBLE NULL); INSERT INTO t0(c0)...

[Crash Bug] SELECT * FROM <table> JOIN <table> ON NULL WHERE FALSE Brings Errors

2

### Describe: HeavyDB will crash when using SELECT \* FROM \ JOIN \ ON NULL WHERE FALSE, after SET EXECUTOR_DEVICE='GPU'. #### ***SQL:*** ```sql ALTER SESSION SET EXECUTOR_DEVICE='GPU'; CREATE TABLE t0(c0...

[Crash Bug] SELECT * FROM <table> JOIN <table> ON CAST(<number> AS BOOLEAN) WHERE FALSE Brings Errors

2

### Describe: HeavyDB will crash when using SELECT \* FROM \ JOIN \ ON CAST(\ AS BOOLEAN) WHERE FALSE, after SET EXECUTOR_DEVICE='GPU'. #### ***SQL:*** ```sql ALTER SESSION SET EXECUTOR_DEVICE='GPU'; CREATE...

[Crash Bug] SELECT <column> FROM <table> JOIN <table> ON FALSE Brings Errors

1

### Describe: HeavyDB will crash when using SELECT \ FROM \ JOIN \ ON FALSE, after SET EXECUTOR_DEVICE='GPU'. #### ***SQL:*** ```sql ALTER SESSION SET EXECUTOR_DEVICE='GPU'; CREATE TABLE t0(c0 INT); CREATE ...

[Crash Bug] Insert Values after Create Table With ( page_size = value (too small or large) ) cause Crash

3

### Describe: HeavyDB will crash when insert values after create table with too small or large pagesize, after SET EXECUTOR_DEVICE='GPU'. It is worth mentioning that no error report when create...

[Crash Bug] Create Table With ( special <property> = value ) cause Crash

3

### Describe: HeavyDB will crash when create tables with special property and values including PARTITIONS=0, SORT\_COLUMN=1, VACUUM=1, STORAGE\_TYPE=1, after SET EXECUTOR_DEVICE='GPU'. #### ***SQL:*** ```sql ALTER SESSION SET EXECUTOR_DEVICE='GPU'; CREATE TABLE...

### Describe: Using CAST(\+\(overflow) AS BOOLEAN) brings different results , when set EXECUTOR\_DEVICE 'CPU' and 'GPU'. #### ***SQL:*** ```sql CREATE TABLE t0(c0 INTEGER NULL); INSERT INTO t0(c0) VALUES(1707341980); ALTER SESSION ...

### Describe: Using SELECT \* FROM \ JOIN ( SELECT ALL \ FROM \) AS \  brings different results , when set EXECUTOR\_DEVICE 'CPU' and 'GPU'. #### ***SQL:*** ```sql CREATE ...

### Describe: Using SELECT \ FROM \ WHERE \ OR \ OR CAST(\ + CAST( \ AS INT) AS BOOLEAN)  brings different results , when set EXECUTOR\_DEVICE 'CPU' and 'GPU'....