On Mon, Jun 21, 2010 at 5:55 PM, Michael Bayer <mike...@zzzcomputing.com> wrote:
> not a bug, that's the correct behavior.

Can you explain how it is correct? I asked for two things but I only
got one. Why should it matter if they happen to be the /same/ thing?

In this particular case, I need it for what ultimately becomes an
insert into (....) select (this, that, theother, col1, col1)


> On Jun 21, 2010, at 5:35 PM, Jon Nelson wrote:
>
>> I'm encountering a problem with SA 0.6.1
>> I have a select statement which selects the same column twice (and
>> some other stuff, too).
>> However, when the query is run (or printed), the column only shows up once.
>> This seems like a bug.
>>
>> Example:
>>
>> from sqlalchemy import create_engine, select, Table, Column, INT, MetaData
>> e = create_engine('sqlite://')
>> meta = MetaData(bind=e)
>> t = Table( 'test', meta, Column( 'c1', INT() ) )
>> meta.create_all()
>> print select([t.c.c1, t.c.c1])
>>
>> I expected:
>>
>> SELECT test.c1, test.c1
>> FROM test
>>
>> I got:
>>
>> SELECT test.c1
>> FROM test
>>
>> --
>> Jon
>>
>> --
>> You received this message because you are subscribed to the Google Groups 
>> "sqlalchemy" group.
>> To post to this group, send email to sqlalch...@googlegroups.com.
>> To unsubscribe from this group, send email to 
>> sqlalchemy+unsubscr...@googlegroups.com.
>> For more options, visit this group at 
>> http://groups.google.com/group/sqlalchemy?hl=en.
>>
>
> --
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To post to this group, send email to sqlalch...@googlegroups.com.
> To unsubscribe from this group, send email to 
> sqlalchemy+unsubscr...@googlegroups.com.
> For more options, visit this group at 
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>



-- 
Jon

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to