Baike.dev
All toolsAI codingTrendingOpen sourceNewsSubmit
Log in
Back to tool/Back to issues
#274·lovefield

Where clause "not in" with an empty array always returns false

Author: germancolladoCreated May 7, 2021Updated Feb 17, 2022

Version: 2.1.12

javascript
await db
  .select(table.id)
  .from(table)
  .where(
    lf.op.not(
      table.id.in([])
    )
  )
  .exec()

Repro: https://codepen.io/colladoger/pen/oNopPJG

Source: google/lovefield

View original on GitHubView discussion on GitHub