diff options
| author | unknown <monty@mysql.com> | 2004-03-19 15:03:12 +0200 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2004-03-19 15:03:12 +0200 |
| commit | 6b465557670093b038cb3d2be930e6a036292192 (patch) | |
| tree | 0f99be402faa607c654e79fea72dffdcff8218f6 /mysql-test/r/system_mysql_db_refs.result | |
| parent | 9935110b30fff7fb79bf3eebdfd310b86474d425 (diff) | |
| download | mariadb-git-6b465557670093b038cb3d2be930e6a036292192.tar.gz | |
Removed \r
Diffstat (limited to 'mysql-test/r/system_mysql_db_refs.result')
| -rw-r--r-- | mysql-test/r/system_mysql_db_refs.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/system_mysql_db_refs.result b/mysql-test/r/system_mysql_db_refs.result index a08b46ffbbb..e15934b03ac 100644 --- a/mysql-test/r/system_mysql_db_refs.result +++ b/mysql-test/r/system_mysql_db_refs.result @@ -17,7 +17,7 @@ insert into test_tables_priv (Host,Db,User,Table_name) values (@name,@name,@name create table test_columns_priv select * from mysql.columns_priv; delete from test_columns_priv; insert into test_columns_priv (Host,Db,User,Table_name,Column_name) values (@name,@name,@name,@name,@name); -select
+select if(isnull(test_db.Host),'WRONG!!!','ok') as test_db_Host,
if(isnull(test_host.Host),'WRONG!!!','ok') as test_host_Host,
if(isnull(test_user.Host),'WRONG!!!','ok') as test_user_Host,
@@ -30,7 +30,7 @@ left join test_tables_priv on test_db.Host=test_tables_priv.Host left join test_columns_priv on test_db.Host=test_columns_priv.Host; test_db_Host test_host_Host test_user_Host test_tables_priv_Host test_columns_priv_Host ok ok ok ok ok -select
+select if(isnull(test_db.Db),'WRONG!!!','ok') as test_db_Db,
if(isnull(test_host.Db),'WRONG!!!','ok') as test_host_Db,
if(isnull(test_tables_priv.Db),'WRONG!!!','ok') as test_tables_priv_Db,
|