create database if not exists testing;
use testing;

drop table if exists ndb_test_unique;

create table ndb_test_unique
(
     FIRST                           INT NOT NULL
) engine=NDB;

CREATE UNIQUE INDEX ndb_test_unique_idx ON ndb_test_unique (FIRST);
# Will fail
insert into ndb_test_unique values (1);

drop table if exists ndb_test_unique;

create table ndb_test_unique
(
     FIRST                           INT NOT NULL
) engine=NDB;

ALTER TABLE ndb_test_unique ADD UNIQUE INDEX (FIRST);
# Will fail
insert into ndb_test_unique values (1);


drop table if exists ndb_test_unique;

create table ndb_test_unique
(
     FIRST                           INT NOT NULL,
     UNIQUE KEY (FIRST)
) engine=NDB;
# Will not fail
insert into ndb_test_unique values (1);

drop table if exists ndb_test_unique;

create table ndb_test_unique
(
     FIRST                           INT
) engine=NDB;

CREATE UNIQUE INDEX ndb_test_unique_idx ON ndb_test_unique (FIRST);
# Will not fail
insert into ndb_test_unique values (1);

drop table if exists ndb_test_unique;

create table ndb_test_unique
(
     FIRST                           INT NOT NULL,
     SECOND                          INT NOT NULL
) engine=NDB;

CREATE UNIQUE INDEX ndb_test_unique_idx ON ndb_test_unique (FIRST);
ALTER TABLE ndb_test_unique ADD PRIMARY KEY (SECOND);
# Will not fail
insert into ndb_test_unique values (1,1);