@@ -282,6 +282,27 @@ it.effect("routes full projection reads to readers and retains uncommitted write
282282 forkedFrom : { type : "run" , threadId : parentId , runId : parent . runs [ 0 ] ! . id } ,
283283 } ,
284284 } ) ;
285+ const messageId = MessageId . make ( "message:reader-routing" ) ;
286+ yield * store . apply ( {
287+ id : EventId . make ( "event:reader-routing:message" ) ,
288+ type : "message.updated" ,
289+ threadId,
290+ occurredAt : parent . thread . createdAt ,
291+ payload : {
292+ id : messageId ,
293+ threadId,
294+ runId : null ,
295+ nodeId : null ,
296+ role : "user" ,
297+ text : "Committed message" ,
298+ attachments : [ ] ,
299+ streaming : false ,
300+ createdBy : "user" ,
301+ creationSource : "web" ,
302+ createdAt : parent . thread . createdAt ,
303+ updatedAt : parent . thread . createdAt ,
304+ } ,
305+ } ) ;
285306 const { queries, trace } = traceSqlRouting ( ) ;
286307 yield * store . getAgentAwarenessSnapshot ( ) . pipe ( trace ) ;
287308 const projection = yield * store . getThreadProjection ( threadId ) . pipe ( trace ) ;
@@ -292,6 +313,10 @@ it.effect("routes full projection reads to readers and retains uncommitted write
292313 . map ( ( row ) => row . sourceItemId ) ,
293314 parent . turnItems . map ( ( item ) => item . id ) ,
294315 ) ;
316+ assert . equal (
317+ ( yield * store . getMessagesById ( threadId , [ messageId ] ) . pipe ( trace ) ) . get ( messageId ) ?. text ,
318+ "Committed message" ,
319+ ) ;
295320 assert . isAbove ( queries . length , 1 ) ;
296321 assert . deepEqual ( [ ...new Set ( queries . map ( ( row ) => row . connection ) ) ] , [ "reader" ] ) ;
297322 const commitRequested = yield * Deferred . make < void > ( ) ;
@@ -343,6 +368,15 @@ it.effect("routes full projection reads to readers and retains uncommitted write
343368 SET payload_json = json_set(payload_json, '$.title', 'Uncommitted title')
344369 WHERE thread_id = ${ threadId }
345370 ` ;
371+ yield * sql `
372+ UPDATE orchestration_v2_projection_messages
373+ SET payload_json = json_set(payload_json, '$.text', 'Uncommitted message')
374+ WHERE message_id = ${ messageId }
375+ ` ;
376+ assert . equal (
377+ ( yield * store . getMessagesById ( threadId , [ messageId ] ) ) . get ( messageId ) ?. text ,
378+ "Uncommitted message" ,
379+ ) ;
346380 assert . equal (
347381 ( yield * store . getAgentAwarenessSnapshot ( ) ) . threads . find (
348382 ( thread ) => thread . id === threadId ,
@@ -2638,10 +2672,28 @@ it.layer(layerTest)("ProjectionStoreV2", (it) => {
26382672 ) ;
26392673 yield * insertMessageItem ( "null-id" , threadId , - 2 , null ) ;
26402674 yield * insertMessageItem ( "missing-id" , threadId , - 3 , undefined ) ;
2675+ const absentMessageId = MessageId . make ( "message:bounded-sql-history:absent" ) ;
2676+ const messageReadTrace = traceSqlStatements ( ) ;
2677+ const selected = yield * projectionStore
2678+ . getMessagesById ( threadId , [ firstMessageId , lastMessageId , firstMessageId , absentMessageId ] )
2679+ . pipe ( Effect . withTracer ( messageReadTrace . tracer ) ) ;
2680+ assert . isFalse ( messageReadTrace . statements . some ( ( query ) => query . includes ( "turn_items" ) ) ) ;
2681+ assert . equal ( selected . size , 2 ) ;
2682+ assert . equal ( selected . get ( firstMessageId ) ?. id , firstMessageId ) ;
2683+ assert . equal ( selected . get ( lastMessageId ) ?. id , lastMessageId ) ;
2684+ assert . isFalse ( selected . has ( absentMessageId ) ) ;
2685+ assert . equal ( ( yield * projectionStore . getMessagesById ( threadId , [ ] ) ) . size , 0 ) ;
2686+ assert . equal (
2687+ ( yield * projectionStore . getMessagesById ( ThreadId . make ( "other-thread" ) , [ firstMessageId ] ) )
2688+ . size ,
2689+ 0 ,
2690+ ) ;
26412691 const readMessageIds = ( filter ?: ProjectionStore . ProjectionRecordFilter ) =>
26422692 projectionStore
26432693 . getThreadRecords ( threadId , [ "messages" ] , filter )
26442694 . pipe ( Effect . map ( ( { messages } ) => messages . map ( ( message ) => message . id ) ) ) ;
2695+ const canonical = yield * projectionStore . getThreadRecords ( threadId , [ "messages" ] ) ;
2696+ for ( const message of canonical . messages ) assert . deepEqual ( selected . get ( message . id ) , message ) ;
26452697 assert . deepEqual ( yield * readMessageIds ( ) , [ lastMessageId , firstMessageId ] ) ;
26462698 assert . deepEqual ( yield * readMessageIds ( { messageRoles : [ "user" , "assistant" ] } ) , [
26472699 lastMessageId ,
0 commit comments