tursodatabase/turso

PRAGMA table_info strips type parameters from column declarations

オープン

#5,762 opened on 2026/03/06

 (3 件のコメント) (0 件のリアクション) (1 人の担当者)Rust (1,001 件のフォーク)github user discovery
compatibilitygood first issueschema management

Repository metrics

Stars
 (19,103 個のスター)
PR merge metrics
 (平均マージ 2d 11h) (30d で 147 merged PRs)

説明

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.

コントリビューターガイド