node:sqlite can not executing more SQL statements

[linbingquan]

Deno can not work, Node can work

import { rmSync } from 'node:fs'
import { DatabaseSync } from 'node:sqlite'

rmSync('./sqlite.db', { force: true })

const database = new DatabaseSync('./sqlite.db')

database.exec(`CREATE TABLE one(id int PRIMARY KEY) STRICT;
CREATE TABLE two(id int PRIMARY KEY) STRICT;`)

const table = database.prepare(`SELECT name FROM sqlite_master WHERE type='table'`).all()

// Deno log { name: 'one' }
// Node log { name: 'one' }, { name: 'two' }
console.log(table)

Deno and Node can work

import { rmSync } from 'node:fs'
import { DatabaseSync } from 'node:sqlite'

rmSync('./sqlite.db', { force: true })

const database = new DatabaseSync('./sqlite.db')

database.exec(`CREATE TABLE one(id int PRIMARY KEY) STRICT;`)
database.exec(`CREATE TABLE two(id int PRIMARY KEY) STRICT;`)

const table = database.prepare(`SELECT name FROM sqlite_master WHERE type='table'`).all()

// log { name: 'one' }, { name: 'two' }
console.log(table)

deno --version
deno 2.1.9+e94581d (canary, release, x86_64-pc-windows-msvc)
v8 13.0.245.12-rusty
typescript 5.7.3