thanks
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Doug Chamberlin
Sent: Thursday, June 21, 2012 4:12 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Left join and computed columns
On 6/21/12 3
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Left join and computed columns
Rick Debay schrieb am 19.06.2012 um 15:58 (-0400):
Since TEST_TABLE is empty, the results should be NULL.
Changing the query to 'SELECT *' return the one row in RDB$DATABASE,
and the column TEST_TABLE.ID
On 6/21/12 3:39 PM, Rick Debay wrote:
Correct. There is no row, but we are getting data in the non-existing
row.
So how do I file a bug report on this?
Go to the Firebird main web site
http://www.firebirdsql.org
Select Development.
Look for the Tracker in the upper right corner of the
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay
Sent: Thursday, May 31, 2012 11:15 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Left join and computed columns
I'll test in 2.5.1 and file a bug
Rick,
It happens in 2.5.1. How do I file a bug report?
CREATE TABLE TEST_TABLE
(
IDINTEGER,
COMPUTED_COL VARCHAR(6) COMPUTED BY ('FAILED') );
SELECT t.COMPUTED_COL
FROM RDB$DATABASE r
LEFT JOIN TEST_TABLE t
ON r.RDB$RELATION_ID = t.ID
COMPUTED_COL
-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Tuesday, June 19, 2012 2:38 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Left join and computed columns
Rick,
It happens in 2.5.1. How do I file a bug
Rick Debay schrieb am 19.06.2012 um 15:58 (-0400):
Since TEST_TABLE is empty, the results should be NULL.
Changing the query to 'SELECT *' return the one row in RDB$DATABASE,
and the column TEST_TABLE.ID is NULL and the column
TEST_TABLE.COMPUTED_COL is FAILED.
If TEST_TABLE is empty, how can
I'll test in 2.5.1 and file a bug report.
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Friday, May 25, 2012 1:04 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Left join
A query with a left join to a table with a computed column returned
values in the computed column even though the row didn't exist in the
table. All other non-computed values came back as null, which was to be
expected.
Is this a bug, or correct by SQL specifications?
Disclaimer: This message
Rick,
A query with a left join to a table with a computed column returned values in
the computed column even though the row didn't exist in the table. All
other non-computed values came back as null, which was to be expected.
Is this a bug, or correct by SQL specifications?
I don't have a
10 matches
Mail list logo