diff options
| author | gluh@gluh.mysql.r18.ru <> | 2005-02-23 20:18:21 +0300 |
|---|---|---|
| committer | gluh@gluh.mysql.r18.ru <> | 2005-02-23 20:18:21 +0300 |
| commit | fc9c20995f63b55db430c812b6296c25b68f8a2b (patch) | |
| tree | 883347b209d106625d806b622a18cbce39b1bb78 /mysql-test/r/warnings.result | |
| parent | 2b5ee94a332c5e97cdb8b642581ddb09743db8b2 (diff) | |
| download | mariadb-git-fc9c20995f63b55db430c812b6296c25b68f8a2b.tar.gz | |
Fix for bug #6572: SHOW ERRORS doesn't
Diffstat (limited to 'mysql-test/r/warnings.result')
| -rw-r--r-- | mysql-test/r/warnings.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/warnings.result b/mysql-test/r/warnings.result index d883feb7ce2..e03d72351d1 100644 --- a/mysql-test/r/warnings.result +++ b/mysql-test/r/warnings.result @@ -1,6 +1,33 @@ drop table if exists t1, t2; SET SQL_WARNINGS=1; create table t1 (a int); +create table t1 (a int); +ERROR 42S01: Table 't1' already exists +show count(*) errors; +@@session.error_count +1 +show errors; +Level Code Message +Error 1050 Table 't1' already exists +show warnings; +Level Code Message +Error 1050 Table 't1' already exists +create table t2(a int) default charset qwerty; +ERROR 42000: Unknown character set: 'qwerty' +show count(*) errors; +@@session.error_count +1 +show errors; +Level Code Message +Error 1115 Unknown character set: 'qwerty' +create table t (i); +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 +show count(*) errors; +@@session.error_count +1 +show errors; +Level Code Message +Error 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 insert into t1 values (1); insert into t1 values ("hej"); Warnings: |