# 21:51:04.89 >  call java nl.cwi.monetdb.client.JdbcClient -h WIN2K12R2 -p 35286 -d mTests_sql_jdbc_tests -e -f "C:\monettesting\6299dc70f959-7-2-2\MonetDB\sql\jdbc\tests\Tests\bogus-auto-generated-keys.sql" 
START TRANSACTION;
Operation successful
-- generate a simple table with an auto-generated key (id)
CREATE TABLE gen_keys (
	"id" serial,
	"x" varchar(12)
);
Operation successful

-- perform an update, useless, but illustrates the bug, this time no
-- generated key is reported, which is correct
UPDATE gen_keys SET "x" = 'bla' WHERE "id" = 12;
0 affected rows

-- insert some value, should get a generated key
INSERT INTO gen_keys ("x") VALUES ('boe');
1 affected row, last generated key: 1

-- update again, we expect NO generated key, but we DO get one
UPDATE gen_keys SET "x" = 'bla' WHERE "id" = 1;
1 affected row, last generated key: 1
UPDATE gen_keys SET "x" = 'bla' WHERE "id" = 12;
0 affected rows, last generated key: 1

-- ok, cleanup a bit
DROP TABLE gen_keys;
Operation successful
ROLLBACK;
Operation successful