COALESCE returns a NullInt instead of an int in JOIN #1096

Activity

1. kyleconroy

   added

   go

   📚 postgresql

   regression

   on Aug 4, 2021
2. kyleconroy

   added this to the v1.9.0 milestone on Aug 4, 2021
3. kyleconroy commented on Aug 11, 2021

   

   kyleconroy

   on Aug 11, 2021

   Collaborator

   More actions

   @kevinburkemeter What is the type of connected_clients?
4. kyleconroy

   closed this as completedin #1112on Aug 11, 2021
5. kevinburke1 commented on Aug 11, 2021

   

   kevinburke1

   on Aug 11, 2021

   ContributorAuthor

   More actions

   Here are some examples

   SELECT stats.*,
   COALESCE(device_query.device_count, 0) AS device_count
   FROM stats
   LEFT JOIN device_query ON device_query.controller = stats.controller;
   

   Produces this diff when run on tip

   @@ -89,7 +90,7 @@ type GetControllerStatsAndDeviceCountRow struct {
    	DownloadBytes      float64
    	BandwidthUpdatedAt time.Time
    	LastRebootedAt     time.Time
   -	DeviceCount        int64
   +	DeviceCount        sql.NullInt64
    }
6. kevinburke1 commented on Aug 11, 2021

   

   kevinburke1

   on Aug 11, 2021

   ContributorAuthor

   More actions

   even simpler

   CREATE TABLE foo(id bigserial primary key);
   CREATE TABLE bar(id bigserial primary key);

   SELECT foo.*,
   COALESCE(bar.id, 0) AS device_count
   FROM foo
   LEFT JOIN bar ON foo.id = bar.id;
   

   ❤️React with ❤️1Reacted by Kyle Gray
7. kyleconroy

   reopened this on Aug 12, 2021
8. kyleconroy

   changed the title [-]COALESCE returns a NullInt instead of an int[/-] [+]COALESCE returns a NullInt instead of an int in JOIN[/+] on Aug 12, 2021
9. kyleconroy

   closed this as completedin #1119on Aug 12, 2021