Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Invalid
-
None
-
None
-
None
Description
IN (Subquery) in (WHERE) expression support is missing.
{{Error: NotImplemented("Unsupported ast node InSubquery { expr: Identifier(Ident
{ value: \"ps_suppkey\", quote_style: None }), subquery: Query { with: None, body: Select(Select { distinct: false, top: None, projection: [UnnamedExpr(Identifier(Ident
{ value: \"s_suppkey\", quote_style: None }))], from: [TableWithJoins { relation: Table { name: ObjectName([Ident
{ value: \"supplier\", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }], selection: Some(BinaryOp { left: Identifier(Ident
{ value: \"s_comment\", quote_style: None }), op: Like, right: Value(SingleQuotedString(\"%Customer%Complaints%\")) }), group_by: [], having: None }), order_by: [], limit: None, offset: None, fetch: None }, negated: true } in sqltorel")}}