Hi, Jan!
How you would detect the difference between no object name given and
object name given, remember that InnoDB does not store the key
identifier (a and b above). Thus the actual foreign key name is
similar to one generated when no key identifier is not given ?
E.g:
alter table t2
Hi, Jan!
Good point!
On Feb 02, Jan Lindström wrote:
Hi,
In my opinion the test case is not complete, you are missing e.g.
ALTER TABLE t2 ADD FOREIGN KEY IF NOT EXISTS (id) REFERENCES t1(id);
-- should fail on warning
ALTER TABLE t2 ADD FOREIGN KEY IF NOT EXISTS (id) REFERENCES t1(id);
Hi,
Hi, Jan!
Good point!
On Feb 02, Jan Lindstrm wrote:
Hi,
In my opinion the test case is not complete, you are missing e.g.
ALTER TABLE t2 ADD FOREIGN KEY IF NOT EXISTS (id) REFERENCES t1(id);
-- should fail on warning
ALTER TABLE t2 ADD FOREIGN KEY
Hi,
In my opinion the test case is not complete, you are missing e.g.
ALTER TABLE t2 ADD FOREIGN KEY IF NOT EXISTS (id) REFERENCES t1(id);
-- should fail on warning
ALTER TABLE t2 ADD FOREIGN KEY IF NOT EXISTS (id) REFERENCES t1(id);
ALTER TABLE t2 ADD FOREIGN
4 matches
Mail list logo