search

cube2222 / octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Mozilla Public License 2.0
4.74k stars 201 forks source link

unsupported expression CaseExpr #323

Open Lvnszn opened 1 year ago

Lvnszn commented 1 year ago

how can i use case when in octosql 

 couldn't parse aliased expression: &{Expr:<nil> Whens:[0xc000522a20] Else:0xc000522a40}: unsupported expression &{Expr:<nil> Whens:[0xc000522a20] Else:0xc000522a40} of type *sqlparser.CaseExpr
cube2222 commented 1 year ago

Hey! It's not supported, so you'd have to contribute it. The implementation would be similar to how COALESCE is implemented.

Lvnszn commented 1 year ago

let me try