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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/d36c46bd-d990-41b0-a365-a128f9becb54%40googlegroups.com.