MySQL auto_generated returns NULL

CloverDX Platform
1

I have been unable to get a RETURNING statement to work with MySQL. The component connnected via port 1 returns the correct number of rows, but the auto_generated column is always NULL. My query is very simple, and I’m stumped. I’m using the commercial server 4.6

INSERT IGNORE INTO orders
(
	extid, storeid, purchasedat, clientid, loggedinassociateid
)
VALUES
(
	$OrderNumber, 57785, $OrderDate, $CustomerContact, 3787087
)
RETURNING $inserted_id:=auto_generated
2

Figured this out on my own. I didn’t realize the IGNORE statement was kicking in because I duplicate ID’s in the database. As such, nothing was actually getting inserted.