sql: error when generate_series is used with scalar-group-by

[andy-kimball]

Repro:

root@:26257/defaultdb> SELECT max(1), generate_series(1,3);
ERROR: column "generate_series" must appear in the GROUP BY clause or be used in an aggregate function

EXPECTED: This should work. PG gives this output:

template1=# SELECT max(1), generate_series(1,3);
 max | generate_series
-----+-----------------
   1 |               1
   1 |               2
   1 |               3

Jira issue: CRDB-5126

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!

[andy-kimball]

Still a problem.