Field with a constant value in a CTE definition outputs its value rather than
NULL for unmatched records in an OUTER JOIN
-------------------------------------------------------------------------------------------------------------------------
Key: CORE-4677
URL: http://tracker.firebirdsql.org/browse/CORE-4677
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.1.7
Environment: Windows XP+, Windows Server 2003+, untested elsewhere
Reporter: Mirco Malaguti
Priority: Minor
Attachments: TEST_CTE.zip
A statement whit a CTE definition gets an incorrect result if
- a field in the CTE deinition have a constant value
- the CTE is in OUTER JOIN relationship with another table
- some records from the CTE don't match any of the other table
I expect those records reports all CTE fileds as NULL, but the field with the
constant value is not null.
Example is attached.
Mirco Malaguti
--
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
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
