Started by user Jenkins Admin Obtained pipelines/pingcap/tidb/latest/merged_integration_nodejs_test.groovy from git https://github.com/PingCAP-QE/ci.git Loading library tipipeline@main Library tipipeline@main is cached. Copying from home. [Pipeline] Start of Pipeline [Pipeline] readJSON [Pipeline] readTrusted Obtained pipelines/pingcap/tidb/latest/pod-merged_integration_nodejs_test.yaml from git https://github.com/PingCAP-QE/ci.git [Pipeline] podTemplate [Pipeline] { [Pipeline] node Created Pod: kubernetes jenkins-tidb/pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv Agent pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv is provisioned from template pingcap_tidb_merged_integration_nodejs_test_1073-1bsql-9ll89 --- apiVersion: "v1" kind: "Pod" metadata: annotations: buildUrl: "http://jenkins.apps.svc.cluster.local:8080/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/" runUrl: "job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/" labels: jenkins/jenkins-jenkins-agent: "true" jenkins/label-digest: "0fa2ca219c7fb81d7c66b16e7cf023b1e19137fe" jenkins/label: "pingcap_tidb_merged_integration_nodejs_test_1073-1bsql" name: "pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv" namespace: "jenkins-tidb" spec: affinity: nodeAffinity: requiredDuringSchedulingIgnoredDuringExecution: nodeSelectorTerms: - matchExpressions: - key: "kubernetes.io/arch" operator: "In" values: - "amd64" containers: - image: "hub.pingcap.net/ee/ci/base:v20230810-go1.21.0" name: "nodejs" resources: limits: memory: "16Gi" cpu: "6" requests: memory: "12Gi" cpu: "4" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/network-multitool" name: "net-tool" resources: limits: memory: "128Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/python3-requests:latest" name: "report" resources: limits: memory: "256Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - env: - name: "JENKINS_SECRET" value: "********" - name: "JENKINS_TUNNEL" value: "jenkins-agent.apps.svc.cluster.local:50000" - name: "JENKINS_AGENT_NAME" value: "pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv" - name: "JENKINS_NAME" value: "pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv" - name: "JENKINS_AGENT_WORKDIR" value: "/home/jenkins/agent" - name: "JENKINS_URL" value: "http://jenkins.apps.svc.cluster.local:8080/jenkins/" image: "jenkins/inbound-agent:3206.vb_15dcf73f6a_9-2" name: "jnlp" resources: requests: memory: "256Mi" cpu: "100m" volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false restartPolicy: "Never" securityContext: runAsUser: 0 volumes: - emptyDir: medium: "" name: "workspace-volume" Running on pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test [Pipeline] { [Pipeline] stage [Pipeline] { (Declarative: Checkout SCM) [Pipeline] checkout The recommended git tool is: git No credentials specified Cloning the remote Git repository Using shallow clone with depth 1 Cloning repository https://github.com/PingCAP-QE/ci.git > git init /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test # timeout=10 Fetching upstream changes from https://github.com/PingCAP-QE/ci.git > git --version # timeout=10 > git --version # 'git version 2.39.2' > git fetch --tags --force --progress --depth=1 -- https://github.com/PingCAP-QE/ci.git +refs/heads/*:refs/remotes/origin/* # timeout=5 Avoid second fetch Checking out Revision 03312178c534dce949face80c69812d989e55009 (origin/main) Commit message: "fix(br): use failpoint tidb-server instead (#2951)" > git config remote.origin.url https://github.com/PingCAP-QE/ci.git # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 > git rev-parse origin/main^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f 03312178c534dce949face80c69812d989e55009 # timeout=10 > git rev-list --no-walk 03312178c534dce949face80c69812d989e55009 # timeout=10 [Pipeline] } [Pipeline] // stage [Pipeline] withEnv [Pipeline] { [Pipeline] container [Pipeline] { [Pipeline] withEnv [Pipeline] { [Pipeline] timeout Timeout set to expire in 1 hr 0 min [Pipeline] { [Pipeline] stage [Pipeline] { (Debug info) [Pipeline] container [Pipeline] { [Pipeline] sh + printenv JENKINS_HOME=/var/jenkins_home KUBERNETES_SERVICE_PORT=443 KUBERNETES_PORT=tcp://10.233.0.1:443 GIT_PREVIOUS_SUCCESSFUL_COMMIT=03312178c534dce949face80c69812d989e55009 CI=true JOB_SPEC={"type":"postsubmit","job":"pingcap/tidb/merged_integration_nodejs_test","buildid":"1787656448361107463","prowjobid":"7e765a46-1cb9-406b-8282-299ff67afff8","refs":{"org":"pingcap","repo":"tidb","repo_link":"https://github.com/pingcap/tidb","base_ref":"master","base_sha":"b6435d1fb1293b94da1eec310925061d75b93f77","base_link":"https://github.com/pingcap/tidb/compare/e3c2c301823e...b6435d1fb129"}} HOSTNAME=pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv POD_LABEL=pingcap_tidb_merged_integration_nodejs_test_1073-1bsql RUN_CHANGES_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/display/redirect?page=changes GIT_COMMIT=03312178c534dce949face80c69812d989e55009 HUDSON_URL=https://do.pingcap.net/jenkins/ NODE_LABELS=pingcap_tidb_merged_integration_nodejs_test_1073-1bsql pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv HOME=/root OLDPWD=/go BUILD_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/ JENKINS_SERVER_COOKIE=durable-cdce0f14ea3897cfef48de2ecfd144333c9fdfa39b50e61400a6ccaf217899cc FILE_SERVER_URL=http://fileserver.pingcap.net WORKSPACE=/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test PROW_JOB_ID=7e765a46-1cb9-406b-8282-299ff67afff8 NODE_NAME=pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv POD_CONTAINER=nodejs RUN_ARTIFACTS_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/display/redirect?page=artifacts EXECUTOR_NUMBER=0 GIT_BRANCH=origin/main STAGE_NAME=Debug info TERM=xterm KUBERNETES_PORT_443_TCP_ADDR=10.233.0.1 BUILD_DISPLAY_NAME=#1073 RUN_TESTS_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/display/redirect?page=tests HUDSON_HOME=/var/jenkins_home JOB_BASE_NAME=merged_integration_nodejs_test PATH=/root/.cargo/bin:/go/bin:/usr/local/go/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/jvm/java-17-openjdk-amd64/bin:/opt/gradle-7.4.2/bin:/opt/apache-maven-3.8.8/bin KUBERNETES_PORT_443_TCP_PORT=443 BUILD_ID=1787656448361107463 KUBERNETES_PORT_443_TCP_PROTO=tcp BUILD_TAG=jenkins-pingcap-tidb-merged_integration_nodejs_test-1073 JENKINS_URL=https://do.pingcap.net/jenkins/ GIT_URL=https://github.com/PingCAP-QE/ci.git JOB_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/ BUILD_NUMBER=1073 GOPATH=/go GOPROXY=http://goproxy.apps.svc,https://proxy.golang.org,direct JENKINS_NODE_COOKIE=b946df5c-06b6-48ec-8aff-978aeaac4278 RUN_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/display/redirect HUDSON_SERVER_COOKIE=83ef27fe9acccc92 JOB_DISPLAY_URL=https://do.pingcap.net/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/display/redirect KUBERNETES_PORT_443_TCP=tcp://10.233.0.1:443 KUBERNETES_SERVICE_PORT_HTTPS=443 CLASSPATH= JOB_NAME=pingcap/tidb/merged_integration_nodejs_test JAVA_HOME=/usr/lib/jvm/java-17-openjdk-amd64 KUBERNETES_SERVICE_HOST=10.233.0.1 PWD=/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test GIT_PREVIOUS_COMMIT=03312178c534dce949face80c69812d989e55009 WORKSPACE_TMP=/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test@tmp GOLANG_VERSION=1.21.0 + echo ------------------------- ------------------------- + echo debug command: kubectl -n jenkins-tidb exec -ti pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv bash debug command: kubectl -n jenkins-tidb exec -ti pingcap-tidb-merged-integration-nodejs-test-1073-1bsql-9l-3ngcv bash [Pipeline] } [Pipeline] // container [Pipeline] container [Pipeline] { [Pipeline] sh + dig github.com ; <<>> DiG 9.18.16 <<>> github.com ;; global options: +cmd ;; Got answer: ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 22871 ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1 ;; OPT PSEUDOSECTION: ; EDNS: version: 0, flags:; udp: 1232 ; COOKIE: a471c2fb80d88adf (echoed) ;; QUESTION SECTION: ;github.com. IN A ;; ANSWER SECTION: github.com. 24 IN A 20.205.243.166 ;; Query time: 0 msec ;; SERVER: 169.254.25.10#53(169.254.25.10) (UDP) ;; WHEN: Tue May 07 01:32:12 UTC 2024 ;; MSG SIZE rcvd: 77 [Pipeline] } [Pipeline] // container [Pipeline] } [Pipeline] // stage [Pipeline] stage [Pipeline] { (Checkout) [Pipeline] timeout Timeout set to expire in 5 min 0 sec [Pipeline] { [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb [Pipeline] { [Pipeline] cache Cache restored successfully (git/pingcap/tidb/rev-e3c2c30-764c03c) 463653376 bytes in 6.03 secs (76926367 bytes/sec) [Pipeline] { [Pipeline] retry [Pipeline] { [Pipeline] script [Pipeline] { [Pipeline] sh git version 2.39.2 Reinitialized existing Git repository in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb/.git/ .git HEAD is now at 2168fc0cf6 Merge commit '764c03c5659efaf4dbc9b48d197d7ef1a765c4eb' into HEAD POST git-upload-pack (383 bytes) POST git-upload-pack (973 bytes) From https://github.com/pingcap/tidb e3c2c30182..b6435d1fb1 master -> origin/master Warning: you are leaving 1 commit behind, not connected to any of your branches: 2168fc0cf6 Merge commit '764c03c5659efaf4dbc9b48d197d7ef1a765c4eb' into HEAD If you want to keep it by creating a new branch, this may be a good time to do so with: git branch 2168fc0cf6 HEAD is now at b6435d1fb1 variable: add all text series types into tidb_analyze_skip_column_types (#52663) 🚧 Checkouting to base SHA:b6435d1fb1293b94da1eec310925061d75b93f77... HEAD is now at b6435d1fb1 variable: add all text series types into tidb_analyze_skip_column_types (#52663) βœ… Checked. πŸŽ‰ 🧾 HEAD info: b6435d1fb1293b94da1eec310925061d75b93f77 b6435d1fb1 variable: add all text series types into tidb_analyze_skip_column_types (#52663) e3c2c30182 br: Add goleak test for br integration test (#52741) b421b729c8 planner: merge fast plan cache and normal plan cache (#53033) βœ… ~~~~~All done.~~~~~~ [Pipeline] } [Pipeline] // script [Pipeline] } [Pipeline] // retry [Pipeline] } Cache not saved (git/pingcap/tidb/rev-b6435d1 already exists) [Pipeline] // cache [Pipeline] } [Pipeline] // dir [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test [Pipeline] { [Pipeline] cache Cache restored successfully (git/PingCAP-QE/tidb-test/rev-92fc1f42c82c5ba25b0c996eedcf16992ac394a7) 609671680 bytes in 3.22 secs (189242340 bytes/sec) [Pipeline] { [Pipeline] retry [Pipeline] { [Pipeline] script [Pipeline] { [Pipeline] checkout The recommended git tool is: NONE using credential github-sre-bot-ssh Warning: JENKINS-30600: special launcher org.csanchez.jenkins.plugins.kubernetes.pipeline.ContainerExecDecorator$1@7eff3f72; decorates RemoteLauncher[hudson.remoting.Channel@55018ccf:JNLP4-connect connection from 10.233.102.81/10.233.102.81:46608] will be ignored (a typical symptom is the Git executable not being run inside a designated container) Fetching changes from the remote Git repository Pruning obsolete local branches Cleaning workspace > git rev-parse --resolve-git-dir /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/.git # timeout=10 > git config remote.origin.url git@github.com:PingCAP-QE/tidb-test.git # timeout=10 > git rev-parse --verify HEAD # timeout=10 Resetting working tree > git reset --hard # timeout=10 > git clean -fdx # timeout=10 Fetching upstream changes from git@github.com:PingCAP-QE/tidb-test.git > git --version # timeout=10 > git --version # 'git version 2.39.2' using GIT_SSH to set credentials [INFO] Currently running in a labeled security context > /usr/bin/chcon --type=ssh_home_t /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test@tmp/jenkins-gitclient-ssh4620093283482981684.key > git fetch --tags --force --progress --prune -- git@github.com:PingCAP-QE/tidb-test.git +refs/heads/*:refs/remotes/origin/* # timeout=5 Checking out Revision fdf9e25157e264e347ca64437a518f8792bd78f2 (origin/master) > git rev-parse origin/master^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f fdf9e25157e264e347ca64437a518f8792bd78f2 # timeout=10 Commit message: "*: change the default value for tidb_analyze_skip_column_types | tidb=pr/52663 (#2319)" [Pipeline] } [Pipeline] // script [Pipeline] } [Pipeline] // retry [Pipeline] } Cache saved successfully (git/PingCAP-QE/tidb-test/rev-b6435d1fb1293b94da1eec310925061d75b93f77) 609673728 bytes in 13.63 secs (44745224 bytes/sec) [Pipeline] // cache [Pipeline] } [Pipeline] // dir [Pipeline] } [Pipeline] // timeout [Pipeline] } [Pipeline] // stage [Pipeline] stage [Pipeline] { (Prepare) [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb [Pipeline] { [Pipeline] sh + [ -f bin/tidb-server ] + make CGO_ENABLED=1 GO111MODULE=on go build -tags codes -ldflags '-X "github.com/pingcap/tidb/pkg/parser/mysql.TiDBReleaseVersion=v8.2.0-alpha-88-gb6435d1fb1" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBBuildTS=2024-05-07 01:32:55" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBGitHash=b6435d1fb1293b94da1eec310925061d75b93f77" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBGitBranch=HEAD" -X "github.com/pingcap/tidb/pkg/util/versioninfo.TiDBEdition=Community" ' -o bin/tidb-server ./cmd/tidb-server go: downloading github.com/opentracing/opentracing-go v1.2.0 go: downloading github.com/pingcap/log v1.1.1-0.20240314023424-862ccc32f18d go: downloading github.com/prometheus/client_golang v1.19.0 go: downloading github.com/tikv/pd/client v0.0.0-20240430080403-1679dbca25b3 go: downloading github.com/tikv/client-go/v2 v2.0.8-0.20240430145241-6cb0704fce51 go: downloading go.uber.org/zap v1.27.0 go: downloading go.uber.org/automaxprocs v1.5.3 go: downloading github.com/pingcap/failpoint v0.0.0-20220801062533-2eaa32854a6c go: downloading github.com/pingcap/errors v0.11.5-0.20240318064555-6bd07397691f go: downloading github.com/lestrrat-go/jwx/v2 v2.0.21 go: downloading github.com/google/pprof v0.0.0-20240117000934-35fc243c5815 go: downloading github.com/pingcap/kvproto v0.0.0-20240227073058-929ab83f9754 go: downloading github.com/dgraph-io/ristretto v0.1.1 go: downloading github.com/gogo/protobuf v1.3.2 go: downloading github.com/twmb/murmur3 v1.1.6 go: downloading google.golang.org/grpc v1.63.2 go: downloading github.com/BurntSushi/toml v1.3.2 go: downloading github.com/pingcap/tipb v0.0.0-20240318032315-55a7867ddd50 go: downloading golang.org/x/sys v0.19.0 go: downloading github.com/uber/jaeger-client-go v2.22.1+incompatible go: downloading go.uber.org/atomic v1.11.0 go: downloading github.com/ngaut/pools v0.0.0-20180318154953-b7bc8c42aac7 go: downloading go.etcd.io/etcd/client/v3 v3.5.12 go: downloading github.com/golang/protobuf v1.5.4 go: downloading github.com/grpc-ecosystem/go-grpc-middleware v1.4.0 go: downloading golang.org/x/net v0.24.0 go: downloading github.com/stretchr/testify v1.9.0 go: downloading gopkg.in/yaml.v2 v2.4.0 go: downloading github.com/jellydator/ttlcache/v3 v3.0.1 go: downloading github.com/shirou/gopsutil/v3 v3.24.2 go: downloading github.com/opentracing/basictracer-go v1.0.0 go: downloading github.com/otiai10/copy v1.2.0 go: downloading go.etcd.io/etcd/api/v3 v3.5.12 go: downloading github.com/influxdata/tdigest v0.0.1 go: downloading github.com/dolthub/swiss v0.2.1 go: downloading golang.org/x/exp v0.0.0-20240404231335-c0f41cb1a7a0 go: downloading github.com/gorilla/mux v1.8.0 go: downloading github.com/danjacques/gofslock v0.0.0-20191023191349-0a45f885bc37 go: downloading golang.org/x/sync v0.7.0 go: downloading github.com/google/uuid v1.6.0 go: downloading github.com/spf13/pflag v1.0.5 go: downloading github.com/YangKeao/ldap/v3 v3.4.5-0.20230421065457-369a3bab1117 go: downloading github.com/coocood/freecache v1.2.1 go: downloading github.com/pingcap/sysutil v1.0.1-0.20240311050922-ae81ee01f3a5 go: downloading github.com/cznic/mathutil v0.0.0-20181122101859-297441e03548 go: downloading github.com/tiancaiamao/gp v0.0.0-20221230034425-4025bc8a4d4a go: downloading golang.org/x/text v0.14.0 go: downloading github.com/docker/go-units v0.5.0 go: downloading go.uber.org/mock v0.4.0 go: downloading github.com/go-sql-driver/mysql v1.7.1 go: downloading github.com/tidwall/btree v1.7.0 go: downloading github.com/ngaut/sync2 v0.0.0-20141008032647-7a24ed77b2ef go: downloading github.com/blacktear23/go-proxyprotocol v1.0.6 go: downloading github.com/klauspost/compress v1.17.7 go: downloading github.com/pingcap/fn v1.0.0 go: downloading github.com/golang/snappy v0.0.4 go: downloading github.com/google/btree v1.1.2 go: downloading go.uber.org/multierr v1.11.0 go: downloading github.com/soheilhy/cmux v0.1.5 go: downloading github.com/tiancaiamao/appdash v0.0.0-20181126055449-889f96f722a2 go: downloading github.com/sourcegraph/appdash-data v0.0.0-20151005221446-73f23eafcf67 go: downloading github.com/prometheus/client_model v0.6.1 go: downloading github.com/cockroachdb/errors v1.11.1 go: downloading golang.org/x/time v0.5.0 go: downloading gopkg.in/natefinch/lumberjack.v2 v2.2.1 go: downloading github.com/asaskevich/govalidator v0.0.0-20230301143203-a9d515a09cc2 go: downloading github.com/wangjohn/quickselect v0.0.0-20161129230411-ed8402a42d5f go: downloading github.com/cloudfoundry/gosigar v1.3.6 go: downloading github.com/dolthub/maphash v0.1.0 go: downloading golang.org/x/tools v0.20.0 go: downloading github.com/robfig/cron/v3 v3.0.1 go: downloading github.com/cespare/xxhash/v2 v2.3.0 go: downloading github.com/aws/aws-sdk-go v1.50.0 go: downloading github.com/joho/sqltocsv v0.0.0-20210428211105-a6d6801d59df go: downloading github.com/carlmjohnson/flagext v0.21.0 go: downloading github.com/cheggaaa/pb/v3 v3.0.8 go: downloading cloud.google.com/go/storage v1.36.0 go: downloading github.com/Azure/azure-sdk-for-go/sdk/azcore v1.9.1 go: downloading github.com/Azure/azure-sdk-for-go/sdk/azidentity v1.5.1 go: downloading github.com/Azure/azure-sdk-for-go/sdk/storage/azblob v1.0.0 go: downloading github.com/aliyun/alibaba-cloud-sdk-go v1.61.1581 go: downloading github.com/go-resty/resty/v2 v2.11.0 go: downloading github.com/ks3sdklib/aws-sdk-go v1.2.9 go: downloading golang.org/x/oauth2 v0.18.0 go: downloading google.golang.org/api v0.162.0 go: downloading github.com/cockroachdb/pebble v1.1.0 go: downloading github.com/spkg/bom v1.0.0 go: downloading github.com/xitongsys/parquet-go v1.5.5-0.20201110004701-b09c49d6d457 go: downloading github.com/jfcg/sorty/v2 v2.1.0 go: downloading github.com/Azure/go-ntlmssp v0.0.0-20221128193559-754e69321358 go: downloading github.com/go-asn1-ber/asn1-ber v1.5.4 go: downloading github.com/prometheus/common v0.53.0 go: downloading github.com/sourcegraph/appdash v0.0.0-20190731080439-ebfcffb1b5c0 go: downloading go.etcd.io/etcd/client/pkg/v3 v3.5.12 go: downloading github.com/remyoudompheng/bigfft v0.0.0-20230129092748-24d4a6f8daec go: downloading github.com/dgryski/go-farm v0.0.0-20200201041132-a6ae2369ad13 go: downloading github.com/pingcap/badger v1.5.1-0.20230103063557-828f39b09b6d go: downloading google.golang.org/protobuf v1.33.0 go: downloading github.com/davecgh/go-spew v1.1.2-0.20180830191138-d8f796af33cc go: downloading github.com/pmezard/go-difflib v1.0.1-0.20181226105442-5d4384ee4fb2 go: downloading gopkg.in/yaml.v3 v3.0.1 go: downloading github.com/coreos/go-semver v0.3.1 go: downloading cloud.google.com/go v0.112.0 go: downloading github.com/VividCortex/ewma v1.2.0 go: downloading github.com/fatih/color v1.16.0 go: downloading github.com/mattn/go-colorable v0.1.13 go: downloading github.com/mattn/go-isatty v0.0.20 go: downloading github.com/mattn/go-runewidth v0.0.15 go: downloading github.com/pkg/errors v0.9.1 go: downloading github.com/uber/jaeger-lib v2.4.1+incompatible go: downloading github.com/beorn7/perks v1.0.1 go: downloading github.com/prometheus/procfs v0.13.0 go: downloading github.com/Azure/azure-sdk-for-go/sdk/internal v1.5.1 go: downloading github.com/AzureAD/microsoft-authentication-library-for-go v1.2.1 go: downloading golang.org/x/crypto v0.22.0 go: downloading github.com/lestrrat-go/iter v1.0.2 go: downloading github.com/lestrrat-go/blackmagic v1.0.2 go: downloading github.com/lestrrat-go/option v1.0.1 go: downloading github.com/lestrrat-go/httprc v1.0.5 go: downloading github.com/vbauerster/mpb/v7 v7.5.3 go: downloading golang.org/x/term v0.19.0 go: downloading github.com/tklauser/go-sysconf v0.3.12 go: downloading github.com/json-iterator/go v1.1.12 go: downloading google.golang.org/genproto/googleapis/api v0.0.0-20240304212257-790db918fca8 go: downloading github.com/spf13/cobra v1.8.0 go: downloading github.com/dustin/go-humanize v1.0.1 go: downloading github.com/golang/glog v1.2.0 go: downloading github.com/jfcg/sixb v1.3.8 go: downloading github.com/jedib0t/go-pretty/v6 v6.2.2 go: downloading github.com/cockroachdb/logtags v0.0.0-20230118201751-21c54148d20b go: downloading github.com/cockroachdb/redact v1.1.5 go: downloading github.com/getsentry/sentry-go v0.27.0 go: downloading github.com/rivo/uniseg v0.4.6 go: downloading github.com/coreos/go-systemd/v22 v22.5.0 go: downloading github.com/pingcap/goleveldb v0.0.0-20191226122134-f82aafb29989 go: downloading github.com/apache/thrift v0.16.0 go: downloading cloud.google.com/go/compute/metadata v0.2.3 go: downloading github.com/lestrrat-go/httpcc v1.0.1 go: downloading google.golang.org/genproto v0.0.0-20240227224415-6ceb2ff114de go: downloading cloud.google.com/go/compute v1.24.0 go: downloading github.com/Masterminds/semver v1.5.0 go: downloading k8s.io/api v0.28.6 go: downloading github.com/emirpasic/gods v1.18.1 go: downloading github.com/kr/pretty v0.3.1 go: downloading github.com/acarl005/stripansi v0.0.0-20180116102854-5a71ef0e047d go: downloading github.com/tklauser/numcpus v0.6.1 go: downloading cloud.google.com/go/iam v1.1.6 go: downloading github.com/googleapis/gax-go/v2 v2.12.0 go: downloading github.com/kylelemons/godebug v1.1.0 go: downloading github.com/pkg/browser v0.0.0-20240102092130-5ac0b6a4141c go: downloading github.com/modern-go/concurrent v0.0.0-20180306012644-bacd9c7ef1dd go: downloading github.com/modern-go/reflect2 v1.0.2 go: downloading go.opencensus.io v0.24.0 go: downloading go.opentelemetry.io/otel v1.22.0 go: downloading go.opentelemetry.io/otel/trace v1.22.0 go: downloading google.golang.org/genproto/googleapis/rpc v0.0.0-20240401170217-c3f982113cda go: downloading github.com/kr/text v0.2.0 go: downloading github.com/rogpeppe/go-internal v1.12.0 go: downloading github.com/golang-jwt/jwt/v5 v5.2.0 go: downloading github.com/ncw/directio v1.0.5 go: downloading github.com/coocood/rtutil v0.0.0-20190304133409-c84515f646f2 go: downloading github.com/coocood/bbloom v0.0.0-20190830030839-58deb6228d64 go: downloading github.com/klauspost/cpuid v1.3.1 go: downloading github.com/golang/groupcache v0.0.0-20210331224755-41bb18bfe9da go: downloading github.com/go-logr/logr v1.4.1 go: downloading go.opentelemetry.io/otel/metric v1.22.0 go: downloading github.com/go-logr/stdr v1.2.2 go: downloading github.com/cockroachdb/tokenbucket v0.0.0-20230807174530-cc333fc44b06 go: downloading github.com/DataDog/zstd v1.5.5 go: downloading k8s.io/apimachinery v0.28.6 go: downloading gopkg.in/inf.v0 v0.9.1 go: downloading k8s.io/klog/v2 v2.120.1 go: downloading github.com/google/gofuzz v1.2.0 go: downloading sigs.k8s.io/structured-merge-diff/v4 v4.4.1 go: downloading sigs.k8s.io/json v0.0.0-20221116044647-bc3834ca7abd go: downloading k8s.io/utils v0.0.0-20230726121419-3b25d923346b go: downloading github.com/google/s2a-go v0.1.7 go: downloading go.opentelemetry.io/contrib/instrumentation/net/http/otelhttp v0.47.0 go: downloading github.com/googleapis/enterprise-certificate-proxy v0.3.2 go: downloading go.opentelemetry.io/contrib/instrumentation/google.golang.org/grpc/otelgrpc v0.47.0 go: downloading github.com/felixge/httpsnoop v1.0.4 go: downloading github.com/jmespath/go-jmespath v0.4.0 Build TiDB Server successfully! [Pipeline] retry [Pipeline] { [Pipeline] sh + chmod +x /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/scripts/PingCAP-QE/tidb-test/download_pingcap_artifact.sh /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/scripts/PingCAP-QE/tidb-test/download_pingcap_artifact_v2.sh /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/scripts/PingCAP-QE/tidb-test/run-integration-mysql-test.sh /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/scripts/PingCAP-QE/tidb-test/run-mysql-test.sh /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/scripts/PingCAP-QE/tidb-test/start_tikv.sh + /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/scripts/PingCAP-QE/tidb-test/download_pingcap_artifact.sh --pd=master --tikv=master TIDB = TIKV = master PD = master TIFLASH = >>> start download tikv tikv master sha1 is 88099c95a3c0c13a827c0795c3d45070264665e4 TIKV: http://fileserver.pingcap.net/download/builds/pingcap/tikv/88099c95a3c0c13a827c0795c3d45070264665e4/centos7/tikv-server.tar.gz download tikv-server.tar.gz from http://fileserver.pingcap.net/download/builds/pingcap/tikv/88099c95a3c0c13a827c0795c3d45070264665e4/centos7/tikv-server.tar.gz >>> start download pd pd master sha1 is f83febabecb98b95b098fd31a3664178f8a6b437 PD: http://fileserver.pingcap.net/download/builds/pingcap/pd/f83febabecb98b95b098fd31a3664178f8a6b437/centos7/pd-server.tar.gz download pd-server.tar.gz from http://fileserver.pingcap.net/download/builds/pingcap/pd/f83febabecb98b95b098fd31a3664178f8a6b437/centos7/pd-server.tar.gz total 523M drwxr-xr-x. 3 root root 4.0K May 7 01:36 . drwxr-xr-x. 18 root root 4.0K May 7 01:35 .. drwxr-xr-x. 2 root root 4.0K May 7 01:36 bin -rwxr-xr-x. 1 1000 1000 106M May 6 08:49 pd-server -rwxr-xr-x. 1 1000 1000 418M May 6 07:33 tikv-server + mv third_bin/tikv-server bin/ + mv third_bin/pd-server bin/ + rm -rf bin/bin + chown -R 1000:1000 bin/ [Pipeline] } [Pipeline] // retry [Pipeline] } [Pipeline] // dir [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test [Pipeline] { [Pipeline] cache Cache not restored (no such key found) [Pipeline] { [Pipeline] sh Release Version: v8.2.0-alpha-15-gf83febabe Edition: Community Git Commit Hash: f83febabecb98b95b098fd31a3664178f8a6b437 Git Branch: master UTC Build Time: 2024-05-06 08:48:58 TiKV Release Version: 8.2.0-alpha Edition: Community Git Commit Hash: 88099c95a3c0c13a827c0795c3d45070264665e4 Git Commit Branch: master UTC Build Time: 2024-05-06 06:37:19 Rust Version: rustc 1.77.0-nightly (89e2160c4 2023-12-27) Enable Features: memory-engine pprof-fp jemalloc mem-profiling portable sse test-engine-kv-rocksdb test-engine-raft-raft-engine trace-async-tasks openssl-vendored Profile: dist_release Release Version: v8.2.0-alpha-88-gb6435d1fb1 Edition: Community Git Commit Hash: b6435d1fb1293b94da1eec310925061d75b93f77 Git Branch: HEAD UTC Build Time: 2024-05-07 01:32:55 GoVersion: go1.21.0 Race Enabled: false Check Table Before Drop: false Store: unistore [Pipeline] } Cache saved successfully (ws/jenkins-pingcap-tidb-merged_integration_nodejs_test-1073/tidb-test) 1375533568 bytes in 27.90 secs (49300383 bytes/sec) [Pipeline] // cache [Pipeline] } [Pipeline] // dir [Pipeline] } [Pipeline] // stage [Pipeline] stage [Pipeline] { (Node.js Tests) [Pipeline] parallel [Pipeline] { (Branch: Matrix - TEST_DIR = 'prisma_test') [Pipeline] { (Branch: Matrix - TEST_DIR = 'typeorm_test') [Pipeline] { (Branch: Matrix - TEST_DIR = 'sequelize_test') [Pipeline] stage [Pipeline] { (Matrix - TEST_DIR = 'prisma_test') [Pipeline] stage [Pipeline] { (Matrix - TEST_DIR = 'typeorm_test') [Pipeline] stage [Pipeline] { (Matrix - TEST_DIR = 'sequelize_test') [Pipeline] withEnv [Pipeline] { [Pipeline] withEnv [Pipeline] { [Pipeline] withEnv [Pipeline] { [Pipeline] readTrusted [Pipeline] readTrusted [Pipeline] readTrusted Obtained pipelines/pingcap/tidb/latest/pod-merged_integration_nodejs_test.yaml from git https://github.com/PingCAP-QE/ci.git [Pipeline] podTemplate [Pipeline] { [Pipeline] node Obtained pipelines/pingcap/tidb/latest/pod-merged_integration_nodejs_test.yaml from git https://github.com/PingCAP-QE/ci.git [Pipeline] podTemplate [Pipeline] { [Pipeline] node Created Pod: kubernetes jenkins-tidb/pingcap-tidb-merged-integration-nodejs-test-1073-v2cv9-pw-9nvzq Obtained pipelines/pingcap/tidb/latest/pod-merged_integration_nodejs_test.yaml from git https://github.com/PingCAP-QE/ci.git [Pipeline] podTemplate [Pipeline] { Created Pod: kubernetes jenkins-tidb/pingcap-tidb-merged-integration-nodejs-test-1073-02dxr-0k-q83rc [Pipeline] node Created Pod: kubernetes jenkins-tidb/pingcap-tidb-merged-integration-nodejs-test-1073-zp3g4-kz-6jx3b Agent pingcap-tidb-merged-integration-nodejs-test-1073-zp3g4-kz-6jx3b is provisioned from template pingcap_tidb_merged_integration_nodejs_test_1073-zp3g4-kzsww --- apiVersion: "v1" kind: "Pod" metadata: annotations: buildUrl: "http://jenkins.apps.svc.cluster.local:8080/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/" runUrl: "job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/" labels: jenkins/jenkins-jenkins-agent: "true" jenkins/label-digest: "6b63821f4d0600aecc2b55a64332f1e4bb247af2" jenkins/label: "pingcap_tidb_merged_integration_nodejs_test_1073-zp3g4" name: "pingcap-tidb-merged-integration-nodejs-test-1073-zp3g4-kz-6jx3b" namespace: "jenkins-tidb" spec: affinity: nodeAffinity: requiredDuringSchedulingIgnoredDuringExecution: nodeSelectorTerms: - matchExpressions: - key: "kubernetes.io/arch" operator: "In" values: - "amd64" containers: - image: "hub.pingcap.net/ee/ci/base:v20230810-go1.21.0" name: "nodejs" resources: limits: memory: "16Gi" cpu: "6" requests: memory: "12Gi" cpu: "4" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/network-multitool" name: "net-tool" resources: limits: memory: "128Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/python3-requests:latest" name: "report" resources: limits: memory: "256Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - env: - name: "JENKINS_SECRET" value: "********" - name: "JENKINS_TUNNEL" value: "jenkins-agent.apps.svc.cluster.local:50000" - name: "JENKINS_AGENT_NAME" value: "pingcap-tidb-merged-integration-nodejs-test-1073-zp3g4-kz-6jx3b" - name: "JENKINS_NAME" value: "pingcap-tidb-merged-integration-nodejs-test-1073-zp3g4-kz-6jx3b" - name: "JENKINS_AGENT_WORKDIR" value: "/home/jenkins/agent" - name: "JENKINS_URL" value: "http://jenkins.apps.svc.cluster.local:8080/jenkins/" image: "jenkins/inbound-agent:3206.vb_15dcf73f6a_9-2" name: "jnlp" resources: requests: memory: "256Mi" cpu: "100m" volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false restartPolicy: "Never" securityContext: runAsUser: 0 volumes: - emptyDir: medium: "" name: "workspace-volume" Running on pingcap-tidb-merged-integration-nodejs-test-1073-zp3g4-kz-6jx3b in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test [Pipeline] { [Pipeline] checkout The recommended git tool is: git Agent pingcap-tidb-merged-integration-nodejs-test-1073-v2cv9-pw-9nvzq is provisioned from template pingcap_tidb_merged_integration_nodejs_test_1073-v2cv9-pwbtl --- apiVersion: "v1" kind: "Pod" metadata: annotations: buildUrl: "http://jenkins.apps.svc.cluster.local:8080/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/" runUrl: "job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/" labels: jenkins/jenkins-jenkins-agent: "true" jenkins/label-digest: "66907c55f28004d805b87fb9310a1e595b6034ad" jenkins/label: "pingcap_tidb_merged_integration_nodejs_test_1073-v2cv9" name: "pingcap-tidb-merged-integration-nodejs-test-1073-v2cv9-pw-9nvzq" namespace: "jenkins-tidb" spec: affinity: nodeAffinity: requiredDuringSchedulingIgnoredDuringExecution: nodeSelectorTerms: - matchExpressions: - key: "kubernetes.io/arch" operator: "In" values: - "amd64" containers: - image: "hub.pingcap.net/ee/ci/base:v20230810-go1.21.0" name: "nodejs" resources: limits: memory: "16Gi" cpu: "6" requests: memory: "12Gi" cpu: "4" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/network-multitool" name: "net-tool" resources: limits: memory: "128Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/python3-requests:latest" name: "report" resources: limits: memory: "256Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - env: - name: "JENKINS_SECRET" value: "********" - name: "JENKINS_TUNNEL" value: "jenkins-agent.apps.svc.cluster.local:50000" - name: "JENKINS_AGENT_NAME" value: "pingcap-tidb-merged-integration-nodejs-test-1073-v2cv9-pw-9nvzq" - name: "JENKINS_NAME" value: "pingcap-tidb-merged-integration-nodejs-test-1073-v2cv9-pw-9nvzq" - name: "JENKINS_AGENT_WORKDIR" value: "/home/jenkins/agent" - name: "JENKINS_URL" value: "http://jenkins.apps.svc.cluster.local:8080/jenkins/" image: "jenkins/inbound-agent:3206.vb_15dcf73f6a_9-2" name: "jnlp" resources: requests: memory: "256Mi" cpu: "100m" volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false restartPolicy: "Never" securityContext: runAsUser: 0 volumes: - emptyDir: medium: "" name: "workspace-volume" Running on pingcap-tidb-merged-integration-nodejs-test-1073-v2cv9-pw-9nvzq in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test [Pipeline] { [Pipeline] checkout The recommended git tool is: git No credentials specified Warning: JENKINS-30600: special launcher org.csanchez.jenkins.plugins.kubernetes.pipeline.ContainerExecDecorator$1@bcaccc4; decorates RemoteLauncher[hudson.remoting.Channel@436b1b20:JNLP4-connect connection from 10.233.102.6/10.233.102.6:53450] will be ignored (a typical symptom is the Git executable not being run inside a designated container) Cloning the remote Git repository Using shallow clone with depth 1 Cloning repository https://github.com/PingCAP-QE/ci.git > git init /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test # timeout=10 Fetching upstream changes from https://github.com/PingCAP-QE/ci.git > git --version # timeout=10 > git --version # 'git version 2.39.2' > git fetch --tags --force --progress --depth=1 -- https://github.com/PingCAP-QE/ci.git +refs/heads/*:refs/remotes/origin/* # timeout=5 Agent pingcap-tidb-merged-integration-nodejs-test-1073-02dxr-0k-q83rc is provisioned from template pingcap_tidb_merged_integration_nodejs_test_1073-02dxr-0kq74 --- apiVersion: "v1" kind: "Pod" metadata: annotations: buildUrl: "http://jenkins.apps.svc.cluster.local:8080/jenkins/job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/" runUrl: "job/pingcap/job/tidb/job/merged_integration_nodejs_test/1073/" labels: jenkins/jenkins-jenkins-agent: "true" jenkins/label-digest: "a9ec6a0f34a38020987a72217e18ba6062efabfc" jenkins/label: "pingcap_tidb_merged_integration_nodejs_test_1073-02dxr" name: "pingcap-tidb-merged-integration-nodejs-test-1073-02dxr-0k-q83rc" namespace: "jenkins-tidb" spec: affinity: nodeAffinity: requiredDuringSchedulingIgnoredDuringExecution: nodeSelectorTerms: - matchExpressions: - key: "kubernetes.io/arch" operator: "In" values: - "amd64" containers: - image: "hub.pingcap.net/ee/ci/base:v20230810-go1.21.0" name: "nodejs" resources: limits: memory: "16Gi" cpu: "6" requests: memory: "12Gi" cpu: "4" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/network-multitool" name: "net-tool" resources: limits: memory: "128Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - image: "hub.pingcap.net/jenkins/python3-requests:latest" name: "report" resources: limits: memory: "256Mi" cpu: "100m" tty: true volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false - env: - name: "JENKINS_SECRET" value: "********" - name: "JENKINS_TUNNEL" value: "jenkins-agent.apps.svc.cluster.local:50000" - name: "JENKINS_AGENT_NAME" value: "pingcap-tidb-merged-integration-nodejs-test-1073-02dxr-0k-q83rc" - name: "JENKINS_NAME" value: "pingcap-tidb-merged-integration-nodejs-test-1073-02dxr-0k-q83rc" - name: "JENKINS_AGENT_WORKDIR" value: "/home/jenkins/agent" - name: "JENKINS_URL" value: "http://jenkins.apps.svc.cluster.local:8080/jenkins/" image: "jenkins/inbound-agent:3206.vb_15dcf73f6a_9-2" name: "jnlp" resources: requests: memory: "256Mi" cpu: "100m" volumeMounts: - mountPath: "/home/jenkins/agent" name: "workspace-volume" readOnly: false restartPolicy: "Never" securityContext: runAsUser: 0 volumes: - emptyDir: medium: "" name: "workspace-volume" Running on pingcap-tidb-merged-integration-nodejs-test-1073-02dxr-0k-q83rc in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test [Pipeline] { [Pipeline] checkout No credentials specified Warning: JENKINS-30600: special launcher org.csanchez.jenkins.plugins.kubernetes.pipeline.ContainerExecDecorator$1@3821adfc; decorates RemoteLauncher[hudson.remoting.Channel@41cc209f:JNLP4-connect connection from 10.233.81.189/10.233.81.189:49110] will be ignored (a typical symptom is the Git executable not being run inside a designated container) Cloning the remote Git repository Using shallow clone with depth 1 The recommended git tool is: git Cloning repository https://github.com/PingCAP-QE/ci.git > git init /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test # timeout=10 Fetching upstream changes from https://github.com/PingCAP-QE/ci.git > git --version # timeout=10 > git --version # 'git version 2.39.2' > git fetch --tags --force --progress --depth=1 -- https://github.com/PingCAP-QE/ci.git +refs/heads/*:refs/remotes/origin/* # timeout=5 No credentials specified Warning: JENKINS-30600: special launcher org.csanchez.jenkins.plugins.kubernetes.pipeline.ContainerExecDecorator$1@65fe3ee5; decorates RemoteLauncher[hudson.remoting.Channel@2ff3286c:JNLP4-connect connection from 10.233.86.82/10.233.86.82:51380] will be ignored (a typical symptom is the Git executable not being run inside a designated container) Cloning the remote Git repository Using shallow clone with depth 1 > git config remote.origin.url https://github.com/PingCAP-QE/ci.git # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 Avoid second fetch Checking out Revision 03312178c534dce949face80c69812d989e55009 (origin/main) Cloning repository https://github.com/PingCAP-QE/ci.git > git init /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test # timeout=10 Fetching upstream changes from https://github.com/PingCAP-QE/ci.git > git --version # timeout=10 > git --version # 'git version 2.39.2' > git fetch --tags --force --progress --depth=1 -- https://github.com/PingCAP-QE/ci.git +refs/heads/*:refs/remotes/origin/* # timeout=5 Commit message: "fix(br): use failpoint tidb-server instead (#2951)" [Pipeline] withEnv [Pipeline] { [Pipeline] container [Pipeline] { [Pipeline] stage [Pipeline] { (Test) [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test [Pipeline] { [Pipeline] cache > git config remote.origin.url https://github.com/PingCAP-QE/ci.git # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 Avoid second fetch Checking out Revision 03312178c534dce949face80c69812d989e55009 (origin/main) Commit message: "fix(br): use failpoint tidb-server instead (#2951)" > git rev-parse origin/main^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f 03312178c534dce949face80c69812d989e55009 # timeout=10 > git rev-parse origin/main^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f 03312178c534dce949face80c69812d989e55009 # timeout=10 > git config remote.origin.url https://github.com/PingCAP-QE/ci.git # timeout=10 > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10 Avoid second fetch Checking out Revision 03312178c534dce949face80c69812d989e55009 (origin/main) Commit message: "fix(br): use failpoint tidb-server instead (#2951)" > git rev-parse origin/main^{commit} # timeout=10 > git config core.sparsecheckout # timeout=10 > git checkout -f 03312178c534dce949face80c69812d989e55009 # timeout=10 Cache restored successfully (ws/jenkins-pingcap-tidb-merged_integration_nodejs_test-1073/tidb-test) 1375533568 bytes in 10.23 secs (134508613 bytes/sec) [Pipeline] { [Pipeline] sh [Pipeline] withEnv [Pipeline] { [Pipeline] withEnv [Pipeline] { [Pipeline] container [Pipeline] { [Pipeline] container [Pipeline] { [Pipeline] stage [Pipeline] { (Test) [Pipeline] stage [Pipeline] { (Test) + ls -alh bin/ total 731M drwxr-xr-x. 2 root root 4.0K May 7 01:37 . drwxr-xr-x. 49 root root 4.0K May 7 01:37 .. -rwxr-xr-x. 1 root root 106M May 7 01:36 pd-server -rwxr-xr-x. 1 root root 208M May 7 01:36 tidb-server -rwxr-xr-x. 1 root root 418M May 7 01:36 tikv-server + ./bin/pd-server -V Release Version: v8.2.0-alpha-15-gf83febabe Edition: Community Git Commit Hash: f83febabecb98b95b098fd31a3664178f8a6b437 Git Branch: master UTC Build Time: 2024-05-06 08:48:58 + ./bin/tikv-server -V TiKV Release Version: 8.2.0-alpha Edition: Community Git Commit Hash: 88099c95a3c0c13a827c0795c3d45070264665e4 Git Commit Branch: master UTC Build Time: 2024-05-06 06:37:19 Rust Version: rustc 1.77.0-nightly (89e2160c4 2023-12-27) Enable Features: memory-engine pprof-fp jemalloc mem-profiling portable sse test-engine-kv-rocksdb test-engine-raft-raft-engine trace-async-tasks openssl-vendored Profile: dist_release + ./bin/tidb-server -V Release Version: v8.2.0-alpha-88-gb6435d1fb1 Edition: Community Git Commit Hash: b6435d1fb1293b94da1eec310925061d75b93f77 Git Branch: HEAD UTC Build Time: 2024-05-07 01:32:55 GoVersion: go1.21.0 Race Enabled: false Check Table Before Drop: false Store: unistore [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test [Pipeline] { [Pipeline] dir Running in /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test [Pipeline] { [Pipeline] cache Cache restored successfully (ws/jenkins-pingcap-tidb-merged_integration_nodejs_test-1073/tidb-test) 1375533568 bytes in 6.73 secs (204463327 bytes/sec) [Pipeline] { [Pipeline] cache Cache restored successfully (ws/jenkins-pingcap-tidb-merged_integration_nodejs_test-1073/tidb-test) 1375533568 bytes in 16.01 secs (85905060 bytes/sec) [Pipeline] { [Pipeline] sh [Pipeline] sh + ls -alh bin/ total 731M drwxr-xr-x. 2 root root 4.0K May 7 01:37 . drwxr-xr-x. 49 root root 4.0K May 7 01:37 .. -rwxr-xr-x. 1 root root 106M May 7 01:36 pd-server -rwxr-xr-x. 1 root root 208M May 7 01:36 tidb-server -rwxr-xr-x. 1 root root 418M May 7 01:36 tikv-server + ./bin/pd-server -V Release Version: v8.2.0-alpha-15-gf83febabe Edition: Community Git Commit Hash: f83febabecb98b95b098fd31a3664178f8a6b437 Git Branch: master UTC Build Time: 2024-05-06 08:48:58 + ./bin/tikv-server -V TiKV Release Version: 8.2.0-alpha Edition: Community Git Commit Hash: 88099c95a3c0c13a827c0795c3d45070264665e4 Git Commit Branch: master UTC Build Time: 2024-05-06 06:37:19 Rust Version: rustc 1.77.0-nightly (89e2160c4 2023-12-27) Enable Features: memory-engine pprof-fp jemalloc mem-profiling portable sse test-engine-kv-rocksdb test-engine-raft-raft-engine trace-async-tasks openssl-vendored Profile: dist_release + ./bin/tidb-server -V Release Version: v8.2.0-alpha-88-gb6435d1fb1 Edition: Community Git Commit Hash: b6435d1fb1293b94da1eec310925061d75b93f77 Git Branch: HEAD UTC Build Time: 2024-05-07 01:32:55 GoVersion: go1.21.0 Race Enabled: false Check Table Before Drop: false Store: unistore [Pipeline] sh + ls -alh bin/ total 731M drwxr-xr-x 2 root root 4.0K May 7 01:37 . drwxr-xr-x 49 root root 4.0K May 7 01:37 .. -rwxr-xr-x 1 root root 106M May 7 01:36 pd-server -rwxr-xr-x 1 root root 208M May 7 01:36 tidb-server -rwxr-xr-x 1 root root 418M May 7 01:36 tikv-server + ./bin/pd-server -V Release Version: v8.2.0-alpha-15-gf83febabe Edition: Community Git Commit Hash: f83febabecb98b95b098fd31a3664178f8a6b437 Git Branch: master UTC Build Time: 2024-05-06 08:48:58 + ./bin/tikv-server -V TiKV Release Version: 8.2.0-alpha Edition: Community Git Commit Hash: 88099c95a3c0c13a827c0795c3d45070264665e4 Git Commit Branch: master UTC Build Time: 2024-05-06 06:37:19 Rust Version: rustc 1.77.0-nightly (89e2160c4 2023-12-27) Enable Features: memory-engine pprof-fp jemalloc mem-profiling portable sse test-engine-kv-rocksdb test-engine-raft-raft-engine trace-async-tasks openssl-vendored Profile: dist_release + ./bin/tidb-server -V Release Version: v8.2.0-alpha-88-gb6435d1fb1 Edition: Community Git Commit Hash: b6435d1fb1293b94da1eec310925061d75b93f77 Git Branch: HEAD UTC Build Time: 2024-05-07 01:32:55 GoVersion: go1.21.0 Race Enabled: false Check Table Before Drop: false Store: unistore [Pipeline] sh wait pd ready... [Pipeline] sh wait pd ready... wait pd ready... wait tikv ready... wait tikv ready... wait tikv ready... sequelize orm v6 test start /go tikv: 127.0.0.1:2379 installing packages ... prisma-4.16.x start /go typeorm-0.3.17 start gcc (Debian 12.2.0-14) 12.2.0 Copyright (C) 2022 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. /go Scope: all 14 workspace projects Lockfile is up to date, resolution step is skipped Progress: resolved 1, reused 0, downloaded 0, added 0 Packages: +1648 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Progress: resolved 1648, reused 0, downloaded 4, added 0 Packages are hard linked from the content-addressable store to the virtual store. Content-addressable store is at: /home/jenkins/agent/.pnpm-store/v3 Virtual store is at: node_modules/.pnpm Progress: resolved 1648, reused 0, downloaded 37, added 34 Progress: resolved 1648, reused 0, downloaded 90, added 87 Progress: resolved 1648, reused 0, downloaded 132, added 129 npm WARN deprecated urix@0.1.0: Please see https://github.com/lydell/urix#deprecated npm WARN deprecated source-map-resolve@0.6.0: See https://github.com/lydell/source-map-resolve#deprecated npm WARN deprecated source-map-url@0.4.1: See https://github.com/lydell/source-map-url#deprecated npm WARN deprecated resolve-url@0.2.1: https://github.com/lydell/resolve-url#deprecated Progress: resolved 1648, reused 0, downloaded 205, added 215 npm WARN deprecated istanbul@0.4.5: This module is no longer maintained, try this instead: npm WARN deprecated npm i nyc npm WARN deprecated Visit https://istanbul.js.org/integrations for other alternatives. Progress: resolved 1648, reused 0, downloaded 241, added 253 Progress: resolved 1648, reused 0, downloaded 284, added 298 npm WARN deprecated chokidar@2.1.8: Chokidar 2 does not receive security updates since 2019. Upgrade to chokidar 3 with 15x fewer dependencies Progress: resolved 1648, reused 0, downloaded 362, added 376 Progress: resolved 1648, reused 0, downloaded 430, added 449 npm WARN deprecated @npmcli/move-file@1.1.2: This functionality has been moved to @npmcli/fs Progress: resolved 1648, reused 0, downloaded 475, added 494 npm WARN deprecated source-map-resolve@0.5.3: See https://github.com/lydell/source-map-resolve#deprecated npm WARN deprecated uuid@3.4.0: Please upgrade to version 7 or higher. Older versions may use Math.random() in certain circumstances, which is known to be problematic. See https://v8.dev/blog/math-random for details. Progress: resolved 1648, reused 0, downloaded 543, added 557 Progress: resolved 1648, reused 0, downloaded 628, added 647 Progress: resolved 1648, reused 0, downloaded 742, added 759 Progress: resolved 1648, reused 0, downloaded 891, added 909 Progress: resolved 1648, reused 0, downloaded 1018, added 1036 Progress: resolved 1648, reused 0, downloaded 1085, added 1100 Progress: resolved 1648, reused 0, downloaded 1158, added 1175 Progress: resolved 1648, reused 0, downloaded 1250, added 1269 Progress: resolved 1648, reused 0, downloaded 1270, added 1289 Progress: resolved 1648, reused 0, downloaded 1283, added 1301 Progress: resolved 1648, reused 0, downloaded 1295, added 1314 Progress: resolved 1648, reused 0, downloaded 1312, added 1331 Progress: resolved 1648, reused 0, downloaded 1347, added 1366 Progress: resolved 1648, reused 0, downloaded 1400, added 1419 Progress: resolved 1648, reused 0, downloaded 1416, added 1434 added 1144 packages, and audited 1145 packages in 25s 111 packages are looking for funding run `npm fund` for details 26 vulnerabilities (1 low, 9 moderate, 15 high, 1 critical) To address issues that do not require attention, run: npm audit fix To address all issues (including breaking changes), run: npm audit fix --force Run `npm audit` for details. > typeorm@0.3.17 test > rimraf ./build && tsc && mocha --file ./build/compiled/test/utils/test-setup.js --bail --recursive --timeout 90000 ./build/compiled/test Progress: resolved 1648, reused 0, downloaded 1471, added 1487 Progress: resolved 1648, reused 0, downloaded 1551, added 1571 Progress: resolved 1648, reused 0, downloaded 1619, added 1639 Progress: resolved 1648, reused 0, downloaded 1626, added 1646 Progress: resolved 1648, reused 0, downloaded 1627, added 1647 Progress: resolved 1648, reused 0, downloaded 1628, added 1648, done .../node_modules/@prisma/engines postinstall$ node scripts/postinstall.js .../core-js@3.26.0/node_modules/core-js postinstall$ node -e "try{require('./postinstall')}catch(e){}" .../node_modules/spawn-sync postinstall$ node postinstall .../sqlite3@5.1.2/node_modules/sqlite3 install$ node-pre-gyp install --fallback-to-build .../.pnpm/yarn@1.22.19/node_modules/yarn preinstall$ :; (node ./preinstall.js > /dev/null 2>&1 || true) .../core-js@3.26.0/node_modules/core-js postinstall: Done .../node_modules/spawn-sync postinstall: Done .../.pnpm/yarn@1.22.19/node_modules/yarn preinstall: Done .../sqlite3@5.1.2/node_modules/sqlite3 install: node-pre-gyp info it worked if it ends with ok .../sqlite3@5.1.2/node_modules/sqlite3 install: node-pre-gyp info using node-pre-gyp@1.0.10 .../sqlite3@5.1.2/node_modules/sqlite3 install: node-pre-gyp info using node@18.13.0 | linux | x64 .../sqlite3@5.1.2/node_modules/sqlite3 install: node-pre-gyp info check checked for "/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/prisma_test/prisma-4.16.x/node_modules/.pnpm/sqlite3@5.1.2/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-x64/node_sqlite3.node" (not found) .../sqlite3@5.1.2/node_modules/sqlite3 install: node-pre-gyp http GET https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.2/napi-v6-linux-glibc-x64.tar.gz .../sqlite3@5.1.2/node_modules/sqlite3 install: node-pre-gyp info install unpacking napi-v6-linux-glibc-x64/node_sqlite3.node .../node_modules/@prisma/engines postinstall: Done .../sqlite3@5.1.2/node_modules/sqlite3 install: node-pre-gyp info extracted file count: 1 .../sqlite3@5.1.2/node_modules/sqlite3 install: node-pre-gyp info ok .../sqlite3@5.1.2/node_modules/sqlite3 install: [sqlite3] Success: "/home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/prisma_test/prisma-4.16.x/node_modules/.pnpm/sqlite3@5.1.2/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-x64/node_sqlite3.node" is installed via remote .../sqlite3@5.1.2/node_modules/sqlite3 install: Done .../node_modules/@swc/core postinstall$ node postinstall.js .../node_modules/@swc/core postinstall$ node postinstall.js .../esbuild@0.15.13/node_modules/esbuild postinstall$ node install.js .../esbuild@0.18.2/node_modules/esbuild postinstall$ node install.js .../prisma@5.4.2/node_modules/prisma preinstall$ node scripts/preinstall-entry.js .../node_modules/@swc/core postinstall: Done .../node_modules/@swc/core postinstall: Done .../esbuild@0.15.13/node_modules/esbuild postinstall: Done .../esbuild@0.18.2/node_modules/esbuild postinstall: Done .../prisma@5.4.2/node_modules/prisma preinstall: Done .../node_modules/yo postinstall$ yodoctor .../node_modules/yo postinstall: Yeoman Doctor .../node_modules/yo postinstall: Running sanity checks on your system .../node_modules/yo postinstall: βœ” No .bowerrc file in home directory .../node_modules/yo postinstall: βœ” Global configuration file is valid .../node_modules/yo postinstall: βœ” NODE_PATH matches the npm root .../node_modules/yo postinstall: βœ” No .yo-rc.json file in home directory .../node_modules/yo postinstall: βœ” Node.js version .../node_modules/yo postinstall: βœ” npm version .../node_modules/yo postinstall: βœ– yo version .../node_modules/yo postinstall: Your yo version is outdated. .../node_modules/yo postinstall: Upgrade to the latest version by running: .../node_modules/yo postinstall: npm install -g yo@latest .../node_modules/yo postinstall: Found potential issues on your machine :( .../node_modules/yo postinstall: Done devDependencies: + @microsoft/api-extractor 7.35.3 + @sindresorhus/slugify 1.1.2 + @slack/webhook 6.1.0 + @types/benchmark 2.1.2 + @types/fs-extra 9.0.13 + @types/graphviz 0.0.35 + @types/node 18.16.16 + @types/node-fetch 2.6.4 + @types/redis 2.8.32 + @types/resolve 1.20.2 + @typescript-eslint/eslint-plugin 5.59.11 + @typescript-eslint/parser 5.59.11 + arg 5.0.2 + batching-toposort 1.2.0 + buffer 6.0.3 + chokidar 3.5.3 + esbuild 0.15.13 + esbuild-register 3.3.3 + eslint 8.43.0 + eslint-config-prettier 8.8.0 + eslint-plugin-eslint-comments 3.2.0 + eslint-plugin-import 2.27.5 + eslint-plugin-jest 27.2.1 + eslint-plugin-prettier 4.2.1 + eslint-plugin-simple-import-sort 10.0.0 + eventemitter3 5.0.1 + execa 5.1.1 + fs-extra 11.1.1 + globby 11.1.0 + graphviz-mit 0.0.9 + husky 8.0.3 + is-ci 3.0.1 + jest-junit 16.0.0 + kleur 4.1.5 + lint-staged 13.2.2 + node-fetch 2.6.11 + p-map 4.0.0 + p-reduce 2.1.0 + p-retry 4.6.2 + path-browserify 1.0.1 + prettier 2.8.8 + redis 3.1.2 + redis-lock 0.1.4 + regenerator-runtime 0.13.11 + resolve 1.22.2 + safe-buffer 5.2.1 + semver 7.5.1 + spdx-exceptions 2.3.0 + spdx-license-ids 3.0.13 + staged-git-files 1.3.0 + ts-node 10.9.1 + ts-toolbelt 9.6.0 + tty-browserify 0.0.1 + typescript 4.9.5 + util 0.12.5 + zx 7.2.2 . preinstall$ node ./scripts/only-allow-pnpm.js pnpm . preinstall: Done . prepare$ is-ci || husky install . prepare: Done packages/engines postinstall$ node scripts/postinstall.js packages/engines postinstall: Done packages/client postinstall$ node scripts/postinstall.js packages/client postinstall: prisma:warn We could not find your Prisma schema at `prisma/schema.prisma`. packages/client postinstall: If you have a Prisma schema file in a custom path, you will need to run packages/client postinstall: `prisma generate --schema=./path/to/your/schema.prisma` to generate Prisma Client. packages/client postinstall: If you do not have a Prisma schema file yet, you can ignore this message. packages/client postinstall: Done packages/cli preinstall$ node scripts/preinstall-entry.js packages/cli preinstall: Done Done in 48.6s > dev-env@ build /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/prisma_test/prisma-4.16.x > ts-node scripts/setup.ts --build ./. git config --global user.email "prismabots@gmail.com" ./. git config --global user.name "prisma-bot" Building packages ./. pnpm -r build Scope: 13 of 14 workspace projects packages/debug build$ node -r esbuild-register helpers/build.ts packages/debug build: Done packages/generator-helper build$ node -r esbuild-register helpers/build.ts packages/get-platform build$ node -r esbuild-register helpers/build.ts packages/generator-helper build: Done packages/get-platform build: Done packages/fetch-engine build$ node -r esbuild-register helpers/build.ts benchmark > bulk-save > case1 βœ” testing bulk save of 10.000 objects benchmark > bulk-save > case2 βœ” testing bulk save of 10000 objects benchmark > bulk-save > case-querybuilder βœ” testing bulk save of 10000 objects benchmark > bulk-sql-build βœ” testing bulk create of 10.000 sql with joins (1059ms) benchmark > QueryBuilder > wide join βœ” testing query builder with join to 10 relations with 10 columns each column kinds > create date column βœ” create date column should automatically be set by a database βœ” create date column can also be manually set by user βœ” create date column should not be updated automatically on every change (1018ms) βœ” create date column should set a custom date when specified column kinds > geometry column βœ” geometry column with SRID defined should be saved without error for valid WKT input βœ” geometry column with SRID defined should be updated without error for valid WKT input βœ” geometry column with no SRID should be saved without error for valid WKT input βœ” geometry column with no SRID should be updated without error for valid WKT input column kinds > update date column βœ” update date column should automatically be set by a database βœ” update column should not update if no changes were detected βœ” update date column can also be manually set by user packages/fetch-engine build: Done packages/engines build$ node -r esbuild-register helpers/build.ts βœ” update date column should be updated automatically on every change (2016ms) βœ” update date column should set a custom date when specified column kinds > version column βœ” version column should automatically be set by a database βœ” version column should not update version if no changes were detected βœ” version column can also be manually set by user βœ” version column should be updated automatically on every change (1013ms) βœ” version column should set a custom value when specified xfail it βœ” chai βœ” standard mocha βœ” async chai base entity βœ” test if DataSource calls `useDataSource` of the provided entities βœ” test if DataSource calls `useDataSource` of the provided entities in the entities directory custom cache provider βœ” should be used instead of built-ins packages/engines build: Analysis will use the bundled TypeScript version 5.0.4 βœ” should cache results properly (1027ms) packages/engines build: Writing package typings: /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/prisma_test/prisma-4.16.x/packages/engines/dist/index.d.ts packages/engines build: Done packages/internals build$ node -r esbuild-register helpers/build.ts βœ” should cache results with pagination enabled properly (1025ms) βœ” should cache results with custom id and duration supplied (2026ms) packages/internals build: Done packages/instrumentation build$ node -r esbuild-register helpers/build.ts packages/migrate build$ node -r esbuild-register helpers/build.ts βœ” should cache results with pagination enabled properly and custom id and loaded relations packages/instrumentation build: Done βœ” should cache results with custom id and duration supplied (1023ms) cascades > should insert by cascades from both sides (#57) βœ” should insert by cascades from owner side columns > comments βœ” should persist comments of different types to the database columns > embedded columns npm WARN EBADENGINE Unsupported engine { npm WARN EBADENGINE package: 'eslint-plugin-jsdoc@37.9.7', npm WARN EBADENGINE required: { node: '^12 || ^14 || ^16 || ^17' }, npm WARN EBADENGINE current: { node: 'v18.13.0', npm: '9.2.0' } npm WARN EBADENGINE } npm WARN EBADENGINE Unsupported engine { npm WARN EBADENGINE package: '@es-joy/jsdoccomment@0.20.1', npm WARN EBADENGINE required: { node: '^12 || ^14 || ^16 || ^17' }, npm WARN EBADENGINE current: { node: 'v18.13.0', npm: '9.2.0' } npm WARN EBADENGINE } npm WARN deprecated abab@1.0.4: Use your platform's native atob() and btoa() methods instead npm WARN deprecated vm2@3.9.19: The library contains critical security issues and should not be used for production! The maintenance of the project has been discontinued. Consider migrating your code to isolated-vm. npm WARN deprecated har-validator@5.1.5: this library is no longer supported npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142 npm WARN deprecated adal-node@0.1.28: This package is no longer supported. Please migrate to @azure/msal-node. npm WARN deprecated @npmcli/move-file@1.1.2: This functionality has been moved to @npmcli/fs npm WARN deprecated querystring@0.2.0: The querystring API is considered Legacy. new code should use the URLSearchParams API instead. npm WARN deprecated string-similarity@4.0.4: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info. npm WARN deprecated better-eval@1.3.0: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info. βœ” should insert / update / remove entity with embedded correctly βœ” should properly generate column names columns > getters and setters npm WARN deprecated loupe@2.3.6: Please upgrade to 2.3.7 which fixes GHSA-4q6p-r6v2-jvc5 βœ” should not update columns marked with readonly property columns > no-selection functionality βœ” should not select columns marked with select: false option βœ” should not select columns with QueryBuilder marked with select: false option βœ” should select columns with select: false even columns were implicitly selected columns > readonly functionality βœ” should not update columns marked with readonly property columns > update and insert control βœ” should respect column update and insert properties columns > value-transformer functionality βœ” should marshal data using the provided value-transformer βœ” should apply three transformers in the right order npm WARN deprecated core-js@2.6.12: core-js@<3.23.3 is no longer maintained and not recommended for usage due to the number of issues. Because of the V8 engine whims, feature detection in old core-js versions could cause a slowdown up to 100x even if nothing is polyfilled. Some versions have web compatibility issues. Please, upgrade your dependencies to the actual version of core-js. βœ” should apply all the transformers βœ” should apply no transformer packages/migrate build: Done packages/client build$ node -r esbuild-register helpers/build.ts packages/integration-tests build$ node -r esbuild-register helpers/build.ts βœ” should marshal data using a complex value-transformer commands - migration create - should write regular empty migration file when no option is passed - should write Javascript empty migration file when option is passed - should use custom timestamp when option is passed commands - migration generate - writes regular migration file when no option is passed - writes Javascript printed file when option is passed - writes migration file with custom timestamp when option is passed Connection before connection is established βœ” connection.isConnected should be false - entity manager and reactive entity manager should not be accessible βœ” should not be able to close βœ” should not be able to sync a schema - should not be able to use repositories βœ” should be able to connect establishing connection - should throw DriverOptionNotSetError when extra.socketPath and host is missing after connection is established successfully npm WARN deprecated sinon@12.0.1: 16.1.1 npm WARN deprecated uuid@3.4.0: Please upgrade to version 7 or higher. Older versions may use Math.random() in certain circumstances, which is known to be problematic. See https://v8.dev/blog/math-random for details. npm WARN deprecated uuid@3.4.0: Please upgrade to version 7 or higher. Older versions may use Math.random() in certain circumstances, which is known to be problematic. See https://v8.dev/blog/math-random for details. npm WARN deprecated uuid@3.4.0: Please upgrade to version 7 or higher. Older versions may use Math.random() in certain circumstances, which is known to be problematic. See https://v8.dev/blog/math-random for details. npm WARN deprecated @sinonjs/fake-timers@10.2.0: Use version 10.1.0. Version 10.2.0 has potential breaking issues βœ” connection.isConnected should be true packages/integration-tests build: Done βœ” entity manager and reactive entity manager should be accessible npm WARN deprecated uuid@3.4.0: Please upgrade to version 7 or higher. Older versions may use Math.random() in certain circumstances, which is known to be problematic. See https://v8.dev/blog/math-random for details. npm WARN deprecated debug@3.2.6: Debug versions >=3.2.0 <3.2.7 || >=4 <4.3.1 have a low-severity ReDos regression when used in a Node.js environment. It is recommended you upgrade to 3.2.7 or 4.3.1. (https://github.com/visionmedia/debug/issues/797) βœ” should not be able to connect again βœ” should be able to close a connection working with repositories after connection is established successfully packages/client build: Analysis will use the bundled TypeScript version 5.0.4 βœ” should be able to get simple entity repository βœ” should be able to get tree entity repository generate a schema when connection.synchronize is called βœ” database should be empty after schema is synced with dropDatabase flag (72ms) log a schema when connection.logSyncSchema is called βœ” should return sql log properly after connection is closed successfully βœ” should not be able to close already closed connection βœ” connection.isConnected should be false skip schema generation when synchronize option is set to false βœ” database should be empty after schema sync different names of the same content of the schema βœ” should not interfere with each other can change postgres default schema name βœ” schema name can be set ConnectionManager create βœ” should create a mysql connection when mysql driver is specified get βœ” should give connection with a requested name βœ” should throw an error if connection with the given name was not found create connection options βœ” should not drop the database if dropSchema was not specified (46ms) > sequelize@0.0.0-development prepare > npm run build && husky install > sequelize@0.0.0-development build > node ./build.js Compiling sequelize... βœ” should drop the database if dropSchema was set to true (mysql) (135ms) ConnectionOptionsReader βœ” properly loads config with entities specified βœ” properly loads sqlite in-memory/path config βœ” properly loads config with specified file path βœ” properly loads asynchronous config with specified file path βœ” properly loads config with specified file path from esm in js βœ” properly loads config from .env file βœ” properly loads config from ormconfig.env file βœ” properly loads config ormconfig.env when given multiple choices cube-postgres βœ” should create correct schema with Postgres' cube type βœ” should persist cube correctly βœ” should update cube correctly βœ” should re-save cube correctly βœ” should persist cube of arity 0 correctly βœ” should be able to order cube by euclidean distance βœ” should persist cube array correctly custom repository βœ” withRepository must work properly in transactions database schema > column collation > cockroach βœ” should correctly create column with collation option database schema > column collation > mssql βœ” should correctly create column with collation option database schema > column collation > mysql - should correctly create column with collation option database schema > column collation > postgres βœ” should correctly create column with collation option database schema > column collation > sqlite - should correctly create column with collation option database schema > column length > mssql βœ” all types should create with correct size βœ” all types should update their size βœ” all relevant types should update their size to max database schema > column length > mysql βœ” all types should be created with correct length βœ” all types should update their length (195ms) database schema > column length > postgres βœ” all types should create with correct size βœ” all types should update their size database schema > column length > sap βœ” all types should create with correct size βœ” all types should update their size database schema > column length > sqlite βœ” all types should create with correct size βœ” all types should update their size database schema > column types > cockroachdb βœ” all types should work correctly - persist and hydrate βœ” all types should work correctly - persist and hydrate when options are specified on columns βœ” all types should work correctly - persist and hydrate when types are not specified on columns database schema > column types > cockroachdb-enum βœ” should create table with ENUM column and save data to it βœ” should create ENUM column and revert creation βœ” should drop ENUM column and revert drop βœ” should create table with ENUM column and revert creation βœ” should drop table with ENUM column and revert drop βœ” should change non-enum column in to ENUM and revert change βœ” should change ENUM column in to non-enum and revert change βœ” should change ENUM array column in to non-array and revert change βœ” should change ENUM value and revert change βœ” should change `enumName` and revert change βœ” should not create new type if same `enumName` is used more than once βœ” should change both ENUM value and ENUM name and revert change βœ” should rename ENUM when column renamed and revert rename βœ” should rename ENUM when table renamed and revert rename database schema > column types > mssql βœ” all types should work correctly - persist and hydrate βœ” all types should work correctly - persist and hydrate when options are specified on columns βœ” all types should work correctly - persist and hydrate when types are not specified on columns database schema > column types > mysql βœ” all types should work correctly - persist and hydrate βœ” all types should work correctly - persist and hydrate when options are specified on columns βœ” all types should work correctly - persist and hydrate when types are not specified on columns database schema > column types > oracle βœ” all types should work correctly - persist and hydrate βœ” all types should work correctly - persist and hydrate when options are specified on columns βœ” all types should work correctly - persist and hydrate when types are not specified on columns database schema > column types > postgres βœ” all types should work correctly - persist and hydrate βœ” all types should work correctly - persist and hydrate when options are specified on columns βœ” all types should work correctly - persist and hydrate when types are not specified on columns database schema > column types > postgres-enum βœ” should create table with ENUM column and save data to it βœ” should create ENUM column and revert creation βœ” should drop ENUM column and revert drop βœ” should create table with ENUM column and revert creation βœ” should drop table with ENUM column and revert drop βœ” should change non-enum column in to ENUM and revert change βœ” should change ENUM column in to non-enum and revert change βœ” should change ENUM array column in to non-array and revert change βœ” should change ENUM value and revert change βœ” should change `enumName` and revert change βœ” should not create new type if same `enumName` is used more than once βœ” should change both ENUM value and ENUM name and revert change βœ” should rename ENUM when column renamed and revert rename βœ” should rename ENUM when table renamed and revert rename database schema > column types > sap βœ” all types should work correctly - persist and hydrate βœ” all types should work correctly - persist and hydrate when options are specified on columns βœ” all types should work correctly - persist and hydrate when types are not specified on columns database schema > column types > spanner βœ” all types should work correctly - persist and hydrate βœ” all types should work correctly - persist and hydrate when options are specified on columns βœ” all types should work correctly - persist and hydrate when types are not specified on columns database schema > column types > sqlite βœ” all types should work correctly - persist and hydrate βœ” all types should work correctly - persist and hydrate when types are not specified on columns database schema > column width βœ” all types should be created with correct width βœ” should update data type display width (124ms) database schema > custom constraint names > foreign key βœ” should set custom constraint names packages/client build: Writing package typings: /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/prisma_test/prisma-4.16.x/packages/client/runtime/index.d.ts .git can't be found (see https://git.io/Jc3F9) npm ERR! code 1 npm ERR! path /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/sequelize_test/sequelize_v6_test npm ERR! command failed npm ERR! command sh -c npm run build && husky install npm ERR! A complete log of this run can be found in: npm ERR! /root/.npm/_logs/2024-05-07T01_38_20_287Z-debug-0.log βœ” should load constraints with custom names - should not change constraint names when table renamed - should not change constraint names when column renamed database schema > custom constraint names > index βœ” should set custom constraint names βœ” should load constraints with custom names tidb-server(PID: 303) started loading test data to db ... > sequelize@0.0.0-development build > node ./build.js Compiling sequelize... βœ” should not change constraint names when table renamed (1742ms) βœ” should not change constraint names when column renamed database schema > custom constraint names > primary key βœ” should set custom constraint names βœ” should load constraints with custom names βœ” should not change constraint names when table renamed βœ” should not change constraint names when column renamed database schema > custom constraint names > unique βœ” should set custom constraint names βœ” should load constraints with custom names βœ” should not change constraint names when table renamed (44ms) βœ” should not change constraint names when column renamed database schema > enums βœ” should correctly use default values βœ” should correctly save and retrieve βœ” should not generate queries when no model changes database schema > enum arrays βœ” should correctly create default values βœ” should correctly save and retrieve database schema > generated columns > cockroachdb βœ” should not generate queries when no model changes βœ” should create table with generated columns βœ” should add generated column and revert add βœ” should drop generated column and revert drop βœ” should change generated column and revert change βœ” should remove data from 'typeorm_metadata' when table dropped database schema > generated columns > mssql βœ” should not generate queries when no model changes βœ” should create table with generated columns βœ” should add generated column and revert add βœ” should drop generated column and revert drop βœ” should change generated column and revert change βœ” should remove data from 'typeorm_metadata' when table dropped database schema > generated columns > mysql βœ” should not generate queries when no model changes βœ” should create table with generated columns - should add generated column and revert add - should drop generated column and revert drop - should change generated column and revert change βœ” should remove data from 'typeorm_metadata' when table dropped (97ms) database schema > generated columns > oracle βœ” should not generate queries when no model changes βœ” should create table with generated columns βœ” should add generated column and revert add βœ” should drop generated column and revert drop βœ” should change generated column and revert change βœ” should remove data from 'typeorm_metadata' when table dropped database schema > generated columns > postgres βœ” should not generate queries when no model changes βœ” should create table with generated columns βœ” should add generated column and revert add βœ” should drop generated column and revert drop βœ” should change generated column and revert change βœ” should remove data from 'typeorm_metadata' when table dropped database schema > generated columns > spanner βœ” should not generate queries when no model changes βœ” should create table with generated columns βœ” should add generated column and revert add βœ” should drop generated column and revert drop βœ” should change generated column and revert change βœ” should remove data from 'typeorm_metadata' when table dropped database schema > generated columns > sqlite βœ” should not generate queries when no model changes βœ” should create table with generated columns βœ” should add generated column and revert add βœ” should drop generated column and revert drop βœ” should change generated column and revert change βœ” should remove data from 'typeorm_metadata' when table dropped database schema > indices > reading index from entity and updating database βœ” should create a non unique index with 2 columns packages/client build: Analysis will use the bundled TypeScript version 5.0.4 βœ” should update the index to be unique (1371ms) βœ” should update the index swapping the 2 columns (1365ms) database schema > mssql-parameters βœ” should correctly insert/update/delete entities on SqlServer driver database-schema > rowid-column βœ” should create `rowid` generated column sequences > creating a sequence and marking the column as generated create table and check that primary key column is marked as generated βœ” should check that the primary key column is generated automatically database schema > simple-enums βœ” should correctly use default values βœ” should correctly save and retrieve database schema > simple enum arrays βœ” should correctly create default values βœ” should correctly save and retrieve decorators > embedded basic functionality βœ” should persist and load entities with embeddeds properly βœ” should be used with prop query builder > relation-count-decorator-many-to-many > many-to-many > sequelize@0.0.0-development teaser > node test/teaser.js ########################### # Running tests for mysql # ########################### βœ” should load relation count on owner side > sequelize@0.0.0-development test-integration > yarn mocha --timeout 60000 --exit "test/integration/**/*.test.[tj]s" yarn run v1.22.19 $ mocha -r ./test/registerEsbuild --timeout 60000 --exit 'test/integration/**/*.test.[tj]s' βœ” should load relation count on owner side with limitation βœ” should load relation count on owner side with additional conditions (56ms) packages/client build: Writing package typings: /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/prisma_test/prisma-4.16.x/packages/client/runtime/index-browser.d.ts βœ” should load relation count on both sides of relation [MYSQL] Alias βœ“ should uppercase the first letter in alias getter, but not in eager loading (117ms) βœ” should load relation count on inverse side (42ms) βœ“ shouldnt touch the passed alias (73ms) βœ“ should allow me to pass my own plural and singular forms to hasMany (68ms) packages/client build: Done packages/cli build$ node -r esbuild-register helpers/build.ts packages/react-prisma build$ node -r esbuild-register helpers/build.ts βœ“ should allow me to define plural and singular forms on the model (65ms) [MYSQL] BelongsToMany getAssociations - supports transactions βœ“ gets all associated objects with all fields βœ” should load relation count on inverse side with limitation βœ“ gets all associated objects when no options are passed βœ“ only get objects that fulfill the options βœ” should load relation count on inverse side with additional conditions decorators > relation-count-decorator > one-to-many βœ“ supports a where not in βœ“ supports a where not in on the primary key βœ“ only gets objects that fulfill options with a formatted value βœ“ get associated objects with an eager load βœ“ get associated objects with an eager load with conditions but not required (41ms) βœ“ should support schemas (229ms) packages/cli build: Done packages/react-prisma build: Done βœ“ supports custom primary keys and foreign keys (254ms) > @prisma/integration-tests@0.0.0 test:tidb /home/jenkins/agent/workspace/pingcap/tidb/merged_integration_nodejs_test/tidb-test/prisma_test/prisma-4.16.x/packages/integration-tests > jest integration.tidb --maxWorkers=1 --silent βœ“ supports primary key attributes with different field and attribute names (239ms) βœ” should load relation count (42ms) decorators > relation-id-decorator > many-to-many βœ” should load ids when RelationId decorator used on owner side (38ms) βœ” should load ids when RelationId decorator used on owner side with additional condition βœ” should load ids when RelationId decorator used on owner side without inverse side βœ” should load ids when RelationId decorator used on owner side without inverse side and with additional condition βœ” should load ids when RelationId decorator used on inverse side βœ“ supports non primary key attributes for joins (sourceKey only) (2930ms) βœ” should load ids when RelationId decorator used on inverse side with additional condition βœ” should load ids when RelationId decorator used on nested relation (57ms) βœ” should not load ids of nested relations when RelationId decorator used on inherit relation and parent relation was not found βœ” should load ids when RelationId decorator used on nested relation with additional conditions (56ms) decorators > relation-id-decorator > many-to-one βœ“ supports non primary key attributes for joins (targetKey only) (2927ms) βœ” should load ids when RelationId decorator used decorators > relation-id > one-to-many βœ” should load id when RelationId decorator used βœ“ supports non primary key attributes for joins (sourceKey and targetKey) (2918ms) βœ” should load id when RelationId decorator used with additional condition decorators > relation-id > one-to-one βœ” should load ids when loadRelationIdAndMap used on owner side βœ” should load id when loadRelationIdAndMap used on inverse side deferrable uq constraints should be check at the end of transaction βœ” use initially deferred deferrable uq constraints βœ” use initially immediated deferrable uq constraints deferrable fk constraints should be check at the end of transaction (#2191) βœ” use initially deferred deferrable fk constraints βœ” use initially immediated deferrable fk constraints MongoDriver connection string βœ” should create a connection string for replica sets (142ms) βœ” should create a connection string for non replica sets escape sqlite query parameters βœ” should transform boolean parameters with value `true` into `1` βœ” should transform boolean parameters with value `false` into `0` βœ” should transform boolean nativeParameters with value `true` into `1` βœ” should transform boolean nativeParameters with value `false` into 0 option nativeBinding for better-sqlite3 βœ” should use a the path set in nativeBindings to the node file driver > convert raw results to entity βœ” should return null value in entity property when record column is null βœ” should return true in entity property when record column is true βœ” should return false in entity property when record column is false DriverUtils parse mongo url βœ” should return a mongo url with a replica set βœ” should return a mongo url without a replica set postgres specific options βœ” should set application_name embedded > basic functionality βœ” should insert, load, update and remove entities with embeddeds properly other issues > entity listeners must work in embeddeds as well βœ” getters and setters should work correctly embedded > embedded-many-to-many-case1 owner side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation inverse side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation embedded > embedded-many-to-many-case2 owner side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation inverse side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation (39ms) embedded > embedded-many-to-many-case3 owner side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation with multiple primary keys (one PK in each embed) (40ms) inverse side βœ“ supports non primary key attributes for joins (custom through model) (4247ms) βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation with multiple primary keys (one PK in each embed) (38ms) embedded > embedded-many-to-many-case4 owner side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation with multiple primary keys (multiple keys in related entity) inverse side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation with multiple primary keys (multiple keys in related entity) (38ms) embedded > embedded-many-to-many-case5 owner side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation with multiple primary keys (multiple keys in both sides) (39ms) inverse side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToMany relation with multiple primary keys (multiple keys in both sides) (46ms) embedded > embedded-many-to-one-case1 owner side PASS src/__tests__/integration/tidb/introspection.test.ts (16.275 s) βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation inverse side βœ“ supports non primary key attributes for joins for getting associations (sourceKey/targetKey) (2896ms) βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation embedded > embedded-many-to-one-case2 owner side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation inverse side βœ“ supports non primary key attributes for joins (custom foreignKey) (2905ms) βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation embedded > embedded-many-to-one-case3 owner side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation with multiple primary keys (one PK in each embed) inverse side βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation with multiple primary keys (one PK in each embed) embedded > embedded-many-to-one-case4 owner side βœ“ supports non primary key attributes for joins (custom foreignKey, custom through model) (4253ms) βœ“ supports primary key attributes with different field names where parent include is required (303ms) hasAssociations - supports transactions βœ“ answers false if only some labels have been assigned βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation with multiple primary keys (multiple keys in related entity) (43ms) inverse side βœ“ answers false if only some labels have been assigned when passing a primary key instead of an object βœ“ answers true if all label have been assigned βœ“ answers true if all label have been assigned when passing a primary key instead of an object βœ“ answers true for labels that have been assigned multitple times (221ms) βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation with multiple primary keys (multiple keys in related entity) embedded > embedded-many-to-one-case5 owner side βœ“ answers true for labels that have been assigned multitple times when passing a primary key instead of an object (220ms) hasAssociations with binary key βœ“ answers true for labels that have been assigned βœ“ answer false for labels that have not been assigned countAssociations βœ“ should count all associations βœ“ should count filtered associations βœ“ should count scoped associations βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation with multiple primary keys (multiple keys in both sides) inverse side βœ“ should count scoped through associations setAssociations βœ“ clears associations when passing null to the set-method (121ms) βœ“ should be able to set twice with custom primary keys (106ms) βœ“ joins an association with custom primary keys (124ms) βœ“ supports passing the primary key instead of an object (108ms) βœ” should insert, load, update and remove entities with embeddeds when embedded entity having ManyToOne relation with multiple primary keys (multiple keys in both sides) embedded > embedded-one-to-one owner side βœ“ using scope to set associations (139ms) βœ” should insert, load, update and remove entities with embeddeds when embedded entity having OneToOne relation inverse side - should insert, load, update and remove entities with embeddeds when embedded entity having OneToOne relation embedded > embedded-with-special-columns βœ“ updating association via set associations with scope (149ms) PASS src/__tests__/integration/tidb/runtime.test.ts (14.414 s) Test Suites: 2 passed, 2 total Tests: 130 passed, 130 total Snapshots: 130 passed, 130 total Time: 31.133 s prisma-4.16.x end [Pipeline] } Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_nodejs_test-1073/tidb-test already exists) [Pipeline] // cache [Pipeline] } [Pipeline] // dir [Pipeline] } [Pipeline] // stage [Pipeline] } [Pipeline] // container [Pipeline] } [Pipeline] // withEnv [Pipeline] } βœ“ should catch EmptyResultError when rejectOnEmpty is set (111ms) createAssociations [Pipeline] // node [Pipeline] } [Pipeline] // podTemplate [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // stage [Pipeline] } βœ“ creates a new associated object (107ms) - supports transactions βœ“ supports setting through table attributes (106ms) βœ” should insert, load, update and remove entities with embeddeds when embeds contains special columns (e.g. CreateDateColumn, UpdateDateColumn, DeleteDateColumn, VersionColumn (1025ms) embedded > multiple-primary-column βœ” should insert, load, update and remove entities with embeddeds when primary column defined in main and in embedded entities embedded > multiple-primary-columns-with-nested-embed βœ” should insert, load, update and remove entities with embeddeds when primary column defined in main and in embedded entities other issues > entity listeners must work in optional embeddeds as well βœ” getters and setters should work correctly embedded > outer-primary-column βœ” should insert, load, update and remove entities with embeddeds when primary column defined only in embedded entity embedded > prefix functionality βœ” should insert, load, update and remove entities with embeddeds properly entity-listeners βœ“ supports using the field parameter (103ms) addAssociations βœ” beforeUpdate entity-metadata > create without entitySkipConstructor βœ” should call the constructor when creating an object βœ” should set the default property values βœ” should call the constructor when retrieving an object with entitySkipConstructor βœ” should call the constructor when creating an object βœ” should set the default property values when creating an object βœ” should not call the constructor when retrieving an object entity-metadata > property-map βœ“ supports both single instance and array (104ms) - supports transactions βœ” should create correct property map object entity-metadata-validator βœ” should throw error if relation count decorator used with ManyToOne or OneToOne relations entity-metadata-validator > initialized relations βœ” should throw error if relation with initialized array was found on many-to-many relation βœ” should throw error if relation with initialized array was found on one-to-many relation βœ” should not throw error if relation with initialized array was not found βœ” should not throw error if relation with initialized array was found, but persistence for this relation was disabled entity-model βœ“ supports transactions when updating a through model (115ms) βœ“ supports passing the primary key instead of an object (102ms) βœ” should save successfully and use static methods successfully βœ” should reload given entity successfully (295ms) βœ” should reload exactly the same entity (316ms) upsert βœ” should upsert successfully entity schemas > basic functionality βœ” should perform basic operations with entity using repository βœ” should perform basic operations with entity using manager entity-schema > checks entity-schema > checks > postgres, cockroachdb, oracle, mssql βœ” should create a check constraints entity-schema > checks > spanner βœ” should create a check constraints entity-schema > columns > mysql βœ” should create columns with different options entity schema > custom constraint names > foreign key βœ“ should not pass indexes to the join table (2748ms) βœ“ should catch EmptyResultError when rejectOnEmpty is set (105ms) βœ“ should returns array of intermediate table (103ms) addMultipleAssociations βœ“ supports both single instance and array (104ms) βœ“ adds associations without removing the current ones (113ms) through model validations βœ“ runs on add βœ“ runs on set βœ” should set custom constraint names βœ“ runs on create optimizations using bulk create, destroy and update βœ“ uses one insert into statement βœ“ uses one delete from statement join table creation βœ“ should work with non integer primary keys (301ms) βœ“ makes join table non-paranoid by default βœ” should load constraints with custom names - should not change constraint names when table renamed - should not change constraint names when column renamed entity schema > custom constraint names > index βœ” should set custom constraint names βœ” should load constraints with custom names βœ“ should allow creation of a paranoid join table βœ” should not change constraint names when table renamed (54ms) foreign keys βœ“ should correctly generate underscored keys βœ“ should infer otherKey from paired BTM relationship with a through string defined βœ“ should infer otherKey from paired BTM relationship with a through model defined foreign key with fields specified βœ” should not change constraint names when column renamed (43ms) database schema > custom constraint names > primary key βœ” should set custom constraint names βœ” should load constraints with custom names βœ” should not change constraint names when table renamed βœ” should not change constraint names when column renamed database schema > custom constraint names > unique βœ” should set custom constraint names βœ” should load constraints with custom names βœ“ should correctly get associations even after a child instance is deleted (155ms) βœ” should not change constraint names when table renamed (51ms) βœ” should not change constraint names when column renamed (44ms) entity-schema > embedded - class-instance βœ“ should correctly get associations when doubly linked (150ms) βœ” should create an table βœ” should not create table with embedded βœ” should create embedded column name with prefix βœ” should create index for embedded entity-schema > embedded - class-instance βœ” should save entity with embedded βœ” should contains instance of target class embedded entity entity-schema > embedded - plain-object βœ“ should be able to handle nested includes properly (215ms) βœ” should save entity with embedded βœ” should contains instance of plain object for embedded entity entity-schema > exclusions βœ” should create an exclusion constraint entity-schema > indices > basic primary key handling for join table βœ“ removes the primary key if it was added by sequelize βœ“ keeps the primary key if it was added by the user without sync βœ“ removes all associations βœ” should create a non unique index with 2 columns through paranoid βœ“ gets only non-deleted records by default βœ“ returns both deleted and non-deleted records with paranoid=false βœ“ hasAssociation also respects paranoid option fetching from join table βœ“ should contain the data from the join table on .UserProjects a DAO βœ” should update the index to be unique (1423ms) βœ“ should be able to alias the default name of the join table βœ“ should be able to limit the join table attributes returned inserting in join table add βœ“ should insert data provided on the object into the join table βœ“ should insert data provided as a second argument into the join table βœ“ should be able to add twice (second call result in UPDATE call) without any attributes (and timestamps off) on the through model (325ms) βœ” should update the index swaping the 2 columns (1432ms) entity-schema > indices > mysql - should correctly create SPATIAL and FULLTEXT indices entity schemas > target option βœ” should create instance of the target βœ” should find instances of the target entity-schema > uniques βœ” should create an unique constraint with 2 columns entity subscriber > query data βœ” passes query data to subscriber βœ” cleans up the data after the save completes entity subscriber > transaction flow βœ” transactionStart βœ” transactionCommit βœ” transactionRollback errors > prototype tree βœ” prototype tree makes sense find options > find operators > ArrayContainedBy βœ” should find entries in regular arrays βœ” should find entries in enum arrays find options > find operators > ArrayContains βœ” should find entries in regular arrays βœ” should find entries in enum arrays find options > find operators > ArrayOverlap βœ” should find entries in regular arrays βœ” should find entries in enum arrays find options > order βœ“ should be able to add twice (second call result in UPDATE call) with custom primary keys and without any attributes (and timestamps off) on the through model (330ms) βœ“ should be able to create an instance along with its many-to-many association which has an extra column in the junction table (355ms) set βœ“ should be able to combine properties on the associated objects, and default values βœ“ should be able to set twice (second call result in UPDATE calls) without any attributes (and timestamps off) on the through model (319ms) query with through.where βœ“ should support query the through model removing from the join table βœ“ should remove a single entry without any attributes (and timestamps off) on the through model (120ms) βœ“ should remove multiple entries without any attributes (and timestamps off) on the through model (116ms) βœ” order by id DESC (55ms) belongsTo and hasMany at once source belongs to target βœ“ correctly uses bId in A target belongs to source βœ“ correctly uses bId in A alias βœ“ creates the join table when through is a string (101ms) βœ“ creates the join table when through is a model (97ms) βœ“ correctly identifies its counterpart when through is a string βœ“ correctly identifies its counterpart when through is a model multiple hasMany project has owners and users and owners and users have projects βœ“ correctly sets user and owner Foreign key constraints βœ“ can cascade deletes both ways by default (110ms) βœ“ can restrict deletes both ways (112ms) βœ“ can cascade and restrict deletes (114ms) βœ“ should be possible to remove all constraints (105ms) βœ“ create custom unique identifier (144ms) Association options βœ“ should throw an error if foreignKey and as result in a name clash allows the user to provide an attribute definition object as foreignKey βœ“ works when taking a column directly from the object thisAssociations βœ“ should work with this reference (76ms) βœ“ should work with custom this reference (225ms) βœ“ should setup correct foreign keys Eager loading βœ“ should load with an alias (115ms) βœ” order by title (39ms) βœ“ should load all (114ms) [MYSQL] BelongsTo Model.associations βœ“ should store all associations when associating to the same table multiple times get multiple βœ“ should fetch associations for multiple instances (81ms) getAssociation βœ“ supports transactions (90ms) βœ“ should be able to handle a where object that's a first class citizen. (77ms) βœ“ supports schemas (84ms) βœ“ supports schemas when defining custom foreign key attribute #9029 (81ms) setAssociation βœ“ supports transactions (78ms) βœ“ can set the association with declared primary keys... (79ms) βœ“ clears the association if null is passed (83ms) βœ“ should throw a ForeignKeyConstraintError if the associated record does not exist (74ms) βœ“ supports passing the primary key instead of an object (76ms) βœ“ should support logging (73ms) βœ“ should not clobber atributes (72ms) βœ“ should set the foreign key value without saving when using save: false (73ms) βœ“ supports setting same association twice (77ms) createAssociation βœ“ creates an associated model instance (78ms) βœ” where two criteria (44ms) βœ“ supports transactions (80ms) foreign key βœ“ should setup underscored field with foreign keys when using underscored βœ“ should use model name when using camelcase βœ“ should support specifying the field of a foreign key (77ms) βœ“ should set foreignKey on foreign table (175ms) foreign key constraints βœ“ are enabled by default (82ms) βœ“ sets to NO ACTION if allowNull: false (78ms) βœ“ should be possible to disable them (71ms) βœ“ can cascade deletes (79ms) βœ“ can restrict deletes (78ms) βœ“ can restrict updates (82ms) βœ“ can cascade updates (86ms) association column βœ“ has correct type and name for non-id primary keys with non-integer type (72ms) βœ“ should support a non-primary key as the association column on a target without a primary key (82ms) βœ“ should support a non-primary unique key as the association column (82ms) βœ“ should support a non-primary key as the association column with a field option (80ms) βœ“ should support a non-primary key as the association column in a table with a composite primary key (83ms) association options βœ“ can specify data type for auto-generated relational keys (126ms) βœ“ should throw an error if foreignKey and as result in a name clash βœ“ should throw an error if an association clashes with the name of an already define attribute allows the user to provide an attribute definition object as foreignKey βœ“ works with a column that hasnt been defined before βœ“ works when taking a column directly from the object βœ“ works when merging with an existing definition Eager loading βœ“ should load with an alias (91ms) βœ“ should load all (80ms) [MYSQL] HasMany Model.associations βœ“ should store all assocations when associting to the same table multiple times count βœ“ should not fail due to ambiguous field (87ms) get multiple βœ” order by relation (46ms) βœ“ should fetch associations for multiple instances (91ms) βœ“ should fetch associations for multiple instances with limit and order (90ms) βœ“ should fetch multiple layers of associations with limit and order with separate=true (138ms) βœ“ should fetch associations for multiple instances with limit and order and a belongsTo relation (132ms) βœ“ supports schemas (145ms) (1:N) βœ“ clears associations when passing null to the set-method with omitNull set to true (91ms) hasAssociation βœ“ should only generate one set of foreignKeys βœ“ supports transactions (192ms) βœ“ does not have any labels assigned to it initially βœ“ answers true if the label has been assigned βœ“ answers correctly if the label has been assigned when passing a primary key instead of an object hasAssociations βœ“ supports transactions (162ms) βœ” order by relation with where relation applied (41ms) βœ“ answers false if only some labels have been assigned βœ“ answers false if only some labels have been assigned when passing a primary key instead of an object βœ“ answers true if all label have been assigned βœ“ answers true if all label have been assigned when passing a primary key instead of an object setAssociations βœ“ supports transactions (88ms) βœ“ clears associations when passing null to the set-method (94ms) βœ“ supports passing the primary key instead of an object (88ms) addAssociations βœ“ supports transactions (91ms) βœ“ supports passing the primary key instead of an object (82ms) addMultipleAssociations βœ“ adds associations without removing the current ones (89ms) βœ“ handles decent sized bulk creates (200ms) createAssociations βœ“ creates a new associated object (81ms) βœ“ creates the object with the association directly (80ms) βœ“ supports transactions (82ms) βœ“ supports passing the field option (81ms) getting assocations with options βœ” order by nested relations (44ms) βœ“ should treat the where object of associations as a first class citizen (247ms) βœ“ gets all associated objects when no options are passed βœ“ only get objects that fulfill the options countAssociations βœ“ should count all associations βœ“ should count filtered associations βœ“ should count scoped associations thisAssociations βœ“ should work with alias foreign key constraints 1:m βœ“ sets null by default (87ms) βœ“ sets to CASCADE if allowNull: false (83ms) βœ“ should be possible to remove all constraints (74ms) βœ“ can cascade deletes (90ms) βœ“ can cascade updates (84ms) βœ“ can restrict deletes (84ms) βœ“ can restrict updates (84ms) Association options βœ“ should setup underscored field with foreign keys when using underscored βœ“ should use model name when using camelcase βœ“ can specify data type for auto-generated relational keys (92ms) βœ“ infers the keyType if none provided (74ms) βœ” order by complex nested relations (48ms) βœ“ should throw an error if foreignKey and as result in a name clash (node:762) [SEQUELIZE0005] DeprecationWarning: Passing a double nested nested array to `group` is unsupported and will be removed in v6. (Use `node --trace-deprecation ...` to show where the warning was created) βœ“ should ignore group from ancestor on deep separated query (136ms) allows the user to provide an attribute definition object as foreignKey βœ“ works with a column that hasnt been defined before βœ“ works when taking a column directly from the object βœ“ works when merging with an existing definition sourceKey βœ“ should use sourceKey βœ“ should count related records βœ” order by column in embed (45ms) βœ“ should set right field when add relative βœ“ should create with nested associated models βœ” order by relation in embed (45ms) find options > relations βœ“ should create nested associations with symmetric getters/setters on FK (1603ms) sourceKey with where clause in include βœ“ should use the specified sourceKey instead of the primary key βœ” basic relation (47ms) Eager loading βœ“ should load with an alias (92ms) βœ“ should load all (84ms) [MYSQL] HasOne Model.associations βœ“ should store all associations when associating to the same table multiple times get multiple βœ“ should fetch associations for multiple instances (82ms) getAssociation βœ“ supports transactions (94ms) βœ“ should be able to handle a where object that's a first class citizen. (90ms) βœ“ supports schemas (94ms) setAssociation βœ“ supports transactions (87ms) βœ“ can set an association with predefined primary keys (84ms) βœ“ clears the association if null is passed (83ms) βœ“ should throw a ForeignKeyConstraintError if the associated record does not exist (79ms) βœ“ supports passing the primary key instead of an object (93ms) βœ“ supports updating with a primary key instead of an object (95ms) βœ“ supports setting same association twice (89ms) createAssociation βœ“ creates an associated model instance (83ms) βœ“ supports transactions (97ms) foreign key βœ“ should setup underscored field with foreign keys when using underscored βœ“ should use model name when using camelcase βœ” complex relation #1 (47ms) βœ“ should support specifying the field of a foreign key (87ms) βœ“ should support custom primary key field name in sub queries (80ms) foreign key constraints βœ“ are enabled by default (84ms) βœ“ sets to CASCADE if allowNull: false (85ms) βœ“ should be possible to disable them (72ms) βœ“ can cascade deletes (87ms) βœ“ works when cascading a delete with hooks but there is no associate (i.e. "has zero") (77ms) βœ“ can cascade updates (91ms) βœ“ can restrict deletes (91ms) βœ“ can restrict updates (84ms) association column βœ“ has correct type for non-id primary keys with non-integer type (74ms) βœ“ should support a non-primary key as the association column on a target with custom primary key (93ms) βœ“ should support a non-primary unique key as the association column (87ms) βœ“ should support a non-primary unique key as the association column with a field option (89ms) Association options βœ“ can specify data type for autogenerated relational keys (518ms) βœ“ should throw an error if an association clashes with the name of an already define attribute allows the user to provide an attribute definition object as foreignKey βœ“ works with a column that hasnt been defined before βœ“ works when taking a column directly from the object βœ“ works when merging with an existing definition Counter part BelongsTo βœ“ should only generate one foreign key Eager loading βœ“ should load with an alias (97ms) βœ“ should load all (98ms) [MYSQL] Multiple Level Filters βœ” complex relation #2 (47ms) βœ“ can filter through belongsTo (135ms) βœ“ avoids duplicated tables in query (131ms) βœ“ can filter through hasMany (132ms) βœ“ can filter through hasMany connector (129ms) [MYSQL] associations scope 1:1 βœ“ should create, find and include associations with scope values (170ms) βœ“ should create included association with scope values (161ms) 1:M βœ“ should create, find and include associations with scope values (167ms) βœ“ should make the same query if called multiple time (#4470) (147ms) βœ“ should created included association with scope values (154ms) βœ” relation in embed (50ms) find options > select βœ“ should include associations with operator scope values (147ms) βœ“ should not mutate scope when running SELECT query (#12868) (151ms) N:M on the target βœ“ [Flaky] should create, find and include associations with scope values (136ms) on the through model βœ“ should create, find and include associations with scope values (669ms) [MYSQL] Self βœ“ supports freezeTableName (48ms) βœ“ can handle 1:m associations (56ms) βœ“ can handle n:m associations (105ms) βœ“ can handle n:m associations with pre-defined through table (98ms) [MYSQL] CLS (Async hooks) βœ“ CLS namespace is stored in Sequelize._cls βœ“ promises returned by sequelize.query are correctly patched βœ” select id (44ms) βœ“ custom logging with benchmarking has correct CLS context (514ms) context βœ“ does not use continuation storage on manually managed transactions βœ“ supports several concurrent transactions βœ“ supports nested promise chains βœ“ does not leak variables to the outer scope (502ms) βœ“ does not leak variables to the following promise chain βœ“ does not leak outside findOrCreate sequelize.query integration βœ“ automagically uses the transaction in all calls βœ“ automagically uses the transaction in all calls with async/await Model Hook integration βœ“ passes the transaction to hooks {beforeBulkCreate,beforeCreate,afterCreate,afterBulkCreate} when calling Model.bulkCreate βœ“ passes the transaction to hooks {beforeFind,beforeFindAfterExpandIncludeAll,beforeFindAfterOptions} when calling Model.findAll βœ“ passes the transaction to hooks {afterFind} when calling Model.findAll βœ“ passes the transaction to hooks {beforeCount} when calling Model.count βœ“ passes the transaction to hooks {beforeUpsert,afterUpsert} when calling Model.upsert βœ“ passes the transaction to hooks {beforeBulkDestroy,afterBulkDestroy} when calling Model.destroy βœ“ passes the transaction to hooks {beforeDestroy,beforeDestroy} when calling Model.destroy with individualHooks βœ“ passes the transaction to hooks {beforeDestroy,beforeDestroy} when calling Model#destroy βœ“ passes the transaction to hooks {beforeBulkUpdate,afterBulkUpdate} when calling Model.update βœ“ passes the transaction to hooks {beforeUpdate,afterUpdate} when calling Model.update with individualHooks βœ“ passes the transaction to hooks {beforeCreate,afterCreate} when calling Model#save (isNewRecord) βœ“ passes the transaction to hooks {beforeUpdate,afterUpdate} when calling Model#save (!isNewRecord) paranoid restore βœ“ passes the transaction to hooks {beforeBulkRestore,afterBulkRestore} when calling Model.restore βœ“ passes the transaction to hooks {beforeRestore,afterRestore} when calling Model.restore with individualHooks βœ“ passes the transaction to hooks {beforeRestore,afterRestore} when calling Model#restore [MYSQL] Configuration Connections problems should fail with a nice message βœ“ when we don't have the correct server details βœ“ when we don't have the correct login information βœ“ when we don't have a valid dialect. [MYSQL] DataTypes βœ“ allows me to return values from a custom parse function (45ms) βœ“ calls parse and stringify for JSON (40ms) βœ“ calls parse and stringify for DATE (40ms) βœ“ calls parse and stringify for DATEONLY (40ms) βœ“ calls parse and stringify for TIME (41ms) βœ“ calls parse and stringify for BLOB (39ms) βœ“ calls parse and stringify for CHAR (38ms) βœ“ calls parse and stringify/bindParam for STRING (38ms) βœ“ calls parse and stringify for TEXT (38ms) βœ” select title (51ms) βœ“ calls parse and stringify for BOOLEAN (41ms) βœ“ calls parse and stringify for INTEGER (40ms) βœ“ calls parse and stringify for DECIMAL (39ms) βœ“ calls parse and stringify for BIGINT (39ms) βœ“ should handle JS BigInt type (42ms) βœ“ should handle TINYINT booleans (39ms) βœ“ calls parse and bindParam for DOUBLE (39ms) βœ“ calls parse and bindParam for FLOAT βœ“ calls parse and bindParam for REAL (38ms) βœ“ calls parse and stringify for UUID βœ“ calls parse and stringify for CIDR βœ“ calls parse and stringify for INET βœ“ calls parse and stringify for CITEXT βœ“ calls parse and stringify for MACADDR βœ“ calls parse and stringify for ENUM βœ“ should parse DECIMAL as string (39ms) βœ“ should parse BIGINT as string (42ms) βœ“ should allow spaces in ENUM (44ms) βœ“ should return YYYY-MM-DD format string for DATEONLY (42ms) βœ“ should return set DATEONLY field to NULL correctly (42ms) βœ“ should be able to cast buffer as boolean [MYSQL] Connection Manager βœ“ should initialize a single pool without replication βœ“ should initialize a multiple pools with replication βœ“ should round robin calls to the read pool βœ“ should trigger deprecation for non supported engine version βœ“ should allow forced reads from the write pool βœ“ should clear the pool after draining it [MYSQL Specific] Associations many-to-many where tables have the same prefix βœ“ should create a table wp_table1wp_table2s (67ms) when join table name is specified βœ“ should not use only a specified name HasMany addDAO / getModel βœ“ should correctly add an association to the dao removeDAO βœ“ should correctly remove associated objects [MYSQL Specific] Connection Manager βœ“ -FOUND_ROWS can be suppressed to get back legacy behavior (43ms) βœ“ should acquire a valid connection when keepDefaultTimezone is true [MYSQL Specific] DAOFactory constructor βœ“ handles extended attributes (unique) βœ“ handles extended attributes (default) βœ“ handles extended attributes (null) βœ“ handles extended attributes (primaryKey) βœ“ adds timestamps βœ“ adds deletedAt if paranoid βœ“ underscores timestamps if underscored βœ“ omits text fields with defaultValues βœ“ omits blobs fields with defaultValues primaryKeys βœ“ determines the correct primaryKeys [MYSQL Specific] Errors ForeignKeyConstraintError βœ“ in context of DELETE restriction (139ms) βœ” select title and text (43ms) βœ“ in context of missing relation (140ms) [MYSQL] Warning logging Executing (default): DROP TABLE IF EXISTS `models`; Executing (default): SHOW WARNINGS MySQL Warnings (default): Unknown table 'sequelize_test.models'; Unknown table 'sequelize_test.models' Executing (default): SELECT CONSTRAINT_NAME as constraint_name,CONSTRAINT_NAME as constraintName,CONSTRAINT_SCHEMA as constraintSchema,CONSTRAINT_SCHEMA as constraintCatalog,TABLE_NAME as tableName,TABLE_SCHEMA as tableSchema,TABLE_SCHEMA as tableCatalog,COLUMN_NAME as columnName,REFERENCED_TABLE_SCHEMA as referencedTableSchema,REFERENCED_TABLE_SCHEMA as referencedTableCatalog,REFERENCED_TABLE_NAME as referencedTableName,REFERENCED_COLUMN_NAME as referencedColumnName FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE where TABLE_NAME = 'models' AND CONSTRAINT_NAME!='PRIMARY' AND CONSTRAINT_SCHEMA='sequelize_test' AND REFERENCED_TABLE_NAME IS NOT NULL; Executing (default): DROP TABLE IF EXISTS `models`; Executing (default): SHOW WARNINGS MySQL Warnings (default): Unknown table 'sequelize_test.models'; Unknown table 'sequelize_test.models' Executing (default): DROP TABLE IF EXISTS `models`; Executing (default): SHOW WARNINGS MySQL Warnings (default): Unknown table 'sequelize_test.models'; Unknown table 'sequelize_test.models' Executing (default): CREATE TABLE IF NOT EXISTS `models` (`id` INTEGER NOT NULL auto_increment , `name` VARCHAR(1) BINARY, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB; Executing (default): SHOW INDEX FROM `models` Executing (default): SELECT 1+1 AS result Executing (default): SET SESSION sql_mode=''; Executing (default): INSERT INTO `models` (`id`,`name`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?); Executing (default): SHOW WARNINGS MySQL Warnings (default): βœ“ logs warnings when there are warnings (47ms) [MYSQL] Sequelize Errors API Surface βœ“ Should have the Error constructors exposed βœ“ Sequelize Errors instances should be instances of Error βœ“ SequelizeValidationError should find errors by path βœ“ SequelizeValidationError should override message property when message parameter is specified βœ“ SequelizeValidationError should concatenate an error messages from given errors if no explicit message is defined βœ“ SequelizeValidationErrorItem does not require instance & validator constructor parameters βœ“ SequelizeValidationErrorItem should have instance, key & validator properties when given to constructor βœ“ SequelizeValidationErrorItem.getValidatorKey() should return a string βœ“ SequelizeValidationErrorItem.getValidatorKey() should throw if namespace separator is invalid (only if NS is used & available) βœ“ SequelizeValidationErrorItem should map deprecated "type" values to new "origin" values βœ“ SequelizeValidationErrorItemOrigin is valid βœ“ SequelizeValidationErrorItem.Origins is valid βœ“ SequelizeDatabaseError should keep original message βœ“ SequelizeDatabaseError should keep the original sql and the parameters βœ“ ConnectionError should keep original message βœ“ ConnectionRefusedError should keep original message βœ“ AccessDeniedError should keep original message βœ“ HostNotFoundError should keep original message βœ“ HostNotReachableError should keep original message βœ“ InvalidConnectionError should keep original message βœ“ ConnectionTimedOutError should keep original message OptimisticLockError βœ“ got correct error type and message (43ms) ConstraintError βœ“ Can be intercepted as UniqueConstraintError using .catch (40ms) βœ“ Can be intercepted as ValidationError using .catch (39ms) βœ“ Supports newlines in keys (38ms) βœ“ Works when unique keys are not defined in sequelize (42ms) βœ“ adds parent and sql properties (46ms) [MYSQL] Hooks associations 1:1 cascade onUpdate βœ“ on success βœ“ on error cascade onDelete #remove βœ“ with no errors βœ“ with errors no cascade update βœ“ on success βœ” select column in embed (41ms) find options > where βœ“ on error no cascade delete #remove βœ“ with no errors βœ“ with errors 1:M cascade #remove βœ“ with no errors βœ“ with errors no cascade #remove βœ“ with no errors βœ“ with errors M:M cascade #remove βœ“ with no errors βœ” where id (47ms) βœ“ with errors no cascade #remove βœ“ with no errors βœ“ with errors multiple 1:M cascade #remove βœ“ with no errors βœ” where title (40ms) βœ“ with errors multiple 1:M sequential hooks cascade #remove βœ“ with no errors βœ“ with errors [MYSQL] Hooks #bulkCreate on success βœ“ should run hooks on error βœ“ should return an error from before βœ“ should return an error from after with the {individualHooks: true} option βœ“ should run the afterCreate/beforeCreate functions for each item created successfully βœ“ should run the afterCreate/beforeCreate functions for each item created with an error #bulkUpdate on success βœ“ should run hooks βœ” where two criteria (45ms) on error βœ“ should return an error from before βœ“ should return an error from after with the {individualHooks: true} option βœ“ should run the after/before functions for each item created successfully βœ“ should run the after/before functions for each item created successfully changing some data before updating βœ“ should run the after/before functions for each item created with an error #bulkDestroy on success βœ“ should run hooks on error βœ“ should return an error from before βœ“ should return an error from after with the {individualHooks: true} option βœ“ should run the after/before functions for each item created successfully βœ“ should run the after/before functions for each item created with an error #bulkRestore on success βœ“ should run hooks on error βœ“ should return an error from before βœ“ should return an error from after with the {individualHooks: true} option βœ“ should run the after/before functions for each item restored successfully βœ“ should run the after/before functions for each item restored with an error [MYSQL] Hooks #count on success βœ“ hook runs βœ“ beforeCount hook can change options on error βœ“ in beforeCount hook returns error [MYSQL] Hooks #create βœ“ should not trigger hooks on parent when using N:M association setters (238ms) βœ” where two criteria without match (42ms) on success βœ“ should run hooks on error βœ“ should return an error from before βœ“ should return an error from after preserves changes to instance βœ“ beforeValidate βœ“ afterValidate βœ“ beforeCreate βœ“ beforeSave βœ“ beforeSave with beforeCreate [MYSQL] Hooks #destroy on success βœ“ should run hooks on error βœ“ should return an error from before βœ“ should return an error from after with paranoid mode enabled βœ“ sets other changed values when soft deleting and a beforeDestroy hooks kicks in (43ms) βœ“ should not throw error when a beforeDestroy hook changes a virtual column (47ms) [MYSQL] Hooks #find βœ“ allow changing attributes via beforeFind #5675 on success βœ“ all hooks run βœ“ beforeFind hook can change options βœ“ beforeFindAfterExpandIncludeAll hook can change options βœ“ beforeFindAfterOptions hook can change options βœ“ afterFind hook can change results on error βœ“ in beforeFind hook returns error βœ“ in beforeFindAfterExpandIncludeAll hook returns error βœ“ in beforeFindAfterOptions hook returns error βœ“ in afterFind hook returns error [MYSQL] Hooks #define βœ“ beforeDefine hook can change model name βœ“ beforeDefine hook can alter options βœ“ beforeDefine hook can alter attributes βœ“ afterDefine hook can alter options #init βœ“ beforeInit hook can alter config βœ” where relation (45ms) βœ“ beforeInit hook can alter options βœ“ afterInit hook can alter options passing DAO instances beforeValidate / afterValidate βœ“ should pass a DAO instance to the hook (98ms) beforeCreate / afterCreate βœ“ should pass a DAO instance to the hook (89ms) beforeDestroy / afterDestroy βœ“ should pass a DAO instance to the hook (97ms) beforeUpdate / afterUpdate βœ“ should pass a DAO instance to the hook (96ms) Model#sync on success βœ“ should run hooks βœ“ should not run hooks when "hooks = false" option passed on error βœ“ should return an error from before βœ“ should return an error from after sequelize#sync on success βœ“ should run hooks βœ“ should not run hooks if "hooks = false" option passed on error βœ“ should return an error from before βœ“ should return an error from after βœ” where column and relation (47ms) #removal βœ“ should be able to remove by name βœ“ should be able to remove by reference βœ“ should be able to remove proxies Sequelize hooks βœ“ should run before/afterPoolAcquire hooks [MYSQL] Hooks #restore on success βœ“ should run hooks on error βœ“ should return an error from before βœ“ should return an error from after [MYSQL] Hooks #update on success βœ“ should run hooks on error βœ“ should return an error from before βœ“ should return an error from after preserves changes to instance βœ“ beforeValidate βœ“ afterValidate βœ“ beforeSave βœ“ beforeSave with beforeUpdate [MYSQL] Hooks #upsert on success βœ“ should run hooks on error βœ“ should return an error from before βœ“ should return an error from after preserves changes to values βœ“ beforeUpsert [MYSQL] Hooks #validate #create βœ“ should return the user #3534, hooks modifications βœ“ fields modified in hooks are saved on error βœ“ should emit an error from after hook βœ“ should call validationFailed hook βœ“ should not replace the validation error in validationFailed hook by default βœ“ should replace the validation error if validationFailed hook creates a new error [MYSQL] Include find βœ“ should support an empty belongsTo include (108ms) βœ“ should support a belongsTo association reference (97ms) βœ“ should support to use associations with Sequelize.col (164ms) βœ“ should support a belongsTo association reference with a where (105ms) βœ” where nested relations (43ms) βœ“ should support a empty hasOne include (105ms) βœ“ should support a hasOne association reference (95ms) βœ“ should support including a belongsTo association rather than a model/as pair (97ms) βœ“ should support a hasMany association reference (103ms) βœ“ should support a hasMany association reference with a where condition (102ms) βœ“ should support a belongsToMany association reference (136ms) βœ“ should support a simple nested belongsTo -> belongsTo include (145ms) βœ“ should support a simple sibling set of belongsTo include (133ms) βœ“ should support a simple nested hasOne -> hasOne include (144ms) βœ“ should support a simple nested hasMany -> belongsTo include (176ms) βœ” where complex nested relations (43ms) βœ“ should support a simple nested belongsTo -> hasMany include (147ms) βœ“ should support a simple nested hasMany to hasMany include (194ms) βœ“ should support an include with multiple different association types (386ms) βœ“ should support specifying attributes (99ms) βœ“ should support Sequelize.literal and renaming of attributes in included model attributes (96ms) βœ“ should support self associated hasMany (with through) include (102ms) βœ“ should support including date fields, with the correct timeszone (131ms) βœ“ should support include when retrieving associated objects (154ms) βœ” where or + optional relations (40ms) where βœ“ should support Sequelize.and() βœ“ should support Sequelize.or() findAndCountAll βœ“ should include associations to findAndCountAll (101ms) association getter βœ“ should support getting an include on a N:M association getter (184ms) right join βœ“ should support getting an include with a right join (93ms) βœ“ should support getting an include through with a right join (143ms) nested includes βœ“ should not ripple grandchild required to top level find when required of child is set to false βœ“ should support eager loading associations using the name of the relation (string) βœ“ should not ripple grandchild required to top level find when required of child is not given (implicitly false) βœ“ should ripple grandchild required to top level find when required of child is set to true as well [MYSQL] Include findAll βœ“ should work on a nested set of relations with a where condition in between relations (309ms) βœ” where column in embed (42ms) βœ“ should accept nested `where` and `limit` at the same time (207ms) βœ“ should support an include with multiple different association types (554ms) βœ“ should support many levels of belongsTo (581ms) βœ” where relation in embed (47ms) βœ“ should support many levels of belongsTo (with a lower level having a where) (552ms) βœ“ should support ordering with only belongsTo includes (159ms) βœ“ should include attributes from through models (154ms) βœ“ should support a required belongsTo include (103ms) βœ“ should be possible to extend the on clause with a where option on a belongsTo include (104ms) βœ“ should be possible to extend the on clause with a where option on a belongsTo include (106ms) βœ” where complex with or + and (41ms) βœ“ should be possible to define a belongsTo include as required with child hasMany not required (178ms) βœ“ should be possible to define a belongsTo include as required with child hasMany with limit (164ms) βœ“ should be possible to define a belongsTo include as required with child hasMany with limit and aliases (160ms) βœ“ should be possible to define a belongsTo include as required with child hasMany which is not required with limit (154ms) βœ“ should be possible to extend the on clause with a where option on a hasOne include (103ms) βœ“ should be possible to extend the on clause with a where option on a hasMany include with a through model (156ms) βœ“ should be possible to extend the on clause with a where option on nested includes (423ms) βœ“ should be possible to use limit and a where with a belongsTo include (94ms) βœ“ should be possible use limit, attributes and a where on a belongsTo with additional hasMany includes (549ms) βœ” where relations with operators (54ms) βœ“ should be possible to have the primary key in attributes (101ms) βœ“ should be possible to turn off the attributes for the through table (516ms) βœ“ should be possible to select on columns inside a through table (539ms) βœ” should not apply inner join if all conditions return undefined (45ms) βœ“ should be possible to select on columns inside a through table and a limit (546ms) βœ“ should be possible not to include the main id in the attributes (106ms) βœ“ should be possible to use limit and a where on a hasMany with additional includes (538ms) βœ“ should be possible to use limit and a where on a hasMany with a through model with additional includes (558ms) βœ” should apply inner join if true is applied (42ms) find options > where βœ” should skip undefined properties βœ” should skip null properties find options > opaque-types-over-primitives βœ” should work in select βœ” should work in where βœ” should work in order by indices > basic unique index test unique index βœ” should work without errors indices > conditional index βœ” should correctly create conditional indices with WHERE condition βœ” should correctly drop conditional indices and revert drop indices > embeds index test embeddeds index βœ” should work without errors indices > fulltext index - should correctly create fulltext indices - with default parser - with ngram parser jsonb type βœ” should make correct schema with Postgres' jsonb type βœ” should persist jsonb correctly βœ” should persist jsonb string correctly βœ” should persist jsonb array correctly βœ” should create updates when changing object βœ” should not create updates when resorting object βœ” should not create new migrations when everything is equivalent json > defaults βœ” should insert default values properly ltree-postgres βœ” should create correct schema with Postgres' ltree type βœ” should persist ltree correctly βœ” should update ltree correctly βœ” should re-save ltree correctly βœ” should persist ltree correctly with trailing '.' βœ” should persist ltree correctly when containing spaces βœ“ should support including date fields, with the correct timeszone (131ms) βœ” should be able to query ltree correctly metadata-builder > ColumnMetadata βœ” getValue βœ” getValueMap metadata builder > MetadataArgsUtils βœ” getInheritanceTree βœ” filterByTargetClasses migrations > generate command βœ” can recognize model changes βœ” does not generate when no model changes (220ms) migrations > show command βœ” can recognise pending migrations βœ” can recognise no pending migrations mongodb > array columns βœ” should insert / update array columns correctly βœ” should retrieve arrays from the column metadata mongodb > embedded columns βœ” should insert / update / remove entity with embedded correctly βœ” should store results in correct camelCase format βœ” should transform results to correct boolean value βœ” should transform entity with nested embedded columns correctly mongodb > embedded columns listeners βœ” should work listeners in entity embeddeds correctly βœ” should not work listeners in entity embeddeds if property is optional βœ” should work listeners in entity array embeddeds correctly mongodb > embeddeds indices βœ” should insert entity with embeddeds indices correctly mongodb > indices βœ” should insert entity with indices correctly mongodb > MongoRepository βœ” connection should return mongo repository when requested βœ” entity manager should return mongo repository when requested βœ” should be able to use entity cursor which will return instances of entity classes βœ” should be able to use entity cursor which will return instances of entity classes βœ” should be able to use findByIds with both ObjectId and strings βœ” should be able to save and update mongo entities βœ” should ignore non-column properties with DeletedDataColumn βœ” with $or query βœ” filter delete data findOne filtered data properly βœ” findOne() βœ” findOneBy() mongodb > object id columns βœ” should persist ObjectIdColumn property as _id to DB βœ” should map _id to ObjectIdColumn property and remove BD _id property βœ” should save and load properly if objectId property has name _id βœ” should not persist entity ObjectIdColumn property in DB on update by save mongodb > basic repository actions βœ” create should create instance of same entity βœ” create should be able to fill data from the given object βœ” merge should merge all given partial objects into given source entity βœ” merge should merge all given recursive partial objects into given source entity βœ” target should be valid βœ” should persist entity successfully and after persistence have generated object id βœ” hasId should return true if id really has an id βœ” unsupported methods should throw exception βœ” should return persisted objects using find* methods βœ” should sort entities in a query βœ” clear should remove all persisted entities βœ” remove should remove given entity βœ” clear should remove all persisted entities βœ” preload should pre-load given object mongodb > timestampable columns βœ” should persist timestampable columns multi-database > basic-functionality filepathToName() βœ” produces deterministic, unique, and valid table names for relative paths; leaves absolute paths unchanged (darwin) βœ” produces deterministic, unique, and valid table names for relative paths; leaves absolute paths unchanged (win32) multiple databases βœ” should correctly attach and create database files βœ” should prefix tableName when custom database used in Entity decorator βœ” should not affect tableName when using default main database βœ” should create foreign keys for relations within the same database multi-schema-and-database > custom-junction-database βœ“ should still pull the main record(s) when an included model is not required and has where restrictions without matches (126ms) βœ” should correctly create tables when custom table schema used multi-schema-and-database > custom-junction-schema βœ” should correctly create tables when custom table schema used multi-schema-and-database > basic-functionality custom-table-schema βœ” should set the table database / schema βœ” should correctly get the table primary keys when custom table schema used βœ” should correctly create tables when custom table schema used βœ” should correctly create tables when custom table schema used in Entity decorator βœ” should correctly work with cross-schema queries βœ” should correctly work with QueryBuilder custom-table-schema-and-database βœ” should set the table database / schema βœ” should correctly get the table primary keys when custom table schema used βœ” should correctly create tables when custom database and custom schema used in Entity decorator βœ” should correctly work with cross-schema and cross-database queries in QueryBuilder custom-database βœ“ should work with paranoid, a main record where, an include where, and a limit (103ms) βœ” should correctly create tables when custom database used in Entity decorator LegacyOracleNamingStrategy > column shortening βœ” should truncate column names to the limit βœ” should change column names to hashes within the limit LegacyOracleNamingStrategy > create table using this naming strategy βœ” should create the table LegacyOracleNamingStrategy > create table using default naming strategy βœ” should not create the table and fail due to ORA-00972 persistence > basic functionality βœ“ should work on a nested set of required 1:1 relations (139ms) βœ” should save an entity βœ” should remove an entity βœ” should throw an error when not an object is passed to a save method βœ“ should work with an empty include.where (180ms) βœ” should throw an error when not an object is passed to a remove method βœ“ should be able to order on the main table and a required belongsTo relation with custom tablenames and limit (106ms) βœ” should throw an exception if object literal is given instead of constructed entity because it cannot determine what to save βœ“ should ignore include with attributes: [] (used for aggregates) (103ms) βœ” should be able to save and remove entities of different types persistence > bulk-insert-remove-optimization βœ“ should ignore include with attributes: [] and through: { attributes: [] } (used for aggregates) (141ms) βœ“ should not add primary key when including and aggregating with raw: true (101ms) βœ” should group multiple insert and remove queries persistence > cascades > example 1 βœ” should insert everything by cascades properly persistence > cascades > example 2 βœ“ should return posts with nested include with inner join with a m:n association (242ms) βœ“ should be able to generate a correct request with inner and outer join (187ms) βœ“ should be able to generate a correct request for entity with 1:n and m:1 associations and limit (560ms) βœ“ should allow through model to be paranoid (152ms) [MYSQL] Include findAndCountAll βœ“ should be able to include two required models with a limit. Result rows should match limit. (126ms) βœ“ should be able to include a required model. Result rows should match count (222ms) βœ“ should count on a where and not use an uneeded include (100ms) βœ“ should return the correct count and rows when using a required belongsTo and a limit (108ms) βœ“ should return the correct count and rows when using a required belongsTo with a where condition and a limit (113ms) βœ“ should correctly filter, limit and sort when multiple includes and types of associations are present. (250ms) βœ“ should properly work with sequelize.function (107ms) [MYSQL] Include findOne βœ“ should include a non required model, with conditions and two includes N:M 1:M (226ms) βœ“ should work with a 1:M to M:1 relation with a where on the last include (144ms) βœ“ should include a model with a where condition but no required (101ms) βœ“ should include a model with a where clause when the PK field name and attribute name are different (98ms) βœ” should insert everything by cascades properly persistence > cascades > remove - should remove everything by cascades properly persistence > cascades > remove - should soft-remove everything by cascades properly persistence > cascade operations with custom name cascade update βœ“ should include a model with a through.where and required true clause when the PK field name and attribute name are different (141ms) βœ“ should still pull the main record when an included model is not required and has where restrictions without matches (129ms) βœ“ should support a nested include (with a where) (150ms) βœ“ should support a belongsTo with the targetKey option (116ms) βœ” should remove relation persistence > entity updation βœ” should update generated auto-increment id after saving βœ“ should support many levels of belongsTo (with a lower level having a where) (431ms) βœ” should update generated uuid after saving βœ“ should work with combinding a where and a scope (87ms) [MYSQL] Include LIMIT βœ” should update default values after saving βœ“ supports many-to-many association with where clause (606ms) βœ” should update special columns after saving βœ” should update even when multiple primary keys are used βœ” should update even with embeddeds persistence > insert > update-relation-columns-after-insertion βœ“ supports 2 levels of required many-to-many associations (597ms) βœ” should work perfectly persistence > many-to-many βœ“ supports 2 levels of required many-to-many associations with where clause (643ms) βœ” add exist element to exist object with empty many-to-many relation and save it and it should contain a new category βœ“ supports 2 levels of required many-to-many associations with through.where clause (648ms) βœ” remove one element from many-to-many relation should remove from the database as well βœ“ supports 3 levels of required many-to-many associations with where clause (667ms) βœ” remove all elements from many-to-many relation should remove from the database as well βœ“ supports required many-to-many association (642ms) βœ“ supports 2 required many-to-many association (637ms) βœ” remove all elements (set to null) from many-to-many relation should remove from the database as well (565ms) βœ“ supports required one-to-many association (622ms) βœ” remove all elements from many-to-many relation if parent entity is removed persistence > many-to-one bi-directional relation βœ“ supports required one-to-many association with where clause (623ms) βœ” should save a category with a post attached βœ“ supports required one-to-many association with where clause (findOne) (621ms) βœ” should save a category and a new post by cascades βœ“ supports 2 levels of required one-to-many associations (686ms) βœ” should update exist post by cascades when category is saved βœ“ supports required one-to-many association with nested required many-to-many association (663ms) βœ” should NOT remove exist post by cascades when category is saved without a post (post is set to undefined) βœ” should unset exist post when its set to null βœ“ supports required many-to-many association with nested required one-to-many association (682ms) βœ” should set category's post to NULL when post is removed from the database (database ON DELETE) βœ“ supports required many-to-one association with nested many-to-many association with where clause (659ms) βœ” should work when relation id is directly set into relation (without related object) persistence > many-to-one uni-directional relation βœ“ supports required many-to-one association with nested many-to-many association with through.where clause (661ms) βœ” should save a category with a post attached βœ“ supports required many-to-one association with multiple nested associations with where clause (677ms) βœ” should save a category and a new post by cascades βœ“ supports required many-to-one association with nested one-to-many association with where clause (664ms) βœ” should update exist post by cascades when category is saved [MYSQL] Paranoid βœ“ paranoid with timestamps: false should be ignored / not crash (618ms) βœ” should NOT remove exist post by cascades when category is saved without a post (post is set to undefined) βœ“ test if non required is marked as false βœ“ test if required is marked as true βœ” should unset exist post when its set to null βœ“ should not load paranoid, destroyed instances, with a non-paranoid parent (706ms) βœ” should set category's post to NULL when post is removed from the database (database ON DELETE) [MYSQL] Includes with schemas findAll βœ“ should support an include with multiple different association types (542ms) βœ” should work when relation id is directly set into relation (without related object) persistence > multi primary keys insert βœ“ should support many levels of belongsTo (576ms) βœ“ should support ordering with only belongsTo includes (178ms) βœ” should insert entity when there are multi column primary keys persistence > multi primary keys on both sides insert βœ“ should include attributes from through models (172ms) βœ“ should support a required belongsTo include (111ms) βœ“ should be possible to extend the on clause with a where option on a belongsTo include (112ms) βœ“ should be possible to extend the on clause with a where option on a belongsTo include (111ms) βœ“ should be possible to define a belongsTo include as required with child hasMany with limit (179ms) βœ“ should be possible to define a belongsTo include as required with child hasMany with limit and aliases (176ms) βœ” should insert entity when there are multi column primary keys persistence > null and default behaviour βœ” should insert value if it is set βœ” should insert default when post.title is undefined βœ” should insert NULL when post.title is null βœ” should update nothing when post.title is undefined βœ” should update to null when post.title is null persistence > one-to-many βœ“ should be possible to define a belongsTo include as required with child hasMany which is not required with limit (176ms) βœ“ should be possible to extend the on clause with a where option on a hasOne include (123ms) βœ“ should be possible to extend the on clause with a where option on a hasMany include with a through model (162ms) βœ” should add exist element to exist object with empty one-to-many relation and save it βœ“ should be possible to extend the on clause with a where option on nested includes (607ms) βœ“ should be possible to use limit and a where with a belongsTo include (121ms) βœ” should add exist element to new object with empty one-to-many relation and save it βœ“ should be possible use limit, attributes and a where on a belongsTo with additional hasMany includes (659ms) βœ” should remove exist element from one-to-many relation and save it βœ“ should be possible to use limit and a where on a hasMany with additional includes (627ms) βœ” should remove all elements from one-to-many relation and save it βœ“ should be possible to use limit and a where on a hasMany with a through model with additional includes (652ms) βœ“ should support including date fields, with the correct timezone (167ms) findOne βœ” set relation to null (elements exist there) from one-to-many relation and save it persistence > one-to-one set the relation with proper item βœ“ should work with schemas (113ms) βœ” should have an access token doesn't allow the same relation to be used twice [MYSQL] Include separate βœ“ should run a hasMany association in a separate query (121ms) βœ” should reject the saving attempt (69ms) persistence > orphanage > delete when a Post is removed from a Category βœ“ should work even if the id was not included (121ms) βœ“ should work even if include does not specify foreign key attribute with custom sourceKey (127ms) βœ“ should not break a nested include with null values (168ms) βœ“ should run a hasMany association with limit in a separate query (122ms) βœ“ should run a nested (from a non-separate include) hasMany association in a separate query (177ms) βœ” should retain a Post on the Category βœ“ should work having a separate include between a parent and child include (238ms) βœ“ should run two nested hasMany association in a separate queries (290ms) βœ“ should work with two schema models in a hasMany association (134ms) βœ“ should work with required non-separate parent and required child (178ms) βœ” should delete the orphaned Post from the database [MYSQL] Instance Escaping βœ“ is done properly for special characters isNewRecord βœ“ returns true for non-saved objects βœ“ returns false for saved objects βœ“ returns false for created objects βœ“ returns false for upserted objects βœ“ returns false for objects found by find method βœ“ returns false for objects found by findAll method default values uuid βœ“ should store a string in uuidv1 and uuidv4 βœ“ should store a string of length 36 in uuidv1 and uuidv4 βœ“ should store a valid uuid in uuidv1 and uuidv4 that conforms to the UUID v1 and v4 specifications βœ“ should store a valid uuid if the multiple primary key fields used current date βœ“ should store a date in touchedAt βœ“ should store the current date in touchedAt allowNull date βœ“ should be just "null" and not Date with Invalid Date βœ“ should be the same valid date when saving the date super user boolean βœ” should retain foreign keys on remaining Posts persistence > orphanage > disable when a User is updated without all settings being loaded... βœ“ should default to false βœ“ should override default when given truthy boolean βœ“ should override default when given truthy boolean-string ("true") βœ“ should override default when given truthy boolean-int (1) βœ“ should throw error when given value of incorrect type complete βœ“ gets triggered if an error occurs βœ“ gets triggered if everything was ok findAll βœ“ sql should have paranoid condition βœ“ sequelize.and as where should include paranoid condition βœ” should not delete setting with orphanedRowAction=disabed βœ“ sequelize.or as where should include paranoid condition βœ“ escapes a single single quotes properly in where clauses βœ“ escapes two single quotes properly in where clauses βœ“ returns the timestamps if no attributes have been specified βœ“ does not return the timestamps if the username attribute has been specified βœ“ creates the deletedAt property, when defining paranoid as true βœ” should not orphane any Settings persistence > partial persist βœ“ destroys a record with a primary key of something other than id (54ms) βœ” should persist partial entities without data loss persistence > persistence options > chunks βœ” should save objects in chunks persistence > persistence options > listeners βœ” save listeners should work by default βœ“ sets deletedAt property to a specific date when deleting an instance βœ” save listeners should be disabled if save option is specified βœ” remove listeners should work by default βœ“ keeps the deletedAt-attribute with value null, when running update βœ” remove listeners should be disabled if remove option is specified βœ“ keeps the deletedAt-attribute with value null, when updating associations βœ” soft-remove listeners should work by default βœ“ can reuse query option objects βœ” soft-remove listeners should be disabled if remove option is specified persistence > persistence options > transaction βœ” should disable transaction when option is specified findOne βœ“ can reuse query option objects βœ” should disable transaction when the drivers transactionSupport setting equals `none` persistence > order of persistence execution operations should throw exception when non-resolvable circular relations found βœ” should throw CircularRelationsError should persist all entities in correct order - persistence > remove-topological-order βœ“ returns null for null, undefined, and unset boolean values (55ms) equals βœ“ can compare records with Date field βœ“ does not compare the existence of associations (129ms) values βœ“ returns all values (46ms) isSoftDeleted βœ“ should return false when model is just created βœ“ returns false if user is not soft deleted βœ“ returns true if user is soft deleted βœ” should remove depend properties in a proper order query builder > brackets βœ” should put parentheses in the SQL βœ” should put brackets correctly into WHERE expression query builder > cache βœ“ works with custom `deletedAt` field name (56ms) restore βœ“ returns an error if the model is not paranoid βœ“ restores a previously deleted model (58ms) βœ“ supports custom deletedAt field (57ms) βœ“ supports custom deletedAt field name (55ms) βœ” should cache results properly (1025ms) βœ“ supports custom deletedAt field and database column (55ms) βœ“ supports custom default value (51ms) [MYSQL] InstanceValidator βœ“ correctly validates using custom validation methods βœ“ supports promises with custom validation methods (48ms) βœ“ skips other validations if allowNull is true and the value is null βœ“ validates a model with custom model-wide validation methods βœ“ validates model with a validator whose arg is an Array successfully twice in a row βœ“ validates enums βœ“ skips validations for the given fields βœ“ skips validations for fields with value that is SequelizeMethod βœ“ raises an error if saving a different value into an immutable field (45ms) βœ“ allows setting an immutable field if the record is unsaved βœ“ raises an error for array on a STRING βœ“ raises an error for array on a STRING(20) βœ“ raises an error for array on a TEXT βœ“ raises an error for {} on a STRING βœ“ raises an error for {} on a STRING(20) βœ“ raises an error for {} on a TEXT βœ“ does not raise an error for null on a STRING (where null is allowed) βœ“ validates VIRTUAL fields βœ“ allows me to add custom validation functions to validator.js #update βœ“ should allow us to update specific columns without tripping the validations (54ms) βœ“ should be able to emit an error upon updating when a validation has failed from an instance (47ms) βœ“ should be able to emit an error upon updating when a validation has failed from the factory (47ms) βœ“ should enforce a unique constraint (53ms) βœ” should cache results with pagination enabled properly (1025ms) βœ“ should allow a custom unique constraint error message (59ms) βœ“ should handle multiple unique messages correctly (56ms) #create generic βœ“ correctly throws an error using create method βœ“ correctly validates using create method explicitly validating primary/auto incremented columns βœ“ should emit an error when we try to enter in a string for the id key without validation arguments (45ms) βœ“ should emit an error when we try to enter in a string for an auto increment key (not named id) (46ms) primaryKey with the name as id with arguments for it's validatio βœ“ should emit an error when we try to enter in a string for the id key with validation arguments βœ“ should emit an error when we try to enter in a string for an auto increment key through .build().validate() βœ“ should emit an error when we try to .save() pass all paths when validating βœ“ produce 3 errors not null schema validation βœ“ correctly throws an error using create method βœ“ correctly throws an error using create method with default generated messages [MYSQL] Instance decrement βœ“ supports transactions (121ms) βœ“ with array βœ“ with single field βœ“ with single field and no value βœ” should cache results with custom id and duration supplied (2027ms) βœ“ should still work right with other concurrent updates βœ“ should still work right with other concurrent increments βœ“ with key value pair βœ“ with negative value βœ“ with timestamps set to true (59ms) βœ“ with timestamps set to true and options.silent set to true (52ms) βœ” should cache results with custom id and duration supplied (1023ms) query builder > comment βœ” should scrub end comment pattern from string [MYSQL] Instance destroy βœ“ supports transactions (51ms) βœ“ does not set the deletedAt date in subsequent destroys if dao is paranoid (54ms) βœ” should not allow an empty comment βœ” should allow a comment with just whitespaces βœ“ does not update deletedAt with custom default in subsequent destroys (50ms) βœ“ deletes a record from the database if dao is not paranoid (56ms) βœ” should allow a multi-line comment βœ” should include comment in select βœ” should include comment in update βœ“ allows updating soft deleted instance (54ms) βœ“ supports custom deletedAt field (57ms) βœ” should include comment in insert βœ” should include comment in delete query builder > composite primary βœ” should find entity by another entity with a composite key query builder > count βœ“ supports custom deletedAt database column (53ms) βœ“ supports custom deletedAt field and database column (58ms) βœ“ persists other model changes when soft deleting (56ms) βœ“ allows sql logging of delete statements (52ms) βœ” Count query should of empty table should be 0 βœ” Count query should count database values βœ“ allows sql logging of update statements (52ms) βœ“ should not call save hooks when soft deleting (54ms) βœ” Count query should handle ambiguous values βœ“ delete a record of multiple primary keys table (54ms) [MYSQL] Instance increment βœ“ supports transactions (117ms) βœ” counting joined query should count database values βœ“ supports where conditions βœ“ with array βœ” counting joined queries should handle ambiguous values query builder > cte > materialized βœ“ with single field βœ“ with single field and no value βœ” should allow MATERIALIZED hint βœ“ should still work right with other concurrent updates βœ“ should still work right with other concurrent increments βœ” should allow NOT MATERIALIZED hint βœ” should omit hint if materialized option is not set query builder > cte > recursive βœ“ with key value pair βœ“ single value should work when field name is different from database column name βœ” should work with simple recursive query query builder > cte > simple βœ“ array should work when field name is different from database column name βœ“ key value should work when field name is different from database column name βœ” show allow select from CTE βœ” should allow join with CTE βœ“ with timestamps set to true (50ms) βœ” should allow to use INSERT with RETURNING clause in CTE βœ” should allow string for CTE query builder > delete βœ“ with timestamps set to true and options.silent set to true (55ms) βœ” should perform deletion correctly [MYSQL] Instance reload βœ“ supports transactions (121ms) βœ” should be able to delete entities by embed criteria βœ“ should return a reference to the same DAO instead of creating a new one βœ“ should use default internal where βœ” should return correct delete result βœ” should throw error when unknown property in where criteria query builder > distinct on βœ” should perform distinct on category authors βœ” should perform distinct on post authors and moderators combination βœ” should perform distinct on post and category authors query builder > enabling transaction βœ“ should update the values on all references to the DAO βœ“ should support updating a subset of attributes βœ” should execute query in a transaction query builder > entity updation βœ“ should update read only attributes as well (updatedAt) βœ” should update entity model after insertion if updateEntity is set to true βœ” should not update entity model after insertion if updateEntity is set to false βœ“ should update the associations as well (124ms) βœ” should not override already set properties βœ” should update entity model after save βœ“ should update internal options of the instance (122ms) βœ” should update special entity properties after entity updation if updateEntity is set to true βœ” should not update special entity properties after entity updation if updateEntity is set to false query builder > exist βœ” Exists query of empty table should be false βœ” Exists query of non empty table should be true query builder > insert βœ“ should return an error when reload fails βœ” should perform insertion correctly βœ“ should set an association to null after deletion, 1-1 (247ms) βœ” should perform bulk insertion correctly βœ“ should set an association to empty after all deletion, 1-N (245ms) βœ” should be able to use sql functions βœ” should be able to insert entities with different properties set even inside embeds query builder > insertion > on conflict βœ” should perform insertion correctly using onConflict βœ” should support alias in insert βœ” should perform insertion correctly using orIgnore βœ” should perform insertion correctly using orUpdate βœ” should perform insertion on partial index using orUpdate βœ” should perform insertion using partial index and skipping update on no change βœ” should throw error if using indexPredicate amd an unsupported driver query builder > joins leftJoinAndSelect βœ“ should update the associations after one element deleted (269ms) βœ“ should inject default scope when reloading (117ms) [MYSQL] Instance save βœ“ supports transactions (123ms) βœ“ only updates fields in passed array βœ“ should work on a model with an attribute named length (66ms) βœ“ only validates fields in passed array βœ“ stores an entry in the database βœ“ handles an entry with primaryKey of zero (54ms) βœ“ updates the timestamps βœ“ does not update timestamps when passing silent=true βœ“ does not update timestamps when passing silent=true in a bulk update βœ” should load data for all relation types (42ms) βœ“ updates with function and column value βœ“ updates with function that contains escaped dollar symbol βœ“ updates with function that contains multiple escaped dollar symbols βœ“ should fail a validation upon creating βœ“ should fail a validation upon creating with hooks false βœ“ should fail a validation upon building βœ“ should fail a validation when updating βœ“ takes zero into account βœ“ saves a record with no primary key (48ms) hooks βœ“ should update attributes added in hooks when default fields are used (53ms) βœ“ should update attributes changed in hooks when default fields are used (52ms) βœ“ should validate attributes added in hooks when default fields are used (62ms) βœ“ should validate attributes changed in hooks when default fields are used (63ms) when nothing changed βœ“ does not update timestamps βœ“ should not throw ER_EMPTY_QUERY if changed only virtual fields (49ms) βœ” should load data when additional condition used without timestamps option βœ“ doesn't update the updatedAt column (54ms) with custom timestamp options βœ“ updates the createdAt column if updatedAt is disabled (48ms) βœ“ updates the updatedAt column if createdAt is disabled (47ms) βœ“ works with `allowNull: false` on createdAt and updatedAt columns (51ms) eagerly loaded objects βœ“ saves one object that has a collection of eagerly loaded objects βœ“ saves many objects that each a have collection of eagerly loaded objects βœ“ saves many objects that each has one eagerly loaded object (to which they belong) [MYSQL] Instance toJSON βœ“ doesn't return instance that isn't defined βœ“ doesn't return instances that aren't defined βœ” should load data when join tables does not have direct relation innerJoinAndSelect βœ“ includes the eagerly loaded associations build βœ“ returns an object containing all values βœ“ returns a response that can be stringified βœ“ returns a response that can be stringified and then parsed create βœ“ returns an object containing all values βœ“ returns a response that can be stringified βœ“ returns a response that can be stringified and then parsed find βœ“ returns an object containing all values βœ” should load only exist data for all relation types βœ“ returns a response that can be stringified βœ“ returns a response that can be stringified and then parsed [MYSQL] Instance update βœ“ supports transactions (113ms) βœ“ should update fields that are not specified on create (49ms) βœ“ should succeed in updating when values are unchanged (without timestamps) (48ms) βœ“ should update timestamps with milliseconds (50ms) βœ“ should only save passed attributes βœ“ should save attributes affected by setters βœ“ should not set attributes that are not specified by fields (49ms) βœ“ updates attributes in the database βœ“ ignores unknown attributes βœ“ ignores undefined attributes (119ms) βœ“ doesn't update primary keys or timestamps (52ms) βœ“ stores and restores null values (58ms) βœ“ should support logging hooks βœ“ should update attributes added in hooks when default fields are used (53ms) βœ” should load data when additional condition used βœ“ should update attributes changed in hooks when default fields are used (57ms) βœ“ should validate attributes added in hooks when default fields are used (50ms) βœ“ should validate attributes changed in hooks when default fields are used (50ms) [MYSQL] DAO Values set βœ“ doesn't overwrite generated primary keys βœ“ doesn't overwrite defined primary keys βœ“ doesn't set timestamps βœ“ doesn't set underscored timestamps βœ“ doesn't set value if not a dynamic setter or a model attribute βœ“ allows use of sequelize.fn and sequelize.col in date and bool fields (54ms) includes βœ“ should support basic includes βœ“ should support basic includes (with raw: true) get βœ“ should use custom attribute getters in get(key) βœ“ should custom virtual getters in get(key) βœ“ should use custom getters in toJSON βœ“ should work with save (49ms) βœ“ can pass parameters to getters plain βœ“ should return plain values when true clone βœ“ should copy the values changed βœ“ should return false if object was built from database (51ms) βœ“ should return true if previous value is different βœ“ should return false immediately after saving (45ms) βœ“ should be available to a afterUpdate hook (51ms) previous βœ“ should return an object with the previous values βœ“ should return the previous value model json βœ“ should tell me that a column is json βœ“ should use a placeholder for json with insert βœ“ should insert json using a custom field name (45ms) βœ“ should update json using a custom field name (46ms) βœ” should not return any result when related data does not exist leftJoinAndMap βœ“ should be able retrieve json value as object βœ“ should be able to retrieve element of array by index βœ“ should be able to retrieve root level value of an object by key βœ“ should be able to retrieve nested value of an object by path βœ“ should be able to retrieve a row based on the values of the json document βœ“ should be able to query using the nested query language βœ“ should be able to query using dot notation βœ“ should be able to query using dot notation with uppercase name βœ” should load and map selected data when entity used as join argument βœ“ should be able to query array using property accessor βœ“ should be able to store strings βœ“ should be able to store values that require JSON escaping βœ“ should be able to findOrCreate with values that require JSON escaping βœ“ should be able retrieve json value with nested include [MYSQL] Model βœ” should load and map selected data when table name used as join argument βœ“ supports multiple async transactions (2214ms) βœ“ should be possible to use a key named UUID as foreign key (179ms) constructor βœ“ uses the passed dao name as tablename if freezeTableName βœ“ uses the pluralized dao name as tablename unless freezeTableName βœ“ uses checks to make sure dao factory is not leaking on multiple define βœ“ allows us to predefine the ID column with our own specs (50ms) βœ“ throws an error if 2 autoIncrements are passed βœ“ throws an error if a custom model-wide validation is not a function βœ“ throws an error if a custom model-wide validation has the same name as a field βœ“ should allow me to set a default value for createdAt and updatedAt (50ms) βœ“ should allow me to set a function as default value (46ms) βœ“ should throw `TypeError` when value for updatedAt, createdAt, or deletedAt is neither string nor boolean βœ“ should allow me to use `true` as a value for updatedAt, createdAt, and deletedAt fields (58ms) βœ” should load and map selected data when query builder used as join argument βœ“ should allow me to override updatedAt, createdAt, and deletedAt fields (58ms) βœ“ should allow me to disable some of the timestamp fields (52ms) βœ“ returns proper defaultValues after save when setter is set (45ms) βœ“ should work with both paranoid and underscored being true (48ms) βœ“ allows multiple column unique keys to be defined (41ms) βœ“ allows unique on column with field aliases (45ms) βœ“ allows us to customize the error message for unique constraint (53ms) βœ” should load and map selected data when data will given from same entity but with different conditions βœ“ allows us to map the customized error message with unique constraint name (1442ms) - should allow the user to specify indexes in options descending indices (MySQL 8 specific) βœ“ complains about missing support for descending indexes (1433ms) βœ” should load and map selected data when data will given from same property but with different conditions (49ms) innerJoinAndMap βœ“ works fine with InnoDB (1437ms) build βœ“ doesn't create database entries βœ“ fills the objects with default values βœ“ fills the objects with default values βœ“ attaches getter and setter methods from attribute definition βœ“ attaches getter and setter methods from options βœ“ attaches getter and setter methods from options only if not defined in attribute include βœ“ should support basic includes βœ“ should support includes with aliases findOne βœ“ supports the transaction option in the first parameter (117ms) βœ“ should not fail if model is paranoid and where is an empty array (125ms) βœ“ should work if model is paranoid and only operator in where clause is a Symbol (#8406) (129ms) βœ” should load and map selected data when entity used as join argument findOrBuild βœ“ supports transactions (116ms) returns an instance if it already exists βœ“ with a single find field βœ“ with multiple find fields βœ“ builds a new instance with default value. save βœ“ should map the correct fields when saving instance (#10589) (128ms) update βœ“ throws an error if no where clause is given (113ms) βœ“ should map the correct fields when updating instance (#10589) (115ms) βœ“ supports transactions (116ms) βœ“ updates the attributes that we select only without updating createdAt (55ms) βœ“ allows sql logging of updated statements (123ms) βœ“ updates only values that match filter βœ“ throws an error if where has a key with undefined value βœ“ updates only values that match the allowed fields βœ“ updates with casting βœ“ updates with function and column value βœ” should load and map selected data when table name used as join argument βœ“ does not update virtual attributes βœ“ doesn't update attributes that are altered by virtual setters when option is enabled (49ms) βœ“ updates attributes that are altered by virtual setters (50ms) βœ“ should properly set data when individualHooks are true βœ“ sets updatedAt to the current timestamp βœ“ returns the number of affected rows βœ“ does not update soft deleted records when model is paranoid (164ms) βœ“ updates soft deleted records when paranoid is overridden (161ms) βœ“ calls update hook for soft deleted objects (127ms) βœ“ supports limit clause destroy βœ“ `truncate` method should clear the table (156ms) βœ“ `truncate` option should clear the table (158ms) βœ“ `truncate` option returns a number (164ms) βœ“ throws an error if no where clause is given (110ms) βœ“ deletes all instances when given an empty where object (116ms) βœ” should load and map selected data when query builder used as join argument βœ“ throws an error if where has a key with undefined value (117ms) βœ“ supports transactions (115ms) βœ“ deletes values that match filter βœ“ works without a primary key (51ms) βœ“ supports .field (53ms) βœ“ sets deletedAt to the current timestamp if paranoid is true (54ms) βœ“ does not set deletedAt for previously destroyed instances if paranoid is true (56ms) βœ“ should include deleted associated records if include has paranoid marked as false (182ms) βœ“ should delete a paranoid record if I set force to true (63ms) βœ“ returns the number of affected rows βœ” should load and map selected data when data will given from same entity but with different conditions βœ“ supports table schema/prefix (131ms) βœ“ should work if model is paranoid and only operator in where clause is a Symbol (116ms) can't find records marked as deleted with paranoid being true βœ“ with the DAOFactory (55ms) can find paranoid records if paranoid is marked as false in query βœ“ with the DAOFactory (56ms) restore βœ“ rejects with an error if the model is not paranoid βœ“ restores a previously deleted model (54ms) equals βœ“ correctly determines equality of objects βœ“ correctly determines equality with multiple primary keys (47ms) equalsOneOf βœ“ determines equality if one is matching βœ“ doesn't determine equality if none is matching count βœ“ supports transactions (117ms) βœ“ counts all created objects βœ“ returns multiple rows when using group βœ“ allows sql logging βœ“ filters object βœ” should load and map selected data when data will given from same property but with different conditions (52ms) βœ“ supports distinct option (115ms) aggregate Executing (default): SELECT `id` AS `id2`, count(`id`) AS `count` FROM `Users` AS `User` GROUP BY `id2`; (node:762) [SEQUELIZE0002] DeprecationWarning: The logging-option should be either a function or false. Default: console.log βœ“ allows grouping by aliased attribute options sent to aggregate βœ“ modifies option "limit" by setting it to null βœ“ modifies option "offset" by setting it to null βœ“ modifies option "order" by setting it to null min βœ“ supports transactions (127ms) βœ“ returns the correct value βœ“ allows sql logging βœ“ should allow decimals βœ“ should allow strings βœ“ should allow dates βœ“ should work with fields named as an SQL reserved keyword βœ” should not return any result when related data does not exist query builder > locking max βœ“ supports transactions (112ms) βœ“ returns the correct value βœ“ allows sql logging βœ“ should allow decimals βœ“ should allow strings βœ“ should allow dates βœ” should not attach pessimistic read lock statement on query if locking is not used βœ“ should work with fields named as an SQL reserved keyword sum βœ“ should work in the simplest case βœ“ should work with fields named as an SQL reserved keyword βœ“ should allow decimals in sum βœ“ should accept a where clause βœ“ should accept a where clause with custom fields βœ” should throw error if pessimistic lock used without transaction βœ“ allows sql logging schematic support βœ“ should be able to drop with schemas βœ“ should be able to list schemas βœ“ should take schemaDelimiter into account if applicable (96ms) βœ“ should describeTable using the default schema settings (90ms) βœ“ should be able to reference a table with a schema set (102ms) βœ“ should be able to create and update records under any valid schematic (56ms) βœ” should not throw error if pessimistic lock used with transaction references βœ“ uses an existing dao factory and references the author table (64ms) βœ“ uses a table name as a string and references the author table (58ms) - emits an error event as the referenced table name is invalid βœ“ works with comments (340ms) blob buffers βœ“ should be able to take a buffer as parameter to a BLOB field βœ“ should return a buffer when fetching a blob βœ“ should work when the database returns null strings βœ“ should be able to take a string as parameter to a BLOB field βœ“ should return a buffer when fetching a BLOB, even when the BLOB was inserted as a string paranoid is true and where is an array βœ“ should not fail when array contains Sequelize.or / and βœ“ should fail when array contains strings βœ“ should not fail with an include βœ” should throw error if for no key update lock used without transaction βœ“ should not overwrite a specified deletedAt by setting paranoid: false βœ“ should not overwrite a specified deletedAt (complex query) by setting paranoid: false Unique βœ“ should set unique when unique is true (44ms) βœ“ should not set unique when unique is false (49ms) βœ“ should not set unique when unique is unset (50ms) bulkCreate βœ“ errors - should return array of errors if validate and individualHooks are true (113ms) βœ“ should not use setter when renaming fields in dataValues (130ms) [MYSQL] Model attributes set βœ“ should only be called once when used on a join model called with an association getter (161ms) βœ“ allows for an attribute to be called "toString" (53ms) βœ” should not throw error if for no key update lock used with transaction βœ“ allows for an attribute to be called "toString" with associations (119ms) quote βœ“ allows for an attribute with dots (45ms) [MYSQL] Model attributes field βœ“ increment should work (59ms) βœ“ decrement should work (55ms) βœ“ sum should work (52ms) βœ“ should create, fetch and update with alternative field names from a simple model βœ” should throw error if for key share lock used without transaction βœ“ should bulk update (550ms) βœ“ should not contain the field properties after create (47ms) βœ“ should make the aliased auto incremented primary key available after create βœ“ should work with where on includes for find βœ” should not throw error if for key share lock used with transaction βœ“ should work with where on includes for findAll βœ“ should work with increment βœ“ should work with a simple where βœ“ should work with a where or βœ” should throw error if pessimistic_partial_write lock used without transaction βœ“ should work with bulkCreate and findAll βœ“ should support renaming of sequelize method fields (511ms) βœ” should not throw error if pessimistic_partial_write lock used with transaction βœ“ should sync foreign keys with custom field names (476ms) βœ“ should find the value of an attribute with a custom field name βœ“ field names that are the same as property names should create, update, and read correctly βœ“ should work with a belongsTo association getter βœ“ should work with paranoid instance.destroy() (116ms) βœ“ should work with paranoid Model.destroy() (118ms) βœ” should throw error if pessimistic_write_or_fail lock used without transaction βœ“ should work with `belongsToMany` association `count` βœ“ should work with `hasMany` association `count` primaryKey βœ“ should support instance.destroy() βœ” should not throw error if pessimistic_write_or_fail lock used with transaction - should attach pessimistic read lock statement on query if locking enabled βœ“ should support Model.destroy() in combination with allowNull βœ“ sets the column to not allow null field and attribute name is the same βœ“ bulkCreate should work βœ“ find with where should work βœ” should attach dirty read lock statement on query if locking enabled βœ“ reload should work βœ“ save should work [MYSQL] Model attributes types VIRTUAL βœ“ should not be ignored in dataValues get βœ“ should be ignored in table creation βœ“ should be ignored in find, findAll and includes βœ” should not attach pessimistic write lock statement on query if locking is not used βœ“ should allow me to store selected values (553ms) βœ“ should be ignored in create and update βœ“ should be ignored in bulkCreate and and bulkUpdate βœ“ should be able to exclude with attributes βœ“ should be able to include model with virtual attributes [MYSQL] Model bulkCreate βœ“ supports transactions (119ms) βœ” should attach pessimistic write lock statement on query if locking enabled βœ“ should not alter options (108ms) βœ“ should be able to set createdAt and updatedAt if using silent: true (121ms) βœ“ should not fail on validate: true and individualHooks: true (111ms) βœ“ should not map instance dataValues to fields with individualHooks: true (118ms) βœ“ should not insert NULL for unused fields (46ms) βœ“ properly handles disparate field lists βœ” should not attach for no key update lock statement on query if locking is not used βœ“ inserts multiple values respecting the white list βœ“ should store all values if no whitelist is specified βœ“ should set isNewRecord = false βœ“ saves data with single quote βœ“ saves data with double quote βœ“ saves stringified JSON data βœ“ properly handles a model with a length column (47ms) βœ” should attach for no key update lock statement on query if locking enabled βœ“ stores the current date in createdAt βœ“ emits an error when validate is set to true (41ms) βœ“ doesn't emit an error when validate is set to true but our selectedValues are fine (41ms) βœ“ should allow blank arrays (return immediately) βœ“ should allow blank creates (with timestamps: false) βœ“ should allow autoincremented attributes to be set (40ms) βœ“ should support schemas (238ms) βœ“ should support the ignoreDuplicates option βœ“ should properly map field names to attribute names (38ms) updateOnDuplicate βœ“ should support the updateOnDuplicate option βœ” should not attach for key share lock statement on query if locking is not used βœ“ should reject for non array updateOnDuplicate option βœ“ should reject for empty array updateOnDuplicate option should support the updateOnDuplicate option with primary keys βœ“ when the primary key column names and model field names are the same βœ“ when the primary key column names and model field names are different βœ“ when the primary key column names and model field names are different and have unique constraints βœ“ when the composite primary key column names and model field names are different (38ms) βœ“ when the primary key column names and model field names are different and have composite unique constraints βœ” should attach for key share lock statement on query if locking enabled βœ“ [#12516] when the primary key column names and model field names are different and have composite unique index constraints (1401ms) enums βœ“ correctly restores enum values (40ms) handles auto increment values βœ“ should return auto increment primary key values βœ“ should return supplied values on primary keys (95ms) βœ“ should return supplied values on primary keys when some instances already exists (98ms) virtual attribute βœ“ should validate (93ms) βœ” should not attach pessimistic_partial_write lock statement on query if locking is not used - should attach pessimistic_partial_write lock statement on query if locking enabled βœ“ should not validate (90ms) [MYSQL] Model bulkCreate include βœ“ should bulkCreate data for BelongsTo relations (100ms) βœ“ should bulkCreate data for BelongsTo relations with no nullable FK (94ms) βœ“ should bulkCreate data for BelongsTo relations with alias (96ms) βœ“ should bulkCreate data for HasMany relations (104ms) βœ“ should bulkCreate data for HasMany relations with alias (95ms) βœ“ should bulkCreate data for HasOne relations (95ms) βœ“ should bulkCreate data for HasOne relations with alias (95ms) βœ“ should bulkCreate data for BelongsToMany relations (145ms) βœ“ should bulkCreate data for polymorphic BelongsToMany relations (139ms) βœ“ should bulkCreate data for BelongsToMany relations with alias (147ms) [MYSQL] Model count βœ“ should count rows βœ“ should support include βœ“ should count groups correctly and return attributes βœ“ should not return NaN βœ” should not attach pessimistic_write_or_fail lock statement on query if locking is not used βœ“ should be able to specify column for COUNT() βœ“ should be able to specify NO column for COUNT() with DISTINCT βœ“ should be able to use where clause on included models βœ“ should be able to specify column for COUNT() with includes βœ“ should work correctly with include and whichever raw option (59ms) [MYSQL] Model βœ“ should return autoIncrement primary key (create) (38ms) βœ“ should support logging findOrCreate βœ“ supports transactions βœ“ supports more than one models per transaction βœ“ should error correctly when defaults contain a unique key (110ms) βœ” should attach pessimistic_write_or_fail lock statement on query if locking enabled (sequelize) Warning: Unknown attributes (foo,bar) passed to defaults option of findOrCreate βœ“ should error correctly when defaults contain a unique key and a non-existent field (93ms) βœ“ should error correctly when defaults contain a unique key and the where clause is complex (91ms) βœ“ should work with empty uuid primary key in where (90ms) βœ“ should not deadlock with no existing entries and no outer transaction (166ms) βœ“ should not deadlock with existing entries and no outer transaction (214ms) βœ“ should not deadlock with concurrency duplicate entries and no outer transaction (186ms) βœ“ should support special characters in defaults (93ms) βœ“ should support bools in defaults (91ms) βœ“ returns instance if already existent. Single find field. βœ“ Returns instance if already existent. Multiple find fields. βœ“ does not include exception catcher in response βœ“ creates new instance with default value. βœ” should throw error if optimistic lock used with getMany method βœ“ supports .or() (only using default values) βœ“ should ignore option returning βœ“ should release transaction when meeting errors several concurrent calls βœ“ works with a transaction βœ“ should not fail silently with concurrency higher than pool, a unique constraint and a create hook resulting in mismatched values (132ms) βœ“ should error correctly when defaults contain a unique key without a transaction (100ms) βœ“ works without a transaction findCreateFind βœ“ [Flaky] should work with multiple concurrent calls βœ“ should work with multiple concurrent calls within a transaction create βœ” should throw error if optimistic lock used with getCount method βœ“ works with multiple non-integer primary keys with a default value (278ms) βœ“ should return an error for a unique constraint error (295ms) βœ“ works without any primary key (321ms) βœ“ should be able to set createdAt and updatedAt if using silent: true (95ms) βœ“ works with custom timestamps with a default value (302ms) βœ“ works with custom timestamps and underscored (278ms) βœ“ supports transactions βœ“ is possible to use casting when creating an instance βœ“ is possible to use casting multiple times mixed in with other utilities βœ” should throw error if optimistic lock used with getManyAndCount method βœ“ is possible to just use .literal() to bypass escaping βœ“ is possible to use funtions when creating an instance βœ“ should escape $ in sequelize functions arguments βœ“ should escape multiple instances of $ in sequelize functions arguments βœ“ should work with a non-id named uuid primary key columns (337ms) βœ“ is possible to use functions as default values βœ“ doesn't allow duplicated records with unique:true (40ms) βœ“ raises an error if created object breaks definition constraints (38ms) βœ“ raises an error if created object breaks definition constraints (41ms) βœ” should throw error if optimistic lock used with getRawMany method βœ“ raises an error if saving an empty string into a column allowing null or URL (46ms) βœ“ raises an error if you mess up the datatype βœ“ sets a 64 bit int in bigint (39ms) βœ“ sets auto increment fields (48ms) βœ“ allows the usage of options as attribute (41ms) βœ“ allows sql logging (42ms) βœ“ should only store the values passed in the whitelist βœ“ should store all values if no whitelist is specified βœ“ can omit autoincremental columns (69ms) βœ“ saves data with single quote βœ“ saves data with double quote βœ“ saves stringified JSON data βœ” should throw error if optimistic lock used with getRawOne method βœ“ stores the current date in createdAt βœ“ allows setting custom IDs βœ“ should allow blank creates (with timestamps: false) (38ms) βœ“ should allow truly blank creates (44ms) βœ“ should only set passed fields (295ms) βœ“ Works even when SQL query has a values of transaction keywords such as BEGIN TRANSACTION (41ms) enums βœ“ correctly restores enum values (48ms) βœ“ allows null values (47ms) when defined via { field: Sequelize.ENUM } βœ“ allows values passed as parameters (42ms) βœ“ allows values passed as an array (40ms) βœ” should not throw error if optimistic lock used with getOne method - should throw error if entity does not have version and update date columns - should throw error if actual version does not equal expected version - should not throw error if actual version and expected versions are equal - should throw error if actual updated date does not equal expected updated date - should not throw error if actual updated date and expected updated date are equal - should work if both version and update date columns applied when defined via { field: { type: Sequelize.ENUM } } βœ“ allows values passed as parameters (48ms) βœ“ allows values passed as an array (39ms) can safely sync multiple times βœ“ through the factory (135ms) βœ“ through sequelize (732ms) [MYSQL] Model create include βœ“ should create data for BelongsTo relations (104ms) βœ“ should create data for BelongsTo relations with no nullable FK (97ms) βœ“ should create data for BelongsTo relations with alias (102ms) βœ” should throw error if pessimistic locking not supported by given driver βœ“ should create data for HasMany relations (111ms) βœ“ should create data for HasMany relations with alias (128ms) βœ“ should create data for HasOne relations (97ms) βœ“ should create data for HasOne relations with alias (97ms) βœ“ should create data for BelongsToMany relations (152ms) βœ“ should create data for polymorphic BelongsToMany relations (147ms) βœ“ should create data for BelongsToMany relations with alias (153ms) [MYSQL] Model βœ“ should support logging findAll βœ“ supports transactions (104ms) βœ“ should not crash on an empty where array βœ“ should throw on an attempt to fetch no attributes βœ“ should not throw if overall attributes are nonempty (86ms) special where conditions/smartWhere object βœ“ should be able to find rows where attribute is in a list of values βœ“ should not break when trying to find rows using an array of primary keys βœ“ should not break when using smart syntax on binary fields βœ“ should be able to find a row using like βœ“ should be able to find a row using not like βœ“ should be able to find a row between a certain date using the between shortcut βœ“ should be able to find a row not between a certain integer using the not between shortcut βœ“ should be able to handle false/true values just fine... βœ“ should be able to handle false/true values through associations as well... (164ms) βœ” should throw error if for no key update locking not supported by given driver βœ“ should be able to handle binary values through associations as well... (159ms) βœ“ should be able to find a row between a certain date βœ“ should be able to find a row between a certain date and an additional where clause βœ“ should be able to find a row not between a certain integer βœ“ should be able to find a row using not between and between logic βœ“ should be able to find a row using not between and between logic with dates βœ“ should be able to find a row using greater than or equal to logic with dates βœ“ should be able to find a row using greater than or equal to logic with moment dates βœ“ should be able to find a row using greater than or equal to βœ“ should be able to find a row using greater than βœ“ should be able to find a row using lesser than or equal to βœ“ should be able to find a row using lesser than βœ“ should have no problem finding a row using lesser and greater than βœ“ should be able to find a row using not equal to logic βœ“ should be able to find multiple users with any of the special where logic properties eager loading βœ“ should not ignore where condition with empty includes, #8771 belongsTo βœ“ throws an error about unexpected input if include contains a non-object βœ“ throws an error if included DaoFactory is not associated βœ“ returns the associated worker via task.worker βœ“ returns the associated worker via task.worker, using limit and sort hasOne βœ“ throws an error if included DaoFactory is not associated βœ” should throw error if for key share locking not supported by given driver βœ“ returns the associated task via worker.task hasOne with alias βœ“ throws an error if included DaoFactory is not referenced by alias βœ“ throws an error if alias is not associated βœ“ returns the associated task via worker.task βœ“ returns the associated task via worker.task when daoFactory is aliased with model hasMany βœ“ throws an error if included DaoFactory is not associated βœ“ returns the associated tasks via worker.tasks βœ“ supports sorting on renamed sub-query attribute (134ms) βœ“ supports sorting DESC on renamed sub-query attribute (125ms) βœ“ supports sorting on multiple renamed sub-query attributes (131ms) hasMany with alias βœ“ throws an error if included DaoFactory is not referenced by alias βœ“ throws an error if alias is not associated βœ” should only specify locked tables in FOR UPDATE OF clause if argument is given βœ“ returns the associated task via worker.task βœ“ returns the associated task via worker.task when daoFactory is aliased with model queryOptions βœ“ should return a DAO when queryOptions are not set βœ“ should return a DAO when raw is false βœ“ should return raw data when raw is true include all βœ“ includes all associations βœ“ includes specific type of association βœ“ utilises specified attributes βœ“ is over-ruled by specified include βœ” should not allow empty array for lockTables βœ“ includes all nested associations properly handles attributes:[] cases βœ“ N:M with ignoring include.attributes only βœ“ N:M with ignoring through.attributes only βœ“ N:M with ignoring include.attributes but having through.attributes order by eager loaded tables HasMany βœ“ sorts simply βœ“ sorts by 1st degree association βœ“ sorts simply and by 1st degree association with limit where 1st degree associated instances returned for second one and not the first βœ” should throw error when specifying a table that is not part of the query βœ“ sorts by 2nd degree association βœ“ sorts by 2nd degree association with alias βœ“ sorts by 2nd degree association with alias while using limit ManyToMany βœ“ sorts by 1st degree association βœ“ sorts by 1st degree association while using limit βœ“ sorts by through table attribute normal findAll βœ“ finds all entries βœ“ can also handle object notation βœ“ sorts the results via id in ascending order βœ“ sorts the results via id in descending order βœ“ sorts the results via a date column βœ“ handles offset and limit βœ“ should allow us to find IDs using capital letters βœ“ should be possible to order by sequelize.col() βœ“ should pull in dependent fields for a VIRTUAL βœ“ should pull in dependent fields for a VIRTUAL in include (129ms) βœ” should allow on a left join βœ“ should throw for undefined where parameters findAndCountAll βœ“ supports transactions (88ms) βœ“ handles where clause {only} βœ“ handles where clause with ordering {only} βœ“ handles offset βœ“ handles limit βœ“ handles offset and limit βœ“ handles offset with includes (138ms) βœ“ handles attributes all βœ“ supports transactions (80ms) βœ“ should return all users rejectOnEmpty mode βœ“ works from model options βœ“ throws custom error with initialized βœ“ throws custom error with instance [MYSQL] Model findAll group βœ“ should correctly group with attributes, #3009 (83ms) βœ“ should not add primary key when grouping using a belongsTo association (88ms) [MYSQL] Model findAll groupedLimit on: belongsToMany βœ“ maps attributes from a grouped limit to models βœ“ maps attributes from a grouped limit to models with include βœ” should allow using lockTables on all types of locking βœ“ [Flaky] works with computed order βœ“ works with multiple orders βœ“ works with paranoid junction models on: hasMany βœ“ Applies limit and order correctly [MYSQL] Model findAll order Sequelize.literal() βœ“ should work with order: literal() βœ“ should work with order: [literal()] βœ“ should work with order: [[literal()]] injections βœ“ should not throw on a literal βœ“ should not throw with include when last order argument is a field [MYSQL] Model findAll separate with limit βœ“ should not throw syntax error (union) (151ms) [MYSQL] Model findOne βœ“ supports transactions (86ms) βœ“ should support logging general / basic function βœ“ allows bit fields as booleans βœ“ treats questionmarks in an array βœ” should allow locking a relation of a relation βœ“ doesn't throw an error when entering in a non integer value for a specified primary field βœ“ returns a single dao βœ“ returns a single dao given a string id βœ“ should make aliased attributes available βœ“ should fail with meaningful error message on invalid attributes definition βœ“ should not try to convert boolean values if they are not selected βœ“ finds a specific user via where option βœ“ doesn't find a user if conditions are not matching βœ“ allows sql logging βœ“ ignores passed limit option βœ“ finds entries via primary keys βœ“ finds entries via a string primary key called id βœ“ finds entries via a bigint primary key called id βœ“ always honors ZERO as primary key βœ“ should allow us to find IDs using capital letters eager loading belongsTo βœ“ returns the private and public ip (84ms) βœ” pessimistic_partial_write and skip_locked works βœ“ eager loads with non-id primary keys (220ms) βœ“ getting parent data in many to one relationship (188ms) βœ“ allows mulitple assocations of the same model with different alias (172ms) generic βœ“ throws an error about unexpected input if include contains a non-object βœ“ throws an error if included DaoFactory is not associated βœ“ returns the associated worker via task.worker (179ms) hasOne βœ“ throws an error if included DaoFactory is not associated βœ“ returns the associated task via worker.task βœ“ eager loads with non-id primary keys (345ms) hasOne with alias βœ“ throws an error if included DaoFactory is not referenced by alias alias βœ“ throws an error indicating an incorrect alias was entered if an association and alias exist but the alias doesn't match βœ“ returns the associated task via worker.task βœ” pessimistic_write_or_fail and skip_locked ignores skip_locked βœ“ returns the associated task via worker.task when daoFactory is aliased with model βœ“ allows mulitple assocations of the same model with different alias (273ms) hasMany βœ“ throws an error if included DaoFactory is not associated βœ“ returns the associated tasks via worker.tasks βœ“ including two has many relations should not result in duplicate values (379ms) βœ“ eager loads with non-id primary keys (376ms) hasMany with alias βœ“ throws an error if included DaoFactory is not referenced by alias alias βœ“ throws an error indicating an incorrect alias was entered if an association and alias exist but the alias doesn't match βœ” skip_locked with "pessimistic_read" βœ“ returns the associated task via worker.task βœ“ returns the associated task via worker.task when daoFactory is aliased with model βœ“ allows mulitple assocations of the same model with different alias (248ms) hasMany (N:M) with alias βœ“ returns the associated models when using through as string and alias (184ms) βœ“ returns the associated models when using through as model and alias (191ms) queryOptions βœ“ should return a DAO when queryOptions are not set βœ“ should return a DAO when raw is false βœ“ should return raw data when raw is true rejectOnEmpty mode βœ“ throws error when record not found by findOne βœ“ throws error when record not found by findByPk βœ“ throws error when record not found by find βœ“ works from model options βœ“ override model options βœ“ resolve null when disabled [MYSQL] Model findOrBuild βœ“ initialize with includes [MYSQL] Model GEOMETRY - works with aliases fields - should create a geometry object - should update a geometry object - works with crs field GEOMETRY(POINT) - should create a geometry object - should update a geometry object - works with crs field GEOMETRY(LINESTRING) - should create a geometry object - should update a geometry object - works with crs field GEOMETRY(POLYGON) - should create a geometry object - works with crs field - should update a geometry object sql injection attacks - should properly escape the single quotes - should properly escape the single quotes in coordinates [MYSQL] Model increment βœ“ supports where conditions βœ“ uses correct column names for where conditions βœ“ should still work right with other concurrent increments βœ” nowait with "pessimistic_read" βœ“ with array βœ“ with single field βœ“ with single field and no value βœ“ with key value pair βœ“ should still work right with other concurrent updates βœ“ with timestamps set to true βœ“ with timestamps set to true and options.silent set to true βœ“ should work with scopes (99ms) βœ“ should not care for attributes in the instance scope βœ“ should not care for exclude-attributes in the instance scope βœ“ should not care for include-attributes in the instance scope decrement βœ“ supports where conditions βœ“ uses correct column names for where conditions βœ“ should still work right with other concurrent increments βœ“ with array βœ“ with single field βœ“ with single field and no value βœ“ with key value pair βœ“ should still work right with other concurrent updates βœ“ with timestamps set to true βœ“ with timestamps set to true and options.silent set to true βœ“ should work with scopes (92ms) βœ“ should not care for attributes in the instance scope βœ“ should not care for exclude-attributes in the instance scope βœ“ should not care for include-attributes in the instance scope [MYSQL] Model JSON βœ“ findOrCreate supports transactions, json and locks create βœ“ should create an instance with JSON data update βœ“ should update with JSON column (dot notation) βœ“ should update with JSON column (JSON notation) βœ“ should update an instance with JSON data find βœ“ should be possible to query a nested value βœ“ should be possible to query dates with array operators βœ“ should be possible to query a boolean with array operators βœ“ should be possible to query a nested integer value βœ“ should be possible to query a nested null value βœ“ should be possible to query for nested fields with hyphens/dashes, #8718 βœ“ should be possible to query multiple nested values βœ“ should be possible to query a nested value and order results destroy βœ“ should be possible to destroy with where sql injection attacks βœ“ should properly escape the single quotes βœ” skip_locked with "pessimistic_read" check getOne βœ“ should properly escape path keys βœ“ should properly escape path keys with sequelize.json βœ“ should properly escape the single quotes in array βœ“ should be possible to find with properly escaped select query βœ“ should query an instance with JSONB data and order while trying to inject [MYSQL] Model max βœ“ type A to C should exist βœ“ type D should not exist [MYSQL] Model optimistic locking βœ“ should increment the version on save βœ“ should increment the version on update βœ“ prevents stale instances from being saved βœ“ increment() also increments the version βœ“ decrement() also increments the version [MYSQL] Model paranoid βœ“ should be able to soft delete with timestamps (45ms) βœ“ should be able to soft delete without timestamps (43ms) JSON βœ“ should soft delete with JSON condition [MYSQL] Model scope βœ“ should be able to merge attributes as array βœ“ should work with Symbol operators βœ“ should keep symbols after default assignment βœ“ should not throw error with sequelize.where [MYSQL] Model scope aggregate βœ“ should apply defaultScope βœ“ should be able to override default scope βœ“ should be able to unscope βœ“ should be able to apply other scopes βœ“ should be able to merge scopes with where βœ“ should be able to use where on include [MYSQL] Model scope associations include βœ“ should scope columns properly βœ” skip_locked with "for_key_share" check getOne βœ“ should apply default scope when including an associations βœ“ should apply default scope when including a model βœ“ should be able to include a scoped model get it should be able to unscope βœ“ hasMany βœ“ hasOne βœ“ belongsTo βœ“ belongsToMany βœ” skip_locked with "pessimistic_read" fails on early versions of MySQL query builder > not βœ” should put negation in the SQL with one condition βœ” should put negation in the SQL with two condition βœ” should put negation correctly into WHERE expression with one condition βœ” should put negation correctly into WHERE expression with two conditions query builder > order-by it should apply default scope βœ“ hasMany βœ” should be always in right order(default order) βœ” should be always in right order(custom order) βœ” should be always in right order(custom order) βœ“ hasOne βœ” should be always in right order(custom order) βœ” should be able to order by sql statement query builder > parameters βœ” should replace basic parameters when executing βœ” should prevent invalid characters from being used as identifiers βœ” should allow periods in parameters query builder > load-relation-count-and-map > many-to-many βœ“ belongsTo βœ“ belongsToMany βœ” should load relation count on owner side it should be able to apply another scope βœ“ hasMany βœ“ hasOne βœ” should load relation count on owner side with limitation βœ“ belongsTo βœ“ belongsToMany βœ” should load relation count on owner side with additional conditions (50ms) scope with includes βœ“ should scope columns properly βœ“ should apply scope conditions with different format βœ” should load relation count on both sides of relation βœ“ should not throw error (598ms) with find options βœ” should load relation count on inverse side βœ“ should merge includes correctly (597ms) scope with options βœ” should load relation count on inverse side with limitation βœ“ should return correct object included foreign_key (564ms) βœ” should load relation count on inverse side with additional conditions query builder > load-relation-count-and-map > one-to-many βœ“ should return correct object included foreign_key with defaultScope (543ms) βœ“ should not throw error (597ms) [MYSQL] Model scope count βœ“ should apply defaultScope βœ“ should be able to override default scope βœ“ should be able to unscope βœ“ should be able to apply other scopes βœ“ should be able to merge scopes with where βœ“ should be able to merge scopes with where on aliased fields βœ“ should ignore the order option if it is found within the scope βœ“ should be able to use where on include βœ” should load relation count βœ“ should be able to use include with function scope βœ“ should be able to use include with function scope and string association [MYSQL] Model scope destroy βœ“ should apply defaultScope βœ“ should be able to override default scope βœ“ should be able to unscope destroy βœ“ should be able to apply other scopes βœ“ should be able to merge scopes with where βœ“ should work with empty where [MYSQL] Model scopes βœ“ should be able use where in scope βœ“ should be able to combine scope and findAll where clauses βœ“ should be able to use a defaultScope if declared βœ“ should be able to handle $and in scopes βœ“ should have no problem performing findOrCreate βœ“ should work when included with default scope should not overwrite βœ“ default scope with values from previous finds βœ“ other scopes with values from previous finds scope in associations βœ“ should work when association with a virtual column queried with default scope (101ms) [MYSQL] Model scope findAndCountAll βœ” should load relation count on nested relations βœ“ should apply defaultScope βœ“ should be able to override default scope βœ“ should be able to unscope βœ“ should be able to apply other scopes βœ“ should be able to merge scopes with where βœ“ should ignore the order option if it is found within the scope [MYSQL] Model scope simple merge βœ“ should merge simple scopes correctly complex merge βœ“ should merge complex scopes correctly regardless of their order (84ms) βœ“ should merge complex scopes with findAll options correctly regardless of their order (102ms) βœ“ should merge complex scopes with findOne options correctly regardless of their order (75ms) [MYSQL] Model scope update βœ“ should apply defaultScope βœ“ should be able to override default scope βœ“ should be able to unscope destroy βœ“ should be able to apply other scopes βœ“ should be able to merge scopes with where βœ“ should work with empty where [MYSQL] Model sum βœ“ should sum without rows βœ“ should sum when is 0 βœ“ should sum [MYSQL] Model sync βœ“ should remove a column if it exists in the databases schema but not the model (281ms) βœ” should load relation count with additional conditions query builder > relation-id > many-to-many > basic-functionality βœ“ should add a column if it exists in the model but not the database (284ms) βœ“ should not remove columns if drop is set to false in alter configuration (40ms) βœ“ should remove columns if drop is set to true in alter configuration (209ms) βœ“ should alter a column using the correct column name (#9515) (204ms) βœ“ should change a column if it exists in the model but is different in the database (242ms) βœ“ should not alter table if data type does not change (173ms) βœ“ should properly create composite index without affecting individual fields (1435ms) βœ” should not load ids when RelationId decorator is not specified βœ“ should properly create composite index that fails on constraint violation (1427ms) βœ” should load ids when loadRelationIdAndMap used on ManyToMany owner side βœ“ supports creating tables with cyclic associations (3084ms) βœ“ supports creating two identically named tables in different schemas (77ms) with { alter: true } βœ“ should properly alter tables when there are foreign keys (507ms) βœ“ does not recreate existing enums (#7649) (338ms) indexes βœ“ should create only one unique index for unique:true column βœ“ should create only one unique index for unique:true columns (38ms) βœ” should load ids when loadRelationIdAndMap used on ManyToMany owner side without inverse side βœ“ should create only one unique index for unique:true columns taking care of options.indexes (1413ms) βœ“ should create only one unique index for unique:name column βœ“ should create only one unique index for unique:name columns with alter:true βœ” should load ids when loadRelationIdAndMap used on ManyToMany inverse side βœ“ should not duplicate named indexes after multiple sync calls (6055ms) βœ” should load ids when loadRelationIdAndMap used on ManyToMany owning side with additional condition βœ” should load ids when loadRelationIdAndMap used on ManyToMany owning side without inverse side and with additional condition βœ“ should not duplicate unnamed indexes after multiple sync calls (6063ms) [MYSQL] Model update βœ“ should only update the passed fields βœ“ changed should be false after reload βœ“ should ignore undefined values without throwing not null validation βœ“ should only update one row skips update query βœ“ if no data to update βœ“ skips when timestamps disabled (41ms) [MYSQL] Model upsert βœ“ works with upsert on id βœ“ works with upsert on a composite key βœ“ should work with UUIDs wth default values (106ms) βœ“ works with upsert on a composite primary key (107ms) βœ“ supports validations βœ“ supports skipping validations (90ms) βœ“ works with BLOBs βœ“ works with .field βœ” should load ids when loadRelationIdAndMap used on ManyToMany inverse side with additional condition βœ“ works with primary key using .field βœ“ works with database functions βœ“ does not overwrite createdAt time on update βœ“ does not overwrite createdAt when supplied as an explicit insert value when using fields βœ“ falls back to a noop if no update values are found in the upsert data (100ms) βœ“ does not update using default values βœ“ does not update when setting current values βœ“ works when two separate uniqueKeys are passed (101ms) βœ” should load ids when loadRelationIdAndMap used on nested relation βœ“ works when indexes are created via indexes array (2888ms) βœ“ works when composite indexes are created via indexes array (1486ms) [MYSQL] Operators REGEXP case sensitive βœ“ should work with a regexp where βœ“ should work with a not regexp where βœ“ should properly escape regular expressions [MYSQL] Pooling network / connection errors βœ“ should obtain new connection when old connection is abruptly closed βœ“ should obtain new connection when released connection dies inside pool idle βœ“ should maintain connection within idle range (95ms) βœ“ [MSSQL Flaky] should get new connection beyond idle range (115ms) acquire βœ“ should reject with ConnectionAcquireTimeoutError when unable to acquire connection βœ“ should reject with ConnectionAcquireTimeoutError when unable to acquire connection for transaction [MYSQL] QueryInterface dropAllSchema βœ“ should drop all schema showAllTables βœ“ should not contain views (124ms) βœ“ should not show tables in other databases (156ms) βœ“ should show all tables in all databases (172ms) renameTable βœ“ should rename table (81ms) dropAllTables βœ“ should drop all tables (101ms) βœ“ should be able to skip given tables indexes βœ” should load ids when loadRelationIdAndMap used on nested relation with additional conditions βœ“ adds, reads and removes an index to the table (1450ms) βœ“ works with schemas (1409ms) βœ” should not load ids of nested relations when loadRelationIdAndMap used on inherit relation and parent relation was not found query builder > relation-id > many-to-many > embedded βœ“ does not fail on reserved keywords (1370ms) renameColumn βœ“ rename a simple column (74ms) βœ“ works with schemas (74ms) βœ“ rename a column non-null without default value (75ms) βœ“ rename a boolean column non-null without default value (72ms) - renames a column primary key autoIncrement column βœ” should load ids when loadRelationIdAndMap used on embedded and nested embedded tables (38ms) query builder > relation-id > many-to-many > embedded-with-multiple-pk owner side βœ“ shows a reasonable error message when column is missing (38ms) addColumn - should be able to add a foreign key reference βœ“ addColumn expected error βœ“ should work with schemas (105ms) βœ“ should work with enums (1) (65ms) βœ“ should work with enums (2) (68ms) describeForeignKeys βœ“ should get a list of foreign keys for the table βœ“ should get a list of foreign key references details for the table constraints unique βœ” should load ids when loadRelationIdAndMap used on embedded table and each table have primary key (44ms) inverse side βœ” should load ids when loadRelationIdAndMap used on embedded table and each table have primary key (45ms) query builder > relation-id > many-to-many > multiple-pk owner side βœ“ should add, read & remove unique constraint (1458ms) βœ” should load ids when both entities have multiple primary keys βœ“ should add a constraint after another (2918ms) primary key - should add, read & remove primary key constraint foreign key - should add, read & remove foreign key constraint unknown constraint βœ“ should throw non existent constraints as UnknownConstraintError [MYSQL] QueryInterface changeColumn βœ“ should support schemas (141ms) βœ” should load ids when only one entity have multiple primary key βœ“ should change columns (159ms) βœ“ should work with enums (case 1) (142ms) βœ“ should work with enums (case 2) (165ms) βœ“ should work with enums with schemas (147ms) should support foreign keys βœ” should load ids when both entities have multiple primary keys and additional condition used βœ“ able to change column to foreign key (1446ms) βœ” should load ids when both entities have multiple primary keys and related entity does not have inverse side βœ“ able to change column property without affecting other properties (1491ms) βœ“ should change the comment of column [MYSQL] QueryInterface createTable βœ“ should create a auto increment primary key βœ“ should create unique constraint with uniqueKeys (43ms) βœ“ should work with schemas (42ms) enums βœ“ should work with enums (1) βœ“ should work with enums (2) βœ“ should work with enums (3) βœ“ should work with enums (4) (38ms) βœ“ should work with enums (5) (39ms) [MYSQL] QueryInterface describeTable βœ“ rejects when no data is available βœ“ reads the metadata of the table (41ms) βœ“ should correctly determine the primary key columns (96ms) [MYSQL] QueryInterface getForeignKeyReferencesForTable βœ“ should be able to provide existing foreign keys (99ms) [MYSQL] QueryInterface removeColumn (without a schema) βœ“ should be able to remove a column with a default value (78ms) βœ“ should be able to remove a column without default value (72ms) βœ” should load ids when loadRelationIdAndMap used on nested relation (48ms) inverse side βœ“ should be able to remove a column with a foreign key constraint (120ms) - should be able to remove a column with primaryKey βœ“ should be able to remove a column with unique contraint (77ms) (with a schema) βœ“ [Flaky] should be able to remove a column with a default value (74ms) βœ“ should be able to remove a column without default value (71ms) - should be able to remove a column with primaryKey βœ“ should be able to remove a column with unique contraint (76ms) [MYSQL] Replication Executing (default): DROP TABLE IF EXISTS `Users`; Executing (default): CREATE TABLE IF NOT EXISTS `Users` (`id` INTEGER NOT NULL auto_increment , `first_name` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB; Executing (default): SHOW INDEX FROM `Users` Executing (default): INSERT INTO `Users` (`id`,`first_name`,`createdAt`,`updatedAt`) VALUES (DEFAULT,?,?,?); βœ“ should be able to make a write Executing (default): DROP TABLE IF EXISTS `Users`; Executing (default): CREATE TABLE IF NOT EXISTS `Users` (`id` INTEGER NOT NULL auto_increment , `first_name` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB; Executing (default): SHOW INDEX FROM `Users` Executing (default): SELECT `id`, `first_name` AS `firstName`, `createdAt`, `updatedAt` FROM `Users` AS `User`; βœ“ should be able to make a read Executing (default): DROP TABLE IF EXISTS `Users`; Executing (default): CREATE TABLE IF NOT EXISTS `Users` (`id` INTEGER NOT NULL auto_increment , `first_name` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB; Executing (default): SHOW INDEX FROM `Users` Executing (34f1a1ac-fbd6-4f52-948d-a4ff971a8641): START TRANSACTION; Executing (34f1a1ac-fbd6-4f52-948d-a4ff971a8641): SELECT `id`, `first_name` AS `firstName`, `createdAt`, `updatedAt` FROM `Users` AS `User`; Executing (34f1a1ac-fbd6-4f52-948d-a4ff971a8641): COMMIT; βœ“ should run read-only transactions on the replica Executing (default): DROP TABLE IF EXISTS `Users`; Executing (default): CREATE TABLE IF NOT EXISTS `Users` (`id` INTEGER NOT NULL auto_increment , `first_name` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB; Executing (default): SHOW INDEX FROM `Users` Executing (ab1ce7fb-3178-4e9e-9195-f37a3888cb27): START TRANSACTION; Executing (ab1ce7fb-3178-4e9e-9195-f37a3888cb27): SELECT `id`, `first_name` AS `firstName`, `createdAt`, `updatedAt` FROM `Users` AS `User`; Executing (ab1ce7fb-3178-4e9e-9195-f37a3888cb27): COMMIT; βœ“ should run non-read-only transactions on the primary [MYSQL] Schema βœ“ supports increment βœ“ supports decrement [MYSQL] Sequelize constructor βœ“ should pass the global options correctly βœ“ should correctly set the host and the port βœ“ should set operators aliases on dialect queryGenerator (node:762) [SEQUELIZE0003] DeprecationWarning: String based operators are deprecated. Please use Symbol based operators for better security, read more at https://sequelize.org/master/manual/querying.html#operators authenticate with valid credentials βœ“ triggers the success event with an invalid connection βœ“ triggers the error event βœ“ triggers an actual RangeError or ConnectionError βœ“ triggers the actual adapter error with invalid credentials βœ“ triggers the error event βœ“ triggers an actual sequlize error βœ“ triggers the error event when using replication validate βœ“ is an alias for .authenticate() getDialect βœ“ returns the defined dialect getDatabaseName βœ“ returns the database name isDefined βœ“ returns false if the dao wasn't defined before βœ“ returns true if the dao was defined before model βœ“ throws an error if the dao being accessed is undefined βœ“ returns the dao factory defined by daoName set βœ“ should be configurable with global functions set βœ“ should return an promised error if transaction isn't defined βœ“ one value βœ“ multiple values define βœ“ adds a new dao to the dao manager βœ“ adds a new dao to sequelize.models βœ“ overwrites global options βœ“ overwrites global rowFormat options βœ“ inherits global collate option βœ“ inherits global rowFormat option βœ” should load ids when both entities have multiple primary keys βœ“ uses the passed tableName (43ms) truncate βœ“ truncates all models (89ms) sync βœ“ synchronizes all models (83ms) βœ“ works with correct database credentials (38ms) βœ“ fails with incorrect match condition βœ“ fails for incorrect connection even when no models are defined βœ“ fails with incorrect database credentials (1) βœ“ fails with incorrect database credentials (2) βœ“ fails with incorrect database credentials (3) βœ“ fails with incorrect database credentials (4) βœ“ returns an error correctly if unable to sync a foreign key referenced model βœ“ handles this dependant foreign key constraints (57ms) βœ“ return the sequelize instance after syncing βœ“ return the single dao after syncing βœ“ handles alter: true with underscore correctly (41ms) doesn't emit logging when explicitly saying not to βœ“ through Sequelize.sync() (48ms) βœ“ through DAOFactory.sync() (39ms) match βœ“ will return an error not matching drop should work βœ“ correctly succeeds (94ms) define βœ“ raises an error if no values are defined define enum βœ“ raises an error if no values are defined βœ“ correctly stores values βœ“ correctly loads values βœ“ doesn't save an instance if value is not in the range of enums enum βœ“ raises an error if no values are defined βœ“ correctly stores values βœ“ correctly loads values βœ“ doesn't save an instance if value is not in the range of enums table βœ“ should be able to override options on the default attributes (39ms) βœ“ should be able to override options on the default attributes (38ms) βœ“ should be able to override options on the default attributes (41ms) transaction βœ“ is a transaction method available βœ“ passes a transaction object to the callback βœ“ allows me to define a callback on the result βœ“ correctly handles multiple transactions (54ms) βœ” should load ids when only one entity have multiple primary key βœ“ supports nested transactions using savepoints (50ms) βœ“ supports rolling back a nested transaction (45ms) βœ“ supports rolling back outermost transaction (46ms) supports rolling back to savepoints βœ“ rolls back to the first savepoint, undoing everything βœ“ rolls back to the most recent savepoint, only undoing recent changes databaseVersion βœ“ should database/dialect version paranoid deletedAt non-null default value βœ“ should use defaultValue of deletedAt in paranoid clause and restore (59ms) [MYSQL] Sequelize#transaction βœ” should load ids when both entities have multiple primary keys and additional condition used βœ” should load ids when loadRelationIdAndMap used on nested relation (45ms) query builder > relation-id > many-to-one > basic-functionality βœ“ works for long running transactions (4050ms) Transaction#commit βœ“ returns a promise that resolves once the transaction has been committed Committing transaction 01dcecec-996e-4665-ab71-4f47234dc01f failed with error "Oh no, an error!". We are killing its connection as it is now in an undetermined state. βœ“ does not pollute the pool with broken connections if commit fails Transaction#rollback βœ“ returns a promise that resolves once the transaction has been rolled back Rolling back transaction fe80caf5-6526-4f5a-9f9a-4daa6f5bd0d5 failed with error "Oh no, an error!". We are killing its connection as it is now in an undetermined state. βœ“ does not pollute the pool with broken connections if the rollback fails complex long running example βœ“ works with promise syntax (1049ms) concurrency: having tables with uniqueness constraints βœ“ triggers the error event for the second transactions (107ms) Sequelize#drop βœ“ supports dropping cyclic associations (3372ms) [MYSQL] Sequelize log with disabled logging βœ“ does not call the log method of the logger with default logging options called with no arguments βœ“ calls the log method βœ“ logs an empty string as info event called with one argument βœ“ logs the passed string as info event called with more than two arguments βœ“ passes the arguments to the logger with a custom function for logging βœ“ calls the custom logger method βœ“ calls the custom logger method with options [MYSQL] Sequelize query βœ“ executes a query the internal way βœ“ executes a query if only the sql is passed βœ“ executes a query if a placeholder value is an array βœ“ executes select queries correctly βœ“ executes select queries correctly when quoteIdentifiers is false βœ“ executes select query with dot notation results βœ“ executes select query with dot notation results and nest it - executes stored procedures βœ“ uses the passed model βœ“ maps the field names to attributes based on the passed model βœ“ arbitrarily map the field names βœ“ keeps field names that are mapped to the same name βœ“ properly adds and escapes replacement value βœ“ it allows to pass custom class instances βœ“ uses properties `query` and `values` if query is tagged βœ“ uses properties `query` and `bind` if query is tagged βœ“ dot separated attributes when doing a raw query without nest βœ“ destructs dot separated attributes when doing a raw query using nest βœ“ replaces token with the passed array βœ“ replaces named parameters with the passed object βœ“ replaces named parameters with the passed object and ignore those which does not qualify βœ” should load ids when loadRelationIdAndMap used βœ“ replaces named parameters with the passed object using the same key twice βœ“ replaces named parameters with the passed object having a null property βœ“ binds token with the passed array βœ“ binds named parameters with the passed object βœ“ binds named parameters with the passed object using the same key twice βœ“ binds named parameters with the passed object having a null property βœ“ binds named parameters array handles escaped $$ βœ“ binds named parameters object handles escaped $$ βœ“ escape where has $ on the middle of characters βœ“ handles AS in conjunction with functions just fine QueryTypes βœ“ RAW retry βœ“ properly bind parameters on extra retries (219ms) logging βœ“ executes a query with global benchmarking option and custom logger βœ“ executes a query with benchmarking option and custom logger with logQueryParameters βœ“ add parameters in log sql βœ“ add parameters in log sql when use bind value stacktraces βœ“ emits raw errors if requested βœ“ emits full stacktraces for generic database error βœ“ emits full stacktraces for unique constraint error βœ” should load ids when loadRelationIdAndMap used and target entity has multiple primary keys βœ“ emits full stacktraces for constraint validation error rejections βœ“ reject if `values` and `options.replacements` are both passed βœ“ reject if `sql.bind` and `options.bind` are both passed βœ“ reject if `options.replacements` and `options.bind` are both passed βœ“ reject if `sql.bind` and `sql.values` are both passed βœ“ reject if `sql.bind` and `options.replacements`` are both passed βœ“ reject if `options.bind` and `sql.replacements` are both passed βœ“ reject when key is missing in the passed object βœ“ reject with the passed number βœ“ reject with the passed empty object βœ“ reject with the passed string (node:762) [DEP0005] DeprecationWarning: Buffer() is deprecated due to security and usability issues. Please use the Buffer.alloc(), Buffer.allocUnsafe(), or Buffer.from() methods instead. βœ“ reject with the passed date βœ“ reject when binds passed with object and numeric $1 is also present βœ“ reject when binds passed as array and $alpha is also present βœ“ reject when bind key is $0 with the passed array βœ“ reject when bind key is $01 with the passed array βœ“ reject when bind key is missing in the passed array βœ“ reject when bind key is missing in the passed object βœ“ reject with the passed number for bind βœ“ reject with the passed empty object for bind βœ“ reject with the passed string for bind βœ“ reject with the passed date for bind [MYSQL] Timezone βœ“ returns the same value for current timestamp βœ“ handles existing timestamps (55ms) Ignoring invalid timezone passed to Connection: America/New_York. This is currently a warning, but in future versions of MySQL2, an error will be thrown if you pass an invalid configuration option to a Connection Ignoring invalid timezone passed to Connection: America/New_York. This is currently a warning, but in future versions of MySQL2, an error will be thrown if you pass an invalid configuration option to a Connection βœ“ handles named timezones (58ms) [MYSQL] Transaction βœ“ does not allow queries after commit βœ“ does not allow queries immediately after commit call βœ“ does not allow queries after rollback βœ“ should not rollback if connection was not acquired βœ“ does not allow queries immediately after rollback call βœ“ does not allow commits after commit βœ“ should run hooks if a non-auto callback transaction is committed βœ“ should not run hooks if a non-auto callback transaction is rolled back βœ“ should throw an error if null is passed to afterCommit βœ“ should throw an error if undefined is passed to afterCommit βœ“ should throw an error if an object is passed to afterCommit βœ“ does not allow commits after rollback βœ“ does not allow rollbacks after commit βœ“ does not allow rollbacks after rollback βœ“ works even if a transaction: null option is passed βœ“ works even if a transaction: undefined option is passed constructor βœ“ stores options βœ“ generates an identifier βœ“ should call dialect specific generateTransactionId method commit βœ“ is a commit method available rollback βœ“ is a rollback method available autoCallback βœ“ supports automatically committing βœ“ supports automatically rolling back with a thrown error βœ“ supports automatically rolling back with a rejection βœ“ supports running hooks when a transaction is committed βœ“ does not run hooks when a transaction is rolled back deadlock handling - should treat deadlocked transaction as rollback - should release the connection for a deadlocked transaction (1/2) - should release the connection for a deadlocked transaction (2/2) isolation levels βœ“ should read the most recent committed rows when using the READ COMMITTED isolation level (52ms) βœ“ should not read newly committed rows when using the REPEATABLE READ isolation level (54ms) - should block updates after reading a row using SERIALIZABLE row locking βœ“ supports for update (2057ms) βœ“ fail locking with outer joins (155ms) βœ” should load ids when loadRelationIdAndMap used on nested relation and target entity has multiple primary keys query builder > relation-id > many-to-one > embedded βœ” should load ids when loadRelationIdAndMap used on embedded and nested embedded tables query builder > relation-id > many-to-one > embedded-with-multiple-pk βœ“ supports for share (i.e. `SELECT ... LOCK IN SHARE MODE`) (6049ms) [MYSQL] Utils underscore underscoredIf βœ“ is defined βœ“ underscores if second param is true βœ“ doesn't underscore if second param is false camelizeIf βœ“ is defined βœ“ camelizes if second param is true βœ“ doesn't camelize if second param is false format βœ“ should format where clause correctly when the value is truthy βœ“ should format where clause correctly when the value is false cloneDeep βœ“ should clone objects βœ“ should clone nested objects βœ“ should not call clone methods on plain objects βœ“ should not call clone methods on arrays inflection βœ“ works better than lingo ;) Sequelize.fn βœ“ accepts condition object (with cast) βœ“ accepts condition object (auto casting) flattenObjectDeep βœ“ should return the value if it is not an object βœ“ should return correctly if values are null [MYSQL] Vectors βœ“ should not allow insert backslash (46ms) 1773 passing (10m) 32 pending Done in 571.83s. sequelize orm v6 test end [Pipeline] } Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_nodejs_test-1073/tidb-test already exists) [Pipeline] // cache [Pipeline] } [Pipeline] // dir [Pipeline] } [Pipeline] // stage [Pipeline] } [Pipeline] // container [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // node [Pipeline] } [Pipeline] // podTemplate [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // stage [Pipeline] } βœ” should load ids when loadRelationIdAndMap used on embedded table and each table have primary key query builder > relation-id > many-to-one > multiple-pk βœ” should load ids when both entities have multiple primary keys βœ” should load ids when only one entity have multiple primary keys βœ” should load ids when both entities have multiple primary keys and related entity does not have inverse side βœ” should load ids when loadRelationIdAndMap used on nested relation query builder > relation-id > one-to-many > basic-functionality βœ” should load id when loadRelationIdAndMap used with OneToMany relation βœ” should load id when loadRelationIdAndMap used with additional condition βœ” should load id when loadRelationIdAndMap used on nested relation (40ms) query builder > relation-id > one-to-many > embedded βœ” should load ids when loadRelationIdAndMap used on embedded and nested embedded tables query builder > relation-id > one-to-many > embedded-with-multiple-pk βœ” should load ids when loadRelationIdAndMap used on embedded table and each table have primary key (39ms) query builder > relation-id > one-to-many > multiple-pk βœ” should load ids when both entities have multiple primary keys βœ” should load ids when only one entity have multiple primary keys βœ” should load ids when both entities have multiple primary keys and additional condition used βœ” should load ids when loadRelationIdAndMap used on nested relation (42ms) query builder > relation-id > one-to-one > basic-functionality βœ” should load ids when loadRelationIdAndMap used with OneToOne owner side relation βœ” should load id when loadRelationIdAndMap used with OneToOne inverse side relation query builder > relation-id > one-to-one > embedded βœ” should load ids when loadRelationIdAndMap used on embedded and nested embedded tables query builder > relation-id > one-to-one > embedded-with-multiple-pk βœ” should load ids when loadRelationIdAndMap used on embedded table and each table have primary key query builder > relation-id > one-to-one > multiple-pk owner side βœ” should load ids when both entities have multiple primary keys βœ” should load ids when only one entity have multiple primary keys βœ” should load ids when both entities have multiple primary keys and related entity does not have inverse side βœ” should load ids when loadRelationIdAndMap used on nested relation inverse side βœ” should load ids when both entities have multiple primary keys βœ” should load ids when only one entity have multiple primary keys βœ” should load ids when loadRelationIdAndMap used on nested relation query builder > relational with many > add and remove many to many inverse βœ” should add entity relation of a given entity by entity objects (40ms) βœ” should add entity relation of a given entity by entity id βœ” should add entity relation of a given entity by entity id map βœ” should add entity relation of a multiple entities βœ” should add multiple entities into relation of a multiple entities query builder > relational with many > add and remove many to many βœ” should add entity relation of a given entity by entity objects (42ms) βœ” should add entity relation of a given entity by entity id (42ms) βœ” should add entity relation of a given entity by entity id map (40ms) βœ” should add entity relation of a multiple entities (40ms) βœ” should add multiple entities into relation of a multiple entities query builder > relational query builder > add operation > one to many relation βœ” should add entity relation of a given entity by entity objects βœ” should add entity relation of a given entity by entity id βœ” should add entity relation of a given entity by entity id map βœ” should add multiple entities into relation of a multiple entities βœ” should handle addAndRemove method as well query builder > relational with many > load many βœ” should load relation entity of a given entity object βœ” should load relation entity of a given entity id map βœ” should load relation entity of a given entity id query builder > relational query builder > load operation > many-to-one and one-to-one relations βœ” should load relation entity of a given entity object βœ” should load relation entity of a given entity id βœ” should load relation entity of a given id query builder > relational query builder > set operation > many to one relation βœ” should set entity relation of a given entity by entity objects βœ” should set entity relation of a given entity by entity id βœ” should set entity relation of a given entity by entity id map βœ” should set entity relation of a multiple entities query builder > relational query builder > set operation > one-to-one non owner side βœ” should set entity relation of a given entity by entity objects βœ” should set entity relation of a given entity by entity id βœ” should set entity relation of a given entity by entity id map βœ” should raise error when setting entity relation of a multiple entities query builder > relational query builder > set operation > one-to-one relation βœ” should set entity relation of a given entity by entity objects βœ” should set entity relation of a given entity by entity id βœ” should set entity relation of a given entity by entity id map (46ms) βœ” should raise error when setting entity relation of a multiple entities query builder > select βœ” should append all entity mapped columns from main selection to select statement βœ” should append all entity mapped columns from main selection to SELECT DISTINCT statement βœ” should append all entity mapped columns from both main selection and join selections to select statement βœ” should append entity mapped columns from both main alias and join aliases to select statement βœ” should append entity mapped columns to select statement, if they passed as array βœ” should append raw sql to select statement βœ” should append raw sql and entity mapped column to select statement βœ” should not create alias for selection, which is not entity mapped column βœ” Support max execution time βœ” Support using certain index with relations and where clause many-to-one βœ” should craft query with exact value βœ” should craft query with FindOperator βœ” should craft query with Raw one-to-many βœ” should craft query with exact value βœ” should craft query with FindOperator many-to-many βœ” should craft query with exact value βœ” should craft query with FindOperator one-to-one βœ” should craft query with exact value βœ” should craft query with FindOperator deeply nested relations βœ” should craft query with exact value βœ” should craft query with FindOperator query execution and retrieval βœ” should return a single entity for getOne when found βœ” should return undefined for getOne when not found βœ” should return a single entity for getOneOrFail when found βœ” should throw an Error for getOneOrFail when not found where-in-ids βœ” should create expected query with simple primary keys βœ” should create expected query with composite primary keys βœ” should create expected query with composite primary keys with missing value query builder > find with the global condition of "non-deleted" and eager relation βœ” The global condition of "non-deleted" should be set for the entity with delete date columns and eager relation βœ” The global condition of "non-deleted" should not be set when "withDeleted" is called query builder > find with the global condition of "non-deleted" βœ” The global condition of "non-deleted" should be set for the entity with delete date columns βœ” The global condition of "non-deleted" should not be set when "withDeleted" is called query builder > soft-delete βœ” should perform soft deletion and recovery correctly βœ” should soft-delete and restore properties inside embeds as well βœ” should perform soft delete with limit correctly βœ” should perform restory with limit correctly βœ” should throw error when delete date column is missing βœ” should find with soft deleted relations query builder > sub-query βœ” should execute sub query in where string using subQuery method βœ” should execute sub query in where function using subQuery method βœ” should execute sub query in where function using subQuery method βœ” should execute sub query using different query builder βœ” should execute sub query in from expression (using different query builder) βœ” should execute sub query in from expression (using from's query builder) βœ” should execute sub query in from expression (using from's query builder) βœ” should execute sub query in from expression as second from expression βœ” should execute sub query in selects βœ” should execute sub query in selects (using provided sub query builder) - should execute sub query in joins (using provided sub query builder) - should execute sub query in joins with subquery factory (as selection) - should execute sub query in joins as string (as selection) query builder > time-travel-query βœ” should execute time travel query without options βœ” should execute time travel query with options (48ms) βœ” should execute time travel query with 'skip' and 'take' options βœ” should execute time travel query with JOIN and skip/take options βœ” should execute time travel query with JOIN and limit/offset options query builder > update βœ” should perform updation correctly βœ” should be able to use sql functions βœ” should update and escape properly βœ” should update properties inside embeds as well βœ” should perform update with limit correctly βœ” should throw error when update value is missing βœ” should throw error when update value is missing 2 βœ” should throw error when update property in set method is unknown βœ” should throw error when unknown property in where criteria query runner > add column - should correctly add column and revert add query runner > change column - should correctly change column and revert change - should correctly change column 'isGenerated' property and revert change βœ” should correctly change generated as expression query runner > create and drop database βœ” should correctly create and drop database and revert it (231ms) query runner > create and drop schema βœ” should correctly create and drop schema and revert it query runner > create check constraint βœ” should correctly create check constraint and revert creation query runner > create exclusion constraint βœ” should correctly create exclusion constraint and revert creation query runner > create foreign key βœ” should correctly create foreign key and revert creation (1740ms) query runner > create index βœ” should correctly create index and revert creation (3078ms) query runner > create primary key βœ” should correctly create primary key and revert creation (3128ms) query runner > create table βœ” should correctly create table from simple object and revert creation (214ms) βœ” should correctly create table from Entity (51ms) βœ” should correctly create table with all dependencies and revert creation (904ms) βœ” should correctly create table with different `Unique` definitions (464ms) βœ” should correctly create table with different `withoutRowid` definitions query runner > create unique constraint βœ” should correctly create unique constraint and revert creation query runner > create view βœ” should correctly create VIEW and revert creation βœ” should correctly create MATERIALIZED VIEW and revert creation query runner > drop check constraint βœ” should correctly drop check constraint and revert drop query runner > drop column when columns are instances of TableColumn - should correctly drop column and revert drop when columns are strings - should correctly drop column and revert drop query runner > drop exclusion constraint βœ” should correctly drop exclusion constraint and revert drop query runner > drop foreign key βœ” should correctly drop foreign key and revert drop (127ms) query runner > drop index βœ” should correctly drop index and revert drop (1508ms) query runner > drop primary key - should correctly drop primary key and revert drop query runner > drop table βœ” should correctly drop table without relations and revert drop (362ms) βœ” should correctly drop table with relations and revert drop (704ms) query runner > drop unique constraint βœ” should correctly drop unique constraint and revert drop query runner > drop view βœ” should correctly drop VIEW and revert dropping βœ” should correctly drop MATERIALIZED VIEW and revert dropping query runner > has column βœ” should correctly check if column exist query runner > implicit results βœ” should return results for Oracle Stored Procedure with Implicit Results query runner > rename column βœ” should correctly rename column and revert rename (3327ms) - should correctly rename column with all constraints and revert rename - should correctly rename column with all constraints in custom table schema and database and revert rename query runner > rename table βœ” should correctly rename table and revert rename (272ms) - should correctly rename table with all constraints depend to that table and revert rename - should correctly rename table with custom schema and database and all its dependencies and revert rename query runner > stream βœ” should stream data relations > custom-referenced-column-name many-to-one βœ” should load related entity when relation use custom referenced column name βœ” should load related entity when relation defined with empty join column βœ” should load related entity when relation defined without reference column name βœ” should load related entity when relation defined without column name βœ” should load related entity when relation defined without reference column name and relation does not have relation column in entity βœ” should persist relation when relation sets via join column one-to-one βœ” should load related entity when relation use custom referenced column name βœ” should load related entity when relation defined without column name βœ” should load related entity when relation defined without reference column name βœ” should load related entity when relation defined without column name βœ” should load related entity when relation defined without reference column name and relation does not have relation column in entity βœ” should persist relation when relation sets via join column relations > eager relations > basic βœ” should load all eager relations when object is loaded (45ms) βœ” should not load eager relations when query builder is used relations > eager relations > circular eager relations βœ” should throw error if eager: true is set on both sides of relationship relations > eager relations > lazy nested eager relations βœ” should load all eager relations nested inside a lazy relation (42ms) basic-lazy-relations βœ” should persist and hydrate successfully on a relation without inverse side βœ” should persist and hydrate successfully on a relation with inverse side βœ” should persist and hydrate successfully on a one-to-one relation with inverse side loaded from entity schema βœ” should persist and hydrate successfully on a many-to-one relation without inverse side βœ” should persist and hydrate successfully on a many-to-one relation with inverse side βœ” should persist and hydrate successfully on a one-to-many relation βœ” should persist and hydrate successfully on a one-to-one relation owner side βœ” should persist and hydrate successfully on a one-to-one relation inverse side βœ” should successfully load relations within a transaction βœ” should successfully load relations outside a transaction with entity generated within a transaction lazy-relations-loading-via-base-entity-finders βœ” works named-columns-lazy-relations βœ” should persist and hydrate successfully on a relation without inverse side βœ” should persist and hydrate successfully on a relation with inverse side βœ” should persist and hydrate successfully on a many-to-one relation without inverse side βœ” should persist and hydrate successfully on a many-to-one relation with inverse side βœ” should persist and hydrate successfully on a one-to-many relation βœ” should persist and hydrate successfully on a one-to-one relation owner side βœ” should persist and hydrate successfully on a one-to-one relation inverse side named-tables-lazy-relations βœ” should persist and hydrate successfully on a relation without inverse side βœ” should persist and hydrate successfully on a relation with inverse side βœ” should persist and hydrate successfully on a many-to-one relation without inverse side βœ” should persist and hydrate successfully on a many-to-one relation with inverse side βœ” should persist and hydrate successfully on a one-to-many relation βœ” should persist and hydrate successfully on a one-to-one relation owner side βœ” should persist and hydrate successfully on a one-to-one relation inverse side named-tables-and-columns-lazy-relations βœ” should persist and hydrate successfully on a relation without inverse side βœ” should persist and hydrate successfully on a relation with inverse side βœ” should persist and hydrate successfully on a many-to-one relation without inverse side βœ” should persist and hydrate successfully on a many-to-one relation with inverse side βœ” should persist and hydrate successfully on a one-to-many relation βœ” should persist and hydrate successfully on a one-to-one relation owner side βœ” should persist and hydrate successfully on a one-to-one relation inverse side relations > multiple-primary-keys > many-to-many owning side βœ” should load related entity when JoinTable used without options βœ” should load related entity when JoinTable used with options βœ” should load related entity when JoinTable references with non-primary columns βœ” should load related entity when both entities have multiple primary columns and JoinTable used without options βœ” should load related entity when both entities have multiple primary columns and JoinTable used with options βœ” should load related entity when both entities have multiple primary columns and JoinTable references with non-primary columns inverse side βœ” should load related entity when JoinTable used without options βœ” should load related entity when JoinTable used with options βœ” should load related entity when JoinTable references with non-primary columns βœ” should load related entity when both entities have multiple primary columns and JoinTable used without options βœ” should load related entity when both entities have multiple primary columns and JoinTable used with options βœ” should load related entity when both entities have multiple primary columns and JoinTable references with non-primary columns relations > multiple-primary-keys > many-to-one owning side βœ” should load related entity when JoinColumn is not specified βœ” should load related entity when JoinColumn is specified without options βœ” should load related entity when JoinColumn is specified with options βœ” should load related entity when JoinColumn references on to non-primary columns inverse side βœ” should load related entity when JoinColumn is not specified βœ” should load related entity when JoinColumn is specified without options βœ” should load related entity when JoinColumn is specified with options βœ” should load related entity when JoinColumn references on to non-primary columns relations > multiple-primary-keys > one-to-many βœ” should correctly insert relation items βœ” should correctly load relation items βœ” should correctly update relation items βœ” should correctly delete relation items relations > multiple-primary-keys > one-to-one owning side βœ” should load related entity when JoinColumn is specified without options βœ” should load related entity when JoinColumn is specified with options βœ” should load related entity when JoinColumn references on to non-primary columns βœ” should load related entity when both entities have multiple primary columns and JoinColumn defined without options βœ” should load related entity when both entities have multiple primary columns and JoinColumn defined with options βœ” should load related entity when both entities have multiple primary columns and JoinColumn references on to non-primary columns inverse side βœ” should load related entity when JoinColumn is specified without options βœ” should load related entity when both entities have multiple primary columns and JoinColumn defined without options βœ” should load related entity when both entities have multiple primary columns and JoinColumn defined with options βœ” should load related entity when JoinColumns references on to non-primary columns βœ” should load related entity when both entities have multiple primary columns and JoinColumn defined with options βœ” should load related entity when both entities have multiple primary columns and JoinColumn references on to non-primary columns relations > multiple-primary-keys > other-cases βœ” should load related entity when entity uses relation ids as primary id (38ms) relations > relation mapped to relation with different name (#56) - should work perfectly relations > relation with primary key many-to-one with primary key in relation βœ” should work perfectly repository > aggregate methods sum βœ” should return the aggregate sum βœ” should return null when 0 rows match the query average βœ” should return the aggregate average βœ” should return null when 0 rows match the query minimum βœ” should return the aggregate minimum βœ” should return null when 0 rows match the query maximum βœ” should return the aggregate maximum βœ” should return null when 0 rows match the query repository > basic methods target βœ” should return instance of the object it manages hasId βœ” should return true if entity has an id βœ” should return false if entity does not have an id createQueryBuilder βœ” should create a new query builder with the given alias create βœ” should create a new instance of the object we are working with βœ” should create a new empty object if entity schema is used βœ” should create a new empty object if entity schema with a target is used βœ” should create an entity and copy to it all properties of the given plain object if its given createMany βœ” should create entities and copy to them all properties of the given plain object if its given preload βœ” should preload entity from the given object with only id βœ” should preload entity and all relations given in the object merge βœ” should merge multiple entities βœ” should merge both entities and plain objects save βœ” should update existing entity using transformers upsert - should first create then update an entity βœ” should bulk upsert - should not overwrite unspecified properties βœ” should skip update when nothing has changed βœ” should upsert with embedded columns βœ” should upsert on one-to-one relation βœ” should bulk upsert with embedded columns βœ” should throw if using an unsupported driver βœ” should throw if using indexPredicate with an unsupported driver preload also should also implement merge functionality βœ” if we preload entity from the plain object and merge preloaded object with plain object we'll have an object from the db with the replaced properties by a plain object's properties query βœ” should execute the query natively and it should return the result repository > clear method βœ” should remove everything (319ms) βœ” called from entity managed should remove everything as well (300ms) repository > decrement method basic βœ” should decrement value βœ” should accept string as input and decrement value βœ” should return UpdateResult βœ” should throw an error if column property path was not found βœ” should throw an error if input value is not number bigint βœ” should decrement value embeded entities βœ” should decrement value repository > deleteById methods βœ” remove using deleteById method should delete successfully βœ” remove using removeByIds method should delete successfully repository > find methods count βœ” should return a full count when no criteria given (231ms) βœ” should return a count of posts that match given criteria (236ms) βœ” should return a count of posts that match given multiple criteria (231ms) βœ” should return a count of posts that match given find options (237ms) βœ” should return a count of posts that match both criteria and find options (234ms) exists βœ” should return a True when no criteria given (247ms) βœ” should return True when matches the given criteria (246ms) βœ” should return True when matches the given multiple criteria (224ms) βœ” should return True when matches the given find options (220ms) βœ” should return True when matches both criteria and find options (225ms) find and findAndCount βœ” should return everything when no criteria given (232ms) βœ” should return posts that match given criteria (228ms) βœ” should return posts that match given multiple criteria (224ms) βœ” should return posts that match given find options (250ms) βœ” should return posts that match both criteria and find options (246ms) findOne βœ” should throw an error when no criteria given (225ms) βœ” should return when criteria given (223ms) βœ” should return when find options given (233ms) findOne βœ” should return entity by a given id (226ms) βœ” should return entity by a given id and find options (217ms) findByIds βœ” should return entities by given ids findOneOrFail βœ” should return entity by a given id (222ms) βœ” should return entity by a given id and find options (223ms) βœ” should throw an error if nothing was found (218ms) repository > find options βœ” should load relations βœ” should execute select query inside transaction βœ” should select specific columns βœ” should select by given conditions repository > find options > comment βœ” repository should insert comment repository > find options > cache βœ” repository should cache results properly (1023ms) repository > find options > locking βœ” should throw error if pessimistic lock used without transaction - should not throw error if pessimistic lock used with transaction - should attach pessimistic read lock statement on query if locking enabled βœ” should attach for no key update lock statement on query if locking enabled βœ” should attach for key share lock statement on query if locking enabled βœ” should attach SKIP LOCKED for pessimistic_read βœ” should attach NOWAIT for pessimistic_write βœ” should attach pessimistic write lock statement on query if locking enabled βœ” should attach dirty read lock statement on query if locking enabled βœ” should throw error if optimistic lock used with `find` method βœ” should not throw error if optimistic lock used with `findOne` method βœ” should throw error if entity does not have version and update date columns βœ” should throw error if actual version does not equal expected version βœ” should not throw error if actual version and expected versions are equal βœ” should throw error if actual updated date does not equal expected updated date βœ” should not throw error if actual updated date and expected updated date are equal βœ” should work if both version and update date columns applied βœ” should throw error if pessimistic locking not supported by given driver βœ” should not allow empty array for lockTables βœ” should throw error when specifying a table that is not part of the query βœ” should allow on a left join βœ” should allow using lockTables on all types of locking βœ” should allow locking a relation of a relation repository > find options > operators βœ” not βœ” lessThan βœ” lessThanOrEqual βœ” not(lessThan) βœ” not(lessThanOrEqual) βœ” moreThan βœ” moreThanOrEqual βœ” not(moreThan) βœ” not(moreThanOrEqual) βœ” equal βœ” not(equal) βœ” ilike βœ” not(ilike) βœ” like βœ” not(like) βœ” between βœ” not(between) βœ” in βœ” not(in) βœ” any βœ” not(any) βœ” isNull βœ” not(isNull) βœ” raw βœ” raw (function) βœ” raw (function with object literal parameters) βœ” should work with ActiveRecord model βœ” or (array syntax) repository > find options > relations βœ” should not any relations if they are not specified βœ” should load specified relations case 1 βœ” should load specified relations case 2 βœ” should load specified relations and their sub-relations case 1 βœ” should load specified relations and their sub-relations case 2 βœ” should load specified relations and their sub-relations case 3 βœ” should throw error if specified relations were not found case 1 βœ” should throw error if specified relations were not found case 2 βœ” should throw error if specified relations were not found case 3 βœ” should throw error if specified relations were not found case 4 βœ” should throw error if specified relations were not found case 5 βœ” should throw error if specified relations were not found case 6 repository > increment method basic βœ” should increment value βœ” should accept string as input and increment value βœ” should return UpdateResult βœ” should throw an error if column property path was not found βœ” should throw an error if input value is not number bigint βœ” should increment value embeded entities βœ” should increment value repository > set/add/remove relation methods - add elements to many-to-many from owner side - add elements to many-to-many from inverse side - remove elements to many-to-many from owner side - remove elements to many-to-many from inverse side - set element to one-to-many relation - set element to many-to-one relation - set element to NULL in one-to-many relation - set element to NULL in many-to-one relation entity > soft-remove βœ” should perform soft removal and recovery correctly βœ” should throw error when delete date column is missing repository > the global condtion of "non-deleted" with eager relation βœ” The global condition of "non-deleted" should be set for the entity with delete date columns and eager relation βœ” The global condition of "non-deleted" should not be set when the option "withDeleted" is set to true repository > the global condtion of "non-deleted" βœ” The global condition of "non-deleted" should be set for the entity with delete date columns βœ” The global condition of "non-deleted" should not be set when the option "withDeleted" is set to true repository > soft-delete βœ” should perform soft deletion and restoration correctly repository > soft-remove βœ” should perform soft removal and recovery correctly βœ” should throw error when delete date column is missing schema builder > add column βœ” should correctly add column (386ms) schema builder > change check constraint βœ” should correctly add new check constraint βœ” should correctly change check βœ” should correctly drop removed check schema builder > change column βœ” should correctly change column name (503ms) βœ” should correctly change column length (2481ms) βœ” should correctly change column type (4357ms) βœ” should correctly change column default value (111ms) - should correctly make column primary and generated - should correctly change column `isGenerated` property when column is on foreign key - should correctly change non-generated column on to uuid-generated column - should correctly change generated column generation strategy βœ” should correctly change column comment (783ms) βœ” should correctly change column type when FK relationships impact it (837ms) schema builder > change exclusion constraint βœ” should correctly add new exclusion constraint βœ” should correctly change exclusion βœ” should correctly drop removed exclusion schema builder > change index βœ” should correctly add new index (1609ms) βœ” should correctly change index (1768ms) βœ” should correctly drop removed index (235ms) βœ” should ignore index synchronization when `synchronize` set to false (1711ms) schema builder > change unique constraint βœ” should correctly add new unique constraint (1626ms) βœ” should correctly change unique constraint (1789ms) βœ” should correctly drop removed unique constraint (620ms) schema builder > create foreign key βœ” should correctly create foreign key (1841ms) schema builder > create table βœ” should correctly create tables with all dependencies (6326ms) schema builder > custom-db-and-schema-sync custom database βœ” should correctly sync tables with custom schema and database (2817ms) custom schema βœ” should correctly sync tables with custom schema βœ” should correctly sync tables with `public` schema custom database and schema βœ” should correctly sync tables with custom schema and database schema builder > drop column βœ” should correctly drop column (799ms) schema builder > update primary keys - should correctly update composite primary keys - should correctly update composite primary keys when table already have primary generated column spatial-cockroachdb βœ” should create correct schema with geometry type βœ” should create correct schema with geography type βœ” should create correct schema with geometry indices βœ” should persist geometry correctly βœ” should persist geography correctly βœ” should update geometry correctly βœ” should re-save geometry correctly βœ” should be able to order geometries by distance spatial-postgres βœ” should create correct schema with Postgres' geometry type βœ” should create correct schema with Postgres' geography type βœ” should create correct schema with Postgres' geometry indices βœ” should persist geometry correctly βœ” should persist geography correctly βœ” should update geometry correctly βœ” should re-save geometry correctly βœ” should be able to order geometries by distance sqlite driver > busy-timeout βœ” should set the busy_timeout as expected sqlite driver > enable wal βœ” should set the journal mode as expected sqlite driver > throws an error when queried after closing connection βœ” should throw sqlite driver > file open flags βœ” should open a DB with flags as expected sqljs driver > autosave βœ” should call autoSaveCallback on insert, update and delete sqljs driver > autosave off βœ” should not call autoSaveCallback when autoSave is disabled sqljs driver > load βœ” should load from a file βœ” should throw an error if the file doesn't exist sqljs driver > save βœ” should save to file βœ” should load a file that was saved sqljs driver > startup βœ” should startup even if the file doesn't exist βœ” should write a new file after first write operation table inheritance > regular inheritance using extends keyword βœ” should work correctly table-inheritance > single-table > basic-functionality βœ” should correctly insert, update and delete data with single-table-inheritance pattern (72ms) βœ” should be able to save different child entities in bulk βœ” should be able to find correct child entities when base class is used as entity metadata table-inheritance > single-table > database-option-inherited βœ” should correctly inherit database option table-inheritance > single-table > no-type-column βœ” should return subclass in relations table-inheritance > single-table > non-virtual-discriminator-column βœ” should return non virtual discriminator column as well table-inheritance > single-table > numeric types βœ” should allow numeric types for the discriminator, including 0 table-inheritance > single-table > relations > many-to-many owner side βœ” should work correctly with ManyToMany relations (55ms) inverse side βœ” should work correctly with ManyToMany relations table-inheritance > single-table > relations > one-to-many βœ” should work correctly with OneToMany relations (50ms) table-inheritance > single-table > relations > one-to-many-cascade-save βœ” should work correctly with OneToMany relations transaction > transaction with full isolation support - should execute all operations in a single transaction with READ UNCOMMITTED isolation level βœ” should execute all operations in a single transaction with READ COMMITTED isolation level βœ” should execute all operations in a single transaction with REPEATABLE READ isolation level - should execute all operations in a single transaction with SERIALIZABLE isolation level transaction > transaction with oracle connection partial isolation support βœ” should execute all operations in a single transaction with READ COMMITTED isolation level βœ” should execute all operations in a single transaction with SERIALIZABLE isolation level transaction > transaction with sqlite connection partial isolation support βœ” should execute all operations in a single transaction with READ UNCOMMITTED isolation level βœ” should execute all operations in a single transaction with SERIALIZABLE isolation level transaction > nested transaction βœ” should execute operations based on conditions in deeply nested scenario βœ” should fail operations when first transaction fails transaction > return data from transaction βœ” should allow to return typed data from transaction βœ” should allow to return typed data from transaction using type inference transaction > single query runner βœ” should execute all operations in the method in a transaction βœ” should execute all operations in the method in a transaction (#804) transaction > transaction with entity manager βœ” should execute all operations in a single transaction βœ” should not save anything if any of operation in transaction fail transaction > transaction with load many βœ” should loadMany in same transaction with same query runner tree tables > closure-table βœ” categories should be attached via parent and saved properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly and everything must be saved in cascades - categories should remove removed children - sub-category should be removed with all its children βœ” findTrees() tests > findTrees should load all category roots and attached children βœ” findTrees() tests > findTrees should load multiple category roots if they exist βœ” findTrees() tests > findTrees should filter by depth if optionally provided βœ” findDescendantsTree() tests > findDescendantsTree should load all category descendents and nested children βœ” findDescendantsTree() tests > findDescendantsTree should filter by depth if optionally provided tree tables > materialized-path βœ” attach should work properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly and everything must be saved in cascades βœ” findTrees() tests > findTrees should load all category roots and attached children βœ” findTrees() testsfindTrees should load multiple category roots if they exist βœ” findTrees() testsfindTrees should filter by depth if optionally provided βœ” findDescendantsTree() tests > findDescendantsTree should load all category descendents and nested children βœ” findDescendantsTree should filter by depth if optionally provided βœ” should compute path correctly when tree is implicitly saved (cascade: true) through related entity tree tables > nested-set βœ” attach should work properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly and everything must be saved in cascades βœ” findTrees() tests > findTrees should load all category roots and attached children βœ” findTrees() tests > findTrees should filter by depth if optionally provided βœ” findTrees() tests > findTrees should present a meaningful error message when used with multiple roots + nested sets βœ” findDescendantsTree() tests > findDescendantsTree should load all category descendents and nested children βœ” findDescendantsTree() tests > findDescendantsTree should filter by depth if optionally provided ImportUtils.importOrRequireFile βœ” should import .js file as ESM βœ” should import .js file as CommonJS βœ” should import .mjs file as ESM βœ” should import .cjs file as CommonJS βœ” should import .json file as CommonJS OrmUtils.mergeDeep βœ” should handle simple values. βœ” should handle ordering and indempotence. βœ” should skip nested promises in sources. βœ” should merge moderately deep objects correctly. βœ” should merge recursively deep objects correctly βœ” should reference copy complex instances of classes. StringUtils snakeCase βœ” should convert camelcase to snakecase βœ” should correctly convert an initial capital βœ” should correctly convert strings of capitals βœ” should correctly convert repeating camelcase groups βœ” should do nothing with strings that are already snakecase βœ” should correctly convert mixed strings into snakecase βœ” should correctly convert strings with numbers βœ” should match the examples given in the older implementation camelCase βœ” should convert snakecase to camelcase βœ” should convert with first capital letter βœ” should correctly convert repeating snakecase groups βœ” should do nothing with strings that are already camelcase βœ” should correctly convert strings with numbers uuid-cockroach βœ” should make correct schema with CockroachDB uuid type βœ” should persist uuid correctly βœ” should persist uuid correctly when it is generated non primary column uuid-mssql βœ” should persist uuid correctly when it is generated non primary column uuid-mysql βœ” should persist uuid correctly when it is generated non primary column βœ” should set generated uuid in the model after save uuid-oracle βœ” should persist uuid correctly when it is generated non primary column pgcrypto βœ” should make correct schema with Postgres' uuid type βœ” should persist uuid correctly βœ” should persist uuid correctly when it is generated non primary column uuid-ossp βœ” should make correct schema with Postgres' uuid type βœ” should persist uuid correctly βœ” should persist uuid correctly when it is generated non primary column uuid-mysql βœ” should persist uuid correctly when it is generated non primary column βœ” should set generated uuid in the model after save uuid-spanner βœ” should persist uuid correctly when it is generated non primary column uuid-sqlite βœ” should persist uuid correctly when it is generated non primary column view entity > general βœ” should create entity view from query builder definition βœ” should correctly return data from View view entity > mssql βœ” should create entity view from string definition βœ” should correctly return data from View view entity > mysql βœ” should create entity view from string definition βœ” should correctly return data from View view entity > oracle βœ” should create entity view from string definition βœ” should correctly return data from View view entity > postgres βœ” should create entity view from string definition βœ” should not return data without refreshing the materialized view βœ” should correctly return data from View view entity > sqlite βœ” should create entity view from string definition βœ” should correctly return data from View views dependencies βœ” should generate drop and create queries in correct order github issues > #10040 TypeORM synchronize database even if it is up to date βœ” should return an empty array for the upQueries after sync github issues > #1014 Transaction doesn't rollback βœ” should rollback transaction if some operation failed in it github issues > #1034 Issue using setter with promises βœ” should set members in circle github issues > #1042 EntityMetadata.createPropertyPath does not work properly with objects inside entities (date, json, etc.) βœ” should update object columns fine, at the same time embedded should work properly github issues > #1055 ind with relations not working, correct syntax causes type error βœ” should be able to find by object reference βœ” should not have type errors with the primary key type github issues > #108 Error with constraint names on postgres βœ” should sync even when there unqiue constraints placed on similarly named columns github issues > #1089 UUID in ClosureEntity βœ” should correctly work with primary UUID column (1997ms) github issues > #1099 BUG - QueryBuilder MySQL skip sql is wrong βœ” drivers which does not support offset without limit should throw an exception, other drivers must work fine github issues > #1113 CreateDateColumn's type is incorrect when using decorator @CreateDateColumn({type: 'timestamp'}) βœ” should correctly create date column from @CreateDateColumn decorator and with custom column type github issues > #1118 findByIds must return empty results if no criteria were passed in an array βœ” drivers which does not support offset without limit should throw an exception, other drivers must work fine github issues > #1123 load relation eagerly by setting isEager property βœ” should load all eager relations when object is loaded βœ” should not load eager relations when query builder is used github issues > #1139 mysql primary generated uuid ER_TOO_LONG_KEY βœ” correctly create primary generated uuid column (335ms) github issues > #114 Can not be parsed correctly the URL of pg. - should not fail in url parser github issues > #1140 timestamp column and value transformer causes TypeError βœ” correctly store/load timestamp columns github issues > #1147 FindOptions should be able to accept custom where condition - should properly query using custom sql github issues > #1178 subqueries must work in insert statements βœ” should work fine github issues > #1200 Update multiple nested embeddeds βœ” should update all embedded entities including the nested ones github issues > #1210 mongodb does not have multiple entities properly βœ” should save entities properly github issues > #1233 column updatedDate must appear in the GROUP BY clause or be used in an aggregate function βœ” should filter correctly using findByIds github issues > #1245 `findByIds` ignores `FindManyOptions` βœ” should filter correctly using findByIds βœ” should filter correctly using findByIds github issues > #1259 Can't sort by fields added with addSelect βœ” should order by added selects when pagination is used βœ” should order by added selects when pagination is used github issues > #1261 onDelete property on foreign key is not modified on sync βœ” should modify onDelete property on foreign key on sync (451ms) github issue > #1282 FEATURE REQUEST - Naming strategy joinTableColumnName if it is called from the owning or owned (inverse) context βœ” NamingStrategyUnderTest# github issues > #1308 Raw Postgresql Update query result is always an empty array βœ” Update query returns the number of affected rows github issues > #131 Error with single table inheritance query without additional conditions βœ” should not fail when querying for single table inheritance model without additional conditions github issues > #1314 UPDATE on json column stores string type βœ” should not store json type as string on update github issue > #1326 Wrong behavior w/ the same table names in different databases βœ” should not confuse equivalent table names in different databases (49ms) github issues > #134 Error TIME is converted to 'HH-mm' instead of 'HH:mm βœ” should successfully persist the post with creationDate in HH:mm and return persisted entity github issues > #1355 Allow explicitly named primary keys, foreign keys, and indices βœ” should set foreign keys their names to given names github issues > #1369 EntitySubscriber not firing events on abstract class entity βœ” should fire the given event for an abstract entity github issues > #1377 Add support for `GENERATED ALWAYS AS` in MySQL - should correctly create table with generated columns github issues > #1388 nullable: true dons't output 'NULL' in mysql βœ” should correctly create nullable column github issue > #1397 Spaces at the end of values are removed when inserting βœ” should not trim empty spaces when saving github issue > #1416 Wrong behavior when fetching an entity that has a relation with its own eager relations βœ” should load eager relations of an entity's relations recursively github issues > #1427 precision and scale column types with errant behavior βœ” should correctly create column with precision and scale github issues > #1465 save child and parent entity βœ” account property in accountActivationToken should not be null github issues > #1476 subqueries βœ” should github issues > #1493 Error parsing pg connection string βœ” should parse common connection url βœ” should parse url with password contains colons βœ” should parse url with username and password contains at signs github issues > #1504 Cannot eagerly query Entity with relation more than 3 levels deep βœ” should not throw an error github issues > #151 joinAndSelect can't find entity from inverse side of relation βœ” should cascade persist successfully github issues > #1510 entity schema does not support mode=objectId βœ” throws an error because there is no object id defined βœ” should create entities without throwing an error when objectId is defined github issues > #1532 Array type default value doesnt work. PostgreSQL βœ” can recognize model changes βœ” does not generate when no model changes github issues > #1545 Typeorm runs insert query instead of update query on save of existing entity for ManyToOne relationships - should add intial validation data github issues > #1551 complex example of cascades + multiple primary keys = persistence order βœ” throws an error because there is no object id defined - throws a "update or delete on table 'message' violates foreign key constraint on table 'recipient'" error on delete - throws a "null value in column 'userId' violates not-null constraint" error on delete - throws a "Subject Recipient must have an identifier to perform operation" internal error on delete github issue > #1569 updateById generates wrong SQL with arrays inside embeddeds βœ” should properly updateById arrays inside embeddeds github issues > #1576 Entities with null as `id` are merged [@next] βœ” should successfully create object github issues > #1581 Composite key breaks OneToMany relation - throws an error because there is no object id defined github issues > #1584 Cannot read property 'createValueMap' of undefined βœ” should save entities properly github issues > #1591 Define order of relation data when querying on the main entity - should query correct number of users with joined data ordering applied github issues > #1600 Postgres: QueryBuilder insert with Postgres array type bug βœ” should insert successfully using save method βœ” should insert successfully using insert method github issues > #161 joinAndSelect can't find entity from inverse side of relation βœ” should persist successfully βœ” should return joined relation successfully github issues > #1615 Datetime2 with any precision result in datetime2(7) in database βœ” should correctly create column with Datetime2 type and any precision github issues > #1623 NOT NULL constraint failed after a new column is added (SQLite) βœ” should correctly add new column (148ms) github issues > #163 ManyToMany relation : Cannot read property 'joinColumnName' of undefined βœ” should persist class table child successfully github issues > #1652 Multiple primary key defined βœ” should correctly create table when multiple primary keys defined and one of them is generated github issues > #1680 Delete & Update applies to all entities in table if criteria is undefined or empty βœ” Delete & Update should throw an error when supplied with an empty criteria github issues > #1685 JoinColumn from JoinColum is not considered when inserting new value - should not fail when inserting a new UserMonth with good PKs from JoinColumn github issues > #1703 Many to Many with association table returns odd values. βœ” should work as expected github issues > #1720 Listener not invoked when relation loaded through getter βœ” should work as expected github issues > #1733 Postgresql driver does not detect/support varying without length specified βœ” should correctly synchronize schema when varchar column length is not specified github issues > #174 Embeded types confusing with order by βœ” should order organisations correctly when properties are duplicate in its embeddable github issues > #1748 PrimaryColumn combined with transformer leads to error on save βœ” should work as expected github issues > #1749 Can't delete tables in non-default schema βœ” should delete entites from tables in different schemas github issues > #175 ManyToMany relation doesn't put an empty array when the relation is empty βœ” should return post with categories if they are attached to the post βœ” should return post with categories even if post with empty categories was saved βœ” should return post with categories even if post was saved without categories set github issues > #1751 Create sequence repeatedly when it already exists βœ” should correctly synchronize schema github issue #1754 Repository.save() always updating ManyToOne relation βœ” should work as expected github issues > #1758 Synchronization bug in PostgreSQL bug occurs when we explicitly state the default schema as 'public' postgres, cockroachdb βœ” should correctly synchronize schema when we explicitly state the default schema as 'public' mssql βœ” should correctly synchronize schema when we explicitly state the default schema as 'public' github issues > #176 @CreateDateColumn and @UpdateDateColumn does not read back in UTC βœ” should return dates in utc github issues > #1780 Support for insertion ignore on duplicate error βœ” should save one row without duplicate error in MySQL/MariaDB βœ” should save one row without duplicate error in PostgreSQL github issues > #1788 One to One does not load relationships. βœ” should work as expected when using find* methods with relations explicitly provided github issues > #1805 bigint PK incorrectly returning as a number (expecting a string) βœ” should return `bigint` column as string github issues > #182 enums are not saved properly βœ” should persist successfully with enum values github issues > #1825 Invalid field values being loaded with long camelCased embedded field names. βœ” should load valid values in embedded with long field names github issues > #1839 Charset and collation not being carried to JoinTable when generating migration - should carry charset and collation from original column in to junction column github issues > #184 [Postgres] Single-Inheritance not working with integer type field βœ” single table inheritance should accept a Integer Type github issues > #1863 createTable.uniques doesn't work when the columnNames only has one item βœ” should correctly create table with unique constraint (96ms) github issues > #1883 Synchronization error with default value βœ” should correctly synchronize schema with enum column github issues > #1887 Having problems with UNIQUEIDENTIFIERS βœ” should correctly insert data github issues > #1898 Simple JSON breaking in @next βœ” should correctly persist github issues > #190 too many SQL variables when using setMaxResults in SQLite βœ” should not fail if high max results is used github issues > #1901 The correct way of adding `ON UPDATE CURRENT_TIMESTAMP` clause to timestamp column βœ” should correctly create and change column with ON UPDATE expression (97ms) github issues > #1493 Error parsing pg connection string βœ” should parse url with empty password βœ” should parse url without password github issues > #1926 Update fails for entity with compound relation-based primary key on OneToMany relationship - Should update OneToMany entity with compound relation-based primary key github issues > #1929 Select attributes in Find method - mongodb βœ” return column on include in select on find βœ” return column on include in select on findAndCount βœ” return column on include in select on findByIds βœ” return column on include in select on findByIds github issues > #1960 Migration generator produces duplicated changes - should not execute any alter queries github issues > #197 Fails to drop indexes when removing fields βœ” it should drop the column and the referenced index (306ms) github issues > #1972 STI problem - empty columns βœ” should insert with userId βœ” should insert with ownerId github issues > #1981 Boolean values not casted properly when used in .find() condition βœ” should be able to find by boolean find github issues > #1997 enum type not working in postgres when defined in a custom schema βœ” should create table with ENUM column βœ” should be able to read table data with ENUM βœ” should save data with ENUM βœ” should create ENUM column and revert creation βœ” should drop ENUM column and revert drop βœ” should create table with ENUM column and revert creation βœ” should drop table with ENUM column and revert drop βœ” should change non-enum column in to ENUM and revert change βœ” should change ENUM column in to non-enum and revert change βœ” should change ENUM column and revert change βœ” should rename ENUM when column renamed and revert rename βœ” should rename ENUM when table renamed and revert rename github issues > #2005 βœ” should be able to find by boolean find github issues > #2006 Columns are being set to null after saving the entity βœ” should be able to find by boolean find github issues > #2031 Advanced find options with FKs βœ” find operators should work with relational columns as well github issues > #204 jsonb array is not persisted correctly βœ” should persist json and jsonb arrays correctly github issues > #2044 Should not double get embedded column value βœ” Insert query should work with relational columns github issues > #2065 TypeError: Cannot convert object to primitive value βœ” should save an entity created with Object.create(null) github issues > #2067 Unhandled promise rejection warning on postgres connection issues βœ” should return a catchable error on connection errors in queries github issues > #2096 [mysql] Database name isn't read from url βœ” should be possible to define a database by connection url for mysql github issues > #2103 query builder regression βœ” whereInIds should respect logical operator precedence > single simple primary key (in is used) βœ” whereInIds should respect logical operator precedence > multiple primary keys github issues > #211 where in query issue βœ” should not fail if WHERE IN expression is used github issues > #2128 skip preparePersistentValue for value functions βœ” should be able to resolve value functions github issues > #2131 InsertResult return the same primary key βœ” should get correct insert ids for multiple entities inserted github issues > #2147 Lazy load JoinColumn with multiple columns name property is ignored for second reference column - should create multiple column join for lazy loading relationship github issues > #215 invalid replacements of join conditions βœ” should not do invalid replacements of join conditions github issues > #219 FindOptions should be able to resolve null values βœ” should properly query null values github issues > #2199 - Inserting value for @PrimaryGeneratedColumn() for mysql, sqlite and mssql βœ” should allow to explicitly insert primary key value βœ” should reset mssql's INSERT_IDENTITY flag correctly after failed queries github issue > #2200 Bug - Issue with snake_case naming strategy βœ” Renammed alias allow to query correctly github issues > #2201 - Create a select query when using a (custom) junction table βœ” Should create only two PM columns ('order_id' and 'user_id') (2229ms) βœ” Should not try to update the junction table when not needed github issues > #2216 - Ability to capture Postgres notifications in logger when logNotifications option is NOT enabled βœ” should NOT pass extension setup notices to client βœ” should NOT pass manual notices to client βœ” should NOT pass 'listen -> notify' messages to client when logNotifications option is enabled βœ” should pass extension setup notices to client βœ” should pass manual notices to client βœ” should pass 'listen -> notify' messages to client βœ” should not interfere with actual queries github issues > #2251 - Unexpected behavior when passing duplicate entities to repository.save() βœ” should update all entities βœ” should handle cascade updates github issues > #2253 - inserting multiple child entities fails βœ” should be able to save multiple child entities github issues > #2259 Missing type for generated columns βœ” Should create table with generated column github issues > #2286 find operators like MoreThan and LessThan doesn't work properly for date fields βœ” should find a record by its datetime value with find options βœ” should find a record by its datetime value with query builder βœ” should save, update, and load with a date PK github issues > #2287 - QueryBuilder IN and ANY Fail with .where - Postgres βœ” should allow to explicitly insert primary key value github issues > #2298 - Repository filtering not considering related columns as filter βœ” should work perfectly github issues > #2313 - BaseEntity has no findOneOrFail() method βœ” should find the appropriate record when one exists βœ” should throw no matching record exists github issues > #2331 undefined value is nulling column on update βœ” should not overwrite column with null when passing undefined github issues > #2333 datetime column showing changed on every schema:sync run βœ” should recognize model changes βœ” should not generate queries when no model changes (95ms) github issues > #234 and #223 lazy loading does not work correctly from one-to-many and many-to-many sides βœ” should correctly load from one-to-many and many-to-one sides (41ms) βœ” should correctly load from both many-to-many sides (94ms) github issues > #2364 should generate id value if @Column generated:true is set βœ” should generate id value (1122ms) github issues > #2376 Naming single column unique constraint with decorator not working as expected βœ” should keep user-specified Unique constraint name github issues > #2434 QueryBuilder insert for Oracle failed βœ” should insert multiple rows with QueryBuilder βœ” should throw ORA-00001 error if constraint violated when inserting multiple rows βœ” should insert multiple rows of entity with generated columns with QueryBuilder βœ” should still insert one row with QueryBuilder βœ” should still insert multiple rows with save βœ” should still insert one row with save github issues > #2464 - ManyToMany onDelete option not working βœ” should not delete when onDelete is 'NO ACTION' βœ” should delete when onDelete is not set github issues > #2499 Postgres DELETE query result is useless βœ” should return correct number of affected rows for mysql, mariadb, postgres github issues > #2518 TreeRepository.findDescendantsTree does not load descendants when relationship id property exist βœ” should load descendants when findDescendantsTree is called for a tree entity βœ” should load descendants when findTrees are called github issues > #2557 object looses its prototype before transformer.to() βœ” should give correct object in transformer.to github issues > #2588 - createQueryBuilder always does left joins on relations βœ” Should allow joins with conditions github issues > #2632 createQueryBuilder relation remove works only if using ID βœ” should add and remove relations of an entity if given a mix of ids and objects github issues > #2651 set shouldn't have update statements twice when UpdateDate is in use βœ” should add and remove relations of an entity if given a mix of ids and objects github issues > #2875 Option to run migrations in 1-transaction-per-migration mode βœ” should fail to run all necessary migrations when transaction is all βœ” should be able to run all necessary migrations when transaction is each github issues > #2703 Column with transformer is not normalized for update βœ” should transform values when computing changed columns github issues > #2733 should correctly handle function calls with upercase letters as default values βœ” MSSQL, Sqljs, Sqlite βœ” Postgres github issues > #2737 MySQLDriver findChangedColumns (fields: width, precision) βœ” should not create migrations for an existing unique index when bigNumberStrings is false github issues > #2758 Insert fails when related OneToOne entity's primary key is also a foreign key - should insert person with nested new party - should insert user with nested new person - should insert a new user with existing person - should insert user with existing personId github issues > #2779 Could we add support for the MySQL/MariaDB SET data type? βœ” should create column with SET datatype βœ” should persist and hydrate sets github issues > #2800 - Can't override embedded entities in STI implementation βœ” should be able to save entity with embedded entities overriding github issues > #2809 afterUpdate subscriber entity argument is undefined βœ” if entity has been updated via repository update(), subscriber should get passed entity to change github issues > #2871 Empty enum array is returned as array with single empty string βœ” should extract array with values from enum array values from 'postgres' βœ” should extract array with one value from enum array with one value from 'postgres' βœ” should extract empty array from empty enum array from 'postgres' github issues > #2875 runMigrations() function is not returning a list of migrated files βœ” should be able to run all necessary migrations github issues > #2904 Type DeepPartial issue when used with generics βœ” DeepPartial should correctly handle generics github issues > #2927 When using base class' custom repository, the discriminator is ignored βœ” should use the correct subclass for inheritance when saving and retrieving concrete instance βœ” should work for deeply nested classes βœ” should work for saving and fetching different subclasses github issues > #2943 Inappropriate migration generated βœ” should not create migrations for unsigned numeric types with no specified width github issues > #2965 Reuse preloaded lazy relations βœ” should resuse preloaded lazy relations github issues > #2984 Discriminator conflict reported even for non-inherited tables βœ” should load entities even with the same discriminator github issues > #300 support of embeddeds that are not set βœ” embedded with custom column name should persist and load without errors github issues > #3047 Mysqsl on duplicate key update use current values βœ” should overwrite using current value in MySQL/MariaDB βœ” should overwrite using current value in PostgreSQL github issues > #306 embeddeds with custom column name don't work βœ” embedded with custom column name should persist and load without errors github issues > #3076 Postgres enum in schema with default is recreated in every new generated migration βœ” should recognize model changes βœ” should not generate queries when no model changes βœ” should handle `enumName` default change github issues > #3105 Error with cascading saves using EntityManager in a transaction βœ” error with cascading saves using EntityManager in a transaction github issues > #3111 Inserting with query builder attempts to insert a default row when values is empty array βœ” should not insert with default values on .values([]) βœ” should still error on missing .values() github issues > #3112 default:null should inserts nulls to database βœ” should insert null when no value specified github issues > #9316 specify how should interpret null and undefined values in conditions βœ” should find users what money is not null and money is more than 10 and money is less than 100 github issues > #3118 shorten alias names (for RDBMS with a limit) when they are longer than 63 characters βœ” should be able to load deeply nested entities, even with long aliases (87ms) βœ” should shorten table names which exceed the max length github issues > #3120 Add relation option "createForeignKeyConstraints" βœ” should create foreign key for relation without createForeignKeyConstraints option βœ” should not create foreign key for relation with createForeignKeyConstraints equal false relation with createForeignKeyConstraints equal false βœ” should work perfectly github issues > #3142 Unique constraint not created on embedded entity field βœ” should create unique constraint on embedded entity github issues > #3151 'uuid' in PrimaryGeneratedColumn causes Many-to-Many Relationship to Fail βœ” should work correctly github issues > #3158 Cannot run sync a second time βœ” can recognize model changes github issues > #320 Bug in getManyAndCount βœ” should correctly parse type from PrimaryGeneratedColumn options github issues > #3246 Saving an entity with a 1:1 cascading insert does not return id if entity has nullable many:one relationship βœ” should insert and return the order with id github issues > #3256 wrong subscriber methods being called βœ” if entity was changed, subscriber should be take updated columns github issues > #3349 Multiple where conditions with parameters βœ” should work with query builder βœ” should work with findOne github issues > #3350 ER_DUP_FIELDNAME with simple find βœ” should find without errors github issues > #3352 sync drops text column βœ” should not drop text column github issues > #3363 Isolation Level in transaction() from Connection - should execute operations in READ UNCOMMITED isolation level - should execute operations in SERIALIZABLE isolation level github issues > #3374 Synchronize issue with UUID (MySQL) βœ” should not drop primary column again github issues > #3379 Migration will keep create and drop indexes if index name is the same across tables βœ” should not recreate indices (259ms) github issues > #3387 named columns βœ” should allow inserting named columns github issues > #3395 Transform.from does nothing when column is NULL βœ” should run transform from if column is null github issues > #341 OneToOne relation with referencedColumnName does not work βœ” custom join column name and referencedColumnName github issues > #3416 Unknown fields are stripped from WHERE clause should throw FindCriteriaNotFoundError when supplying unknown property in where criteria βœ” find βœ” update βœ” delete github issues > #3422 cannot save to nested-tree table if schema is used in postgres βœ” should not fail when using schema and nested-tree github issues > #3443 @JoinTable on entities without synchronization βœ” Should set synchronize: false for @JoinTable when passed to options github issues > #345 Join query on ManyToMany relations not working βœ” embedded with custom column name should persist and load without errors (50ms) github issues > #3496 jsonb comparison doesn't work βœ” the entity should not be updated a second time github issues > #352 double precision round to int in mssql βœ” real number should be successfully stored and loaded from db including value in parameters github issues > #3534: store regexp βœ” allows entities with regexp columns github issues > #3536 Sync only works once for enums on entities with capital letters in entity name βœ” should run without throw error github issues > #3551 array of embedded documents through multiple levels are not handled βœ” should return entity with all these embedded documents github issues > #3587 do not generate change queries for number based enum types every time βœ” should NOT generate change queries in case enum is not changed github issues > #3588 Migration:generate issue with onUpdate using mysql 8.0 βœ” can recognize model changes github issues > #3604 FK columns have wrong length when PrimaryGeneratedColumn('uuid') is used. βœ” join column should have the same length with primary column github issues > #363 Can't save 2 unrelated entity types in a single persist call βœ” entityManager should allow you to save unrelated entities with one persist call βœ” entityManager should allow you to delete unrelated entities with one remove call github issues > #3636 synchronize drops (and then re-adds) json column in mariadb βœ” should not drop json column github issues > #3685 Brackets syntax failed when use where with object literal βœ” should accept objects in .where method (github issue #3685) github issues > #3694 Sync enums on schema sync βœ” should change schema when enum definition changes (228ms) github issues > #3702 MySQL Spatial Type Support : GeomFromText function is not supported when legacySpatialSupport: true - should use GeomFromText - should provide SRID - should use AsText when legacySpatialSupport: false - should use ST_GeomFromText - should provide SRID - should use ST_AsText github issues > #3737 Should URL-decode the user info of a data source URI βœ” should parse URL with percent-encoded username βœ” should parse URL with percent-encoded password github issues > #3783 Tree functionality broken βœ” should work correctly github issues > #3803 column option unique sqlite error βœ” should create unique constraints defined in EntitySchema github issues > #3828 Conflicting PR to fix postgres schema:log with uppercase table names and enums βœ” schema sync should work when enum type name was changed github issues > #3847 FEATURE REQUEST - Naming strategy foreign key override name βœ” NamingStrategyUnderTest# github issues > #3857 Schema inheritance when STI pattern is used βœ” Child classes should have same schema as parent github issues > #3874 Using an (empty string) enum as the type of a primary key column βœ” should reload entity github issues > #388 skip and take with string ID don't work βœ” should load posts with string id successfully github issues > #3946 loadRelationCountAndMap fails cause made a wrong IN calculation, when primary key is string βœ” should load relation count on owner side βœ” should load relation count on owner side with limitation βœ” should load relation count on owner side with additional conditions (54ms) βœ” should load relation count on both sides of relation βœ” should load relation count on inverse side βœ” should load relation count on inverse side with limitation βœ” should load relation count on inverse side with additional conditions github issues > #3949 sqlite date hydration is susceptible to corruption βœ” should correctly read date column that was inserted raw in canonical format βœ” should correctly read date column that was inserted raw in iso 8601 format github issues > #3991 Migration keeps changing @CreateDateColumn/@UpdateDateColumn timestamp column to same definition postgres βœ” should recognize model changes βœ” should not generate queries when no model changes cockroachdb βœ” should recognize model changes βœ” should not generate queries when no model changes oracle βœ” should recognize model changes βœ” should not generate queries when no model changes sqlite βœ” should recognize model changes βœ” should not generate queries when no model changes mysql, mariadb βœ” should recognize model changes βœ” should not generate queries when no model changes (93ms) mssql βœ” should recognize model changes βœ” should not generate queries when no model changes github issues > #3997 synchronize=true always failing when using decimal column type with a foreign key constraint βœ” should recognize model changes βœ” should not generate queries when no model changes (1808ms) github issues > #401 special keywords should be escaped in join queries βœ” should escape 'group' keyword properly github issues > #4060 Fail to insert entity with Buffer type of primary column under some circumstances. βœ” should save entities github issues > #4096 SQLite support for orUpdate βœ” should overwrite using current value in SQLite github issues > #4106 Specify enum type name in postgres βœ” should create an enum with the name specified in column options -> enumName βœ” should insert data with the correct enum github issues > #4147 `SQLITE_ERROR: near "-": syntax error` when use sqlite, simple-enum βœ” should not error while synchronizing when using simple-enum with sqlite github issues > #4156 QueryExpressionMap doesn't clone all values correctly βœ” should not error when the query builder has been cloned βœ” should not error when the query builder with where statement has been cloned github issues > #4185 afterLoad() subscriber interface missing additional info available on other events βœ” should invoke afterLoad() with LoadEvent github issues > #4190 Relation decorators: allow to pass string instead of typeFunction βœ” should work with one-to-one relations βœ” should work with many-to-one/one-to-many relations βœ” should work with many-to-many relations github issues > #4219 class-transformer-shim: support metadata reflection βœ” should create instances with the correct property types github issues > #4220 Fix the bug when using buffer as the key. βœ” should use the hex string format of buffer when the primary column is buffer type. github issues > #423 Cannot use Group as Table name && cannot autoSchemeSync when use alias Entity βœ” should successfully sync schema (94ms) github issues > #4277 Using cache in findAndCount and getManyAndCount returns 0 as count βœ” getManyAndCount and findAndCount should count correctly when using cacheId βœ” getManyAndCount and findAndCount should count correctly when NOT using cacheId βœ” getManyAndCount and findAndCount should count correctly when NOT using cache github issues > #433 default value (json) is not getting set in postgreSQL βœ” should successfully set default value in to JSON type column github issues > #438 how can i define unsigned column? - should correctly create and change column with UNSIGNED and ZEROFILL attributes github issues > #4410 allow custom filepath for FileLogger when no option is passed βœ” writes to the base path when logPath option is passed as a file βœ” writes to the given filename when logPath option is passed as a nested path βœ” writes to the given path github issues > #4415 allow beautify generated migrations - writes regular migration file when no option is passed - writes pretty printed file when pretty option is passed github issues > #4452 InsertQueryBuilder fails on some SQL Expressions values βœ” should be able to use sql functions github issues > #4513 CockroachDB support for onConflict βœ” should insert if no conflict βœ” should update on conflict with do update βœ” should not update on conflict with do nothing βœ” should update with orUpdate github issues > #4570 Fix PrimaryColumn decorator modifies passed option βœ” should not modify passed options to PrimaryColumn github issues > #463 saving empty string array βœ” should not return array with single empty string if empty array was saved github issues > #4630 Enum string not escaping resulting in broken migrations. βœ” should support enums of strings with apostrophes in them github issues > #4658 Renaming a column with current_timestamp(6) results in broken SQL βœ” should correctly rename column and revert rename (372ms) βœ” should correctly remove column and revert it back (672ms) github issues > #4697 Revert migrations running in reverse order. βœ” should revert migrations in the right order github issues > #47 wrong sql syntax when loading lazy relation βœ” should persist successfully and return persisted entity github issues > #4701 Duplicate migrations are executed. βœ” should throw error if there're duplicate migrations github issues > #4719 HStore with empty string values βœ” should handle HStore with empty string keys or values βœ” should not allow 'hstore injection' github issues > #4753 MySQL Replication Config broken - should connect without error when using replication mssql > add lock clause for MSSQL select with join clause βœ” should not have Lock clause βœ” should have WITH (NOLOCK) clause βœ” should have two WITH (NOLOCK) clause βœ” should have three WITH (NOLOCK) clause βœ” should have three WITH (NOLOCK) clause (without relation) βœ” should have WITH (HOLDLOCK, ROWLOCK) clause βœ” should have WITH (UPLOCK, ROWLOCK) clause βœ” should have two WITH (UPDLOCK, ROWLOCK) clause github issues > #4782 mariadb driver wants to recreate create/update date columns CURRENT_TIMESTAMP(6) === current_timestamp(6) βœ” should not want to execute migrations twice VersionUtils isGreaterOrEqual βœ” should return false when comparing invalid versions βœ” should return false when targetVersion is larger βœ” should return true when targetVersion is smaller βœ” should work with mariadb-style versions github issues > #479 orWhere breaks skip / take βœ” where expression of the skip/take should not break original where query github issues > #4842 QueryExpressionMap doesn't clone distinct property βœ” should contain correct distinct value after query builder is cloned github issues > #485 If I set the datatype of PrimaryGeneratedColumn to uuid then it is not giving the uuid to the column. βœ” should persist uuid correctly when it used as PrimaryGeneratedColumn type github issues > #4897 [MSSQL] Enum column definition removes and recreates constraint overwritting existing data βœ” should recognize model changes βœ” should not generate queries when no model changes github issues > #493 pagination should work with string primary keys βœ” should work perfectly with string primary keys github issues > #4947 beforeUpdate subscriber entity argument is undefined βœ” if entity has been updated via repository update(), subscriber should get passed entity to change github issues > #495 Unable to set multi-column indices βœ” should successfully create indices and save an object github issues > #4956 create typeorm_metatable when running migrations. βœ” should create typeorm_metadata table when running migrations with views (657ms) βœ” should not create typeorm_metadata table when running migrations if there are no views (751ms) github issues > #4958 getRepository returns results from another Repo βœ” sql generated is for correct model github issues > #4980 (Postgres) onUpdate: 'CASCADE' doesn't work on many-to-many relation βœ” should generate onDelete: CASCADE and onUpdate: CASCADE for 'books' side of many-to-many relation βœ” should generate onDelete: NO ACTION and onUpdate: CASCADE for 'authors' side of many-to-many relation βœ” should generate onDelete: NO ACTION and onUpdate: CASCADE for foreign key pointing to Book βœ” should generate onDelete: CASCADE and onUpdate: CASCADE for foreign key pointing to Author github issues > #499 postgres DATE hydrated as DATETIME object βœ” should return date in a string format github issues > #5004 expireAfterSeconds 0 can't be passed to Index decorator βœ” should allow expireAfterSeconds 0 to be passed to Index decorator github issues > #5067 ORA-00972: identifier is too long βœ” generated parameter name is within the size constraints github issues > #5119 migration with foreign key that changes target βœ” should generate a drop and create step github issues > #512 Table name escaping in UPDATE in QueryBuilder βœ” should escape table name using driver's escape function in UPDATE github issues > #513 Incorrect time/datetime types for SQLite βœ” should create datetime column type for datetime in sqlite βœ” should persist correct type in datetime column in sqlite βœ” should create datetime column type for time in sqlite βœ” should persist correct type in datetime column in sqlite github issues > #5132: Default of -1 (minus 1) generates useless migrations` -1 (minus 1) in default value βœ” can recognize model changes βœ” does not generate when no model changes github issues > #5160 (MSSQL) DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause βœ” should update entity model after insertion to MSSQL table with trigger βœ” should update entity model after save to MSSQL table with trigger github issues > #5174 `selectQueryBuilder.take` messes up the query when using the `ids` parameter βœ” should allow the 'ids' parameter without messing up the query when using .take github issues > #521 Attributes in UPDATE in QB arent getting replaced βœ” should replace parameters github issues > #5275 Enums with spaces are not converted properly. βœ” should correctly parse enums of strings with spaces βœ” should correctly parse non-array enums with spaces github issues > #5365 Generated Identity for Postgres 10+ βœ” should produce proper SQL for creating a table with identity column github issues > #5407 Wrong migration created because of default column value format βœ” can recognize model changes βœ” does not generate when no model changes (116ms) github issues > #5444 EntitySchema missing support for multiple joinColumns in relations βœ” Update query returns the number of affected rows github issues > #5478 Setting enumName doesn't change how migrations get generated βœ” should correctly rename enum github issues > #5501 Incorrect data loading from JSON string for column type 'simple-json' βœ” should correctly store simple-json field βœ” should correctly retrieve simple-json field βœ” should throw an error when the data in the database is invalid github issues > #5520 save does not return generated id if object to save contains a many to one relationship with an undefined id βœ” should generate parents and childs uuid and return them github issues > #56 relationships only work when both primary keys have the same name - should persist successfully and return persisted entity github issues > #5684 eager relation skips children relations βœ” should select children of an eager relation (61ms) github issues > #5691 RelationId is too slow βœ” should be as fast as separate queries (306ms) github issues > #57 cascade insert not working with OneToOne relationship βœ” should persist successfully from inverse side github issues > #5734 insert([]) should not crash βœ” should not crash on insert([]) βœ” should still work with a nonempty array github issues > #5762 `Using URL as a rich column type breaks βœ” should allow assigning URL as a field value github issues > #58 relations with multiple primary keys βœ” should persist successfully and return persisted entity github issues > #587 Ordering of fields in composite indexes defined using Index decorator βœ” should preserve field ordering when fields are specified as string[] github issues > #5871 Migration generate does not play well with mysql enum with parentheses in the enum value βœ” should recognize model changes βœ” should not generate queries when no model changes (117ms) github issues > #5898 Postgres primary key of type uuid: default value migration/sync not working βœ” should add DEFAULT value when @PrimaryGeneratedColumn('increment') is added βœ” should remove DEFAULT value when @PrimaryGeneratedColumn('increment') is removed βœ” should add DEFAULT value when @PrimaryGeneratedColumn('uuid') is added βœ” should remove DEFAULT value when @PrimaryGeneratedColumn('uuid') is removed github issues > #5919 Caching won't work with replication enabled βœ” should not another queryRunner for cache with a given masterQueryRunner βœ” should create another queryRunner for cache with a given slaveQueryRunner github issues > #594 WhereInIds no longer works in the latest version. βœ” should load entities by given simple post ids (non mixed) github issues > #6066 Column comment string is not escaped during synchronization βœ” should synchronize (90ms) github issues > #609 Custom precision on CreateDateColumn and UpdateDateColumn βœ” should create `CreateDateColumn` and `UpdateDateColumn` column with custom default github issues > #6115 Down migration for enums with defaults are wrong βœ” should change schema when enum definition changes github issues > #6168 fix multiple foreign keys with the same name in a mysql multi-tenanted DB βœ” should only have one foreign key column github issues > #6195 feature: fake migrations for existing tables fake run tests βœ” should fail for duplicate column βœ” should not fail for duplicate column when run with the fake option fake rollback tests βœ” should fail for non-existent column βœ” should not fail for non-existent column when run with the fake option github issues > #620 Feature Request: Flexibility in Foreign Key names βœ” should work as expected github issues > #6265 `fix: resolve issue with find with relations returns soft-deleted entities βœ” should soft delete one record in relation table github issues > #6266 Many identical selects after insert bunch of items βœ” should execute a single SELECT to get inserted default and generated values of multiple entities github issues > #6284 cli support for cjs extension βœ” will load a cjs file βœ” loads cjs files via DirectoryExportedClassesloader github issues > #6327 softRemove DeleteDateColumn is null at Susbscriber's AfterUpdate method βœ” should send correct update and delete date columns to after update subscriber github issues > #6389 MongoDB URI Connection string with query params βœ” should parse correctly mongodb URI github issues > #6399 Process extraAppendedAndWhereCondition for inherited entity βœ” Query with join and limit for inhered entity github issues > #6412 Generating migrations when having entities with CreateDateColumn/UpdateDateColumn and default values as CURRENT_TIMESTAMP leads to a lot of redundant queries in resulting migrations βœ” should recognize model changes βœ” should not generate queries when no model changes (99ms) github issues > #6399 Combining ManyToOne, Cascade, & Composite Primary Key causes Unique Constraint issues βœ” persisting the cascading entities should succeed βœ” persisting the cascading entities without JoinColumn should succeed βœ” persisting the child entity should succeed github issues > #6442 JoinTable does not respect inverseJoinColumns referenced column width βœ” should generate column widths equal to the referenced column widths github issues > #6471 Postgres enum is recreated in every new generated migration βœ” should recognize model changes βœ” should not generate queries when no model changes βœ” should handle `enumName` change github issues > #6540 Enum not resolved if it is from an external file βœ” should recognize model changes βœ” should not generate queries when no model changes (194ms) github issues > #6552 MongoRepository delete by ObjectId deletes the wrong entity βœ” should delete the correct entity when id column is called _id βœ” should delete the correct entity when id column is not called _id βœ” should delete the correct entity when deleting by _id query github issues > #6580 DeepPartial does not handle `any` and `{[k: string]}` βœ” DeepPartial should correctly handle any βœ” DeepPartial should correctly handle {[k: string]: any} github issues > #660 Specifying a RETURNING or OUTPUT clause with QueryBuilder βœ” should create an INSERT statement, including RETURNING or OUTPUT clause (PostgreSQL and MSSQL only) βœ” should perform insert with RETURNING or OUTPUT clause (PostgreSQL and MSSQL only) βœ” should create an UPDATE statement, including RETURNING or OUTPUT clause (PostgreSQL and MSSQL only) βœ” should perform update with RETURNING or OUTPUT clause (PostgreSQL and MSSQL only) βœ” should create a DELETE statement, including RETURNING or OUTPUT clause (PostgreSQL and MSSQL only) βœ” should perform delete with RETURNING or OUTPUT clause (PostgreSQL and MSSQL only) github issues > #6633 Fulltext indices continually dropped & re-created - should not create migrations for fulltext indices github issues > #6636 migration issues with scale & precision βœ” should not create migrations columns with precision github issues > #6699 MaxListenersExceededWarning occurs on Postgres βœ” queries in a transaction do not cause an EventEmitter memory leak github issues > #6714 Migration:generate issue with onUpdate using mariadb 10.4 βœ” dont change anything βœ” recognizing on update changes github issues > #6752 column name not been find on unique index decorator βœ” dont change anything github issues > #6815 RelationId() on nullable relation returns 'null' string βœ” should return null as childId if child doesn't exist βœ” should return string as childId if child exists github issues > #6833 Entities with JSON key columns are incorrectly grouped βœ” jsonB keys are correctly resolved βœ” jsonB keys can be found βœ” jsonB keys can be found with IN βœ” jsonB keys can be found regardless of order github issues > #6900 MongoDB ConnectionManager doesn't select given database, creates new database "test" instead βœ” should connect to the expected database βœ” should write data to the correct database github issues > #6947 Custom primary column for TreeRepository based entities unable to get tree descendants βœ” entities with custom primary column names should work github issues > #6948 TreeRepository's findRoots query incorrectly when using a custom primary key βœ” entity parent column should work with custom primary column names github issues > #695 Join columns are not using correct length βœ” should set correct length on to join columns github issues > #6950 postgres: Inappropiate migration generated for `default: null` null default βœ” can recognize model changes βœ” does not generate when no model changes (112ms) null default and nullable βœ” can recognize model changes βœ” does not generate when no model changes (120ms) github issues > #6958 Promises never get resolved in specific cases βœ” should release all used query runners upon disconnection github issues > #6977 Relation columns in embedded entities are not prefixed βœ” should correctly assign foreign key columns in embedded entity github issues > #6990 synchronize drops array columns in postgres if a length is set βœ” should not drop varchar array column on synchronize using postgres driver github issues > #6995 Generating migrations for UpdateDateColumn should generate on update clause βœ” should create migration with default ON UPDATE clause github issues > #70 cascade deleting works incorrect βœ” should persist successfully and return persisted entity github issues > #7002 cascade save fails if the child entity has CreateDateColumn and PK as JoinColumn - save an entity having a child entity with shared PK and CreatedDateColumn by cascade github issues > #703.findOne does not return an empty array on OneToMany relationship βœ” should not return anything in joined relation if nothing was found (1505ms) github issues > #7030 βœ” should insert and fetch from the expected column github issues > #704 Table alias in WHERE clause is not quoted in PostgreSQL βœ” should return user by a given email and proper escape 'user' keyword github issues > #7041 When requesting nested relations on foreign key primary entities, relation becomes empty entity rather than null βœ” should return null when requested nested relations are empty on OneToOne relation βœ” should return [] when requested nested relations are empty on OneToMany relation github issues > #7065 ChildEntity type relationship produces unexpected results βœ” should join child entity with discriminator value condition github issues > #7068 βœ” categories should be attached via parent and saved properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly and everything must be saved in cascades - categories should remove removed children - sub-category should be removed with all its children github issues > #7079 Error when sorting by an embedded entity while using join and skip/take βœ” should be able to getMany with join and sorting by an embedded entity column while user take and skip github issues > #7087 Allow to specify transaction property for individual migrations βœ” should fail to run all necessary migrations when transaction is all and there are transaction overrides βœ” should set correct transaction mode when transaction is each βœ” should set correct transaction mode when transaction is none github issues > #71 ManyToOne relation with custom column name persistence fails βœ” should persist successfully entity successfully with its many-to-one relation github issues > #7100 MSSQL error when user requests additional columns to be returned βœ” should return user requested columns github issues > #7106 shorten sequence names (for RDBMS with a limit) when they are longer than 63 characters βœ” should be able to work with long sequence name with short table name βœ” should be able to work with long sequence name with long table name github issues > #7109 stream() bug from 0.2.25 to 0.2.26 with postgresql βœ” should release the QueryRunner created by a SelectQueryBuilder github issues > #7110: Typeorm Migrations ignore existing default value on column` double type conversion in default value βœ” can recognize model changes βœ” does not generate when no model changes github issues > #7113 Soft deleted docs still being pulled in Mongodb βœ” should not pull soft deleted docs with find βœ” should not pull soft deleted docs with findAndCount βœ” should not pull soft deleted docs with findOne github issues > #7146 Lazy relations resolve to 'undefined' instead of 'null' lazy-loaded relations βœ” should return null if ManyToOne relation has NULL in database βœ” should return null if OneToOne+JoinColumn relation has NULL in database βœ” should return null if OneToOne relation has NULL in database lazy-loaded relations included in 'relations' find option βœ” should return null if ManyToOne relation has NULL in database βœ” should return null if OneToOne+JoinColumn relation has NULL in database βœ” should return null if OneToOne relation has NULL in database eager-loaded relations βœ” should return null if ManyToOne relation has NULL in database βœ” should return null if OneToOne+JoinColumn relation has NULL in database βœ” should return null if OneToOne relation has NULL in database github issues > #7155 - (Closure/SingleID/Save) Update without parent - (Closure/SingleID/Save) Update without tree change - (Closure/SingleID/Save) Set leaf entity as root - (Closure/SingleID/Save) Move leaf with multi root - (Closure/SingleID/Save) Move branch with single root - (Closure/SingleID/Save) Move branch with single root via children - (Closure/SingleID/Save) Move multiple branches with single root via children - (Closure/SingleID/Save) Remove and re-add parent - (Closure/SingleID/Remove) Remove leaf with multi root - (Closure/SingleID/Remove) Remove branch with single root - (Closure/SingleID/Remove) Remove multiple branches with single root - (Nested/SingleID/Save) Update without tree change - (Nested/SingleID/Save) Set multiple root entities - (Nested/SingleID/Save) Set leaf entity as root - (Nested/SingleID/Save) Move leaf with single root - (Nested/SingleID/Save) Move branch with single root - (Nested/SingleID/Save) Move branch with single root via children - (Nested/SingleID/Save) Move multiple branches with single root via children - (Nested/SingleID/Remove) Remove leaf with single root - (Nested/SingleID/Remove) Remove branch with single root - (Nested/SingleID/Remove) Remove multiple branches with single root - (Materialized/SingleID/Save) Update without parent - (Materialized/SingleID/Save) Update without tree change - (Materialized/SingleID/Save) Set leaf entity as root - (Materialized/SingleID/Save) Move leaf with multi root - (Materialized/SingleID/Save) Move branch with single root - (Materialized/SingleID/Save) Move branch with single root via children - (Materialized/SingleID/Save) Move multiple branches with single root via children - (Materialized/SingleID/Remove) Remove leaf with multi root - (Materialized/SingleID/Remove) Remove branch with single root - (Materialized/SingleID/Remove) Remove multiple branches with single root - (Nested/MultiID/Save) Update without tree change - (Nested/MultiID/Save) Set multiple root entities - (Nested/MultiID/Save) Set leaf entity as root - (Nested/MultiID/Save) Move leaf with single root - (Nested/MultiID/Save) Move branch with single root - (Nested/MultiID/Save) Move branch with single root via children - (Nested/MultiID/Save) Move multiple branches with single root via children - (Nested/MultiID/Remove) Remove leaf with single root - (Nested/MultiID/Remove) Remove branch with single root - (Nested/MultiID/Remove) Remove multiple branches with single root - (Materialized/MultiID/Save) Update without parent - (Materialized/MultiID/Save) Update without tree change - (Materialized/MultiID/Save) Set leaf entity as root - (Materialized/MultiID/Save) Move leaf with multi root - (Materialized/MultiID/Save) Move branch with single root - (Materialized/MultiID/Save) Move branch with single root via children - (Materialized/MultiID/Save) Move multiple branches with single root via children - (Materialized/MultiID/Remove) Remove leaf with multi root - (Materialized/MultiID/Remove) Remove branch with single root - (Materialized/MultiID/Remove) Remove multiple branches with single root github issues > #7155 > tree relations βœ” (Closure) Validate relations βœ” (Nested) Validate relations βœ” (Materialized) Validate relations github issues > #720 `.save()` not updating composite key with Postgres βœ” should not insert new entity when entity already exist with same primary keys βœ” reproducing second comment issue github issues > #7203 QueryExpressionMap doesn't clone comment field βœ” should be able to clone comment field github issues > #7217 Modifying enum fails migration if the enum is used in an array column βœ” should not generate queries when no model changes βœ” should correctly change enum github issues > #7235 Use "INSERT...RETURNING" in MariaDB. βœ” should allow `DELETE...RETURNING` on MariaDB >= 10.0.5 βœ” should allow `INSERT...RETURNING` on MariaDB >= 10.5.0 github issues > #7266 rename table typeorm_metadata name. βœ” should create the typeorm metadata table with a custom name when provided βœ” should have correct views using the custom named metadata table github issues > #7276 Schema sync not able to find diff correctly and executes same queries on every run postgres βœ” should recognize model changes βœ” should not generate queries when no model changes mssql βœ” should recognize model changes βœ” should not generate queries when no model changes github issues > #7283 Generating Migration on ManyToOne/OneToMany + Primary enum column results in missing enum type in migration output βœ” should create tables with enum primary column (2555ms) github issues > #736 ClosureEntity should set (composite) primary/unique key in the closure table βœ” should create composite primary key on closure ancestor and descendant github issues > #7381 Infinite same ALTERs upon startup (mysql, ver 0.2.30) βœ” should recognize model changes βœ” should not generate queries when no model changes (129ms) github issues > #7401 MongoDB replica set connection string not support with method "parseConnectionUrl" & "buildConnectionUrl" βœ” should parse replicaSet and host list in ConnectionUrl github issues > #7415 Tree entities with embedded primary columns are not built correctly βœ” should build tree entities with embedded primary columns correctly (43ms) github issues > #7437 MongoDB options never parse in connectionUrl and after my fix was parse incorrect βœ” should parse options in ConnectionUrl github issues > #7479 Only first single quote in comments is escaped βœ” should properly escape quotes in comments github issues > #750 Need option for Mysql's full text search - should correctly create SPATIAL and FULLTEXT indices github issues > #752 postgres - count query fails for empty table βœ” should return user by a given email and proper escape 'user' keyword github issues > #7521 Only first is removed in comments, only first \ is escaped etc. βœ” should recognize model changes βœ” should not generate queries when no model changes (152ms) βœ” should properly escape quotes in comments github issues > #7523 Do not create duplicate CREATE TYPE migration query when same 'enumName's are exists βœ” should recognize model changes βœ” should not generate queries when no model changes github issues > #7541 Column of type `enum` throws missing properties error βœ” should recognize model changes βœ” should not generate queries when no model changes github issues > #7558 Child entities' wrong discriminator value when embedded in parent entity βœ” should use the correct subclass for inheritance when saving & retrieving a single STI entity (one-to-one) βœ” should use the correct subclass for inheritance when saving & retrieving multiple STI entities (one-to-many) βœ” should set the correct discriminators for trees in STI settings github issues > #7586 Oddly indexed views are not dropped in migration βœ” should generate drop queries for all views github issues > #7614 Postgres: Custom enum name results in field recreate βœ” should recognize model changes βœ” should not generate queries when no model changes github issues > #762 Nullable @Embedded inside @Embedded βœ” should work perfectly with all data set βœ” should work perfectly with some data not set βœ” should work perfectly without any data set github issues > #7647 Duplicate migrations when using 'enumName' ColumnOption in an 'enum' type Postgres βœ” should recognize model changes βœ” should not generate queries when no model changes github issues > #7650 Inappropriate migration generated βœ” should not create migrations for json default which are equivalent github issues > #7651 Enum that contains functions is not accordingly translated to SQL entity βœ” should correctly save and retrieve enum fields when declaration merging technique is used and enum contains functions βœ” should correctly save and retrieve enum array schema βœ” should contain SQL for enum type without function github issues > #7662 postgres extensions installation should be optional - should NOT install extensions if option is disabled - should install extensions if option is undefined - should install extensions if option is enabled github issues > #7698 MariaDB STORED columns don't accept [NULL | NOT NULL] βœ” should not generate queries with NULL or NOT NULL for stored columns in mariadb github issues > #773 @PrimaryGeneratedColumn not returning auto generated id from oracle database βœ” should return auto generated column github issues > #7760 Mongodb: When field is null in db, typeorm query sets it to undefined βœ” should delete all documents related to search pattern github issues > #778 TypeORM is ignoring the `type` field when set on a PrimaryGeneratedColumn βœ” should correctly parse type from PrimaryGeneratedColumn options github issues > #7788 MongoDB update make changes only to first matched document βœ” should update all documents related to search pattern github issues > #7809 MongoDB delete make changes only to first matched document βœ” should delete all documents related to search pattern github issues > #7851 Updating (using save method) a ManyToOne relation sets the object.relation_id to null βœ” should update the message.user_id to the new value github issues > #7852 saving a ManyToMany relation tries to insert (DEFAULT, entity2.id) instead of (entity1.id, entity2.id), when id is Buffer βœ” should insert (entity1.id, entity2.id) github issues > #7867 Column not renamed when schema/database is set schema is set βœ” should correctly change column name database is set βœ” should correctly change column name (586ms) github issues > #7882 .findOne reduces relations to an empty array βœ” should delete all documents related to search pattern github issues > #7907 add support for mongodb driver v5 βœ” should find the Post without throw error: Cannot read property 'prototype' of undefined github issues > #7932 non-ascii characters assigned to var/char columns in SQL are truncated to one byte βœ” should store non-ascii characters in var/char without data loss - should throw an error if characters in a string are too long to store βœ” should not change char or varchar column types to nchar or nvarchar github issues > #7974 Adding relations option to findTrees() βœ” should return tree without sites relations βœ” should return tree with sites relations github issues > #799 sqlite: 'database' path should be created βœ” should create the whole path to database file βœ” should create the whole path to database file for better-sqlite3 github issues > #80 repository.save fails when empty array is sent to the method βœ” should persist successfully and return persisted entity βœ” should not fail if empty array is given to persist method github issues > #8011 Enum values with multiple apostrophes not properly escaped in MySQL βœ” should properly escape all apostrophes (124ms) github issues > #8018 Non-unique relation property names causes entity mixup in query results βœ” should create child entities of the correct type github issues > #8026 Inserting a value for a column that has a relation, and is also a date, results in the value being inserted as DEFAULT βœ” it should include a related date column in the constructed query github issues > #807 Error in persisting dates βœ” should be able to save dates as objects βœ” should be able to save dates as strings github issues > #8076 Add relation options to all tree queries (missing ones) βœ” should return tree without sites relations βœ” should return tree with sites relations βœ” should return roots without member relations βœ” should return roots with member relations βœ” should return descendants without member relations βœ” should return descendants with member relations βœ” should return descendants tree without member relations βœ” should return descendants tree with member relations βœ” should return ancestors without member relations βœ” should return ancestors with member relations βœ” should return ancestors tree without member relations βœ” should return ancestors tree with member relations github issues > #813 order by must support functions βœ” should work perfectly βœ” should work perfectly with pagination as well github issues > #815 @RelationId properties are not updated after entity saving βœ” should work perfectly with many-to-one relation βœ” should work perfectly with one-to-many relation βœ” should work perfectly with many-to-many relation βœ” should work perfectly with many-to-many relation (inverse side) github issues > #8158 Typeorm creates migration that creates already existing unique constraint βœ” should recognize model changes βœ” should not generate queries when no model changes (713ms) github issues > #8221 βœ” afterLoad entity modifier must not make relation key matching fail github issues > #8273 Adding @Generated('uuid') doesn't update column default in PostgreSQL βœ” should add DEFAULT value when @Generated('increment') is added βœ” should remove DEFAULT value when @Generated('increment') is removed βœ” should add DEFAULT value when @Generated('uuid') is added βœ” should remove DEFAULT value when @Generated('uuid') is removed github issues > #8346 MySQL: Regression when using take, orderBy, and getMany on a joined relation βœ” should return customers ordered by contacts github issues > #836 .save won't update entity when it contains OneToOne relationship βœ” should work perfectly github issues > #8370 Add support for Postgres GENERATED ALWAYS AS IDENTITY βœ” should produce proper SQL for creating a column with `BY DEFAULT` identity column github issues > #838 Time zones for timestamp columns are incorrectly fetched and persisted in PostgreSQL - should return date & time stored in PostgreSQL database correctly - should persist date & time to the PostgreSQL database correctly github issues > #8393 When trying to update `update: false` column with `@UpdateDateColumn` the update column is updated βœ” should not update the @UpdateDateColumn column when trying to update un-updatable column github issues > #8398 Separate update event into the update, soft remove and restore events βœ” should trigger different events for update, soft remove, and recover persistence > delete orphans when a Post is removed from a Category βœ” should retain a Post on the Category βœ” should mark orphaned Post as soft-deleted βœ” should retain foreign keys on remaining Posts github issues > #8430 sqlite temporary tables do not honor withoutRowid βœ” should keep 'withoutRowid' after table recreation github issues > #8443 QueryFailedError when tree entity with JoinColumn > closure-table βœ” categories should be attached via parent and saved properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly and everything must be saved in cascades - categories should remove removed children - sub-category should be removed with all its children βœ” findTrees() tests > findTrees should load all category roots and attached children βœ” findTrees() tests > findTrees should load multiple category roots if they exist βœ” findTrees() tests > findTrees should filter by depth if optionally provided (39ms) βœ” findDescendantsTree() tests > findDescendantsTree should load all category descendents and nested children βœ” findDescendantsTree() tests > findDescendantsTree should filter by depth if optionally provided (55ms) github issues > #8443 QueryFailedError when tree entity with JoinColumn > materialized-path βœ” attach should work properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly and everything must be saved in cascades βœ” findTrees() tests > findTrees should load all category roots and attached children βœ” findTrees() testsfindTrees should load multiple category roots if they exist βœ” findTrees() testsfindTrees should filter by depth if optionally provided (52ms) βœ” findDescendantsTree() tests > findDescendantsTree should load all category descendents and nested children βœ” findDescendantsTree should filter by depth if optionally provided github issues > #8443 QueryFailedError when tree entity with JoinColumn > nested-set βœ” attach should work properly (43ms) βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly βœ” categories should be attached via children and saved properly and everything must be saved in cascades βœ” findTrees() tests > findTrees should load all category roots and attached children βœ” findTrees() tests > findTrees should filter by depth if optionally provided (43ms) βœ” findTrees() tests > findTrees should present a meaningful error message when used with multiple roots + nested sets βœ” findDescendantsTree() tests > findDescendantsTree should load all category descendents and nested children βœ” findDescendantsTree() tests > findDescendantsTree should filter by depth if optionally provided github issues > #8444 entitySkipConstructor not working without entitySkipConstructor βœ” createTestingConnections should fail with 'someColumn cannot be undefined.' with entitySkipConstructor βœ” createTestingConnections should succeed (342ms) github issues > #8459 Can not create indexes of materialized views βœ” should create a materialized view index at runtime βœ” should rename a materialized view unique index βœ” should delete a materialized view index βœ” should create a materialized view index βœ” should create a materialized view unique index github issues > #8485 second migration is generated for a combination of PrimaryColumn and JoinColumn βœ” should not create second migration (2208ms) github issues > #85 - Column option insert: false, update: false βœ” should ignore value of non-inserted column βœ” should be able to create an entity with column entirely missing (520ms) github issues > #8522 Single table inheritance returns the same discriminator value error for unrelated tables where their parents extend from the same entity Unrelated tables βœ” should loads internal user and internal role Related tables βœ” Should throw error when related tables have the same discriminator github issues > #8527 cannot clear database inside a transaction. βœ” should not fail when clearing a database inside a transaction (200ms) github issues > #8556 TreeRepository.findDescendants/Tree should return empty if tree parent entity does not exist βœ” should load descendants when findDescendants is called for a tree entity βœ” should return empty when findDescendants is called for a non existing tree entity github issues > #8627 junction aliases are not unique βœ” should not fail querying many-to-many-relation github issues > #863 indices > create schema build schema βœ” it should just work, creating the index (953ms) github issues > #8644 BUG - Special keyword column name for simple-enum in sqlite βœ” it should be able to set special keyword as column name for simple-enum types github issues > #867 result of `findAndCount` is wrong when apply `skip` and `take` option βœ” should work perfectly github issues > #8681 DeepPartial simplification breaks the .create() and .save() method in certain cases. βœ” should .save() and .create() complex deep partial entities βœ” should .save() and .create() complex deep partial entities using a generic repository github issues > #8690 Relations do not render primary key column values correctly when transformers present βœ” should load relations correctly when primary columns have transformers github issues > #8723 Fail on Update when reference exists together with FK: multiple assignments to same column βœ” should able to update when both reference and the id exist in the update object github issues > #8747 QueryBuilder update handles Date objects wrong on a ManyToOne relationship. - should correctly update the datetime field github issues > #8796 New find select object api should support false values as expected βœ” should suport false value when selecting fields github issues > #8832 Add uuid, inet4, and inet6 types for mariadb basic use of new maria db types βœ” should create table with uuid, inet4, and inet6 type set to column for relevant mariadb versions regression test mysql uuid generation βœ” should create table with with varchar with length 36 when version is mysql entity-metadata-validator βœ” should throw error if mariadb uuid is supported and length is provided to property βœ” should not throw error for mysql when uuid is provided and a length property is provided github issues > #8890 it should be possible to query IS NULL on ManyToOne relations βœ” where IsNull βœ” where In βœ” where IsNull OR In github issues > #8890 it should be possible to query IS NULL on OneToOne relations on owner side βœ” where IsNull βœ” where In βœ” where IsNull OR In github issues > #8892 ManyToMany relations save throws "Violation of PRIMARY KEY constraint" βœ” should work perfectly with with many to many relation with primary key from related object is a primary key from an many to one relation (43ms) github issues > #8936 DropIndex with a TableIndex without name is not working βœ” should drop the index as expected (1935ms) query builder order nulls first/last βœ” should work with uppercase/lowercase first/last cli init command βœ” should work with mysql option (21080ms) βœ” should work with mariadb option (14319ms) βœ” should work with postgres option (14778ms) βœ” should work with cockroachdb option (15156ms) βœ” should work with sqlite option (18930ms) βœ” should work with better-sqlite3 option (17293ms) βœ” should work with mssql option (22710ms) βœ” should work with mongodb option (14770ms) github issues > #9033 Cannot manually insert type in discriminator column of parent entity class whenusing single table inheritance when creating instance of parent entity βœ” is possible to set the discriminator column manually on the base entity github issues > #904 Using closure tables without @TreeLevelColumn will always fail on insert βœ” should work correctly when saving using parent category βœ” should work correctly when saving using children categories βœ” should be able to retrieve the whole tree github issues > #9049 mongodb entities with 2 level-nested arrays throws an 'document[embedded.prefix].map is not a function' error βœ” should save entities properly github issues > #9063 Support postgres column with varchar datatype and uuid_generate_v4() default βœ” it should be able to set special keyword as column name for simple-enum types github issues > #9152 Can't use LessThan for Union field βœ” should not raise TypeScript error when LessThan with Union is passed to FindOptionsWhere github issues > #9173 missing typeorm_metadata βœ” should create a view without view entity (385ms) github issues > #9176 The names of foreign keys created by queryRunner.createForeignKey and schema:sync are different with SQLite github issues > #9176 foreign keys βœ” should not generate queries when created foreign key with queryRunnner.createForeignKey github issues > #9176 unique constraint βœ” should not generate queries when created unique constraint with queryRunnner.createUniqueConstraint github issues > #9176 check constraint βœ” should not generate queries when created check constraint with queryRunnner.createCheckConstraint github issues > #9189 check invalid constraint options βœ” should throw an exception, when invalid option is configured github issues > #922 Support HSTORE column type βœ” should correctly implement HSTORE type github issues > #9230 Incorrect date parsing for year 1-999 mixedDateToDateString βœ” should format a year less than 1000 with correct 0 padding github issues > #9241 Incorrect insert order when cascade inserting parent inherited relations βœ” should save entities properly github issues > #9266 queryRunner.getTable() fails if Foreign Key is set in target table βœ” should be able to load tables github issues > #9272 Fix select on deeply nested embedded entities, using Repository API βœ” should be able to pass select options for deeply nested embedded entities github issues > #929 sub-queries should set their own parameters on execution βœ” should persist successfully and return persisted entity github issues > #9318 Change version query from SHOW server_version to SELECT version βœ” should have proper isGeneratedColumnsSupported value for postgres version github issues > #9323 Add new VirtualColumn decorator feature βœ” should generate expected sub-select & select statement βœ” should generate expected sub-select & nested-subselect statement βœ” should not generate sub-select if column is not selected βœ” should be able to save and find sub-select data in the database βœ” should be able to save and find sub-select data in the databse (with query builder) github issues > #9341 "bigNumberStrings:false" is not working for postgres βœ” should fetch big int as number not string when using parseInt8=true github issues > #9379 RelationIdLoader is not respecting maxAliasLength βœ” should fetch related entities properly github issues > #9381 The column option γ€Štransformer》 affects the result of the query condition generation βœ” transform and find values (334ms) βœ” transform json values and find values github issues > #9399 mssql: Column is dropped and recreated in every migration βœ” No migration should be created github issues > #9405 Incorrect subject sorting with multi-inheritance entities βœ” should correctly sort entities with multi-inheritances better-sqlite3 driver > enable wal βœ” github issues > #9410 The better-sqlite3 driver should support the enableWal flag github issues > #9365 βœ” should work with conflict path github issues > #945 synchronization with multiple primary keys βœ” schema should include two primary keys github issues > #9457 No changes in database schema were found, when simple-enum is changed. βœ” should drop and recreate 'CHECK' constraint to match enum values github issues > #9477 Unsigned Integers Columns constantly dropped and recreated βœ” should not create migrations for unsigned indices github issues > #948 EntityManager#save always considers a Postgres array-type field to have changed βœ” should not produce extra query when array is updated? github issues > #9518 Can't pass ObjectLiteral in MongoRepository.find where condition due to typings βœ” should be able to use ObjectLiteral in find where condition github issues > #953 MySQL 5.7 JSON column parse βœ” should retrieve record from mysql5.7 using driver mysql2 github issues > #9534 materialized-path βœ” attach should work properly (42ms) βœ” findTrees() tests > findTrees should load all category roots github issues > #9601 view+schema+synchronize broken for oracle βœ” should recognize model changes βœ” should not generate queries when no model changes github issues > #966 Inheritance in embeddables βœ” should save and load Superclass fields in embeddable github issues > #9664 add JsonContains operator βœ” should find addresses in json field by name github issues > #9673 TreeRepository not loading relations on findDescendants() method using QUERY method (relationLoadStrategy) βœ” should generate multiple queries per relation (40ms) github issues > #9684 Incorrect enum default value when table name contains dash character βœ” should get default enum value github issues > #9690 Incorrect SQL expression if `where` parameter is empty array βœ” should run without throw error github issues > #970 Mongo Bad Sort Specification βœ” should order properly without errors github issues > #9715 Database schema is not updated by sync/migration when 'simple-enum' is changed. βœ” should update 'CHECK' constraint to match enum values github issues > #9770 check for referencing foreign keys when altering a table using sqlite βœ” shouldn't loose dependant table data github issues > #9829 Incorrect default value with concat value of function βœ” should get default concat value github issues > #9833 Add support for Single Table Inheritance when using Entity Schemas βœ” should instantiate concrete entities when using EntitySchema github issues > #9885 βœ” should be connected github issues > #9895 βœ” should allow find order on object property github issues > #9903 json data type json supported type for mariadb βœ” should create table with json constraint github issues > #9948 Subscribers with both 'beforeUpdate' and 'afterUpdate' methods defined cause duplicate 'updatedColumn' entries βœ” should not duplicate update column github issues > #996 already loaded via query builder relations should not be loaded again when they are lazily loaded βœ” should be able to find by object reference github issues > #9960 βœ” select + order by must work without issues github issues > #9977 βœ” where relations with (More|Less)ThanOrEqual operators (67ms) github issues > #9984 TransactionRetryWithProtoRefreshError should be handled by TypeORM βœ” should retry transaction on 40001 error with 'inject_retry_errors_enabled=true' βœ” should retry transaction on 40001 error github issues > #9988 RelationIdLoader reuses the same queryplanner within a transaction βœ” custom repository querybuilders within transactions returns relations for getOne() and getMany insertion βœ” basic insert functionality other issues > auto-increment id as string βœ” should relationIds exist other issues > column with getter / setter should work βœ” getters and setters should work correctly other issues > ekifox reported issue with increment βœ” getters and setters should work correctly other issues > entity change in listeners should affect persistence βœ” if entity was changed in the listener, changed property should be updated in the db other issues > entity change in subscribers should affect persistence βœ” if entity was changed, subscriber should be take updated columns other issues > escaping function parameter βœ” select query builder should ignore function-based parameters βœ” insert query builder should work with function parameters βœ” update query builder should work with function parameters other issues > getId should not return undefined for composite primary keys with lazy relations βœ” getId should not return undefined other issues > allow HSTORE column type to use transformers βœ” should use the transformer set in the column options other issues > hydration performance βœ” if entity was changed in the listener, changed property should be updated in the db (2960ms) other issues > double inheritance produces multiple duplicated columns βœ” should not produce duplicate columns other issues > joining empty relations βœ” should return empty array if its joined and nothing was found βœ” should return empty array if its joined and nothing was found, but relations in empty results should be skipped other issues > using limit in conjunction with order by βœ” should persist successfully and return persisted entity (668ms) other issues > mongodb entity change in listeners should affect persistence βœ” if entity was changed in the listener, changed property should be updated in the db βœ” if entity was loaded in the listener, loaded property should be changed other issues > mongodb entity change in subscribers should affect persistence βœ” if entity was changed, subscriber should be take updated columns βœ” if entity was loaded, loaded property should be changed mssql -> add column to existing table βœ” should fail to add column βœ” should succeed to add column other issues > using nested child entities βœ” should insert without error other issues > preventing-injection βœ” should not allow selection of non-exist columns via FindOptions βœ” should throw error for non-exist columns in where expression via FindOptions βœ” should not allow selection of non-exist columns via FindOptions βœ” should not allow non-numeric values in skip and take via FindOptions βœ” should not allow non-numeric values in skip and take in QueryBuilder βœ” should not allow non-allowed values in order by in QueryBuilder other issues > redundant cascade schema queries in many-to-many relation βœ” should work correctly other issues > bulk save in sqlite βœ” should save entities in bulk other issues > Relation decorators: allow to pass given table name string instead of typeFunction or entity name βœ” should work with one-to-one relations βœ” should work with many-to-one/one-to-many relations βœ” should work with many-to-many relations other issues > using take with multiple primary keys βœ” should persist successfully and return persisted entity (730ms) other issues > correctly compute change for transformed json / jsonb columns βœ” should not update entity if transformed JSON column did not change βœ” should not update entity if transformed JSONB column did not change other issues > update relational column on relation change βœ” should update relational column when relation is inserted path-utils isAbsolute βœ” discriminates cross platform relative paths toPortablePath Platform darwin toPortablePath βœ” should change paths on non-Windows platform Platform win32 toPortablePath βœ” shouldn't change absolute posix paths when producing portable path βœ” shouldn't change absolute paths that are already portable βœ” should normalize the slashes in relative Windows paths βœ” should transform Windows paths into their posix counterparts (uppercase drive) βœ” should transform Windows paths into their posix counterparts (lowercase drive) βœ” should transform Windows paths into their posix counterparts (forward slashes) βœ” should support Windows paths that contain both backslashes and forward slashes βœ” should support drive: Windows paths βœ” should support UNC Windows paths (\\[server]\[sharename]\) βœ” should support Long UNC Windows paths (\\?\[server]\[sharename]\) βœ” should support Long UNC Windows paths (\\?\UNC\[server]\[sharename]\) βœ” should support Long UNC Windows paths (\\?\[drive_spec]:\) βœ” should support Long UNC Windows paths with dot (\\.\[physical_device]\) 2030 passing (47m) 166 pending typeorm-0.3.17 end [Pipeline] } Cache not saved (ws/jenkins-pingcap-tidb-merged_integration_nodejs_test-1073/tidb-test already exists) [Pipeline] // cache [Pipeline] } [Pipeline] // dir [Pipeline] } [Pipeline] // stage [Pipeline] } [Pipeline] // container [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // node [Pipeline] } [Pipeline] // podTemplate [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // stage [Pipeline] } [Pipeline] // parallel [Pipeline] } [Pipeline] // stage [Pipeline] } [Pipeline] // timeout [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // container [Pipeline] } [Pipeline] // withEnv [Pipeline] } [Pipeline] // node [Pipeline] } [Pipeline] // podTemplate [Pipeline] End of Pipeline Finished: SUCCESS