QueryFailedError when use tree entity

[Yuuki-Sakura]

Issue Description

QueryFailedError when use TreeRepository

Expected Behavior

SELECT "treeEntity"."id" AS "treeEntity_id", "treeEntity"."code" AS "treeEntity_code", "treeEntity"."name" AS "treeEntity_name", "treeEntity"."longitude" AS "treeEntity_longitude", "treeEntity"."latitude" AS "treeEntity_latitude", "treeEntity"."level" AS "treeEntity_level", "treeEntity"."mpath" AS "treeEntity_mpath", "treeEntity"."parent_id" AS "treeEntity_parent_id" FROM "district" "treeEntity" WHERE "treeEntity"."parent_id" IS NULL

Actual Behavior

[Nest Shop] [INFO] [2021-12-10 14:18:52.819 PM +0800] [TypeORM] [query-id: pytz79nUvUl3y6ZVrCwm] query: SELECT "treeEntity"."id" AS "treeEntity_id", "treeEntity"."code" AS "treeEntity_code", "treeEntity"."name" AS "treeEntity_name", "treeEntity"."longitude" AS "treeEntity_longitude", "treeEntity"."latitude" AS "treeEntity_latitude", "treeEntity"."level" AS "treeEntity_level", "treeEntity"."mpath" AS "treeEntity_mpath", "treeEntity"."parent_id" AS "treeEntity_parent_id" FROM "district" "treeEntity" WHERE "treeEntity"."parentId" IS NULL - {}
[Nest Shop] [ERROR] [2021-12-10 14:18:52.843 PM +0800] [TypeORM] [query-id: pytz79nUvUl3y6ZVrCwm] query: SELECT "treeEntity"."id" AS "treeEntity_id", "treeEntity"."code" AS "treeEntity_code", "treeEntity"."name" AS "treeEntity_name", "treeEntity"."longitude" AS "treeEntity_longitude", "treeEntity"."latitude" AS "treeEntity_latitude", "treeEntity"."level" AS "treeEntity_level", "treeEntity"."mpath" AS "treeEntity_mpath", "treeEntity"."parent_id" AS "treeEntity_parent_id" FROM "district" "treeEntity" WHERE "treeEntity"."parentId" IS NULL - {
  stack: [
    {
      length: 185,
      name: 'error',
      severity: 'ERROR',
      code: '42703',
      hint: 'Perhaps you meant to reference the column "treeEntity.parent_id".',
      position: '406',
      file: 'parse_relation.c',
      line: '3503',
      routine: 'errorMissingColumn'
    }
  ]
}

Steps to Reproduce

1. add tree entity and JoinColumn decorator

import {
  Column,
  Entity,
  Index,
  JoinColumn,
  PrimaryGeneratedColumn,
  Tree,
  TreeChildren,
  TreeParent,
} from 'typeorm';

export enum DistrictLevel {
  Country = 'country', //国家
  Province = 'province', //省份
  City = 'city', //城市
  District = 'district', //县/区
  Street = 'street', //街道
}

@Entity('district')
@Tree('materialized-path')
export class DistrictEntity {
  @PrimaryGeneratedColumn()
  id: number;

  @Column('varchar', {
    length: 6,
  })
  @Index()
  code: string;

  @Column()
  @Index()
  name: string;

  get location() {
    return this.longitude + ',' + this.latitude;
  }

  @Column({
    comment: '经度',
  })
  longitude: string;

  @Column({
    comment: '纬度',
  })
  latitude: string;

  @Column('simple-enum', {
    comment: '地区级别',
    enum: DistrictLevel,
  })
  level: DistrictLevel;

  @TreeParent()
  @JoinColumn({
    name: 'parent_id',
  })
  parent: DistrictEntity;

  @TreeChildren({
    cascade: true,
  })
  children: DistrictEntity[];
}

getConnection().getTreeRepository(DistrictEntity).findTrees();

My Environment

Dependency	Version
Operating System	Ubuntu 20.04
Node.js version	v14.17.1
Typescript version	^4.4.4
TypeORM version	^0.2.41
NestJS version	^8.2.2

Additional Context

can use this repository https://github.com/Yuuki-Sakura/nest-shop/tree/typeorm-issue

Relevant Database Driver(s)

DB Type	Reproducible
aurora-data-api	no
aurora-data-api-pg	no
better-sqlite3	no
cockroachdb	no
cordova	no
expo	no
mongodb	no
mysql	no
nativescript	no
oracle	no
postgres	yes
react-native	no
sap	no
sqlite	no
sqlite-abstract	no
sqljs	no
sqlserver	no

Are you willing to resolve this issue by submitting a Pull Request?

• ✖️ Yes, I have the time, and I know how to start.
• ✅ Yes, I have the time, but I don't know how to start. I would need guidance.
• ✖️ No, I don’t have the time, but I can support (using donations) development.
• ✖️ No, I don’t have the time and I’m okay to wait for the community / maintainers to resolve this issue.