| 1 | package sessioncatalog |
| 2 | |
| 3 | const metadataTopicIndex = `CREATE INDEX IF NOT EXISTS idx_catalog_topics_registered_metadata |
| 4 | ON catalog_topics(scope,workspace_root_key,topic_id) WHERE metadata_present=1` |
| 5 | |
| 6 | const registeredMetadataTopics = `SELECT scope,workspace_root,workspace_root_key,topic_id |
| 7 | FROM catalog_topics INDEXED BY idx_catalog_topics_registered_metadata WHERE metadata_present=1` |
| 8 | |
| 9 | const orphanMetadataPredicate = `metadata_present=0 AND NOT EXISTS ( |
| 10 | SELECT 1 FROM catalog_sessions s WHERE s.scope=catalog_topics.scope |
| 11 | AND s.workspace_root_key=catalog_topics.workspace_root_key AND s.topic_id=catalog_topics.topic_id)` |
| 12 |