hi - can you please create a self-contained MCVE and post to https://github.com/sqlalchemy/sqlalchemy/issues - thanks.
- mike On Mon, Jun 21, 2021, at 5:25 AM, Julien Cigar wrote: > ok .. :) > > Another regression from 1.3: I have two deferred column_property on my > mapped class (1) and with (2) I'm getting a > sqlalchemy.exc.ProgrammingError: sqlalchemy.exc.ProgrammingError: > (psycopg2.errors.InvalidColumnReference) WITH query "parents" has 21 > columns available but 23 columns specified. > > The generated query is (3), which is wrong: it includes deferred columns > in the WITH RECUSRIVE statement but don't load them in the SELECT > clause. If I'm set deferred=False in (1) then is works as expected > (generated query is (4)) > > (1) > https://github.com/silenius/amnesia/blob/dev/amnesia/modules/content/mapper.py#L117-L130 > (2) https://gist.github.com/silenius/34ce40ed288c6a681058ab064147bd70 > (3) https://gist.github.com/silenius/02a8c2481f77ca1a1ec05bfad830821d > (4) https://gist.github.com/silenius/5de95ceddd14e62bfc3e52366643bd32 > > Julien > > On Fri, Jun 18, 2021 at 10:11:10AM -0400, Mike Bayer wrote: > > > > that's a really obscure API you found there. Coverage for that wasn't > > carried along to 1.4 unfortunately so you'd need to assemble that list > > outside of the and_() first for now. > > > > > > On Fri, Jun 18, 2021, at 4:08 AM, Julien Cigar wrote: > > > Hello, > > > > > > While updating SQLAlchemy dependency to 1.4 (from 1.3) I noticed that I > > > couldn't use .append() on an existing sql.and_() clause .. is it > > > expected..? > > > > > > The problematic code is > > > https://gist.github.com/silenius/7d3043d64fddaa8474dcd062e23ced44 (line > > > 18-21) > > > > > > Another example that worked with 1.3: > > > https://gist.github.com/silenius/2054e7dc690946c0122c72e6b05f1433 > > > > > > Thanks, > > > Julien > > > > > > -- > > > Julien Cigar > > > Belgian Biodiversity Platform (http://www.biodiversity.be) > > > PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 > > > No trees were killed in the creation of this message. > > > However, many electrons were terribly inconvenienced. > > > > > > -- > > > SQLAlchemy - > > > The Python SQL Toolkit and Object Relational Mapper > > > > > > http://www.sqlalchemy.org/ > > > > > > To post example code, please provide an MCVE: Minimal, Complete, and > > > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > > > description. > > > --- > > > You received this message because you are subscribed to the Google Groups > > > "sqlalchemy" group. > > > To unsubscribe from this group and stop receiving emails from it, send an > > > email to sqlalchemy+unsubscr...@googlegroups.com > > > <mailto:sqlalchemy%2Bunsubscribe%40googlegroups.com> > > > <mailto:sqlalchemy%2Bunsubscribe%40googlegroups.com>. > > > To view this discussion on the web visit > > > https://groups.google.com/d/msgid/sqlalchemy/20210618080804.b47v72c3whdaluyh%40x1. > > > > > > > -- > > SQLAlchemy - > > The Python SQL Toolkit and Object Relational Mapper > > > > http://www.sqlalchemy.org/ > > > > To post example code, please provide an MCVE: Minimal, Complete, and > > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > > description. > > --- > > You received this message because you are subscribed to the Google Groups > > "sqlalchemy" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to sqlalchemy+unsubscr...@googlegroups.com > > <mailto:sqlalchemy%2Bunsubscribe%40googlegroups.com>. > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/sqlalchemy/31f1f804-21f2-4faa-9a71-ef356149248a%40www.fastmail.com. > > -- > Julien Cigar > Belgian Biodiversity Platform (http://www.biodiversity.be) > PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 > No trees were killed in the creation of this message. > However, many electrons were terribly inconvenienced. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy%2Bunsubscribe%40googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/20210621092524.pzzpcnn5nkuxsr6y%40x1. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/8525c6a5-041d-4f1c-a05b-1a01444a17e8%40www.fastmail.com.
