diff options
| author | mskold@mysql.com <> | 2004-09-26 17:11:28 +0200 |
|---|---|---|
| committer | mskold@mysql.com <> | 2004-09-26 17:11:28 +0200 |
| commit | f29939c453bdbb31e16c64ad0c4f7a3d09cc7f34 (patch) | |
| tree | 9f479b367e09b656d0a5187216cbef3e008bb33d /mysql-test/r/ndb_alter_table.result | |
| parent | 2027459cce7a32fadc9ec8f1e2b67ab903cea974 (diff) | |
| download | mariadb-git-f29939c453bdbb31e16c64ad0c4f7a3d09cc7f34.tar.gz | |
Setting MODE_NO_AUTO_VALUE_ON_ZERO at copying in copy_data_between_tables
Diffstat (limited to 'mysql-test/r/ndb_alter_table.result')
| -rw-r--r-- | mysql-test/r/ndb_alter_table.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_alter_table.result b/mysql-test/r/ndb_alter_table.result index a36536b878d..897fa77185d 100644 --- a/mysql-test/r/ndb_alter_table.result +++ b/mysql-test/r/ndb_alter_table.result @@ -72,6 +72,21 @@ col6 col1 col3 fourth col4 col4_5 col5 col7 col8 1 100 3 4 5 PENDING 0000-00-00 00:00:00 1 101 3 4 5 PENDING 0000-00-00 00:00:00 2 102 4 3 5 99 PENDING EXTRA 2004-01-01 00:00:00 +delete from t1; +insert into t1 values (0,0,4,3,5,99,"PENDING","EXTRA",'2004-01-01 00:00:00'); +SET SQL_MODE=''; +insert into t1 values (1,0,4,3,5,99,"PENDING","EXTRA",'2004-01-01 00:00:00'); +select * from t1 order by col1; +col6 col1 col3 fourth col4 col4_5 col5 col7 col8 +0 0 4 3 5 99 PENDING EXTRA 2004-01-01 00:00:00 +1 103 4 3 5 99 PENDING EXTRA 2004-01-01 00:00:00 +alter table t1 drop column col4_5; +insert into t1 values (2,0,4,3,5,"PENDING","EXTRA",'2004-01-01 00:00:00'); +select * from t1 order by col1; +col6 col1 col3 fourth col4 col5 col7 col8 +0 0 4 3 5 PENDING EXTRA 2004-01-01 00:00:00 +1 103 4 3 5 PENDING EXTRA 2004-01-01 00:00:00 +2 104 4 3 5 PENDING EXTRA 2004-01-01 00:00:00 drop table t1; CREATE TABLE t1 ( a INT NOT NULL, |