>>>>> On Fri, 10 May 2024 14:00:42 -0400, Phil Stracchino said: > > On 5/10/24 13:39, Martin Simmons wrote: > >> Column declared NOT NULL without DEFAULT (SQL99 violation) > > > > Where does SQL99 say that this is a violation for CREATE TABLE? You > > mentioned > > AUTO_INCREMENT previously, but that is MySQL-specific. > > > I can't point you at the specific line, but I do know that the reason > reason cited by Oracle for why MySQL 8 started flagging this as an error > is *because* it is a SQL99 violation.
OK, the violation is probably when you come to use INSERT rather than the CREATE TABLE statement itself. __Martin _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
