function that won’t eliminate much of what the query is
> producing?
>
> *From: *'Dan Stromberg [External]' via sqlalchemy
>
> *Date: *Tuesday, March 21, 2023 at 9:05 AM
> *To: *sqlalchemy@googlegroups.com
> *Subject: *Re: [sqlalchemy] Test query seems to spuri
t 1:11 PM
To: noreply-spamdigest via sqlalchemy
Subject: Re: [sqlalchemy] Test query seems to spuriously give
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
column 'tb_br.id' in 'on clause'")
what SQL are you going for ? start with that. On Mon, Mar 20, 2023,
[External]' via sqlalchemy
Date: Tuesday, March 21, 2023 at 9:05 AM
To: sqlalchemy@googlegroups.com
Subject: Re: [sqlalchemy] Test query seems to spuriously give
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
column 'tb_br.id' in 'on clause'")
Alright, using
To: noreply-spamdigest via sqlalchemy
Subject: Re: [sqlalchemy] Test query seems to spuriously give
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
column 'tb_br.id' in 'on clause'")
what SQL are you going for ? start with that. On Mon, Mar 20, 2023, at 10: 33
glegroups.com on behalf
> of Mike Bayer
> *Date: *Monday, March 20, 2023 at 1:11 PM
> *To: *noreply-spamdigest via sqlalchemy
> *Subject: *Re: [sqlalchemy] Test query seems to spuriously give
> sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
> column
: [sqlalchemy] Test query seems to spuriously give
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
column 'tb_br.id' in 'on clause'")
I’m getting some pushback internally, from my team lead – he and I both think
it’s probably too much detail to share. It’s 43 li
: Monday, March 20, 2023 at 1:11 PM
To: noreply-spamdigest via sqlalchemy
Subject: Re: [sqlalchemy] Test query seems to spuriously give
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
column 'tb_br.id' in 'on clause'")
what SQL are you going for ? start with that. O
at 8:01 AM
> *To: *noreply-spamdigest via sqlalchemy
> *Subject: *Re: [sqlalchemy] Test query seems to spuriously give
> sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
> column 'tb_br.id' in 'on clause'")
> the query emitted is: SELECT tb_nv. id, min(bs_3. buil
igest via sqlalchemy
Subject: Re: [sqlalchemy] Test query seems to spuriously give
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
column 'tb_br.id' in 'on clause'")
the query emitted is: SELECT tb_nv. id, min(bs_3. build_id) AS min_1 FROM
tb_nv, tb_brst AS bs_3, tb
the query emitted is:
SELECT tb_nv.id, min(bs_3.build_id) AS min_1
FROM tb_nv, tb_brst AS bs_3, tb_brst AS bs
INNER JOIN tb_vers AS v_2 ON bs.version_id = v_2.id
INNER JOIN tb_brst AS bs_2 ON tb_br.id = bs_2.branch_id
the error means that your ON clause refers to a table "tb_br" which is not
Sorry, I don’t know why Google Groups decided to aggregate a few lines into 2
large lines. Here’s that list of versions again. Hopefully GG will be
appeased this time.
I'm using:
$ python3 -m pip list -v | grep -i sqlalchemy
Flask-SQLAlchemy 2.5.1
Hi people.
I'm having trouble with a test query.
As the subject line says, I'm getting:
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1054, "Unknown
column 'tb_br.id' in 'on clause'")
But it seems like tb_br exists, and has an id column - tb_br being an empty
table, but still,
12 matches
Mail list logo