[BUG] Function 'replace' expects 3 arguments but received 2
Valid dbt sql
SELECT DISTINCT
REPLACE('test-'::VARCHAR, '-')
Query execution error: Query execution error: DataFusion error: Error during planning: Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts. Candidate functions: replace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String)))) 0: <transparent> 1: Query execution error: Query execution error: DataFusion error: Error during planning: Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts. Candidate functions: replace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String)))), at crates/api-ui/src/queries/handlers.rs:118:10 2: Query execution error: DataFusion error: Error during planning: Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts. Candidate functions: replace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String)))), at crates/api-ui/src/queries/handlers.rs:117:10 3: DataFusion error: Error during planning: Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts. Candidate functions: replace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String)))), at crates/core-executor/src/query.rs:1333:14 4: Plan("Function 'replace' expects 3 arguments but received 2 No function matches the given name and argument types 'replace(Utf8, Utf8)'. You might need to add explicit type casts.\n\tCandidate functions:\n\treplace(Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))), Coercion(TypeSignatureClass::Native(LogicalType(Native(String), String))))")