[Oledb-dev] Update support

[Shachar Shemesh]

Konstantin Izmailov wrote:

> Victor,
> I haven't looked at it yet again. However, I have a guess why this is
> happening. Consider the UPDATE statement ADO passes to PgOleDB:
>   update testtab set strcol=?, boolcol=? where strcol=? and boolcol=?
>  
> Strictly speaking if boolcol value before change was NULL, fourth
> parameter in the query is NULL and statement must look like:
>   update testtab set strcol=?, boolcol=? where strcol=? and boocol is null

MUST?

> The query transformation must be done by the provider (if we add
> parser and query builder).

If the provider does such a query transformation, how will I issue the
statement as originally written (and sometimes intended)?

The only "must" is this: A driver must not change the semantic meaning
of queries that pass through it. Your suggested solution would.

          Shachar