Use of the LIKE operator #85

Activity

1. david-alm commented on Dec 15, 2020

   

   david-alm

   on Dec 15, 2020

   Last edited by david-alm

   Author

   More actions

   Here's a quick repro of the issue:

   import databases
   import orm
   import sqlalchemy
   
   database = databases.Database("sqlite:///db.sqlite")
   metadata = sqlalchemy.MetaData()
   
   
   class Note(orm.Model):
       __tablename__ = "notes"
       __database__ = database
       __metadata__ = metadata
   
       id = orm.Integer(primary_key=True)
       text = orm.String(max_length=100)
       completed = orm.Boolean(default=False)
   
   # Create the database
   engine = sqlalchemy.create_engine(str(database.url))
   metadata.create_all(engine)
   
   # Create three somewhat similar notes
   await Note.objects.create(text="Find the first bug", completed=True)
   await Note.objects.create(text="Find the second bug", completed=False)
   await Note.objects.create(text="find_the_second_bug", completed=False)
   
   # Search for `find%`
   await Note.objects.filter(text__iexact="find%").all() 
   # This returns all 3 notes, even though none of them is "lowercase exact" `find%`
   
   # In the same vein, this occurs with `_` as well
   await Note.objects.filter(text__iexact="find_the_second_bug").all() 
   # This returns the last 2 notes.
   
2. lovelydinosaur

   closed this as completedon Mar 15, 2021
3. encode

   locked and limited conversation to collaborators on Mar 15, 2021