By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
col1 | col2 |
---|---|
1 | 2 |
3 | 4 |
1 | 5 |
1 | 2 |
Level | Code | Message |
---|---|---|
Warning | 1365 | Division by 0 |
Warning | 1365 | Division by 0 |
col1 | col2 | colA | colB |
---|---|---|---|
1 | 2 | 2 | a |
3 | 4 | 4 | b |
1 | 2 | 2 | a |
EXPLAIN |
---|
-> Filter: ((T1.colA / T.col1) > 0) (cost=1.00 rows=0) (actual time=0.047..0.061 rows=3 loops=1) -> Inner hash join (T.col2 = T1.colA) (cost=1.00 rows=0) (actual time=0.039..0.051 rows=3 loops=1) -> Filter: (T.col1 <> 0) (cost=0.23 rows=1) (actual time=0.006..0.015 rows=4 loops=1) -> Table scan on T (cost=0.23 rows=6) (actual time=0.004..0.012 rows=6 loops=1) -> Hash -> Table scan on T1 (cost=0.45 rows=2) (actual time=0.015..0.019 rows=2 loops=1) |