Node output sorting reversed with 'use error output'

Describe the problem/error/question

On a mySQL node, when using the ‘Continue (using error output)’ on error type, the results are reverse sorted. For ‘Continue’ or ‘Stop Workflow’ the results are sorted correctly.

What is the error message (if any)?

N/A

Please share your workflow

Note, the sequence command may be MariaDB only, but just produces 5 sequentially numbered rows. The same happens for real queries with an ORDER BY clause.

Share the output returned by the last node

[
{
“seq”: 5
},
{
“seq”: 4
},
{
“seq”: 3
},
{
“seq”: 2
},
{
“seq”: 1
}
]

Information on your n8n setup

  • n8n version: 1.63.4
  • Database (default: SQLite): postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: Linux

Looks like it’s not just mySQL nodes - the same happens on a code node:

@Jon @netroy FYI

Hi guys, thanks for reporting this!

Will create a ticket to get this looked at :eyes:

Thanks! :slight_smile: