| ==== | |
| ---- QUERY: primitive_decimal_arithmetic | |
| -- Description : Query dominated by decimal arithmetic | |
| -- Target test case : Validate and track decimal arithmetic performance . | |
| select | |
| sum(l_quantity * l_tax), sum(l_extendedprice * l_discount) , | |
| sum(l_quantity / l_tax), sum(l_extendedprice / l_discount), | |
| sum(l_quantity + l_tax), sum(l_extendedprice + l_discount) , | |
| sum(l_quantity - l_tax), sum(l_extendedprice - l_discount) | |
| from lineitem where l_tax > 0 and l_discount > 0; | |
| ---- RESULTS | |
| ---- TYPES | |
| ==== |