~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

• browse files at revision 2023.3.10
• compare with another revision
• download diff
• download tarball
• view history from revision 2023.3.10

• reverse the comparison (2023.3.10 to 2165.1.3)
• stop comparing with revision 2165.1.3

Show diffs side-by-side

added

removed

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 ER_INVALID_ALTER_TABLE_FOR_NOT_NULL

 

6

--error 1714

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 ER_WARN_DATA_TRUNCATED

 

17

--error 1265

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;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1