SQL Test Queries ORDER BY

These are the tests and expected results for different ORDER BY queries.

These tests can be found in camlsql.sql_orderby_testqueries.spec.js.

SQL ORDER BY Test Query #001

1. "SELECT * FROM List ORDER BY Field", []
2. "SELECT * FROM List ORDER BY [Field]", []

<View>
    <Query>
        <OrderBy>
            <FieldRef Name="Field" />
        </OrderBy>
    </Query>
</View>

SQL ORDER BY Test Query #002

1. "SELECT * FROM List ORDER BY Field desc", []
2. "SELECT * FROM List ORDER BY [Field] desc", []

<View>
    <Query>
        <OrderBy>
            <FieldRef Name="Field" Ascending="False" />
        </OrderBy>
    </Query>
</View>

SQL ORDER BY Test Query #003

1. "SELECT * FROM List ORDER BY Field, Field2", []
2. "SELECT * FROM List ORDER BY [Field], Field2", []

<View>
    <Query>
        <OrderBy>
            <FieldRef Name="Field" />
            <FieldRef Name="Field2" />
        </OrderBy>
    </Query>
</View>