Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TypeORm discard column inexistent in where #5208

Closed
saulomano opened this issue Dec 9, 2019 · 1 comment
Closed

TypeORm discard column inexistent in where #5208

saulomano opened this issue Dec 9, 2019 · 1 comment

Comments

@saulomano
Copy link

saulomano commented Dec 9, 2019

Issue type:

[ ] question
[X ] bug report
[ ] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[ ] mongodb
[ ] mssql
[X ] mysql / mariadb
[ ] oracle
[ ] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[x ] latest
[ ] @next
[ ] 0.x.x (or put your version here)

Steps to reproduce or a small repository showing the problem:

I detect a functional problem in where condition. if in where write condition that not exists column in database table and entity this is discarded and the query execute with anhoter columns.

For example

Mi code
return this.InjectRepository.findOne( { where: { servicio: tienda, tipoAnalitica:tipoAnalitica, finalzado: 0 } });

output console log

query: SELECT SincronizacionAnalitycs.id AS SincronizacionAnalitycs_id, SincronizacionAnalitycs.fecha AS SincronizacionAnalitycs_fecha, SincronizacionAnalitycs.servicio AS SincronizacionAnalitycs_servicio, SincronizacionAnalitycs.tipoAnalitica AS SincronizacionAnalitycs_tipoAnalitica, SincronizacionAnalitycs.cantidadRegistros AS SincronizacionAnalitycs_cantidadRegistros, SincronizacionAnalitycs.ultimoSincronizado AS SincronizacionAnalitycs_ultimoSincronizado, SincronizacionAnalitycs.fechadesde AS SincronizacionAnalitycs_fechadesde, SincronizacionAnalitycs.fechahasta AS SincronizacionAnalitycs_fechahasta, SincronizacionAnalitycs.finalizado AS SincronizacionAnalitycs_finalizado FROM sincronizacion_analitycs SincronizacionAnalitycs WHERE SincronizacionAnalitycs.servicio = ? AND SincronizacionAnalitycs.tipoAnalitica = ? LIMIT 1 -- PARAMETERS: ["YOUTUBE","TRACK"]

In the code of sinxtax where the problem it's a colum finalzado that is bad write. When print output log the column is SincronizacionAnalitycs.finalizado.

Maybe it's a framework functionality

@imnotjames
Copy link
Contributor

Duplicate of #3416

@imnotjames imnotjames marked this as a duplicate of #3416 Oct 12, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants