search

near / near-microindexers

9 stars 1 forks source link

Handle transaction hash collisions #31

Open telezhnaya opened 2 years ago

telezhnaya commented 2 years ago

Same story as in https://github.com/near/near-indexer-for-explorer/issues/84

Decided to create almost the same solution

telezhnaya commented 2 years ago 
select * from action_receipts where receipt_id = "7SdPiQwWkXkNsmASztLtgHqhT52CwV19eNKKRezWCLqi";
select * from transactions where transaction_hash = "AUh97Kbbg962AfqnQTnmM7tSSy5rnczZ99xXNjAxkctL";
telezhnaya commented 2 years ago

I created the other solution because SingleStore requires doing so. Now we put all the tx and receipts without the problems, but the second select gives 2 transactions. I guess I want to think about it more.