env “TMPDIR" can't change the tmp store diretory about go-sqlite3 HOT 7 OPEN

PRAGMA temp_store_directory = '/path/to/the/tmpdir';

❯ sqlite3 db.bak -cmd "PRAGMA temp_store_directory = '/mnt/test'; VACUUM" .quit

Error: database or disk is full

...
_, err = db.Exec("PRAGMA temp_store_directory = '/mnt/test'; VACUUM")
...

❯ go run main.go
azTempDirs[0] = NULL
azTempDirs[1] = /mnt/test
2024/02/21 21:17:54 Database vacuumed successfully

/*
** Directories to consider for temp files.
*/
static const char *azTempDirs[] = {
  0,
  0,
  "/var/tmp",
  "/usr/tmp",
  "/tmp",
  "."
};

/*
** Initialize first two members of azTempDirs[] array.
*/
static void unixTempFileInit(void){
  azTempDirs[0] = getenv("SQLITE_TMPDIR");
  azTempDirs[1] = getenv("TMPDIR");
  printf("azTempDirs[0] = %s\n", azTempDirs[0] ? azTempDirs[0] : "NULL");
  printf("azTempDirs[1] = %s\n", azTempDirs[1] ? azTempDirs[1] : "NULL");
}

$ ls -lah /data/nostr-relay.sqlite
-rw------- 1 mattn mattn 1.7G  2月 22 23:20 /data/nostr-relay.sqlite
$ sudo mkdir test
$ sudo chmod 600 test
$ TMPDIR=./test SQLITE_TMPDIR=./test sqlite3 /data/nostr-relay.sqlite -cmd vacuum .quit