Re: SELECT 42 AS a, a AS b FROM system.iota

From: dtmackenzie <david.mackenzie@xxxxxxxxxxxx>
Date: Wed, 13 Feb 2008 05:35:49 -0800 (PST)

I'm wondering if a is a column of system.iota ...

David, does "select a as b from system.iota" work ?

Luc.

Luc, system.iota in ADS is a table with a single row and a single
column, also named "iota".
As expected, "select a as b from system.iota" returns an error message
that column "a" does not exist.

My example is simplified as far as possible for demonstration purposes
but it's not just a theoretical problem - in the real SELECT I have a
longer expression instead of "42" which I would like to avoid
repeating within the expressions for several other columns.

David
.

References:
- SELECT 42 AS a, a AS b FROM system.iota
  - From: dtmackenzie
- Re: SELECT 42 AS a, a AS b FROM system.iota
  - From: mpeppler@xxxxxxxxxxx
- Re: SELECT 42 AS a, a AS b FROM system.iota
  - From: Luc Van der Veurst

Prev by Date: Re: SELECT 42 AS a, a AS b FROM system.iota
Next by Date: Re: SELECT 42 AS a, a AS b FROM system.iota
Previous by thread: Re: SELECT 42 AS a, a AS b FROM system.iota
Index(es):
- Date
- Thread