On Feb 17, 2010, at 8:58 AM, Manlio Perillo wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Michael Bayer ha scritto: >> On Feb 16, 2010, at 7:07 PM, Manlio Perillo wrote: >> >> Michael Bayer ha scritto: >>>>> [...] >>>>>> just so I can understand fully can you modify the paste I sent to >>>>>> illustrate exactly how the results are happening, as that can help me to >>>>>> formulate the best version of this feature. >> I have pasted a complete working fragment of the code I have used: >> http://paste.pocoo.org/show/179089/ >> >> >> By the way, I still have a problem when using fold_equivalents. >> http://paste.pocoo.org/show/179092/ >> >>> the feature would be built into the select(), that as each column is added, >>> if a column of the same name exists and is related by a foreign key, > it is skipped. >> > > I agree. > It should be built into the select. > > > By the way, I have found an incorrect behaviour in SQLAlchemy, when the > select column list is empty. > > query = sql.select( > None, contents.c.slug == 'python', from_obj=[join]) > > > SQLAlchemy generates an incorrect SQL query. > It should, instead, automatically add the columns from the `from_obj` > list, skipping duplicate columns involved in a join.
sounds more like an assumption to me. select(None) is specifically a select with no columns, which can be added later using column() (that might be the intent). > > > Can I fill a bug report for this? > > > Manlio > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAkt79f0ACgkQscQJ24LbaUSr/gCfatYVT36ZvK+0prqXKVcck4sI > e3YAnjgvwvi/d5qUT17gOx8DopvJvLPN > =IdpF > -----END PGP SIGNATURE----- > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
