github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/int_decimal_arith (about) 1 # Heterogeneous int/decimal arithmetic is valid. 2 3 eval 4 1.1:::decimal + 2:::int 5 ---- 6 3.1 7 8 eval 9 1.1:::decimal - 2:::int 10 ---- 11 -0.9 12 13 eval 14 1.1:::decimal * 2:::int 15 ---- 16 2.2 17 18 eval 19 1.1:::decimal % 2:::int 20 ---- 21 1.1 22 23 eval 24 4.1:::decimal // 2:::int 25 ---- 26 2 27 28 eval 29 1.1:::decimal ^ 2:::int 30 ---- 31 1.21 32 33 eval 34 2:::int + 2.1:::decimal 35 ---- 36 4.1 37 38 eval 39 2:::int - 2.1:::decimal 40 ---- 41 -0.1 42 43 eval 44 2:::int * 2.1:::decimal 45 ---- 46 4.2 47 48 eval 49 2:::int % 2.1:::decimal 50 ---- 51 2.0 52 53 eval 54 4:::int // 2.1:::decimal 55 ---- 56 1 57 58 eval 59 2:::int ^ 2.1:::decimal 60 ---- 61 4.2870938501451726569