summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_autodiscover.result
diff options
context:
space:
mode:
authorunknown <msvensson@neptunus.(none)>2005-06-22 14:10:02 +0200
committerunknown <msvensson@neptunus.(none)>2005-06-22 14:10:02 +0200
commit4db138f91a04619f6c53ece45f3b143e633a7566 (patch)
treee53068db54e844c159cf1431067a242ef99c4ed2 /mysql-test/r/ndb_autodiscover.result
parent73ea278f6a44f2840a6784a9c856520090aef159 (diff)
parent19f51d3fa50e1ffda7e25eabc879b63627920a81 (diff)
downloadmariadb-git-4db138f91a04619f6c53ece45f3b143e633a7566.tar.gz
Merged from mysql-4.1 to mysql-5.0
client/mysqltest.c: Auto merged mysql-test/mysql-test-run.sh: Auto merged mysql-test/t/ndb_autodiscover.test: Auto merged sql/ha_ndbcluster.h: Auto merged sql/item_strfunc.cc: Auto merged client/mysqldump.c: Merge from 4.1 to 5.0 mysql-test/r/ndb_autodiscover.result: Merge ndb/test/ndbapi/create_tab.cpp: Merge sql/ha_ndbcluster.cc: Merge sql/handler.cc: Merge sql/handler.h: Merge sql/sql_base.cc: Merge sql/sql_table.cc: Merge
Diffstat (limited to 'mysql-test/r/ndb_autodiscover.result')
-rw-r--r--mysql-test/r/ndb_autodiscover.result20
1 files changed, 17 insertions, 3 deletions
diff --git a/mysql-test/r/ndb_autodiscover.result b/mysql-test/r/ndb_autodiscover.result
index 27ebda36669..fb1fae7809c 100644
--- a/mysql-test/r/ndb_autodiscover.result
+++ b/mysql-test/r/ndb_autodiscover.result
@@ -93,7 +93,7 @@ name char(20), a int, b float, c char(24)
ERROR 42S01: Table 't3' already exists
show status like 'handler_discover%';
Variable_name Value
-Handler_discover 1
+Handler_discover 0
create table IF NOT EXISTS t3(
id int not null primary key,
id2 int not null,
@@ -101,7 +101,7 @@ name char(20)
) engine=ndb;
show status like 'handler_discover%';
Variable_name Value
-Handler_discover 2
+Handler_discover 0
SHOW CREATE TABLE t3;
Table Create Table
t3 CREATE TABLE `t3` (
@@ -114,7 +114,7 @@ id name
1 Explorer
show status like 'handler_discover%';
Variable_name Value
-Handler_discover 2
+Handler_discover 1
drop table t3;
flush status;
create table t7(
@@ -373,6 +373,20 @@ use test2;
drop table t2;
drop database test2;
use test;
+CREATE TABLE sys.SYSTAB_0 (a int);
+ERROR 42S01: Table 'SYSTAB_0' already exists
+select * from sys.SYSTAB_0;
+ERROR HY000: Failed to open 'SYSTAB_0', error while unpacking from engine
+CREATE TABLE IF NOT EXISTS sys.SYSTAB_0 (a int);
+show warnings;
+Level Code Message
+select * from sys.SYSTAB_0;
+ERROR HY000: Failed to open 'SYSTAB_0', error while unpacking from engine
+drop table sys.SYSTAB_0;
+ERROR 42S02: Unknown table 'SYSTAB_0'
+drop table IF EXISTS sys.SYSTAB_0;
+Warnings:
+Note 1051 Unknown table 'SYSTAB_0'
drop database if exists test_only_ndb_tables;
create database test_only_ndb_tables;
use test_only_ndb_tables;