~drizzle-trunk/drizzle/development

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'myisam_key_cache_size' at line 1

365

SELECT @@global.session.myisam_key_cache_size;

366

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'myisam_key_cache_size' at line 1

367

SELECT @@global.local.myisam_key_cache_size;

368

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'myisam_key_cache_size' at line 1

330

369

create temporary table t1 (

331

370

c1 int,

332

371

c2 int,

336

375

show create table t1;

337

376

Table Create Table

338

377

t1 CREATE TEMPORARY TABLE `t1` (

339

`c1` INT DEFAULT NULL,

340

`c2` INT DEFAULT NULL,

341

`c3` INT DEFAULT NULL,

342

`c4` INT DEFAULT NULL,

343

`c5` BIGINT DEFAULT NULL

344

) ENGINE=MyISAM COLLATE = utf8_general_ci

378

`c1` int DEFAULT NULL,

379

`c2` int DEFAULT NULL,

380

`c3` int DEFAULT NULL,

381

`c4` int DEFAULT NULL,

382

`c5` bigint DEFAULT NULL

383

) ENGINE=MyISAM

345

384

drop table t1;

346

385

set @arg00= 8, @arg01= 8.8, @arg02= 'a string', @arg03= 0.2e0;

347

386

create temporary table t1 as select @arg00 as c1, @arg01 as c2, @arg02 as c3, @arg03 as c4;

348

387

show create table t1;

349

388

Table Create Table

350

389

t1 CREATE TEMPORARY TABLE `t1` (

351

`c1` BIGINT DEFAULT NULL,

352

`c2` DECIMAL(65,30) DEFAULT NULL,

353

`c3` TEXT COLLATE utf8_general_ci,

354

`c4` DOUBLE DEFAULT NULL

355

) ENGINE=MyISAM COLLATE = utf8_general_ci

390

`c1` bigint DEFAULT NULL,

391

`c2` decimal(65,30) DEFAULT NULL,

392

`c3` text,

393

`c4` double DEFAULT NULL

394

) ENGINE=MyISAM

356

395

drop table t1;

357

396

SET GLOBAL table_open_cache=-1;

358

397

Warnings:

533

572

End of 5.0 tests

534

573

set global flush_time =@my_flush_time;

535

574

ERROR HY000: Unknown system variable 'flush_time'

575

set global myisam_key_cache_size =@my_myisam_key_cache_size;

536

576

set global max_connect_errors =@my_max_connect_errors;

537

577

set global max_heap_table_size =@my_max_heap_table_size;

538

578

set global max_join_size =@my_max_join_size;

539

579

set global max_write_lock_count =default;

580

set global myisam_data_pointer_size =@my_myisam_data_pointer_size;

581

ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'

540

582

set global mysql_protocol_buffer_length= @my_mysql_protocol_buffer_length;

541

583

set global server_id =@my_server_id;

542

584

set global storage_engine =@my_storage_engine;

543

585

set global thread_cache_size =@my_thread_cache_size;

544

586

ERROR HY000: Unknown system variable 'thread_cache_size'

545

587

set global myisam_sort_buffer_size =@my_myisam_sort_buffer_size;

546

SHOW GLOBAL VARIABLES LIKE 'max_join_size';

547

Variable_name Value

548

max_join_size 2147483647

549

SHOW LOCAL VARIABLES LIKE 'max_join_size';

550

Variable_name Value

551

max_join_size 100

552

set GLOBAL bulk_insert_buffer_size=DEFAULT;

553

set GLOBAL join_buffer_size=DEFAULT;

554

set GLOBAL max_allowed_packet=DEFAULT;

555

set GLOBAL max_connect_errors=DEFAULT;

556

set GLOBAL max_heap_table_size=DEFAULT;

557

set GLOBAL max_join_size=DEFAULT;

558

set GLOBAL max_sort_length=DEFAULT;

559

set GLOBAL max_write_lock_count=DEFAULT;

560

set GLOBAL myisam_sort_buffer_size=DEFAULT;

561

set GLOBAL mysql_protocol_buffer_length=DEFAULT;

562

set GLOBAL read_buffer_size=DEFAULT;

563

set GLOBAL read_rnd_buffer_size=DEFAULT;

564

set GLOBAL server_id=DEFAULT;

565

set GLOBAL sort_buffer_size=DEFAULT;

566

set GLOBAL table_open_cache=DEFAULT;

567

set GLOBAL storage_engine= @my_storage_engine;

568

set GLOBAL tmp_table_size=DEFAULT;

569

set GLOBAL tx_isolation= @my_tx_isolation;

570

set SESSION bulk_insert_buffer_size=DEFAULT;

571

set SESSION join_buffer_size=DEFAULT;

572

set SESSION max_allowed_packet=DEFAULT;

573

set SESSION max_heap_table_size=DEFAULT;

574

set SESSION max_join_size=DEFAULT;

575

set SESSION max_sort_length=DEFAULT;

576

set SESSION read_buffer_size=DEFAULT;

577

set SESSION read_rnd_buffer_size=DEFAULT;

578

set SESSION sort_buffer_size=DEFAULT;

579

set SESSION sql_big_selects=DEFAULT;

580

set SESSION sql_buffer_result=DEFAULT;

581

set SESSION sql_select_limit=DEFAULT;

582

set SESSION sql_warnings=DEFAULT;

583

set SESSION storage_engine= @my_storage_engine;

584

set SESSION tmp_table_size=DEFAULT;

585

set SESSION tx_isolation= @my_tx_isolation;

586

588

show global variables where variable_name='table_definition_cache' or Variable_name='table_lock_wait_timeout';

587

589

Variable_name Value

588

590

table_definition_cache #

Older »