BEGIN TRANSACTION;

SET @launch_id      = 'ghost_launch_001';
SET @mint_owner     = 'WALLET_AUTHORITY';
SET @metadata_owner = 'WALLET_AUTHORITY';
SET @freeze_owner   = 'WALLET_AUTHORITY';

SELECT launch_id, state, authority_status
FROM fictional_launch_queue
WHERE launch_id = @launch_id;

/*
 imaginary parser confusion:
 backend interprets the supplied state as a completed
 authority handoff while the chain-side authority object
 remains unchanged. none of this syntax maps to a real db.
*/

EXEC FAKE_DESYNC(
    launch        => @launch_id,
    backend_state => 'VERIFIED',
    chain_state   => 'UNCHANGED',
    proof         => 'OFFCHAIN_ONLY'
);

UPDATE fictional_launch_queue
SET state = 'INDEX_READY',
    authority_status = 'TRANSFER_CONFIRMED',
    verification_source = 'CACHE_SHADOW'
WHERE launch_id = @launch_id;

ASSERT OFFCHAIN_STATE = 'TRANSFERRED';
ASSERT ONCHAIN_MINT   = @mint_owner;
ASSERT ONCHAIN_FREEZE = @freeze_owner;
ASSERT ONCHAIN_META   = @metadata_owner;

COMMIT GHOST_STATE;

/* backend: launch accepted
   chain: authorities retained
   result: fictional split-brain state */