IN with string, contained multiple values -----------------------------------------
Key: CORE-3460 URL: http://tracker.firebirdsql.org/browse/CORE-3460 Project: Firebird Core Issue Type: Improvement Reporter: Maxim Kuzmin Priority: Trivial When using WHERE with IN (), for condition allowed only single value (integer or varchar). When using string-condition with multiple values, it's raise exception: SELECT FROM TABLE 1 WHERE ID IN ('1') -- OK SELECT FROM TABLE 1 WHERE ID IN ('1, 2, 4, 6') -- EXCEPTION Also, this behavior does not use string parameters, such as WHERE ID IN (:LIST_ID). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel