RE: [firebird-support] Left join and computed columns

2012-06-22 Thread Rick Debay
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

RE: [firebird-support] Left join and computed columns

2012-06-21 Thread Rick Debay
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

Re: [firebird-support] Left join and computed columns

2012-06-21 Thread Doug Chamberlin
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

RE: [firebird-support] Left join and computed columns

2012-06-19 Thread Rick Debay
-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

RE: [firebird-support] Left join and computed columns

2012-06-19 Thread Leyne, Sean
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

RE: [firebird-support] Left join and computed columns

2012-06-19 Thread Rick Debay
- 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

Re: [firebird-support] Left join and computed columns

2012-06-19 Thread Michael Ludwig
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

RE: [firebird-support] Left join and computed columns

2012-05-31 Thread Rick Debay
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

[firebird-support] Left join and computed columns

2012-05-25 Thread Rick Debay
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

RE: [firebird-support] Left join and computed columns - Email found in subject

2012-05-25 Thread Leyne, Sean
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