Hello. I tried to execute such command in SQL Server 2012, 2017, and 2019 on db<>fiddle and I must say that it leads to undefined results in this database system. It can set column to 1 in all rows, in can set column to 1 in some rows and to some other number in other rows depending on content of the table and I don't see any pattern.
And of course such command is not a part of the SQL Standard. H2 does not support it. Some other databases may accept it, for example, PostgreSQL accepts it and sets this column to 1 in all rows. I don't understand what do you want. UPDATE tableName SET fieldName = 1 will be more reliable, efficient, and compatible, every normal database should accept it. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/d36c46bd-d990-41b0-a365-a128f9becb54%40googlegroups.com.
