opened
elonazoulay
username_0
This is to avoid an issue where the jdbc client attempts
to insert into unsupported columns which are not present
in the presto jdbc tmp table but are present in the database.
Only include selected columns in jdbc insert statement
issue
created
elonazoulay
username_0
Some more context: we had an issue where some column types in our postgres database are not supported and tried to run an insert from presto. Instead of doing "SELECT * FROM <tmp_table" the jdbc client will select only the columns in the temp table.

Note: If the unsupported columns have not null constraints the insert will fail.
comment
created
electrum
username_1
Can you add a test for this in `TestPostgreSqlIntegrationSmokeTest`? See `testTableWithNoSupportedColumns` for an example of creating a table with unsupported columns.
comment
created
findepi
username_2
This seems superseded by https://github.com/prestosql/presto/commit/d36b1053d733cfd6d1c2bf043c7ca321eae93da2.
comment
created
martint
username_3
This was implemented as part of another PR
comment