Documentation Home
MySQL Internals Manual
Download this Manual
EPUB - 1.2Mb


MySQL Internals Manual  /  ...  /  Probably Mismatch of Focus of Test and Code Sequence

26.8.1 Probably Mismatch of Focus of Test and Code Sequence

CREATE TABLE t1 (
  id INT NOT NULL AUTO_INCREMENT,
  my_column VARCHAR(30),
  name LONGTEXT,
  PRIMARY KEY (id));
INSERT INTO t1(my_column,name) VALUES('2','two');
INSERT INTO t1(my_column,name) VALUES('1','one');
INSERT INTO t1(my_column,name) VALUES('4','four');
INSERT INTO t1(my_column,name) VALUES('2','two');
INSERT INTO t1(my_column,name) VALUES('3','three');

This test will

  • fail if the feature AUTO_INCREMENT is temporary broken

  • will (depending on existence of prerequisite checks) fail or get skipped if the default storage engine does not support AUTO_INCREMENT or LONGTEXT

==> no coverage for other features or properties checked within this test

Some questions with recommended action depending on the answer:

  • Is the table t1 just an auxiliary table and not the test object?

Yes: Please ensure that the test does not break or gets skipped if the default storage engine does not support AUTO_INCREMENT or LONGTEXT and you are done.

No: no action

  • Do we check AUTO_INCREMENT and the corresponding column is t1.id?

Yes: no action

No: Remove the use of AUTO_INCREMENT

  • Do we check LONGTEXT and the corresponding column is t1.name?

Yes: no action

No: Remove the use of LONGTEXT

  • Do we check AUTO_INCREMENT and LONGTEXT in combination?

Yes: no action

No: Split the test at least if it should be a test of basic functionality


User Comments
Sign Up Login You must be logged in to post a comment.