# Node output sorting reversed with 'use error output'

**URL:** <https://community.n8n.io/t/node-output-sorting-reversed-with-use-error-output/59257>\
**Category:** Questions\
**Tags:** mysql\
**Created:** [October 21, 2024, 10:44am UTC](https://community.n8n.io/t/node-output-sorting-reversed-with-use-error-output/59257 "2024-10-21T10:44:39Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![TomSpidge](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tomspidge/32/24404_2.png) [@TomSpidge](https://community.n8n.io/u/TomSpidge)\
**Post date:** [October 21, 2024, 10:44am UTC](https://community.n8n.io/t/node-output-sorting-reversed-with-use-error-output/59257/1 "2024-10-21T10:44:39Z")

</div>

## 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**

---

<div class="post-metadata">

**Author:** ![TomSpidge](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tomspidge/32/24404_2.png) [@TomSpidge](https://community.n8n.io/u/TomSpidge)\
**Post date:** [October 21, 2024, 11:07am UTC](https://community.n8n.io/t/node-output-sorting-reversed-with-use-error-output/59257/2 "2024-10-21T11:07:40Z")

</div>

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

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/c/6/c6136505fc186801c0b5b86d8705caec7492a88c.png)

---

<div class="post-metadata">

**Author:** ![barn4k](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/barn4k/32/8170_2.png) [@barn4k](https://community.n8n.io/u/barn4k)\
**Post date:** [October 21, 2024, 12:19pm UTC](https://community.n8n.io/t/node-output-sorting-reversed-with-use-error-output/59257/3 "2024-10-21T12:19:21Z")

</div>

@Jon @netroy FYI

---

<div class="post-metadata">

**Author:** ![ria](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ria/32/99251_2.png) [@ria](https://community.n8n.io/u/ria)\
**Post date:** [October 29, 2024, 8:31am UTC](https://community.n8n.io/t/node-output-sorting-reversed-with-use-error-output/59257/4 "2024-10-29T08:31:54Z")

</div>

Hi guys, thanks for reporting this!

Will create a ticket to get this looked at 👀

Thanks! 🙂

---

<div class="post-metadata">

**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\
**Post date:** [November 13, 2024, 5:11pm UTC](https://community.n8n.io/t/node-output-sorting-reversed-with-use-error-output/59257/6 "2024-11-13T17:11:58Z")

</div>

New version [`n8n@1.68.0`](https://github.com/n8n-io/n8n/releases/tag/n8n%401.68.0) got released which includes the [GitHub PR 11684](https://github.com/n8n-io/n8n/pull/11684).

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [February 11, 2025, 5:12pm UTC](https://community.n8n.io/t/node-output-sorting-reversed-with-use-error-output/59257/7 "2025-02-11T17:12:41Z")

</div>

Closed on February 11, 2025, 5:12pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
