[SPARK-22717] Postgres is assumed to cascade truncate table by default which is not true

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 2.2.1
• Component/s: SQL

Environment

Postgres 8,9,10

• Assignee: Unassigned
• Reporter: Bolke de Bruin
• Created: 06/Dec/17 14:02
• Updated: 07/Dec/17 05:46
• Resolved: 07/Dec/17 05:13

Description

The postgres dialect returns True for isCascadingTruncateTable, which is mentioned to be returned (https://github.com/apache/spark/blob/d4107196d59638845bd19da6aab074424d90ddaf/sql/core/src/main/scala/org/apache/spark/sql/jdbc/JdbcDialects.scala#L152) to indicate that it cascades by default. This is not true accoriding to the documentationhttps://www.postgresql.org/docs/9.1/static/sql-truncate.html

domino=> truncate domino.info;
ERROR:  cannot truncate a table referenced in a foreign key constraint
DETAIL:  Table "fix" references "info".
HINT:  Truncate table "fix" at the same time, or use TRUNCATE ... CASCADE.

Issue Links

• links to: [Github] Pull Request #19911 (danielvdende)