# Derivate of suite/funcs_1/t/is_tables_ndb.test
#

--source include/have_ndb.inc
# let $engine_type= NDB;
# let $engine_type= myisam;

--disable_abort_on_error

--disable_warnings
DROP DATABASE IF EXISTS mydb;
--enable_warnings
CREATE DATABASE mydb;

eval CREATE TABLE mydb.t_ndb     (f1 VARCHAR(20)) ENGINE = ndb;
eval CREATE TABLE mydb.t_myisam  (f1 VARCHAR(20)) ENGINE = myisam;

###########################################################################

--disable_warnings
DROP DATABASE IF EXISTS db_datadict;
--enable_warnings
CREATE DATABASE db_datadict;

SELECT table_schema, table_name, engine
FROM information_schema.tables
WHERE TABLE_SCHEMA = 'mydb' ORDER BY table_name;

# Create a low privileged user.
# Note: The database db_datadict is just a "home" for the low privileged user
#       and not in the focus of testing.
--error 0,ER_CANNOT_USER
DROP   USER testuser@localhost;
CREATE USER testuser@localhost;
GRANT SELECT ON db_datadict.* TO testuser@localhost;

--echo # Establish connection testuser (user=testuser)
--replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK
connect (testuser,localhost,testuser,,db_datadict);
SELECT USER();

SELECT table_schema, table_name, engine
FROM information_schema.tables
WHERE TABLE_SCHEMA = 'mydb' ORDER BY table_name;
SHOW TABLES FROM mydb; 
SELECT * FROM mydb.t_ndb;
SELECT * FROM mydb.t_myisam;
SELECT * FROM information_schema.columns WHERE TABLE_SCHEMA = 'mydb';

--echo # Switch to connection default and close connection testuser
connection default;
disconnect testuser;
DROP USER testuser@localhost;
DROP DATABASE db_datadict;
DROP DATABASE mydb;