Issue Details (XML | Word | Printable)

Key: DOC-142
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Paul Vinkenoog
Reporter: Paweł Krzyżanowski
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Documentation

Sql query behavior not as expected

Created: 09/Oct/19 10:13 AM   Updated: 09/Oct/19 10:13 AM
Component/s: None
Affects Version/s: None
Fix Version/s: None

Environment: Windows 10, 64 bit, Firebird 2.5.2, gds


 Description  « Hide
in
https://firebirdsql.org/manual/nullguide-predicates.html

is code:
SELECT Farmer FROM Farms WHERE EXISTS
  (SELECT * FROM Landowners
   WHERE Landowners.Name = Farms.Farmer)
   
but not working:
SELECT Farmer FROM Farms WHERE EXISTS
  (SELECT * FROM Landowners
   WHERE Landowners.Name CONTAINING Farms.Farmer)
   
(and not working with like, result is NULL)

For example 'LISA' as Farmer and 'MONALISA' as Landowners.Name
'MONALISA' CONTAINING 'LISA' but EXISTS in this query returns NULL.
Alone EXISTS returns correct dataset.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.