You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Nikita Timofeev (Jira)" <ji...@apache.org> on 2024/01/15 12:50:00 UTC
[jira] [Updated] (CAY-2811) Incorrect SQL building using ColumnQuery with ASTScalar
[ 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)