2.5.1 broke query that worked with 2.5.0. Changing just one CONTAINING to LIKE
fixes the issue.
------------------------------------------------------------------------------------------------
Key: CORE-3746
URL: http://tracker.firebirdsql.org/browse/CORE-3746
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.1
Environment: windows
Reporter: flipo
2.5.1 broke query that worked with 2.5.0.
This will work on 2.5.1
select * from inventory,ItemComments where (ItemComments.GUID=Inventory.GUID)
and ItemComments.Comments LIKE '%max%' and ...other Inventory CONTAINING tests
This does not work on 2.5.1 but works with 2.5.0 ( ie
Firebird-2.5.0.26074_1_Win32.exe, Firebird-2.5.0.26074_1_x64.exe)
select * from inventory,ItemComments where (ItemComments.GUID=Inventory.GUID)
and ItemComments.Comments CONTAINING 'max' and ...save other Inventory
CONTAINING tests
The ItemComments.Comments is a blob and the other inventory CONTAINING usage is
against a mix of varchar and blobs.
No errors reported just no info received back.
--
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
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
