package systemtables

import (
	"testing"

	"github.com/everything-on-mysql/cassandra-on-mysql/pkg/mysqlbackend"
)

func TestColumnKindRegularPosition(t *testing.T) {
	table := &SystemTable{
		PartitionKeys:  []string{"id"},
		ClusteringKeys: []string{"ts"},
	}

	kind, position, order := columnKind(table, "name")
	if kind != "regular" || position != -1 || order != "NONE" {
		t.Fatalf("unexpected regular column metadata: kind=%s position=%d order=%s", kind, position, order)
	}
}

func TestColumnKindForMySQLRegularPosition(t *testing.T) {
	pk := []mysqlbackend.IndexInfo{
		{Column: "id", IsPrimary: true},
		{Column: "ts", IsPrimary: true},
	}

	kind, position, order := columnKindForMySQL("name", pk)
	if kind != "regular" || position != -1 || order != "NONE" {
		t.Fatalf("unexpected regular column metadata: kind=%s position=%d order=%s", kind, position, order)
	}
}