Merge pull request jmoiron#340 from npiganeau/patch-2

jmoiron · web-flow · commit 9adbc0698d04 · 2018-02-28T00:27:27.000-05:00
[]byte should not be expanded by In
diff --git a/bind.go b/bind.go
@@ -113,7 +113,8 @@ func In(query string, args ...interface{}) (string, []interface{}, error) {
 		v := reflect.ValueOf(arg)
 		t := reflectx.Deref(v.Type())
 
-		if t.Kind() == reflect.Slice {
+		// []byte is a driver.Value type so it should not be expanded
+		if t.Kind() == reflect.Slice && t != reflect.TypeOf([]byte{}) {
 			meta[i].length = v.Len()
 			meta[i].v = v
 
diff --git a/sqlx_test.go b/sqlx_test.go
@@ -1497,6 +1497,9 @@ func TestIn(t *testing.T) {
 		{"SELECT * FROM foo WHERE x in (?)",
 			[]interface{}{[]int{1, 2, 3, 4, 5, 6, 7, 8}},
 			8},
+		{"SELECT * FROM foo WHERE x = ? AND y in (?)",
+			[]interface{}{[]byte("foo"), []int{0, 5, 3}},
+			4},
 	}
 	for _, test := range tests {
 		q, a, err := In(test.q, test.args...)
