Re: !SQLException:sql.bind:42000!Column type mismatch

On 09/09/2019 05:05, Jiading Guo wrote:

Hi,

Hi

What is the goal of these tests?

I'm doing some tests about bind operation with v11.33.11 (Apr2019-SP1) and here's how to reproduce:

mclient -d test
sql>create table unary(a int);
sql>insert into unary(a) select value from generate_series(1, 101, 1);

mclient -d test -l mal
mal>sql.init();
mal>s := sql.mvc();
mal>a := sql.bind(s, "sys", "unary", "a", 0);

The type of a can not be determined statically from the sql.bind() operation. You should use something like:

a[:int] := sql.bind(s, "sys", "unary", "a", 0);

Then I got `!SQLException:sql.bind:42000!Column type mismatch`.

I traced it down to `sql/backends/monet5/sql.c:mvc_bind_wrap`, `int
coltype = getBatType(getArgType(mb, pci, 0));` coltype is set to 255
here, which confused me about what this coltype is used for.

Also in `sql/backends/monet5/sql.mal`, the comment says the access
kind (last argument) is divided into `0, base table`, `1, inserts` and
`2, updates`. In what scenarios are these values used? Is `0` for read
only operations? What about delete operations?

MonetDB uses a delta-based scheme to record planned updates.

regards, Martin

Thanks for your help.

Best regards, Jiading Guo _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list