oven-sh/bun

"create table foo;" from example isn't working

Open

#12,119 创建于 2024年6月24日

在 GitHub 查看
 (2 评论) (0 反应) (1 负责人)Rust (90,348 star) (4,486 fork)batch import
bugbun:sqliteconfirmed bugdocsgood first issue

描述

What version of Bun is running?

1.1.16+bf7b327f6

What platform is your computer?

Darwin 23.5.0 arm64 arm

What steps can reproduce the bug?

const db = new Database(":memory:");
const query = db.query(`create table foo;`);

What is the expected behavior?

A created table.

What do you see instead?

22 | const query = db.query(create table foo); ^ SQLiteError: incomplete input errno: 1

  at prepare (bun:sqlite:277:10)
  at query (bun:sqlite:284:8)
  at /Users/steida/dev/bun/SkiplistSql.ts:22:18

Additional information

No response

贡献者指南

技术栈
typescriptsqlite
领域
backenddatabase
议题类型
bug
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
1
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
under 1 hour
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
blocked
清晰度议题是否清楚说明期望改动、验收标准和下一步。
clear
前置要求
basic SQL syntaxfamiliarity with Bun's SQLite API
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
70
研究方向
The issue is that the SQL statement 'create table foo;' is invalid because at least one column is required. The stack trace points to the 'prepare' function in bun:sqlite (line 277). Look at the Bun source code, likely in src/sqlite/sqlite.zig or similar, to see how SQL statements are passed to sqlite3 prepare v2. Consider adding validation to either auto add a dummy column or throw a clearer error. Check if any existing PRs or comments address this; none were linked.