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 (17) failed Jun 3, 2024 in 0s

5185 tests run, 5064 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 (17)

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 (17)

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 (17)

H2NoTxOpsRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@2937b1d6, io.micronaut.data.tck.entities.Student@6cfff5ec]

	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 (17)

H2RepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

	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 (17)

MariaRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@242d40c1, io.micronaut.data.tck.entities.Student@130d736a]

	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 (17)

MySqlRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@522fa53c, io.micronaut.data.tck.entities.Student@3a757443]

	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 (17)

OracleXERepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

	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 (17)

PostgresRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

	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 (17)

SqlServerRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

	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 (17)

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 (17)

H2RepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@3cbc7338, io.micronaut.data.tck.entities.Student@66879a85]

	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 (17)

MariaDbRepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

	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 (17)

MariaDbRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@57909c0, io.micronaut.data.tck.entities.Student@16081cb]

	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 (17)

MySqlRepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@601fbcd4, io.micronaut.data.tck.entities.Student@63ddd89]

	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 (17)

MySqlRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

	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 (17)

OracleXERepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@51325b0d, io.micronaut.data.tck.entities.Student@65f0d314]

	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 (17)

OracleXERepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@2989ad69, io.micronaut.data.tck.entities.Student@228637fa]

	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 (17)

PostgresRepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

	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 (17)

PostgresRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

	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 (17)

SqlServerRepositoryPoolSpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

students.size() == 1
|        |      |
|        2      false
[io.micronaut.data.tck.entities.Student@6bcd1373, io.micronaut.data.tck.entities.Student@58dde631]

	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 (17)

SqlServerRepositorySpec.test ManyToMany join table with mappedBy

Condition not satisfied:

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

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

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