Skip to content

Left join returns incorrect number of records #1791

Left join returns incorrect number of records

Left join returns incorrect number of records #1791

GitHub Actions / Java CI / Test Report (21) failed Jun 3, 2024 in 0s

5186 tests run, 5065 passed, 100 skipped, 21 failed.

Annotations

Check failure on line 126 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2EnumsMappingSpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

H2EnumsMappingSpec.test create table with enums

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);
Raw output
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);

	at io.micronaut.data.jdbc.h2.H2EnumsMappingSpec.test create table with enums(H2EnumsMappingSpec.groovy:126)

Check failure on line 137 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2EnumsMappingSpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

H2EnumsMappingSpec.test jpa create table with enums

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);
Raw output
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);

	at io.micronaut.data.jdbc.h2.H2EnumsMappingSpec.test jpa create table with enums(H2EnumsMappingSpec.groovy:137)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2NoTxOpsRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

H2NoTxOpsRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@5f585409, io.micronaut.data.tck.entities.Student@192271a1]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@5f585409, io.micronaut.data.tck.entities.Student@192271a1]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2RepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

H2RepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@1fc4cf65, io.micronaut.data.tck.entities.Student@6061d898]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@1fc4cf65, io.micronaut.data.tck.entities.Student@6061d898]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mariadb/MariaRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

MariaRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@4375f916, io.micronaut.data.tck.entities.Student@33782942]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@4375f916, io.micronaut.data.tck.entities.Student@33782942]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mysql/MySqlRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

MySqlRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@3d55e978, io.micronaut.data.tck.entities.Student@7735ecd6]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@3d55e978, io.micronaut.data.tck.entities.Student@7735ecd6]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/oraclexe/OracleXERepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

OracleXERepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@261655dd, io.micronaut.data.tck.entities.Student@29d453af]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@261655dd, io.micronaut.data.tck.entities.Student@29d453af]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/postgres/PostgresRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

PostgresRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@1d4edfc5, io.micronaut.data.tck.entities.Student@1f9f79d9]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@1d4edfc5, io.micronaut.data.tck.entities.Student@1f9f79d9]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/sqlserver/SqlServerRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

SqlServerRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@121c50de, io.micronaut.data.tck.entities.Student@103064c0]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@121c50de, io.micronaut.data.tck.entities.Student@103064c0]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 426 in data-processor/src/test/groovy/io/micronaut/data/processor/sql/BuildTableSpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

BuildTableSpec.test create table OneToMany with JoinColumn

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);]
Raw output
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);]

	at io.micronaut.data.processor.sql.BuildTableSpec.test create table OneToMany with JoinColumn(BuildTableSpec.groovy:426)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/h2/H2RepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

H2RepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@4b43ee03, io.micronaut.data.tck.entities.Student@3ab2b539]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@4b43ee03, io.micronaut.data.tck.entities.Student@3ab2b539]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mariadb/MariaDbRepositoryPoolSpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

MariaDbRepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@2c8414ed, io.micronaut.data.tck.entities.Student@11ef9a74]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@2c8414ed, io.micronaut.data.tck.entities.Student@11ef9a74]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mariadb/MariaDbRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

MariaDbRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@55bd1c89, io.micronaut.data.tck.entities.Student@42e85dfc]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@55bd1c89, io.micronaut.data.tck.entities.Student@42e85dfc]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/mysql/MySqlRepositoryPoolSpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

MySqlRepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@2d2785a5, io.micronaut.data.tck.entities.Student@5a70de9d]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@2d2785a5, io.micronaut.data.tck.entities.Student@5a70de9d]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/mysql/MySqlRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

MySqlRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@273f5d0c, io.micronaut.data.tck.entities.Student@21633f5b]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@273f5d0c, io.micronaut.data.tck.entities.Student@21633f5b]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/oraclexe/OracleXERepositoryPoolSpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

OracleXERepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@36143d8d, io.micronaut.data.tck.entities.Student@a80b838]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@36143d8d, io.micronaut.data.tck.entities.Student@a80b838]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/oraclexe/OracleXERepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

OracleXERepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@70423a, io.micronaut.data.tck.entities.Student@3ac908]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@70423a, io.micronaut.data.tck.entities.Student@3ac908]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/postgres/PostgresRepositoryPoolSpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

PostgresRepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@4f07d298, io.micronaut.data.tck.entities.Student@1b3ceb6c]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@4f07d298, io.micronaut.data.tck.entities.Student@1b3ceb6c]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/postgres/PostgresRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

PostgresRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@7ba93b04, io.micronaut.data.tck.entities.Student@741df824]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@7ba93b04, io.micronaut.data.tck.entities.Student@741df824]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-r2dbc/src/test/groovy/io/micronaut/data/r2dbc/sqlserver/SqlServerRepositoryPoolSpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

SqlServerRepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@1589772a, io.micronaut.data.tck.entities.Student@142813ea]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@1589772a, io.micronaut.data.tck.entities.Student@142813ea]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)

Check failure on line 1 in data-jdbc/src/test/groovy/io/micronaut/data/jdbc/sqlserver/SqlServerRepositorySpec.groovy

See this annotation in the file changed.

@github-actions github-actions / Java CI / Test Report (21)

SqlServerRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@5c513f93, io.micronaut.data.tck.entities.Student@7a40ae2b]
Raw output
Condition not satisfied:

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@5c513f93, io.micronaut.data.tck.entities.Student@7a40ae2b]

	at io.micronaut.data.tck.tests.AbstractRepositorySpec.test ManyToMany join table with mappedBy(AbstractRepositorySpec.groovy:2566)