SIMILAR TO: matching engine can fail for records that come from "UNION ALL" datasource --------------------------------------------------------------------------------------
Key: CORE-4750 URL: http://tracker.firebirdsql.org/browse/CORE-4750 Project: Firebird Core Issue Type: Bug Reporter: Pavel Zotov Test: ==== select str ,ptn ,hash( trim(ptn) ) trim_ptn_hash ,iif( str similar to trim(ptn), 1, 0 ) "str similar to ptn" from( select --'a1' str, '_' ptn from rdb$database union all select -- false 'a' str, '[[:DIGIT:]]' ptn from rdb$database union all select -- false '4', '[^[:DIGIT:]]' from rdb$database union all select -- false 'a', '[^[:DIGIT:]]' from rdb$database -- TRUE! ); ----------------------------------------------------------------------------- select str ,ptn ,hash( trim(ptn) ) trim_ptn_hash ,iif( str similar to trim(ptn), 1, 0 ) "str similar to ptn" from( select 'a1' str, '_' ptn from rdb$database union all select -- false 'a' str, '[[:DIGIT:]]' ptn from rdb$database union all select -- false '4', '[^[:DIGIT:]]' from rdb$database union all select -- false 'a', '[^[:DIGIT:]]' from rdb$database -- TRUE! ); ------------------------------------------------------------------------ select str ,ptn ,hash( trim(ptn) ) trim_ptn_hash ,iif( str similar to trim(ptn), 1, 0 ) "str similar to ptn" from( select 'a' str, '[[:DIGIT:]]' ptn from rdb$database union all select -- false '4', '[^[:DIGIT:]]' from rdb$database union all select -- false 'a', '[^[:DIGIT:]]' from rdb$database union all select -- TRUE! 'a1' str, '_' ptn from rdb$database -- false ); Output for WI-T3.0.0.31780, WI-V2.5.4.26857, LI-T3.0.0.31780 and LI-V2.5.4.26821: STR PTN TRIM_PTN_HASH str similar to ptn ====== ============ ===================== ================== a [[:DIGIT:]] 106577696555053 0 4 [^[:DIGIT:]] 1710765161480237 0 a [^[:DIGIT:]] 1710765161480237 1 --- YES, it is correct. STR PTN TRIM_PTN_HASH str similar to ptn ====== ============ ===================== ================== a1 _ 95 0 a [[:DIGIT:]] 106577696555053 0 4 [^[:DIGIT:]] 1710765161480237 0 a [^[:DIGIT:]] 1710765161480237 0 ----------------------------------------- <<<<<<<<<<<<<< ??? <<<<<<<<<<<<<< STR PTN TRIM_PTN_HASH str similar to ptn ====== ============ ===================== ================== a [[:DIGIT:]] 106577696555053 0 4 [^[:DIGIT:]] 1710765161480237 0 a [^[:DIGIT:]] 1710765161480237 0 ----------------------------------------- <<<<<<<<<<<<<< ??? <<<<<<<<<<<<<< a1 _ 95 0 -- 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 ------------------------------------------------------------------------------ BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel