You are an expert in writing code in many different languages. Your goal is to perform code completion for the following code, keeping in mind the rest of the code and the file meta data.
    Metadata details:
    filename: tenant_test.go
    path of file: ./repos/cockroach/pkg/sql
    
    the code of the file until where you have to start completion: // Copyright 2020 The Cockroach Authors.
//
// Use of this software is governed by the Business Source License
// included in the file licenses/BSL.txt.
//
// As of the Change Date specified in that file, in accordance with
// the Business Source License, use of this software will be governed
// by the Apache License, Version 2.0, included in the file
// licenses/APL.txt.

package sql_test

import (
	"con
    
func TestGetTenantIds(t *testing.T) {
	defer leaktest.AfterTest(t)()
	defer log.Scope(t).Close(t)
	ctx := context.Background()
	s, sqlDB, _ := serverutils.StartServer(t, base.TestServerArgs{})
	defer s.Stopper().Stop(ctx)
	idb := s.ExecutorConfig().(sql.ExecutorConfig).InternalDB
	tdb := sqlutils.MakeSQLRunner(sqlDB)

	// Create 2 tenants in addition to the system tenant.
	tdb.Exec(t, "CREATE TENANT t1")
	tdb.Exec(t, "CREATE TENANT t2")

	var ids []roachpb.TenantID
	require.NoError(t, idb.Txn(ctx, func(ctx context.Context, txn isql.Txn) (err error) {
		ids, err = sql.GetAllNonDropTenantIDs(ctx, txn, s.ClusterSettings())
		return err
	}))
	expectedIds := []roachpb.TenantID{
		roachpb.MustMakeTenantID(1),
		roachpb.MustMakeTenantID(2),
		roachpb.MustMakeTenantID(3),
	}
	require.Equal(t, expectedIds, ids)

	// Drop tenant 2.
	tdb.Exec(t, "DROP TENANT t1")

	require.NoError(t, idb.Txn(ctx, func(ctx context.Context, txn isql.Txn) (err error) {
		ids, err = sql.GetAllNonDropTenantIDs(ctx, txn, s.ClusterSettings())
		return err
	}))
	expectedIds = []roachpb.TenantID{
		roachpb.MustMakeTenantID(1),
		roachpb.MustMakeTenantID(3),
	}
	require.Equal(t, expectedIds, ids)
}