Left join returns incorrect number of records #1791
radovanradicgraalvm-latest.yml
on: pull_request
build_matrix
3m 54s
Matrix: build
Annotations
48 errors and 1 warning
|
H2EnumsMappingSpec.test create table with enums:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2EnumsMappingSpec.groovy#L126
Condition not satisfied:
sql == 'CREATE TABLE `enum_entity` (`id` BIGINT AUTO_INCREMENT PRIMARY KEY,`as_default` VARCHAR(255) NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);'
| |
| false
| 24 differences (86% similarity)
| CREATE TABLE `enum_entity` (`id` BIGINT (GENER)A(-)T(ED ALWAYS AS ID)ENT(ITY) PRIMARY KEY,`as_default` VARCHAR(255) NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
| CREATE TABLE `enum_entity` (`id` BIGINT (-----)A(U)T(O_INCREM-------)ENT(---) PRIMARY KEY,`as_default` VARCHAR(255) NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
CREATE TABLE `enum_entity` (`id` BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,`as_default` VARCHAR(255) NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
|
|
H2EnumsMappingSpec.test jpa create table with enums:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2EnumsMappingSpec.groovy#L137
Condition not satisfied:
sql == 'CREATE TABLE `jpa_enum_entity` (`id` BIGINT AUTO_INCREMENT PRIMARY KEY,`as_default` INT NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);'
| |
| false
| 24 differences (85% similarity)
| CREATE TABLE `jpa_enum_entity` (`id` BIGINT (GENER)A(-)T(ED ALWAYS AS ID)ENT(ITY) PRIMARY KEY,`as_default` INT NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
| CREATE TABLE `jpa_enum_entity` (`id` BIGINT (-----)A(U)T(O_INCREM-------)ENT(---) PRIMARY KEY,`as_default` INT NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
CREATE TABLE `jpa_enum_entity` (`id` BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,`as_default` INT NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
|
|
H2NoTxOpsRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2NoTxOpsRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@2937b1d6, io.micronaut.data.tck.entities.Student@6cfff5ec]
|
|
H2RepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2RepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@42e97053, io.micronaut.data.tck.entities.Student@2d0a0036]
|
|
MariaRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mariadb/MariaRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@242d40c1, io.micronaut.data.tck.entities.Student@130d736a]
|
|
MySqlRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mysql/MySqlRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@522fa53c, io.micronaut.data.tck.entities.Student@3a757443]
|
|
OracleXERepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/oraclexe/OracleXERepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@1ec21d44, io.micronaut.data.tck.entities.Student@2b2ea28b]
|
|
PostgresRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/postgres/PostgresRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@46826104, io.micronaut.data.tck.entities.Student@305a9455]
|
|
SqlServerRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/sqlserver/SqlServerRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@47a32893, io.micronaut.data.tck.entities.Student@2e4bcfa]
|
|
BuildTableSpec.test create table OneToMany with JoinColumn:
data-processor/src/test/groovy/io/micronaut/data/processor/sql/BuildTableSpec.groovy#L426
Condition not satisfied:
employeeSql[0] == 'CREATE TABLE `employee` (`id` BIGINT AUTO_INCREMENT PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);'
| | |
| | false
| | 24 differences (85% similarity)
| | CREATE TABLE `employee` (`id` BIGINT (GENER)A(-)T(ED ALWAYS AS ID)ENT(ITY) PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);
| | CREATE TABLE `employee` (`id` BIGINT (-----)A(U)T(O_INCREM-------)ENT(---) PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);
| CREATE TABLE `employee` (`id` BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);
[CREATE TABLE `employee` (`id` BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);]
|
|
H2RepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2RepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@3cbc7338, io.micronaut.data.tck.entities.Student@66879a85]
|
|
MariaDbRepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mariadb/MariaDbRepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@3f6d8ad7, io.micronaut.data.tck.entities.Student@3a2583ab]
|
|
MariaDbRepositorySpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mariadb/MariaDbRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@57909c0, io.micronaut.data.tck.entities.Student@16081cb]
|
|
MySqlRepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mysql/MySqlRepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@601fbcd4, io.micronaut.data.tck.entities.Student@63ddd89]
|
|
MySqlRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mysql/MySqlRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@15856d3e, io.micronaut.data.tck.entities.Student@70828671]
|
|
OracleXERepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/oraclexe/OracleXERepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@51325b0d, io.micronaut.data.tck.entities.Student@65f0d314]
|
|
OracleXERepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/oraclexe/OracleXERepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@2989ad69, io.micronaut.data.tck.entities.Student@228637fa]
|
|
PostgresRepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/postgres/PostgresRepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@f79d6d4, io.micronaut.data.tck.entities.Student@33228ff5]
|
|
PostgresRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/postgres/PostgresRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@1c9e368c, io.micronaut.data.tck.entities.Student@35582687]
|
|
SqlServerRepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/sqlserver/SqlServerRepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@6bcd1373, io.micronaut.data.tck.entities.Student@58dde631]
|
|
SqlServerRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/sqlserver/SqlServerRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@6086cc38, io.micronaut.data.tck.entities.Student@2a65bf69]
|
|
H2EnumsMappingSpec.test create table with enums:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2EnumsMappingSpec.groovy#L126
Condition not satisfied:
sql == 'CREATE TABLE `enum_entity` (`id` BIGINT AUTO_INCREMENT PRIMARY KEY,`as_default` VARCHAR(255) NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);'
| |
| false
| 24 differences (86% similarity)
| CREATE TABLE `enum_entity` (`id` BIGINT (GENER)A(-)T(ED ALWAYS AS ID)ENT(ITY) PRIMARY KEY,`as_default` VARCHAR(255) NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
| CREATE TABLE `enum_entity` (`id` BIGINT (-----)A(U)T(O_INCREM-------)ENT(---) PRIMARY KEY,`as_default` VARCHAR(255) NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
CREATE TABLE `enum_entity` (`id` BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,`as_default` VARCHAR(255) NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
|
|
H2EnumsMappingSpec.test jpa create table with enums:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2EnumsMappingSpec.groovy#L137
Condition not satisfied:
sql == 'CREATE TABLE `jpa_enum_entity` (`id` BIGINT AUTO_INCREMENT PRIMARY KEY,`as_default` INT NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);'
| |
| false
| 24 differences (85% similarity)
| CREATE TABLE `jpa_enum_entity` (`id` BIGINT (GENER)A(-)T(ED ALWAYS AS ID)ENT(ITY) PRIMARY KEY,`as_default` INT NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
| CREATE TABLE `jpa_enum_entity` (`id` BIGINT (-----)A(U)T(O_INCREM-------)ENT(---) PRIMARY KEY,`as_default` INT NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
CREATE TABLE `jpa_enum_entity` (`id` BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,`as_default` INT NOT NULL,`as_string` VARCHAR(255) NOT NULL,`as_int` INT NOT NULL);
|
|
H2NoTxOpsRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2NoTxOpsRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@5f585409, io.micronaut.data.tck.entities.Student@192271a1]
|
|
H2RepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2RepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@1fc4cf65, io.micronaut.data.tck.entities.Student@6061d898]
|
|
MariaRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mariadb/MariaRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@4375f916, io.micronaut.data.tck.entities.Student@33782942]
|
|
MySqlRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mysql/MySqlRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@3d55e978, io.micronaut.data.tck.entities.Student@7735ecd6]
|
|
OracleXERepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/oraclexe/OracleXERepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@261655dd, io.micronaut.data.tck.entities.Student@29d453af]
|
|
PostgresRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/postgres/PostgresRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@1d4edfc5, io.micronaut.data.tck.entities.Student@1f9f79d9]
|
|
SqlServerRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/sqlserver/SqlServerRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@121c50de, io.micronaut.data.tck.entities.Student@103064c0]
|
|
BuildTableSpec.test create table OneToMany with JoinColumn:
data-processor/src/test/groovy/io/micronaut/data/processor/sql/BuildTableSpec.groovy#L426
Condition not satisfied:
employeeSql[0] == 'CREATE TABLE `employee` (`id` BIGINT AUTO_INCREMENT PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);'
| | |
| | false
| | 24 differences (85% similarity)
| | CREATE TABLE `employee` (`id` BIGINT (GENER)A(-)T(ED ALWAYS AS ID)ENT(ITY) PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);
| | CREATE TABLE `employee` (`id` BIGINT (-----)A(U)T(O_INCREM-------)ENT(---) PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);
| CREATE TABLE `employee` (`id` BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);
[CREATE TABLE `employee` (`id` BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,`name` VARCHAR(255) NOT NULL,`category_id` BIGINT NOT NULL,`employer_id` BIGINT NOT NULL);]
|
|
H2RepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2RepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@4b43ee03, io.micronaut.data.tck.entities.Student@3ab2b539]
|
|
MariaDbRepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mariadb/MariaDbRepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@2c8414ed, io.micronaut.data.tck.entities.Student@11ef9a74]
|
|
MariaDbRepositorySpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mariadb/MariaDbRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@55bd1c89, io.micronaut.data.tck.entities.Student@42e85dfc]
|
|
MySqlRepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mysql/MySqlRepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@2d2785a5, io.micronaut.data.tck.entities.Student@5a70de9d]
|
|
MySqlRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mysql/MySqlRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@273f5d0c, io.micronaut.data.tck.entities.Student@21633f5b]
|
|
OracleXERepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/oraclexe/OracleXERepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@36143d8d, io.micronaut.data.tck.entities.Student@a80b838]
|
|
OracleXERepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/oraclexe/OracleXERepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@70423a, io.micronaut.data.tck.entities.Student@3ac908]
|
|
PostgresRepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/postgres/PostgresRepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@4f07d298, io.micronaut.data.tck.entities.Student@1b3ceb6c]
|
|
PostgresRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/postgres/PostgresRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@7ba93b04, io.micronaut.data.tck.entities.Student@741df824]
|
|
SqlServerRepositoryPoolSpec.test ManyToMany join table with mappedBy:
data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/sqlserver/SqlServerRepositoryPoolSpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@1589772a, io.micronaut.data.tck.entities.Student@142813ea]
|
|
SqlServerRepositorySpec.test ManyToMany join table with mappedBy:
data-jdbc/src/test/groovy/io/micronaut/data/jdbc/sqlserver/SqlServerRepositorySpec.groovy#L1
Condition not satisfied:
students.size() == 1
| | |
| 2 false
[io.micronaut.data.tck.entities.Student@5c513f93, io.micronaut.data.tck.entities.Student@7a40ae2b]
|
|
build (17, micronaut-doc-examples:micronaut-hibernate-example-java:nativeTest)
The run was canceled by @radovanradic.
|
|
build (17, micronaut-doc-examples:micronaut-jdbc-and-r2dbc-example-java:nativeTest)
The run was canceled by @radovanradic.
|
|
build (17, micronaut-doc-examples:micronaut-jdbc-example-java:nativeTest)
The run was canceled by @radovanradic.
|
|
|
|
build (17, micronaut-doc-examples:micronaut-hibernate-reactive-example-java:nativeTest)
The run was canceled by @radovanradic.
|
|
build (17, micronaut-doc-examples:micronaut-example-hibernate-and-jdbc:nativeTest)
The run was canceled by @radovanradic.
|
|
build_matrix
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: gradle/gradle-build-action@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
|