SHOW USERS LIKE/NOT LIKE

[alexey-milovidov]

Company or project name

ClickHouse

Use case

SHOW USERS NOT LIKE '%-internal'

Describe the solution you'd like

Implement it for USERS and also for all similar SHOW statements.

Describe alternatives you've considered

No response

Additional context

No response

[davidmenggx]

I can try this

[zainulabidin302]

hi @davidmenggx , I'm getting started with ch contributions and this looked like a great first issue to learn the parser/interpreter path.

Have you already started on it? If not, I'd love to pick it up. Happy to leave it if you're mid-way. Thanks ;) Zain

[davidmenggx]

Hi @zainulabidin302 I haven't started on this yet, so feel free to go ahead and pick it up!

[zainulabidin302]

Appreciate it david, thanks.

taking it now

[1000ms]

@zainulabidin302 I have started on it already.

[zainulabidin302]

hey @1000ms I'd actually picked this up after david handed it off (had a version ready before I saw your message).

I've got a tested implementation for SHOW USERS/ROLES/PROFILES [NOT] LIKE/ILIKE. happy to open it as a PR so folks can review or if you are midway on your own, let's compare notes so we don't duplicate.

can you share status?

[1000ms]

Hi @zainulabidin302 I also have the tested PR ready, but I have not written tests as I am not 100% sure whether .sql test would be enough for this. Was going to raise the PR and ask for help on tests.