On Fri, Jul 30, 2021 at 4:02 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > > Besides, I think we need a new default value about parallel dml safety. > > Maybe > > 'auto' or 'null'(different from safe/restricted/unsafe). Because, user is > > likely to alter the safety to the default value to get the automatic safety > > check, a independent default value can make it more clear. > > > > Hmm, but auto won't work for partitioned tables, right? If so, that > might appear like an inconsistency to the user and we need to document > the same. Let me summarize the discussion so far in this thread so > that it is helpful to others. >
To avoid that inconsistency, UNSAFE could be the default for partitioned tables (and we would disallow setting AUTO for these). So then AUTO is the default for non-partitioned tables only. Regards, Greg Nancarrow Fujitsu Australia
