[MDEV-17135] RocksDB: CREATE OR REPLACE t_name AS SELECT - Bulk Load Created: 2018-09-05  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: 10.3.9
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Juan Telleria Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Windows



 Description   

In RocksDB, there are some scenarios in which it is always convenient and more efficient to overpass compaction and perform a Bulk Load.

This includes the following SQL Commands:

  • CREATE OR REPLACE TABLE db_name.tb_name AS SELECT: "As always is done over an empty table".
  • INSERT INTO db_name.tb_name [AS SELECT | VALUES]: "When performed over an empty table".
  • ALTER TABLE db_name.tb_name ENGINE = RocksDB.

Would it be possible to enable automatically rocksdb_bulk_load in such cases? Otherwise, the Query will hit an error and fail, giving a bad user experience.

Thank you.


Generated at Thu Feb 08 08:34:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.