tursodatabase/turso

PRAGMA table_info strips type parameters from column declarations

Open

#5,762 创建于 2026年3月6日

在 GitHub 查看
 (2 评论) (0 反应) (1 负责人)Rust (1,001 fork)github user discovery
compatibilitygood first issueschema management

仓库指标

Star
 (19,103 star)
PR 合并指标
 (PR 指标待抓取)

描述

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.

贡献者指南