Column option column_type doesn't works with UPDATE

[mkgrgis]

Column option column_type exists for timestamp and uuid PostgreSQL data types where there is some mixed affinity support.

SQLite, SQL CREATE TABLE (i int, t timestamp);
PosgtreSQL, foreign table with key i and timestamp t with column_type = int.

Near

sqlite_fdw/deparse.c

Line 2373 in d6387a8

sqlite_deparse_column_ref(buf, rtindex, attnum, root, false, true);

constant expressions always deparsed by default algorithm. For timestamp this is text affinity value. See

sqlite_fdw/deparse.c

Line 2576 in d6387a8

sqlite_deparse_const(Const *node, deparse_expr_cxt *context, int showtype)

But in UPDATE context there is no complementarynode or something similar

sqlite_fdw/deparse.c

Line 2652 in d6387a8

if (context->complementarynode != NULL)

With UUID support in my PR there is similar tested problem after

sqlite_fdw/expected/12.15/type.out

Line 805 in d6387a8

ALTER FOREIGN TABLE "type_UUID" ALTER COLUMN "u" OPTIONS (SET column_type 'TEXT');

sqlite_fdw/expected/12.15/type.out

Line 813 in d6387a8

SQLite query: UPDATE main."type_UUID" SET `u` = X'b0eebc999c0b4ef8bb6d6bb9bd380a15' WHERE ((`i` = 25))

My solution:

• use for calculated update expression some data normalization function with needed data affinity output, for ex. strftime if we need integer affinity
• for getting data affinity of calculated expression get column_type option and PostgreSQL data type for updatable attribute of foreign table.

Corresponding PR yet drafted and planned after bit/varbit support, bool mixed affinity support and float mixed affinity support.

[mkgrgis]

The problem for timestamp still exists, in #95 (comment) @son-phamngoc recommends me exclude code about timestamp from that PR as a code not about UUID and as untested line.