Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Do
-
1.0.7
-
None
Description
Build tested: 1.0.7-1
By default, the max_allowed_packet is setup 1M, which allows up to about 7384 rows of lineitem to be included in the value. This affects both ColumnStore and InnoDB tables. Since we target for data warehousing, We should increase the default value to 4M or higher.
After increasing the value to 4M, I was able to insert 4x the number of rows.
I created an Autopilot test (autopilot.systemTest.largeInsert) for this test.