| -- This case is based on the reproduce steps reported on https://github.com/greenplum-db/gpdb/issues/15149 |
| CREATE TABLE issue_15149(c1 varchar); |
| NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c1' as the Apache Cloudberry data distribution key for this table. |
| HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew. |
| SELECT t.c1 FROM (SELECT DISTINCT ON (upper(c1)) c1 COLLATE "C" FROM issue_15149)t; |
| c1 |
| ---- |
| (0 rows) |
| |
| DROP TABLE issue_15149; |
