InterSystems Ideas
We love hearing from our users. Tell us what you want to see next and upvote ideas from the community.
* Bugs and troubleshooting should as usual go through InterSystems support.
Add a new idea Subscribe
Status Implemented
Categories Bug reports
Created by Dmitry Maslennikov
Created on Dec 11, 2025

RELATED IDEAS

SQL: Undefined error with IN

CREATE TABLE t0(c0 BIT );
SELECT * FROM t0 WHERE (c0 IN (c0, c0, c0, c0));

produces error

SQL Error [400] [S1000]: [SQLCODE: <-400>:<Fatal error occurred>] [Location: <Prepare>] [%msg: <<UNDEFINED>in+4^%qaqpnl *mt("v","4")>]

  • ADMIN RESPONSE
    Dec 22, 2025

    Thank you for submitting the idea.

    This idea was implemented by InterSystems.

  • Post comment
  • Benjamin De Boe
    Dec 22, 2025

    FYI - this issue has now been fixed and will be included in forthcoming maintenance releases for 2024.1, 2025.1 and 2026.1

    Reply
  • Benjamin De Boe
    Dec 17, 2025

    Thanks for reporting this bug. We've filed the issue internally and will be working on a solution.

    Reply