About index

51-60 of 200Refresh
Issue
26

Internal Exception and Index Problems

with the index on that field. It is unclear how this happened, and unfortunately the Doctor doesn't include checks to identify this mismatch. However it is very easy to fix the index by running the Doctor in ... schema, it is possible that wrong data will be used by the server when an object is indexed
Forum
26

Partial Indexing

I have a question about partial indexing. For example, a field of String type ttt, will be distinguished by the first 5 characters, then I can make a index of substr(ttt,1,5) in MySQL. With ObjectDB, how can I write the annotation for this purpose? TIA Currently ObjectDB supports only indexing
Forum
26

Search through collection for value using index

by a paticular user, since I will do this query often I would like to index it.  How would I tell ObjectDB to make an index and then use it in a query? I have yet to deploy this entity so I could do something besides a java collection if there is a better approach. You can define an index
Issue
26

"is not null" queries not working with index

"is not null"-queries are not working correctly for indexed fields. Following SSCCE creates 1000 entities. A null value is assigned to an indexed field for every second entity. When doing count ... .annotations.Index; import javax.persistence.Entity; import javax.persistence.EntityManager; import javax
Forum
26

Check for index existence ?

Hello, Is there a simple way to check if indexes specified in entities are well taken into account by ObjectDb ? Regards, Xirt You can see query execution details, including usage of indexes ... well i got it after few minutes. Seems write in log is not immediate. Well, how can i check index
Forum
25

Case Insensitive Indexes

How do you do case insensitive indexes? I have search the Forum and tutorials and have not found any info related to this.   Thanks, -- Nathan Modrzewski Case insensitive string indexes are currently not supported. If you cannot use lowercase only (or uppercase only) for the data - consider
Issue
25

Full Text Indexing and Query

The ability of ObjectDB to index collections, including collections of strings, can be very useful in text indexing and search. By splitting document text into words and keeping these words in a List persistent field, documents that contain specific words can be retrieved easily
Forum
25

Search with wildcards and index issue

annotations: @Index(unique="true") @Column(nullable=false,unique=true) the search no longer works. I ... in LIKE was ignored when using an index. Build 2.3.7_11 fixes this bug. Thank you for your report. pedwards
Issue
25

Support for case-insensitive indexes

I would like to request support for case insensitive string indexes. Case-insensitive search is a very common requirement and adding a separate field for every indexed field is a pain. Regards, Natalia.   natmaclin lwalkowski
Issue
25

InternalException when querying indexed field using a list that contains duplicates

is an indexed String field on the candidate class :ids is a list which contains a duplicate entry