How to use 'orderBy' on a joined query?

[mrverdant13]

When I use the following expresion, an exception is thrown.

final joinedQuery = select(
      firstTable,
    ).join(
      [
        innerJoin(
          secondTable,
          secondTable.id.equalsExp(
            firstTable.secondId,
          ),
        ),
      ],
    );

    joinedQuery
      ..where( ... )
      ..orderBy(
        [OrderingTerm.asc(secondTable.name)],
      );

    return joinedQuery.get()

[simolus3]

Does the I/O error only happen for that query? From a quick search, it looks like that error could happen if an auxiliary journey file for sqlite3 isn't writable. I don't really see how this condition could be triggered from a specific query, do you have a repro for me to look at?

[mrverdant13]

It only happen for that specific query, yes.
My workaround was to sort the results inline (with Dart) but I am aware of this as a bad approach.
I have no public repo for reference but I am going to set up a new one with a similar query.
Must point this out: the issue shows up when the orderBy caluse is appended that way (after a join set).