diff options
Diffstat (limited to 'mysql-test/suite/s3/basic.result')
| -rw-r--r-- | mysql-test/suite/s3/basic.result | 156 |
1 files changed, 156 insertions, 0 deletions
diff --git a/mysql-test/suite/s3/basic.result b/mysql-test/suite/s3/basic.result new file mode 100644 index 00000000..790806ee --- /dev/null +++ b/mysql-test/suite/s3/basic.result @@ -0,0 +1,156 @@ +drop table if exists t1; +# +# Test simple create of s3 table +# +create or replace table t1 (a int, b int, c varchar(1000), key (a), key(c)) engine=aria; +insert into t1 select seq, seq+10, repeat(char(65+ mod(seq, 20)),mod(seq,1000)) from seq_1_to_10000; +alter table t1 engine=s3; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL, + `b` int(11) DEFAULT NULL, + `c` varchar(1000) DEFAULT NULL, + KEY `a` (`a`), + KEY `c` (`c`) +) ENGINE=S3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 +select * from information_schema.tables where table_schema="database" and table_name="t1";; +TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT MAX_INDEX_LENGTH TEMPORARY +def # t1 BASE TABLE S3 10 Page 10000 567 5677056 # 761856 0 NULL # # # latin1_swedish_ci NULL page_checksum=1 2305843009213685760 # +show table status like "t1"; +Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary +t1 S3 10 Page 10000 567 5677056 # 761856 0 NULL # # # latin1_swedish_ci NULL page_checksum=1 # N +select a,b from t1 limit 10; +a b +1 11 +2 12 +3 13 +4 14 +5 15 +6 16 +7 17 +8 18 +9 19 +10 20 +select count(*) from t1; +count(*) +10000 +select a,b from t1 where a between 10 and 20; +a b +10 20 +11 21 +12 22 +13 23 +14 24 +15 25 +16 26 +17 27 +18 28 +19 29 +20 30 +explain select * from t1 where a between 10 and 20; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 range a a 5 NULL # Using index condition +insert into t1 values (1,1); +ERROR HY000: Table 't1' is read only +update t1 set b=100 where a=1; +ERROR HY000: Table 't1' is read only +delete from t1 where a>10; +ERROR HY000: Table 't1' is read only +# +# Analyze, repair, optimize and check table +# +set @@use_stat_tables='never'; +truncate mysql.table_stats; +check table t1 fast; +Table Op Msg_type Msg_text +database.t1 check status Table is already up to date +check table t1 quick; +Table Op Msg_type Msg_text +database.t1 check status OK +check table t1 extended; +Table Op Msg_type Msg_text +database.t1 check status OK +analyze table t1; +Table Op Msg_type Msg_text +database.t1 analyze status Table 'database.t1' is read only +analyze table t1 persistent for all; +Table Op Msg_type Msg_text +database.t1 analyze status Table 'database.t1' is read only +database.t1 analyze status Engine-independent statistics collected +database.t1 analyze status OK +repair table t1; +Table Op Msg_type Msg_text +database.t1 repair Error Table 't1' is read only +database.t1 repair status Operation failed +optimize table t1; +Table Op Msg_type Msg_text +database.t1 optimize Error Table 't1' is read only +database.t1 optimize status Operation failed +select * from mysql.table_stats; +db_name table_name cardinality +database t1 10000 +# +# Converting table back to Aria +# +alter table t1 engine=aria; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL, + `b` int(11) DEFAULT NULL, + `c` varchar(1000) DEFAULT NULL, + KEY `a` (`a`), + KEY `c` (`c`) +) ENGINE=Aria DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci PAGE_CHECKSUM=1 +select a,b from t1 limit 10; +a b +1 11 +2 12 +3 13 +4 14 +5 15 +6 16 +7 17 +8 18 +9 19 +10 20 +select count(*) from t1; +count(*) +10000 +delete from t1 where a=1; +drop table t1; +# +# status +# +show variables like "s3%"; +Variable_name Value +s3_access_key X +s3_block_size X +s3_bucket X +s3_debug X +s3_host_name X +s3_pagecache_age_threshold X +s3_pagecache_buffer_size X +s3_pagecache_division_limit X +s3_pagecache_file_hash_size X +s3_port X +s3_protocol_version X +s3_region X +s3_replicate_alter_as_create_select X +s3_secret_key X +s3_slave_ignore_updates X +s3_use_http X +show variables like "s3_slave%"; +Variable_name Value +s3_slave_ignore_updates OFF +show variables like "s3_replicate%"; +Variable_name Value +s3_replicate_alter_as_create_select ON +show status like "s3%"; +Variable_name Value +S3_pagecache_blocks_not_flushed X +S3_pagecache_blocks_unused X +S3_pagecache_blocks_used X +S3_pagecache_read_requests X +S3_pagecache_reads X |