Int column turned to String in realtime listening (for one row)

[bit-burger]

Int column turned to String in realtime listening (for one row)

[bit-burger]

@bdlukaa yes im sorry for not making it directly clear

[bdlukaa]

Duplicate of #64.

Also, could you not create another issue with the same information?

[bit-burger]

@bdlukaa Sry accidentally sent it two times because i had duplicated the tab, won't happen again!

[bit-burger]

But i am failing to understand how this is a duplicate, no one mentions int columns or whatever type being changed to String columns, I even have overridden my dependencies with that exact branch of Supabase before it was merged, because before that nothing worked and after the installing of that branch there were the issues with the String columns, so it is definitely not fixed

[bdlukaa]

RealtimeSubscription Unhandled Exception: type 'Null' is not a subtype of type 'List' in type cast error

I assumed the issue was with this.

[bit-burger]

Here a small bit of code to maybe better understand the problem:

create domain points as bigint check (value >= 0);
create domain color as smallint check ((value >= 0) and (value < 10));
create domain icon as smallint check ((value >= 0) and (value < 230));

create table public.profiles(
  id uuid primary key references auth.users on delete cascade,
  name varchar(8) not null check(name ~ '^(?!-|\s)([a-z-]|\s)*[a-z]$'),
  status varchar(16) not null default 'im new to points',
  bio varchar(256) not null,
  color color not null default 9,
  icon icon not null default 0,
  points points not null default 0,
  gives points not null default 0
);

_client.from("profiles:id=eq.$userId").on(
        SupabaseEventTypes.update,
        (payload) {
          final user = payload.newRecord!;
          // TODO: Temp fix
          if (user["color"] is String) {
            user["color"] = int.parse(user["color"]);
          }
          if (user["icon"] is String) {
            user["icon"] = int.parse(user["icon"]);
          }
          if (user["points"] is String) {
            user["points"] = int.parse(user["points"]);
          }
          if (user["gives"] is String) {
            user["gives"] = int.parse(user["gives"]);
          }
          // Now the user can actually be used
        },
      )

As you can see I have to convert each and every column (I put them in ifs checking the type incase Supabase changes again)