Curated issues

SQL Good First Issues

Browse open source issues tagged with SQL in the issue metadata. Results stay focused on work that can become public contribution evidence.

628 matching issues

SQL

Slice signals

Average annotated difficulty: 3.4/5 across 158 issues.
11% of 158 time estimates are one day or less.

About SQL

The query language of relational databases (1974), standardised and spoken by MySQL, PostgreSQL, SQLite and most of the rest.

Open All

628 open issues indexed

request mode: window union over (last join) expect wrong schema of union query Open

bug execute-engine

4paradigm/OpenMLDB#2832 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
WARN log "not fully resolved" for SQL `select 0 in ("0","2")` Open

execute-engine minor

4paradigm/OpenMLDB#2845 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
support `format` argument for `date`, `datediff`, `timestamp`, `unix_timestamp`, etc Open

execute-engine udf

4paradigm/OpenMLDB#2848 · 1 comment · 0 reactions · 2 assignees · Indexed Sep 13, 2026
Spark job is trigger when compiling SQL with offline engine Open

batch-engine bug

4paradigm/OpenMLDB#2880 · 3 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
SQL Engine assumes all the pointers are valid during the computation period while it is not always true Open

bug high-priority

4paradigm/OpenMLDB#2944 · 1 comment · 0 reactions · 2 assignees · Indexed Sep 13, 2026
Support create table like maxcompute Open

batch-engine execute-engine sql

4paradigm/OpenMLDB#2977 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Category aggregation functions Open

enhancement execute-engine

4paradigm/OpenMLDB#3014 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
more flexible support to window (SimpleOps) Open

enhancement execute-engine

4paradigm/OpenMLDB#3024 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
can't lift child `i` to list for udf functions which requires params as list Open

bug execute-engine

4paradigm/OpenMLDB#3039 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Select constant in offline and sync mode will not print result Open

batch-engine bug

4paradigm/OpenMLDB#3076 · 2 comments · 0 reactions · 2 assignees · Indexed Sep 13, 2026
doc: distinguish udaf input list from array(e.g. split output) Open

documentation enhancement execute-engine

4paradigm/OpenMLDB#3099 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
create table bug in parallel Open

bug storage-engine

4paradigm/OpenMLDB#3121 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
colunm resolving: uncleared resolving to a rename node Open

bug execute-engine minor

4paradigm/OpenMLDB#3144 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Support inserting timestamp filed with `yyyy-MM-dd HH:mm:ss` format Open

enhancement storage-engine

4paradigm/OpenMLDB#3167 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Support SQL syntax of limit with parameter Open

execute-engine

4paradigm/OpenMLDB#3179 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
support function: current_timestamp, current_date, now Open

enhancement execute-engine udf

4paradigm/OpenMLDB#3198 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
CLI: copy a large and multiline sql, result may be wrong Open

storage-engine

4paradigm/OpenMLDB#3207 · 3 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
LAST JOIN with complex condition not work on offline mode Open

bug high-priority

4paradigm/OpenMLDB#3240 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
lag correctness: wrong result used as parameter of other udaf Open

bug execute-engine udf

4paradigm/OpenMLDB#3299 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Use JDBC ResultSet and can not get the schema Open

high-priority java sdk

4paradigm/OpenMLDB#3310 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
external registered functions: registered fn with wrong signatures cores the whole tablet Open

bug execute-engine high-priority

4paradigm/OpenMLDB#3368 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
CREATE FUNCTION: test not covered for `CREATE FUNCTION ... OPTIONS (FILE = 'libxxx.so')` Open

bug test

4paradigm/OpenMLDB#3375 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Compiling the SQL that has many features(more than 5000) will take a long time Open

bug high-priority

4paradigm/OpenMLDB#3402 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
feat(offline): support const project with arbitrary expression for const projection Open

batch-engine enhancement

4paradigm/OpenMLDB#3405 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
coverage fails at high freq Open

storage-engine workflow

4paradigm/OpenMLDB#3412 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
support request with sql in apiserver Open

api-server

4paradigm/OpenMLDB#3425 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
work with dates before 1900 or timestamp before 1970 Open

bug execute-engine

4paradigm/OpenMLDB#3501 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Deploy without table success but use it fail Open

bug high-priority storage-engine

4paradigm/OpenMLDB#3551 · 0 comments · 0 reactions · 2 assignees · Indexed Sep 13, 2026
feat(online): support SQL `last join order by( filter<optimized> ) ` Open

execute-engine

4paradigm/OpenMLDB#3599 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Support show variables like syntax Open

sql

4paradigm/OpenMLDB#3601 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
Create table from hive may support setting replica and other config Open

4paradigm/OpenMLDB#3622 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
sqlRouter.GetTableNames will return empty list even if the database does not exist Open

bug sdk

4paradigm/OpenMLDB#3624 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Resolve the inconsistency problem of distinct count in offline mode Open

batch-engine bug

4paradigm/OpenMLDB#3629 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Truncate the sql string when calling show jobs command Open

batch-engine

4paradigm/OpenMLDB#3650 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
count(*) over table in offline mode Open

batch-engine enhancement high-priority

4paradigm/OpenMLDB#3652 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
use default database in subquery not support in offline Open

bug

4paradigm/OpenMLDB#3683 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
cast string as date not support in offline Open

bug

4paradigm/OpenMLDB#3684 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Inconsistent results in online/offline mode while join condition includes null Open

bug execute-engine high-priority

4paradigm/OpenMLDB#3685 · 2 comments · 0 reactions · 2 assignees · Indexed Sep 13, 2026
Add SQL syntax support for passing tuple to 'where in' statement Open

4paradigm/OpenMLDB#3689 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 13, 2026
Show components does not show all taskmanager Open

duplicate enhancement high-priority task-manager

4paradigm/OpenMLDB#3691 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
add desc about load data option `sql` Open

documentation

4paradigm/OpenMLDB#3707 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
load data issues and error msg improvements Open

high-priority

4paradigm/OpenMLDB#3708 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
feat: scalar subquery and correlated subquery Open

enhancement execute-engine high-priority sql

4paradigm/OpenMLDB#3714 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Click the table name will get error and fail to open the detail page Open

4paradigm/FeatInsight#18 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
Support uploading SQL or data files Open

4paradigm/FeatInsight#19 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
Provide the consistent type name for string and varchar Open

4paradigm/FeatInsight#27 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
Add sync mode for offline SQL execution Open

4paradigm/FeatInsight#31 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
insert statement: codegen insert rows Open

enhancement execute-engine storage-engine

4paradigm/OpenMLDB#3731 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
sql_cmd_test too easy to fail Open

bug storage-engine

4paradigm/OpenMLDB#3751 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
After inserting data with precompiled SQL, when queried, certain fields have additional null characters ('\x00') appended at the end Open

bug python

4paradigm/OpenMLDB#3779 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026

SQL Good First Issues

Slice signals

About SQL

Get new issues in your inbox