You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
[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.
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_analitycsSincronizacionAnalitycs 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
The text was updated successfully, but these errors were encountered:
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
ASSincronizacionAnalitycs_id
,SincronizacionAnalitycs
.fecha
ASSincronizacionAnalitycs_fecha
,SincronizacionAnalitycs
.servicio
ASSincronizacionAnalitycs_servicio
,SincronizacionAnalitycs
.tipoAnalitica
ASSincronizacionAnalitycs_tipoAnalitica
,SincronizacionAnalitycs
.cantidadRegistros
ASSincronizacionAnalitycs_cantidadRegistros
,SincronizacionAnalitycs
.ultimoSincronizado
ASSincronizacionAnalitycs_ultimoSincronizado
,SincronizacionAnalitycs
.fechadesde
ASSincronizacionAnalitycs_fechadesde
,SincronizacionAnalitycs
.fechahasta
ASSincronizacionAnalitycs_fechahasta
,SincronizacionAnalitycs
.finalizado
ASSincronizacionAnalitycs_finalizado
FROMsincronizacion_analitycs
SincronizacionAnalitycs
WHERESincronizacionAnalitycs
.servicio
= ? ANDSincronizacionAnalitycs
.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
The text was updated successfully, but these errors were encountered: