Truncated UUIDs in BINARY(16) about go.uuid HOT 4 CLOSED

Some more data (from Ubuntu 16.04 LTS)

Bugged UUIDs are bolded
UUIDs generated within the same transaction are included for context

79CF2018CA11E7A6B67EF825168B4700
79CFA7B018CA11E7A6B67EF825168B47
79CFE78B18CA11E7A6B67EF825168B47
79CFF7C418CA11E7A6B67EF825168B47
79D0080D18CA11E7A6B67EF825168B47

E73A909E18A811E7A6B67EF825168B47
E7029918A811E7A6B67EF825168B4700
E715FD18A811E7A6B67EF825168B4700
E729E518A811E7A6B67EF825168B4700
E73A4818A811E7A6B67EF825168B4700
E74E7B18A811E7A6B67EF825168B4700
E75A114718A811E7A6B67EF825168B47
E75A33DD18A811E7A6B67EF825168B47
E75A9FC418A811E7A6B67EF825168B47
E75ACDC618A811E7A6B67EF825168B47
E75AE77118A811E7A6B67EF825168B47
E75AFB8218A811E7A6B67EF825168B47
E75B19E118A811E7A6B67EF825168B47
E75B2D4518A811E7A6B67EF825168B47
E75B3F8818A811E7A6B67EF825168B47
E75B612418A811E7A6B67EF825168B47
E75B739118A811E7A6B67EF825168B47
E75B972218A811E7A6B67EF825168B47
E75BA97618A811E7A6B67EF825168B47
E75BBDAF18A811E7A6B67EF825168B47
E75BCEC618A811E7A6B67EF825168B47
E75BDE3418A811E7A6B67EF825168B47
E75BF29718A811E7A6B67EF825168B47

466CB10218A911E7A6B67EF825168B47
468F336A18A911E7A6B67EF825168B47
468F4A5618A911E7A6B67EF825168B47
468F8118A911E7A6B67EF825168B4700

1E000BC118AA11E7A6B67EF825168B47
00C9FCD618AE11E7A6B67EF825168B47 // also bugged? not sure
1E255E18AA11E7A6B67EF825168B4700
1E25864018AA11E7A6B67EF825168B47
1E25A10318AA11E7A6B67EF825168B47
1E25C0A118AA11E7A6B67EF825168B47
1E25D52418AA11E7A6B67EF825168B47
1E25E67B18AA11E7A6B67EF825168B47
1E2607F718AA11E7A6B67EF825168B47
1E26264918AA11E7A6B67EF825168B47
1E263EFE18AA11E7A6B67EF825168B47

So far, 12 of my 579 UUIDs have trailing 00's (Just over 2%)

Side note, I have 2/570 UUIDs with a leading 00.
00C9FCD618AE11E7A6B67EF825168B47
00FA63FC18AE11E7A6B67EF825168B47

from go.uuid.

Can it be my sanitizer?

import (
	"database/sql"
	"fmt"

	"github.com/satori/go.uuid"
)

func foo(db *sql.DB) {
	id := uuid.NewV1()
	_, _ := db.Exec(sanitizeSQL("INSERT INTO bar (id, baz) VALUES ('%s', '%s')", id.Bytes(), "baq"))
}

func sanitizeSQL(format string, args ...interface{}) string {
	for i := range args {
		args[i] = sanitizeArg(args[i])
	}
	return fmt.Sprintf(format, args...)
}

func sanitizeArg(v interface{}) interface{} {
	s, ok := v.(string)
	if !ok {
		return v
	}

	// protect vs sql injection
	s = strings.Replace(s, "\\", "\\\\", -1)
	s = strings.Replace(s, "\"", "\\\"", -1)
	s = strings.Replace(s, "'", "\\'", -1)

	return strings.TrimSpace(s)
}

from go.uuid.

Probably solved by methane here

from go.uuid.

@EmperorEarth the problem might be that you are formatting .Bytes() output into %s instead of .String()

from go.uuid.