Skip to content

NULLable interval column inferred as string instead of string | null #1876

@icopp

Description

@icopp

Describe the bug

It looks like for some reason, on the latest Supabase CLI version (supabase version 2.58.5), interval columns are getting inferred as string only, ignoring the nullability of them.

Library affected

unsure/all/other

Reproduction

No response

Steps to reproduce

  • Create a table with a column typed INTERVAL (nullable)
  • Run supabase gen types --lang=typescript --local --schema > database.ts
  • See that the column is inferred as string instead of string | null

System Info

System:
    OS: macOS 26.1
    CPU: (8) arm64 Apple M3
    Memory: 344.05 MB / 24.00 GB
    Shell: 5.9 - /bin/zsh
  Binaries:
    Node: 22.20.0
    npm: 11.6.2
    Watchman: 2025.10.27.00
  Browsers:
    Chrome: 142.0.7444.162
    Edge: 142.0.3595.80
    Safari: 26.1

Used Package Manager

npm

Logs

No response

Validations

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions