Changeset: f42aec4f0a0e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f42aec4f0a0e
Modified Files:
sql/test/nested/Tests/bluesky.test.in
Branch: nested
Log Message:
aproved output for now
diffs (35 lines):
diff --git a/sql/test/nested/Tests/bluesky.test.in
b/sql/test/nested/Tests/bluesky.test.in
--- a/sql/test/nested/Tests/bluesky.test.in
+++ b/sql/test/nested/Tests/bluesky.test.in
@@ -74,13 +74,13 @@ query TII
SELECT data."commit"."collection" AS event, "hour"(epoch(cast(data.time_us as
bigint)/(1000*1000))) as hour_of_day, count(*) AS cnt FROM bluesky WHERE
data.kind = 'commit' AND data."commit"."operation" = 'create' AND
data."commit"."collection" in ('app.bsky.feed.post', 'app.bsky.feed.repost',
'app.bsky.feed.like') GROUP BY event, hour_of_day ORDER BY hour_of_day, event
----
app.bsky.feed.like
-17
+18
3
app.bsky.feed.post
-17
+18
3
app.bsky.feed.repost
-17
+18
1
@@ -89,11 +89,11 @@ query TT
SELECT data.did as user_id, epoch(cast(min(data.time_us) as bigint)/1000000)
as first_post_ts FROM bluesky WHERE data.kind = 'commit' AND
data."commit"."operation" = 'create' AND data."commit"."collection" =
'app.bsky.feed.post' GROUP BY user_id ORDER BY first_post_ts ASC LIMIT 3
----
did:plc:yj3sjq3blzpynh27cumnp5ks
-2024-11-21 17:25:49+01:00
+2024-11-21 18:25:49+02:00
did:plc:l5o3qjrmfztir54cpwlv2eme
-2024-11-21 17:25:49+01:00
+2024-11-21 18:25:49+02:00
did:plc:s4bwqchfzm6gjqfeb6mexgbu
-2024-11-21 17:25:49+01:00
+2024-11-21 18:25:49+02:00
# Q5
query TT
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
