Marios Trivyzas

Hi @katerinarousi, thx for working on this! You can use long (milliseconds to do the operations), but I think it's easier to convert the date to a `DateTime` object and...

> Note: This is a benchmark where it works well, created on purpose for this use-case. Yep, of course benchmarks depend on the exact query and data, but this one...

I don't have a clear opinion if this is a bug or a desired behavior. A bit related, need to test, what happens if you attempt to restore users/roles &...

> I am pretty sure at least for schemas this is intentional, as they are not explicitly created and therefore a user would need to have access to a schema...

After discussion we decided to treat this as an improvement, rather than a bug fix.

Some extra info, currently you can restore USERMANAGEMENT, and the privileges are there even though the objects are not: ``` cr> RESTORE SNAPSHOT repo.snap1 USERMANAGEMENT; RESTORE OK, 1 row affected...

I'm only guessing here, but I could see it being handy for a CrateDB user that connects to the DB with different users, one doing insertion, one doing dashboard queries,...

> Edge case: > > ``` > cr> select pg_catalog.has_table_privilege('crate', 'sys.summits', 'insert'); > +------+ > | true | > +------+ > | TRUE | > +------+ > ``` Maybe we...

> Maybe we should check this on the `Roles` level, if the table is in `sys`,`information_schema`,`pg_catalog` we return false for DDL/DML, independently of what are the privileges assigned to a...

> > > Maybe we should check this on the `Roles` level, if the table is in `sys`,`information_schema`,`pg_catalog` we return false for DDL/DML, independently of what are the privileges assigned...