webleedev / typeorm Goto Github PK

Issue type:

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

Database system/driver:

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

TypeORM version:

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

Steps to reproduce or a small repository showing the problem:
Creating a large object with lots of relations can yield an update query in mysql without any values which is invalid in mysql.

UPDATE abc SET WHERE id in (NN)

Issue type:

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

Database system/driver:

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

TypeORM version:

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

Steps to reproduce or a small repository showing the problem:

@Entity()
class Parent {
  @PrimaryGeneratedColumn()
  id: number;

  @OneToMan(type => Child, Child => Child.parent)
  children: Child[]
}

@Entity()
class Child {

  @PrimaryGeneratedColumn()
  id: number;

  @Column({
    name: "parent_id"
    type: "int"
  })
  parentId: number;

  @ManyToOne(type => Parent, Parent => Parent.children)
  @JoinColumn({name: "parent_id"})
  parent: Parent;
}

const entityManager = typeorm.getConnection().getEntityManager();

const aParent = new Parent();
entityManager.save(aParent);

const aChild = new Child();
aChild.parentId = aParent.id;
aChild.parent = aParent;
entityManager.save(aChild);

Issue type:

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

Database system/driver:

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

TypeORM version:

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

Steps to reproduce or a small repository showing the problem:

Issue type:

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

Database system/driver:

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

TypeORM version:

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

Steps to reproduce or a small repository showing the problem:

1. define entity with child inheritance
2. define shared column for each child entity

notice some entities may not be inserted correctly if all entities used in save operation