dolthub / dolthub/doltgresql

support for unnest with multiple args

Open
#3,106 1 comment 0 reactions 0 assignees View on GitHub
customer issue
Dominant language
Go
Stars
2.1k
Forks
73
Avg merge
1d 11h
Merged PRs (30d)
152

Description

```sql
select unnest(ARRAY[1, 2], ARRAY[10, 20]);
ERROR: function unnest(integer[], integer[]) does not exist
```

This is used by Django on a standard migration path, so it's high priority. Django uses it in an insert like this:

```sql
INSERT INTO bug11 (a, b) SELECT * FROM UNNEST(ARRAY[1, 2], ARRAY[10, 20]);
```

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the two SQL examples in DoltgreSQL, then trace the unnest function handling for calls with multiple array arguments. Done means both SELECT unnest(...) and the Django-style INSERT ... SELECT * FROM UNNEST(...) execute successfully and return paired rows.

Written by the indexing model from the issue text.

Assessment

Tech stack
django, go, postgresql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.