Translate XStore into Relational based on locality #10694
26 errors, 29 skipped, 3 959 pass in 6m 31s
Annotations
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testClassMappingsAreCorrectlyIsolated (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Execution error at (resource:/core/pure/router/store/builder.pure line:219 column:150), "Cannot cast a collection of size 0 to multiplicity [1]"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.toOneWithMessage(CompiledSupport.java:332)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.toOne(CompiledSupport.java:310)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60$1.value(core_pure_router_store_builder.java:1531)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60$1.value(core_pure_router_store_builder.java:1521)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60.valueOf(core_pure_router_store_builder.java:1519)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1546)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56$3.value(core_pure_router_store_builder.java:913)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56$3.value(core_pure_router_store_builder.java:897)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56.execute(core_pure_router_store_builder.java:896)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_enrichStoreMappingRoutedValueSpecification_StoreMappingRoutedValueSpecification_1__ExecutionContext_1__Extension_MANY__DebugContext_1__StoreMappingRoutedValueSpecification_1_(core_pure_router_store_builder.java:970)
at org.finos.legend.pure.generated.core_pure_router_router_main$19.valueOf(core_pure_router_router_main.java:330)
at org.finos.legend.pure.generated.core_pure_router_router_main.Root_meta_pure_router_enrichExpressionWithStrategyBasedEnrichment_ExtendedRoutedValueSpecification_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ExtendedRoutedValueSpecification_1_(core_pure_router_router_main.java:332)
at org.finos.legend.pure.generated.core_pure_router_router_main$17.value(core_pure_router_router_main.java:284)
at org.finos.legend.pure.generated.core_pure_router_router_main$17.value(core_pure_router_router_main.java:275)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_router_main.Root_meta_pure_router_routeFunction_FunctionDefinition_1__RoutingStrategy_1__ExecutionContext_1__Map_$0_1$__Extension_MANY__DebugContext_1__FunctionDefinition_1_(core_pure_router_router_main.java:274)
at org.finos.legend.pure.generated.core_pure_router_deprecated_deprecated.Root_meta_pure_router_routeFunction_FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__DebugContext_1__FunctionDefinition_1_(core_pure_router_deprecated_deprecated.java:34)
at org.finos.legend.pure.generated.core_pure_router_router_execution.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__DebugContext_1__Result_1_(core_pure_router_router_execution.java:353)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.valueOf(core_pure_router_router_entry.java:185)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.execute(core_pure_router_router_entry.java:180)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.execute(core_pure_router_router_entry.java:171)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure.evaluate(Pure.java:366)
at org.finos.legend.pure.runtime.java.extension.functions.compiled.FunctionsHelper.legendTest(FunctionsHelper.java:1694)
at org.finos.legend.pure.generated.FunctionsGen.legendTest(FunctionsGen.java:107)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.valueOf(core_pure_router_router_entry.java:134)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.execute(core_pure_router_router_entry.java:129)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.execute(core_pure_router_router_entry.java:120)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure.evaluate(Pure.java:366)
at org.finos.legend.pure.runtime.java.extension.functions.compiled.FunctionsHelper.traceSpan(FunctionsHelper.java:1641)
at org.finos.legend.pure.generated.FunctionsGen.traceSpan(FunctionsGen.java:268)
at org.finos.legend.pure.generated.core_pure_router_router_entry.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__Result_1_(core_pure_router_router_entry.java:116)
at org.finos.legend.pure.generated.core_pure_router_router_entry.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__Extension_MANY__Result_1_(core_pure_router_router_entry.java:111)
at org.finos.legend.pure.generated.core_relational_relational_functions_tests_testFrom.Root_meta_relational_tests_fromMapping_testClassMappingsAreCorrectlyIsolated__Boolean_1_(core_relational_relational_functions_tests_testFrom.java:247)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testMappingFromQueriesViaMappingWithAssociationsOnly (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Execution error at (resource:/core/pure/router/store/builder.pure line:219 column:150), "Cannot cast a collection of size 0 to multiplicity [1]"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.toOneWithMessage(CompiledSupport.java:332)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.toOne(CompiledSupport.java:310)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60$1.value(core_pure_router_store_builder.java:1531)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60$1.value(core_pure_router_store_builder.java:1521)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60.valueOf(core_pure_router_store_builder.java:1519)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1546)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56$3.value(core_pure_router_store_builder.java:913)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56$3.value(core_pure_router_store_builder.java:897)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56.execute(core_pure_router_store_builder.java:896)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_enrichStoreMappingRoutedValueSpecification_StoreMappingRoutedValueSpecification_1__ExecutionContext_1__Extension_MANY__DebugContext_1__StoreMappingRoutedValueSpecification_1_(core_pure_router_store_builder.java:970)
at org.finos.legend.pure.generated.core_pure_router_router_main$19.valueOf(core_pure_router_router_main.java:330)
at org.finos.legend.pure.generated.core_pure_router_router_main.Root_meta_pure_router_enrichExpressionWithStrategyBasedEnrichment_ExtendedRoutedValueSpecification_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ExtendedRoutedValueSpecification_1_(core_pure_router_router_main.java:332)
at org.finos.legend.pure.generated.core_pure_router_router_main$17.value(core_pure_router_router_main.java:284)
at org.finos.legend.pure.generated.core_pure_router_router_main$17.value(core_pure_router_router_main.java:275)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_router_main.Root_meta_pure_router_routeFunction_FunctionDefinition_1__RoutingStrategy_1__ExecutionContext_1__Map_$0_1$__Extension_MANY__DebugContext_1__FunctionDefinition_1_(core_pure_router_router_main.java:274)
at org.finos.legend.pure.generated.core_pure_router_deprecated_deprecated.Root_meta_pure_router_routeFunction_FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__DebugContext_1__FunctionDefinition_1_(core_pure_router_deprecated_deprecated.java:34)
at org.finos.legend.pure.generated.core_pure_router_router_execution.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__DebugContext_1__Result_1_(core_pure_router_router_execution.java:353)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.valueOf(core_pure_router_router_entry.java:185)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.execute(core_pure_router_router_entry.java:180)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.execute(core_pure_router_router_entry.java:171)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure.evaluate(Pure.java:366)
at org.finos.legend.pure.runtime.java.extension.functions.compiled.FunctionsHelper.legendTest(FunctionsHelper.java:1694)
at org.finos.legend.pure.generated.FunctionsGen.legendTest(FunctionsGen.java:107)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.valueOf(core_pure_router_router_entry.java:134)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.execute(core_pure_router_router_entry.java:129)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.execute(core_pure_router_router_entry.java:120)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure.evaluate(Pure.java:366)
at org.finos.legend.pure.runtime.java.extension.functions.compiled.FunctionsHelper.traceSpan(FunctionsHelper.java:1641)
at org.finos.legend.pure.generated.FunctionsGen.traceSpan(FunctionsGen.java:268)
at org.finos.legend.pure.generated.core_pure_router_router_entry.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__Result_1_(core_pure_router_router_entry.java:116)
at org.finos.legend.pure.generated.core_pure_router_router_entry.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__Extension_MANY__Result_1_(core_pure_router_router_entry.java:111)
at org.finos.legend.pure.generated.core_relational_relational_functions_tests_testFrom.Root_meta_relational_tests_fromMapping_testMappingFromQueriesViaMappingWithAssociationsOnly__Boolean_1_(core_relational_relational_functions_tests_testFrom.java:231)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross2SetsV1 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk" as "x_pk", "unionalias_1"."Y0pk_Y1pk" as "y_pk", "unionalias_3"."Z0pk_Z1pk" as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".pk as "pk_0_0", null as "pk_0_1", "root".pk as "X0pk_X1pk", "root".fk as fk_0, null as fk_1 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "pk_0_0", "root".pk as "pk_0_1", "root".pk as "X0pk_X1pk", null as fk_0, "root".fk as fk_1 from X1 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join A as "a_0" on ("unionBase".fk_1 = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') left outer join (select "unionalias_2".fk_1 as fk_1, "unionalias_2".fk_0 as fk_0, "unionalias_2"."Y0pk_Y1pk" as "Y0pk_Y1pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".fk as fk_0, null as fk_1, "root".pk as "Y0pk_Y1pk" from Y0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as fk_0, "root".fk as fk_1, "root".pk as "Y0pk_Y1pk" from Y1 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_2" where (coalesce("unionalias_2"."from_z_0", "unionalias_2"."from_z_1") <= DATE\'2018-01-01\' and coalesce("unionalias_2"."thru_z_0", "unionalias_2"."thru_z_1") > DATE\'2018-01-01\') or coalesce("unionalias_2"."from_z_0", "unionalias_2"."from_z_1", "unionalias_2"."thru_z_0", "unionalias_2"."thru_z_1") is null) as "unionalias_1" on ("a_0".fk1 = "unionalias_1".fk_1 or "unionBase".fk_0 = "unionalias_1".fk_0) left outer join (select "g_1".fk0 as fk0, "g_1".fk1 from G as "g_1" where "g_1".from_z <= DATE\'2018-01-01\' and "g_1".thru_z > DATE\'2018-01-01\') as "g_0" on ("unionalias_1".fk_1 = "g_0".fk0) left outer join (select "unionalias_4".fk_1 as fk_1, "unionalias_4".fk_0 as fk_0, "unionalias_4"."Z0pk_Z1pk" as "Z0pk_Z1pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".fk as fk_0, null as fk_1, "root".pk as "Z0pk_Z1pk" from Z0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as fk_0, "root".fk as fk_1, "root".pk as "Z0pk_Z1pk" from Z1 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_4" where (coalesce("unionalias_4"."from_z_0", "unionalias_4"."from_z_1") <= DATE\'2018-01-01\' and coalesce("unionalias_4"."thru_z_0", "unionalias_4"."thru_z_1") > DATE\'2018-01-01\') or coalesce("unionalias_4"."from_z_0", "unionalias_4"."from_z_1", "unionalias_4"."thru_z_0", "unionalias_4"."thru_z_1") is null) as "unionalias_3" on ("g_0".fk1 = "unionalias_3".fk_1 or "unionalias_1".fk_0 = "unionalias_3".fk_0)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross2SetsV1__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1460)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross2SetsV2 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk" as "x_pk", "unionalias_1"."Y0pk_Y1pk" as "y_pk", "z0_0".pk as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".pk as "pk_0_0", null as "pk_0_1", "root".pk as "X0pk_X1pk", "root".fk as fk_0, null as fk_1 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "pk_0_0", "root".pk as "pk_0_1", "root".pk as "X0pk_X1pk", null as fk_0, "root".fk as fk_1 from X1 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join A as "a_0" on ("unionBase".fk_1 = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') left outer join (select "unionalias_2".fk_1 as fk_1, "unionalias_2".fk_0 as fk_0, "unionalias_2"."Y0pk_Y1pk" as "Y0pk_Y1pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".fk as fk_0, null as fk_1, "root".pk as "Y0pk_Y1pk" from Y0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as fk_0, "root".fk as fk_1, "root".pk as "Y0pk_Y1pk" from Y1 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_2" where (coalesce("unionalias_2"."from_z_0", "unionalias_2"."from_z_1") <= DATE\'2018-01-01\' and coalesce("unionalias_2"."thru_z_0", "unionalias_2"."thru_z_1") > DATE\'2018-01-01\') or coalesce("unionalias_2"."from_z_0", "unionalias_2"."from_z_1", "unionalias_2"."thru_z_0", "unionalias_2"."thru_z_1") is null) as "unionalias_1" on ("a_0".fk1 = "unionalias_1".fk_1 or "unionBase".fk_0 = "unionalias_1".fk_0) left outer join (select "g_1".fk0 as fk0, "g_1".fk1 from G as "g_1" where "g_1".from_z <= DATE\'2018-01-01\' and "g_1".thru_z > DATE\'2018-01-01\') as "g_0" on ("unionalias_1".fk_1 = "g_0".fk0) left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("g_0".fk1 = "z0_0".fk or "unionalias_1".fk_0 = "z0_0".fk)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross2SetsV2__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1511)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross2SetsV3 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk" as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".pk as "pk_0_0", null as "pk_0_1", "root".pk as "X0pk_X1pk", "root".fk as fk_0, null as fk_1 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "pk_0_0", "root".pk as "pk_0_1", "root".pk as "X0pk_X1pk", null as fk_0, "root".fk as fk_1 from X1 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join A as "a_0" on ("unionBase".fk_1 = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') left outer join (select "y0_1".fk as fk, "y0_1".pk as pk from Y0 as "y0_1" where "y0_1".from_z <= DATE\'2018-01-01\' and "y0_1".thru_z > DATE\'2018-01-01\') as "y0_0" on ("a_0".fk1 = "y0_0".fk or "unionBase".fk_0 = "y0_0".fk) left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross2SetsV3__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1562)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross3SetsV1 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk_X2pk" as "x_pk", "unionalias_1"."Y0pk_Y1pk_Y2pk" as "y_pk", "unionalias_2"."Z0pk_Z1pk_Z2pk" as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".pk as "pk_0_0", null as "pk_0_1", null as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk1_1, null as fk1_2 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "pk_0_0", "root".pk as "pk_0_1", null as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", null as fk_0, "root".fk as fk_1, null as fk_2, "a_0".fk1 as fk1_1, null as fk1_2 from X1 as "root" left outer join A as "a_0" on ("root".fk = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "pk_0_0", null as "pk_0_1", "root".pk as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk1_1, "c_0".fk1 as fk1_2 from X2 as "root" left outer join B as "b_0" on ("root".fk = "b_0".fk0 and "b_0".from_z <= DATE\'2018-01-01\' and "b_0".thru_z > DATE\'2018-01-01\') left outer join (select "c_1".fk1 as fk1, "c_1".fk0 as fk0 from C as "c_1" where "c_1".from_z <= DATE\'2018-01-01\' and "c_1".thru_z > DATE\'2018-01-01\') as "c_0" on ("b_0".fk1 = "c_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".fk as fk_0, null as fk_1, null as fk_2, "root".pk as "Y0pk_Y1pk_Y2pk", null as fk1_1, null as fk1_2 from Y0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as fk_0, "root".fk as fk_1, null as fk_2, "root".pk as "Y0pk_Y1pk_Y2pk", "g_0".fk1 as fk1_1, null as fk1_2 from Y1 as "root" left outer join G as "g_0" on ("root".fk = "g_0".fk0 and "g_0".from_z <= DATE\'2018-01-01\' and "g_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as fk_0, null as fk_1, "root".fk as fk_2, "root".pk as "Y0pk_Y1pk_Y2pk", null as fk1_1, "i_0".fk1 as fk1_2 from Y2 as "root" left outer join H as "h_0" on ("root".fk = "h_0".fk0 and "h_0".from_z <= DATE\'2018-01-01\' and "h_0".thru_z > DATE\'2018-01-01\') left outer join (select "i_1".fk1 as fk1, "i_1".fk0 as fk0 from I as "i_1" where "i_1".from_z <= DATE\'2018-01-01\' and "i_1".thru_z > DATE\'2018-01-01\') as "i_0" on ("h_0".fk1 = "i_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_1" on (("unionBase".fk_0 = "unionalias_1".fk_0 or "unionBase".fk1_1 = "unionalias_1".fk_1 or "unionBase".fk1_2 = "unionalias_1".fk_2) and ((coalesce("unionalias_1"."from_z_0", "unionalias_1"."from_z_1", "unionalias_1"."from_z_2") <= DATE\'2018-01-01\' and coalesce("unionalias_1"."thru_z_0", "unionalias_1"."thru_z_1", "unionalias_1"."thru_z_2") > DATE\'2018-01-01\') or coalesce("unionalias_1"."from_z_0", "unionalias_1"."from_z_1", "unionalias_1"."from_z_2", "unionalias_1"."thru_z_0", "unionalias_1"."thru_z_1", "unionalias_1"."thru_z_2") is null)) left outer join (select "unionalias_3".fk_0 as fk_0, "unionalias_3".fk_1 as fk_1, "unionalias_3".fk_2 as fk_2, "unionalias_3"."Z0pk_Z1pk_Z2pk" as "Z0pk_Z1pk_Z2pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".fk as fk_0, null as fk_1, null as fk_2, "root".pk as "Z0pk_Z1pk_Z2pk" from Z0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as fk_0, "root".fk as fk_1, null as fk_2, "root".pk as "Z0pk_Z1pk_Z2pk" from Z1 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as fk_0, null as fk_1, "root".fk as fk_2, "root".pk as "Z0pk_Z1pk_Z2pk" from Z2 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_3" where (coalesce("unionalias_3"."from_z_0", "unionalias_3"."from_z_1", "unionalias_3"."from_z_2") <= DATE\'2018-01-01\' and coalesce("unionalias_3"."thru_z_0", "unionalias_3"."thru_z_1", "unionalias_3"."thru_z_2") > DATE\'2018-01-01\') or coalesce("unionalias_3"."from_z_0", "unionalias_3"."from_z_1", "unionalias_3"."from_z_2", "unionalias_3"."thru_z_0", "unionalias_3"."thru_z_1", "unionalias_3"."thru_z_2") is null) as "unionalias_2" on ("unionalias_1".fk_0 = "unionalias_2".fk_0 or "unionalias_1".fk1_1 = "unionalias_2".fk_1 or "unionalias_1".fk1_2 = "unionalias_2".fk_2)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross3SetsV1__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1477)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross3SetsV2 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk_X2pk" as "x_pk", "unionalias_1"."Y0pk_Y1pk_Y2pk" as "y_pk", "z0_0".pk as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".pk as "pk_0_0", null as "pk_0_1", null as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk1_1, null as fk1_2 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "pk_0_0", "root".pk as "pk_0_1", null as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", null as fk_0, "root".fk as fk_1, null as fk_2, "a_0".fk1 as fk1_1, null as fk1_2 from X1 as "root" left outer join A as "a_0" on ("root".fk = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "pk_0_0", null as "pk_0_1", "root".pk as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk1_1, "c_0".fk1 as fk1_2 from X2 as "root" left outer join B as "b_0" on ("root".fk = "b_0".fk0 and "b_0".from_z <= DATE\'2018-01-01\' and "b_0".thru_z > DATE\'2018-01-01\') left outer join (select "c_1".fk1 as fk1, "c_1".fk0 as fk0 from C as "c_1" where "c_1".from_z <= DATE\'2018-01-01\' and "c_1".thru_z > DATE\'2018-01-01\') as "c_0" on ("b_0".fk1 = "c_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".fk as fk_0, null as fk_1, null as fk_2, "root".pk as "Y0pk_Y1pk_Y2pk", null as fk1_1, null as fk1_2 from Y0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as fk_0, "root".fk as fk_1, null as fk_2, "root".pk as "Y0pk_Y1pk_Y2pk", "g_0".fk1 as fk1_1, null as fk1_2 from Y1 as "root" left outer join G as "g_0" on ("root".fk = "g_0".fk0 and "g_0".from_z <= DATE\'2018-01-01\' and "g_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as fk_0, null as fk_1, "root".fk as fk_2, "root".pk as "Y0pk_Y1pk_Y2pk", null as fk1_1, "i_0".fk1 as fk1_2 from Y2 as "root" left outer join H as "h_0" on ("root".fk = "h_0".fk0 and "h_0".from_z <= DATE\'2018-01-01\' and "h_0".thru_z > DATE\'2018-01-01\') left outer join (select "i_1".fk1 as fk1, "i_1".fk0 as fk0 from I as "i_1" where "i_1".from_z <= DATE\'2018-01-01\' and "i_1".thru_z > DATE\'2018-01-01\') as "i_0" on ("h_0".fk1 = "i_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_1" on (("unionBase".fk_0 = "unionalias_1".fk_0 or "unionBase".fk1_1 = "unionalias_1".fk_1 or "unionBase".fk1_2 = "unionalias_1".fk_2) and ((coalesce("unionalias_1"."from_z_0", "unionalias_1"."from_z_1", "unionalias_1"."from_z_2") <= DATE\'2018-01-01\' and coalesce("unionalias_1"."thru_z_0", "unionalias_1"."thru_z_1", "unionalias_1"."thru_z_2") > DATE\'2018-01-01\') or coalesce("unionalias_1"."from_z_0", "unionalias_1"."from_z_1", "unionalias_1"."from_z_2", "unionalias_1"."thru_z_0", "unionalias_1"."thru_z_1", "unionalias_1"."thru_z_2") is null)) left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("unionalias_1".fk_0 = "z0_0".fk or "unionalias_1".fk1_1 = "z0_0".fk or "unionalias_1".fk1_2 = "z0_0".fk)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross3SetsV2__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1528)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross3SetsV3 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk_X2pk" as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".pk as "pk_0_0", null as "pk_0_1", null as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk1_1, null as fk1_2 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "pk_0_0", "root".pk as "pk_0_1", null as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", null as fk_0, "root".fk as fk_1, null as fk_2, "a_0".fk1 as fk1_1, null as fk1_2 from X1 as "root" left outer join A as "a_0" on ("root".fk = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "pk_0_0", null as "pk_0_1", "root".pk as "pk_0_2", "root".pk as "X0pk_X1pk_X2pk", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk1_1, "c_0".fk1 as fk1_2 from X2 as "root" left outer join B as "b_0" on ("root".fk = "b_0".fk0 and "b_0".from_z <= DATE\'2018-01-01\' and "b_0".thru_z > DATE\'2018-01-01\') left outer join (select "c_1".fk1 as fk1, "c_1".fk0 as fk0 from C as "c_1" where "c_1".from_z <= DATE\'2018-01-01\' and "c_1".thru_z > DATE\'2018-01-01\') as "c_0" on ("b_0".fk1 = "c_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join Y0 as "y0_0" on (("unionBase".fk_0 = "y0_0".fk or "unionBase".fk1_1 = "y0_0".fk or "unionBase".fk1_2 = "y0_0".fk) and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross3SetsV3__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1579)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross4SetsV1 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk_X2pk_X3pk" as "x_pk", "unionalias_1"."Y0pk_Y1pk_Y2pk_Y3pk" as "y_pk", "unionalias_2"."Z0pk_Z1pk_Z2pk_Z3pk" as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", "root".pk as "pk_0_0", null as "pk_0_1", null as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk_3, null as fk1_1, null as fk1_2, null as fk1_3 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as "pk_0_0", "root".pk as "pk_0_1", null as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, "root".fk as fk_1, null as fk_2, null as fk_3, "a_0".fk1 as fk1_1, null as fk1_2, null as fk1_3 from X1 as "root" left outer join A as "a_0" on ("root".fk = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as "pk_0_0", null as "pk_0_1", "root".pk as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk_3, null as fk1_1, "c_0".fk1 as fk1_2, null as fk1_3 from X2 as "root" left outer join B as "b_0" on ("root".fk = "b_0".fk0 and "b_0".from_z <= DATE\'2018-01-01\' and "b_0".thru_z > DATE\'2018-01-01\') left outer join (select "c_1".fk1 as fk1, "c_1".fk0 as fk0 from C as "c_1" where "c_1".from_z <= DATE\'2018-01-01\' and "c_1".thru_z > DATE\'2018-01-01\') as "c_0" on ("b_0".fk1 = "c_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".from_z as "from_z_3", "root".thru_z as "thru_z_3", null as "pk_0_0", null as "pk_0_1", null as "pk_0_2", "root".pk as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, null as fk_1, null as fk_2, "root".fk as fk_3, null as fk1_1, null as fk1_2, "f_0".fk1 as fk1_3 from X3 as "root" left outer join D as "d_0" on ("root".fk = "d_0".fk0 and "d_0".from_z <= DATE\'2018-01-01\' and "d_0".thru_z > DATE\'2018-01-01\') left outer join (select "e_1".fk0 as fk0, "e_1".fk1 from E as "e_1" where "e_1".from_z <= DATE\'2018-01-01\' and "e_1".thru_z > DATE\'2018-01-01\') as "e_0" on ("d_0".fk1 = "e_0".fk0) left outer join (select "f_1".fk1 as fk1, "f_1".fk0 as fk0 from F as "f_1" where "f_1".from_z <= DATE\'2018-01-01\' and "f_1".thru_z > DATE\'2018-01-01\') as "f_0" on ("e_0".fk1 = "f_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk_3, "root".pk as "Y0pk_Y1pk_Y2pk_Y3pk", null as fk1_1, null as fk1_2, null as fk1_3 from Y0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as fk_0, "root".fk as fk_1, null as fk_2, null as fk_3, "root".pk as "Y0pk_Y1pk_Y2pk_Y3pk", "g_0".fk1 as fk1_1, null as fk1_2, null as fk1_3 from Y1 as "root" left outer join G as "g_0" on ("root".fk = "g_0".fk0 and "g_0".from_z <= DATE\'2018-01-01\' and "g_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk_3, "root".pk as "Y0pk_Y1pk_Y2pk_Y3pk", null as fk1_1, "i_0".fk1 as fk1_2, null as fk1_3 from Y2 as "root" left outer join H as "h_0" on ("root".fk = "h_0".fk0 and "h_0".from_z <= DATE\'2018-01-01\' and "h_0".thru_z > DATE\'2018-01-01\') left outer join (select "i_1".fk1 as fk1, "i_1".fk0 as fk0 from I as "i_1" where "i_1".from_z <= DATE\'2018-01-01\' and "i_1".thru_z > DATE\'2018-01-01\') as "i_0" on ("h_0".fk1 = "i_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".from_z as "from_z_3", "root".thru_z as "thru_z_3", null as fk_0, null as fk_1, null as fk_2, "root".fk as fk_3, "root".pk as "Y0pk_Y1pk_Y2pk_Y3pk", null as fk1_1, null as fk1_2, "l_0".fk1 as fk1_3 from Y3 as "root" left outer join J as "j_0" on ("root".fk = "j_0".fk0 and "j_0".from_z <= DATE\'2018-01-01\' and "j_0".thru_z > DATE\'2018-01-01\') left outer join (select "k_1".fk0 as fk0, "k_1".fk1 from K as "k_1" where "k_1".from_z <= DATE\'2018-01-01\' and "k_1".thru_z > DATE\'2018-01-01\') as "k_0" on ("j_0".fk1 = "k_0".fk0) left outer join (select "l_1".fk1 as fk1, "l_1".fk0 as fk0 from L as "l_1" where "l_1".from_z <= DATE\'2018-01-01\' and "l_1".thru_z > DATE\'2018-01-01\') as "l_0" on ("k_0".fk1 = "l_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_1" on (("unionBase".fk_0 = "unionalias_1".fk_0 or "unionBase".fk1_1 = "unionalias_1".fk_1 or "unionBase".fk1_2 = "unionalias_1".fk_2 or "unionBase".fk1_3 = "unionalias_1".fk_3) and ((coalesce("unionalias_1"."from_z_0", "unionalias_1"."from_z_1", "unionalias_1"."from_z_2", "unionalias_1"."from_z_3") <= DATE\'2018-01-01\' and coalesce("unionalias_1"."thru_z_0", "unionalias_1"."thru_z_1", "unionalias_1"."thru_z_2", "unionalias_1"."thru_z_3") > DATE\'2018-01-01\') or coalesce("unionalias_1"."from_z_0", "unionalias_1"."from_z_1", "unionalias_1"."from_z_2", "unionalias_1"."from_z_3", "unionalias_1"."thru_z_0", "unionalias_1"."thru_z_1", "unionalias_1"."thru_z_2", "unionalias_1"."thru_z_3") is null)) left outer join (select "unionalias_3".fk_0 as fk_0, "unionalias_3".fk_1 as fk_1, "unionalias_3".fk_2 as fk_2, "unionalias_3".fk_3 as fk_3, "unionalias_3"."Z0pk_Z1pk_Z2pk_Z3pk" as "Z0pk_Z1pk_Z2pk_Z3pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk_3, "root".pk as "Z0pk_Z1pk_Z2pk_Z3pk" from Z0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as fk_0, "root".fk as fk_1, null as fk_2, null as fk_3, "root".pk as "Z0pk_Z1pk_Z2pk_Z3pk" from Z1 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk_3, "root".pk as "Z0pk_Z1pk_Z2pk_Z3pk" from Z2 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".from_z as "from_z_3", "root".thru_z as "thru_z_3", null as fk_0, null as fk_1, null as fk_2, "root".fk as fk_3, "root".pk as "Z0pk_Z1pk_Z2pk_Z3pk" from Z3 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_3" where (coalesce("unionalias_3"."from_z_0", "unionalias_3"."from_z_1", "unionalias_3"."from_z_2", "unionalias_3"."from_z_3") <= DATE\'2018-01-01\' and coalesce("unionalias_3"."thru_z_0", "unionalias_3"."thru_z_1", "unionalias_3"."thru_z_2", "unionalias_3"."thru_z_3") > DATE\'2018-01-01\') or coalesce("unionalias_3"."from_z_0", "unionalias_3"."from_z_1", "unionalias_3"."from_z_2", "unionalias_3"."from_z_3", "unionalias_3"."thru_z_0", "unionalias_3"."thru_z_1", "unionalias_3"."thru_z_2", "unionalias_3"."thru_z_3") is null) as "unionalias_2" on ("unionalias_1".fk_0 = "unionalias_2".fk_0 or "unionalias_1".fk1_1 = "unionalias_2".fk_1 or "unionalias_1".fk1_2 = "unionalias_2".fk_2 or "unionalias_1".fk1_3 = "unionalias_2".fk_3)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross4SetsV1__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1494)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross4SetsV2 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk_X2pk_X3pk" as "x_pk", "unionalias_1"."Y0pk_Y1pk_Y2pk_Y3pk" as "y_pk", "z0_0".pk as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", "root".pk as "pk_0_0", null as "pk_0_1", null as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk_3, null as fk1_1, null as fk1_2, null as fk1_3 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as "pk_0_0", "root".pk as "pk_0_1", null as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, "root".fk as fk_1, null as fk_2, null as fk_3, "a_0".fk1 as fk1_1, null as fk1_2, null as fk1_3 from X1 as "root" left outer join A as "a_0" on ("root".fk = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as "pk_0_0", null as "pk_0_1", "root".pk as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk_3, null as fk1_1, "c_0".fk1 as fk1_2, null as fk1_3 from X2 as "root" left outer join B as "b_0" on ("root".fk = "b_0".fk0 and "b_0".from_z <= DATE\'2018-01-01\' and "b_0".thru_z > DATE\'2018-01-01\') left outer join (select "c_1".fk1 as fk1, "c_1".fk0 as fk0 from C as "c_1" where "c_1".from_z <= DATE\'2018-01-01\' and "c_1".thru_z > DATE\'2018-01-01\') as "c_0" on ("b_0".fk1 = "c_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".from_z as "from_z_3", "root".thru_z as "thru_z_3", null as "pk_0_0", null as "pk_0_1", null as "pk_0_2", "root".pk as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, null as fk_1, null as fk_2, "root".fk as fk_3, null as fk1_1, null as fk1_2, "f_0".fk1 as fk1_3 from X3 as "root" left outer join D as "d_0" on ("root".fk = "d_0".fk0 and "d_0".from_z <= DATE\'2018-01-01\' and "d_0".thru_z > DATE\'2018-01-01\') left outer join (select "e_1".fk0 as fk0, "e_1".fk1 from E as "e_1" where "e_1".from_z <= DATE\'2018-01-01\' and "e_1".thru_z > DATE\'2018-01-01\') as "e_0" on ("d_0".fk1 = "e_0".fk0) left outer join (select "f_1".fk1 as fk1, "f_1".fk0 as fk0 from F as "f_1" where "f_1".from_z <= DATE\'2018-01-01\' and "f_1".thru_z > DATE\'2018-01-01\') as "f_0" on ("e_0".fk1 = "f_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk_3, "root".pk as "Y0pk_Y1pk_Y2pk_Y3pk", null as fk1_1, null as fk1_2, null as fk1_3 from Y0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as fk_0, "root".fk as fk_1, null as fk_2, null as fk_3, "root".pk as "Y0pk_Y1pk_Y2pk_Y3pk", "g_0".fk1 as fk1_1, null as fk1_2, null as fk1_3 from Y1 as "root" left outer join G as "g_0" on ("root".fk = "g_0".fk0 and "g_0".from_z <= DATE\'2018-01-01\' and "g_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk_3, "root".pk as "Y0pk_Y1pk_Y2pk_Y3pk", null as fk1_1, "i_0".fk1 as fk1_2, null as fk1_3 from Y2 as "root" left outer join H as "h_0" on ("root".fk = "h_0".fk0 and "h_0".from_z <= DATE\'2018-01-01\' and "h_0".thru_z > DATE\'2018-01-01\') left outer join (select "i_1".fk1 as fk1, "i_1".fk0 as fk0 from I as "i_1" where "i_1".from_z <= DATE\'2018-01-01\' and "i_1".thru_z > DATE\'2018-01-01\') as "i_0" on ("h_0".fk1 = "i_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".from_z as "from_z_3", "root".thru_z as "thru_z_3", null as fk_0, null as fk_1, null as fk_2, "root".fk as fk_3, "root".pk as "Y0pk_Y1pk_Y2pk_Y3pk", null as fk1_1, null as fk1_2, "l_0".fk1 as fk1_3 from Y3 as "root" left outer join J as "j_0" on ("root".fk = "j_0".fk0 and "j_0".from_z <= DATE\'2018-01-01\' and "j_0".thru_z > DATE\'2018-01-01\') left outer join (select "k_1".fk0 as fk0, "k_1".fk1 from K as "k_1" where "k_1".from_z <= DATE\'2018-01-01\' and "k_1".thru_z > DATE\'2018-01-01\') as "k_0" on ("j_0".fk1 = "k_0".fk0) left outer join (select "l_1".fk1 as fk1, "l_1".fk0 as fk0 from L as "l_1" where "l_1".from_z <= DATE\'2018-01-01\' and "l_1".thru_z > DATE\'2018-01-01\') as "l_0" on ("k_0".fk1 = "l_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionalias_1" on (("unionBase".fk_0 = "unionalias_1".fk_0 or "unionBase".fk1_1 = "unionalias_1".fk_1 or "unionBase".fk1_2 = "unionalias_1".fk_2 or "unionBase".fk1_3 = "unionalias_1".fk_3) and ((coalesce("unionalias_1"."from_z_0", "unionalias_1"."from_z_1", "unionalias_1"."from_z_2", "unionalias_1"."from_z_3") <= DATE\'2018-01-01\' and coalesce("unionalias_1"."thru_z_0", "unionalias_1"."thru_z_1", "unionalias_1"."thru_z_2", "unionalias_1"."thru_z_3") > DATE\'2018-01-01\') or coalesce("unionalias_1"."from_z_0", "unionalias_1"."from_z_1", "unionalias_1"."from_z_2", "unionalias_1"."from_z_3", "unionalias_1"."thru_z_0", "unionalias_1"."thru_z_1", "unionalias_1"."thru_z_2", "unionalias_1"."thru_z_3") is null)) left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("unionalias_1".fk_0 = "z0_0".fk or "unionalias_1".fk1_1 = "z0_0".fk or "unionalias_1".fk1_2 = "z0_0".fk or "unionalias_1".fk1_3 = "z0_0".fk)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross4SetsV2__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1545)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionWithChainedJoinsAcross4SetsV3 (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."X0pk_X1pk_X2pk_X3pk" as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from (select "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", "root".pk as "pk_0_0", null as "pk_0_1", null as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", "root".fk as fk_0, null as fk_1, null as fk_2, null as fk_3, null as fk1_1, null as fk1_2, null as fk1_3 from X0 as "root" where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", null as "from_z_2", null as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as "pk_0_0", "root".pk as "pk_0_1", null as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, "root".fk as fk_1, null as fk_2, null as fk_3, "a_0".fk1 as fk1_1, null as fk1_2, null as fk1_3 from X1 as "root" left outer join A as "a_0" on ("root".fk = "a_0".fk0 and "a_0".from_z <= DATE\'2018-01-01\' and "a_0".thru_z > DATE\'2018-01-01\') where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", "root".from_z as "from_z_2", "root".thru_z as "thru_z_2", null as "from_z_3", null as "thru_z_3", null as "pk_0_0", null as "pk_0_1", "root".pk as "pk_0_2", null as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, null as fk_1, "root".fk as fk_2, null as fk_3, null as fk1_1, "c_0".fk1 as fk1_2, null as fk1_3 from X2 as "root" left outer join B as "b_0" on ("root".fk = "b_0".fk0 and "b_0".from_z <= DATE\'2018-01-01\' and "b_0".thru_z > DATE\'2018-01-01\') left outer join (select "c_1".fk1 as fk1, "c_1".fk0 as fk0 from C as "c_1" where "c_1".from_z <= DATE\'2018-01-01\' and "c_1".thru_z > DATE\'2018-01-01\') as "c_0" on ("b_0".fk1 = "c_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\' UNION ALL select null as "from_z_0", null as "thru_z_0", null as "from_z_1", null as "thru_z_1", null as "from_z_2", null as "thru_z_2", "root".from_z as "from_z_3", "root".thru_z as "thru_z_3", null as "pk_0_0", null as "pk_0_1", null as "pk_0_2", "root".pk as "pk_0_3", "root".pk as "X0pk_X1pk_X2pk_X3pk", null as fk_0, null as fk_1, null as fk_2, "root".fk as fk_3, null as fk1_1, null as fk1_2, "f_0".fk1 as fk1_3 from X3 as "root" left outer join D as "d_0" on ("root".fk = "d_0".fk0 and "d_0".from_z <= DATE\'2018-01-01\' and "d_0".thru_z > DATE\'2018-01-01\') left outer join (select "e_1".fk0 as fk0, "e_1".fk1 from E as "e_1" where "e_1".from_z <= DATE\'2018-01-01\' and "e_1".thru_z > DATE\'2018-01-01\') as "e_0" on ("d_0".fk1 = "e_0".fk0) left outer join (select "f_1".fk1 as fk1, "f_1".fk0 as fk0 from F as "f_1" where "f_1".from_z <= DATE\'2018-01-01\' and "f_1".thru_z > DATE\'2018-01-01\') as "f_0" on ("e_0".fk1 = "f_0".fk0) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\') as "unionBase" left outer join Y0 as "y0_0" on (("unionBase".fk_0 = "y0_0".fk or "unionBase".fk1_1 = "y0_0".fk or "unionBase".fk1_2 = "y0_0".fk or "unionBase".fk1_3 = "y0_0".fk) and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk)'
actual: 'select "root".pk as "x_pk", "y0_0".pk as "y_pk", "z0_0".pk as "z_pk" from X0 as "root" left outer join Y0 as "y0_0" on ("root".fk = "y0_0".fk and "y0_0".from_z <= DATE\'2018-01-01\' and "y0_0".thru_z > DATE\'2018-01-01\') left outer join (select "z0_1".fk as fk, "z0_1".pk as pk from Z0 as "z0_1" where "z0_1".from_z <= DATE\'2018-01-01\' and "z0_1".thru_z > DATE\'2018-01-01\') as "z0_0" on ("y0_0".fk = "z0_0".fk) where "root".from_z <= DATE\'2018-01-01\' and "root".thru_z > DATE\'2018-01-01\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionWithChainedJoinsAcross4SetsV3__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1596)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionedViewsToViewToUnion (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Execution error at (resource:/core_relational/relational/relationalMappingExecution.pure line:334 column:14), "Error executing sql query; SQL reason: Column "unionalias_2.PK_0" not found; SQL statement:
-- "executionTraceID" : "b4ff7e4e-9390-4c0b-83c9-60dcf02f9c5b"
select
"unionalias_1"."Z1pk_Z2pk" as "z"
from (
select
"root".pk as "pk_0_0",
null as "pk_0_1",
"root".fk as fk_0,
null as fk_1
from (
select
"root".pk as pk,
"root".fk as fk,
'2018-01-01' as "k_businessDate"
from X0 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01') as "root" UNION ALL
select
null as "pk_0_0",
"root".pk as "pk_0_1",
null as fk_0,
"root".fk as fk_1
from (
select
"root".pk as pk,
"root".fk as fk,
'2018-01-01' as "k_businessDate"
from X0 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01') as "root") as "unionBase"
left outer join (
select
"root".pk as pk,
"root".fk as fk,
'2018-01-01' as "k_businessDate"
from X0 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01') as "vx2_0"
on ("unionBase".fk_0 = "vx2_0".pk or "unionBase".fk_1 = "vx2_0".pk or "unionBase".fk_1 = "vx2_0".pk)
left outer join (
select
"unionalias_2".pk_0 as pk_0,
"unionalias_2".pk_1 as pk_1,
"unionalias_2"."Z1pk_Z2pk" as "Z1pk_Z2pk"
from (
select
"root".from_z as "from_z_0",
"root".thru_z as "thru_z_0",
null as "from_z_1",
null as "thru_z_1",
"root".pk as pk,
"root".pk as "Z1pk_Z2pk"
from Z1 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01' UNION ALL
select
null as "from_z_0",
null as "thru_z_0",
"root".from_z as "from_z_1",
"root".thru_z as "thru_z_1",
"root".pk as pk,
"root".pk as "Z1pk_Z2pk"
from Z2 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01') as "unionalias_2"
where (coalesce("unionalias_2"."from_z_0", "unionalias_2"."from_z_1") <= DATE'2018-01-01' and coalesce("unionalias_2"."thru_z_0", "unionalias_2"."thru_z_1") > DATE'2018-01-01') or coalesce("unionalias_2"."from_z_0", "unionalias_2"."from_z_1", "unionalias_2"."thru_z_0", "unionalias_2"."thru_z_1") is null) as "unionalias_1"
on ("vx2_0".fk = "unionalias_1".pk_0 or "vx2_0".fk = "unionalias_1".pk_1 or "vx2_0".fk = "unionalias_1".pk_0 or "vx2_0".fk = "unionalias_1".pk_1) [42122-214]; SQL error code: 42122; SQL state: 42S22"
at org.finos.legend.pure.runtime.java.extension.store.relational.compiled.natives.ResultSetRowIterableProvider.createResultSetIterator(ResultSetRowIterableProvider.java:195)
at org.finos.legend.pure.generated.RelationalGen.executeInDb(RelationalGen.java:217)
at org.finos.legend.pure.generated.core_relational_relational_relationalMappingExecution.Root_meta_relational_mapping_executeQuery_String_1__SQLQuery_$0_1$__Pair_MANY__DatabaseConnection_1__Runtime_1__Type_$0_1$__RoutedValueSpecification_$0_1$__Mapping_1__Integer_$0_1$__Integer_$0_1$__ExecutionContext_1__Extension_MANY__DebugContext_1__Result_1_(core_relational_relational_relationalMappingExecution.java:1454)
at org.finos.legend.pure.generated.core_relational_relational_relationalMappingExecution.Root_meta_relational_mapping_execution_Database_1__FunctionExpression_1__RoutedValueSpecification_$0_1$__Mapping_1__Runtime_1__Map_1__ExecutionContext_1__Extension_MANY__DebugContext_1__Result_1_(core_relational_relational_relationalMappingExecution.java:1440)
at org.finos.legend.pure.generated.core_relational_relational_contract_storeContract.Root_meta_relational_contract_execution_StoreQuery_1__RoutedValueSpecification_$0_1$__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__DebugContext_1__Result_1_(core_relational_relational_contract_storeContract.java:1040)
at jdk.internal.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.metadata.JavaMethodWithParamsSharedPureFunction.execute(JavaMethodWithParamsSharedPureFunction.java:59)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure.evaluate(Pure.java:358)
at org.finos.legend.pure.generated.CoreGen.evaluate(CoreGen.java:72)
at org.finos.legend.pure.generated.core_pure_router_router_execution$23.execute(core_pure_router_router_execution.java:424)
at org.finos.legend.pure.generated.core_pure_router_router_execution.Root_meta_pure_router_execution_executeExpression_ClusteredValueSpecification_MANY__Map_1__Activity_MANY__ExecutionContext_$0_1$__Extension_MANY__DebugContext_1__Result_1_(core_pure_router_router_execution.java:448)
at org.finos.legend.pure.generated.core_pure_router_router_execution$20.value(core_pure_router_router_execution.java:358)
at org.finos.legend.pure.generated.core_pure_router_router_execution$20.value(core_pure_router_router_execution.java:357)
at org.eclipse.collections.impl.utility.internal.RandomAccessListIterate.injectInto(RandomAccessListIterate.java:748)
at org.eclipse.collections.impl.utility.ListIterate.injectInto(ListIterate.java:962)
at org.eclipse.collections.impl.list.immutable.AbstractImmutableList.injectInto(AbstractImmutableList.java:438)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.fold(CompiledSupport.java:691)
at org.finos.legend.pure.generated.core_pure_router_router_execution.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__DebugContext_1__Result_1_(core_pure_router_router_execution.java:357)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.valueOf(core_pure_router_router_entry.java:185)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.execute(core_pure_router_router_entry.java:180)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7$2.execute(core_pure_router_router_entry.java:171)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure.evaluate(Pure.java:366)
at org.finos.legend.pure.runtime.java.extension.functions.compiled.FunctionsHelper.legendTest(FunctionsHelper.java:1694)
at org.finos.legend.pure.generated.FunctionsGen.legendTest(FunctionsGen.java:107)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.valueOf(core_pure_router_router_entry.java:134)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.execute(core_pure_router_router_entry.java:129)
at org.finos.legend.pure.generated.core_pure_router_router_entry$7.execute(core_pure_router_router_entry.java:120)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure.evaluate(Pure.java:366)
at org.finos.legend.pure.runtime.java.extension.functions.compiled.FunctionsHelper.traceSpan(FunctionsHelper.java:1641)
at org.finos.legend.pure.generated.FunctionsGen.traceSpan(FunctionsGen.java:268)
at org.finos.legend.pure.generated.core_pure_router_router_entry.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__Result_1_(core_pure_router_router_entry.java:116)
at org.finos.legend.pure.generated.core_pure_router_router_entry.Root_meta_pure_router_execute_FunctionDefinition_1__Mapping_1__Runtime_1__Extension_MANY__Result_1_(core_pure_router_router_entry.java:111)
at org.finos.legend.pure.generated.core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.Root_meta_relational_tests_mapping_union_multipleChainedJoins_testUnionedViewsToViewToUnion__Boolean_1_(core_relational_relational_tests_mapping_union_testUnionWithMultipleChainedJoins.java:1618)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "unionalias_2.PK_0" not found; SQL statement:
-- "executionTraceID" : "b4ff7e4e-9390-4c0b-83c9-60dcf02f9c5b"
select
"unionalias_1"."Z1pk_Z2pk" as "z"
from (
select
"root".pk as "pk_0_0",
null as "pk_0_1",
"root".fk as fk_0,
null as fk_1
from (
select
"root".pk as pk,
"root".fk as fk,
'2018-01-01' as "k_businessDate"
from X0 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01') as "root" UNION ALL
select
null as "pk_0_0",
"root".pk as "pk_0_1",
null as fk_0,
"root".fk as fk_1
from (
select
"root".pk as pk,
"root".fk as fk,
'2018-01-01' as "k_businessDate"
from X0 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01') as "root") as "unionBase"
left outer join (
select
"root".pk as pk,
"root".fk as fk,
'2018-01-01' as "k_businessDate"
from X0 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01') as "vx2_0"
on ("unionBase".fk_0 = "vx2_0".pk or "unionBase".fk_1 = "vx2_0".pk or "unionBase".fk_1 = "vx2_0".pk)
left outer join (
select
"unionalias_2".pk_0 as pk_0,
"unionalias_2".pk_1 as pk_1,
"unionalias_2"."Z1pk_Z2pk" as "Z1pk_Z2pk"
from (
select
"root".from_z as "from_z_0",
"root".thru_z as "thru_z_0",
null as "from_z_1",
null as "thru_z_1",
"root".pk as pk,
"root".pk as "Z1pk_Z2pk"
from Z1 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01' UNION ALL
select
null as "from_z_0",
null as "thru_z_0",
"root".from_z as "from_z_1",
"root".thru_z as "thru_z_1",
"root".pk as pk,
"root".pk as "Z1pk_Z2pk"
from Z2 as "root"
where "root".from_z <= DATE'2018-01-01' and "root".thru_z > DATE'2018-01-01') as "unionalias_2"
where (coalesce("unionalias_2"."from_z_0", "unionalias_2"."from_z_1") <= DATE'2018-01-01' and coalesce("unionalias_2"."thru_z_0", "unionalias_2"."thru_z_1") > DATE'2018-01-01') or coalesce("unionalias_2"."from_z_0", "unionalias_2"."from_z_1", "unionalias_2"."thru_z_0", "unionalias_2"."thru_z_1") is null) as "unionalias_1"
on ("vx2_0".fk = "unionalias_1".pk_0 or "vx2_0".fk = "unionalias_1".pk_1 or "vx2_0".fk = "unionalias_1".pk_0 or "vx2_0".fk = "unionalias_1".pk_1) [42122-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:223)
at org.h2.message.DbException.get(DbException.java:199)
at org.h2.expression.ExpressionColumn.getColumnException(ExpressionColumn.java:244)
at org.h2.expression.ExpressionColumn.optimizeOther(ExpressionColumn.java:226)
at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:213)
at org.h2.expression.Alias.optimize(Alias.java:52)
at org.h2.command.query.Select.prepareExpressions(Select.java:1170)
at org.h2.table.DerivedTable.<init>(DerivedTable.java:41)
at org.h2.command.query.Query.toTable(Query.java:1004)
at org.h2.command.Parser.readDerivedTableWithCorrelation(Parser.java:1918)
at org.h2.command.Parser.readTablePrimary(Parser.java:1795)
at org.h2.command.Parser.readTableReference(Parser.java:2334)
at org.h2.command.Parser.readTableReference(Parser.java:2351)
at org.h2.command.Parser.parseSelectFromPart(Parser.java:2772)
at org.h2.command.Parser.parseSelect(Parser.java:2878)
at org.h2.command.Parser.parseQueryPrimary(Parser.java:2762)
at org.h2.command.Parser.parseQueryTerm(Parser.java:2633)
at org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2612)
at org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2605)
at org.h2.command.Parser.parseQueryExpression(Parser.java:2598)
at org.h2.command.Parser.parseQuery(Parser.java:2567)
at org.h2.command.Parser.parsePrepared(Parser.java:724)
at org.h2.command.Parser.parse(Parser.java:689)
at org.h2.command.Parser.parse(Parser.java:661)
at org.h2.command.Parser.prepareCommand(Parser.java:569)
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:237)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:223)
at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
at org.finos.legend.pure.runtime.java.extension.store.relational.compiled.natives.ResultSetRowIterableProvider.createResultSetIterator(ResultSetRowIterableProvider.java:88)
... 67 more
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testInThruInclusiveUnionInThruInclusive (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase".u_type as u_type, "unionBase"."pk_0_0" as "pk_0_0", "unionBase"."pk_0_1" as "pk_0_1", "unionBase"."id" as "id" from (select \'0\' as u_type, "root".id as "pk_0_0", null as "pk_0_1", "root".id as "id", null as prodFk_1 from MyOrderTable as "root" UNION ALL select \'1\' as u_type, null as "pk_0_0", "root".id as "pk_0_1", "root".id as "id", "root".prodFk as prodFk_1 from MyOrderTable as "root") as "unionBase" left outer join BiTemporalProductTable_In_Thru_Inclusive as "bitemporalproducttable_in_thru_inclusive_0" on ("unionBase".prodFk_1 = "bitemporalproducttable_in_thru_inclusive_0".id and ("bitemporalproducttable_in_thru_inclusive_0".in_z <= DATE\'2018-05-05\' and "bitemporalproducttable_in_thru_inclusive_0".out_z > DATE\'2018-05-05\' and "bitemporalproducttable_in_thru_inclusive_0".from_z < DATE\'2018-05-04\' and "bitemporalproducttable_in_thru_inclusive_0".thru_z >= DATE\'2018-05-04\')) where "bitemporalproducttable_in_thru_inclusive_0".name = \'def2\''
actual: 'select "root".id as "pk_0", "root".id as "id" from MyOrderTable as "root" left outer join BiTemporalProductTable_In_Thru_Inclusive as "bitemporalproducttable_in_thru_inclusive_0" on ("root".prodFk = "bitemporalproducttable_in_thru_inclusive_0".id and ("bitemporalproducttable_in_thru_inclusive_0".in_z <= DATE\'2018-05-05\' and "bitemporalproducttable_in_thru_inclusive_0".out_z > DATE\'2018-05-05\' and "bitemporalproducttable_in_thru_inclusive_0".from_z < DATE\'2018-05-04\' and "bitemporalproducttable_in_thru_inclusive_0".thru_z >= DATE\'2018-05-04\')) where "bitemporalproducttable_in_thru_inclusive_0".name = \'def2\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testMilestoningWithInclusive.Root_meta_relational_tests_milestoning_inclusive_testInThruInclusiveUnionInThruInclusive__Boolean_1_(core_relational_relational_milestoning_tests_testMilestoningWithInclusive.java:732)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testInThruInclusiveUnionOutFromInclusive (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase".u_type as u_type, "unionBase"."pk_0_0" as "pk_0_0", "unionBase"."pk_1_0" as "pk_1_0", "unionBase"."pk_0_1" as "pk_0_1", "unionBase"."pk_1_1" as "pk_1_1", "unionBase"."id" as "id", "unionBase"."name" as "name", "unionBase"."k_processingDate" as "k_processingDate", "unionBase"."k_businessDate" as "k_businessDate", "unionBase"."from_z_0" as "from_z_0", "unionBase"."thru_z_0" as "thru_z_0", "unionBase"."in_z_0" as "in_z_0", "unionBase"."out_z_0" as "out_z_0", "unionBase"."from_z_1" as "from_z_1", "unionBase"."thru_z_1" as "thru_z_1", "unionBase"."in_z_1" as "in_z_1", "unionBase"."out_z_1" as "out_z_1" from (select \'0\' as u_type, "root".id as "pk_0_0", "root".name as "pk_1_0", null as "pk_0_1", null as "pk_1_1", "root".id as "id", "root".name as "name", \'2018-05-05\' as "k_processingDate", \'2018-05-04\' as "k_businessDate", "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", "root".in_z as "in_z_0", "root".out_z as "out_z_0", null as "from_z_1", null as "thru_z_1", null as "in_z_1", null as "out_z_1", "root".id as "BiTemporalProductTable_In_Thru_Inclusiveid_BiTemporalProductTable_Out_From_Inclusiveid" from BiTemporalProductTable_In_Thru_Inclusive as "root" where "root".in_z <= DATE\'2018-05-05\' and "root".out_z > DATE\'2018-05-05\' and "root".from_z < DATE\'2018-05-04\' and "root".thru_z >= DATE\'2018-05-04\' UNION ALL select \'1\' as u_type, null as "pk_0_0", null as "pk_1_0", "root".id as "pk_0_1", "root".name as "pk_1_1", "root".id as "id", "root".name as "name", \'2018-05-05\' as "k_processingDate", \'2018-05-04\' as "k_businessDate", null as "from_z_0", null as "thru_z_0", null as "in_z_0", null as "out_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", "root".in_z as "in_z_1", "root".out_z as "out_z_1", "root".id as "BiTemporalProductTable_In_Thru_Inclusiveid_BiTemporalProductTable_Out_From_Inclusiveid" from BiTemporalProductTable_Out_From_Inclusive as "root" where "root".in_z < DATE\'2018-05-05\' and "root".out_z >= DATE\'2018-05-05\' and "root".from_z <= DATE\'2018-05-04\' and "root".thru_z > DATE\'2018-05-04\') as "unionBase" where "unionBase"."BiTemporalProductTable_In_Thru_Inclusiveid_BiTemporalProductTable_Out_From_Inclusiveid" = 2'
actual: 'select "root".id as "pk_0", "root".name as "pk_1", "root".id as "id", "root".name as "name", \'2018-05-05\' as "k_processingDate", \'2018-05-04\' as "k_businessDate" from BiTemporalProductTable_Out_From_Inclusive as "root" where "root".id = 2 and "root".in_z < DATE\'2018-05-05\' and "root".out_z >= DATE\'2018-05-05\' and "root".from_z <= DATE\'2018-05-04\' and "root".thru_z > DATE\'2018-05-04\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testMilestoningWithInclusive.Root_meta_relational_tests_milestoning_inclusive_testInThruInclusiveUnionOutFromInclusive__Boolean_1_(core_relational_relational_milestoning_tests_testMilestoningWithInclusive.java:702)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testOutFromInclusiveUnionInThruInclusive (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase".u_type as u_type, "unionBase"."pk_0_0" as "pk_0_0", "unionBase"."pk_1_0" as "pk_1_0", "unionBase"."pk_0_1" as "pk_0_1", "unionBase"."pk_1_1" as "pk_1_1", "unionBase"."id" as "id", "unionBase"."name" as "name", "unionBase"."k_processingDate" as "k_processingDate", "unionBase"."k_businessDate" as "k_businessDate", "unionBase"."from_z_0" as "from_z_0", "unionBase"."thru_z_0" as "thru_z_0", "unionBase"."in_z_0" as "in_z_0", "unionBase"."out_z_0" as "out_z_0", "unionBase"."from_z_1" as "from_z_1", "unionBase"."thru_z_1" as "thru_z_1", "unionBase"."in_z_1" as "in_z_1", "unionBase"."out_z_1" as "out_z_1" from (select \'0\' as u_type, "root".id as "pk_0_0", "root".name as "pk_1_0", null as "pk_0_1", null as "pk_1_1", "root".id as "id", "root".name as "name", \'2018-05-05\' as "k_processingDate", \'2018-05-04\' as "k_businessDate", "root".from_z as "from_z_0", "root".thru_z as "thru_z_0", "root".in_z as "in_z_0", "root".out_z as "out_z_0", null as "from_z_1", null as "thru_z_1", null as "in_z_1", null as "out_z_1", "root".id as "BiTemporalProductTable_Out_From_Inclusiveid_BiTemporalProductTable_In_Thru_Inclusiveid" from BiTemporalProductTable_Out_From_Inclusive as "root" where "root".in_z < DATE\'2018-05-05\' and "root".out_z >= DATE\'2018-05-05\' and "root".from_z <= DATE\'2018-05-04\' and "root".thru_z > DATE\'2018-05-04\' UNION ALL select \'1\' as u_type, null as "pk_0_0", null as "pk_1_0", "root".id as "pk_0_1", "root".name as "pk_1_1", "root".id as "id", "root".name as "name", \'2018-05-05\' as "k_processingDate", \'2018-05-04\' as "k_businessDate", null as "from_z_0", null as "thru_z_0", null as "in_z_0", null as "out_z_0", "root".from_z as "from_z_1", "root".thru_z as "thru_z_1", "root".in_z as "in_z_1", "root".out_z as "out_z_1", "root".id as "BiTemporalProductTable_Out_From_Inclusiveid_BiTemporalProductTable_In_Thru_Inclusiveid" from BiTemporalProductTable_In_Thru_Inclusive as "root" where "root".in_z <= DATE\'2018-05-05\' and "root".out_z > DATE\'2018-05-05\' and "root".from_z < DATE\'2018-05-04\' and "root".thru_z >= DATE\'2018-05-04\') as "unionBase" where "unionBase"."BiTemporalProductTable_Out_From_Inclusiveid_BiTemporalProductTable_In_Thru_Inclusiveid" = 2'
actual: 'select "root".id as "pk_0", "root".name as "pk_1", "root".id as "id", "root".name as "name", \'2018-05-05\' as "k_processingDate", \'2018-05-04\' as "k_businessDate" from BiTemporalProductTable_In_Thru_Inclusive as "root" where "root".id = 2 and "root".in_z <= DATE\'2018-05-05\' and "root".out_z > DATE\'2018-05-05\' and "root".from_z < DATE\'2018-05-04\' and "root".thru_z >= DATE\'2018-05-04\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testMilestoningWithInclusive.Root_meta_relational_tests_milestoning_inclusive_testOutFromInclusiveUnionInThruInclusive__Boolean_1_(core_relational_relational_milestoning_tests_testMilestoningWithInclusive.java:717)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testOutFromInclusiveUnionOutFromInclusive (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase".u_type as u_type, "unionBase"."pk_0_0" as "pk_0_0", "unionBase"."pk_0_1" as "pk_0_1", "unionBase"."id" as "id" from (select \'0\' as u_type, "root".id as "pk_0_0", null as "pk_0_1", "root".id as "id", null as prodFk_1 from MyOrderTable as "root" UNION ALL select \'1\' as u_type, null as "pk_0_0", "root".id as "pk_0_1", "root".id as "id", "root".prodFk as prodFk_1 from MyOrderTable as "root") as "unionBase" left outer join BiTemporalProductTable_Out_From_Inclusive as "bitemporalproducttable_out_from_inclusive_0" on ("unionBase".prodFk_1 = "bitemporalproducttable_out_from_inclusive_0".id and ("bitemporalproducttable_out_from_inclusive_0".in_z < DATE\'2018-05-05\' and "bitemporalproducttable_out_from_inclusive_0".out_z >= DATE\'2018-05-05\' and "bitemporalproducttable_out_from_inclusive_0".from_z <= DATE\'2018-05-04\' and "bitemporalproducttable_out_from_inclusive_0".thru_z > DATE\'2018-05-04\')) where "bitemporalproducttable_out_from_inclusive_0".name = \'def2\''
actual: 'select "root".id as "pk_0", "root".id as "id" from MyOrderTable as "root" left outer join BiTemporalProductTable_Out_From_Inclusive as "bitemporalproducttable_out_from_inclusive_0" on ("root".prodFk = "bitemporalproducttable_out_from_inclusive_0".id and ("bitemporalproducttable_out_from_inclusive_0".in_z < DATE\'2018-05-05\' and "bitemporalproducttable_out_from_inclusive_0".out_z >= DATE\'2018-05-05\' and "bitemporalproducttable_out_from_inclusive_0".from_z <= DATE\'2018-05-04\' and "bitemporalproducttable_out_from_inclusive_0".thru_z > DATE\'2018-05-04\')) where "bitemporalproducttable_out_from_inclusive_0".name = \'def2\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testMilestoningWithInclusive.Root_meta_relational_tests_milestoning_inclusive_testOutFromInclusiveUnionOutFromInclusive__Boolean_1_(core_relational_relational_milestoning_tests_testMilestoningWithInclusive.java:747)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testDateTimeMilestoningParamUnion (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionalias_1"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" as "type" from (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".type as type_0, null as type_1, "root".id as "pk_0_0", null as "pk_0_1" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date) UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", null as type_0, "root".type as type_1, null as "pk_0_0", "root".id as "pk_0_1" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date)) as "unionBase" left outer join (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".type as type, "root".type_description as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description", "root".type as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date) UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", "root".type as type, "root".type_description as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description", "root".type as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date)) as "unionalias_1" on (("unionBase".type_0 = "unionalias_1".type or "unionBase".type_1 = "unionalias_1".type) and (coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date) or coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") is null)) where "unionalias_1"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description" = \'STOCK DESC-V2\''
actual: 'select "productclassificationtablewithbusinesssnapshotmilestoning_0".type as "type" from ProductTableWithBusinessSnapshotMilestoning as "root" left outer join ProductClassificationTableWithBusinessSnapshotMilestoning as "productclassificationtablewithbusinesssnapshotmilestoning_0" on ("root".type = "productclassificationtablewithbusinesssnapshotmilestoning_0".type and "productclassificationtablewithbusinesssnapshotmilestoning_0".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date)) where "productclassificationtablewithbusinesssnapshotmilestoning_0".type_description = \'STOCK DESC-V2\' and "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date)'"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.Root_meta_relational_tests_milestoning_snapshot_testDateTimeMilestoningParamUnion__Boolean_1_(core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.java:1361)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testDateTimeVariableMilestoningParamUnion (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionalias_1"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" as "type" from (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".type as type_0, null as type_1, "root".id as "pk_0_0", null as "pk_0_1" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date) UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", null as type_0, "root".type as type_1, null as "pk_0_0", "root".id as "pk_0_1" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date)) as "unionBase" left outer join (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".type as type, "root".type_description as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description", "root".type as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date) UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", "root".type as type, "root".type_description as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description", "root".type as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date)) as "unionalias_1" on (("unionBase".type_0 = "unionalias_1".type or "unionBase".type_1 = "unionalias_1".type) and (coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date) or coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") is null)) where "unionalias_1"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description" = \'STOCK DESC-V2\''
actual: 'select "productclassificationtablewithbusinesssnapshotmilestoning_0".type as "type" from ProductTableWithBusinessSnapshotMilestoning as "root" left outer join ProductClassificationTableWithBusinessSnapshotMilestoning as "productclassificationtablewithbusinesssnapshotmilestoning_0" on ("root".type = "productclassificationtablewithbusinesssnapshotmilestoning_0".type and "productclassificationtablewithbusinesssnapshotmilestoning_0".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date)) where "productclassificationtablewithbusinesssnapshotmilestoning_0".type_description = \'STOCK DESC-V2\' and "root".snapshotDate = cast(truncate(TIMESTAMP\'2015-08-26 02:00:00\') as date)'"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.Root_meta_relational_tests_milestoning_snapshot_testDateTimeVariableMilestoningParamUnion__Boolean_1_(core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.java:1374)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionQueryOnNonTemporalRootWithTemporalProperty (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionalias_1"."ProductTableWithBusinessSnapshotMilestoningid_ProductTableWithBusinessSnapshotMilestoningid" as "id" from (select "root".prodFk as prodFk_0, null as prodFk_1, "root".id as "pk_0_0", null as "pk_0_1" from OrderTable as "root" UNION ALL select null as prodFk_0, "root".prodFk as prodFk_1, null as "pk_0_0", "root".id as "pk_0_1" from OrderTable as "root") as "unionBase" left outer join (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".id as id, "root".name as "ProductTableWithBusinessSnapshotMilestoningname_ProductTableWithBusinessSnapshotMilestoningname", "root".id as "ProductTableWithBusinessSnapshotMilestoningid_ProductTableWithBusinessSnapshotMilestoningid" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\' UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", "root".id as id, "root".name as "ProductTableWithBusinessSnapshotMilestoningname_ProductTableWithBusinessSnapshotMilestoningname", "root".id as "ProductTableWithBusinessSnapshotMilestoningid_ProductTableWithBusinessSnapshotMilestoningid" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\') as "unionalias_1" on (("unionBase".prodFk_0 = "unionalias_1".id or "unionBase".prodFk_1 = "unionalias_1".id) and (coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") = DATE\'2015-08-26\' or coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") is null)) where "unionalias_1"."ProductTableWithBusinessSnapshotMilestoningname_ProductTableWithBusinessSnapshotMilestoningname" = \'ProductName1\''
actual: 'select "producttablewithbusinesssnapshotmilestoning_0".id as "id" from OrderTable as "root" left outer join ProductTableWithBusinessSnapshotMilestoning as "producttablewithbusinesssnapshotmilestoning_0" on ("root".prodFk = "producttablewithbusinesssnapshotmilestoning_0".id and "producttablewithbusinesssnapshotmilestoning_0".snapshotDate = DATE\'2015-08-26\') where "producttablewithbusinesssnapshotmilestoning_0".name = \'ProductName1\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.Root_meta_relational_tests_milestoning_snapshot_testUnionQueryOnNonTemporalRootWithTemporalProperty__Boolean_1_(core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.java:1231)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionQueryOnTemporalRoot (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionBase"."ProductTableWithBusinessSnapshotMilestoningid_ProductTableWithBusinessSnapshotMilestoningid" as "id" from (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".name as "ProductTableWithBusinessSnapshotMilestoningname_ProductTableWithBusinessSnapshotMilestoningname", "root".id as "pk_0_0", null as "pk_0_1", "root".id as "ProductTableWithBusinessSnapshotMilestoningid_ProductTableWithBusinessSnapshotMilestoningid" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\' UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", "root".name as "ProductTableWithBusinessSnapshotMilestoningname_ProductTableWithBusinessSnapshotMilestoningname", null as "pk_0_0", "root".id as "pk_0_1", "root".id as "ProductTableWithBusinessSnapshotMilestoningid_ProductTableWithBusinessSnapshotMilestoningid" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\') as "unionBase" where "unionBase"."ProductTableWithBusinessSnapshotMilestoningname_ProductTableWithBusinessSnapshotMilestoningname" = \'ProductName1\''
actual: 'select "root".id as "id" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".name = \'ProductName1\' and "root".snapshotDate = DATE\'2015-08-26\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.Root_meta_relational_tests_milestoning_snapshot_testUnionQueryOnTemporalRoot__Boolean_1_(core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.java:1218)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionQueryWithPropagationOnNonTemporalRootWithTemporalProperty (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionalias_3"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" as "type" from (select "root".prodFk as prodFk_0, null as prodFk_1, "root".id as "pk_0_0", null as "pk_0_1" from OrderTable as "root" UNION ALL select null as prodFk_0, "root".prodFk as prodFk_1, null as "pk_0_0", "root".id as "pk_0_1" from OrderTable as "root") as "unionBase" left outer join (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".id as id, "root".type as type_0, null as type_1 from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\' UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", "root".id as id, null as type_0, "root".type as type_1 from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\') as "unionalias_1" on (("unionBase".prodFk_0 = "unionalias_1".id or "unionBase".prodFk_1 = "unionalias_1".id) and (coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") = DATE\'2015-08-26\' or coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") is null)) left outer join (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".type as type, "root".type_description as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\' UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", "root".type as type, "root".type_description as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\') as "unionalias_2" on (("unionalias_1".type_0 = "unionalias_2".type or "unionalias_1".type_1 = "unionalias_2".type) and (coalesce("unionalias_2"."snapshotDate_0", "unionalias_2"."snapshotDate_1") = DATE\'2015-08-26\' or coalesce("unionalias_2"."snapshotDate_0", "unionalias_2"."snapshotDate_1") is null)) left outer join (select "unionalias_4".type as type, "unionalias_4"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".type as type, "root".type as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\' UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", "root".type as type, "root".type as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\') as "unionalias_4" where coalesce("unionalias_4"."snapshotDate_0", "unionalias_4"."snapshotDate_1") = DATE\'2015-08-26\' or coalesce("unionalias_4"."snapshotDate_0", "unionalias_4"."snapshotDate_1") is null) as "unionalias_3" on ("unionalias_1".type_0 = "unionalias_3".type or "unionalias_1".type_1 = "unionalias_3".type) where "unionalias_2"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description" = \'STOCK DESC-V2\''
actual: 'select "productclassificationtablewithbusinesssnapshotmilestoning_1".type as "type" from OrderTable as "root" left outer join ProductTableWithBusinessSnapshotMilestoning as "producttablewithbusinesssnapshotmilestoning_0" on ("root".prodFk = "producttablewithbusinesssnapshotmilestoning_0".id and "producttablewithbusinesssnapshotmilestoning_0".snapshotDate = DATE\'2015-08-26\') left outer join ProductClassificationTableWithBusinessSnapshotMilestoning as "productclassificationtablewithbusinesssnapshotmilestoning_0" on ("producttablewithbusinesssnapshotmilestoning_0".type = "productclassificationtablewithbusinesssnapshotmilestoning_0".type and "productclassificationtablewithbusinesssnapshotmilestoning_0".snapshotDate = DATE\'2015-08-26\') left outer join (select "productclassificationtablewithbusinesssnapshotmilestoning_2".type as type from ProductClassificationTableWithBusinessSnapshotMilestoning as "productclassificationtablewithbusinesssnapshotmilestoning_2" where "productclassificationtablewithbusinesssnapshotmilestoning_2".snapshotDate = DATE\'2015-08-26\') as "productclassificationtablewithbusinesssnapshotmilestoning_1" on ("producttablewithbusinesssnapshotmilestoning_0".type = "productclassificationtablewithbusinesssnapshotmilestoning_1".type) where "productclassificationtablewithbusinesssnapshotmilestoning_0".type_description = \'STOCK DESC-V2\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.Root_meta_relational_tests_milestoning_snapshot_testUnionQueryWithPropagationOnNonTemporalRootWithTemporalProperty__Boolean_1_(core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.java:1257)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testUnionQueryWithPropagationOnTemporalRoot (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'select "unionalias_1"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" as "type" from (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".type as type_0, null as type_1, "root".id as "pk_0_0", null as "pk_0_1" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\' UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", null as type_0, "root".type as type_1, null as "pk_0_0", "root".id as "pk_0_1" from ProductTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\') as "unionBase" left outer join (select "root".snapshotDate as "snapshotDate_0", null as "snapshotDate_1", "root".type as type, "root".type_description as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description", "root".type as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\' UNION ALL select null as "snapshotDate_0", "root".snapshotDate as "snapshotDate_1", "root".type as type, "root".type_description as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description", "root".type as "ProductClassificationTableWithBusinessSnapshotMilestoningtype_ProductClassificationTableWithBusinessSnapshotMilestoningtype" from ProductClassificationTableWithBusinessSnapshotMilestoning as "root" where "root".snapshotDate = DATE\'2015-08-26\') as "unionalias_1" on (("unionBase".type_0 = "unionalias_1".type or "unionBase".type_1 = "unionalias_1".type) and (coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") = DATE\'2015-08-26\' or coalesce("unionalias_1"."snapshotDate_0", "unionalias_1"."snapshotDate_1") is null)) where "unionalias_1"."ProductClassificationTableWithBusinessSnapshotMilestoningtype_description_ProductClassificationTableWithBusinessSnapshotMilestoningtype_description" = \'STOCK DESC-V2\''
actual: 'select "productclassificationtablewithbusinesssnapshotmilestoning_0".type as "type" from ProductTableWithBusinessSnapshotMilestoning as "root" left outer join ProductClassificationTableWithBusinessSnapshotMilestoning as "productclassificationtablewithbusinesssnapshotmilestoning_0" on ("root".type = "productclassificationtablewithbusinesssnapshotmilestoning_0".type and "productclassificationtablewithbusinesssnapshotmilestoning_0".snapshotDate = DATE\'2015-08-26\') where "productclassificationtablewithbusinesssnapshotmilestoning_0".type_description = \'STOCK DESC-V2\' and "root".snapshotDate = DATE\'2015-08-26\''"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.Root_meta_relational_functions_sqlQueryToString_h2_assertEqualsH2Compatible_Any_1__Any_1__Any_1__Boolean_1_(core_relational_relational_sqlQueryToString_dbSpecific_h2_h2Extension.java:59)
at org.finos.legend.pure.generated.core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.Root_meta_relational_tests_milestoning_snapshot_testUnionQueryWithPropagationOnTemporalRoot__Boolean_1_(core_relational_relational_milestoning_tests_testBusinessSnapshotMilestoning.java:1244)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
validateAllConstraintsWithInnerJoinInFilter (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Assert failure at (resource:/platform/pure/basics/tests/assert.pure line:21 column:5), "
expected: 'CONSTRAINT_ID,ENFORCEMENT_LEVEL,MESSAGE,ID
knownAccount,Error,Account unknown,1
isATypeAccount,Warn,Account is not Type A : ,1
'
actual: 'CONSTRAINT_ID,ENFORCEMENT_LEVEL,MESSAGE,ID
etiNotEmpty,Error,External Trade ID is not valid,2
validLocation,Warn,Location is not known,3
validLocation,Warn,Location is not known,4
quantityInValidRange,Error,Quantity not in range: 1000000,5
latestEventDateValid,Error,Latest event date is not valid,2
knownProduct,Error,Product unknown,4
knownAccount,Error,Account unknown,1
isATypeAccount,Warn,Account is not Type A : ,1
isATypeAccount,Warn,Account is not Type A : Account_3_B,4
cusipExists,Error,Product cusip empty,3
cusipExists,Error,Product cusip empty,4
'"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.pureAssert(CompiledSupport.java:1478)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assert.Root_meta_pure_functions_asserts_assert_Boolean_1__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assert.java:40)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__String_1__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:65)
at org.finos.legend.pure.generated.platform_pure_basics_tests_assertEquals.Root_meta_pure_functions_asserts_assertEquals_Any_MANY__Any_MANY__Boolean_1_(platform_pure_basics_tests_assertEquals.java:58)
at org.finos.legend.pure.generated.core_relational_relational_validation_showcase_validationStandaloneShowcase.Root_meta_relational_validation_showcase_standalone_validateAllConstraintsWithInnerJoinInFilter__Boolean_1_(core_relational_relational_validation_showcase_validationStandaloneShowcase.java:469)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testCrossDbPlanGenerationWithFromWithoutExternalMapping (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Execution error at (resource:/core_relational/relational/pureToSQLQuery/pureToSQLQuery.pure line:3334 column:65), "Cast exception: InstanceValue cannot be cast to StoreMappingRoutedValueSpecification"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.castWithExceptionHandling(CompiledSupport.java:1961)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processGetAll_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__RelationalOperationElement_1_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:20607)
at jdk.internal.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.metadata.JavaMethodWithParamsSharedPureFunction.execute(JavaMethodWithParamsSharedPureFunction.java:59)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure._evaluateToMany(Pure.java:429)
at org.finos.legend.pure.generated.CoreGen.evaluateToMany(CoreGen.java:91)
at org.finos.legend.pure.generated.CoreGen.evaluateToMany(CoreGen.java:78)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1123.execute(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:17416)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processFunctionExpressionForNonPropertyFunction_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:17416)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1027.valueOf(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14896)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processFunctionExpression_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14898)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1008.valueOf(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14394)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processValueSpecificationReturnPropertyMapping_ValueSpecification_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14396)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processValueSpecification_ValueSpecification_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__RelationalOperationElement_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14362)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processProject_String_MANY__Function_MANY__String_MANY__FunctionExpression_1__SelectWithCursor_1__Map_1__State_1__String_1__List_1__DebugContext_1__WindowColumnSpecification_MANY__Extension_MANY__RelationalOperationElement_1_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:25488)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processProjectColumns_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__RelationalOperationElement_1_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:25144)
at jdk.internal.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.metadata.JavaMethodWithParamsSharedPureFunction.execute(JavaMethodWithParamsSharedPureFunction.java:59)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure._evaluateToMany(Pure.java:429)
at org.finos.legend.pure.generated.CoreGen.evaluateToMany(CoreGen.java:91)
at org.finos.legend.pure.generated.CoreGen.evaluateToMany(CoreGen.java:78)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1123.execute(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:17416)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processFunctionExpressionForNonPropertyFunction_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:17416)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1027.valueOf(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14896)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processFunctionExpression_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14898)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1008.valueOf(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14394)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processValueSpecificationReturnPropertyMapping_ValueSpecification_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14396)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processValueSpecification_ValueSpecification_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__RelationalOperationElement_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14362)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processTdsJoin_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__RelationalOperationElement_1_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:23089)
at jdk.internal.reflect.GeneratedMethodAccessor160.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.metadata.JavaMethodWithParamsSharedPureFunction.execute(JavaMethodWithParamsSharedPureFunction.java:59)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure._evaluateToMany(Pure.java:429)
at org.finos.legend.pure.generated.CoreGen.evaluateToMany(CoreGen.java:91)
at org.finos.legend.pure.generated.CoreGen.evaluateToMany(CoreGen.java:78)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1123.execute(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:17416)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processFunctionExpressionForNonPropertyFunction_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:17416)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1027.valueOf(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14896)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processFunctionExpression_FunctionExpression_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14898)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery$1008.valueOf(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14394)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processValueSpecificationReturnPropertyMapping_ValueSpecification_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__OperationWithParentPropertyMapping_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14396)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processValueSpecification_ValueSpecification_1__PropertyMapping_MANY__SelectWithCursor_1__Map_1__State_1__JoinType_1__String_1__List_1__DebugContext_1__Extension_MANY__RelationalOperationElement_MANY_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14362)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_processQuery_FunctionExpression_1__State_1__DebugContext_1__Extension_MANY__SelectWithCursor_1_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14006)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_toSQLQuery_FunctionExpression_1__Mapping_1__Map_1__DebugContext_1__State_1__Extension_MANY__SQLQuery_1_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14037)
at org.finos.legend.pure.generated.core_relational_relational_pureToSQLQuery_pureToSQLQuery.Root_meta_relational_functions_pureToSqlQuery_toSQLQuery_FunctionExpression_1__Mapping_1__Map_1__RelationalExecutionContext_$0_1$__DebugContext_1__Extension_MANY__SQLQuery_1_(core_relational_relational_pureToSQLQuery_pureToSQLQuery.java:14001)
at org.finos.legend.pure.generated.core_relational_relational_contract_storeContract$43.execute(core_relational_relational_contract_storeContract.java:1064)
at org.finos.legend.pure.generated.core_relational_relational_contract_storeContract.Root_meta_relational_contract_planExecution_StoreQuery_1__RoutedValueSpecification_$0_1$__Mapping_$0_1$__Runtime_$0_1$__ExecutionContext_1__Extension_MANY__DebugContext_1__ExecutionNode_1_(core_relational_relational_contract_storeContract.java:1065)
at jdk.internal.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.metadata.JavaMethodWithParamsSharedPureFunction.execute(JavaMethodWithParamsSharedPureFunction.java:59)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.Pure.evaluate(Pure.java:358)
at org.finos.legend.pure.generated.CoreGen.evaluate(CoreGen.java:72)
at org.finos.legend.pure.generated.core_pure_router_metamodel_clustering$13.valueOf(core_pure_router_metamodel_clustering.java:246)
at org.finos.legend.pure.generated.core_pure_router_metamodel_clustering.Root_meta_pure_router_clustering_generateExecutionNodeFromCluster_ClusteredValueSpecification_1__Map_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ExecutionNode_1_(core_pure_router_metamodel_clustering.java:270)
at org.finos.legend.pure.generated.core_pure_executionPlan_executionPlan_generation.Root_meta_pure_executionPlan_plan_ClusteredValueSpecification_1__Map_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ExecutionNode_1_(core_pure_executionPlan_executionPlan_generation.java:859)
at org.finos.legend.pure.generated.core_pure_executionPlan_executionPlan_generation$31.execute(core_pure_executionPlan_executionPlan_generation.java:487)
at org.finos.legend.pure.generated.core_pure_executionPlan_executionPlan_generation.Root_meta_pure_executionPlan_executionPlan_ClusteredValueSpecification_MANY__FunctionDefinition_1__FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Map_1__Extension_MANY__DebugContext_1__ExecutionPlan_1_(core_pure_executionPlan_executionPlan_generation.java:487)
at org.finos.legend.pure.generated.core_pure_executionPlan_executionPlan_generation.Root_meta_pure_executionPlan_executionPlan_FunctionDefinition_1__FunctionDefinition_1__Mapping_1__Runtime_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ExecutionPlan_1_(core_pure_executionPlan_executionPlan_generation.java:479)
at org.finos.legend.pure.generated.core_pure_executionPlan_executionPlan_generation.Root_meta_pure_executionPlan_executionPlan_FunctionDefinition_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ExecutionPlan_1_(core_pure_executionPlan_executionPlan_generation.java:463)
at org.finos.legend.pure.generated.core_pure_executionPlan_executionPlan_generation.Root_meta_pure_executionPlan_executionPlan_FunctionDefinition_1__Extension_MANY__ExecutionPlan_1_(core_pure_executionPlan_executionPlan_generation.java:427)
at org.finos.legend.pure.generated.core_relational_relational_executionPlan_tests_executionPlanTest.Root_meta_pure_executionPlan_tests_testCrossDbPlanGenerationWithFromWithoutExternalMapping__Boolean_1_(core_relational_relational_executionPlan_tests_executionPlanTest.java:5384)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)
Check failure on line 0 in org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase
github-actions / Test Results
testTwoMappingsOneRuntimeWithoutExternalMapping (org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase) with error
artifacts/test-results/TEST-org.finos.legend.pure.code.core.relational.Test_Pure_Relational.xml
Raw output
Execution error at (resource:/core/pure/router/store/builder.pure line:219 column:150), "Cannot cast a collection of size 0 to multiplicity [1]"
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.toOneWithMessage(CompiledSupport.java:332)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.toOne(CompiledSupport.java:310)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60$1.value(core_pure_router_store_builder.java:1531)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60$1.value(core_pure_router_store_builder.java:1521)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$60.valueOf(core_pure_router_store_builder.java:1519)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1546)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:997)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1$1.value(core_pure_router_store_builder.java:982)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57$1.execute(core_pure_router_store_builder.java:981)
at org.finos.legend.pure.generated.core_pure_router_store_builder$57.valueOf(core_pure_router_store_builder.java:1053)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1055)
at org.finos.legend.pure.generated.core_pure_router_store_builder$58.valueOf(core_pure_router_store_builder.java:1498)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_build_ValueSpecification_1__List_MANY__SetImplementation_$0_1$__Mapping_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ValueSpecification_1_(core_pure_router_store_builder.java:1501)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56$3.value(core_pure_router_store_builder.java:913)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56$3.value(core_pure_router_store_builder.java:897)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_store_builder$56.execute(core_pure_router_store_builder.java:896)
at org.finos.legend.pure.generated.core_pure_router_store_builder.Root_meta_pure_router_store_routing_enrichStoreMappingRoutedValueSpecification_StoreMappingRoutedValueSpecification_1__ExecutionContext_1__Extension_MANY__DebugContext_1__StoreMappingRoutedValueSpecification_1_(core_pure_router_store_builder.java:970)
at org.finos.legend.pure.generated.core_pure_router_router_main$19.valueOf(core_pure_router_router_main.java:330)
at org.finos.legend.pure.generated.core_pure_router_router_main.Root_meta_pure_router_enrichExpressionWithStrategyBasedEnrichment_ExtendedRoutedValueSpecification_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ExtendedRoutedValueSpecification_1_(core_pure_router_router_main.java:332)
at org.finos.legend.pure.generated.core_pure_router_router_main$17.value(core_pure_router_router_main.java:284)
at org.finos.legend.pure.generated.core_pure_router_router_main$17.value(core_pure_router_router_main.java:275)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:25)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.function.defended.DefendedPureLambdaFunction1.apply(DefendedPureLambdaFunction1.java:20)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.lambda$mapToOneOverMany$abfad999$1(CompiledSupport.java:670)
at org.eclipse.collections.impl.list.mutable.FastList.each(FastList.java:603)
at org.eclipse.collections.impl.AbstractRichIterable.forEach(AbstractRichIterable.java:581)
at org.finos.legend.pure.runtime.java.compiled.generation.processors.support.CompiledSupport.mapToOneOverMany(CompiledSupport.java:668)
at org.finos.legend.pure.generated.core_pure_router_router_main.Root_meta_pure_router_routeFunction_FunctionDefinition_1__RoutingStrategy_1__ExecutionContext_1__Map_$0_1$__Extension_MANY__DebugContext_1__FunctionDefinition_1_(core_pure_router_router_main.java:274)
at org.finos.legend.pure.generated.core_pure_router_router_main.Root_meta_pure_router_routeFunction_FunctionDefinition_1__ExecutionContext_1__Extension_MANY__DebugContext_1__FunctionDefinition_1_(core_pure_router_router_main.java:261)
at org.finos.legend.pure.generated.core_pure_executionPlan_executionPlan_generation.Root_meta_pure_executionPlan_executionPlan_FunctionDefinition_1__ExecutionContext_1__Extension_MANY__DebugContext_1__ExecutionPlan_1_(core_pure_executionPlan_executionPlan_generation.java:462)
at org.finos.legend.pure.generated.core_pure_executionPlan_executionPlan_generation.Root_meta_pure_executionPlan_executionPlan_FunctionDefinition_1__Extension_MANY__ExecutionPlan_1_(core_pure_executionPlan_executionPlan_generation.java:427)
at org.finos.legend.pure.generated.core_relational_relational_executionPlan_tests_executionPlanTest.Root_meta_pure_executionPlan_tests_testTwoMappingsOneRuntimeWithoutExternalMapping__Boolean_1_(core_relational_relational_executionPlan_tests_executionPlanTest.java:5373)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.executeFn(PureTestBuilderCompiled.java:110)
at org.finos.legend.pure.runtime.java.compiled.testHelper.PureTestBuilderCompiled.lambda$buildSuite$0(PureTestBuilderCompiled.java:76)
at org.finos.legend.pure.m3.execution.test.PureTestBuilder$PureTestCase.runTest(PureTestBuilder.java:112)
at junit.framework.TestCase.runBare(TestCase.java:142)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:130)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at junit.framework.TestSuite.runTest(TestSuite.java:241)
at junit.framework.TestSuite.run(TestSuite.java:236)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:90)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159)
at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345)
at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418)