~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

640

set GLOBAL global.key_buffer_size= 1;

641

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

642

SELECT @@global.global.key_buffer_size;

643

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

644

SELECT @@global.session.key_buffer_size;

645

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

646

SELECT @@global.local.key_buffer_size;

647

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

648

set @tstlw = @@log_warnings;

649

show global variables like 'log_warnings';

650

Variable_name Value

651

log_warnings 1

652

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

653

VARIABLE_NAME VARIABLE_VALUE

654

LOG_WARNINGS 1

655

set global log_warnings = 0;

656

show global variables like 'log_warnings';

657

Variable_name Value

658

log_warnings 0

659

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

660

VARIABLE_NAME VARIABLE_VALUE

661

LOG_WARNINGS 0

662

set global log_warnings = 42;

663

show global variables like 'log_warnings';

664

Variable_name Value

665

log_warnings 42

666

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

667

VARIABLE_NAME VARIABLE_VALUE

668

LOG_WARNINGS 42

669

set global log_warnings = @tstlw;

670

show global variables like 'log_warnings';

671

Variable_name Value

672

log_warnings 1

673

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

674

VARIABLE_NAME VARIABLE_VALUE

675

LOG_WARNINGS 1

676

create table t1 (

677

c1 tinyint,

678

c2 smallint,

679

c3 mediumint,

334

680

c4 int,

335

681

c5 bigint);

336

682

show create table t1;

337

683

Table Create Table

338

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

684

t1 CREATE TABLE `t1` (

685

`c1` tinyint(4) DEFAULT NULL,

686

`c2` smallint(6) DEFAULT NULL,

687

`c3` mediumint(9) DEFAULT NULL,

688

`c4` int(11) DEFAULT NULL,

689

`c5` bigint(20) DEFAULT NULL

690

) ENGINE=MyISAM DEFAULT CHARSET=latin1

345

691

drop table t1;

346

692

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

347

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

693

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

348

694

show create table t1;

349

695

Table Create Table

350

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

696

t1 CREATE TABLE `t1` (

697

`c1` bigint(20) DEFAULT NULL,

698

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

699

`c3` longtext,

700

`c4` double DEFAULT NULL

701

) ENGINE=MyISAM DEFAULT CHARSET=latin1

356

702

drop table t1;

703

SET GLOBAL MYISAM_DATA_POINTER_SIZE= 7;

704

SHOW VARIABLES LIKE 'MYISAM_DATA_POINTER_SIZE';

705

Variable_name Value

706

myisam_data_pointer_size 7

707

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

708

VARIABLE_NAME VARIABLE_VALUE

709

MYISAM_DATA_POINTER_SIZE 7

357

710

SET GLOBAL table_open_cache=-1;

358

711

Warnings:

359

Error 1292 Truncated incorrect table_open_cache value: '18446744073709551615'

712

Warning 1292 Truncated incorrect table_open_cache value: '0'

360

713

SHOW VARIABLES LIKE 'table_open_cache';

361

714

Variable_name Value

362

table_open_cache 100

363

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

715

table_open_cache 1

716

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

364

717

VARIABLE_NAME VARIABLE_VALUE

365

table_open_cache 100

718

TABLE_OPEN_CACHE 1

366

719

SET GLOBAL table_open_cache=DEFAULT;

720

set character_set_results=NULL;

721

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

722

ifnull(@@character_set_results,"really null")

723

really null

724

set names latin1;

725

select @@have_innodb;

726

@@have_innodb

727

367

728

*** Various tests with LC_TIME_NAMES

368

729

*** LC_TIME_NAMES: testing case insensitivity

369

730

set @@lc_time_names='ru_ru';

457

818

select @@query_prealloc_size = @test;

458

819

@@query_prealloc_size = @test

459

820

821

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

822

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

460

823

End of 4.1 tests

461

create temporary table t1 (a int);

824

create table t1 (a int);

462

825

select a into @x from t1;

463

826

Warnings:

464

827

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

470

833

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

471

834

set @@global.error_count=1;

472

835

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

836

set @@max_heap_table_size= 4294967296;

837

select @@max_heap_table_size > 0;

838

@@max_heap_table_size > 0

839

840

set global max_heap_table_size= 4294967296;

841

select @@max_heap_table_size > 0;

842

@@max_heap_table_size > 0

843

844

set @@max_heap_table_size= 4294967296;

845

select @@max_heap_table_size > 0;

846

@@max_heap_table_size > 0

847

473

848

select @@character_set_system;

474

ERROR HY000: Unknown system variable 'character_set_system'

475

set global character_set_system = utf8;

476

ERROR HY000: Unknown system variable 'character_set_system'

849

@@character_set_system

850

utf8

851

set global character_set_system = latin1;

852

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

477

853

set @@global.version_compile_os='234';

478

854

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

479

set @@global.character_set_filesystem=utf8;

480

ERROR HY000: Unknown system variable 'character_set_filesystem'

481

set character_set_filesystem=utf8;

482

ERROR HY000: Unknown system variable 'character_set_filesystem'

483

set @sql_big_selects = @@sql_big_selects;

855

set character_set_filesystem=latin1;

856

select @@character_set_filesystem;

857

@@character_set_filesystem

858

latin1

859

set @@global.character_set_filesystem=latin2;

860

set character_set_filesystem=latin1;

861

select @@character_set_filesystem;

862

@@character_set_filesystem

863

latin1

864

set @@global.character_set_filesystem=latin2;

865

set character_set_filesystem=default;

866

select @@character_set_filesystem;

867

@@character_set_filesystem

868

latin2

869

set @@global.character_set_filesystem=default;

870

select @@global.character_set_filesystem;

871

@@global.character_set_filesystem

872

binary

873

set @old_sql_big_selects = @@sql_big_selects;

484

874

set @@sql_big_selects = 1;

485

875

show variables like 'sql_big_selects';

486

876

Variable_name Value

487

877

sql_big_selects ON

488

set @@sql_big_selects = @sql_big_selects;

878

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

879

VARIABLE_NAME VARIABLE_VALUE

880

SQL_BIG_SELECTS ON

881

set @@sql_big_selects = @old_sql_big_selects;

489

882

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

490

883

show variables like 'sql_notes';

491

884

Variable_name Value

492

885

sql_notes OFF

886

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

887

VARIABLE_NAME VARIABLE_VALUE

888

SQL_NOTES OFF

493

889

show variables like 'sql_warnings';

494

890

Variable_name Value

495

891

sql_warnings OFF

892

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

893

VARIABLE_NAME VARIABLE_VALUE

894

SQL_WARNINGS OFF

496

895

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

497

896

show variables like 'sql_notes';

498

897

Variable_name Value

499

898

sql_notes ON

899

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

900

VARIABLE_NAME VARIABLE_VALUE

901

SQL_NOTES ON

500

902

show variables like 'sql_warnings';

501

903

Variable_name Value

502

904

sql_warnings ON

905

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

906

VARIABLE_NAME VARIABLE_VALUE

907

SQL_WARNINGS ON

908

select @@system_time_zone;

909

@@system_time_zone

910

503

911

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

504

912

@@version_compile_os;

505

913

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

510

918

show variables like 'basedir';

511

919

Variable_name Value

512

920

basedir #

921

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

922

VARIABLE_NAME VARIABLE_VALUE

923

BASEDIR #

513

924

show variables like 'datadir';

514

925

Variable_name Value

515

926

datadir #

927

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

928

VARIABLE_NAME VARIABLE_VALUE

929

DATADIR #

516

930

show variables like 'tmpdir';

517

931

Variable_name Value

518

932

tmpdir #

933

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

934

VARIABLE_NAME VARIABLE_VALUE

935

TMPDIR #

936

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

937

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

938

# # # # #

939

show variables like 'ssl%';

940

Variable_name Value

941

ssl_ca #

942

ssl_capath #

943

ssl_cert #

944

ssl_cipher #

945

ssl_key #

946

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

947

VARIABLE_NAME VARIABLE_VALUE

948

SSL_CA #

949

SSL_CAPATH #

950

SSL_CERT #

951

SSL_CIPHER #

952

SSL_KEY #

953

select @@log_queries_not_using_indexes;

954

@@log_queries_not_using_indexes

955

956

show variables like 'log_queries_not_using_indexes';

957

Variable_name Value

958

log_queries_not_using_indexes OFF

959

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

960

VARIABLE_NAME VARIABLE_VALUE

961

LOG_QUERIES_NOT_USING_INDEXES OFF

519

962

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

963

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

964

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

965

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

966

select @@@;

524

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

967

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

525

968

select @@hostname;

526

969

@@hostname

527

970

531

974

Variable_name Value

532

975

hostname #

533

976

End of 5.0 tests

977

set global binlog_cache_size =@my_binlog_cache_size;

978

set global connect_timeout =@my_connect_timeout;

979

set global delayed_insert_timeout =@my_delayed_insert_timeout;

980

set global delayed_queue_size =@my_delayed_queue_size;

981

set global flush =@my_flush;

534

982

set global flush_time =@my_flush_time;

535

ERROR HY000: Unknown system variable 'flush_time'

983

set global key_buffer_size =@my_key_buffer_size;

984

set global max_binlog_cache_size =default;

985

set global max_binlog_size =@my_max_binlog_size;

536

986

set global max_connect_errors =@my_max_connect_errors;

987

set global max_connections =@my_max_connections;

988

set global max_delayed_threads =@my_max_delayed_threads;

537

989

set global max_heap_table_size =@my_max_heap_table_size;

990

set global max_insert_delayed_threads=@my_max_insert_delayed_threads;

538

991

set global max_join_size =@my_max_join_size;

992

set global max_user_connections =default;

539

993

set global max_write_lock_count =default;

540

set global mysql_protocol_buffer_length= @my_mysql_protocol_buffer_length;

994

set global myisam_data_pointer_size =@my_myisam_data_pointer_size;

995

set global net_buffer_length =@my_net_buffer_length;

996

set global net_write_timeout =@my_net_write_timeout;

997

set global net_read_timeout =@my_net_read_timeout;

998

set global query_cache_limit =@my_query_cache_limit;

999

set global query_cache_type =@my_query_cache_type;

1000

set global rpl_recovery_rank =@my_rpl_recovery_rank;

541

1001

set global server_id =@my_server_id;

1002

set global slow_launch_time =@my_slow_launch_time;

542

1003

set global storage_engine =@my_storage_engine;

543

1004

set global thread_cache_size =@my_thread_cache_size;

544

ERROR HY000: Unknown system variable 'thread_cache_size'

545

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

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

1005

show global variables where Variable_name='table_definition_cache' or

1006

Variable_name='table_lock_wait_timeout';

587

1007

Variable_name Value

588

1008

table_definition_cache #

589

1009

table_lock_wait_timeout #

1010

1011

# --

1012

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

1013

# --

1014

SET GLOBAL log_output = '';

1015

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

1016

SET GLOBAL log_output = 0;

1017

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

1018

1019

# -- End of Bug#34820.

Older »