Skip to content
This repository has been archived by the owner on Apr 11, 2024. It is now read-only.

No working a query on v2 Dune SQL #334

Open
mingji opened this issue Jun 5, 2023 · 0 comments
Open

No working a query on v2 Dune SQL #334

mingji opened this issue Jun 5, 2023 · 0 comments

Comments

@mingji
Copy link

mingji commented Jun 5, 2023

I have an issue for the following v2 dune sql.
Given correlated subquery is not supported
if I remove "where" statement, then no error.
But it's worked before for the deprecated queries.

select
            h.day
            ,(select evt_tx_hash from all_events where evt_block_time <=  h.day limit 1) as hash
from 
            unnest(SEQUENCE(timestamp '2022-05-20 00:00', CURRENT_DATE, interval '1' day) )  AS h(day)
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant