~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT

2026

NULL test tm1 BASE TABLE NULL NULL NULL # # # # # # # # # # NULL # # Unable to open underlying table which is differently defined or of non-MyISAM ty

2027

Warnings:

2028

Warning 1168 Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

2027

2029

DROP TABLE tm1;

2028

2030

CREATE TABLE t1(C1 INT, C2 INT, KEY C1(C1), KEY C2(C2)) ENGINE=MYISAM;

2029

2031

CREATE TABLE t2(C1 INT, C2 INT, KEY C1(C1), KEY C2(C2)) ENGINE=MYISAM;

2298

2300

id select_type table type possible_keys key key_len ref rows Extra

2299

2301

1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables

2300

2302

DROP TABLE t2, t1;

2303

2304

# Bug#46339 - crash on REPAIR TABLE merge table USE_FRM

2305

2306

DROP TABLE IF EXISTS m1, t1;

2307

CREATE TABLE t1 (c1 INT) ENGINE=MYISAM;

2308

CREATE TABLE m1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1) INSERT_METHOD=LAST;

2309

LOCK TABLE m1 READ;

2310

REPAIR TABLE m1 USE_FRM;

2311

Table Op Msg_type Msg_text

2312

test.m1 repair note The storage engine for the table doesn't support repair

2313

UNLOCK TABLES;

2314

REPAIR TABLE m1 USE_FRM;

2315

Table Op Msg_type Msg_text

2316

test.m1 repair note The storage engine for the table doesn't support repair

2317

DROP TABLE m1,t1;

2318

CREATE TABLE m1 (f1 BIGINT) ENGINE=MRG_MyISAM UNION(t1);

2319

REPAIR TABLE m1 USE_FRM;

2320

Table Op Msg_type Msg_text

2321

test.m1 repair Error Can't open table

2322

test.m1 repair error Corrupt

2323

CREATE TABLE t1 (f1 BIGINT) ENGINE = MyISAM;

2324

REPAIR TABLE m1 USE_FRM;

2325

Table Op Msg_type Msg_text

2326

test.m1 repair note The storage engine for the table doesn't support repair

2327

REPAIR TABLE m1;

2328

Table Op Msg_type Msg_text

2329

test.m1 repair note The storage engine for the table doesn't support repair

2330

DROP TABLE m1, t1;

2331

CREATE TEMPORARY TABLE m1 (f1 BIGINT) ENGINE=MRG_MyISAM UNION(t1);

2332

REPAIR TABLE m1 USE_FRM;

2333

Table Op Msg_type Msg_text

2334

test.m1 repair Error Table 'test.m1' doesn't exist

2335

test.m1 repair error Corrupt

2336

CREATE TEMPORARY TABLE t1 (f1 BIGINT) ENGINE=MyISAM;

2337

REPAIR TABLE m1 USE_FRM;

2338

Table Op Msg_type Msg_text

2339

m1 repair error Cannot repair temporary table from .frm file

2340

REPAIR TABLE m1;

2341

Table Op Msg_type Msg_text

2342

test.m1 repair note The storage engine for the table doesn't support repair

2343

DROP TABLE m1, t1;

2344

2345

# BUG#11763712 - 56458: KILLING A FLUSH TABLE FOR A MERGE/CHILD

2346

# CRASHES SERVER

2347

2348

CREATE TABLE t1(a INT);

2349

CREATE TABLE t2(a INT);

2350

CREATE TABLE t3(a INT, b INT);

2351

CREATE TABLE m1(a INT) ENGINE=MERGE UNION=(t1, t2);

2352

# Test reopen merge parent failure

2353

LOCK TABLES m1 READ;

2354

# Remove 'm1' table using file operations.

2355

FLUSH TABLES;

2356

ERROR 42S02: Table 'test.m1' doesn't exist

2357

UNLOCK TABLES;

2358

CREATE TABLE m1(a INT) ENGINE=MERGE UNION=(t1, t2);

2359

# Test reopen merge child failure

2360

LOCK TABLES m1 READ;

2361

# Remove 't1' table using file operations.

2362

FLUSH TABLES;

2363

ERROR 42S02: Table 'test.t1' doesn't exist

2364

UNLOCK TABLES;

2365

CREATE TABLE t1(a INT);

2366

# Test reattach merge failure

2367

LOCK TABLES m1 READ;

2368

# Replace 't1' with 't3' table using file operations.

2369

FLUSH TABLES;

2370

ERROR HY000: Can't reopen table: 'm1'

2371

UNLOCK TABLES;

2372

DROP TABLE t1, t2, t3, m1;

2301

2373

End of 5.1 tests

Older »