mirror of
https://github.com/MariaDB/server.git
synced 2025-02-10 07:34:11 +01:00
![Monty](/assets/img/avatar_default.png)
A read-only storage engine that stores it's data in (aws) S3 To store data in S3 one could use ALTER TABLE: ALTER TABLE table_name ENGINE=S3 libmarias3 integration done by Sergei Golubchik libmarias3 created by Andrew Hutchings
25 lines
709 B
Text
25 lines
709 B
Text
--source include/have_sequence.inc
|
|
|
|
let $datadir=`select @@datadir`;
|
|
|
|
if (`select @@global.s3_secret_key <> "" or @@global.s3_access_key <> ""`)
|
|
{
|
|
skip S3 engine options given (probably from command line);
|
|
}
|
|
|
|
#
|
|
# Test what happens when we don't have s3 enabled
|
|
#
|
|
create table t1 (a int, b int) engine=aria select seq,seq+10 from seq_1_to_2;
|
|
--error ER_CANT_CREATE_TABLE
|
|
alter table t1 engine=s3;
|
|
drop table t1;
|
|
|
|
--copy_file std_data/s3_unique_table.frm $datadir/test/s3_unique_table.frm
|
|
--error ER_UNSUPPORTED_EXTENSION
|
|
select * from s3_unique_table;
|
|
--error ER_UNSUPPORTED_EXTENSION
|
|
truncate table s3_unique_table;
|
|
--error ER_ERROR_ON_RENAME
|
|
rename table s3_unique_table to t1;
|
|
drop table s3_unique_table;
|