Debian Codegraph @

mysql-test/suite/s3/arguments.result

raw
1 drop table if exists t1;
2 #
3 # Test options
4 #
5 create or replace table t1 (a int, b int, key(a)) engine=aria;
6 insert into t1 select seq,seq+10 from seq_1_to_10;
7 alter table t1 engine=s3, s3_block_size=819200, compression_algorithm="zlib";
8 show create table t1;
9 Table Create Table
10 t1 CREATE TABLE `t1` (
11 `a` int(11) DEFAULT NULL,
12 `b` int(11) DEFAULT NULL,
13 KEY `a` (`a`)
14 ) ENGINE=S3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 `s3_block_size`=819200 `compression_algorithm`='zlib'
15 alter table t1 engine=s3, s3_block_size=8192;
16 ERROR HY000: Incorrect value '8192' for option 's3_block_size'
17 alter table t1 engine=s3, s3_block_size=65536;
18 show create table t1;
19 Table Create Table
20 t1 CREATE TABLE `t1` (
21 `a` int(11) DEFAULT NULL,
22 `b` int(11) DEFAULT NULL,
23 KEY `a` (`a`)
24 ) ENGINE=S3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 `compression_algorithm`='zlib' `s3_block_size`=65536
25 alter table t1 engine=s3, s3_block_size=100000;
26 ERROR HY000: Incorrect value '100000' for option 's3_block_size'
27 show create table t1;
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `a` int(11) DEFAULT NULL,
31 `b` int(11) DEFAULT NULL,
32 KEY `a` (`a`)
33 ) ENGINE=S3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 `compression_algorithm`='zlib' `s3_block_size`=65536
34 alter table t1 engine=s3, compression_algorithm="wss";
35 ERROR HY000: Incorrect value 'wss' for option 'compression_algorithm'
36 drop table t1;
37 # Check that key variables are not shown to the end user
38 show variables like "s3%key";
39 Variable_name Value
40 s3_access_key *****
41 s3_secret_key *****
42 # Show some "static" s3 variables
43 set @tmp= @@global.s3_block_size;
44 show variables like "s3_block_size";
45 Variable_name Value
46 s3_block_size 4194304
47 set @@global.s3_block_size=65536;
48 show variables like "s3_block_size";
49 Variable_name Value
50 s3_block_size 65536
51 set @@global.s3_block_size= @tmp;
52 set @@s3_block_size=65536;
53 ERROR HY000: Variable 's3_block_size' is a GLOBAL variable and should be set with SET GLOBAL
54 # Check s3 variables that can't be changed by end user
55 set @@s3_access_key="abc";
56 ERROR HY000: Variable 's3_access_key' is a read only variable
57 set @@s3_secret_key="abc";
58 ERROR HY000: Variable 's3_secret_key' is a read only variable