TypeScript / React useTable returns number instead of bool

[sean256]

View

export const foo = db.view(
	{ name: 'foo', public: true },
	t.array(t.row('fooReturns', { foo: t.bool() })),
	ctx => {
		return [
			{
				foo: true,
			},
		];
	},
);

Output via React useTable

Actual

{"foo":1}

Expected

{"foo":true}

Output via SQL Endpoint

[
  {
    "schema": {
      "elements": [
        {
          "name": {
            "some": "foo"
          },
          "algebraic_type": {
            "Bool": []
          }
        }
      ]
    },
    "rows": [
      [
        true
      ]
    ],
    "total_duration_micros": 2927,
    "stats": {
      "rows_inserted": 0,
      "rows_deleted": 0,
      "rows_updated": 0
    }
  }
]

Weirdly this half works

export const foo = db.view(
	{ name: 'foo', public: true },
	t.array(t.row('fooReturns', { foo: t.bool(), sub: t.object('foo', { subFoo: t.bool() }) })),
	ctx => {
		return [
			{
				foo: true,
				sub: {
					subFoo: true,
				},
			},
		];
	},
);

OUTPUT

{"foo":true,"sub":{"subFoo":1}}

Now the top level value is correctly a bool, but the sub value is a number

[sean256]

I had Claude fix it in a local build, here's what worked:

Bug is in the fixed-size product deserialization fast path in algebraic_type.ts.

When a product type has only fixed-size primitive fields, a fast path generates code that reads directly from a DataView. For Bool fields, it generates:

result.foo = view.getUint8(reader.offset);

getUint8 returns a number (1), not a boolean (true). The non-fast path correctly uses reader.readBool() which does value !== 0.

This explains the behavior in the report:

• Simple product with only primitives — hits the fast path, bools come back as 0/1
• Product with a nested object — the outer product is no longer all-fixed-size, so it falls to the non-fast path and top-level bools deserialize correctly. But the inner product (which is all primitives) still hits the fast path, so nested bools are still 0/1.

Fix: append !== 0 to the generated code for Bool fields:

result.foo = view.getUint8(reader.offset) !== 0;