Fix show engiens
@@ -29,7 +29,7 @@ pub struct DfShowEngines;
impl AnalyzableStatement for DfShowEngines {
#[tracing::instrument(level = "debug", skip(self, ctx), fields(ctx.id = ctx.get_id().as_str()))]
async fn analyze(&self, ctx: Arc<QueryContext>) -> Result<AnalyzedResult> {
- let rewritten_query = "SELECT * FROM system.engines ORDER BY name DESC";
+ let rewritten_query = "SELECT Engine, Comment FROM system.engines ORDER BY Engine ASC";
let rewritten_query_plan = PlanParser::parse(rewritten_query, ctx);
Ok(AnalyzedResult::SimpleQuery(Box::new(
rewritten_query_plan.await?,
