tursodatabase/turso
PRAGMA table_info strips type parameters from column declarations
Offen
#5.762 geöffnet am 06.03.2026
compatibilitygood first issueschema management
Repository-Metriken
- Stars
- (19.103 Sterne)
- PR-Merge-Metriken
- (Durchschn. Merge 2T 11h) (147 gemergte PRs in 30 T)
Beschreibung
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.