~drizzle-trunk/drizzle/development

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

632

set GLOBAL global.key_buffer_size= 1;

633

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

634

SELECT @@global.global.key_buffer_size;

635

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

636

SELECT @@global.session.key_buffer_size;

637

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

638

SELECT @@global.local.key_buffer_size;

639

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

640

set @tstlw = @@log_warnings;

641

show global variables like 'log_warnings';

642

Variable_name Value

643

log_warnings 1

644

select * from information_schema.global_variables where variable_name like 'log_warnings';

645

VARIABLE_NAME VARIABLE_VALUE

646

LOG_WARNINGS 1

647

set global log_warnings = 0;

648

show global variables like 'log_warnings';

649

Variable_name Value

650

log_warnings 0

651

select * from information_schema.global_variables where variable_name like 'log_warnings';

652

VARIABLE_NAME VARIABLE_VALUE

653

LOG_WARNINGS 0

654

set global log_warnings = 42;

655

show global variables like 'log_warnings';

656

Variable_name Value

657

log_warnings 42

658

select * from information_schema.global_variables where variable_name like 'log_warnings';

659

VARIABLE_NAME VARIABLE_VALUE

660

LOG_WARNINGS 42

661

set global log_warnings = @tstlw;

662

show global variables like 'log_warnings';

663

Variable_name Value

664

log_warnings 1

665

select * from information_schema.global_variables where variable_name like 'log_warnings';

666

VARIABLE_NAME VARIABLE_VALUE

667

LOG_WARNINGS 1

668

create table t1 (

669

c1 tinyint,

670

c2 smallint,

671

c3 mediumint,

332

672

c4 int,

333

673

c5 bigint);

334

674

show create table t1;

335

675

Table Create Table

336

t1 CREATE TEMPORARY TABLE `t1` (

337

`c1` INT DEFAULT NULL,

338

`c2` INT DEFAULT NULL,

339

`c3` INT DEFAULT NULL,

340

`c4` INT DEFAULT NULL,

341

`c5` BIGINT DEFAULT NULL

342

) ENGINE=MyISAM COLLATE = utf8_general_ci

676

t1 CREATE TABLE `t1` (

677

`c1` tinyint(4) DEFAULT NULL,

678

`c2` smallint(6) DEFAULT NULL,

679

`c3` mediumint(9) DEFAULT NULL,

680

`c4` int(11) DEFAULT NULL,

681

`c5` bigint(20) DEFAULT NULL

682

) ENGINE=MyISAM DEFAULT CHARSET=latin1

343

683

drop table t1;

344

684

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

345

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

685

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

346

686

show create table t1;

347

687

Table Create Table

348

t1 CREATE TEMPORARY TABLE `t1` (

349

`c1` BIGINT DEFAULT NULL,

350

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

351

`c3` TEXT COLLATE utf8_general_ci,

352

`c4` DOUBLE DEFAULT NULL

353

) ENGINE=MyISAM COLLATE = utf8_general_ci

688

t1 CREATE TABLE `t1` (

689

`c1` bigint(20) DEFAULT NULL,

690

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

691

`c3` longtext,

692

`c4` double DEFAULT NULL

693

) ENGINE=MyISAM DEFAULT CHARSET=latin1

354

694

drop table t1;

695

SET GLOBAL MYISAM_DATA_POINTER_SIZE= 7;

696

SHOW VARIABLES LIKE 'MYISAM_DATA_POINTER_SIZE';

697

Variable_name Value

698

myisam_data_pointer_size 7

699

SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME LIKE 'MYISAM_DATA_POINTER_SIZE';

700

VARIABLE_NAME VARIABLE_VALUE

701

MYISAM_DATA_POINTER_SIZE 7

355

702

SET GLOBAL table_open_cache=-1;

356

703

Warnings:

357

Error 1292 Truncated incorrect table_open_cache value: '18446744073709551615'

704

Warning 1292 Truncated incorrect table_open_cache value: '0'

358

705

SHOW VARIABLES LIKE 'table_open_cache';

359

706

Variable_name Value

360

table_open_cache 100

361

SELECT * FROM DATA_DICTIONARY.SESSION_VARIABLES WHERE VARIABLE_NAME LIKE 'table_open_cache';

707

table_open_cache 1

708

SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME LIKE 'table_open_cache';

362

709

VARIABLE_NAME VARIABLE_VALUE

363

table_open_cache 100

710

TABLE_OPEN_CACHE 1

364

711

SET GLOBAL table_open_cache=DEFAULT;

712

set character_set_results=NULL;

713

select ifnull(@@character_set_results,"really null");

714

ifnull(@@character_set_results,"really null")

715

really null

716

set names latin1;

717

select @@have_innodb;

718

@@have_innodb

719

365

720

*** Various tests with LC_TIME_NAMES

366

721

*** LC_TIME_NAMES: testing case insensitivity

367

722

set @@lc_time_names='ru_ru';

455

810

select @@query_prealloc_size = @test;

456

811

@@query_prealloc_size = @test

457

812

813

set global sql_mode=repeat('a',80);

814

ERROR 42000: Variable 'sql_mode' can't be set to the value of 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

458

815

End of 4.1 tests

459

create temporary table t1 (a int);

816

create table t1 (a int);

460

817

select a into @x from t1;

461

818

Warnings:

462

819

Warning 1329 No data - zero rows fetched, selected, or processed

468

825

ERROR HY000: Variable 'warning_count' is a read only variable

469

826

set @@global.error_count=1;

470

827

ERROR HY000: Variable 'error_count' is a read only variable

828

set @@max_heap_table_size= 4294967296;

829

select @@max_heap_table_size > 0;

830

@@max_heap_table_size > 0

831

832

set global max_heap_table_size= 4294967296;

833

select @@max_heap_table_size > 0;

834

@@max_heap_table_size > 0

835

836

set @@max_heap_table_size= 4294967296;

837

select @@max_heap_table_size > 0;

838

@@max_heap_table_size > 0

839

471

840

select @@character_set_system;

472

ERROR HY000: Unknown system variable 'character_set_system'

473

set global character_set_system = utf8;

474

ERROR HY000: Unknown system variable 'character_set_system'

841

@@character_set_system

842

utf8

843

set global character_set_system = latin1;

844

ERROR HY000: Variable 'character_set_system' is a read only variable

475

845

set @@global.version_compile_os='234';

476

846

ERROR HY000: Variable 'version_compile_os' is a read only variable

477

set @@global.character_set_filesystem=utf8;

478

ERROR HY000: Unknown system variable 'character_set_filesystem'

479

set character_set_filesystem=utf8;

480

ERROR HY000: Unknown system variable 'character_set_filesystem'

481

set @sql_big_selects = @@sql_big_selects;

847

set character_set_filesystem=latin1;

848

select @@character_set_filesystem;

849

@@character_set_filesystem

850

latin1

851

set @@global.character_set_filesystem=latin2;

852

set character_set_filesystem=latin1;

853

select @@character_set_filesystem;

854

@@character_set_filesystem

855

latin1

856

set @@global.character_set_filesystem=latin2;

857

set character_set_filesystem=default;

858

select @@character_set_filesystem;

859

@@character_set_filesystem

860

latin2

861

set @@global.character_set_filesystem=default;

862

select @@global.character_set_filesystem;

863

@@global.character_set_filesystem

864

binary

865

set @old_sql_big_selects = @@sql_big_selects;

482

866

set @@sql_big_selects = 1;

483

867

show variables like 'sql_big_selects';

484

868

Variable_name Value

485

869

sql_big_selects ON

486

set @@sql_big_selects = @sql_big_selects;

870

select * from information_schema.session_variables where variable_name like 'sql_big_selects';

871

VARIABLE_NAME VARIABLE_VALUE

872

SQL_BIG_SELECTS ON

873

set @@sql_big_selects = @old_sql_big_selects;

487

874

set @@sql_notes = 0, @@sql_warnings = 0;

488

875

show variables like 'sql_notes';

489

876

Variable_name Value

490

877

sql_notes OFF

878

select * from information_schema.session_variables where variable_name like 'sql_notes';

879

VARIABLE_NAME VARIABLE_VALUE

880

SQL_NOTES OFF

491

881

show variables like 'sql_warnings';

492

882

Variable_name Value

493

883

sql_warnings OFF

884

select * from information_schema.session_variables where variable_name like 'sql_warnings';

885

VARIABLE_NAME VARIABLE_VALUE

886

SQL_WARNINGS OFF

494

887

set @@sql_notes = 1, @@sql_warnings = 1;

495

888

show variables like 'sql_notes';

496

889

Variable_name Value

497

890

sql_notes ON

891

select * from information_schema.session_variables where variable_name like 'sql_notes';

892

VARIABLE_NAME VARIABLE_VALUE

893

SQL_NOTES ON

498

894

show variables like 'sql_warnings';

499

895

Variable_name Value

500

896

sql_warnings ON

897

select * from information_schema.session_variables where variable_name like 'sql_warnings';

898

VARIABLE_NAME VARIABLE_VALUE

899

SQL_WARNINGS ON

900

select @@system_time_zone;

901

@@system_time_zone

902

501

903

select @@version, @@version_comment, @@version_compile_machine,

502

904

@@version_compile_os;

503

905

@@version @@version_comment @@version_compile_machine @@version_compile_os

508

910

show variables like 'basedir';

509

911

Variable_name Value

510

912

basedir #

913

select * from information_schema.session_variables where variable_name like 'basedir';

914

VARIABLE_NAME VARIABLE_VALUE

915

BASEDIR #

511

916

show variables like 'datadir';

512

917

Variable_name Value

513

918

datadir #

919

select * from information_schema.session_variables where variable_name like 'datadir';

920

VARIABLE_NAME VARIABLE_VALUE

921

DATADIR #

514

922

show variables like 'tmpdir';

515

923

Variable_name Value

516

924

tmpdir #

925

select * from information_schema.session_variables where variable_name like 'tmpdir';

926

VARIABLE_NAME VARIABLE_VALUE

927

TMPDIR #

928

select @@ssl_ca, @@ssl_capath, @@ssl_cert, @@ssl_cipher, @@ssl_key;

929

@@ssl_ca @@ssl_capath @@ssl_cert @@ssl_cipher @@ssl_key

930

# # # # #

931

show variables like 'ssl%';

932

Variable_name Value

933

ssl_ca #

934

ssl_capath #

935

ssl_cert #

936

ssl_cipher #

937

ssl_key #

938

select * from information_schema.session_variables where variable_name like 'ssl%' order by 1;

939

VARIABLE_NAME VARIABLE_VALUE

940

SSL_CA #

941

SSL_CAPATH #

942

SSL_CERT #

943

SSL_CIPHER #

944

SSL_KEY #

945

select @@log_queries_not_using_indexes;

946

@@log_queries_not_using_indexes

947

948

show variables like 'log_queries_not_using_indexes';

949

Variable_name Value

950

log_queries_not_using_indexes OFF

951

select * from information_schema.session_variables where variable_name like 'log_queries_not_using_indexes';

952

VARIABLE_NAME VARIABLE_VALUE

953

LOG_QUERIES_NOT_USING_INDEXES OFF

517

954

select @@"";

518

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 '""' at line 1

955

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

519

956

select @@&;

520

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 '&' at line 1

957

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

521

958

select @@@;

522

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 '@' at line 1

959

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

523

960

select @@hostname;

524

961

@@hostname

525

962

529

966

Variable_name Value

530

967

hostname #

531

968

End of 5.0 tests

969

set global binlog_cache_size =@my_binlog_cache_size;

970

set global connect_timeout =@my_connect_timeout;

971

set global delayed_insert_timeout =@my_delayed_insert_timeout;

972

set global delayed_queue_size =@my_delayed_queue_size;

973

set global flush =@my_flush;

532

974

set global flush_time =@my_flush_time;

533

ERROR HY000: Unknown system variable 'flush_time'

975

set global key_buffer_size =@my_key_buffer_size;

976

set global max_binlog_cache_size =default;

977

set global max_binlog_size =@my_max_binlog_size;

978

set global max_connect_errors =@my_max_connect_errors;

979

set global max_connections =@my_max_connections;

980

set global max_delayed_threads =@my_max_delayed_threads;

534

981

set global max_heap_table_size =@my_max_heap_table_size;

982

set global max_insert_delayed_threads=@my_max_insert_delayed_threads;

535

983

set global max_join_size =@my_max_join_size;

984

set global max_user_connections =default;

536

985

set global max_write_lock_count =default;

537

set global mysql_protocol_buffer_length= @my_mysql_protocol_buffer_length;

986

set global myisam_data_pointer_size =@my_myisam_data_pointer_size;

987

set global net_buffer_length =@my_net_buffer_length;

988

set global net_write_timeout =@my_net_write_timeout;

989

set global net_read_timeout =@my_net_read_timeout;

990

set global query_cache_limit =@my_query_cache_limit;

991

set global query_cache_type =@my_query_cache_type;

992

set global rpl_recovery_rank =@my_rpl_recovery_rank;

538

993

set global server_id =@my_server_id;

994

set global slow_launch_time =@my_slow_launch_time;

539

995

set global storage_engine =@my_storage_engine;

540

996

set global thread_cache_size =@my_thread_cache_size;

541

ERROR HY000: Unknown system variable 'thread_cache_size'

542

set global myisam_sort_buffer_size =@my_myisam_sort_buffer_size;

543

SHOW GLOBAL VARIABLES LIKE 'max_join_size';

544

Variable_name Value

545

max_join_size 2147483647

546

SHOW LOCAL VARIABLES LIKE 'max_join_size';

547

Variable_name Value

548

max_join_size 100

549

set GLOBAL bulk_insert_buffer_size=DEFAULT;

550

set GLOBAL join_buffer_size=DEFAULT;

551

set GLOBAL max_allowed_packet=DEFAULT;

552

set GLOBAL max_heap_table_size=DEFAULT;

553

set GLOBAL max_join_size=DEFAULT;

554

set GLOBAL max_sort_length=DEFAULT;

555

set GLOBAL max_write_lock_count=DEFAULT;

556

set GLOBAL myisam_sort_buffer_size=DEFAULT;

557

set GLOBAL mysql_protocol_buffer_length=DEFAULT;

558

set GLOBAL read_buffer_size=DEFAULT;

559

set GLOBAL read_rnd_buffer_size=DEFAULT;

560

set GLOBAL server_id=DEFAULT;

561

set GLOBAL sort_buffer_size=DEFAULT;

562

set GLOBAL table_open_cache=DEFAULT;

563

set GLOBAL storage_engine= @my_storage_engine;

564

set GLOBAL tmp_table_size=DEFAULT;

565

set GLOBAL tx_isolation= @my_tx_isolation;

566

set SESSION bulk_insert_buffer_size=DEFAULT;

567

set SESSION join_buffer_size=DEFAULT;

568

set SESSION max_allowed_packet=DEFAULT;

569

set SESSION max_heap_table_size=DEFAULT;

570

set SESSION max_join_size=DEFAULT;

571

set SESSION max_sort_length=DEFAULT;

572

set SESSION read_buffer_size=DEFAULT;

573

set SESSION read_rnd_buffer_size=DEFAULT;

574

set SESSION sort_buffer_size=DEFAULT;

575

set SESSION sql_big_selects=DEFAULT;

576

set SESSION sql_buffer_result=DEFAULT;

577

set SESSION sql_select_limit=DEFAULT;

578

set SESSION sql_warnings=DEFAULT;

579

set SESSION storage_engine= @my_storage_engine;

580

set SESSION tmp_table_size=DEFAULT;

581

set SESSION tx_isolation= @my_tx_isolation;

582

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

997

show global variables where Variable_name='table_definition_cache' or

998

Variable_name='table_lock_wait_timeout';

583

999

Variable_name Value

584

1000

table_definition_cache #

585

1001

table_lock_wait_timeout #

1002

1003

# --

1004

# -- Bug#34820: log_output can be set to illegal value.

1005

# --

1006

SET GLOBAL log_output = '';

1007

ERROR 42000: Variable 'log_output' can't be set to the value of ''

1008

SET GLOBAL log_output = 0;

1009

ERROR 42000: Variable 'log_output' can't be set to the value of '0'

1010

1011

# -- End of Bug#34820.

Older »