Unable to read values with NUL in them

[corrideat]

Using jsr:@db/sqlite@0.13.0, I'm unable to read values from the DB if they contain a NUL in them (the value is truncated)

import * as sqlite from 'jsr:@db/sqlite'

const db = new sqlite.Database('./example.db')
db.run('CREATE TABLE IF NOT EXISTS Data(key TEXT NOT NULL PRIMARY KEY, value TEXT NOT NULL)')
const readStatement = db.prepare('SELECT value FROM Data WHERE key = ?')
const writeStatement = db.prepare('REPLACE INTO Data(key, value) VALUES(?, ?)')

writeStatement.run('foo', 'bar\x00baz')
console.error(readStatement.get('foo'))
// Result is `{ value: "bar" }` but it should have been `{ value: "bar\x00baz" }`, or a buffer with "bar\x00baz"
// Opening the DB with SQLite shows the correct values

[corrideat]

Looking through the code, it seems like the issue is in statement.ts:

const text = readCstr(ptr, 0);

The following appears to fix the issue:

    case SQLITE_TEXT: {
      const ptr = sqlite3_column_text(handle, i);
      if (ptr === null) return null;
      /// PATCH STARTS HERE
      const bytes = sqlite3_column_bytes(handle, i);
      const text = new TextDecoder().decode(
        Deno.UnsafePointerView.getArrayBuffer(ptr, bytes).slice(0),
      );
      /// PATCH ENDS HERE
      const value = sqlite3_column_value(handle, i);
      const subtype = sqlite3_value_subtype(value);
      if (subtype === JSON_SUBTYPE && parseJson) {
        try {
          return JSON.parse(text);
        } catch (_error) {
          return text;
        }
      }
      return text;
    }

[DjDeveloperr]

Thanks for reporting the bug - fixed in 4f1efd3
I'll make a release soon