Details
-
Sub-task
-
Status: Closed
-
Major
-
Resolution: Invalid
-
None
-
None
-
None
Description
Needs subquery support.
{{Error: NotImplemented("Unsupported ast node Subquery(Query { with: None, body: Select(Select { distinct: false, top: None, projection: [UnnamedExpr(BinaryOp { left: Function(Function { name: ObjectName([Ident
{ value: \"sum\", quote_style: None }]), args: [Unnamed(BinaryOp { left: Identifier(Ident
{ value: \"ps_supplycost\", quote_style: None }), op: Multiply, right: Identifier(Ident { value: \"ps_availqty\", quote_style: None }) })], over: None, distinct: false }), op: Multiply, right: Value(Number(\"0.0001\")) })], from: [TableWithJoins { relation: Table { name: ObjectName([Ident
{ value: \"partsupp\", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }, TableWithJoins { relation: Table { name: ObjectName([Ident
{ value: \"supplier\", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }, TableWithJoins { relation: Table { name: ObjectName([Ident
{ value: \"nation\", quote_style: None }]), alias: None, args: [], with_hints: [] }, joins: [] }], selection: Some(BinaryOp { left: BinaryOp { left: BinaryOp { left: Identifier(Ident
{ value: \"ps_suppkey\", quote_style: None }), op: Eq, right: Identifier(Ident { value: \"s_suppkey\", quote_style: None }) }, op: And, right: BinaryOp { left: Identifier(Ident
{ value: \"s_nationkey\", quote_style: None }), op: Eq, right: Identifier(Ident { value: \"n_nationkey\", quote_style: None }) } }, op: And, right: BinaryOp { left: Identifier(Ident
{ value: \"n_name\", quote_style: None }), op: Eq, right: Value(SingleQuotedString(\"GERMANY\")) } }), group_by: [], having: None }), order_by: [], limit: None, offset: None, fetch: None }) in sqltorel")}}