~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 'key_buffer_size= 1' at line 1

631

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

441

632

set GLOBAL global.key_buffer_size= 1;

442

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

443

634

SELECT @@global.global.key_buffer_size;

444

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

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

445

636

SELECT @@global.session.key_buffer_size;

446

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

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

447

638

SELECT @@global.local.key_buffer_size;

448

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

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

449

668

create table t1 (

450

c1 int,

451

c2 int,

452

c3 int,

669

c1 tinyint,

670

c2 smallint,

671

c3 mediumint,

453

672

c4 int,

454

673

c5 bigint);

455

674

show create table t1;

456

675

Table Create Table

457

676

t1 CREATE TABLE `t1` (

458

`c1` int,

459

`c2` int,

460

`c3` int,

461

`c4` int,

462

`c5` bigint

463

) ENGINE=MyISAM

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

464

683

drop table t1;

465

684

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

466

685

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

467

686

show create table t1;

468

687

Table Create Table

469

688

t1 CREATE TABLE `t1` (

470

`c1` bigint,

471

`c2` decimal(65,30),

472

`c3` text,

473

`c4` double

474

) ENGINE=MyISAM

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

475

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

476

702

SET GLOBAL table_open_cache=-1;

477

703

Warnings:

478

704

Warning 1292 Truncated incorrect table_open_cache value: '0'

479

705

SHOW VARIABLES LIKE 'table_open_cache';

480

706

Variable_name Value

481

707

table_open_cache 1

708

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

709

VARIABLE_NAME VARIABLE_VALUE

710

TABLE_OPEN_CACHE 1

482

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

483

720

*** Various tests with LC_TIME_NAMES

484

721

*** LC_TIME_NAMES: testing case insensitivity

485

722

set @@lc_time_names='ru_ru';

573

810

select @@query_prealloc_size = @test;

574

811

@@query_prealloc_size = @test

575

812

813

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

814

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

576

815

End of 4.1 tests

577

816

create table t1 (a int);

578

817

select a into @x from t1;

599

838

@@max_heap_table_size > 0

600

839

601

840

select @@character_set_system;

602

ERROR HY000: Unknown system variable 'character_set_system'

603

set global character_set_system = utf8;

604

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

605

845

set @@global.version_compile_os='234';

606

846

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

607

set @@global.character_set_filesystem=utf8;

608

ERROR HY000: Unknown system variable 'character_set_filesystem'

609

set character_set_filesystem=utf8;

610

ERROR HY000: Unknown system variable 'character_set_filesystem'

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

611

865

set @old_sql_big_selects = @@sql_big_selects;

612

866

set @@sql_big_selects = 1;

613

867

show variables like 'sql_big_selects';

614

868

Variable_name Value

615

869

sql_big_selects ON

870

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

871

VARIABLE_NAME VARIABLE_VALUE

872

SQL_BIG_SELECTS ON

616

873

set @@sql_big_selects = @old_sql_big_selects;

617

874

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

618

875

show variables like 'sql_notes';

619

876

Variable_name Value

620

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

621

881

show variables like 'sql_warnings';

622

882

Variable_name Value

623

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

624

887

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

625

888

show variables like 'sql_notes';

626

889

Variable_name Value

627

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

628

894

show variables like 'sql_warnings';

629

895

Variable_name Value

630

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

631

900

select @@system_time_zone;

632

901

@@system_time_zone

633

902

641

910

show variables like 'basedir';

642

911

Variable_name Value

643

912

basedir #

913

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

914

VARIABLE_NAME VARIABLE_VALUE

915

BASEDIR #

644

916

show variables like 'datadir';

645

917

Variable_name Value

646

918

datadir #

919

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

920

VARIABLE_NAME VARIABLE_VALUE

921

DATADIR #

647

922

show variables like 'tmpdir';

648

923

Variable_name Value

649

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

650

954

select @@"";

651

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

652

956

select @@&;

653

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

654

958

select @@@;

655

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

656

960

select @@hostname;

657

961

@@hostname

658

962

662

966

Variable_name Value

663

967

hostname #

664

968

End of 5.0 tests

969

set global binlog_cache_size =@my_binlog_cache_size;

665

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;

666

973

set global flush =@my_flush;

667

974

set global flush_time =@my_flush_time;

668

ERROR HY000: Unknown system variable 'flush_time'

669

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;

670

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;

671

981

set global max_heap_table_size =@my_max_heap_table_size;

982

set global max_insert_delayed_threads=@my_max_insert_delayed_threads;

672

983

set global max_join_size =@my_max_join_size;

984

set global max_user_connections =default;

673

985

set global max_write_lock_count =default;

674

986

set global myisam_data_pointer_size =@my_myisam_data_pointer_size;

675

ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'

676

987

set global net_buffer_length =@my_net_buffer_length;

677

988

set global net_write_timeout =@my_net_write_timeout;

678

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;

679

993

set global server_id =@my_server_id;

680

994

set global slow_launch_time =@my_slow_launch_time;

681

995

set global storage_engine =@my_storage_engine;

682

996

set global thread_cache_size =@my_thread_cache_size;

683

ERROR HY000: Unknown system variable 'thread_cache_size'

997

show global variables where Variable_name='table_definition_cache' or

998

Variable_name='table_lock_wait_timeout';

999

Variable_name Value

1000

table_definition_cache #

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 »