Function test_bind_array2

tests/tools/cdb2bind.c:417–481

}

void test_bind_array2()
{
    cdb2_hndl_tp *hndl = NULL;
    test_open(&hndl, db);

    test_exec(hndl, "drop table if exists t2");
    test_exec(hndl, "create table t2 (a int, b char(1))");
    test_exec(hndl, "insert into t2 select value, cast(value%10 as char) from generate_series(0,2999)");

    
    {
        int N = 2048;
        int values[N];
        for (int i = 0; i < N; i++) {
            values[i] = i;
        }
        cdb2_bind_array(hndl, "myarray", CDB2_INTEGER, (const void *)values, N, sizeof(values[0]));
        test_exec(hndl, "select a,b from t2 where a in carray(@myarray) order by a");
        for (int i = 0; i < N; i++) {
            test_next_record(hndl);
            int64_t *vala = cdb2_column_value(hndl, 0);
            if (*vala != values[i]) {
                fprintf(stderr, "%s:%d:error got:%"PRId64" expected:%d\n", __func__, __LINE__, *vala, values[i]);
                exit(1);
            }

            char *valb = cdb2_column_value(hndl, 1);
            if (*valb != ('0'+values[i]%10)) {
                fprintf(stderr, "%s:%d:error got:'%c' expected:'%d'\n", __func__, __LINE__, *valb, values[i]);
                exit(1);
            }

            //printf("TEST 06 RESP %"PRId64" %c\n", *vala, *valb);
        }

        cdb2_clearbindings(hndl);
    }

    {  // use bind to insert 
        test_exec(hndl, "drop table if exists t3");
        test_exec(hndl, "create table t3 (a int)");

        int N = 2048;
        int values[N];
        for (int i = 0; i < N; i++) {
            values[i] = i + 123;
        }
        cdb2_bind_array(hndl, "myintarr", CDB2_INTEGER, (const void *)values, N, sizeof(values[0]));
        test_exec(hndl, "insert into t3 select * from carray(@myintarr)");
        cdb2_clearbindings(hndl);

        // verify insert succeeded
        test_exec(hndl, "select a from t3 order by a");
        for (int i = 0; i < N; i++) {
            test_next_record(hndl);
            int64_t *vala = cdb2_column_value(hndl, 0);
            if (*vala != values[i]) {
                fprintf(stderr, "%s:%d:error got:%"PRId64" expected:%d\n", __func__, __LINE__, *vala, values[i]);