search

risingwavelabs / risingwave

SQL stream processing, analytics, and management. We decouple storage and compute to offer instant failover, dynamic scaling, speedy bootstrapping, and efficient joins.
https://www.risingwave.com/slack
Apache License 2.0
6.59k stars 538 forks source link

expr: support `ANY`/`ALL` for multi-dimensional array #10544

Open BugenZhao opened 1 year ago

BugenZhao commented 1 year ago

Are we going to support 1 = any(array[array[1,2], array[3,4]]) ? cc @xiangjinwu 

dev=> select 1 = any(array[array[1,2], array[3,4]]);
ERROR:  QueryError: Bind error: failed to bind expression: 1 = SOME(ARRAY[ARRAY[1, 2], ARRAY[3, 4]])

Caused by:
  Feature is not yet implemented: Equal[Int32, List]
Tracking issue: https://github.com/risingwavelabs/risingwave/issues/112

_Originally posted by @BugenZhao in https://github.com/risingwavelabs/risingwave/pull/10520#discussion_r1241062716_

In Postgres:

postgres=# select 1 = any(array[array[1,2], array[3,4]]);
 ?column? 
----------
 t
(1 row)
github-actions[bot] commented 9 months ago

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.

github-actions[bot] commented 4 days ago

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean. Don't worry if you think the issue is still valuable to continue in the future. It's searchable and can be reopened when it's time. 😄