[CAY-2811] Incorrect SQL building using ColumnQuery with ASTScalar

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1, 4.2
• Fix Version/s: 5.0-M1
• Component/s: Core Library
• Assignee: Unassigned
• Reporter: Ivan Nikitka
• Created: 03/Aug/23 09:28
• Updated: 15/Jan/24 12:50
• Resolved: 15/Jan/24 12:50

Description

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:
java.sql.SQLSyntaxErrorException: unexpected token: FROM in statement [SELECT RTRIM(t0.ARTIST_NAME),  FROM ARTIST t0]