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

Test: Test `Create db.table`, `Create Index on db.table`, `Drop db.table` and `Desc db,table` Open

test

4paradigm/OpenMLDB#1179 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
CLI with interactive=false does not print error message if fail to execute SQL Open

enhancement

4paradigm/OpenMLDB#1224 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Can not drop table when using CLI to execute SQL files Open

bug storage-engine

4paradigm/OpenMLDB#1225 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Support UnsafeRowOpt for groupby agg physical node Open

enhancement

4paradigm/OpenMLDB#1346 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
add the sql UDF function for calculating percentile Open

call-for-contributions community execute-engine

4paradigm/OpenMLDB#1371 · 3 comments · 2 reactions · 0 assignees · Indexed Sep 13, 2026
Partial parameter binding in request mode Open

community

4paradigm/OpenMLDB#1388 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
feat(api server): support show api servers Open

api-server enhancement

4paradigm/OpenMLDB#1416 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
pre-aggregation table migration Open

enhancement

4paradigm/OpenMLDB#1488 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
希望增加一列拆成多行的函数 Open

community sql udf

4paradigm/OpenMLDB#1543 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
`CallProcedure` request may not be routed to the best tablet when `partitionnum` > 1 Open

enhancement

4paradigm/OpenMLDB#1604 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Execute drop function failed if deployment reference it Open

enhancement

4paradigm/OpenMLDB#1610 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Pre-aggr table still exists if deploy failed Open

bug high-priority storage-engine

4paradigm/OpenMLDB#1669 · 4 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Use simple expressions for join equality condition is supported Open

batch-engine sql

4paradigm/OpenMLDB#1687 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
JDBC: support connect to standalone Open

call-for-contributions java sdk

4paradigm/OpenMLDB#1693 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
docs: add index explanations in sql `desc` Open

enhancement storage-engine

4paradigm/OpenMLDB#1763 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
design the option for user to control ordering for window union rows and original rows that have same ts manully Open

execute-engine sql

4paradigm/OpenMLDB#1809 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
`SHOW COMPONENTS` include OpenMLDB version info Open

storage-engine

4paradigm/OpenMLDB#1830 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Support delete/gc the pre-aggregation tables when all related deployments are dropped Open

storage-engine

4paradigm/OpenMLDB#1933 · 0 comments · 0 reactions · 2 assignees · Indexed Sep 13, 2026
negative `order by` value overflow in window query Open

bug execute-engine

4paradigm/OpenMLDB#2182 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
The result of select is unstable in the cluster version Open

bug storage-engine

4paradigm/OpenMLDB#2192 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
apiserver needs full sql test, pay attention to NsClient::db_ Open

api-server enhancement

4paradigm/OpenMLDB#2212 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
When window is open, ts=0, calculation error Open

bug execute-engine

4paradigm/OpenMLDB#2213 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
When ts=0, the calculation of history window is wrong Open

bug execute-engine

4paradigm/OpenMLDB#2214 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
delete pre-agg tables if user going to drop the long window deployment Open

enhancement storage-engine

4paradigm/OpenMLDB#2308 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
long window: count where op with a rows bucket based pre-agg table may produce incorrect result Open

execute-engine storage-engine

4paradigm/OpenMLDB#2313 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
disk table supports duplicate key? Open

enhancement storage-engine

4paradigm/OpenMLDB#2318 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
The data of the pre aggregation table obtained by the SDK is empty, but the value is found by the command query Open

bug java sdk

4paradigm/OpenMLDB#2344 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
[TBC] CLI does not support multiple SQL strings Open

bug enhancement high-priority

4paradigm/OpenMLDB#2432 · 4 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
count_where over whole table in offline mode: project type kAggregation not supported Open

batch-engine enhancement

4paradigm/OpenMLDB#2441 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
window project over limit clause is not supported Open

enhancement execute-engine

4paradigm/OpenMLDB#2457 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
spark load data(online&offline), the blank value in the data will become null Open

bug high-priority storage-engine

4paradigm/OpenMLDB#2459 · 3 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Long window optimization effect for Real-time Feature processing is not obvious Open

bug execute-engine storage-engine

4paradigm/OpenMLDB#2464 · 6 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
`long window` supports base table with existing data Open

enhancement storage-engine

4paradigm/OpenMLDB#2485 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Sync `deployment` to replica cluster Open

4paradigm/OpenMLDB#2490 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
request mode: last join order by check should fail if column is not ts of a index Open

bug execute-engine high-priority

4paradigm/OpenMLDB#2493 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
sql engine: fail to resolve column from right table in last join where multiple window op exists Open

bug execute-engine high-priority

4paradigm/OpenMLDB#2563 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
In offline mode, logs display all data information Open

batch-engine enhancement

4paradigm/OpenMLDB#2564 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Feature requirements of online recommendation platform for openmldb Open

api-server community enhancement execute-engine storage-engine

4paradigm/OpenMLDB#2574 · 19 comments · 3 reactions · 3 assignees · Indexed Sep 13, 2026
During online export (SELECT INTO), when quote='#', # in the string will not be escaped Open

bug storage-engine

4paradigm/OpenMLDB#2589 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Offline export. When quote='#', the empty string is "" Open

batch-engine bug minor

4paradigm/OpenMLDB#2590 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
docs about ttl and auto index Open

documentation

4paradigm/OpenMLDB#2600 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
feat: `NaN` value in table rows Open

enhancement

4paradigm/OpenMLDB#2628 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 13, 2026
ddlparser: sql compile options need to check Open

enhancement

4paradigm/OpenMLDB#2634 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 13, 2026
For stand-alone version, the data in the db directory is not cleared after restart Open

bug storage-engine

4paradigm/OpenMLDB#2659 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
There is no data in the result of full table aggregation calculation for an empty table Open

bug execute-engine

4paradigm/OpenMLDB#2667 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Want to provide a way to query internal tasks Open

enhancement

4paradigm/OpenMLDB#2712 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
router error improvements Open

enhancement

4paradigm/OpenMLDB#2741 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
show database status Open

enhancement sql storage-engine

4paradigm/OpenMLDB#2744 · 0 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
query trace Open

enhancement

4paradigm/OpenMLDB#2784 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 13, 2026
Support simple column computing in offline Open

batch-engine enhancement

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

SQL Good First Issues

Slice signals

About SQL

Get new issues in your inbox