Skip to content
Build 6.1

Use temp session tables (but we are reusing sessions) #1272

Sign in to view logs

Use temp session tables (but we are reusing sessions)

Use temp session tables (but we are reusing sessions) #1272

GitHub Actions / Lucee Test Results failed Jul 16, 2024 in 0s

14 errors, 11 fail, 220 skipped, 3 528 pass in 4m 47s

    1 files  ±0  1 440 suites  ±0   4m 47s ⏱️ + 1m 20s
3 773 tests +1  3 528 ✅  - 24  220 💤 ±0  11 ❌ +11  14 🔥 +14 
3 902 runs  ±0  3 634 ✅  - 27  241 💤 ±0  11 ❌ +11  16 🔥 +16 

Results for commit b1aebaf. ± Comparison against earlier commit fa195b2.

Annotations

Check warning on line 0 in test.tickets.LDEV2470

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ joins on columns with type integer does work (test.tickets.LDEV2470) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [1] but received []

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev2470_cfc$cf.udfCall(/test/tickets/LDEV2470.cfc:13)}, codePrintPlain={11: 						)
12: 					}
13: 					expect(int_query.id).tobe(1);
14: 				}
15: 			});
}, column={0}, line={13}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV2470.cfc}, id={??}, type={cfml}, codePrintHTML={11: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)<br>
12: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
<b>13: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(int_query.id).tobe(1);</b><br>
14: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});<br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check failure on line 0 in test.tickets.LDEV2470

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ joins on columns with type numeric doesn't work (test.tickets.LDEV2470) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at tickets.ldev2470_cfc$cf.udfCall(/test/tickets/LDEV2470.cfc:25)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 101 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE A (ID NUMERIC)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 101 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 105 more

Check warning on line 0 in test.tickets.LDEV3311

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

Qoq select join from large tables (test.tickets.LDEV3311) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [5] but received [0]

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev3311_cfc$cf.udfCall(/test/tickets/LDEV3311.cfc:118)}, codePrintPlain={116: 					options = { dbtype: 'query' }
117: 				);
118: 				expect( q1check.recordcount ).toBe( q1.recordcount );
119: 				//debug(q2);
120: 				var q2check = QueryExecute(
}, column={0}, line={118}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV3311.cfc}, id={??}, type={cfml}, codePrintHTML={116: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;options&nbsp;=&nbsp;{&nbsp;dbtype:&nbsp;'query'&nbsp;}<br>
117: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
<b>118: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;q1check.recordcount&nbsp;).toBe(&nbsp;q1.recordcount&nbsp;);</b><br>
119: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//debug(q2);<br>
120: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;q2check&nbsp;=&nbsp;QueryExecute(<br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check warning on line 0 in test.tickets.LDEV3514

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

Join QoQ containing a serialized CFC Object (test.tickets.LDEV3514) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [test] but received []

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev3514_cfc$cf.udfCall(/test/tickets/LDEV3514.cfc:71)}, codePrintPlain={69: 					res = e.message
70: 				}
71: 				expect(res).toBe("test");
72: 			});
73: 
}, column={0}, line={71}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV3514.cfc}, id={??}, type={cfml}, codePrintHTML={69: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;res&nbsp;=&nbsp;e.message<br>
70: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
<b>71: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(res).toBe(&quot;test&quot;);</b><br>
72: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});<br>
73: <br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check warning on line 0 in test.tickets.LDEV4181

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

Checking QoQ with numeric column, trailing 000s (test.tickets.LDEV4181) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [1,10,15] but received []

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev4181_cfc$cf.udfCall(/test/tickets/LDEV4181.cfc:49)}, codePrintPlain={47: 					{ dbType='query' }
48: 				);
49: 				expect(valueList(queryResult.id)).tobe("1,10,15");
50: 			});
51: 
}, column={0}, line={49}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV4181.cfc}, id={??}, type={cfml}, codePrintHTML={47: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;dbType='query'&nbsp;}<br>
48: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
<b>49: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(valueList(queryResult.id)).tobe(&quot;1,10,15&quot;);</b><br>
50: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});<br>
51: <br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check warning on line 0 in test.tickets.LDEV4592

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test qoq different column types, duplicate columns (test.tickets.LDEV4592) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [4] but received [0]

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev4592_cfc$cf.udfCall(/test/tickets/LDEV4592.cfc:24)}, codePrintPlain={22: 				}
23: 
24: 				expect ( q.recordcount ).toBe( 4 );
25: 			});
26: 
}, column={0}, line={24}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV4592.cfc}, id={??}, type={cfml}, codePrintHTML={22: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
23: <br>
<b>24: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect&nbsp;(&nbsp;q.recordcount&nbsp;).toBe(&nbsp;4&nbsp;);</b><br>
25: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});<br>
26: <br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check failure on line 0 in test.tickets.LDEV4592

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test qoq different column types, aliased duplicate columns (test.tickets.LDEV4592) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at tickets.ldev4592_cfc$cf.udfCall(/test/tickets/LDEV4592.cfc:41)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 101 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE NEWS (ID BIT,TITLE VARCHAR_IGNORECASE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 101 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 105 more

Check failure on line 0 in test.tickets.LDEV4592

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test qoq same column types, aliased duplicate column names (test.tickets.LDEV4592) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at tickets.ldev4592_cfc$cf.udfCall(/test/tickets/LDEV4592.cfc:61)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 101 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE NEWS (ID BIT,TITLE VARCHAR_IGNORECASE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 101 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 105 more

Check failure on line 0 in test.tickets.LDEV4592

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test qoq different column types, duplicate column names (test.tickets.LDEV4592) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at tickets.ldev4592_cfc$cf.udfCall(/test/tickets/LDEV4592.cfc:80)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 101 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE NEWS (ID INTEGER,TITLE VARCHAR_IGNORECASE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 101 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 105 more

Check failure on line 0 in test.tickets.LDEV4592

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test qoq different column types, aliased duplicate column names (test.tickets.LDEV4592) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at tickets.ldev4592_cfc$cf.udfCall(/test/tickets/LDEV4592.cfc:99)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 101 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE NEWS (ID INTEGER,TITLE VARCHAR_IGNORECASE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 101 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 105 more

Check failure on line 0 in test.tickets.LDEV4593

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test hsqldb qoq with $ in column names (test.tickets.LDEV4593) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at tickets.ldev4593_cfc$cf.udfCall(/test/tickets/LDEV4593.cfc:72)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 101 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE Q (ID$LUCEE VARCHAR_IGNORECASE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 101 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 105 more

Check warning on line 0 in test.tickets.LDEV4593

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test hsqldb qoq with $ in column name and $ leading table name (test.tickets.LDEV4593) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [4uYOfMFUSBCsPmMDf7td1w] but received []

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev4593_cfc$cf.udfCall(/test/tickets/LDEV4593.cfc:90)}, codePrintPlain={88: 				}
89: 
90: 				expect( r[ "id$lucee" ] ).toBe( randomValue );
91: 				expect( r.recordcount ).toBe( 1 );
92: 
}, column={0}, line={90}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV4593.cfc}, id={??}, type={cfml}, codePrintHTML={88: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
89: <br>
<b>90: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;r[&nbsp;&quot;id$lucee&quot;&nbsp;]&nbsp;).toBe(&nbsp;randomValue&nbsp;);</b><br>
91: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;r.recordcount&nbsp;).toBe(&nbsp;1&nbsp;);<br>
92: <br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check warning on line 0 in test.tickets.LDEV4593

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test hsqldb qoq with $ in column name and _ leading table name (test.tickets.LDEV4593) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [XL3ioRP3QgCuyV2meNorlQ] but received []

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev4593_cfc$cf.udfCall(/test/tickets/LDEV4593.cfc:105)}, codePrintPlain={103: 				}
104: 
105: 				expect( r[ "id$lucee" ] ).toBe( randomValue );
106: 				expect( r.recordcount ).toBe( 1 );
107: 
}, column={0}, line={105}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV4593.cfc}, id={??}, type={cfml}, codePrintHTML={103: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
104: <br>
<b>105: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;r[&nbsp;&quot;id$lucee&quot;&nbsp;]&nbsp;).toBe(&nbsp;randomValue&nbsp;);</b><br>
106: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;r.recordcount&nbsp;).toBe(&nbsp;1&nbsp;);<br>
107: <br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check warning on line 0 in test.tickets.LDEV4593

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

test hsqldb qoq with $ in column name and $ in table name (test.tickets.LDEV4593) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [Z-vr303wTe2ry8TIR4PmUQ] but received []

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev4593_cfc$cf.udfCall(/test/tickets/LDEV4593.cfc:120)}, codePrintPlain={118: 				}
119: 
120: 				expect( r[ "id$lucee" ] ).toBe( randomValue );
121: 				expect( r.recordcount ).toBe( 1 );
122: 
}, column={0}, line={120}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV4593.cfc}, id={??}, type={cfml}, codePrintHTML={118: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
119: <br>
<b>120: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;r[&nbsp;&quot;id$lucee&quot;&nbsp;]&nbsp;).toBe(&nbsp;randomValue&nbsp;);</b><br>
121: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;r.recordcount&nbsp;).toBe(&nbsp;1&nbsp;);<br>
122: <br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check failure on line 0 in test.tickets.LDEV4613

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

All 3 runs with error: LDEV-4613 incompatible data type in operation simple join, mixed case sql (test.tickets.LDEV4613) 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at tickets.ldev4613_cfc$cf.udfCall(/test/tickets/LDEV4613.cfc:66)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 102 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE QRYG4APPLICENSES (G4APP_ID INTEGER,G4APP_CODE VARCHAR_IGNORECASE,IS_HR BIT,IS_EMP BIT,LICENSE_MIN_SUMMED DOUBLE,LICENSE_MAX_SUMMED DOUBLE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 102 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 106 more

Check failure on line 0 in test.tickets.LDEV4613

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

LDEV-4613 incompatible data type in operation simple join, orig example (test.tickets.LDEV4613) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at tickets.ldev4613_cfc$cf.udfCall(/test/tickets/LDEV4613.cfc:198)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 102 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE QRYG4APPLICENSES (G4APP_ID INTEGER,G4APP_CODE VARCHAR_IGNORECASE,IS_HR BIT,IS_EMP BIT,LICENSE_MIN_SUMMED DOUBLE,LICENSE_MAX_SUMMED DOUBLE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 102 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 106 more

Check failure on line 0 in test.tickets.LDEV4615

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ: data exception: string data, right truncation ; size limit: 1 (test.tickets.LDEV4615) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at tickets.ldev4615_cfc$cf.udfCall(/test/tickets/LDEV4615.cfc:19)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 102 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE Q1 (ID INTEGER,TITLE VARCHAR_IGNORECASE,INITS CHAR)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 102 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 106 more

Check failure on line 0 in test.tickets.LDEV4691

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ check decimal types scale are preserved (test.tickets.LDEV4691) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at tickets.ldev4691_cfc$cf.udfCall(/test/tickets/LDEV4691.cfc:19)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 102 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE Q1 (ID INTEGER,DEC DECIMAL)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 102 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 106 more

Check failure on line 0 in test.tickets.LDEV4695

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ with same types as sub select (test.tickets.LDEV4695) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at tickets.ldev4695_cfc$cf.udfCall(/test/tickets/LDEV4695.cfc:41)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 101 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE Q (NAVID VARCHAR_IGNORECASE,TYPE DECIMAL,URL VARCHAR_IGNORECASE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 101 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 105 more

Check warning on line 0 in test.tickets.LDEV4829

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

Checking qoq with LIKE operator on hsqldb with * (test.tickets.LDEV4829) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [1] but received [0]

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev4829_cfc$cf.udfCall(/test/tickets/LDEV4829.cfc:60)}, codePrintPlain={58:                 var myresult = queryExecute( sql, params, queryOptions );
59:                 var res = queryToStruct( myresult, "id" );
60:                 expect( myresult.recordCount).toBe( 1 );
61:                 expect( res[ 1 ].number ).toBe( "3*562" );
62:             });
}, column={0}, line={60}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV4829.cfc}, id={??}, type={cfml}, codePrintHTML={58: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;myresult&nbsp;=&nbsp;queryExecute(&nbsp;sql,&nbsp;params,&nbsp;queryOptions&nbsp;);<br>
59: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;res&nbsp;=&nbsp;queryToStruct(&nbsp;myresult,&nbsp;&quot;id&quot;&nbsp;);<br>
<b>60: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;myresult.recordCount).toBe(&nbsp;1&nbsp;);</b><br>
61: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;res[&nbsp;1&nbsp;].number&nbsp;).toBe(&nbsp;&quot;3*562&quot;&nbsp;);<br>
62: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;});<br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check warning on line 0 in test.tickets.LDEV4829

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

Checking qoq with LIKE operator on hsqldb with | (test.tickets.LDEV4829) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [1] but received [0]

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev4829_cfc$cf.udfCall(/test/tickets/LDEV4829.cfc:92)}, codePrintPlain={90:                 var res = queryToStruct( myresult, "id" );
91: 
92:                 expect( myresult.recordCount ).toBe( 1 );
93:                 expect( res[1].number ).toBe( "3#variables.operator#562" );
94: 
}, column={0}, line={92}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV4829.cfc}, id={??}, type={cfml}, codePrintHTML={90: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;res&nbsp;=&nbsp;queryToStruct(&nbsp;myresult,&nbsp;&quot;id&quot;&nbsp;);<br>
91: <br>
<b>92: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;myresult.recordCount&nbsp;).toBe(&nbsp;1&nbsp;);</b><br>
93: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;res[1].number&nbsp;).toBe(&nbsp;&quot;3#variables.operator#562&quot;&nbsp;);<br>
94: <br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check warning on line 0 in test.tickets.LDEV5023

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ select * from table same source table name HSQLDB (test.tickets.LDEV5023) failed 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
Expected [0] but received [5]

					[{Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:16)}, codePrintPlain={14: 	function fail( message="" ){
15: 		arguments.message = ( len( arguments.message ) ? arguments.message : "A test failure occurred" );
16: 		throw(type="TestBox.AssertionFailed", message=arguments.message);
17: 	}
18: 
}, column={0}, line={16}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={14: &nbsp;&nbsp;&nbsp;function&nbsp;fail(&nbsp;message=&quot;&quot;&nbsp;){<br>
15: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.message&nbsp;=&nbsp;(&nbsp;len(&nbsp;arguments.message&nbsp;)&nbsp;?&nbsp;arguments.message&nbsp;:&nbsp;&quot;A&nbsp;test&nbsp;failure&nbsp;occurred&quot;&nbsp;);<br>
<b>16: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throw(type=&quot;TestBox.AssertionFailed&quot;,&nbsp;message=arguments.message);</b><br>
17: &nbsp;&nbsp;&nbsp;}<br>
18: <br>
}}, {Raw_Trace={system.assertion_cfc$cf.udfCall1(/testbox/system/Assertion.cfc:67)}, codePrintPlain={65: 			"Expected [#getStringName( arguments.expected )#] but received [#getStringName( arguments.actual )#]" );
66: 		// if we reach here, nothing is equal man!
67: 		fail( arguments.message );
68: 	}
69: 
}, column={0}, line={67}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Assertion.cfc}, id={??}, type={cfml}, codePrintHTML={65: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Expected&nbsp;[#getStringName(&nbsp;arguments.expected&nbsp;)#]&nbsp;but&nbsp;received&nbsp;[#getStringName(&nbsp;arguments.actual&nbsp;)#]&quot;&nbsp;);<br>
66: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;if&nbsp;we&nbsp;reach&nbsp;here,&nbsp;nothing&nbsp;is&nbsp;equal&nbsp;man!<br>
<b>67: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fail(&nbsp;arguments.message&nbsp;);</b><br>
68: &nbsp;&nbsp;&nbsp;}<br>
69: <br>
}}, {Raw_Trace={system.expectation_cfc$cf.udfCall1(/testbox/system/Expectation.cfc:150)}, codePrintPlain={148: 			variables.assert.isNotEqual( argumentCollection=arguments );
149: 		} else {
150: 			variables.assert.isEqual( argumentCollection=arguments );
151: 		}
152: 		return this;
}, column={0}, line={150}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/Expectation.cfc}, id={??}, type={cfml}, codePrintHTML={148: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isNotEqual(&nbsp;argumentCollection=arguments&nbsp;);<br>
149: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
<b>150: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.assert.isEqual(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
151: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
152: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this;<br>
}}, {Raw_Trace={tickets.ldev5023_cfc$cf.udfCall(/test/tickets/LDEV5023.cfc:23)}, codePrintPlain={21: 					options = { dbtype: 'query' }
22: 				);
23: 				expect( q_stash.recordcount ).toBe( q_hsqlb.recordcount );
24: 				expect( q_native.recordcount ).toBe( q_hsqlb.recordcount );
25: 				expect( q_stash.recordcount ).toBe( q_native.recordcount );
}, column={0}, line={23}, template={/home/runner/work/Lucee/Lucee/test/tickets/LDEV5023.cfc}, id={??}, type={cfml}, codePrintHTML={21: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;options&nbsp;=&nbsp;{&nbsp;dbtype:&nbsp;'query'&nbsp;}<br>
22: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
<b>23: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;q_stash.recordcount&nbsp;).toBe(&nbsp;q_hsqlb.recordcount&nbsp;);</b><br>
24: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;q_native.recordcount&nbsp;).toBe(&nbsp;q_hsqlb.recordcount&nbsp;);<br>
25: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;expect(&nbsp;q_stash.recordcount&nbsp;).toBe(&nbsp;q_native.recordcount&nbsp;);<br>
}}, {Raw_Trace={system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)}, codePrintPlain={565: 					} else {
566: 						// Execute the Spec body
567: 						arguments.spec.body( data=arguments.spec.data );
568: 					}
569: 				} catch( any e ){
}, column={0}, line={567}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/BaseSpec.cfc}, id={??}, type={cfml}, codePrintHTML={565: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{<br>
566: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;the&nbsp;Spec&nbsp;body<br>
<b>567: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;arguments.spec.body(&nbsp;data=arguments.spec.data&nbsp;);</b><br>
568: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
569: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch(&nbsp;any&nbsp;e&nbsp;){<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)}, codePrintPlain={202: 						suiteStats=thread.suiteStats,
203: 						runner=this 
204: 					);
205: 
206: 					// verify call backs
}, column={0}, line={204}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={202: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;suiteStats=thread.suiteStats,<br>
203: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;runner=this&nbsp;<br>
<b>204: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);</b><br>
205: <br>
206: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;verify&nbsp;call&nbsp;backs<br>
}}, {Raw_Trace={system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)}, codePrintPlain={73: 						testResults=arguments.testResults,
74: 						bundleStats=bundleStats,
75: 						callbacks=arguments.callbacks
76: 					);
77: 
}, column={0}, line={75}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/runners/BDDRunner.cfc}, id={??}, type={cfml}, codePrintHTML={73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults=arguments.testResults,<br>
74: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bundleStats=bundleStats,<br>
<b>75: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;callbacks=arguments.callbacks</b><br>
76: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);<br>
77: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)}, codePrintPlain={362: 			// Run via BDD Style
363: 			new testbox.system.runners.BDDRunner( options=variables.options, testbox=this )
364: 				.run( target, arguments.testResults, arguments.callbacks );
365: 		}
366: 		else{
}, column={0}, line={364}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={362: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Run&nbsp;via&nbsp;BDD&nbsp;Style<br>
363: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;new&nbsp;testbox.system.runners.BDDRunner(&nbsp;options=variables.options,&nbsp;testbox=this&nbsp;)<br>
<b>364: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.run(&nbsp;target,&nbsp;arguments.testResults,&nbsp;arguments.callbacks&nbsp;);</b><br>
365: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
366: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else{<br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)}, codePrintPlain={168: 		for( var thisBundlePath in variables.bundles ){
169: 			// Execute Bundle
170: 			testBundle( bundlePath=thisBundlePath, testResults=results, callbacks=arguments.callbacks );
171: 		}
172: 
}, column={0}, line={170}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={168: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(&nbsp;var&nbsp;thisBundlePath&nbsp;in&nbsp;variables.bundles&nbsp;){<br>
169: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Execute&nbsp;Bundle<br>
<b>170: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testBundle(&nbsp;bundlePath=thisBundlePath,&nbsp;testResults=results,&nbsp;callbacks=arguments.callbacks&nbsp;);</b><br>
171: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<br>
172: <br>
}}, {Raw_Trace={system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)}, codePrintPlain={96: 		if( !isNull( arguments.reporter ) ){ variables.reporter = arguments.reporter; }
97: 		// run it and get results
98: 		var results = runRaw( argumentCollection=arguments );
99: 		// store latest results
100:         variables.result = results;
}, column={0}, line={98}, template={/home/runner/work/Lucee/Lucee/temp/testbox/testbox/system/TestBox.cfc}, id={??}, type={cfml}, codePrintHTML={96: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(&nbsp;!isNull(&nbsp;arguments.reporter&nbsp;)&nbsp;){&nbsp;variables.reporter&nbsp;=&nbsp;arguments.reporter;&nbsp;}<br>
97: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;run&nbsp;it&nbsp;and&nbsp;get&nbsp;results<br>
<b>98: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;results&nbsp;=&nbsp;runRaw(&nbsp;argumentCollection=arguments&nbsp;);</b><br>
99: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;store&nbsp;latest&nbsp;results<br>
100: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;variables.result&nbsp;=&nbsp;results;<br>
}}, {Raw_Trace={_testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)}, codePrintPlain={281: 	,onSpecEnd 		= function( bundle, testResults, suite, spec ){}*/
282: } // callbacks
283: 			); // report = tb.run
284: 
285: 	 		// get the result
}, column={0}, line={283}, template={/home/runner/work/Lucee/Lucee/test/_testRunner.cfc}, id={??}, type={cfml}, codePrintHTML={281: &nbsp;&nbsp;&nbsp;,onSpecEnd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;function(&nbsp;bundle,&nbsp;testResults,&nbsp;suite,&nbsp;spec&nbsp;){}*/<br>
282: }&nbsp;//&nbsp;callbacks<br>
<b>283: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;);&nbsp;//&nbsp;report&nbsp;=&nbsp;tb.run</b><br>
284: <br>
285: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;get&nbsp;the&nbsp;result<br>
}}, {Raw_Trace={run_tests_cfm180$cf.call(/test/run-tests.cfm:348)}, codePrintPlain={346: 	systemOutput(NL & "-------------- Start Tests -----------", true);
347: 	silent {
348: 		testResults = new test._testRunner().runTests();
349: 	}
350: 
}, column={0}, line={348}, template={/home/runner/work/Lucee/Lucee/test/run-tests.cfm}, id={??}, type={cfml}, codePrintHTML={346: &nbsp;&nbsp;&nbsp;systemOutput(NL&nbsp;&amp;&nbsp;&quot;--------------&nbsp;Start&nbsp;Tests&nbsp;-----------&quot;,&nbsp;true);<br>
347: &nbsp;&nbsp;&nbsp;silent&nbsp;{<br>
<b>348: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;testResults&nbsp;=&nbsp;new&nbsp;test._testRunner().runTests();</b><br>
349: &nbsp;&nbsp;&nbsp;}<br>
350: <br>
}}]

Check failure on line 0 in test.tickets.LDEV5023

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ select * from table same source table name (arguments) HSQLDB (test.tickets.LDEV5023) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at tickets.ldev5023_cfc$cf.udfCall(/test/tickets/LDEV5023.cfc:43)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 102 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE Q_NATIVE (NAME VARCHAR_IGNORECASE,ID VARCHAR_IGNORECASE)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 102 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 106 more

Check failure on line 0 in test.tickets.LDEV5023

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ select * from table same source table name (all cols) HSQLDB (test.tickets.LDEV5023) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at tickets.ldev5023_cfc$cf.udfCall(/test/tickets/LDEV5023.cfc:63)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.EnvUDF.callWithNamedValues(EnvUDF.java:83)
	at lucee.runtime.type.util.StructSupport.callWithNamedValues(StructSupport.java:286)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.basespec_cfc$cf.udfCall3(/testbox/system/BaseSpec.cfc:567)
	at system.basespec_cfc$cf.udfCall(/testbox/system/BaseSpec.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:204)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.runners.bddrunner_cfc$cf.udfCall(/testbox/system/runners/BDDRunner.cfc:75)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:364)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:170)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:799)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at system.testbox_cfc$cf.udfCall1(/testbox/system/TestBox.cfc:98)
	at system.testbox_cfc$cf.udfCall(/testbox/system/TestBox.cfc)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:716)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2048)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:875)
	at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2028)
	at _testrunner_cfc$cf.udfCall(/test/_testRunner.cfc:283)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:715)
	at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
	at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
	at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
	at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
	at run_tests_cfm180$cf.call(/test/run-tests.cfm:348)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
	at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
	at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
	at zli3shic70q.call(Unknown Source)
	at lucee.runtime.compiler.Renderer.tag(Renderer.java:106)
	at lucee.runtime.compiler.Renderer.script(Renderer.java:96)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:66)
	at lucee.runtime.jsr223.ScriptEngineImpl.eval(ScriptEngineImpl.java:221)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.evaluateScript(JavaxScriptRunner.java:154)
	at org.apache.tools.ant.util.optional.JavaxScriptRunner.executeScript(JavaxScriptRunner.java:86)
	at org.apache.tools.ant.taskdefs.optional.Script.execute(Script.java:54)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:299)
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:99)
	at org.apache.tools.ant.Task.perform(Task.java:350)
	at org.apache.tools.ant.Target.execute(Target.java:449)
	at org.apache.tools.ant.Target.performTasks(Target.java:470)
	at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1401)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1374)
	at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1264)
	at org.apache.tools.ant.Main.runBuild(Main.java:818)
	at org.apache.tools.ant.Main.startAnt(Main.java:223)
	at org.apache.tools.ant.launch.Launcher.run(Launcher.java:284)
	at org.apache.tools.ant.launch.Launcher.main(Launcher.java:101)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 102 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE Q_NATIVE (ID VARCHAR_IGNORECASE,VERSION VARCHAR_IGNORECASE,NAME VARCHAR_IGNORECASE,SYMBOLICNAME VARCHAR_IGNORECASE,TYPE VARCHAR_IGNORECASE,DESCRIPTION VARCHAR_IGNORECASE,IMAGE VARCHAR_IGNORECASE,RELEASETYPE VARCHAR_IGNORECASE,TRIAL BOOLEAN,CATEGORIES OBJECT,STARTBUNDLES BOOLEAN,BUNDLES OBJECT,FLDS OBJECT,TLDS OBJECT,TAGS OBJECT,FUNCTIONS OBJECT,CONTEXTS OBJECT,WEBCONTEXTS OBJECT,CONFIG OBJECT,APPLICATIONS OBJECT,COMPONENTS OBJECT,PLUGINS OBJECT,EVENTGATEWAYS OBJECT,ARCHIVES OBJECT)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 102 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 106 more

Check failure on line 0 in test.tickets.LDEV5023

See this annotation in the file changed.

@github-actions github-actions / Lucee Test Results

QoQ select * from table same source table name (all cols) HSQLDB, 5000 threads (test.tickets.LDEV5023) with error 

test/reports/junit-test-results-6.1.0.241-RC.xml [took 0s]
Raw output 
QoQ HSQLDB: error executing sql statement on query.

					lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:647)
	at lucee.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:544)
	at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:532)
	at lucee.runtime.tag.Query.executeQoQ(Query.java:1103)
	at lucee.runtime.tag.Query._doEndTag(Query.java:675)
	at lucee.runtime.tag.Query.doEndTag(Query.java:559)
	at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
	at tickets.ldev5023_cfc$cf.udfCall(/test/tickets/LDEV5023.cfc:86)
	at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
	at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
	at lucee.runtime.type.UDFImpl.call(UDFImpl.java:219)
	at lucee.runtime.type.EnvUDF.call(EnvUDF.java:137)
	at lucee.runtime.concurrency.UDFCaller2.call(UDFCaller2.java:89)
	at lucee.runtime.concurrency.UDFCaller2.call(UDFCaller2.java:40)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: lucee.runtime.exp.IllegalQoQException: QoQ HSQLDB: error executing sql statement on query.
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:640)
	... 17 more
Caused by: java.sql.SQLSyntaxErrorException: object name already exists in statement [DECLARE LOCAL TEMPORARY TABLE Q (ID VARCHAR_IGNORECASE,VERSION VARCHAR_IGNORECASE,NAME VARCHAR_IGNORECASE,SYMBOLICNAME VARCHAR_IGNORECASE,TYPE VARCHAR_IGNORECASE,DESCRIPTION VARCHAR_IGNORECASE,IMAGE VARCHAR_IGNORECASE,RELEASETYPE VARCHAR_IGNORECASE,TRIAL BOOLEAN,CATEGORIES OBJECT,STARTBUNDLES BOOLEAN,BUNDLES OBJECT,FLDS OBJECT,TLDS OBJECT,TAGS OBJECT,FUNCTIONS OBJECT,CONTEXTS OBJECT,WEBCONTEXTS OBJECT,CONFIG OBJECT,APPLICATIONS OBJECT,COMPONENTS OBJECT,PLUGINS OBJECT,EVENTGATEWAYS OBJECT,ARCHIVES OBJECT)]
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
	at lucee.runtime.db.HSQLDBHandler.createTable(HSQLDBHandler.java:140)
	at lucee.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:595)
	... 17 more
Caused by: org.hsqldb.HsqlException: object name already exists
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.SessionContext.addSessionTable(Unknown Source)
	at org.hsqldb.StatementSession.getResult(Unknown Source)
	at org.hsqldb.StatementSession.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.executeDirectStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 21 more
View more details on GitHub Actions