Re: Append an array of values to a BUN

I tried char *v_char[] = {"Y\0N\0Y\0"}; // array of strings int v_char_off[] = {0, 2, 4}; // offsets for strings // append string heaps size_t toff = tmp3->batCount == 0 ? 0 : tmp3->tvheap->free; // make sure we get alignment right toff = (toff + GDK_VARALIGN - 1) & ~(GDK_VARALIGN - 1); //create a heap of strings HEAPextend(tmp3->tvheap, toff + nrows*(sizeof(char)+1), 1); memcpy(tmp3->tvheap->base + toff, v_char, nrows*(sizeof(char)+1)); tmp3->tvheap->free = toff + nrows*(sizeof(char)+1); BATsetcount(tmp3, BATcount(tmp3) + nrows); //integers to point into a heap of strings memcpy(Tloc(tmp3, BUNlast(tmp3)), v_char_off, nrows*sizeof(int)); but output string column is empty. Anton On Fri, Nov 2, 2018 at 2:08 PM Anton Kravchenko < kravchenko.anton86@gmail.com> wrote:

Though I wonder how to append an array of values to a BUN for TYPE_str column?

sql_table *tbl = mvc_bind_table(m, sch, "atable");

sql_column *col1 = mvc_bind_column(m, tbl, "acolumn"); //char(1)

BAT *tmp1 = NULL;

int nrows = 3;

tmp1 = COLnew(0, TYPE_str, (BUN)nrows, TRANSIENT);

char v_char[3][2] = {"Y\0","N\0","Y\0"}; //char(1)

for (irow=0; irow

BUNappend(tmp1, &(v_char[irow]), FALSE);

mvc_append_column(m->session->tr, col1, tmp1);

mvc_commit(m, 0, tr->name);

bat_destroy(tmp1);

Anton

On Fri, Nov 2, 2018 at 1:12 PM Anton Kravchenko < kravchenko.anton86@gmail.com> wrote:

...

Ok to make it work I had to replace

for (irow=0; irow

BUNappend(tmp1, &v_long[irow], FALSE);

with

memcpy(Tloc(tmp1, BUNlast(tmp1)), v_long, nrows*sizeof(long long));

BATsetcount(tmp1, BATcount(tmp1) + nrows);

Anton

On Fri, Nov 2, 2018 at 9:39 AM Anton Kravchenko < kravchenko.anton86@gmail.com> wrote:

...

Hi there,

Is there a way to append an array of values to a BUN, instead one value at a time?

sql_table *tbl = mvc_bind_table(m, sch, "atable"); sql_column *col = mvc_bind_column(m, tbl, "acolumn"); BAT *tmp1 = COLnew(0, TYPE_lng, (BUN)nrows, TRANSIENT); long long v_long[3] = {100000000009,100000000010,100000000011};

for (irow=0; irow

BUNappend(tmp1, &v_long[irow], FALSE);

mvc_append_column(m->session->tr, col1, tmp1);

mvc_commit(m, 0, tr->name);

bat_destroy(tmp1);

Thanks, Anton