← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/regression/r/686197.result

  • Committer: Olaf van der Spek
  • Date: 2011-07-24 16:27:12 UTC
  • mfrom: (2371 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2384.
  • Revision ID: olafvdspek@gmail.com-20110724162712-nrut3uifjnu295xs
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/regression/r/686197.result
16
16
Table   Create Table
17
17
t1      CREATE TABLE `t1` (
18
18
  `A` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
19
 
  UNIQUE KEY `A` (`A`)
 
19
  UNIQUE KEY `A` (`A`) USING BTREE
20
20
) ENGINE=InnoDB COLLATE = utf8_general_ci
21
21
ALTER TABLE t1 ADD COLUMN b INT DEFAULT 1 NOT NULL;
22
22
SELECT A,B from t1 ORDER BY A;
44
44
t1      CREATE TABLE `t1` (
45
45
  `A` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
46
46
  `b` INT DEFAULT NULL,
47
 
  UNIQUE KEY `A` (`A`)
 
47
  UNIQUE KEY `A` (`A`) USING BTREE
48
48
) ENGINE=InnoDB COLLATE = utf8_general_ci
49
49
ALTER TABLE t1 MODIFY COLUMN b int DEFAULT 42 NOT NULL;
50
50
SELECT A,B from t1 ORDER BY A;