Dune
Create
Log in / Sign up
Home
Bugs
44
Create a Post
Category
Select Category
Title
Details
Create Post
Powered by Canny
1
ROUND function bug
select ROUND(100 * 0.1 / 100, 2) UNION select ROUND(100 * 0.01 / 100, 2) UNION select ROUND(100 * 212 / 391, 2) in dune v2 result is 54 0.01 0.1 in spark v2 result is 54.22 0.1 0.01 in dune v2 lost .22
0
4
Bitcoin output address is null
The output address for Bitcoin transactions are null for both bitcoin.transactions and bitcoin.outputs .
0
2
Counter not showing 0 as value
If the result of the query has a column with a value of 0 and if the counter visualization is mapped to that column, then the counter does not show the value as 0. Query: https://dune.com/queries/2027599
0
3
Tooltip for Barchart in wrong order
In bar charts the tooltip is shown falsely in reverse order. See screenshot (taken from https://dune.com/umer_h_adil/good-degen ) for an example.
2
3
Polygon V2 (Spark SQL) `miner` & `nonce`
polygon.block has zeros in the miner and nonce columns.
1
1
Optimism.logs showing wrong topics2 & 3 in Spark SQL Dune V2
The table is showing additional "0"s in these topic, for example it's showing "0x0000000000000000000000000f5d59575510b75fef61315b76f315544fb521d3" instead of "0x0f5d59575510b75fef61315b76f315544fb521d3"
0
2
Missing Optimism ERC20 Transfers in Dune V2
Found erc20 token transfers for tokens on etherscan, but not in Dune. Example: https://optimistic.etherscan.io/tx/0xa1a3ad2ac040c2d94d54098f0228c99b3a6776063e739964d067f8a3e75dd8b3 ''' SELECT evt_tx_hash FROM erc20_optimism.evt_Transfer WHERE contract_address = lower('0x6ab707Aca953eDAeFBc4fD23bA73294241490620') AND evt_tx_hash = '0xa1a3ad2ac040c2d94d54098f0228c99b3a6776063e739964d067f8a3e75dd8b3' ''' Returns null
0
1
[dex.trades] amount_usd of Curve trades is wrong on table
It seems to use wrong decimals to calculate amount of token. In this case, we should use 1e18 rather than 1e6 (decimals of USDC.e). Query: select * from dex.trades where tx_hash = '0xc6a1e3aeb0ac646b37efb5f2941ff96ea807363f697b5e4b6dc289870872d79e' Link for using: https://snowtrace.io/tx/0xc6a1e3aeb0ac646b37efb5f2941ff96ea807363f697b5e4b6dc289870872d79e https://snowtrace.deth.net/address/0x6bf6fc7eaf84174bb7e1610efd865f0ebd2aa96d
0
5
Error: Failed to Fetch
I am getting this error all the time now. Used to be occasionally. Now its at least 20 times a day
7
1
Parameters Don't Hold Position on Dashboard Update
When I save a layout on a dashboard, parameters often float back up to the top, or become placed randomly along the dashboard. Steps to reproduce: Dashboard > Edit Move Parameters Done
3
Load More
→
Powered by Canny