Cannot specify filter using spent_output property about onyx HOT 5 CLOSED

@jbowens Any idea off the top of your head what might cause this?

from onyx.

#440 was intended to restore spent_output to annotated inputs after it had been replaced with spent_output_id in #421. But #440 included no tests for the new functionality. Is it known ever to have worked?

from onyx.

I tried out the filter in 68c85f9 and it works, so it seems that something broke it since then.

from onyx.

I think this slipped through during the filter rewrite. I think the most expedient way to fix this is to add a new column to annotated_inputs that is a nullable jsonb column and update it to be the spent output object. Backfilling the object might be hard. We might need to pull it out of the annotated_txs.data column.

from onyx.

I think we can probably skip the backfill, assuming you're talking about it as a migration step.

from onyx.