COALESCE returns a NullInt instead of an int in JOIN

[kevinburke1]

If I have COALESCE(connected_clients, 0), sqlc generates a NullInt64 for this instead of an int64. This is a regression from 1.7.0. (At least I can fix it by casting to the right value).

[kyleconroy]

@kevinburkemeter What is the type of connected_clients?

[kevinburke1]

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
 }

[kevinburke1]

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;