Kimi WANG

Results 4 comments of Kimi WANG

Use alternative privilege escalation command to initialize the environment

> We have many more locations that uses `sudo` to get super user privilege, I think we should make this approach more generic. Maybe in executor? Thank you Allen for...

Use alternative privilege escalation command to initialize the environment

> Hi, is it possible to make the option global (like `--native-ssh`) and implement this in SSH executor rather than only for the `env_init` process? Sure, but I'm quite busy...

Query optimizer choose to do table scan while index seek is possible

Thank you @qw4990 for your quick response. Do we have workaround for this? Actually I rewrote the query in different forms to intend to "enforcing" the SQL engine to execute...

Query optimizer choose to do table scan while index seek is possible

I found one. The workaround is to create a generated stored column. The column will be used to identify the json column is null or not. E.g `job_result_not_null TINYINT AS...