dolthub / dolthub/doltgresql

`DOLT_PATCH` output should properly format strings

Open
#2,241 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
2.1k
Forks
73
Avg merge
1d 11h
Merged PRs (30d)
152

Description

This applies to all Dolt functions, not just `DOLT_PATCH`. If used on any columns that should output its data in textual format (`VARCHAR`, `TIMESTAMP`, etc.), it just outputs the unquoted contents. This means that the statements, as given, are invalid. An example output:
```sql
INSERT INTO "table_name" ("text_val","timestamp_val") VALUES (example text,2026-01-27 03:00:00.00);
```

Contributor guide

Open the contributing guide

Research direction

Reproduce the example with DOLT_PATCH and other Dolt functions using VARCHAR and TIMESTAMP columns, then inspect the relevant function implementations to trace how textual values are rendered. Done means generated statements quote and format string-like values so the resulting SQL is valid across the affected functions.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, postgresql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.