Documentation Home
MySQL Internals Manual


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
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.