Function test_multi_column_index

crates/core/src/sql/execute.rs:512–542

()

    /// Test a query that uses a multi-column index
    #[tokio::test]
    async fn test_multi_column_index() -> anyhow::Result<()> {
        let db = TestDB::in_memory()?;

        let schema = [
            ("a", AlgebraicType::U64),
            ("b", AlgebraicType::U64),
            ("c", AlgebraicType::U64),
        ];

        let table_id = db.create_table_for_test_multi_column("t", &schema, [1, 2].into())?;

        insert_rows(
            &db,
            table_id,
            vec![
                product![0_u64, 1_u64, 2_u64],
                product![1_u64, 2_u64, 1_u64],
                product![2_u64, 2_u64, 2_u64],
            ],
        )?;

        assert_query_results(
            db.clone(),
            "select * from t where c = 1 and b = 2",
            AuthCtx::for_testing(),
            [product![1_u64, 2_u64, 1_u64]],
        )
        .await;

        Ok(())
    }

    /// Test querying a table with RLS rules
    #[tokio::test]