Loading...

XML

Word

Printable

CREATE INDEX `id_type_size_etype` ON `mybucket`(`reporting_entity_type`,encoded_size(mybucket))

upon index creation gets changed to

CREATE INDEX `id_type_size_etype` ON `mybucket`(`reporting_entity_type`,encoded_size(self))

Running a query with mybucket, covers correctly however if I use "self" it does not cover

Covers:

select reporting_entity_type,AVG(encoded_size(mybucket))

from mybucket

where reporting_entity_type in ["n","r","b","c"]

group by reporting_entity_type

Does not cover:

select reporting_entity_type,AVG(encoded_size(self))

from mybucket

where reporting_entity_type in ["n","r","b","c"]

group by reporting_entity_type

Ask:

Either prevent the conversion of bucket name to self or treat self and bucket name interchangeably in the queries

No reviews matched the request. Check your Options in the drop-down menu of this sections header.

There are no open Gerrit changes

Covering index / Bucket name translation to "Self"