The ShowCharset node seems to just be a SubqueryAlias-esque wrapper around information_schema.character_sets. It breaks a lot of conventions we have around how nodes are structured, and its debug string is effectively a blackbox so it was hard to debug when a filter was pushed down through it.
It might make sense to structure and build ShowCharset to be more similar to other SHOW nodes and to resolve/fetch information_schema.character_sets during rowexec.
The
ShowCharsetnode seems to just be aSubqueryAlias-esque wrapper aroundinformation_schema.character_sets. It breaks a lot of conventions we have around how nodes are structured, and its debug string is effectively a blackbox so it was hard to debug when a filter was pushed down through it.It might make sense to structure and build
ShowCharsetto be more similar to otherSHOWnodes and to resolve/fetchinformation_schema.character_setsduring rowexec.