Function TestOperators

testing/go/operators_test.go:23–4040

(t *testing.T)

)

func TestOperators(t *testing.T) {
	RunScriptsWithoutNormalization(t, []ScriptTest{
		{
			Name: "Addition",
			SetUpScript: []string{
				"SET timezone TO 'UTC';",
			},
			Assertions: []ScriptTestAssertion{
				{
					Query:    `SELECT 1::float4 + 2::float4;`,
					Expected: []sql.Row{{float32(3)}},
				},
				{
					Query:    `SELECT 1::float4 + 2::float8;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float4 + 2::int2;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float4 + 2::int4;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float4 + 2::int8;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float4 + 2::numeric;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float8 + 2::float4;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float8 + 2::float8;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float8 + 2::int2;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float8 + 2::int4;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float8 + 2::int8;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::float8 + 2::numeric;`,
					Expected: []sql.Row{{float64(3)}},
				},
				{
					Query:    `SELECT 1::int2 + 2::float4;`,