Function TestFormatSQLDatum

pkg/ttl/sqlbuilder/sql_test.go:168–391

(t *testing.T)

}

func TestFormatSQLDatum(t *testing.T) {
	// invalid pk types contains the types that should not exist in primary keys of a TTL table.
	// We do not need to check sqlbuilder.FormatSQLDatum for these types
	invalidPKTypes := []struct {
		types []string
		err   *terror.Error
	}{
		{
			types: []string{"json"},
			err:   dbterror.ErrJSONUsedAsKey,
		},
		{
			types: []string{"blob"},
			err:   dbterror.ErrBlobKeyWithoutLength,
		},
		{
			types: []string{"blob(8)"},
			err:   dbterror.ErrBlobKeyWithoutLength,
		},
		{
			types: []string{"text"},
			err:   dbterror.ErrBlobKeyWithoutLength,
		},
		{
			types: []string{"text(8)"},
			err:   dbterror.ErrBlobKeyWithoutLength,
		},
		{
			types: []string{"int", "json"},
			err:   dbterror.ErrJSONUsedAsKey,
		},
		{
			types: []string{"int", "blob"},
			err:   dbterror.ErrBlobKeyWithoutLength,
		},
		{
			types: []string{"int", "text"},
			err:   dbterror.ErrBlobKeyWithoutLength,
		},
		{
			types: []string{"float"},
			err:   dbterror.ErrUnsupportedPrimaryKeyTypeWithTTL,
		},
		{
			types: []string{"double"},
			err:   dbterror.ErrUnsupportedPrimaryKeyTypeWithTTL,
		},
		{
			types: []string{"int", "float"},
			err:   dbterror.ErrUnsupportedPrimaryKeyTypeWithTTL,
		},
		{
			types: []string{"int", "double"},
			err:   dbterror.ErrUnsupportedPrimaryKeyTypeWithTTL,
		},
	}

	cases := []struct {