@@ -1984,11 +1984,29 @@ it.layer(layerTest)("ProjectionStoreV2", (it) => {
19841984 payload_json = json_set(payload_json, '$.ordinal', 1000)
19851985 WHERE thread_id = ${ threadId } AND ordinal = 999` ;
19861986 const promptId = TurnItemId . make ( "turn-item:bounded-sql-history:1" ) ;
1987- const deferred = yield * projectionStore . getThreadSnapshotWindow ( threadId , {
1988- rowLimit : sqlPageLimit ,
1989- userTurnLimit : 10 ,
1990- deferWork : true ,
1991- } ) ;
1987+ const { statements : deferredStatements , tracer : deferredTracer } = traceSqlStatements ( ) ;
1988+ const deferred = yield * projectionStore
1989+ . getThreadSnapshotWindow ( threadId , {
1990+ rowLimit : sqlPageLimit ,
1991+ userTurnLimit : 10 ,
1992+ deferWork : true ,
1993+ } )
1994+ . pipe ( Effect . withTracer ( deferredTracer ) ) ;
1995+ const deferredQuery = deferredStatements . find ( ( statement ) =>
1996+ statement . includes ( "blocked_runs AS MATERIALIZED" ) ,
1997+ ) ;
1998+ assert . isDefined ( deferredQuery ) ;
1999+ const deferredPlan = yield * sql . unsafe < {
2000+ readonly id : number ;
2001+ readonly parent : number ;
2002+ readonly detail : string ;
2003+ } > ( `EXPLAIN QUERY PLAN ${ deferredQuery } ` ) ;
2004+ const blockedRunsPlan = deferredPlan . find ( ( row ) => row . detail === "MATERIALIZE blocked_runs" ) ;
2005+ assert . isDefined ( blockedRunsPlan ) ;
2006+ const blockedLookup = deferredPlan . find (
2007+ ( row ) => row . parent === blockedRunsPlan ! . id && row . detail . startsWith ( "SEARCH " ) ,
2008+ ) ;
2009+ assert . include ( blockedLookup ?. detail ?? "" , "run_id=?" ) ;
19922010 assert . lengthOf ( deferred . projection . visibleTurnItems , 3 ) ;
19932011 assert . strictEqual ( deferred . projection . visibleTurnItems [ 0 ] ?. sourceItemId , promptId ) ;
19942012 const anchor = deferred . projection . visibleTurnItems [ 1 ] ! ;
0 commit comments