Table options not available in CREATE DATABASE

[emliunix]

What type of bug is this?

Configuration

What subsystems are affected?

Standalone mode, Metasrv

Minimal reproduce step

It's mentioned in doc table options are applicable to CREATE DATABSE WITH as well, but the code suggests it's hard coded to allow only TTL.

Execute the following SQL.

create database log with (ttl = '7d', storage = 's3');

# config file
[storage]
type = "File"
data_home = "/var/lib/greptimedb"
cache_path = "/var/lib/greptimedb/cache"
cache_capacity = "2GiB"

[wal]
dir = "/var/lib/greptimedb/wal"

[logging]
dir = "/var/lib/greptimedb/log"

[[storage.providers]]
name = "s3"
type = "S3"
# more s3 configs redacted

What did you expect to see?

database created with default storage options.

What did you see instead?

11:31:35 PM [error] create database log with (ttl = '7d', storage = 's3'); Unrecognized database option key: storage

What operating system did you use?

docker.io/greptime/greptimedb:v0.11.3 on arm64 orangepi 5 pro

What version of GreptimeDB did you use?

v0.11.3

Relevant log output and stack trace

[yihong0618]

seems it only support the table part of object store, not the database side

[emliunix]

My understanding is that the doc says these database options are just defaults for table options, which seems to make sense.

And I think it's a valid use case like templates and dynamic templates in elasticsearch for configuring tables that'll be auto created on metrics ingestion.