71 words

Search with wildcards and index issue

#1
2012-03-30 00:18

Hi,

I have a search using wildcards: SELECT $1 FROM CDI $1 WHERE $1.loginId LIKE '%*_last%2' ESCAPE '*'

This works perfectly when loginId has NO annotations.

Now if I add to loginId the following annotations:

@Index(unique="true")
@Column(nullable=false,unique=true)

the search no longer works.

I have attached the unit test. (this is using 2.3.7_10)

Thanks

Paul.

pedwards
pedwards's picture
Joined on 2011-06-06
User Post #21
#2
2012-03-30 14:27

Your test demonstrates that ESCAPE in LIKE was ignored when using an index.

Build 2.3.7_11 fixes this bug. Thank you for your report.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support
support's picture
Joined on 2010-05-03
User Post #995

Post Reply

Please read carefully the posting instructions - before posting to the ObjectDB website.

  • You may have to disable pop up blocking in order to use the toolbar (e.g. in Chrome).
  • Use ctrl + right click to open the browser context menu in the editing area (e.g. for using a browser spell checker).
  • To insert formatted lines (e.g. Java code, stack trace) - select a style in the toolbar and then insert the text in the new created block.
  • Avoid overflow of published source code examples by breaking long lines.
  • You may mark in paragraph code words (e.g. class names) with the code style (can be applied by ctrl + D).
  • Long stack traces (> 50 lines) and complex source examples (> 100 lines) should be posted as attachments.
Attachments:
Maximum file size: 32 MB
Cancel