<p>The test ada entries was used for testing the redemption of ada from the genesis block (aka AVVM certificate process).</p>

CC BY-SA 4.0
2022-03-29T19:09:06.417Z
Ok cool, so after (if) it's redeemed it is just incorporated into the utxo set
adjuric
CC BY-SA 4.0
2022-03-29T18:37:56.597Z
2022-03-29T18:37:56.597Z
Samuel Leathers
<p>I have been studying utxos on the mainnet and have run into some interesting inconsistencies.</p>
<p>If you run this query against cardano-db-sync's cexplorer database:</p>
<pre><code>select sum(value)
from block 
inner join tx on block.id = tx.block_id 
inner join tx_out on tx.id = tx_out.tx_id
  -- Get genesis block
where epoch_no is null 
  -- Filter &quot;test ada&quot; (idk ctrl f &quot;test ada&quot; here https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/interesting-queries.md)
  -- FYI there is 100,000,000 lovelace worth of &quot;test ada&quot;
  and tx_out.value &lt;&gt; 1000000

----------------------------
3111248464500000000
</code></pre>
<p>You will get 31,112,484,645 Ada which is one ada less than the 31,112,484,646 Ada the <a href="https://cardano.org/genesis/" rel="nofollow noreferrer">Cardano website claims</a> was created in the genesis block.</p>
<p>Any insight behind this single extra Ada would be greatly appreciated!</p>
<p>On that same note, the discrepancy becomes 99 Ada if we don't remove the &quot;Test Ada&quot;. From what I've seen, the &quot;Test Ada&quot; has been incorporated into the utxo set as if it is normal Ada. Really curious as to what's going on here! I'm building tools for measuring Ada distribution over time and would like to be precise about the accounting.</p>
<p>Anddd if you're feeling extra helpful, I don't understand the story behind why <a href="https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/interesting-queries.md#get-historical-utxo-set-for-a-given-timestamp" rel="nofollow noreferrer">outputs are omitted from genesis after the Allegra hard fork</a>.</p>
<p>Sorry for multiple questions, thanks in advance!</p>

<cardano-db-sync><ledger>
Mainnet genesis block output off by 1,000,000 Lovelace + what is the test Ada from mainnet genesis?
# Mainnet genesis block output off by 1,000,000 Lovelace + what is the test Ada from mainnet genesis?

(Asked by: username_0 on 2022-03-29)

I have been studying utxos on the mainnet and have run into some interesting inconsistencies.
If you run this query against cardano-db-sync's cexplorer database:
select sum(value)
from block 
inner join tx on block.id = tx.block_id 
inner join tx_out on tx.id = tx_out.tx_id
  -- Get genesis block
where epoch_no is null 
  -- Filter "test ada" (idk ctrl f "test ada" here https://github.com/input-output-hk/cardano-db-sync/blob/master/doc/interesting-queries.md)
  -- FYI there is 100,000,000 lovelace worth of "test ada"
  and tx_out.value <> 1000000

----------------------------
3111248464500000000

You will get 31,112,484,645 Ada which is one ada less than the 31,112,484,646 Ada the Cardano website claims was created in the genesis block.
Any insight behind this single extra Ada would be greatly appreciated!
On that same note, the discrepancy becomes 99 Ada if we don't remove the "Test Ada". From what I've seen, the "Test Ada" has been incorporated into the utxo set as if it is normal Ada. Really curious as to what's going on here! I'm building tools for measuring Ada distribution over time and would like to be precise about the accounting.
Anddd if you're feeling extra helpful, I don't understand the story behind why outputs are omitted from genesis after the Allegra hard fork.
Sorry for multiple questions, thanks in advance!

**Tags:** cardano-db-sync, ledger

---

## 1 answers

### Answer by username_1 on 2022-03-29. Score: 3

The test ada entries was used for testing the redemption of ada from the genesis block (aka AVVM certificate process).

> **Comments:**
> **username_0**: Ok cool, so after (if) it's redeemed it is just incorporated into the utxo set  

---

