ij> create table ai (x int, y int generated always as identity (increment by 200000000)); ij> insert into ai (x) values (1),(2),(3),(4),(5),(6),(7), (8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
ERROR 42Z24: Overflow occurred in identity for column 'Y' in table 'AI': SQLSTATE: 22003: The resulting value is outside the range for the data type INTEGER.
ERROR 42Z24: Overflow occurred in identity for column 'Y' in table 'AI'.
ERROR 22003: The resulting value is outside the range for the data type INTEGER.
This is because the network client driver reports only one SQLException or one SQLWarning per statement.