acbdf637b6
The previous patch added the ability in CREATE TABLE to designate one of the regular columns as a "TTL column", to be used by the per-row TTL feature (Refs #13000). In this patch we add to ALTER TABLE the ability to enable per-row TTL on an existing table with a given column as the TTL column: ALTER TABLE tab TTL colname and also the ability to disable per-row TTL with ALTER TABLE tab TTL NULL as in CREATE TABLE, the designated TTL column must be a regular column (it can't be a primary key column or a static column), and must have the types timestamp, bigint or int. You can't enable per-row TTL if already enabled, or disable it if already disabled. To change the TTL column on an existing table, you must first disable TTL, and then re-enable it with the new column. A large collection of functional tests (in test/cqlpy), for every detail of this patch, will come in a later patch in this series. Signed-off-by: Nadav Har'El <nyh@scylladb.com>
103 lines
4.4 KiB
C++
103 lines
4.4 KiB
C++
/*
|
|
* Copyright 2015-present ScyllaDB
|
|
*
|
|
* Modified by ScyllaDB
|
|
*/
|
|
|
|
/*
|
|
* SPDX-License-Identifier: (LicenseRef-ScyllaDB-Source-Available-1.0 and Apache-2.0)
|
|
*/
|
|
|
|
#pragma once
|
|
|
|
#include "cql3/attributes.hh"
|
|
#include "cql3/statements/schema_altering_statement.hh"
|
|
#include "cql3/statements/cf_prop_defs.hh"
|
|
#include "cql3/cql3_type.hh"
|
|
#include "cql3/column_identifier.hh"
|
|
#include "data_dictionary/data_dictionary.hh"
|
|
#include "mutation/timestamp.hh"
|
|
|
|
namespace cql3 {
|
|
|
|
class query_processor;
|
|
|
|
namespace statements {
|
|
|
|
class alter_table_statement : public schema_altering_statement {
|
|
public:
|
|
enum class type {
|
|
add,
|
|
alter,
|
|
drop,
|
|
opts,
|
|
rename,
|
|
ttl,
|
|
};
|
|
using renames_type = std::vector<std::pair<shared_ptr<column_identifier::raw>,
|
|
shared_ptr<column_identifier::raw>>>;
|
|
struct column_change {
|
|
shared_ptr<column_identifier::raw> name;
|
|
shared_ptr<cql3_type::raw> validator = nullptr;
|
|
bool is_static = false;
|
|
};
|
|
|
|
class raw_statement;
|
|
private:
|
|
const uint32_t _bound_terms;
|
|
|
|
const type _type;
|
|
const std::vector<column_change> _column_changes;
|
|
const std::optional<cf_prop_defs> _properties;
|
|
const renames_type _renames;
|
|
const std::unique_ptr<attributes> _attrs;
|
|
shared_ptr<column_identifier::raw> _ttl_change;
|
|
public:
|
|
alter_table_statement(uint32_t bound_terms,
|
|
cf_name name,
|
|
type t,
|
|
std::vector<column_change> column_changes,
|
|
std::optional<cf_prop_defs> properties,
|
|
renames_type renames,
|
|
std::unique_ptr<attributes> attrs,
|
|
shared_ptr<column_identifier::raw> ttl_change);
|
|
|
|
virtual uint32_t get_bound_terms() const override;
|
|
virtual future<> check_access(query_processor& qp, const service::client_state& state) const override;
|
|
virtual std::unique_ptr<prepared_statement> prepare(data_dictionary::database db, cql_stats& stats) override;
|
|
virtual future<::shared_ptr<messages::result_message>> execute(query_processor& qp, service::query_state& state, const query_options& options, std::optional<service::group0_guard> guard) const override;
|
|
|
|
future<std::tuple<::shared_ptr<cql_transport::event::schema_change>, utils::chunked_vector<mutation>, cql3::cql_warnings_vec>> prepare_schema_mutations(query_processor& qp, const query_options& options, api::timestamp_type) const override;
|
|
private:
|
|
void add_column(const query_options& options, const schema& schema, data_dictionary::table cf, schema_builder& cfm, std::vector<view_ptr>& view_updates, const column_identifier& column_name, const cql3_type validator, const column_definition* def, bool is_static) const;
|
|
void alter_column(const query_options& options, const schema& schema, data_dictionary::table cf, schema_builder& cfm, std::vector<view_ptr>& view_updates, const column_identifier& column_name, const cql3_type validator, const column_definition* def, bool is_static) const;
|
|
void drop_column(const query_options& options, const schema& schema, data_dictionary::table cf, schema_builder& cfm, std::vector<view_ptr>& view_updates, const column_identifier& column_name, const cql3_type validator, const column_definition* def, bool is_static) const;
|
|
std::pair<schema_ptr, std::vector<view_ptr>> prepare_schema_update(data_dictionary::database db, const query_options& options) const;
|
|
};
|
|
|
|
class alter_table_statement::raw_statement : public raw::cf_statement {
|
|
const alter_table_statement::type _type;
|
|
const std::vector<column_change> _column_changes;
|
|
const std::optional<cf_prop_defs> _properties;
|
|
const alter_table_statement::renames_type _renames;
|
|
const std::unique_ptr<attributes::raw> _attrs;
|
|
shared_ptr<column_identifier::raw> _ttl_change;
|
|
|
|
public:
|
|
raw_statement(cf_name name,
|
|
type t,
|
|
std::vector<column_change> column_changes,
|
|
std::optional<cf_prop_defs> properties,
|
|
renames_type renames,
|
|
std::unique_ptr<attributes::raw> attrs,
|
|
shared_ptr<column_identifier::raw> ttl_change);
|
|
|
|
virtual std::unique_ptr<prepared_statement> prepare(data_dictionary::database db, cql_stats& stats) override;
|
|
|
|
virtual audit::statement_category category() const override { return audit::statement_category::DDL; }
|
|
};
|
|
|
|
}
|
|
|
|
}
|