~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

394

ERROR HY000: Unknown system variable 'global'

632

395

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

396

ERROR HY000: Unknown system variable 'global'

634

397

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

398

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

636

399

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

400

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

638

401

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,

402

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

403

create temporary table t1 (

404

c1 int,

405

c2 int,

406

c3 int,

672

407

c4 int,

673

408

c5 bigint);

674

409

show create table t1;

675

410

Table Create Table

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

411

t1 CREATE TEMPORARY TABLE `t1` (

412

`c1` int DEFAULT NULL,

413

`c2` int DEFAULT NULL,

414

`c3` int DEFAULT NULL,

415

`c4` int DEFAULT NULL,

416

`c5` bigint DEFAULT NULL

417

) ENGINE=MyISAM

683

418

drop table t1;

684

419

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

685

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

420

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

686

421

show create table t1;

687

422

Table Create Table

688

t1 CREATE TABLE `t1` (

689

`c1` bigint(20) DEFAULT NULL,

423

t1 CREATE TEMPORARY TABLE `t1` (

424

`c1` bigint DEFAULT NULL,

690

425

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

691

`c3` longtext,

426

`c3` text,

692

427

`c4` double DEFAULT NULL

693

) ENGINE=MyISAM DEFAULT CHARSET=latin1

428

) ENGINE=MyISAM

694

429

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

702

430

SET GLOBAL table_open_cache=-1;

703

431

Warnings:

704

Warning 1292 Truncated incorrect table_open_cache value: '0'

432

Error 1292 Truncated incorrect table_open_cache value: '18446744073709551615'

705

433

SHOW VARIABLES LIKE 'table_open_cache';

706

434

Variable_name Value

707

table_open_cache 1

435

table_open_cache 100

708

436

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

709

437

VARIABLE_NAME VARIABLE_VALUE

710

TABLE_OPEN_CACHE 1

438

TABLE_OPEN_CACHE 100

711

439

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

720

440

*** Various tests with LC_TIME_NAMES

721

441

*** LC_TIME_NAMES: testing case insensitivity

722

442

set @@lc_time_names='ru_ru';

810

530

select @@query_prealloc_size = @test;

811

531

@@query_prealloc_size = @test

812

532

813

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

814

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

815

533

End of 4.1 tests

816

create table t1 (a int);

534

create temporary table t1 (a int);

817

535

select a into @x from t1;

818

536

Warnings:

819

537

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

838

556

@@max_heap_table_size > 0

839

557

840

558

select @@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

559

ERROR HY000: Unknown system variable 'character_set_system'

560

set global character_set_system = utf8;

561

ERROR HY000: Unknown system variable 'character_set_system'

845

562

set @@global.version_compile_os='234';

846

563

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

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

564

set @@global.character_set_filesystem=utf8;

565

ERROR HY000: Unknown system variable 'character_set_filesystem'

566

set character_set_filesystem=utf8;

567

ERROR HY000: Unknown system variable 'character_set_filesystem'

865

568

set @old_sql_big_selects = @@sql_big_selects;

866

569

set @@sql_big_selects = 1;

867

570

show variables like 'sql_big_selects';

868

571

Variable_name Value

869

572

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

873

573

set @@sql_big_selects = @old_sql_big_selects;

874

574

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

875

575

show variables like 'sql_notes';

876

576

Variable_name Value

877

577

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

881

578

show variables like 'sql_warnings';

882

579

Variable_name Value

883

580

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

887

581

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

888

582

show variables like 'sql_notes';

889

583

Variable_name Value

890

584

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

894

585

show variables like 'sql_warnings';

895

586

Variable_name Value

896

587

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

903

588

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

904

589

@@version_compile_os;

905

590

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

910

595

show variables like 'basedir';

911

596

Variable_name Value

912

597

basedir #

913

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

914

VARIABLE_NAME VARIABLE_VALUE

915

BASEDIR #

916

598

show variables like 'datadir';

917

599

Variable_name Value

918

600

datadir #

919

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

920

VARIABLE_NAME VARIABLE_VALUE

921

DATADIR #

922

601

show variables like 'tmpdir';

923

602

Variable_name Value

924

603

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

954

604

select @@"";

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

605

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

956

606

select @@&;

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

607

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

958

608

select @@@;

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

609

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

960

610

select @@hostname;

961

611

@@hostname

962

612

966

616

Variable_name Value

967

617

hostname #

968

618

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;

974

619

set global flush_time =@my_flush_time;

620

ERROR HY000: Unknown system variable 'flush_time'

975

621

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

622

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;

981

623

set global max_heap_table_size =@my_max_heap_table_size;

982

set global max_insert_delayed_threads=@my_max_insert_delayed_threads;

983

624

set global max_join_size =@my_max_join_size;

984

set global max_user_connections =default;

985

625

set global max_write_lock_count =default;

986

626

set global myisam_data_pointer_size =@my_myisam_data_pointer_size;

627

ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'

987

628

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;

993

629

set global server_id =@my_server_id;

994

set global slow_launch_time =@my_slow_launch_time;

995

630

set global storage_engine =@my_storage_engine;

996

631

set global thread_cache_size =@my_thread_cache_size;

997

show global variables where Variable_name='table_definition_cache' or

998

Variable_name='table_lock_wait_timeout';

632

ERROR HY000: Unknown system variable 'thread_cache_size'

633

set global myisam_sort_buffer_size =@my_myisam_sort_buffer_size;

634

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

999

635

Variable_name Value

1000

636

table_definition_cache #

1001

637

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 »