Oct 9, 2025
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000380_task_name_unique.down.sql b/coderd/database/migrations/000380_task_name_unique.down.sql
 DROP INDEX IF EXISTS tasks_owner_id_name_unique_idx;
diff --git a/coderd/database/migrations/000380_task_name_unique.up.sql b/coderd/database/migrations/000380_task_name_unique.up.sql
 CREATEUNIQUE INDEXIF NOT EXISTS tasks_owner_id_name_unique_idxON tasks (owner_id,LOWER(name))WHERE deleted_at ISNULL;
 COMMENT ON INDEX tasks_owner_id_name_unique_idx IS'Index to ensure uniqueness for task owner/name';
diff --git a/coderd/database/querier_test.go b/coderd/database/querier_test.go
 }
 }

 func TestTaskNameUniqueness(t *testing.T) {
 t.Parallel()

 db, _ := dbtestutil.NewDB(t)

 org := dbgen.Organization(t, db, database.Organization{})
 user1 := dbgen.User(t, db, database.User{})
 user2 := dbgen.User(t, db, database.User{})
 template := dbgen.Template(t, db, database.Template{
 OrganizationID: org.ID,
 CreatedBy:      user1.ID,
 })
 tv := dbgen.TemplateVersion(t, db, database.TemplateVersion{
 TemplateID:     uuid.NullUUID{UUID: template.ID, Valid: true},
 OrganizationID: org.ID,
 CreatedBy:      user1.ID,
 })

 taskName := "my-task"

 // Create initial task for user1.
 task1 := dbgen.Task(t, db, database.TaskTable{
 OrganizationID:    org.ID,
 OwnerID:           user1.ID,
 Name:              taskName,
 TemplateVersionID: tv.ID,
 Prompt:            "Test prompt",
 })
 require.NotEqual(t, uuid.Nil, task1.ID)

 tests := []struct {
 name     string
 ownerID  uuid.UUID
 taskName string
 wantErr  bool
 }{
 {
 name:     "duplicate task name same user",
 ownerID:  user1.ID,
 taskName: taskName,
 wantErr:  true,
 },
 {
 name:     "duplicate task name different case same user",
 ownerID:  user1.ID,
 taskName: "MY-TASK",
 wantErr:  true,
 },
 {
 name:     "same task name different user",
 ownerID:  user2.ID,
 taskName: taskName,
 wantErr:  false,
 },
 }

 for _, tt := range tests {
 t.Run(tt.name, func(t *testing.T) {
 t.Parallel()

 ctx := testutil.Context(t, testutil.WaitShort)

 task, err := db.InsertTask(ctx, database.InsertTaskParams{
 OrganizationID:     org.ID,
 OwnerID:            tt.ownerID,
 Name:               tt.taskName,
 TemplateVersionID:  tv.ID,
 TemplateParameters: json.RawMessage("{}"),
 Prompt:             "Test prompt",
 CreatedAt:          dbtime.Now(),
 })
 if tt.wantErr {
 require.Error(t, err)
 } else {
 require.NoError(t, err)
 require.NotEqual(t, uuid.Nil, task.ID)
 require.NotEqual(t, task1.ID, task.ID)
 }
 })
 }
 }

 func TestUsageEventsTrigger(t *testing.T) {
 t.Parallel()

diff --git a/coderd/database/unique_constraint.go b/coderd/database/unique_constraint.go
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		DROP INDEX IF EXISTS tasks_owner_id_name_unique_idx;
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		CREATEUNIQUE INDEXIF NOT EXISTS tasks_owner_id_name_unique_idxON tasks (owner_id,LOWER(name))WHERE deleted_at ISNULL;
		COMMENT ON INDEX tasks_owner_id_name_unique_idx IS'Index to ensure uniqueness for task owner/name';
Original file line number	Diff line number	Diff line change
Expand Up		@@ -7105,6 +7105,88 @@ func TestGetTaskByWorkspaceID(t *testing.T) {
		}
		}

		func TestTaskNameUniqueness(t *testing.T) {
		t.Parallel()

		db, _ := dbtestutil.NewDB(t)

		org := dbgen.Organization(t, db, database.Organization{})
		user1 := dbgen.User(t, db, database.User{})
		user2 := dbgen.User(t, db, database.User{})
		template := dbgen.Template(t, db, database.Template{
		OrganizationID: org.ID,
		CreatedBy: user1.ID,
		})
		tv := dbgen.TemplateVersion(t, db, database.TemplateVersion{
		TemplateID: uuid.NullUUID{UUID: template.ID, Valid: true},
		OrganizationID: org.ID,
		CreatedBy: user1.ID,
		})

		taskName := "my-task"

		// Create initial task for user1.
		task1 := dbgen.Task(t, db, database.TaskTable{
		OrganizationID: org.ID,
		OwnerID: user1.ID,
		Name: taskName,
		TemplateVersionID: tv.ID,
		Prompt: "Test prompt",
		})
		require.NotEqual(t, uuid.Nil, task1.ID)

		tests := []struct {
		name string
		ownerID uuid.UUID
		taskName string
		wantErr bool
		}{
		{
		name: "duplicate task name same user",
		ownerID: user1.ID,
		taskName: taskName,
		wantErr: true,
		},
		{
		name: "duplicate task name different case same user",
		ownerID: user1.ID,
		taskName: "MY-TASK",
		wantErr: true,
		},
		{
		name: "same task name different user",
		ownerID: user2.ID,
		taskName: taskName,
		wantErr: false,
		},
		}

		for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
		t.Parallel()

		ctx := testutil.Context(t, testutil.WaitShort)

		task, err := db.InsertTask(ctx, database.InsertTaskParams{
		OrganizationID: org.ID,
		OwnerID: tt.ownerID,
		Name: tt.taskName,
		TemplateVersionID: tv.ID,
		TemplateParameters: json.RawMessage("{}"),
		Prompt: "Test prompt",
		CreatedAt: dbtime.Now(),
		})
		if tt.wantErr {
		require.Error(t, err)
		} else {
		require.NoError(t, err)
		require.NotEqual(t, uuid.Nil, task.ID)
		require.NotEqual(t, task1.ID, task.ID)
		}
		})
		}
		}

		func TestUsageEventsTrigger(t *testing.T) {
		t.Parallel()

Expand Down