BoxLang: Our new JVM Dynamic Language made by Ortus! Check it out: https://www.boxlang.io

Insert null queryparam throws 'Unknown QueryColumnType: null'

Description

This query attempts to insert a null using cfqueryparam:

<cfquery> INSERT INTO developers (id, name, role ) VALUES (<cfqueryparam value="1" />, <cfqueryparam null="true" />, <cfqueryparam value="CEO" />) </cfquery>

This throws the following (abbreviated) error:

java.lang.IllegalArgumentException: Unknown QueryColumnType: null at ortus.boxlang.runtime.types.QueryColumnType.fromString(QueryColumnType.java:75) at ortus.boxlang.runtime.jdbc.QueryParameter.<init>(QueryParameter.java:45) at ortus.boxlang.runtime.jdbc.QueryParameter.fromAny(QueryParameter.java:53) at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197) at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708) at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921) at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682) at ortus.boxlang.runtime.jdbc.PendingQuery.buildParameterList(PendingQuery.java:224) at ortus.boxlang.runtime.jdbc.PendingQuery.processBindings(PendingQuery.java:205) at ortus.boxlang.runtime.jdbc.PendingQuery.<init>(PendingQuery.java:154) at ortus.boxlang.runtime.components.jdbc.Query._invoke(Query.java:139) at ortus.boxlang.runtime.components.Component.invoke(Component.java:121) at ortus.boxlang.runtime.components.ComponentDescriptor.invoke(ComponentDescriptor.java:197) at ortus.boxlang.runtime.context.BaseBoxContext.invokeComponent(BaseBoxContext.java:445) at boxgenerated.scripts.Script_da235ca18e0c4266ccf419d67ef17334._invoke(Script_da235ca18e0c4266ccf419d67ef17334.java:79)

Activity

Show:

Michael Born @ Ortus July 3, 2024 at 12:13 PM

Resolved and added tests in latest BoxLang beta.

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Fix versions

Priority

Sentry

Created July 3, 2024 at 11:24 AM
Updated July 3, 2024 at 12:13 PM
Resolved July 3, 2024 at 12:13 PM

Flag notifications