INTERNAL Error: Assertion triggered in file "../extra/duckdb/src/execution/expression_executor/execute_function.cpp" on line 54: !result_data.validity.RowIsValid(idx)

[meetamit77]

Verified with debug builds of 8.0.44-alisql-dev-debug

After a SQL query throws this exception, any other query on the same table throws this same exception

ERROR 7501 (HY000): [DuckDB] INTERNAL Error: Assertion triggered in file "../extra/duckdb/src/execution/expression_executor/execute_function.cpp" on line 54: !result_data.validity.RowIsValid(idx)

Stack Trace:

.../debug/bin/mysqld(_ZN6duckdb9Exception6ToJSONENS_13ExceptionTypeERKSs+0x3a) [0xbb7f0b6]
.../debug/bin/mysqld(_ZN6duckdb9ExceptionC2ENS_13ExceptionTypeERKSs+0x30) [0xbb7efa6]
.../debug/bin/mysqld(_ZN6duckdb17InternalEx

Repro

CREATE TABLE IF NOT EXISTS t2;
DROP TABLE IF EXISTS t2;
CREATE TABLE t2 (
pk int NOT NULL,
c1 int DEFAULT NULL,
c2 varchar(10) DEFAULT NULL,
PRIMARY KEY (pk)
) ENGINE=DUCKDB ;
INSERT INTO t2 VALUES (0,0,NULL),(0,1272832,NULL),(0,245,'rvqlzsvasu'),(0,1,'dhucjxdoyg'),(0,9,NULL),(0,NULL,'you'),(0,181,'xqyciakhxp'),(0,NULL,'why'),(0,4,'xiecurgmhb'),(0,25,NULL);
SELECT 1 FROM t2 ORDER BY GREATEST( c2, 0, - 0 );
SELECT COUNT(*) FROM t2;

[p1p1bear]

Confirmed, we were able to reproduce the issue. We are currently analyzing it.