Go + SQLite3: Temporary Table Not Removed

sqlite_bug.go

package main

import (
	"context"
	"database/sql"
	"log"
	"os"

	_ "github.com/mattn/go-sqlite3"
)

func main() {
	err := createTempTableTwice(context.Background())
	if err != nil {
		log.Fatal(err)
	}
	log.Println("Done.")
}

func createTempTableTwice(ctx context.Context) error {
	os.Remove("./foo.db")
	db, err := sql.Open("sqlite3", "./foo.db")
	if err != nil {
		log.Fatal(err)
	}
	defer db.Close()
	{
		conn1, err := db.Conn(ctx)
		if err != nil {
			return err
		}
		_, err = conn1.ExecContext(ctx, `CREATE TEMPORARY TABLE temp.documents(document_id TEXT PRIMARY KEY);`)
		if err != nil {
			return err
		}
		err = conn1.Close()
		if err != nil {
			return err
		}
	}
	conn2, err := db.Conn(ctx)
	if err != nil {
		return err
	}
	defer conn2.Close()
	// NOTE: This line causes the following error: `2025/03/24 15:42:40 table documents already exists`
	_, err = conn2.ExecContext(ctx, `CREATE TEMPORARY TABLE temp.documents(document_id TEXT PRIMARY KEY);`)
	return err
}

Check out mattn/go-sqlite3#1330