SQL Test Queries IN statement

These are the tests and expected results for JOINs. These tests can be found in camlsql.sql_joins.spec.js.

SQL Test Query - IN #001

Select from List1 Where Field1 is any of the specified numbers

1. "SELECT * FROM List1 WHERE Field1 IN ?", [[1,2,3]]

<View>
    <Query>
        <Where>
            <In>
                <FieldRef Name="Field1" />
                <Values>
                    <Value Type="Number">1</Value>
                    <Value Type="Number">2</Value>
                    <Value Type="Number">3</Value>
                </Values>
            </In>
        </Where>
    </Query>
</View>

SQL Test Query - IN #002

Error if parameter is not an array

1. "SELECT * FROM List1 WHERE Field1 IN ?", [1,2,3]

Uncaught [camlsql] IN parameter must be an array