diff options
| author | unknown <venu@myvenu.com> | 2003-01-07 18:59:08 -0800 |
|---|---|---|
| committer | unknown <venu@myvenu.com> | 2003-01-07 18:59:08 -0800 |
| commit | db67a2ee6149b16c4976ddd510e62d35c6eb8a9f (patch) | |
| tree | 0037dc5a0037e6dd01c3bb6cb7e38ad591e558ba /mysql-test/r/warnings.result | |
| parent | e3494520c9d88a8b44b6237cfdb141fd85760c7f (diff) | |
| download | mariadb-git-db67a2ee6149b16c4976ddd510e62d35c6eb8a9f.tar.gz | |
Simple misc cases - warnings
Diffstat (limited to 'mysql-test/r/warnings.result')
| -rw-r--r-- | mysql-test/r/warnings.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/warnings.result b/mysql-test/r/warnings.result index 06be16aad48..f2a105827da 100644 --- a/mysql-test/r/warnings.result +++ b/mysql-test/r/warnings.result @@ -13,3 +13,20 @@ set SQL_WARNINGS=0; drop temporary table if exists not_exists; Warnings: Note 1051 Unknown table 'not_exists' +drop table if exists not_exists_table; +Warnings: +Note 1051 Unknown table 'not_exists_table' +show warnings limit 1; +Level Code Message +Note 1051 Unknown table 'not_exists_table' +drop database if exists not_exists_db; +Warnings: +Note 1008 Can't drop database 'not_exists_db'. Database doesn't exist +show count(*) warnings; +@@session.warning_count +1 +create table t1(id int); +create table if not exists t1(id int); +select @@warning_count; +@@warning_count +0 |