Type error: referencing missing column count

[davidchalifoux]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

After upgrading @supabase/supabase-js to 2.26.0, I'm now getting a type error when querying count for a nested relationship. The API is returning the count exactly as before, so it's only a type issue.

To Reproduce

• Query the count of a nested relationship.
• Try to reference said value

Example query:

const response = await supabase
    .from("brands")
    .select(
      "*, brand_categories!brands_category_id_fkey(*), brand_subcategories(*, brand_categories(*)), brand_statuses(*), brand_locations(count)",
      { count: "estimated", head: false }
    );

In this example, brand_locations(count) is what's causing the error.
The returned type for that field is SelectQueryError even though no error is thrown from the API.

Expected behavior

The returned type of a count should not be SelectQueryError.

Screenshots

System information

• OS: macOS 13.5
• Version of supabase-js: v2.26.0
• Version of Node.js: v18.17.0

[soedirgo]

Thanks David, I'll try to reproduce this. Is count a normal column of brand_locations? Or a computed column etc.?

[davidchalifoux]

@soedirgo Thank you!
No, it is not a normal or computed column.

[davidchalifoux]

It's actually happening to me with a much simpler query:

const res = await supabase
      .from("brand_locations")
      .select("count", { count: "estimated", head: true })
      .eq("brand_id", brandId);

Again, it's returning SelectQueryError<"Referencing missing column count">.
I also tested it on other tables in my database, and it's happening with every one of them.
Could it be an issue with supabase gen types?

EDIT: Nevermind, I forgot you don't need to select count if it's not a foreign table.

[jasonpanosso]

This is happening to me with this query:

  const someQuery = await supabase
    .from('someTable')
    .select(
      `id,
       fk:foreign_key_id(id, name)
      `
    )

I believe it has to do with this pr

I've verified that my types file is correct, the column name exists on the foreign table, and foreign_key_id is configured as a foreign key to the table I expect it to be referencing(confirmed in types file). Also, at runtime, this works completely as expected with no issues.

I believe the expected behaviour is that fk should be unknown, or {}[]? This works fine if I put * instead of specifying columns. Not 100% sure on what the intended behavior is, or if my issue is directly related to this one. I'm just getting the same error, and they seem very similar

[jasonpanosso]

@soedirgo did you ever get a chance to test? Curious if this is intended behavior, or a bug

[samuba]

I have the same problem after upgrading. Also this seems to be a duplicate: #449

[github-actions]

🎉 This issue has been resolved in version 1.13.0 🎉

The release is available on:

• GitHub release
• npm package (@latest dist-tag)

Your semantic-release bot 📦🚀

[yulluone]

I am having the same issue with v 2.41.1 - Nuxt 3

I am attempting to fetch a list of jobs and their applications count. I have a jobs table and an applications table which references the jobs table. As you will see below, I get the results I want from the query I make but typescript cannot resolve count. Should count be added to generated database types definitions?

Here is my query:

const { data: jobsData, error: jobsError } = await supabase
      .from("jobs")
      .select(`id, job_title, industry, employer, applications(count)`)
      .eq("employer", userId);

Hovering over jobsData gives me this type:

const jobsData: {
    id: string;
    job_title: string;
    industry: string;
    employer: string;
    rocket_applications: SelectQueryError<"Referencing missing column `count`">[];
}[] | null

One of the job objects from the response I get:

{
  "id": "dad00615-9990-4c56-a39d-94ae32ba1133",
  "job_title": "Waiter/Waitress",
  "industry": "Real Estate",
  "employer": "b8e1aaed-c21b-485b-a9e6-50f0ae6d7016",
  "rocket_applications": [
    {
      "count": 6
    }
  ]
}

[viniciusdel]

I am having the same issue. It generates the proper types but the "count" is not marked in typescript so it's screaming.