INTERNAL Error:
ExpressionExecutor::Execute called with a result vector of type INTEGER that does not match expression type VARCHAR

Stack Trace:

0        duckdb::Exception::Exception(duckdb::ExceptionType, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>> const&) + 64
1        duckdb::InternalException::InternalException(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>> const&) + 20
2        duckdb::InternalException::InternalException<duckdb::LogicalType, duckdb::LogicalType>(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char>> const&, duckdb::LogicalType, duckdb::LogicalType) + 88
3        duckdb::ExpressionExecutor::Execute(duckdb::Expression const&, duckdb::ExpressionState*, duckdb::SelectionVector const*, unsigned long long, duckdb::Vector&) + 884
4        duckdb::ExpressionExecutor::Execute(duckdb::DataChunk*, duckdb::DataChunk&) + 92
5        duckdb::PhysicalHashJoin::Sink(duckdb::ExecutionContext&, duckdb::DataChunk&, duckdb::OperatorSinkInput&) const + 60
6        duckdb::PhysicalRightDelimJoin::Sink(duckdb::ExecutionContext&, duckdb::DataChunk&, duckdb::OperatorSinkInput&) const + 104
7        duckdb::PipelineExecutor::ExecutePushInternal(duckdb::DataChunk&, duckdb::ExecutionBudget&, unsigned long long) + 264
8        duckdb::PipelineExecutor::Execute(unsigned long long) + 356
9        duckdb::PipelineTask::ExecuteTask(duckdb::TaskExecutionMode) + 260
10       duckdb::ExecutorTask::Execute(duckdb::TaskExecutionMode) + 288
11       duckdb::Executor::ExecuteTask(bool) + 544
12       duckdb::ClientContext::ExecuteTaskInternal(duckdb::ClientContextLock&, duckdb::BaseQueryResult&, bool) + 64
13       duckdb::PendingQueryResult::ExecuteInternal(duckdb::ClientContextLock&) + 120
14       duckdb::PendingQueryResult::Execute() + 56
15       duckdb_shell_sqlite3_print_duckbox + 520
16       duckdb_shell::ShellState::ExecutePreparedStatement(sqlite3_stmt*) + 528
17       duckdb_shell::ShellState::ExecuteSQL(char const*, char**) + 488
18       duckdb_shell::ShellState::RunOneSqlLine(char*) + 248
19       duckdb_shell::ShellState::ProcessInput() + 1092
20       main + 3948
21       start + 6000

CREATE TABLE t0(c0 varchar);
CREATE TABLE t1(c0 INT);
CREATE TABLE t2(c1 INT);
CREATE TABLE t40(c0 varchar);
INSERT INTO t0(c0) VALUES ('duckdb');
INSERT INTO t2(c1) VALUES (1);
INSERT INTO t40(c0) VALUES ('duckdb');

SELECT * FROM t0, (SELECT 0) as subQuery0 LEFT JOIN (SELECT t0.c0 AS col_1, t1.c0 AS col_2, t2.c1 AS col_3 FROM t1 RIGHT JOIN t2 ON true ORDER BY t2.c1) as subQuery1 ON true;