ISSUE DESCRIPTION [SQL] "expand" projection is always named "value" ignoring "AS"…
- User
ISSUE DESCRIPTION
[SQL] "expand" projection is always named "value" ignoring "AS"
ArcadeDB Server v26.5.1 (build b6d08fee549dd5930303b362223869901aab0fac/1778533954349/main)Running on Linux 6.17.0-29-generic - OpenJDK 64-Bit Server VM 25.0.3-eaUsing
expandin a projection, the result-set contains an property namedvalueinspite an alias of the formAS x:SELECT expand([1,2,3,4]) AS testresults in:
{"result":[{"value":1},{"value":2},{"value":3},{"value":4}]}Interface
No new interfaces are introduced.
ADDITIONAL ADVICE
Since you are given a git repository, you can use git commands to simplify your work. For example, if you made a mistake and want to revert your changes, you can use
git checkout <file>to restore the file to its original state. You can also reset all changes in the repository usinggit reset --hardcommand. Additionally, you can usegit stashandgit stash popto temporarily save your changes and restore them later. Finally, you can see the changes that you've made (which will be submitted when you callsubmit) usinggit statusorgit diffcommands. However you don't need to usegit addorgit commitbefore submitting your changes. In fact,submitonly submits currently unstaged changes because it usesgit diffto get the changes that need to be submitted.CHECKLIST
Before submitting your solution, please go over the following checklist and make sure you've done everything:
- If an error was reported in the issue description, I have successfully reproduced it.
- If an error was reported in the issue description, I have confirmed that my fix resolves the error.
- I have thought about edge cases and made sure my fix handles them as well.
- I have run existing tests in the repository that might have been affected by the change I made and confirmed that they pass. I want you to list every bullet from this checklist and write your reasoning for why you think you did it or didn't need to.
Repository has been uploaded and your shell is currently at the repository root. Time to solve the issue!
(Current directory: /arcadedb, current file: none) bash-$
- Assistant
I'll start by exploring the repository structure and locating the SQL
expandprojection implementation so we can fix the ignoredASalias. - Assistant
I'll search the engine SQL code for
expandhandling next. - Assistant
Found
ExpandStep.java; next I'll inspect that file and how the alias is planned. - Assistant
Reading the rest of
ExpandStepand the planner's expand/alias handling. - Assistant
The hard-coded
"value"property andgetExpandContent()look central — inspecting how the alias is (or isn't) preserved. - Assistant
Looking at existing expand tests and how projection alias flows into ExpandStep.
- Assistant
There's an ExpandParseTest.java - let me look at that and also search specifically for expand as related to the "value" property.
- Assistant
Comparing with
UnwindStep— aliases may be handled differently there. - Assistant
Checking how ProjectStep applies the alias and whether git history mentions this bug.
- Assistant
Checking ProjectionCalculationStep and any expected default
"value"field name behavior. - Assistant
Let me search tests that specifically expand arrays of primitives and check for "value"
- Assistant
There's ExpandStepTest.java and UnwindExpandStepTest.java - let me read those.
- Assistant
Let me check if ExpandStepTest checks for value property on scalars
- Assistant
Checking how callers use expanded scalar property names.
- Assistant
Let me look at ExpandStepTest for strings - does it check property names?
- Assistant
I'll check every
ExpandStepconstruction site next. - Assistant
Implementing the fix: preserving the
ASalias ingetExpandContent()(defaulting to"value") and using that property name inExpandStepfor scalar wraps. - Assistant
Need to open the file at the right line first or use edit with --file and ensure the content matches exactly.
- Assistant
Now I can use replace or edit.
- Assistant
Updating
ExpandStepto use the source property name instead of hardcoding"value". - Assistant
I need to track the field name when expanding.
- Assistant
Now update the setProperty to use fieldName, and set fieldName when reading propName.
- Assistant
I need to set fieldName = propName when we get the property name.
- Assistant
I need to check if Identifier is already imported in ProjectionItem.java
- Assistant
Identifier is in the same package. Next I'll produce a temporary reproduction script and run the related tests.
- Assistant
Compiling and running the related expand tests.
- Assistant
HOME is not set. Let me set it.
- Assistant
Tests look green; next I'll add a temporary reproduction for the issue and run more expand-related tests.
- Assistant
Existing tests pass. Creating a temporary reproduction outside the repo to verify the specific issue.
- Assistant
Let me create a simple Java file and compile/run it with the full classpath.
- Assistant
Fix verified. Running a broader set of expand-related tests for safety.
- Assistant
Cleaning up temporary files and submitting.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.
Identical first prompt
claude-sonnet-5Compare side by side →
claude-sonnet-5Compare side by side →
claude-sonnet-5Compare side by side →
claude-sonnet-5Compare side by side →
claude-sonnet-5Compare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.6-35B-A3BCompare side by side →
Qwen/Qwen3.5-35B-A3BCompare side by side →
Qwen/Qwen3.5-35B-A3BCompare side by side →