[#NUCRDBMS-324] JDOQL : navigational query through two levels of collection using declareVariables causes invalid SQL - DataNucleus JIRA

DataNucleus RDBMS

JDOQL : navigational query through two levels of collection using declareVariables causes invalid SQL

Created: 28/Aug/06 09:49 PM Updated: 17/Mar/10 08:52 PM Resolved: 04/Mar/10 06:04 PM

Component/s:

Queries

Affects Version/s:

None

Fix Version/s:

2.0.2

File Attachments:	1. jpox.zip (2 kB)
Environment:	jpox 1.1.1 - Windows platform - mysql5 - Java5

Forum Thread URL:	http://www.jpox.org/servlet/forum/viewthread?thread=3701
Datastore:	MySQL
Severity:	Development

Description

« Hide

problem reported in forum :
http://www.jpox.org/servlet/forum/viewthread?thread=3701

Summary :

Query aQuery = pm.newQuery(virtualdoc.class, "fieldsList.contains(aField) && aField.name =='fieldName' && aField.values.contains(aValue) && aValue.length()>0")
aQuery.declareImports("import virtual.*");
aQuery.declareVariables("virtual.virtualField aField; java.lang.String aValue");
aQuery.execute();

Error : java.sql.SQLException: Unknown column 'UNBOUND_AFIELD_VALUES_AVALUE.STRING_ELE' in 'where clause'

bug report requested by Erik.

Thanks.

Sort Order:

André made changes - 28/Aug/06 09:49 PM

Field	Original Value	New Value
Attachment		jpox.zip [ 10305 ]

Andy Jefferson made changes - 06/Sep/06 10:06 AM

Fix Version/s

1.2.0 [ 10021 ]

Andy Jefferson made changes - 03/Oct/06 06:19 PM

Assignee

JPOX Administrator [ admin ]

Andy Jefferson made changes - 16/Jul/07 06:47 PM

Summary

navigational query through two levels of collection using declareVariables

JDOQL : navigational query through two levels of collection using declareVariables causes invalid SQL

Andy Jefferson made changes - 09/Dec/07 11:45 AM

Project	Core [ 10000 ]	RDBMS [ 10111 ]
Key	CORE-2951	RDBMS-59
Component/s		Queries [ 10111 ]
Component/s	Queries [ 10030 ]
Fix Version/s	1.2.0 [ 10021 ]
Affects Version/s	1.1.1 [ 10130 ]

Andy Jefferson made changes - 04/Mar/10 06:01 PM

Project	JPOX RDBMS (ARCHIVED) [ 10111 ]	DataNucleus RDBMS [ 10144 ]
Key	RDBMS-59	~~NUCRDBMS-324~~
Component/s		Queries [ 10142 ]
Component/s	Queries [ 10111 ]

Andy Jefferson made changes - 04/Mar/10 06:04 PM

Status	Open [ 1 ]	Resolved [ 5 ]
Fix Version/s		2.0.2 [ 10870 ]
Resolution		Fixed [ 1 ]

Andy Jefferson made changes - 17/Mar/10 08:52 PM

Status

Resolved [ 5 ]

Closed [ 6 ]