nhupcd0mbfl7s3lc3h3ld8v0s606fq4j · 2 rows
| type | name | fragment | extra | sql_mode |
|---|---|---|---|---|
| view | blocked_issues | CREATE OR REPLACE VIEW blocked_issues AS WITH done_frozen AS ( SELECT name FROM custom_statuses WHERE category IN ('done', 'frozen') ) SELECT i.*, (SELECT COUNT(*) FROM dependencies d WHERE d.issue_id = i.id AND d.type = 'blocks' AND EXISTS ( SELECT 1 FROM issues blocker WHERE blocker.id = d.depends_on_issue_id AND blocker.status NOT IN ('closed', 'pinned') AND blocker.status NOT IN (SELECT name FROM done_frozen) ) ) as blocked_by_count FROM issues i WHERE i.status NOT IN ('closed', 'pinned') AND i.status NOT IN (SELECT name FROM done_frozen) AND EXISTS ( SELECT 1 FROM dependencies d WHERE d.issue_id = i.id AND d.type = 'blocks' AND EXISTS ( SELECT 1 FROM issues blocker WHERE blocker.id = d.depends_on_issue_id AND blocker.status NOT IN ('closed', 'pinned') AND blocker.status NOT IN (SELECT name FROM done_frozen) ) ) | �{"CreatedAt":0} | NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES |
| view | ready_issues | CREATE OR REPLACE VIEW ready_issues AS WITH RECURSIVE blocked_directly AS ( SELECT DISTINCT d.issue_id FROM dependencies d WHERE d.type = 'blocks' AND EXISTS ( SELECT 1 FROM issues blocker WHERE blocker.id = d.depends_on_issue_id AND blocker.status NOT IN ('closed', 'pinned') ) ), blocked_transitively AS ( SELECT issue_id, 0 as depth FROM blocked_directly UNION ALL SELECT d.issue_id, bt.depth + 1 FROM blocked_transitively bt JOIN dependencies d ON d.depends_on_issue_id = bt.issue_id WHERE d.type = 'parent-child' AND bt.depth < 50 ) SELECT i.* FROM issues i LEFT JOIN blocked_transitively bt ON bt.issue_id = i.id WHERE ( i.status = 'open' OR i.status IN (SELECT name FROM custom_statuses WHERE category = 'active') ) AND (i.ephemeral = 0 OR i.ephemeral IS NULL) AND bt.issue_id IS NULL AND (i.defer_until IS NULL OR i.defer_until <= UTC_TIMESTAMP()) AND NOT EXISTS ( SELECT 1 FROM dependencies d_parent JOIN issues parent ON parent.id = d_parent.depends_on_issue_id WHERE d_parent.issue_id = i.id AND d_parent.type = 'parent-child' AND parent.defer_until IS NOT NULL AND parent.defer_until > UTC_TIMESTAMP() ) | �{"CreatedAt":0} | NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES |