[Firebird-devel] [FB-Tracker] Created: (CORE-1275) Cross join with empty table produce empty resultset

[Baldur F?r. (JIRA) <tr...@fi...>]

Cross join with empty table produce empty resultset
---------------------------------------------------

                 Key: CORE-1275
                 URL: http://tracker.firebirdsql.org/browse/CORE-1275
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.0.1
         Environment: Windows XP/SP2, VisualStudio6, VisualBasic
            Reporter: Baldur F?rchau
            Priority: Minor


I have two tables to join each record from left to each record to right.
If the second table has no records, i get an empty result:

select * from tablea, tableb

To temporarily solve the problem i code:

select * from tablea left join tableb on 1=1

This produce the correct result.

But if the table on the left contains no records but the right table, i get also an empty result.
In this case i must code:

select * from tablea right join tableb on 1=1

So i have to check if any table has records to code the right sql.

-- 
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