← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/regression/t/686197.test

  • Committer: Monty Taylor
  • Date: 2011-03-10 18:09:05 UTC
  • mfrom: (2225.2.2 refactor)
  • mto: This revision was merged to the branch mainline in revision 2228.
  • Revision ID: mordred@inaugust.com-20110310180905-ttx05t7q7ff6nl7c
Merge Olad: Refactoring

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/regression/t/686197.test
3
3
CREATE TABLE t1 (A SERIAL);
4
4
INSERT INTO t1 VALUES (), (), ();
5
5
SELECT A from t1 ORDER BY A;
6
 
--error 1714
 
6
--error ER_INVALID_ALTER_TABLE_FOR_NOT_NULL
7
7
ALTER TABLE t1 ADD COLUMN b INT NOT NULL;
8
8
SELECT A from t1 ORDER BY A;
9
9
SHOW CREATE TABLE t1;
14
14
CREATE TABLE t1 (A SERIAL, b int);
15
15
INSERT INTO t1 VALUES (), (), ();
16
16
SELECT A,B from t1 ORDER BY A;
17
 
--error 1265
 
17
--error ER_WARN_DATA_TRUNCATED
18
18
ALTER TABLE t1 MODIFY COLUMN b int not null;
19
19
SELECT A,B from t1 ORDER BY A;
20
20
SHOW CREATE TABLE t1;