Function TestNumbersToAny

driver_test.go:408–449

TestNumbers test that selecting numeric columns. Both of textRows and binaryRows should return same type and value.

(t *testing.T)

// TestNumbers test that selecting numeric columns.
// Both of textRows and binaryRows should return same type and value.
func TestNumbersToAny(t *testing.T) {
	runTestsParallel(t, dsn, func(dbt *DBTest, tbl string) {
		dbt.mustExec("CREATE TABLE " + tbl + " (id INT PRIMARY KEY, b BOOL, i8 TINYINT, " +
			"i16 SMALLINT, i32 INT, i64 BIGINT, f32 FLOAT, f64 DOUBLE, iu32 INT UNSIGNED)")
		dbt.mustExec("INSERT INTO " + tbl + " VALUES (1, true, 127, 32767, 2147483647, 9223372036854775807, 1.25, 2.5, 4294967295)")

		// Use binaryRows for interpolateParams=false and textRows for interpolateParams=true.
		rows := dbt.mustQuery("SELECT b, i8, i16, i32, i64, f32, f64, iu32 FROM "+tbl+" WHERE id=?", 1)
		if !rows.Next() {
			dbt.Fatal("no data")
		}
		var b, i8, i16, i32, i64, f32, f64, iu32 any
		err := rows.Scan(&b, &i8, &i16, &i32, &i64, &f32, &f64, &iu32)
		if err != nil {
			dbt.Fatal(err)
		}
		if b.(int64) != 1 {
			dbt.Errorf("b != 1")
		}
		if i8.(int64) != 127 {
			dbt.Errorf("i8 != 127")
		}
		if i16.(int64) != 32767 {
			dbt.Errorf("i16 != 32767")
		}
		if i32.(int64) != 2147483647 {
			dbt.Errorf("i32 != 2147483647")
		}
		if i64.(int64) != 9223372036854775807 {
			dbt.Errorf("i64 != 9223372036854775807")
		}
		if f32.(float32) != 1.25 {
			dbt.Errorf("f32 != 1.25")
		}
		if f64.(float64) != 2.5 {
			dbt.Errorf("f64 != 2.5")
		}
		if iu32.(int64) != 4294967295 {
			dbt.Errorf("iu32 != 4294967295")
		}
	})
}

func TestMultiQuery(t *testing.T) {
	runTestsWithMultiStatement(t, dsn, func(dbt *DBTest) {