4paradigm / 4paradigm/OpenMLDB

Support show variables like syntax

Open
#3,601 0 comments 0 reactions 0 assignees View on GitHub
sql
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

**Describe the feature you'd like**

Now mysql supports "show variables like" to show some variables instead of all variables. Refer to https://dev.mysql.com/doc/refman/8.0/en/show-variables.html .

But it does not support in OpenMLDB SQL.

![image](https://github.com/4paradigm/OpenMLDB/assets/2715000/b153cc7b-4afe-45a2-886a-57d5d18e8e8d)

**Additional context**

We have support `like` udf in other SQLs and may use in `show variables`.

Contributor guide

Open the contributing guide

Research direction

The issue is about extending the 'SHOW VARIABLES' command in OpenMLDB to support a 'LIKE' clause, similar to MySQL. Look for the SQL parser and command executor code that handles 'SHOW VARIABLES'. Check existing 'LIKE' UDF implementations to understand the pattern matching logic. Test the change by running the modified SQL command in the OpenMLDB CLI to verify it filters variables correctly.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
cli, databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
40/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.