diff options
| author | monty@mishka.local <> | 2004-10-02 22:20:08 +0300 |
|---|---|---|
| committer | monty@mishka.local <> | 2004-10-02 22:20:08 +0300 |
| commit | be4ca46fbe308faa155fade0875fe0edaa408ddd (patch) | |
| tree | 6c0a1c36e51cd1d74e5e4c2f58e89904ff71fb46 /mysql-test/r/insert_select.result | |
| parent | 1fc7e6af85e848813315f8693a660f9783cc11d3 (diff) | |
| download | mariadb-git-be4ca46fbe308faa155fade0875fe0edaa408ddd.tar.gz | |
More fixes for strict mode:
More tests.
Better error messages.
Fixed bug when checking if we updated all needed columns for INSERT.
Give an error if we encounter a wrong float value during parsing.
Don't print DEFAULT for columns without a default value in SHOW CREATE/SHOW FIELDS.
Fixed UPDATE IGNORE when using STRICT mode.
Diffstat (limited to 'mysql-test/r/insert_select.result')
| -rw-r--r-- | mysql-test/r/insert_select.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result index 83e47639fe3..323302128da 100644 --- a/mysql-test/r/insert_select.result +++ b/mysql-test/r/insert_select.result @@ -622,8 +622,8 @@ NULL 2 100 create table t2(No int not null, Field int not null, Count int not null); insert into t2 Select null, Field, Count From t1 Where Month=20030901 and Type=2; Warnings: -Warning 1263 Data truncated; NULL supplied to NOT NULL column 'No' at row 1 -Warning 1263 Data truncated; NULL supplied to NOT NULL column 'No' at row 2 +Warning 1263 Column set to default value; NULL supplied to NOT NULL column 'No' at row 1 +Warning 1263 Column set to default value; NULL supplied to NOT NULL column 'No' at row 2 select * from t2; No Field Count 0 1 100 |