val sessionTz = "America/Los_Angeles"
val written = "2020-01-01 12:00:00"

withSQLConf(
  SQLConf.SESSION_LOCAL_TIMEZONE.key -> sessionTz,
  SQLConf.PARQUET_OUTPUT_TIMESTAMP_TYPE.key -> "INT96",
  SQLConf.USE_V1_SOURCE_LIST.key -> "parquet") {
  withTempPath { dir =>
    val path = dir.getCanonicalPath

    // Write "2020-01-01 12:00:00" America/Los_Angeles as INT96.
    // The bits encode the UTC instant 2020-01-01 20:00:00.
    Seq(Timestamp.valueOf(written)).toDF("ts").write.parquet(path)

    // Spark refuses to read INT96 as TimestampNTZ (SPARK-36182)
    withSQLConf(CometConf.COMET_ENABLED.key -> "false") {
      intercept[SparkException] {
        spark.read.schema("ts timestamp_ntz").parquet(path).collect()
      }
    }

    // native_datafusion silently returns a shifted value
    withSQLConf(CometConf.COMET_NATIVE_SCAN_IMPL.key -> CometConf.SCAN_NATIVE_DATAFUSION) {
      val rows = spark.read.schema("ts timestamp_ntz").parquet(path).collect()
      val actual = rows.head.getAs[LocalDateTime](0)
      // actual != LocalDateTime.parse("2020-01-01T12:00:00")
      // The value is silently wrong — shifted by the timezone offset
    }
  }
}