🪲 Errors found in fuzzing

[joocer]

I asked ChatGPT for some test cases, it included these queries which failed but appeared like they should all run.

SELECT LOWER(name) FROM $astronauts WHERE UPPER(name) LIKE 'A%'

Query failed with error <class 'AttributeError'> but error None was expected

SELECT CAST(magnitude AS INTEGER) FROM $satellites WHERE magnitude IS NOT NULL 

Query failed with error <class 'opteryx.exceptions.InconsistentSchemaError'> but error None was expected

SELECT CONCAT('Astronaut: ', name) FROM $astronauts

AND

SELECT CONCAT(('Astronaut: ', name)) FROM $astronauts

AND

SELECT CONCAT('Hello', ' ', 'World') as concatenated

.

SELECT LPAD(name, 10, '*') FROM $planets

AND

SELECT RPAD(name, 10, '*') FROM $planets

.

SELECT ASCII('A') as ascii_value

AND

SELECT CHAR(65) as char_value

[joocer]

#1820 and #1821 raised