polardbxengine/mysql-test/suite/ndbcluster/table_private_id.test

45 lines
1.0 KiB
Plaintext

--source include/have_ndb.inc
--source include/have_debug.inc
CREATE TABLE t1 (
a int PRIMARY KEY,
b varchar(255)
) ENGINE = NDB;
# Bypass the DD table access checks, a normal user is otherwise
# not allowed to query mysql.tables table, that is the reason this
# test only works in debug compile
--disable_query_log ONCE
SET SESSION debug= '+d,skip_dd_table_access_check';
let $t1_private_id =
`SELECT se_private_id FROM mysql.tables
WHERE NAME = 't1'`;
#echo t1_private_id: $t1_private_id;
if (!$t1_private_id)
{
die No se_private_id set on table t1;
}
let $t1_private_data =
`SELECT se_private_data FROM mysql.tables
WHERE NAME = 't1'`;
#echo t1_private_data: $t1_private_data;
if (!$t1_private_data)
{
die No se_private_data set on table t1;
}
# Check that t1.se_private_data contains object_version=
if (!`select '$t1_private_data' regexp '.*object_version=[0-9]+.*'`)
{
die No object_version property found in t1.se_private_data;
}
--disable_query_log ONCE
SET SESSION debug= '-d,skip_dd_table_access_check';
DROP TABLE t1;