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

On Feb 12, 1:56 pm, dtmackenzie <david.macken...@[EMAIL PROTECTED]
> wrote:
> Is this a legal SELECT?
>
> I was surprised to get the following error message from ADS:
>
> poQuery: Error 7200:  AQE Error:  State = S0000;   NativeError =
> 2121;  [Extended Systems][Advantage SQL Engine]Column not found: a --
> Location of error in the SQL statement is: 17

It's legal with ASE - I just tried this with sqsh:

[23] TEST.mydb.(sa).1> select 42 as spid, spid as toto from
master..sysprocesses;

and got the expected output.

Michael