[
https://issues.apache.org/jira/browse/CAY-2811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Timofeev updated CAY-2811:
---------------------------------
Summary: Incorrect SQL building using ColumnQuery with ASTScalar (was:
Incorrect SQL building using ColumnQuerry with ASTScalar)
> Incorrect SQL building using ColumnQuery with ASTScalar
> -------------------------------------------------------
>
> Key: CAY-2811
> URL: https://issues.apache.org/jira/browse/CAY-2811
> Project: Cayenne
> Issue Type: Bug
> Components: Core Library
> Affects Versions: 4.1, 4.2
> Reporter: Ivan Nikitka
> Priority: Major
> Fix For: 5.0-M1
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> *The resulted SQL of*
> Property<Integer> property =
> Property.create(ExpressionFactory.wrapScalarValue(123), Integer.class);
> ObjectSelect.columnQuery(Artist.class, Artist.ARTIST_NAME,
> property).select(context);
> *is:*
> {color:#FF0000}java.sql.SQLSyntaxErrorException: unexpected token: FROM in
> statement [SELECT RTRIM(t0.ARTIST_NAME), FROM ARTIST t0]{color}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
