| ==== |
| ---- QUERY |
| select * from decimal_encodings; |
| ---- RESULTS |
| 0.00,0.00,0.00 |
| 255.00,255.00,255.00 |
| 65535.00,65535.00,65535.00 |
| 9999999.99,9999999.99,9999999.99 |
| 0.00,9999999999999999.99,999999999999999999999999999999999999.99 |
| -255.00,-255.00,-255.00 |
| -65535.00,-65535.00,-65535.00 |
| -9999999.99,-9999999.99,-9999999.99 |
| 0.00,-9999999999999999.99,-999999999999999999999999999999999999.99 |
| 0.00,0.00,0.00 |
| 255.00,255.00,255.00 |
| 65535.00,65535.00,65535.00 |
| 9999999.99,9999999.99,9999999.99 |
| 0.00,9999999999999999.99,999999999999999999999999999999999999.99 |
| -255.00,-255.00,-255.00 |
| -65535.00,-65535.00,-65535.00 |
| -9999999.99,-9999999.99,-9999999.99 |
| 0.00,-9999999999999999.99,-999999999999999999999999999999999999.99 |
| ---- TYPES |
| DECIMAL,DECIMAL,DECIMAL |
| ==== |
| ---- QUERY |
| select score from decimal_stored_as_int32 |
| ---- RESULTS |
| 12.340 |
| 24.560 |
| 34.123 |
| ---- TYPES |
| DECIMAL |
| ==== |
| ---- QUERY |
| select score from decimal_stored_as_int64 |
| ---- RESULTS |
| 12.3400 |
| 24.5600 |
| 34.1230 |
| ---- TYPES |
| DECIMAL |
| ==== |