tursodatabase/turso

PRAGMA table_info strips type parameters from column declarations

Open

#5,762 opened on Mar 6, 2026

View on GitHub
 (2 comments) (0 reactions) (1 assignee)Rust (1,001 forks)github user discovery
compatibilitygood first issueschema management

Repository metrics

Stars
 (19,103 stars)
PR merge metrics
 (PR metrics pending)

Description

Description

PRAGMA table_info strips parenthesized type parameters from column type declarations. SQLite preserves the complete type string exactly as written.

Reproducer

CREATE TABLE t(
  a VARCHAR(100),
  b CHAR(50),
  c DECIMAL(10,2),
  d NUMERIC(5,3),
  e FLOAT(24),
  f NVARCHAR(200)
);
PRAGMA table_info(t);
-- Turso type column: VARCHAR, CHAR, DECIMAL, NUMERIC, FLOAT, NVARCHAR
-- SQLite type column: VARCHAR(100), CHAR(50), DECIMAL(10,2), NUMERIC(5,3), FLOAT(24), NVARCHAR(200)

Per SQLite documentation: the "type" column reports the declared type of the column. The schema parser or column metadata storage strips the parenthesized parameters.

This issue brought to you by Mikaël and Claude Code.

Contributor guide

Research direction
Locate the schema parsing or column metadata storage code in the Turso codebase that strips parenthesized type parameters from column type strings. Focus on code paths handling PRAGMA table info output.
Tech stack
rustsqlite
Domain
database
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
SQLiteRust
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65