Google Git
Sign in
apache / derby / 08cc0f89fe077234078430bf9b93ebc9dfd70ac5 / . / java / testing / org / apache / derbyTesting / functionTests / tests / lang / OrderByAndSortAvoidance.java
blob: 8cdc152c3d90e748bbffe51c8038f14801d5b550 [file] [log] [blame]
/*
* Class org.apache.derbyTesting.functionTests.tests.lang.OrderByAndSortAvoidance
*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*/
package org.apache.derbyTesting.functionTests.tests.lang;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import junit.framework.Test;
import org.apache.derbyTesting.junit.BaseJDBCTestCase;
import org.apache.derbyTesting.junit.BaseTestSuite;
import org.apache.derbyTesting.junit.CleanDatabaseTestSetup;
import org.apache.derbyTesting.junit.JDBC;
import org.apache.derbyTesting.junit.RuntimeStatisticsParser;
import org.apache.derbyTesting.junit.SQLUtilities;
import org.apache.derbyTesting.junit.TestConfiguration;
/**
* Tests for DERBY-3926. Optimizer is choosing to avoid sort which is
* causing the results to be returned in wrong order.
*/
public class OrderByAndSortAvoidance extends BaseJDBCTestCase {
public OrderByAndSortAvoidance(String name) {
super(name);
}
/**
* Construct top level suite in this JUnit test
*
* @return A suite containing embedded and client suites.
*/
public static Test suite()
{
BaseTestSuite suite = new BaseTestSuite("OrderByAndSortAvoidance");
suite.addTest(makeSuite());
suite.addTest(
TestConfiguration.clientServerDecorator(makeSuite()));
return suite;
}
/**
* Construct suite of tests
*
* @return A suite containing the test cases.
*/
private static Test makeSuite()
{
return new CleanDatabaseTestSetup(
new BaseTestSuite(OrderByAndSortAvoidance.class)) {
protected void decorateSQL(Statement st)
throws SQLException {
st.executeUpdate("create table a(col1 int, col2 int)");
st.executeUpdate("insert into a values(1,1),(1,1)");
st.executeUpdate("create table b(col1 int, col2 int)");
st.executeUpdate("insert into b values(2,2),(2,2)");
st.executeUpdate("create table c(col1 int, col2 int)");
st.executeUpdate("insert into c values(3,3),(3,3)");
st.executeUpdate(
"create TABLE table1 (id BIGINT NOT NULL, PRIMARY KEY(id))");
st.executeUpdate(
"CREATE INDEX key1 ON table1(id)");
st.executeUpdate(
"CREATE TABLE table2 (id BIGINT NOT NULL, name "
+ "VARCHAR(40) NOT NULL, value VARCHAR(1024), PRIMARY "
+ "KEY(id, name))");
st.executeUpdate(
"CREATE UNIQUE INDEX key2 ON table2(id, name)");
st.executeUpdate(
"CREATE INDEX key3 ON table2(value)");
populateTestTables(getConnection());
//Start of tables creation for DERBY-4240 repro
st.executeUpdate(
"CREATE TABLE test1 (id BIGINT NOT NULL, name VARCHAR(255), "+
"PRIMARY KEY (id))");
st.executeUpdate(
"CREATE TABLE test2 (entity_id BIGINT, rel_id BIGINT)");
st.executeUpdate(
"CREATE INDEX idx_test2 ON test2 (entity_id)");
st.executeUpdate(
"INSERT INTO test1 (id, name) VALUES (102, 'Tom')");
st.executeUpdate(
"INSERT INTO test1 (id, name) VALUES (1, null)");
st.executeUpdate(
"INSERT INTO test1 (id, name) VALUES (103, 'Jerry')");
st.executeUpdate(
"INSERT INTO test1 (id, name) VALUES (101, 'Pupy')");
st.executeUpdate(
"INSERT INTO test2 (entity_id, rel_id) VALUES (1, 102)");
st.executeUpdate(
"INSERT INTO test2 (entity_id, rel_id) VALUES (1, 101)");
st.executeUpdate(
"INSERT INTO test2 (entity_id, rel_id) VALUES (1, 103)");
//End of tables creation for DERBY-4240 repro
//Start of tables creation for DERBY-4331 repro
st.executeUpdate(
"CREATE TABLE REPOSITORIES ( ID INT CONSTRAINT "+
"REPOSITORIES_PRIMARY_ID PRIMARY KEY GENERATED ALWAYS "+
"AS IDENTITY, "+
"PATH VARCHAR(32672) CONSTRAINT REPOSITORIES_PATH "+
"UNIQUE NOT NULL)");
st.executeUpdate(
"CREATE TABLE FILES ( ID INT CONSTRAINT FILES_PRIMARY_ID "+
"PRIMARY KEY GENERATED ALWAYS AS IDENTITY, "+
"PATH VARCHAR(32672) NOT NULL, REPOSITORY INT NOT NULL "+
"REFERENCES REPOSITORIES ON DELETE CASCADE, "+
"CONSTRAINT FILES_REPOSITORY_PATH UNIQUE "+
"(REPOSITORY, PATH))");
st.executeUpdate(
"CREATE TABLE AUTHORS ( "+
"ID INT CONSTRAINT AUTHORS_PRIMARY_ID PRIMARY KEY "+
"GENERATED ALWAYS AS IDENTITY, REPOSITORY INT NOT NULL "+
"REFERENCES REPOSITORIES ON DELETE CASCADE, "+
"NAME VARCHAR(32672) NOT NULL, "+
"CONSTRAINT AUTHORS_REPOSITORY_NAME UNIQUE (REPOSITORY, NAME))");
st.executeUpdate(
"CREATE TABLE CHANGESETS ( "+
"ID INT CONSTRAINT CHANGESETS_PRIMARY_ID PRIMARY KEY "+
"GENERATED ALWAYS AS IDENTITY, " +
"REPOSITORY INT NOT NULL REFERENCES REPOSITORIES "+
"ON DELETE CASCADE, REVISION VARCHAR(1024) NOT NULL, "+
"AUTHOR INT NOT NULL REFERENCES AUTHORS ON DELETE CASCADE, "+
"TIME TIMESTAMP NOT NULL, MESSAGE VARCHAR(32672) NOT NULL, "+
"CONSTRAINT CHANGESETS_REPOSITORY_REVISION UNIQUE "+
"(REPOSITORY, REVISION))");
st.executeUpdate(
"CREATE UNIQUE INDEX IDX_CHANGESETS_ID_DESC ON "+
"CHANGESETS(ID DESC)");
st.executeUpdate(
"CREATE TABLE FILECHANGES ( "+
"ID INT CONSTRAINT FILECHANGES_PRIMARY_ID PRIMARY KEY "+
"GENERATED ALWAYS AS IDENTITY, FILE INT NOT NULL "+
"REFERENCES FILES ON DELETE CASCADE, "+
"CHANGESET INT NOT NULL REFERENCES CHANGESETS "+
"ON DELETE CASCADE, " +
"CONSTRAINT FILECHANGES_FILE_CHANGESET "+
"UNIQUE (FILE, CHANGESET))");
st.executeUpdate(
"insert into repositories(path) values "+
"'/var/tmp/source5923202038296723704opengrok/mercurial'");
st.executeUpdate(
"insert into files(path, repository) values "+
"('/mercurial/Makefile', 1), "+
"('/mercurial/main.c', 1), "+
"('/mercurial/header.h', 1), "+
"('/mercurial/.hgignore', 1)");
st.executeUpdate(
"insert into authors(repository, name) values "+
"(1, 'Trond Norbye <trond.norbye@sun.com>')");
st.executeUpdate(
"insert into changesets(repository, revision, author, "+
"time, message) values (1,'0:816b6279ae9c',1,"+
"'2008-08-12 22:00:00.0','Add .hgignore file'),"+
"(1,'1:f24a5fd7a85d',1,'2008-08-12 22:03:00.0',"+
"'Created a small dummy program'),"+
"(1,'2:585a1b3f2efb',1,'2008-08-12 22:13:00.0',"+
"'Add lint make target and fix lint warnings')");
st.executeUpdate(
"insert into filechanges(file, changeset) values "+
"(4,1),(1,2),(3,2),(2,2),(1,3),(2,3)");
//End of tables creation for DERBY-4331 repro
}
};
}
/**
* Helper method that inserts a row into table1.
* @param ps parameterized statement that inserts a row into table1
* @param id the value of the id column
*/
private static void insertTable1(PreparedStatement ps, long id)
throws SQLException {
ps.setLong(1, id);
ps.executeUpdate();
}
/**
* Helper method that inserts a row into table2.
* @param ps parameterized statement that inserts a row into table2
* @param id the value of the id column
* @param name the value of the name column
* @param value the value of the value column
*/
private static void insertTable2(PreparedStatement ps, long id,
String name, String value)
throws SQLException {
ps.setLong(1, id);
ps.setString(2, name);
ps.setString(3, value);
ps.executeUpdate();
}
/**
* Helper method that updates a row in table2
* @param ps parameterized statement that updates a row in table2
* @param id the id of the row to update
*/
private static void updateTable2(PreparedStatement ps, long id) throws SQLException {
ps.setLong(1, id);
ps.executeUpdate();
}
/**
* Populate table1 and table2 with the rows needed for reproducing
* DERBY-3926.
*/
private static void populateTestTables(Connection conn) throws SQLException {
PreparedStatement it1 = conn.prepareStatement(
"INSERT INTO table1 VALUES (?)");
PreparedStatement it2 = conn.prepareStatement(
"INSERT INTO table2 VALUES (?,?,?)");
PreparedStatement ut2 = conn.prepareStatement(
"UPDATE table2 SET value='true' WHERE id=? AND name='has_address'");
insertTable1(it1, 2147483649L);
insertTable2(it2, 2147483649L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483649L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483649L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483649L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483649L, "DocumentSortingValues", "______21855__1__1");
insertTable2(it2, 2147483649L, "ItemSeq", "1");
insertTable2(it2, 2147483649L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483649L, "Plex", "S");
insertTable2(it2, 2147483649L, "SC3", "=");
insertTable2(it2, 2147483649L, "has_address", "true");
insertTable2(it2, 2147483649L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483649L, "Language", "FR");
insertTable2(it2, 2147483649L, "logo", "false");
insertTable2(it2, 2147483649L, "SC4", "=");
insertTable2(it2, 2147483649L, "InternalAddress", "");
insertTable2(it2, 2147483649L, "AddressG6", "");
insertTable2(it2, 2147483649L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483649L, "AddresseeSeq", "1");
insertTable2(it2, 2147483649L, "SC1", "Country=BE");
insertTable2(it2, 2147483649L, "CommunicationOrderId", "21865");
insertTable2(it2, 2147483649L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483649L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483649L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483649L, "Enveloping", "C");
insertTable2(it2, 2147483649L, "PostComponentId", "21855");
insertTable2(it2, 2147483649L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483649L, "city", "Bruxelles");
insertTable2(it2, 2147483649L, "AddressG7", "");
insertTable2(it2, 2147483649L, "CopyMention", "");
insertTable2(it2, 2147483649L, "AddressG8", "");
insertTable2(it2, 2147483649L, "StapleNbr", "");
insertTable2(it2, 2147483649L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483649L, "AddressG5", "");
insertTable2(it2, 2147483649L, "header", "true");
insertTable2(it2, 2147483649L, "EnvelopSortingValue", "BE1180___testOlivier001-0001___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483649L, "GroupedWith", "");
insertTable2(it2, 2147483649L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483649L, "DiversionReason", "");
insertTable2(it2, 2147483649L, "Pliable", "true");
insertTable2(it2, 2147483649L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483649L, "country", "BE");
insertTable2(it2, 2147483649L, "AddressG1", "testOlivier001-0001");
insertTable2(it2, 2147483649L, "MentionCode", "");
insertTable2(it2, 2147483649L, "postCode", "1180");
insertTable2(it2, 2147483649L, "SC5", "=");
insertTable2(it2, 2147483649L, "Branding", "1C");
insertTable1(it1, 2147483650L);
insertTable2(it2, 2147483650L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483650L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483650L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483650L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483650L, "DocumentSortingValues", "______21855__1__1");
insertTable2(it2, 2147483650L, "ItemSeq", "1");
insertTable2(it2, 2147483650L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483650L, "Plex", "S");
insertTable2(it2, 2147483650L, "SC3", "=");
insertTable2(it2, 2147483650L, "has_address", "true");
insertTable2(it2, 2147483650L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483650L, "Language", "FR");
insertTable2(it2, 2147483650L, "logo", "false");
insertTable2(it2, 2147483650L, "SC4", "=");
insertTable2(it2, 2147483650L, "InternalAddress", "");
insertTable2(it2, 2147483650L, "AddressG6", "");
insertTable2(it2, 2147483650L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483650L, "AddresseeSeq", "1");
insertTable2(it2, 2147483650L, "SC1", "Country=BE");
insertTable2(it2, 2147483650L, "CommunicationOrderId", "21865");
insertTable2(it2, 2147483650L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483650L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483650L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483650L, "Enveloping", "C");
insertTable2(it2, 2147483650L, "PostComponentId", "21855");
insertTable2(it2, 2147483650L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483650L, "city", "Bruxelles");
insertTable2(it2, 2147483650L, "AddressG7", "");
insertTable2(it2, 2147483650L, "CopyMention", "");
insertTable2(it2, 2147483650L, "AddressG8", "");
insertTable2(it2, 2147483650L, "StapleNbr", "");
insertTable2(it2, 2147483650L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483650L, "AddressG5", "");
insertTable2(it2, 2147483650L, "header", "true");
insertTable2(it2, 2147483650L, "EnvelopSortingValue", "BE1180___testOlivier001-0001___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483650L, "GroupedWith", "");
insertTable2(it2, 2147483650L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483650L, "DiversionReason", "");
insertTable2(it2, 2147483650L, "Pliable", "true");
insertTable2(it2, 2147483650L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483650L, "country", "BE");
insertTable2(it2, 2147483650L, "AddressG1", "testOlivier001-0001");
insertTable2(it2, 2147483650L, "MentionCode", "");
insertTable2(it2, 2147483650L, "postCode", "1180");
insertTable2(it2, 2147483650L, "SC5", "=");
insertTable2(it2, 2147483650L, "Branding", "1C");
insertTable1(it1, 2147483651L);
insertTable2(it2, 2147483651L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483651L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483651L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483651L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483651L, "DocumentSortingValues", "______21856__1__1");
insertTable2(it2, 2147483651L, "ItemSeq", "1");
insertTable2(it2, 2147483651L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483651L, "Plex", "S");
insertTable2(it2, 2147483651L, "SC3", "=");
insertTable2(it2, 2147483651L, "has_address", "true");
insertTable2(it2, 2147483651L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483651L, "Language", "FR");
insertTable2(it2, 2147483651L, "logo", "false");
insertTable2(it2, 2147483651L, "SC4", "=");
insertTable2(it2, 2147483651L, "InternalAddress", "");
insertTable2(it2, 2147483651L, "AddressG6", "");
insertTable2(it2, 2147483651L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483651L, "AddresseeSeq", "1");
insertTable2(it2, 2147483651L, "SC1", "Country=BE");
insertTable2(it2, 2147483651L, "CommunicationOrderId", "21866");
insertTable2(it2, 2147483651L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483651L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483651L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483651L, "Enveloping", "C");
insertTable2(it2, 2147483651L, "PostComponentId", "21856");
insertTable2(it2, 2147483651L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483651L, "city", "Bruxelles");
insertTable2(it2, 2147483651L, "AddressG7", "");
insertTable2(it2, 2147483651L, "CopyMention", "");
insertTable2(it2, 2147483651L, "AddressG8", "");
insertTable2(it2, 2147483651L, "StapleNbr", "");
insertTable2(it2, 2147483651L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483651L, "AddressG5", "");
insertTable2(it2, 2147483651L, "header", "true");
insertTable2(it2, 2147483651L, "EnvelopSortingValue", "BE1180___testOlivier001-0002___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483651L, "GroupedWith", "");
insertTable2(it2, 2147483651L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483651L, "DiversionReason", "");
insertTable2(it2, 2147483651L, "Pliable", "true");
insertTable2(it2, 2147483651L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483651L, "country", "BE");
insertTable2(it2, 2147483651L, "AddressG1", "testOlivier001-0002");
insertTable2(it2, 2147483651L, "MentionCode", "");
insertTable2(it2, 2147483651L, "postCode", "1180");
insertTable2(it2, 2147483651L, "SC5", "=");
insertTable2(it2, 2147483651L, "Branding", "1C");
insertTable1(it1, 2147483652L);
insertTable2(it2, 2147483652L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483652L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483652L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483652L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483652L, "DocumentSortingValues", "______21856__1__1");
insertTable2(it2, 2147483652L, "ItemSeq", "1");
insertTable2(it2, 2147483652L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483652L, "Plex", "S");
insertTable2(it2, 2147483652L, "SC3", "=");
insertTable2(it2, 2147483652L, "has_address", "true");
insertTable2(it2, 2147483652L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483652L, "Language", "FR");
insertTable2(it2, 2147483652L, "logo", "false");
insertTable2(it2, 2147483652L, "SC4", "=");
insertTable2(it2, 2147483652L, "InternalAddress", "");
insertTable2(it2, 2147483652L, "AddressG6", "");
insertTable2(it2, 2147483652L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483652L, "AddresseeSeq", "1");
insertTable2(it2, 2147483652L, "SC1", "Country=BE");
insertTable2(it2, 2147483652L, "CommunicationOrderId", "21866");
insertTable2(it2, 2147483652L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483652L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483652L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483652L, "Enveloping", "C");
insertTable2(it2, 2147483652L, "PostComponentId", "21856");
insertTable2(it2, 2147483652L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483652L, "city", "Bruxelles");
insertTable2(it2, 2147483652L, "AddressG7", "");
insertTable2(it2, 2147483652L, "CopyMention", "");
insertTable2(it2, 2147483652L, "AddressG8", "");
insertTable2(it2, 2147483652L, "StapleNbr", "");
insertTable2(it2, 2147483652L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483652L, "AddressG5", "");
insertTable2(it2, 2147483652L, "header", "true");
insertTable2(it2, 2147483652L, "EnvelopSortingValue","BE1180___testOlivier001-0002___________Bla bla bla bla bl,a bla 99____");
insertTable2(it2, 2147483652L, "GroupedWith", "");
insertTable2(it2, 2147483652L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483652L, "DiversionReason", "");
insertTable2(it2, 2147483652L, "Pliable", "true");
insertTable2(it2, 2147483652L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483652L, "country", "BE");
insertTable2(it2, 2147483652L, "AddressG1", "testOlivier001-0002");
insertTable2(it2, 2147483652L, "MentionCode", "");
insertTable2(it2, 2147483652L, "postCode", "1180");
insertTable2(it2, 2147483652L, "SC5", "=");
insertTable2(it2, 2147483652L, "Branding", "1C");
insertTable1(it1, 2147483653L);
insertTable2(it2, 2147483653L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483653L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483653L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483653L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483653L, "DocumentSortingValues", "______21857__1__1");
insertTable2(it2, 2147483653L, "ItemSeq", "1");
insertTable2(it2, 2147483653L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483653L, "Plex", "S");
insertTable2(it2, 2147483653L, "SC3", "=");
insertTable2(it2, 2147483653L, "has_address", "true");
insertTable2(it2, 2147483653L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483653L, "Language", "FR");
insertTable2(it2, 2147483653L, "logo", "false");
insertTable2(it2, 2147483653L, "SC4", "=");
insertTable2(it2, 2147483653L, "InternalAddress", "233/621");
insertTable2(it2, 2147483653L, "AddressG6", "");
insertTable2(it2, 2147483653L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483653L, "AddresseeSeq", "1");
insertTable2(it2, 2147483653L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483653L, "CommunicationOrderId", "21867");
insertTable2(it2, 2147483653L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483653L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483653L, "SortPlan", "");
insertTable2(it2, 2147483653L, "Enveloping", "N");
insertTable2(it2, 2147483653L, "PostComponentId", "21857");
insertTable2(it2, 2147483653L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483653L, "city", "Bruxelles");
insertTable2(it2, 2147483653L, "AddressG7", "");
insertTable2(it2, 2147483653L, "CopyMention", "");
insertTable2(it2, 2147483653L, "AddressG8", "");
insertTable2(it2, 2147483653L, "StapleNbr", "");
insertTable2(it2, 2147483653L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483653L, "AddressG5", "");
insertTable2(it2, 2147483653L, "header", "true");
insertTable2(it2, 2147483653L, "EnvelopSortingValue", "BE1180___testOlivier002-0003___________Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483653L, "GroupedWith", "");
insertTable2(it2, 2147483653L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483653L, "DiversionReason", "001");
insertTable2(it2, 2147483653L, "Pliable", "true");
insertTable2(it2, 2147483653L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483653L, "country", "BE");
insertTable2(it2, 2147483653L, "AddressG1", "testOlivier002-0003");
insertTable2(it2, 2147483653L, "MentionCode", "");
insertTable2(it2, 2147483653L, "postCode", "1180");
insertTable2(it2, 2147483653L, "SC5", "=");
insertTable2(it2, 2147483653L, "Branding", "1C");
insertTable1(it1, 2147483654L);
insertTable2(it2, 2147483654L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483654L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483654L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483654L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483654L, "DocumentSortingValues", "______21857__1__1");
insertTable2(it2, 2147483654L, "ItemSeq", "1");
insertTable2(it2, 2147483654L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483654L, "Plex", "S");
insertTable2(it2, 2147483654L, "SC3", "=");
insertTable2(it2, 2147483654L, "has_address", "true");
insertTable2(it2, 2147483654L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483654L, "Language", "FR");
insertTable2(it2, 2147483654L, "logo", "false");
insertTable2(it2, 2147483654L, "SC4", "=");
insertTable2(it2, 2147483654L, "InternalAddress","233/621");
insertTable2(it2, 2147483654L, "AddressG6", "");
insertTable2(it2, 2147483654L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483654L, "AddresseeSeq", "1");
insertTable2(it2, 2147483654L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483654L, "CommunicationOrderId", "21867");
insertTable2(it2, 2147483654L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483654L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483654L, "SortPlan", "");
insertTable2(it2, 2147483654L, "Enveloping", "N");
insertTable2(it2, 2147483654L, "PostComponentId", "21857");
insertTable2(it2, 2147483654L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483654L, "city", "Bruxelles");
insertTable2(it2, 2147483654L, "AddressG7", "");
insertTable2(it2, 2147483654L, "CopyMention", "");
insertTable2(it2, 2147483654L, "AddressG8", "");
insertTable2(it2, 2147483654L, "StapleNbr", "");
insertTable2(it2, 2147483654L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483654L, "AddressG5", "");
insertTable2(it2, 2147483654L, "header", "true");
insertTable2(it2, 2147483654L, "EnvelopSortingValue", "BE1180___testOlivier002-0003___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483654L, "GroupedWith", "");
insertTable2(it2, 2147483654L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483654L, "DiversionReason", "001");
insertTable2(it2, 2147483654L, "Pliable", "true");
insertTable2(it2, 2147483654L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483654L, "country", "BE");
insertTable2(it2, 2147483654L, "AddressG1", "testOlivier002-0003");
insertTable2(it2, 2147483654L, "MentionCode", "");
insertTable2(it2, 2147483654L, "postCode", "1180");
insertTable2(it2, 2147483654L, "SC5", "=");
insertTable2(it2, 2147483654L, "Branding", "1C");
insertTable1(it1, 2147483655L);
insertTable2(it2, 2147483655L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483655L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483655L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483655L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483655L, "DocumentSortingValues", "______21858__1__1");
insertTable2(it2, 2147483655L, "ItemSeq", "1");
insertTable2(it2, 2147483655L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483655L, "Plex", "S");
insertTable2(it2, 2147483655L, "SC3", "=");
insertTable2(it2, 2147483655L, "has_address", "true");
insertTable2(it2, 2147483655L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483655L, "Language", "FR");
insertTable2(it2, 2147483655L, "logo", "false");
insertTable2(it2, 2147483655L, "SC4", "=");
insertTable2(it2, 2147483655L, "InternalAddress", "233/621");
insertTable2(it2, 2147483655L, "AddressG6", "");
insertTable2(it2, 2147483655L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483655L, "AddresseeSeq", "1");
insertTable2(it2, 2147483655L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483655L, "CommunicationOrderId", "21868");
insertTable2(it2, 2147483655L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483655L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483655L, "SortPlan", "");
insertTable2(it2, 2147483655L, "Enveloping", "N");
insertTable2(it2, 2147483655L, "PostComponentId", "21858");
insertTable2(it2, 2147483655L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483655L, "city", "Bruxelles");
insertTable2(it2, 2147483655L, "AddressG7", "");
insertTable2(it2, 2147483655L, "CopyMention", "");
insertTable2(it2, 2147483655L, "AddressG8", "");
insertTable2(it2, 2147483655L, "StapleNbr", "");
insertTable2(it2, 2147483655L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483655L, "AddressG5", "");
insertTable2(it2, 2147483655L, "header", "true");
insertTable2(it2, 2147483655L, "EnvelopSortingValue", "BE1180___testOlivier002-0004___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483655L, "GroupedWith", "");
insertTable2(it2, 2147483655L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483655L, "DiversionReason", "001");
insertTable2(it2, 2147483655L, "Pliable", "true");
insertTable2(it2, 2147483655L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483655L, "country", "BE");
insertTable2(it2, 2147483655L, "AddressG1", "testOlivier002-0004");
insertTable2(it2, 2147483655L, "MentionCode", "");
insertTable2(it2, 2147483655L, "postCode", "1180");
insertTable2(it2, 2147483655L, "SC5", "=");
insertTable2(it2, 2147483655L, "Branding", "1C");
insertTable1(it1, 2147483656L);
insertTable2(it2, 2147483656L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483656L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483656L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483656L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483656L, "DocumentSortingValues", "______21858__1__1");
insertTable2(it2, 2147483656L, "ItemSeq", "1");
insertTable2(it2, 2147483656L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483656L, "Plex", "S");
insertTable2(it2, 2147483656L, "SC3", "=");
insertTable2(it2, 2147483656L, "has_address", "true");
insertTable2(it2, 2147483656L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483656L, "Language", "FR");
insertTable2(it2, 2147483656L, "logo", "false");
insertTable2(it2, 2147483656L, "SC4", "=");
insertTable2(it2, 2147483656L, "InternalAddress", "233/621");
insertTable2(it2, 2147483656L, "AddressG6", "");
insertTable2(it2, 2147483656L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483656L, "AddresseeSeq", "1");
insertTable2(it2, 2147483656L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483656L, "CommunicationOrderId", "21868");
insertTable2(it2, 2147483656L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483656L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483656L, "SortPlan", "");
insertTable2(it2, 2147483656L, "Enveloping", "N");
insertTable2(it2, 2147483656L, "PostComponentId", "21858");
insertTable2(it2, 2147483656L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483656L, "city", "Bruxelles");
insertTable2(it2, 2147483656L, "AddressG7", "");
insertTable2(it2, 2147483656L, "CopyMention", "");
insertTable2(it2, 2147483656L, "AddressG8", "");
insertTable2(it2, 2147483656L, "StapleNbr", "");
insertTable2(it2, 2147483656L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483656L, "AddressG5", "");
insertTable2(it2, 2147483656L, "header", "true");
insertTable2(it2, 2147483656L, "EnvelopSortingValue", "BE1180___testOlivier002-0004___________Boulevard du Souverain, 23____");
insertTable2(it2, 2147483656L, "GroupedWith", "");
insertTable2(it2, 2147483656L, "AddressG2", "Boulevard du Souverain, 23");
insertTable2(it2, 2147483656L, "DiversionReason", "001");
insertTable2(it2, 2147483656L, "Pliable", "true");
insertTable2(it2, 2147483656L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483656L, "country", "BE");
insertTable2(it2, 2147483656L, "AddressG1", "testOlivier002-0004");
insertTable2(it2, 2147483656L, "MentionCode", "");
insertTable2(it2, 2147483656L, "postCode", "1180");
insertTable2(it2, 2147483656L, "SC5", "=");
insertTable2(it2, 2147483656L, "Branding", "1C");
insertTable1(it1, 2147483657L);
insertTable2(it2, 2147483657L, "SC2", "=");
insertTable2(it2, 2147483657L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483657L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483657L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483657L, "DocumentSortingValues", "______21859__1__1");
insertTable2(it2, 2147483657L, "ItemSeq", "1");
insertTable2(it2, 2147483657L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483657L, "Plex", "S");
insertTable2(it2, 2147483657L, "SC3", "=");
insertTable2(it2, 2147483657L, "has_address", "true");
insertTable2(it2, 2147483657L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483657L, "Language", "FR");
insertTable2(it2, 2147483657L, "logo", "false");
insertTable2(it2, 2147483657L, "SC4", "=");
insertTable2(it2, 2147483657L, "InternalAddress", "");
insertTable2(it2, 2147483657L, "AddressG6", "");
insertTable2(it2, 2147483657L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483657L, "AddresseeSeq", "1");
insertTable2(it2, 2147483657L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483657L, "CommunicationOrderId", "21869");
insertTable2(it2, 2147483657L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483657L, "location", "rue du broker");
insertTable2(it2, 2147483657L, "SortPlan", "");
insertTable2(it2, 2147483657L, "Enveloping", "C");
insertTable2(it2, 2147483657L, "PostComponentId", "21859");
insertTable2(it2, 2147483657L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483657L, "city", "Broker ville");
insertTable2(it2, 2147483657L, "AddressG7", "");
insertTable2(it2, 2147483657L, "CopyMention", "");
insertTable2(it2, 2147483657L, "AddressG8", "");
insertTable2(it2, 2147483657L, "StapleNbr", "");
insertTable2(it2, 2147483657L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483657L, "AddressG5", "");
insertTable2(it2, 2147483657L, "header", "true");
insertTable2(it2, 2147483657L, "EnvelopSortingValue", "BE1000___testOlivier003-0005___________rue du broker_________________");
insertTable2(it2, 2147483657L, "GroupedWith", "");
insertTable2(it2, 2147483657L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483657L, "DiversionReason", "");
insertTable2(it2, 2147483657L, "Pliable", "true");
insertTable2(it2, 2147483657L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483657L, "country", "BE");
insertTable2(it2, 2147483657L, "AddressG1", "testOlivier003-0005");
insertTable2(it2, 2147483657L, "MentionCode", "");
insertTable2(it2, 2147483657L, "postCode", "1000");
insertTable2(it2, 2147483657L, "SC5", "=");
insertTable2(it2, 2147483657L, "Branding", "1C");
insertTable1(it1, 2147483658L);
insertTable2(it2, 2147483658L, "SC2", "=");
insertTable2(it2, 2147483658L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483658L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483658L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483658L, "DocumentSortingValues", "______21859__1__1");
insertTable2(it2, 2147483658L, "ItemSeq", "1");
insertTable2(it2, 2147483658L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483658L, "Plex", "S");
insertTable2(it2, 2147483658L, "SC3", "=");
insertTable2(it2, 2147483658L, "has_address", "true");
insertTable2(it2, 2147483658L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483658L, "Language", "FR");
insertTable2(it2, 2147483658L, "logo", "false");
insertTable2(it2, 2147483658L, "SC4", "=");
insertTable2(it2, 2147483658L, "InternalAddress", "");
insertTable2(it2, 2147483658L, "AddressG6", "");
insertTable2(it2, 2147483658L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483658L, "AddresseeSeq", "1");
insertTable2(it2, 2147483658L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483658L, "CommunicationOrderId", "21869");
insertTable2(it2, 2147483658L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483658L, "location", "rue du broker");
insertTable2(it2, 2147483658L, "SortPlan", "");
insertTable2(it2, 2147483658L, "Enveloping", "C");
insertTable2(it2, 2147483658L, "PostComponentId", "21859");
insertTable2(it2, 2147483658L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483658L, "city", "Broker ville");
insertTable2(it2, 2147483658L, "AddressG7", "");
insertTable2(it2, 2147483658L, "CopyMention", "");
insertTable2(it2, 2147483658L, "AddressG8", "");
insertTable2(it2, 2147483658L, "StapleNbr", "");
insertTable2(it2, 2147483658L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483658L, "AddressG5", "");
insertTable2(it2, 2147483658L, "header", "true");
insertTable2(it2, 2147483658L, "EnvelopSortingValue", "BE1000___testOlivier003-0005___________rue dubroker_________________");
insertTable2(it2, 2147483658L, "GroupedWith", "");
insertTable2(it2, 2147483658L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483658L, "DiversionReason", "");
insertTable2(it2, 2147483658L, "Pliable", "true");
insertTable2(it2, 2147483658L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483658L, "country", "BE");
insertTable2(it2, 2147483658L, "AddressG1", "testOlivier003-0005");
insertTable2(it2, 2147483658L, "MentionCode", "");
insertTable2(it2, 2147483658L, "postCode", "1000");
insertTable2(it2, 2147483658L, "SC5", "=");
insertTable2(it2, 2147483658L, "Branding", "1C");
insertTable1(it1, 2147483659L);
insertTable2(it2, 2147483659L, "SC2", "=");
insertTable2(it2, 2147483659L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483659L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483659L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483659L, "DocumentSortingValues", "______21860__1__1");
insertTable2(it2, 2147483659L, "ItemSeq", "1");
insertTable2(it2, 2147483659L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483659L, "Plex", "S");
insertTable2(it2, 2147483659L, "SC3", "=");
insertTable2(it2, 2147483659L, "has_address", "true");
insertTable2(it2, 2147483659L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483659L, "Language", "FR");
insertTable2(it2, 2147483659L, "logo", "false");
insertTable2(it2, 2147483659L, "SC4", "=");
insertTable2(it2, 2147483659L, "InternalAddress", "");
insertTable2(it2, 2147483659L, "AddressG6", "");
insertTable2(it2, 2147483659L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483659L, "AddresseeSeq", "1");
insertTable2(it2, 2147483659L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483659L, "CommunicationOrderId", "21870");
insertTable2(it2, 2147483659L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483659L, "location", "rue du broker");
insertTable2(it2, 2147483659L, "SortPlan", "");
insertTable2(it2, 2147483659L, "Enveloping", "C");
insertTable2(it2, 2147483659L, "PostComponentId", "21860");
insertTable2(it2, 2147483659L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483659L, "city", "Broker ville");
insertTable2(it2, 2147483659L, "AddressG7", "");
insertTable2(it2, 2147483659L, "CopyMention", "");
insertTable2(it2, 2147483659L, "AddressG8", "");
insertTable2(it2, 2147483659L, "StapleNbr", "");
insertTable2(it2, 2147483659L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483659L, "AddressG5", "");
insertTable2(it2, 2147483659L, "header", "true");
insertTable2(it2, 2147483659L, "EnvelopSortingValue", "BE1000___testOlivier003-0006___________rue du broker_________________");
insertTable2(it2, 2147483659L, "GroupedWith", "");
insertTable2(it2, 2147483659L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483659L, "DiversionReason", "");
insertTable2(it2, 2147483659L, "Pliable", "true");
insertTable2(it2, 2147483659L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483659L, "country", "BE");
insertTable2(it2, 2147483659L, "AddressG1", "testOlivier003-0006");
insertTable2(it2, 2147483659L, "MentionCode", "");
insertTable2(it2, 2147483659L, "postCode", "1000");
insertTable2(it2, 2147483659L, "SC5", "=");
insertTable2(it2, 2147483659L, "Branding", "1C");
insertTable1(it1, 2147483660L);
insertTable2(it2, 2147483660L, "SC2", "=");
insertTable2(it2, 2147483660L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483660L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483660L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483660L, "DocumentSortingValues", "______21860__1__1");
insertTable2(it2, 2147483660L, "ItemSeq", "1");
insertTable2(it2, 2147483660L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483660L, "Plex", "S");
insertTable2(it2, 2147483660L, "SC3", "=");
insertTable2(it2, 2147483660L, "has_address", "true");
insertTable2(it2, 2147483660L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483660L, "Language", "FR");
insertTable2(it2, 2147483660L, "logo", "false");
insertTable2(it2, 2147483660L, "SC4", "=");
insertTable2(it2, 2147483660L, "InternalAddress", "");
insertTable2(it2, 2147483660L, "AddressG6", "");
insertTable2(it2, 2147483660L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483660L, "AddresseeSeq", "1");
insertTable2(it2, 2147483660L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483660L, "CommunicationOrderId", "21870");
insertTable2(it2, 2147483660L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483660L, "location", "rue du broker");
insertTable2(it2, 2147483660L, "SortPlan", "");
insertTable2(it2, 2147483660L, "Enveloping", "C");
insertTable2(it2, 2147483660L, "PostComponentId", "21860");
insertTable2(it2, 2147483660L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483660L, "city", "Broker ville");
insertTable2(it2, 2147483660L, "AddressG7", "");
insertTable2(it2, 2147483660L, "CopyMention", "");
insertTable2(it2, 2147483660L, "AddressG8", "");
insertTable2(it2, 2147483660L, "StapleNbr", "");
insertTable2(it2, 2147483660L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483660L, "AddressG5", "");
insertTable2(it2, 2147483660L, "header", "true");
insertTable2(it2, 2147483660L, "EnvelopSortingValue", "BE1000___testOlivier003-0006___________rue dubroker_________________");
insertTable2(it2, 2147483660L, "GroupedWith", "");
insertTable2(it2, 2147483660L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483660L, "DiversionReason", "");
insertTable2(it2, 2147483660L, "Pliable", "true");
insertTable2(it2, 2147483660L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483660L, "country", "BE");
insertTable2(it2, 2147483660L, "AddressG1", "testOlivier003-0006");
insertTable2(it2, 2147483660L, "MentionCode", "");
insertTable2(it2, 2147483660L, "postCode", "1000");
insertTable2(it2, 2147483660L, "SC5", "=");
insertTable2(it2, 2147483660L, "Branding", "1C");
insertTable1(it1, 2147483661L);
insertTable2(it2, 2147483661L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483661L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483661L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483661L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483661L, "DocumentSortingValues", "______21861__1__1");
insertTable2(it2, 2147483661L, "ItemSeq", "1");
insertTable2(it2, 2147483661L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483661L, "Plex", "S");
insertTable2(it2, 2147483661L, "SC3", "=");
insertTable2(it2, 2147483661L, "has_address", "true");
insertTable2(it2, 2147483661L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483661L, "Language", "FR");
insertTable2(it2, 2147483661L, "logo", "false");
insertTable2(it2, 2147483661L, "SC4", "=");
insertTable2(it2, 2147483661L, "InternalAddress", "");
insertTable2(it2, 2147483661L, "AddressG6", "");
insertTable2(it2, 2147483661L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483661L, "AddresseeSeq", "1");
insertTable2(it2, 2147483661L, "SC1", "Country=BE");
insertTable2(it2, 2147483661L, "CommunicationOrderId", "21871");
insertTable2(it2, 2147483661L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483661L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483661L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483661L, "Enveloping", "C");
insertTable2(it2, 2147483661L, "PostComponentId", "21861");
insertTable2(it2, 2147483661L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483661L, "city", "Bruxelles");
insertTable2(it2, 2147483661L, "AddressG7", "");
insertTable2(it2, 2147483661L, "CopyMention", "");
insertTable2(it2, 2147483661L, "AddressG8", "");
insertTable2(it2, 2147483661L, "StapleNbr", "");
insertTable2(it2, 2147483661L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483661L, "AddressG5", "");
insertTable2(it2, 2147483661L, "header", "true");
insertTable2(it2, 2147483661L, "EnvelopSortingValue", "BE1180___testOlivier004-0007___________Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483661L, "GroupedWith", "");
insertTable2(it2, 2147483661L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483661L, "DiversionReason", "");
insertTable2(it2, 2147483661L, "Pliable", "true");
insertTable2(it2, 2147483661L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483661L, "country", "BE");
insertTable2(it2, 2147483661L, "AddressG1", "testOlivier004-0007");
insertTable2(it2, 2147483661L, "MentionCode", "");
insertTable2(it2, 2147483661L, "postCode", "1180");
insertTable2(it2, 2147483661L, "SC5", "=");
insertTable2(it2, 2147483661L, "Branding", "1C");
insertTable1(it1, 2147483662L);
insertTable2(it2, 2147483662L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483662L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483662L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483662L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483662L, "DocumentSortingValues", "______21861__1__1");
insertTable2(it2, 2147483662L, "ItemSeq", "1");
insertTable2(it2, 2147483662L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483662L, "Plex", "S");
insertTable2(it2, 2147483662L, "SC3", "=");
insertTable2(it2, 2147483662L, "has_address", "true");
insertTable2(it2, 2147483662L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483662L, "Language", "FR");
insertTable2(it2, 2147483662L, "logo", "false");
insertTable2(it2, 2147483662L, "SC4", "=");
insertTable2(it2, 2147483662L, "InternalAddress", "");
insertTable2(it2, 2147483662L, "AddressG6", "");
insertTable2(it2, 2147483662L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483662L, "AddresseeSeq", "1");
insertTable2(it2, 2147483662L, "SC1", "Country=BE");
insertTable2(it2, 2147483662L, "CommunicationOrderId", "21871");
insertTable2(it2, 2147483662L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483662L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483662L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483662L, "Enveloping", "C");
insertTable2(it2, 2147483662L, "PostComponentId", "21861");
insertTable2(it2, 2147483662L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483662L, "city", "Bruxelles");
insertTable2(it2, 2147483662L, "AddressG7", "");
insertTable2(it2, 2147483662L, "CopyMention", "");
insertTable2(it2, 2147483662L, "AddressG8", "");
insertTable2(it2, 2147483662L, "StapleNbr", "");
insertTable2(it2, 2147483662L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483662L, "AddressG5", "");
insertTable2(it2, 2147483662L, "header", "true");
insertTable2(it2, 2147483662L, "EnvelopSortingValue", "BE1180___testOlivier004-0007___________Boulevard du Souverain, 23____");
insertTable2(it2, 2147483662L, "GroupedWith", "");
insertTable2(it2, 2147483662L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483662L, "DiversionReason", "");
insertTable2(it2, 2147483662L, "Pliable", "true");
insertTable2(it2, 2147483662L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483662L, "country", "BE");
insertTable2(it2, 2147483662L, "AddressG1", "testOlivier004-0007");
insertTable2(it2, 2147483662L, "MentionCode", "");
insertTable2(it2, 2147483662L, "postCode", "1180");
insertTable2(it2, 2147483662L, "SC5", "=");
insertTable2(it2, 2147483662L, "Branding", "1C");
insertTable1(it1, 2147483663L);
insertTable2(it2, 2147483663L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483663L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483663L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483663L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483663L, "DocumentSortingValues", "______21862__1__1");
insertTable2(it2, 2147483663L, "ItemSeq", "1");
insertTable2(it2, 2147483663L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483663L, "Plex", "S");
insertTable2(it2, 2147483663L, "SC3", "=");
insertTable2(it2, 2147483663L, "has_address", "true");
insertTable2(it2, 2147483663L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483663L, "Language", "FR");
insertTable2(it2, 2147483663L, "logo", "false");
insertTable2(it2, 2147483663L, "SC4", "=");
insertTable2(it2, 2147483663L, "InternalAddress", "");
insertTable2(it2, 2147483663L, "AddressG6", "");
insertTable2(it2, 2147483663L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483663L, "AddresseeSeq", "1");
insertTable2(it2, 2147483663L, "SC1", "Country=BE");
insertTable2(it2, 2147483663L, "CommunicationOrderId", "21872");
insertTable2(it2, 2147483663L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483663L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483663L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483663L, "Enveloping", "C");
insertTable2(it2, 2147483663L, "PostComponentId", "21862");
insertTable2(it2, 2147483663L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483663L, "city", "Bruxelles");
insertTable2(it2, 2147483663L, "AddressG7", "");
insertTable2(it2, 2147483663L, "CopyMention", "");
insertTable2(it2, 2147483663L, "AddressG8", "");
insertTable2(it2, 2147483663L, "StapleNbr", "");
insertTable2(it2, 2147483663L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483663L, "AddressG5", "");
insertTable2(it2, 2147483663L, "header", "true");
insertTable2(it2, 2147483663L, "EnvelopSortingValue", "BE1180___testOlivier004-0008___________Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483663L, "GroupedWith", "");
insertTable2(it2, 2147483663L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483663L, "DiversionReason", "");
insertTable2(it2, 2147483663L, "Pliable", "true");
insertTable2(it2, 2147483663L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483663L, "country", "BE");
insertTable2(it2, 2147483663L, "AddressG1", "testOlivier004-0008");
insertTable2(it2, 2147483663L, "MentionCode", "");
insertTable2(it2, 2147483663L, "postCode", "1180");
insertTable2(it2, 2147483663L, "SC5", "=");
insertTable2(it2, 2147483663L, "Branding", "1C");
insertTable1(it1, 2147483664L);
insertTable2(it2, 2147483664L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483664L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483664L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483664L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483664L, "DocumentSortingValues", "______21862__1__1");
insertTable2(it2, 2147483664L, "ItemSeq", "1");
insertTable2(it2, 2147483664L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483664L, "Plex", "S");
insertTable2(it2, 2147483664L, "SC3", "=");
insertTable2(it2, 2147483664L, "has_address", "true");
insertTable2(it2, 2147483664L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483664L, "Language", "FR");
insertTable2(it2, 2147483664L, "logo", "false");
insertTable2(it2, 2147483664L, "SC4", "=");
insertTable2(it2, 2147483664L, "InternalAddress", "");
insertTable2(it2, 2147483664L, "AddressG6", "");
insertTable2(it2, 2147483664L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483664L, "AddresseeSeq", "1");
insertTable2(it2, 2147483664L, "SC1", "Country=BE");
insertTable2(it2, 2147483664L, "CommunicationOrderId", "21872");
insertTable2(it2, 2147483664L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483664L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483664L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483664L, "Enveloping", "C");
insertTable2(it2, 2147483664L, "PostComponentId", "21862");
insertTable2(it2, 2147483664L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483664L, "city", "Bruxelles");
insertTable2(it2, 2147483664L, "AddressG7", "");
insertTable2(it2, 2147483664L, "CopyMention", "");
insertTable2(it2, 2147483664L, "AddressG8", "");
insertTable2(it2, 2147483664L, "StapleNbr", "");
insertTable2(it2, 2147483664L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483664L, "AddressG5", "");
insertTable2(it2, 2147483664L, "header", "true");
insertTable2(it2, 2147483664L, "EnvelopSortingValue", "BE1180___testOlivier004-0008___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483664L, "GroupedWith", "");
insertTable2(it2, 2147483664L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483664L, "DiversionReason", "");
insertTable2(it2, 2147483664L, "Pliable", "true");
insertTable2(it2, 2147483664L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483664L, "country", "BE");
insertTable2(it2, 2147483664L, "AddressG1", "testOlivier004-0008");
insertTable2(it2, 2147483664L, "MentionCode", "");
insertTable2(it2, 2147483664L, "postCode", "1180");
insertTable2(it2, 2147483664L, "SC5", "=");
insertTable2(it2, 2147483664L, "Branding", "1C");
insertTable1(it1, 2147483665L);
insertTable2(it2, 2147483665L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483665L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483665L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483665L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483665L, "DocumentSortingValues", "______21863__1__1");
insertTable2(it2, 2147483665L, "ItemSeq", "1");
insertTable2(it2, 2147483665L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483665L, "Plex", "S");
insertTable2(it2, 2147483665L, "SC3", "=");
insertTable2(it2, 2147483665L, "has_address", "true");
insertTable2(it2, 2147483665L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483665L, "Language", "FR");
insertTable2(it2, 2147483665L, "logo", "false");
insertTable2(it2, 2147483665L, "SC4", "=");
insertTable2(it2, 2147483665L, "InternalAddress", "233/621");
insertTable2(it2, 2147483665L, "AddressG6", "");
insertTable2(it2, 2147483665L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483665L, "AddresseeSeq", "1");
insertTable2(it2, 2147483665L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483665L, "CommunicationOrderId", "21873");
insertTable2(it2, 2147483665L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483665L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483665L, "SortPlan", "");
insertTable2(it2, 2147483665L, "Enveloping", "N");
insertTable2(it2, 2147483665L, "PostComponentId", "21863");
insertTable2(it2, 2147483665L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483665L, "city", "Bruxelles");
insertTable2(it2, 2147483665L, "AddressG7", "");
insertTable2(it2, 2147483665L, "CopyMention", "");
insertTable2(it2, 2147483665L, "AddressG8", "");
insertTable2(it2, 2147483665L, "StapleNbr", "");
insertTable2(it2, 2147483665L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483665L, "AddressG5", "");
insertTable2(it2, 2147483665L, "header", "true");
insertTable2(it2, 2147483665L, "EnvelopSortingValue", "BE1180___testOlivier005-0009___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483665L, "GroupedWith", "");
insertTable2(it2, 2147483665L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483665L, "DiversionReason", "001");
insertTable2(it2, 2147483665L, "Pliable", "true");
insertTable2(it2, 2147483665L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483665L, "country", "BE");
insertTable2(it2, 2147483665L, "AddressG1", "testOlivier005-0009");
insertTable2(it2, 2147483665L, "MentionCode", "");
insertTable2(it2, 2147483665L, "postCode", "1180");
insertTable2(it2, 2147483665L, "SC5", "=");
insertTable2(it2, 2147483665L, "Branding", "1C");
insertTable1(it1, 2147483666L);
insertTable2(it2, 2147483666L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483666L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483666L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483666L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483666L, "DocumentSortingValues", "______21863__1__1");
insertTable2(it2, 2147483666L, "ItemSeq", "1");
insertTable2(it2, 2147483666L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483666L, "Plex", "S");
insertTable2(it2, 2147483666L, "SC3", "=");
insertTable2(it2, 2147483666L, "has_address", "true");
insertTable2(it2, 2147483666L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483666L, "Language", "FR");
insertTable2(it2, 2147483666L, "logo", "false");
insertTable2(it2, 2147483666L, "SC4", "=");
insertTable2(it2, 2147483666L, "InternalAddress", "233/621");
insertTable2(it2, 2147483666L, "AddressG6", "");
insertTable2(it2, 2147483666L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483666L, "AddresseeSeq", "1");
insertTable2(it2, 2147483666L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483666L, "CommunicationOrderId", "21873");
insertTable2(it2, 2147483666L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483666L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483666L, "SortPlan", "");
insertTable2(it2, 2147483666L, "Enveloping", "N");
insertTable2(it2, 2147483666L, "PostComponentId", "21863");
insertTable2(it2, 2147483666L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483666L, "city", "Bruxelles");
insertTable2(it2, 2147483666L, "AddressG7", "");
insertTable2(it2, 2147483666L, "CopyMention", "");
insertTable2(it2, 2147483666L, "AddressG8", "");
insertTable2(it2, 2147483666L, "StapleNbr", "");
insertTable2(it2, 2147483666L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483666L, "AddressG5", "");
insertTable2(it2, 2147483666L, "header", "true");
insertTable2(it2, 2147483666L, "EnvelopSortingValue", "BE1180___testOlivier005-0009___________Boulevard du Souverain, 23____");
insertTable2(it2, 2147483666L, "GroupedWith", "");
insertTable2(it2, 2147483666L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483666L, "DiversionReason", "001");
insertTable2(it2, 2147483666L, "Pliable", "true");
insertTable2(it2, 2147483666L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483666L, "country", "BE");
insertTable2(it2, 2147483666L, "AddressG1", "testOlivier005-0009");
insertTable2(it2, 2147483666L, "MentionCode", "");
insertTable2(it2, 2147483666L, "postCode", "1180");
insertTable2(it2, 2147483666L, "SC5", "=");
insertTable2(it2, 2147483666L, "Branding", "1C");
insertTable1(it1, 2147483667L);
insertTable2(it2, 2147483667L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483667L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483667L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483667L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483667L, "DocumentSortingValues", "______21864__1__1");
insertTable2(it2, 2147483667L, "ItemSeq", "1");
insertTable2(it2, 2147483667L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483667L, "Plex", "S");
insertTable2(it2, 2147483667L, "SC3", "=");
insertTable2(it2, 2147483667L, "has_address", "true");
insertTable2(it2, 2147483667L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483667L, "Language", "FR");
insertTable2(it2, 2147483667L, "logo", "false");
insertTable2(it2, 2147483667L, "SC4", "=");
insertTable2(it2, 2147483667L, "InternalAddress", "233/621");
insertTable2(it2, 2147483667L, "AddressG6", "");
insertTable2(it2, 2147483667L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483667L, "AddresseeSeq", "1");
insertTable2(it2, 2147483667L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483667L, "CommunicationOrderId", "21874");
insertTable2(it2, 2147483667L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483667L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483667L, "SortPlan", "");
insertTable2(it2, 2147483667L, "Enveloping", "N");
insertTable2(it2, 2147483667L, "PostComponentId", "21864");
insertTable2(it2, 2147483667L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483667L, "city", "Bruxelles");
insertTable2(it2, 2147483667L, "AddressG7", "");
insertTable2(it2, 2147483667L, "CopyMention", "");
insertTable2(it2, 2147483667L, "AddressG8", "");
insertTable2(it2, 2147483667L, "StapleNbr", "");
insertTable2(it2, 2147483667L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483667L, "AddressG5", "");
insertTable2(it2, 2147483667L, "header", "true");
insertTable2(it2, 2147483667L, "EnvelopSortingValue", "BE1180___testOlivier005-0010___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483667L, "GroupedWith", "");
insertTable2(it2, 2147483667L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483667L, "DiversionReason", "001");
insertTable2(it2, 2147483667L, "Pliable", "true");
insertTable2(it2, 2147483667L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483667L, "country", "BE");
insertTable2(it2, 2147483667L, "AddressG1", "testOlivier005-0010");
insertTable2(it2, 2147483667L, "MentionCode", "");
insertTable2(it2, 2147483667L, "postCode", "1180");
insertTable2(it2, 2147483667L, "SC5", "=");
insertTable2(it2, 2147483667L, "Branding", "1C");
insertTable1(it1, 2147483668L);
insertTable2(it2, 2147483668L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483668L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483668L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483668L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483668L, "DocumentSortingValues", "______21864__1__1");
insertTable2(it2, 2147483668L, "ItemSeq", "1");
insertTable2(it2, 2147483668L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483668L, "Plex", "S");
insertTable2(it2, 2147483668L, "SC3", "=");
insertTable2(it2, 2147483668L, "has_address", "true");
insertTable2(it2, 2147483668L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483668L, "Language", "FR");
insertTable2(it2, 2147483668L, "logo", "false");
insertTable2(it2, 2147483668L, "SC4", "=");
insertTable2(it2, 2147483668L, "InternalAddress", "233/621");
insertTable2(it2, 2147483668L, "AddressG6", "");
insertTable2(it2, 2147483668L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483668L, "AddresseeSeq", "1");
insertTable2(it2, 2147483668L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483668L, "CommunicationOrderId", "21874");
insertTable2(it2, 2147483668L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483668L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483668L, "SortPlan", "");
insertTable2(it2, 2147483668L, "Enveloping", "N");
insertTable2(it2, 2147483668L, "PostComponentId", "21864");
insertTable2(it2, 2147483668L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483668L, "city", "Bruxelles");
insertTable2(it2, 2147483668L, "AddressG7", "");
insertTable2(it2, 2147483668L, "CopyMention", "");
insertTable2(it2, 2147483668L, "AddressG8", "");
insertTable2(it2, 2147483668L, "StapleNbr", "");
insertTable2(it2, 2147483668L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483668L, "AddressG5", "");
insertTable2(it2, 2147483668L, "header", "true");
insertTable2(it2, 2147483668L, "EnvelopSortingValue", "BE1180___testOlivier005-0010___________Boulevard du Souverain, 23____");
insertTable2(it2, 2147483668L, "GroupedWith", "");
insertTable2(it2, 2147483668L, "AddressG2", "Boulevard du Souverain, 23");
insertTable2(it2, 2147483668L, "DiversionReason", "001");
insertTable2(it2, 2147483668L, "Pliable", "true");
insertTable2(it2, 2147483668L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483668L, "country", "BE");
insertTable2(it2, 2147483668L, "AddressG1", "testOlivier005-0010");
insertTable2(it2, 2147483668L, "MentionCode", "");
insertTable2(it2, 2147483668L, "postCode", "1180");
insertTable2(it2, 2147483668L, "SC5", "=");
insertTable2(it2, 2147483668L, "Branding", "1C");
insertTable1(it1, 2147483669L);
insertTable2(it2, 2147483669L, "SC2", "=");
insertTable2(it2, 2147483669L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483669L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483669L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483669L, "DocumentSortingValues", "______21865__1__1");
insertTable2(it2, 2147483669L, "ItemSeq", "1");
insertTable2(it2, 2147483669L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483669L, "Plex", "S");
insertTable2(it2, 2147483669L, "SC3", "=");
insertTable2(it2, 2147483669L, "has_address", "true");
insertTable2(it2, 2147483669L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483669L, "Language", "FR");
insertTable2(it2, 2147483669L, "logo", "false");
insertTable2(it2, 2147483669L, "SC4", "=");
insertTable2(it2, 2147483669L, "InternalAddress", "");
insertTable2(it2, 2147483669L, "AddressG6", "");
insertTable2(it2, 2147483669L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483669L, "AddresseeSeq", "1");
insertTable2(it2, 2147483669L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483669L, "CommunicationOrderId", "21875");
insertTable2(it2, 2147483669L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483669L, "location", "rue du broker");
insertTable2(it2, 2147483669L, "SortPlan", "");
insertTable2(it2, 2147483669L, "Enveloping", "C");
insertTable2(it2, 2147483669L, "PostComponentId", "21865");
insertTable2(it2, 2147483669L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483669L, "city", "Broker ville");
insertTable2(it2, 2147483669L, "AddressG7", "");
insertTable2(it2, 2147483669L, "CopyMention", "");
insertTable2(it2, 2147483669L, "AddressG8", "");
insertTable2(it2, 2147483669L, "StapleNbr", "");
insertTable2(it2, 2147483669L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483669L, "AddressG5", "");
insertTable2(it2, 2147483669L, "header", "true");
insertTable2(it2, 2147483669L, "EnvelopSortingValue", "BE1000___testOlivier006-0011___________rue du broker_________________");
insertTable2(it2, 2147483669L, "GroupedWith", "");
insertTable2(it2, 2147483669L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483669L, "DiversionReason", "");
insertTable2(it2, 2147483669L, "Pliable", "true");
insertTable2(it2, 2147483669L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483669L, "country", "BE");
insertTable2(it2, 2147483669L, "AddressG1", "testOlivier006-0011");
insertTable2(it2, 2147483669L, "MentionCode", "");
insertTable2(it2, 2147483669L, "postCode", "1000");
insertTable2(it2, 2147483669L, "SC5", "=");
insertTable2(it2, 2147483669L, "Branding", "1C");
insertTable1(it1, 2147483670L);
insertTable2(it2, 2147483670L, "SC2", "=");
insertTable2(it2, 2147483670L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483670L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483670L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483670L, "DocumentSortingValues", "______21865__1__1");
insertTable2(it2, 2147483670L, "ItemSeq", "1");
insertTable2(it2, 2147483670L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483670L, "Plex", "S");
insertTable2(it2, 2147483670L, "SC3", "=");
insertTable2(it2, 2147483670L, "has_address", "true");
insertTable2(it2, 2147483670L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483670L, "Language", "FR");
insertTable2(it2, 2147483670L, "logo", "false");
insertTable2(it2, 2147483670L, "SC4", "=");
insertTable2(it2, 2147483670L, "InternalAddress", "");
insertTable2(it2, 2147483670L, "AddressG6", "");
insertTable2(it2, 2147483670L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483670L, "AddresseeSeq", "1");
insertTable2(it2, 2147483670L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483670L, "CommunicationOrderId", "21875");
insertTable2(it2, 2147483670L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483670L, "location", "rue du broker");
insertTable2(it2, 2147483670L, "SortPlan", "");
insertTable2(it2, 2147483670L, "Enveloping", "C");
insertTable2(it2, 2147483670L, "PostComponentId", "21865");
insertTable2(it2, 2147483670L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483670L, "city", "Broker ville");
insertTable2(it2, 2147483670L, "AddressG7", "");
insertTable2(it2, 2147483670L, "CopyMention", "");
insertTable2(it2, 2147483670L, "AddressG8", "");
insertTable2(it2, 2147483670L, "StapleNbr", "");
insertTable2(it2, 2147483670L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483670L, "AddressG5", "");
insertTable2(it2, 2147483670L, "header", "true");
insertTable2(it2, 2147483670L, "EnvelopSortingValue", "BE1000___testOlivier006-0011___________rue dubroker_________________");
insertTable2(it2, 2147483670L, "GroupedWith", "");
insertTable2(it2, 2147483670L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483670L, "DiversionReason", "");
insertTable2(it2, 2147483670L, "Pliable", "true");
insertTable2(it2, 2147483670L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483670L, "country", "BE");
insertTable2(it2, 2147483670L, "AddressG1", "testOlivier006-0011");
insertTable2(it2, 2147483670L, "MentionCode", "");
insertTable2(it2, 2147483670L, "postCode", "1000");
insertTable2(it2, 2147483670L, "SC5", "=");
insertTable2(it2, 2147483670L, "Branding", "1C");
insertTable1(it1, 2147483671L);
insertTable2(it2, 2147483671L, "SC2", "=");
insertTable2(it2, 2147483671L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483671L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483671L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483671L, "DocumentSortingValues", "______21866__1__1");
insertTable2(it2, 2147483671L, "ItemSeq", "1");
insertTable2(it2, 2147483671L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483671L, "Plex", "S");
insertTable2(it2, 2147483671L, "SC3", "=");
insertTable2(it2, 2147483671L, "has_address", "true");
insertTable2(it2, 2147483671L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483671L, "Language", "FR");
insertTable2(it2, 2147483671L, "logo", "false");
insertTable2(it2, 2147483671L, "SC4", "=");
insertTable2(it2, 2147483671L, "InternalAddress", "");
insertTable2(it2, 2147483671L, "AddressG6", "");
insertTable2(it2, 2147483671L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483671L, "AddresseeSeq", "1");
insertTable2(it2, 2147483671L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483671L, "CommunicationOrderId", "21876");
insertTable2(it2, 2147483671L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483671L, "location", "rue du broker");
insertTable2(it2, 2147483671L, "SortPlan", "");
insertTable2(it2, 2147483671L, "Enveloping", "C");
insertTable2(it2, 2147483671L, "PostComponentId", "21866");
insertTable2(it2, 2147483671L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483671L, "city", "Broker ville");
insertTable2(it2, 2147483671L, "AddressG7", "");
insertTable2(it2, 2147483671L, "CopyMention", "");
insertTable2(it2, 2147483671L, "AddressG8", "");
insertTable2(it2, 2147483671L, "StapleNbr", "");
insertTable2(it2, 2147483671L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483671L, "AddressG5", "");
insertTable2(it2, 2147483671L, "header", "true");
insertTable2(it2, 2147483671L, "EnvelopSortingValue", "BE1000___testOlivier006-0012___________rue du broker_________________");
insertTable2(it2, 2147483671L, "GroupedWith", "");
insertTable2(it2, 2147483671L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483671L, "DiversionReason", "");
insertTable2(it2, 2147483671L, "Pliable", "true");
insertTable2(it2, 2147483671L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483671L, "country", "BE");
insertTable2(it2, 2147483671L, "AddressG1", "testOlivier006-0012");
insertTable2(it2, 2147483671L, "MentionCode", "");
insertTable2(it2, 2147483671L, "postCode", "1000");
insertTable2(it2, 2147483671L, "SC5", "=");
insertTable2(it2, 2147483671L, "Branding", "1C");
insertTable1(it1, 2147483672L);
insertTable2(it2, 2147483672L, "SC2", "=");
insertTable2(it2, 2147483672L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483672L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483672L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483672L, "DocumentSortingValues", "______21866__1__1");
insertTable2(it2, 2147483672L, "ItemSeq", "1");
insertTable2(it2, 2147483672L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483672L, "Plex", "S");
insertTable2(it2, 2147483672L, "SC3", "=");
insertTable2(it2, 2147483672L, "has_address", "true");
insertTable2(it2, 2147483672L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483672L, "Language", "FR");
insertTable2(it2, 2147483672L, "logo", "false");
insertTable2(it2, 2147483672L, "SC4", "=");
insertTable2(it2, 2147483672L, "InternalAddress", "");
insertTable2(it2, 2147483672L, "AddressG6", "");
insertTable2(it2, 2147483672L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483672L, "AddresseeSeq", "1");
insertTable2(it2, 2147483672L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483672L, "CommunicationOrderId", "21876");
insertTable2(it2, 2147483672L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483672L, "location", "rue du broker");
insertTable2(it2, 2147483672L, "SortPlan", "");
insertTable2(it2, 2147483672L, "Enveloping", "C");
insertTable2(it2, 2147483672L, "PostComponentId", "21866");
insertTable2(it2, 2147483672L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483672L, "city", "Broker ville");
insertTable2(it2, 2147483672L, "AddressG7", "");
insertTable2(it2, 2147483672L, "CopyMention", "");
insertTable2(it2, 2147483672L, "AddressG8", "");
insertTable2(it2, 2147483672L, "StapleNbr", "");
insertTable2(it2, 2147483672L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483672L, "AddressG5", "");
insertTable2(it2, 2147483672L, "header", "true");
insertTable2(it2, 2147483672L, "EnvelopSortingValue", "BE1000___testOlivier006-0012___________rue dubroker_________________");
insertTable2(it2, 2147483672L, "GroupedWith", "");
insertTable2(it2, 2147483672L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483672L, "DiversionReason", "");
insertTable2(it2, 2147483672L, "Pliable", "true");
insertTable2(it2, 2147483672L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483672L, "country", "BE");
insertTable2(it2, 2147483672L, "AddressG1", "testOlivier006-0012");
insertTable2(it2, 2147483672L, "MentionCode", "");
insertTable2(it2, 2147483672L, "postCode", "1000");
insertTable2(it2, 2147483672L, "SC5", "=");
insertTable2(it2, 2147483672L, "Branding", "1C");
insertTable1(it1, 2147483673L);
insertTable2(it2, 2147483673L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483673L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483673L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483673L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483673L, "DocumentSortingValues", "______21867__1__1");
insertTable2(it2, 2147483673L, "ItemSeq", "1");
insertTable2(it2, 2147483673L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483673L, "Plex", "S");
insertTable2(it2, 2147483673L, "SC3", "=");
insertTable2(it2, 2147483673L, "has_address", "true");
insertTable2(it2, 2147483673L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483673L, "Language", "FR");
insertTable2(it2, 2147483673L, "logo", "false");
insertTable2(it2, 2147483673L, "SC4", "=");
insertTable2(it2, 2147483673L, "InternalAddress", "");
insertTable2(it2, 2147483673L, "AddressG6", "");
insertTable2(it2, 2147483673L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483673L, "AddresseeSeq", "1");
insertTable2(it2, 2147483673L, "SC1", "Country=BE");
insertTable2(it2, 2147483673L, "CommunicationOrderId", "21877");
insertTable2(it2, 2147483673L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483673L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483673L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483673L, "Enveloping", "C");
insertTable2(it2, 2147483673L, "PostComponentId", "21867");
insertTable2(it2, 2147483673L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483673L, "city", "Bruxelles");
insertTable2(it2, 2147483673L, "AddressG7", "");
insertTable2(it2, 2147483673L, "CopyMention", "");
insertTable2(it2, 2147483673L, "AddressG8", "");
insertTable2(it2, 2147483673L, "StapleNbr", "");
insertTable2(it2, 2147483673L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483673L, "AddressG5", "");
insertTable2(it2, 2147483673L, "header", "true");
insertTable2(it2, 2147483673L, "EnvelopSortingValue", "BE1180___testOlivier007-0013___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483673L, "GroupedWith", "");
insertTable2(it2, 2147483673L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483673L, "DiversionReason", "");
insertTable2(it2, 2147483673L, "Pliable", "true");
insertTable2(it2, 2147483673L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483673L, "country", "BE");
insertTable2(it2, 2147483673L, "AddressG1", "testOlivier007-0013");
insertTable2(it2, 2147483673L, "MentionCode", "");
insertTable2(it2, 2147483673L, "postCode", "1180");
insertTable2(it2, 2147483673L, "SC5", "=");
insertTable2(it2, 2147483673L, "Branding", "1C");
insertTable1(it1, 2147483674L);
insertTable2(it2, 2147483674L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483674L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483674L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483674L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483674L, "DocumentSortingValues", "______21867__1__1");
insertTable2(it2, 2147483674L, "ItemSeq", "1");
insertTable2(it2, 2147483674L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483674L, "Plex", "S");
insertTable2(it2, 2147483674L, "SC3", "=");
insertTable2(it2, 2147483674L, "has_address", "true");
insertTable2(it2, 2147483674L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483674L, "Language", "FR");
insertTable2(it2, 2147483674L, "logo", "false");
insertTable2(it2, 2147483674L, "SC4", "=");
insertTable2(it2, 2147483674L, "InternalAddress", "");
insertTable2(it2, 2147483674L, "AddressG6", "");
insertTable2(it2, 2147483674L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483674L, "AddresseeSeq", "1");
insertTable2(it2, 2147483674L, "SC1", "Country=BE");
insertTable2(it2, 2147483674L, "CommunicationOrderId", "21877");
insertTable2(it2, 2147483674L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483674L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483674L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483674L, "Enveloping", "C");
insertTable2(it2, 2147483674L, "PostComponentId", "21867");
insertTable2(it2, 2147483674L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483674L, "city", "Bruxelles");
insertTable2(it2, 2147483674L, "AddressG7", "");
insertTable2(it2, 2147483674L, "CopyMention", "");
insertTable2(it2, 2147483674L, "AddressG8", "");
insertTable2(it2, 2147483674L, "StapleNbr", "");
insertTable2(it2, 2147483674L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483674L, "AddressG5", "");
insertTable2(it2, 2147483674L, "header", "true");
insertTable2(it2, 2147483674L, "EnvelopSortingValue", "BE1180___testOlivier007-0013___________Boulevard du Souverain, 23____");
insertTable2(it2, 2147483674L, "GroupedWith", "");
insertTable2(it2, 2147483674L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483674L, "DiversionReason", "");
insertTable2(it2, 2147483674L, "Pliable", "true");
insertTable2(it2, 2147483674L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483674L, "country", "BE");
insertTable2(it2, 2147483674L, "AddressG1", "testOlivier007-0013");
insertTable2(it2, 2147483674L, "MentionCode", "");
insertTable2(it2, 2147483674L, "postCode", "1180");
insertTable2(it2, 2147483674L, "SC5", "=");
insertTable2(it2, 2147483674L, "Branding", "1C");
insertTable1(it1, 2147483675L);
insertTable2(it2, 2147483675L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483675L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483675L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483675L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483675L, "DocumentSortingValues", "______21868__1__1");
insertTable2(it2, 2147483675L, "ItemSeq", "1");
insertTable2(it2, 2147483675L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483675L, "Plex", "S");
insertTable2(it2, 2147483675L, "SC3", "=");
insertTable2(it2, 2147483675L, "has_address", "true");
insertTable2(it2, 2147483675L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483675L, "Language", "FR");
insertTable2(it2, 2147483675L, "logo", "false");
insertTable2(it2, 2147483675L, "SC4", "=");
insertTable2(it2, 2147483675L, "InternalAddress", "");
insertTable2(it2, 2147483675L, "AddressG6", "");
insertTable2(it2, 2147483675L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483675L, "AddresseeSeq", "1");
insertTable2(it2, 2147483675L, "SC1", "Country=BE");
insertTable2(it2, 2147483675L, "CommunicationOrderId", "21878");
insertTable2(it2, 2147483675L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483675L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483675L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483675L, "Enveloping", "C");
insertTable2(it2, 2147483675L, "PostComponentId", "21868");
insertTable2(it2, 2147483675L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483675L, "city", "Bruxelles");
insertTable2(it2, 2147483675L, "AddressG7", "");
insertTable2(it2, 2147483675L, "CopyMention", "");
insertTable2(it2, 2147483675L, "AddressG8", "");
insertTable2(it2, 2147483675L, "StapleNbr", "");
insertTable2(it2, 2147483675L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483675L, "AddressG5", "");
insertTable2(it2, 2147483675L, "header", "true");
insertTable2(it2, 2147483675L, "EnvelopSortingValue", "BE1180___testOlivier007-0014___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483675L, "GroupedWith", "");
insertTable2(it2, 2147483675L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483675L, "DiversionReason", "");
insertTable2(it2, 2147483675L, "Pliable", "true");
insertTable2(it2, 2147483675L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483675L, "country", "BE");
insertTable2(it2, 2147483675L, "AddressG1", "testOlivier007-0014");
insertTable2(it2, 2147483675L, "MentionCode", "");
insertTable2(it2, 2147483675L, "postCode", "1180");
insertTable2(it2, 2147483675L, "SC5", "=");
insertTable2(it2, 2147483675L, "Branding", "1C");
insertTable1(it1, 2147483676L);
insertTable2(it2, 2147483676L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483676L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483676L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483676L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483676L, "DocumentSortingValues", "______21868__1__1");
insertTable2(it2, 2147483676L, "ItemSeq", "1");
insertTable2(it2, 2147483676L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483676L, "Plex", "S");
insertTable2(it2, 2147483676L, "SC3", "=");
insertTable2(it2, 2147483676L, "has_address", "true");
insertTable2(it2, 2147483676L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483676L, "Language", "FR");
insertTable2(it2, 2147483676L, "logo", "false");
insertTable2(it2, 2147483676L, "SC4", "=");
insertTable2(it2, 2147483676L, "InternalAddress", "");
insertTable2(it2, 2147483676L, "AddressG6", "");
insertTable2(it2, 2147483676L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483676L, "AddresseeSeq", "1");
insertTable2(it2, 2147483676L, "SC1", "Country=BE");
insertTable2(it2, 2147483676L, "CommunicationOrderId", "21878");
insertTable2(it2, 2147483676L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483676L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483676L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483676L, "Enveloping", "C");
insertTable2(it2, 2147483676L, "PostComponentId", "21868");
insertTable2(it2, 2147483676L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483676L, "city", "Bruxelles");
insertTable2(it2, 2147483676L, "AddressG7", "");
insertTable2(it2, 2147483676L, "CopyMention", "");
insertTable2(it2, 2147483676L, "AddressG8", "");
insertTable2(it2, 2147483676L, "StapleNbr", "");
insertTable2(it2, 2147483676L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483676L, "AddressG5", "");
insertTable2(it2, 2147483676L, "header", "true");
insertTable2(it2, 2147483676L, "EnvelopSortingValue", "BE1180___testOlivier007-0014___________Boulevard du Souverain, 23____");
insertTable2(it2, 2147483676L, "GroupedWith", "");
insertTable2(it2, 2147483676L, "AddressG2", "Boulevard du Souverain, 23");
insertTable2(it2, 2147483676L, "DiversionReason", "");
insertTable2(it2, 2147483676L, "Pliable", "true");
insertTable2(it2, 2147483676L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483676L, "country", "BE");
insertTable2(it2, 2147483676L, "AddressG1", "testOlivier007-0014");
insertTable2(it2, 2147483676L, "MentionCode", "");
insertTable2(it2, 2147483676L, "postCode", "1180");
insertTable2(it2, 2147483676L, "SC5", "=");
insertTable2(it2, 2147483676L, "Branding", "1C");
insertTable1(it1, 2147483677L);
insertTable2(it2, 2147483677L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483677L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483677L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483677L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483677L, "DocumentSortingValues", "______21869__1__1");
insertTable2(it2, 2147483677L, "ItemSeq", "1");
insertTable2(it2, 2147483677L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483677L, "Plex", "S");
insertTable2(it2, 2147483677L, "SC3", "=");
insertTable2(it2, 2147483677L, "has_address", "true");
insertTable2(it2, 2147483677L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483677L, "Language", "FR");
insertTable2(it2, 2147483677L, "logo", "false");
insertTable2(it2, 2147483677L, "SC4", "=");
insertTable2(it2, 2147483677L, "InternalAddress", "233/621");
insertTable2(it2, 2147483677L, "AddressG6", "");
insertTable2(it2, 2147483677L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483677L, "AddresseeSeq", "1");
insertTable2(it2, 2147483677L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483677L, "CommunicationOrderId", "21879");
insertTable2(it2, 2147483677L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483677L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483677L, "SortPlan", "");
insertTable2(it2, 2147483677L, "Enveloping", "N");
insertTable2(it2, 2147483677L, "PostComponentId", "21869");
insertTable2(it2, 2147483677L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483677L, "city", "Bruxelles");
insertTable2(it2, 2147483677L, "AddressG7", "");
insertTable2(it2, 2147483677L, "CopyMention", "");
insertTable2(it2, 2147483677L, "AddressG8", "");
insertTable2(it2, 2147483677L, "StapleNbr", "");
insertTable2(it2, 2147483677L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483677L, "AddressG5", "");
insertTable2(it2, 2147483677L, "header", "true");
insertTable2(it2, 2147483677L, "EnvelopSortingValue", "BE1180___testOlivier008-0015___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483677L, "GroupedWith", "");
insertTable2(it2, 2147483677L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483677L, "DiversionReason", "001");
insertTable2(it2, 2147483677L, "Pliable", "true");
insertTable2(it2, 2147483677L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483677L, "country", "BE");
insertTable2(it2, 2147483677L, "AddressG1", "testOlivier008-0015");
insertTable2(it2, 2147483677L, "MentionCode", "");
insertTable2(it2, 2147483677L, "postCode", "1180");
insertTable2(it2, 2147483677L, "SC5", "=");
insertTable2(it2, 2147483677L, "Branding", "1C");
insertTable1(it1, 2147483678L);
insertTable2(it2, 2147483678L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483678L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483678L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483678L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483678L, "DocumentSortingValues", "______21869__1__1");
insertTable2(it2, 2147483678L, "ItemSeq", "1");
insertTable2(it2, 2147483678L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483678L, "Plex", "S");
insertTable2(it2, 2147483678L, "SC3", "=");
insertTable2(it2, 2147483678L, "has_address", "true");
insertTable2(it2, 2147483678L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483678L, "Language", "FR");
insertTable2(it2, 2147483678L, "logo", "false");
insertTable2(it2, 2147483678L, "SC4", "=");
insertTable2(it2, 2147483678L, "InternalAddress", "233/621");
insertTable2(it2, 2147483678L, "AddressG6", "");
insertTable2(it2, 2147483678L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483678L, "AddresseeSeq", "1");
insertTable2(it2, 2147483678L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483678L, "CommunicationOrderId", "21879");
insertTable2(it2, 2147483678L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483678L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483678L, "SortPlan", "");
insertTable2(it2, 2147483678L, "Enveloping", "N");
insertTable2(it2, 2147483678L, "PostComponentId", "21869");
insertTable2(it2, 2147483678L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483678L, "city", "Bruxelles");
insertTable2(it2, 2147483678L, "AddressG7", "");
insertTable2(it2, 2147483678L, "CopyMention", "");
insertTable2(it2, 2147483678L, "AddressG8", "");
insertTable2(it2, 2147483678L, "StapleNbr", "");
insertTable2(it2, 2147483678L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483678L, "AddressG5", "");
insertTable2(it2, 2147483678L, "header", "true");
insertTable2(it2, 2147483678L, "EnvelopSortingValue", "BE1180___testOlivier008-0015___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483678L, "GroupedWith", "");
insertTable2(it2, 2147483678L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483678L, "DiversionReason", "001");
insertTable2(it2, 2147483678L, "Pliable", "true");
insertTable2(it2, 2147483678L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483678L, "country", "BE");
insertTable2(it2, 2147483678L, "AddressG1", "testOlivier008-0015");
insertTable2(it2, 2147483678L, "MentionCode", "");
insertTable2(it2, 2147483678L, "postCode", "1180");
insertTable2(it2, 2147483678L, "SC5", "=");
insertTable2(it2, 2147483678L, "Branding", "1C");
insertTable1(it1, 2147483679L);
insertTable2(it2, 2147483679L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483679L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483679L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483679L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483679L, "DocumentSortingValues", "______21870__1__1");
insertTable2(it2, 2147483679L, "ItemSeq", "1");
insertTable2(it2, 2147483679L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483679L, "Plex", "S");
insertTable2(it2, 2147483679L, "SC3", "=");
insertTable2(it2, 2147483679L, "has_address", "true");
insertTable2(it2, 2147483679L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483679L, "Language", "FR");
insertTable2(it2, 2147483679L, "logo", "false");
insertTable2(it2, 2147483679L, "SC4", "=");
insertTable2(it2, 2147483679L, "InternalAddress", "233/621");
insertTable2(it2, 2147483679L, "AddressG6", "");
insertTable2(it2, 2147483679L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483679L, "AddresseeSeq", "1");
insertTable2(it2, 2147483679L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483679L, "CommunicationOrderId", "21880");
insertTable2(it2, 2147483679L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483679L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483679L, "SortPlan", "");
insertTable2(it2, 2147483679L, "Enveloping", "N");
insertTable2(it2, 2147483679L, "PostComponentId", "21870");
insertTable2(it2, 2147483679L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483679L, "city", "Bruxelles");
insertTable2(it2, 2147483679L, "AddressG7", "");
insertTable2(it2, 2147483679L, "CopyMention", "");
insertTable2(it2, 2147483679L, "AddressG8", "");
insertTable2(it2, 2147483679L, "StapleNbr", "");
insertTable2(it2, 2147483679L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483679L, "AddressG5", "");
insertTable2(it2, 2147483679L, "header", "true");
insertTable2(it2, 2147483679L, "EnvelopSortingValue", "BE1180___testOlivier008-0016___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483679L, "GroupedWith", "");
insertTable2(it2, 2147483679L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483679L, "DiversionReason", "001");
insertTable2(it2, 2147483679L, "Pliable", "true");
insertTable2(it2, 2147483679L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483679L, "country", "BE");
insertTable2(it2, 2147483679L, "AddressG1", "testOlivier008-0016");
insertTable2(it2, 2147483679L, "MentionCode", "");
insertTable2(it2, 2147483679L, "postCode", "1180");
insertTable2(it2, 2147483679L, "SC5", "=");
insertTable2(it2, 2147483679L, "Branding", "1C");
insertTable1(it1, 2147483680L);
insertTable2(it2, 2147483680L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483680L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483680L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483680L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483680L, "DocumentSortingValues", "______21870__1__1");
insertTable2(it2, 2147483680L, "ItemSeq", "1");
insertTable2(it2, 2147483680L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483680L, "Plex", "S");
insertTable2(it2, 2147483680L, "SC3", "=");
insertTable2(it2, 2147483680L, "has_address", "true");
insertTable2(it2, 2147483680L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483680L, "Language", "FR");
insertTable2(it2, 2147483680L, "logo", "false");
insertTable2(it2, 2147483680L, "SC4", "=");
insertTable2(it2, 2147483680L, "InternalAddress", "233/621");
insertTable2(it2, 2147483680L, "AddressG6", "");
insertTable2(it2, 2147483680L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483680L, "AddresseeSeq", "1");
insertTable2(it2, 2147483680L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483680L, "CommunicationOrderId", "21880");
insertTable2(it2, 2147483680L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483680L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483680L, "SortPlan", "");
insertTable2(it2, 2147483680L, "Enveloping", "N");
insertTable2(it2, 2147483680L, "PostComponentId", "21870");
insertTable2(it2, 2147483680L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483680L, "city", "Bruxelles");
insertTable2(it2, 2147483680L, "AddressG7", "");
insertTable2(it2, 2147483680L, "CopyMention", "");
insertTable2(it2, 2147483680L, "AddressG8", "");
insertTable2(it2, 2147483680L, "StapleNbr", "");
insertTable2(it2, 2147483680L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483680L, "AddressG5", "");
insertTable2(it2, 2147483680L, "header", "true");
insertTable2(it2, 2147483680L, "EnvelopSortingValue", "BE1180___testOlivier008-0016___________Boulevard du Souverain, 23____");
insertTable2(it2, 2147483680L, "GroupedWith", "");
insertTable2(it2, 2147483680L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483680L, "DiversionReason", "001");
insertTable2(it2, 2147483680L, "Pliable", "true");
insertTable2(it2, 2147483680L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483680L, "country", "BE");
insertTable2(it2, 2147483680L, "AddressG1", "testOlivier008-0016");
insertTable2(it2, 2147483680L, "MentionCode", "");
insertTable2(it2, 2147483680L, "postCode", "1180");
insertTable2(it2, 2147483680L, "SC5", "=");
insertTable2(it2, 2147483680L, "Branding", "1C");
insertTable1(it1, 2147483681L);
insertTable2(it2, 2147483681L, "SC2", "=");
insertTable2(it2, 2147483681L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483681L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483681L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483681L, "DocumentSortingValues", "______21871__1__1");
insertTable2(it2, 2147483681L, "ItemSeq", "1");
insertTable2(it2, 2147483681L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483681L, "Plex", "S");
insertTable2(it2, 2147483681L, "SC3", "=");
insertTable2(it2, 2147483681L, "has_address", "true");
insertTable2(it2, 2147483681L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483681L, "Language", "FR");
insertTable2(it2, 2147483681L, "logo", "false");
insertTable2(it2, 2147483681L, "SC4", "=");
insertTable2(it2, 2147483681L, "InternalAddress", "");
insertTable2(it2, 2147483681L, "AddressG6", "");
insertTable2(it2, 2147483681L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483681L, "AddresseeSeq", "1");
insertTable2(it2, 2147483681L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483681L, "CommunicationOrderId", "21881");
insertTable2(it2, 2147483681L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483681L, "location", "rue du broker");
insertTable2(it2, 2147483681L, "SortPlan", "");
insertTable2(it2, 2147483681L, "Enveloping", "C");
insertTable2(it2, 2147483681L, "PostComponentId", "21871");
insertTable2(it2, 2147483681L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483681L, "city", "Broker ville");
insertTable2(it2, 2147483681L, "AddressG7", "");
insertTable2(it2, 2147483681L, "CopyMention", "");
insertTable2(it2, 2147483681L, "AddressG8", "");
insertTable2(it2, 2147483681L, "StapleNbr", "");
insertTable2(it2, 2147483681L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483681L, "AddressG5", "");
insertTable2(it2, 2147483681L, "header", "true");
insertTable2(it2, 2147483681L, "EnvelopSortingValue", "BE1000___testOlivier009-0017___________rue du broker_________________");
insertTable2(it2, 2147483681L, "GroupedWith", "");
insertTable2(it2, 2147483681L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483681L, "DiversionReason", "");
insertTable2(it2, 2147483681L, "Pliable", "true");
insertTable2(it2, 2147483681L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483681L, "country", "BE");
insertTable2(it2, 2147483681L, "AddressG1", "testOlivier009-0017");
insertTable2(it2, 2147483681L, "MentionCode", "");
insertTable2(it2, 2147483681L, "postCode", "1000");
insertTable2(it2, 2147483681L, "SC5", "=");
insertTable2(it2, 2147483681L, "Branding", "1C");
insertTable1(it1, 2147483682L);
insertTable2(it2, 2147483682L, "SC2", "=");
insertTable2(it2, 2147483682L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483682L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483682L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483682L, "DocumentSortingValues", "______21871__1__1");
insertTable2(it2, 2147483682L, "ItemSeq", "1");
insertTable2(it2, 2147483682L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483682L, "Plex", "S");
insertTable2(it2, 2147483682L, "SC3", "=");
insertTable2(it2, 2147483682L, "has_address", "true");
insertTable2(it2, 2147483682L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483682L, "Language", "FR");
insertTable2(it2, 2147483682L, "logo", "false");
insertTable2(it2, 2147483682L, "SC4", "=");
insertTable2(it2, 2147483682L, "InternalAddress", "");
insertTable2(it2, 2147483682L, "AddressG6", "");
insertTable2(it2, 2147483682L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483682L, "AddresseeSeq", "1");
insertTable2(it2, 2147483682L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483682L, "CommunicationOrderId", "21881");
insertTable2(it2, 2147483682L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483682L, "location", "rue du broker");
insertTable2(it2, 2147483682L, "SortPlan", "");
insertTable2(it2, 2147483682L, "Enveloping", "C");
insertTable2(it2, 2147483682L, "PostComponentId", "21871");
insertTable2(it2, 2147483682L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483682L, "city", "Broker ville");
insertTable2(it2, 2147483682L, "AddressG7", "");
insertTable2(it2, 2147483682L, "CopyMention", "");
insertTable2(it2, 2147483682L, "AddressG8", "");
insertTable2(it2, 2147483682L, "StapleNbr", "");
insertTable2(it2, 2147483682L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483682L, "AddressG5", "");
insertTable2(it2, 2147483682L, "header", "true");
insertTable2(it2, 2147483682L, "EnvelopSortingValue", "BE1000___testOlivier009-0017___________rue dubroker_________________");
insertTable2(it2, 2147483682L, "GroupedWith", "");
insertTable2(it2, 2147483682L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483682L, "DiversionReason", "");
insertTable2(it2, 2147483682L, "Pliable", "true");
insertTable2(it2, 2147483682L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483682L, "country", "BE");
insertTable2(it2, 2147483682L, "AddressG1", "testOlivier009-0017");
insertTable2(it2, 2147483682L, "MentionCode", "");
insertTable2(it2, 2147483682L, "postCode", "1000");
insertTable2(it2, 2147483682L, "SC5", "=");
insertTable2(it2, 2147483682L, "Branding", "1C");
insertTable1(it1, 2147483683L);
insertTable2(it2, 2147483683L, "SC2", "=");
insertTable2(it2, 2147483683L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483683L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483683L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483683L, "DocumentSortingValues", "______21872__1__1");
insertTable2(it2, 2147483683L, "ItemSeq", "1");
insertTable2(it2, 2147483683L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483683L, "Plex", "S");
insertTable2(it2, 2147483683L, "SC3", "=");
insertTable2(it2, 2147483683L, "has_address", "true");
insertTable2(it2, 2147483683L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483683L, "Language", "FR");
insertTable2(it2, 2147483683L, "logo", "false");
insertTable2(it2, 2147483683L, "SC4", "=");
insertTable2(it2, 2147483683L, "InternalAddress", "");
insertTable2(it2, 2147483683L, "AddressG6", "");
insertTable2(it2, 2147483683L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483683L, "AddresseeSeq", "1");
insertTable2(it2, 2147483683L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483683L, "CommunicationOrderId", "21882");
insertTable2(it2, 2147483683L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483683L, "location", "rue du broker");
insertTable2(it2, 2147483683L, "SortPlan", "");
insertTable2(it2, 2147483683L, "Enveloping", "C");
insertTable2(it2, 2147483683L, "PostComponentId", "21872");
insertTable2(it2, 2147483683L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483683L, "city", "Broker ville");
insertTable2(it2, 2147483683L, "AddressG7", "");
insertTable2(it2, 2147483683L, "CopyMention", "");
insertTable2(it2, 2147483683L, "AddressG8", "");
insertTable2(it2, 2147483683L, "StapleNbr", "");
insertTable2(it2, 2147483683L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483683L, "AddressG5", "");
insertTable2(it2, 2147483683L, "header", "true");
insertTable2(it2, 2147483683L, "EnvelopSortingValue", "BE1000___testOlivier009-0018___________rue du broker_________________");
insertTable2(it2, 2147483683L, "GroupedWith", "");
insertTable2(it2, 2147483683L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483683L, "DiversionReason", "");
insertTable2(it2, 2147483683L, "Pliable", "true");
insertTable2(it2, 2147483683L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483683L, "country", "BE");
insertTable2(it2, 2147483683L, "AddressG1", "testOlivier009-0018");
insertTable2(it2, 2147483683L, "MentionCode", "");
insertTable2(it2, 2147483683L, "postCode", "1000");
insertTable2(it2, 2147483683L, "SC5", "=");
insertTable2(it2, 2147483683L, "Branding", "1C");
insertTable1(it1, 2147483684L);
insertTable2(it2, 2147483684L, "SC2", "=");
insertTable2(it2, 2147483684L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483684L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483684L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483684L, "DocumentSortingValues", "______21872__1__1");
insertTable2(it2, 2147483684L, "ItemSeq", "1");
insertTable2(it2, 2147483684L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483684L, "Plex", "S");
insertTable2(it2, 2147483684L, "SC3", "=");
insertTable2(it2, 2147483684L, "has_address", "true");
insertTable2(it2, 2147483684L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483684L, "Language", "FR");
insertTable2(it2, 2147483684L, "logo", "false");
insertTable2(it2, 2147483684L, "SC4", "=");
insertTable2(it2, 2147483684L, "InternalAddress", "");
insertTable2(it2, 2147483684L, "AddressG6", "");
insertTable2(it2, 2147483684L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483684L, "AddresseeSeq", "1");
insertTable2(it2, 2147483684L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483684L, "CommunicationOrderId", "21882");
insertTable2(it2, 2147483684L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483684L, "location", "rue du broker");
insertTable2(it2, 2147483684L, "SortPlan", "");
insertTable2(it2, 2147483684L, "Enveloping", "C");
insertTable2(it2, 2147483684L, "PostComponentId", "21872");
insertTable2(it2, 2147483684L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483684L, "city", "Broker ville");
insertTable2(it2, 2147483684L, "AddressG7", "");
insertTable2(it2, 2147483684L, "CopyMention", "");
insertTable2(it2, 2147483684L, "AddressG8", "");
insertTable2(it2, 2147483684L, "StapleNbr", "");
insertTable2(it2, 2147483684L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483684L, "AddressG5", "");
insertTable2(it2, 2147483684L, "header", "true");
insertTable2(it2, 2147483684L, "EnvelopSortingValue", "BE1000___testOlivier009-0018___________rue du broker_________________");
insertTable2(it2, 2147483684L, "GroupedWith", "");
insertTable2(it2, 2147483684L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483684L, "DiversionReason", "");
insertTable2(it2, 2147483684L, "Pliable", "true");
insertTable2(it2, 2147483684L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483684L, "country", "BE");
insertTable2(it2, 2147483684L, "AddressG1", "testOlivier009-0018");
insertTable2(it2, 2147483684L, "MentionCode", "");
insertTable2(it2, 2147483684L, "postCode", "1000");
insertTable2(it2, 2147483684L, "SC5", "=");
insertTable2(it2, 2147483684L, "Branding", "1C");
insertTable1(it1, 2147483685L);
insertTable2(it2, 2147483685L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483685L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483685L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483685L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483685L, "DocumentSortingValues", "______21873__1__1");
insertTable2(it2, 2147483685L, "ItemSeq", "1");
insertTable2(it2, 2147483685L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483685L, "Plex", "S");
insertTable2(it2, 2147483685L, "SC3", "=");
insertTable2(it2, 2147483685L, "has_address", "true");
insertTable2(it2, 2147483685L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483685L, "Language", "FR");
insertTable2(it2, 2147483685L, "logo", "false");
insertTable2(it2, 2147483685L, "SC4", "=");
insertTable2(it2, 2147483685L, "InternalAddress", "");
insertTable2(it2, 2147483685L, "AddressG6", "");
insertTable2(it2, 2147483685L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483685L, "AddresseeSeq", "1");
insertTable2(it2, 2147483685L, "SC1", "Country=BE");
insertTable2(it2, 2147483685L, "CommunicationOrderId", "21883");
insertTable2(it2, 2147483685L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483685L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483685L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483685L, "Enveloping", "C");
insertTable2(it2, 2147483685L, "PostComponentId", "21873");
insertTable2(it2, 2147483685L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483685L, "city", "Bruxelles");
insertTable2(it2, 2147483685L, "AddressG7", "");
insertTable2(it2, 2147483685L, "CopyMention", "");
insertTable2(it2, 2147483685L, "AddressG8", "");
insertTable2(it2, 2147483685L, "StapleNbr", "");
insertTable2(it2, 2147483685L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483685L, "AddressG5", "");
insertTable2(it2, 2147483685L, "header", "true");
insertTable2(it2, 2147483685L, "EnvelopSortingValue", "BE1180___testOlivier010-0019___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483685L, "GroupedWith", "");
insertTable2(it2, 2147483685L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483685L, "DiversionReason", "");
insertTable2(it2, 2147483685L, "Pliable", "true");
insertTable2(it2, 2147483685L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483685L, "country", "BE");
insertTable2(it2, 2147483685L, "AddressG1", "testOlivier010-0019");
insertTable2(it2, 2147483685L, "MentionCode", "");
insertTable2(it2, 2147483685L, "postCode", "1180");
insertTable2(it2, 2147483685L, "SC5", "=");
insertTable2(it2, 2147483685L, "Branding", "1C");
insertTable1(it1, 2147483686L);
insertTable2(it2, 2147483686L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483686L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483686L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483686L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483686L, "DocumentSortingValues", "______21873__1__1");
insertTable2(it2, 2147483686L, "ItemSeq", "1");
insertTable2(it2, 2147483686L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483686L, "Plex", "S");
insertTable2(it2, 2147483686L, "SC3", "=");
insertTable2(it2, 2147483686L, "has_address", "true");
insertTable2(it2, 2147483686L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483686L, "Language", "FR");
insertTable2(it2, 2147483686L, "logo", "false");
insertTable2(it2, 2147483686L, "SC4", "=");
insertTable2(it2, 2147483686L, "InternalAddress", "");
insertTable2(it2, 2147483686L, "AddressG6", "");
insertTable2(it2, 2147483686L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483686L, "AddresseeSeq", "1");
insertTable2(it2, 2147483686L, "SC1", "Country=BE");
insertTable2(it2, 2147483686L, "CommunicationOrderId", "21883");
insertTable2(it2, 2147483686L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483686L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483686L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483686L, "Enveloping", "C");
insertTable2(it2, 2147483686L, "PostComponentId", "21873");
insertTable2(it2, 2147483686L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483686L, "city", "Bruxelles");
insertTable2(it2, 2147483686L, "AddressG7", "");
insertTable2(it2, 2147483686L, "CopyMention", "");
insertTable2(it2, 2147483686L, "AddressG8", "");
insertTable2(it2, 2147483686L, "StapleNbr", "");
insertTable2(it2, 2147483686L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483686L, "AddressG5", "");
insertTable2(it2, 2147483686L, "header", "true");
insertTable2(it2, 2147483686L, "EnvelopSortingValue", "BE1180___testOlivier010-0019___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483686L, "GroupedWith", "");
insertTable2(it2, 2147483686L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483686L, "DiversionReason", "");
insertTable2(it2, 2147483686L, "Pliable", "true");
insertTable2(it2, 2147483686L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483686L, "country", "BE");
insertTable2(it2, 2147483686L, "AddressG1", "testOlivier010-0019");
insertTable2(it2, 2147483686L, "MentionCode", "");
insertTable2(it2, 2147483686L, "postCode", "1180");
insertTable2(it2, 2147483686L, "SC5", "=");
insertTable2(it2, 2147483686L, "Branding", "1C");
insertTable1(it1, 2147483687L);
insertTable2(it2, 2147483687L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483687L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483687L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483687L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483687L, "DocumentSortingValues", "______21874__1__1");
insertTable2(it2, 2147483687L, "ItemSeq", "1");
insertTable2(it2, 2147483687L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483687L, "Plex", "S");
insertTable2(it2, 2147483687L, "SC3", "=");
insertTable2(it2, 2147483687L, "has_address", "true");
insertTable2(it2, 2147483687L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483687L, "Language", "FR");
insertTable2(it2, 2147483687L, "logo", "false");
insertTable2(it2, 2147483687L, "SC4", "=");
insertTable2(it2, 2147483687L, "InternalAddress", "");
insertTable2(it2, 2147483687L, "AddressG6", "");
insertTable2(it2, 2147483687L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483687L, "AddresseeSeq", "1");
insertTable2(it2, 2147483687L, "SC1", "Country=BE");
insertTable2(it2, 2147483687L, "CommunicationOrderId", "21884");
insertTable2(it2, 2147483687L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483687L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483687L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483687L, "Enveloping", "C");
insertTable2(it2, 2147483687L, "PostComponentId", "21874");
insertTable2(it2, 2147483687L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483687L, "city", "Bruxelles");
insertTable2(it2, 2147483687L, "AddressG7", "");
insertTable2(it2, 2147483687L, "CopyMention", "");
insertTable2(it2, 2147483687L, "AddressG8", "");
insertTable2(it2, 2147483687L, "StapleNbr", "");
insertTable2(it2, 2147483687L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483687L, "AddressG5", "");
insertTable2(it2, 2147483687L, "header", "true");
insertTable2(it2, 2147483687L, "EnvelopSortingValue", "BE1180___testOlivier010-0020___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483687L, "GroupedWith", "");
insertTable2(it2, 2147483687L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483687L, "DiversionReason", "");
insertTable2(it2, 2147483687L, "Pliable", "true");
insertTable2(it2, 2147483687L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483687L, "country", "BE");
insertTable2(it2, 2147483687L, "AddressG1", "testOlivier010-0020");
insertTable2(it2, 2147483687L, "MentionCode", "");
insertTable2(it2, 2147483687L, "postCode", "1180");
insertTable2(it2, 2147483687L, "SC5", "=");
insertTable2(it2, 2147483687L, "Branding", "1C");
insertTable1(it1, 2147483688L);
insertTable2(it2, 2147483688L, "SC2", "LaPosteSortPlan=B-W3-S2");
insertTable2(it2, 2147483688L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483688L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483688L, "AddressG3", "1180, Bruxelles");
insertTable2(it2, 2147483688L, "DocumentSortingValues", "______21874__1__1");
insertTable2(it2, 2147483688L, "ItemSeq", "1");
insertTable2(it2, 2147483688L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483688L, "Plex", "S");
insertTable2(it2, 2147483688L, "SC3", "=");
insertTable2(it2, 2147483688L, "has_address", "true");
insertTable2(it2, 2147483688L, "SubBatchSortingValue", "BE_B-W3-S2___");
insertTable2(it2, 2147483688L, "Language", "FR");
insertTable2(it2, 2147483688L, "logo", "false");
insertTable2(it2, 2147483688L, "SC4", "=");
insertTable2(it2, 2147483688L, "InternalAddress", "");
insertTable2(it2, 2147483688L, "AddressG6", "");
insertTable2(it2, 2147483688L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483688L, "AddresseeSeq", "1");
insertTable2(it2, 2147483688L, "SC1", "Country=BE");
insertTable2(it2, 2147483688L, "CommunicationOrderId", "21884");
insertTable2(it2, 2147483688L, "BatchTypeId", "Paper");
insertTable2(it2, 2147483688L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483688L, "SortPlan", "B-W3-S2");
insertTable2(it2, 2147483688L, "Enveloping", "C");
insertTable2(it2, 2147483688L, "PostComponentId", "21874");
insertTable2(it2, 2147483688L, "BatchTypeLabel", "Paper");
insertTable2(it2, 2147483688L, "city", "Bruxelles");
insertTable2(it2, 2147483688L, "AddressG7", "");
insertTable2(it2, 2147483688L, "CopyMention", "");
insertTable2(it2, 2147483688L, "AddressG8", "");
insertTable2(it2, 2147483688L, "StapleNbr", "");
insertTable2(it2, 2147483688L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483688L, "AddressG5", "");
insertTable2(it2, 2147483688L, "header", "true");
insertTable2(it2, 2147483688L, "EnvelopSortingValue", "BE1180___testOlivier010-0020___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483688L, "GroupedWith", "");
insertTable2(it2, 2147483688L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483688L, "DiversionReason", "");
insertTable2(it2, 2147483688L, "Pliable", "true");
insertTable2(it2, 2147483688L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483688L, "country", "BE");
insertTable2(it2, 2147483688L, "AddressG1", "testOlivier010-0020");
insertTable2(it2, 2147483688L, "MentionCode", "");
insertTable2(it2, 2147483688L, "postCode", "1180");
insertTable2(it2, 2147483688L, "SC5", "=");
insertTable2(it2, 2147483688L, "Branding", "1C");
insertTable1(it1, 2147483689L);
insertTable2(it2, 2147483689L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483689L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483689L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483689L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483689L, "DocumentSortingValues", "______21875__1__1");
insertTable2(it2, 2147483689L, "ItemSeq", "1");
insertTable2(it2, 2147483689L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483689L, "Plex", "S");
insertTable2(it2, 2147483689L, "SC3", "=");
insertTable2(it2, 2147483689L, "has_address", "true");
insertTable2(it2, 2147483689L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483689L, "Language", "FR");
insertTable2(it2, 2147483689L, "logo", "false");
insertTable2(it2, 2147483689L, "SC4", "=");
insertTable2(it2, 2147483689L, "InternalAddress", "233/621");
insertTable2(it2, 2147483689L, "AddressG6", "");
insertTable2(it2, 2147483689L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483689L, "AddresseeSeq", "1");
insertTable2(it2, 2147483689L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483689L, "CommunicationOrderId", "21885");
insertTable2(it2, 2147483689L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483689L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483689L, "SortPlan", "");
insertTable2(it2, 2147483689L, "Enveloping", "N");
insertTable2(it2, 2147483689L, "PostComponentId", "21875");
insertTable2(it2, 2147483689L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483689L, "city", "Bruxelles");
insertTable2(it2, 2147483689L, "AddressG7", "");
insertTable2(it2, 2147483689L, "CopyMention", "");
insertTable2(it2, 2147483689L, "AddressG8", "");
insertTable2(it2, 2147483689L, "StapleNbr", "");
insertTable2(it2, 2147483689L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483689L, "AddressG5", "");
insertTable2(it2, 2147483689L, "header", "true");
insertTable2(it2, 2147483689L, "EnvelopSortingValue", "BE1180___testOlivier011-0021___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483689L, "GroupedWith", "");
insertTable2(it2, 2147483689L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483689L, "DiversionReason", "001");
insertTable2(it2, 2147483689L, "Pliable", "true");
insertTable2(it2, 2147483689L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483689L, "country", "BE");
insertTable2(it2, 2147483689L, "AddressG1", "testOlivier011-0021");
insertTable2(it2, 2147483689L, "MentionCode", "");
insertTable2(it2, 2147483689L, "postCode", "1180");
insertTable2(it2, 2147483689L, "SC5", "=");
insertTable2(it2, 2147483689L, "Branding", "1C");
insertTable1(it1, 2147483690L);
insertTable2(it2, 2147483690L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483690L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483690L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483690L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483690L, "DocumentSortingValues", "______21875__1__1");
insertTable2(it2, 2147483690L, "ItemSeq", "1");
insertTable2(it2, 2147483690L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483690L, "Plex", "S");
insertTable2(it2, 2147483690L, "SC3", "=");
insertTable2(it2, 2147483690L, "has_address", "true");
insertTable2(it2, 2147483690L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483690L, "Language", "FR");
insertTable2(it2, 2147483690L, "logo", "false");
insertTable2(it2, 2147483690L, "SC4", "=");
insertTable2(it2, 2147483690L, "InternalAddress", "233/621");
insertTable2(it2, 2147483690L, "AddressG6", "");
insertTable2(it2, 2147483690L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483690L, "AddresseeSeq", "1");
insertTable2(it2, 2147483690L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483690L, "CommunicationOrderId", "21885");
insertTable2(it2, 2147483690L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483690L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483690L, "SortPlan", "");
insertTable2(it2, 2147483690L, "Enveloping", "N");
insertTable2(it2, 2147483690L, "PostComponentId", "21875");
insertTable2(it2, 2147483690L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483690L, "city", "Bruxelles");
insertTable2(it2, 2147483690L, "AddressG7", "");
insertTable2(it2, 2147483690L, "CopyMention", "");
insertTable2(it2, 2147483690L, "AddressG8", "");
insertTable2(it2, 2147483690L, "StapleNbr", "");
insertTable2(it2, 2147483690L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483690L, "AddressG5", "");
insertTable2(it2, 2147483690L, "header", "true");
insertTable2(it2, 2147483690L, "EnvelopSortingValue", "BE1180___testOlivier011-0021___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483690L, "GroupedWith", "");
insertTable2(it2, 2147483690L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483690L, "DiversionReason", "001");
insertTable2(it2, 2147483690L, "Pliable", "true");
insertTable2(it2, 2147483690L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483690L, "country", "BE");
insertTable2(it2, 2147483690L, "AddressG1", "testOlivier011-0021");
insertTable2(it2, 2147483690L, "MentionCode", "");
insertTable2(it2, 2147483690L, "postCode", "1180");
insertTable2(it2, 2147483690L, "SC5", "=");
insertTable2(it2, 2147483690L, "Branding", "1C");
insertTable1(it1, 2147483691L);
insertTable2(it2, 2147483691L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483691L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483691L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483691L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483691L, "DocumentSortingValues", "______21876__1__1");
insertTable2(it2, 2147483691L, "ItemSeq", "1");
insertTable2(it2, 2147483691L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483691L, "Plex", "S");
insertTable2(it2, 2147483691L, "SC3", "=");
insertTable2(it2, 2147483691L, "has_address", "true");
insertTable2(it2, 2147483691L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483691L, "Language", "FR");
insertTable2(it2, 2147483691L, "logo", "false");
insertTable2(it2, 2147483691L, "SC4", "=");
insertTable2(it2, 2147483691L, "InternalAddress", "233/621");
insertTable2(it2, 2147483691L, "AddressG6", "");
insertTable2(it2, 2147483691L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483691L, "AddresseeSeq", "1");
insertTable2(it2, 2147483691L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483691L, "CommunicationOrderId", "21886");
insertTable2(it2, 2147483691L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483691L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483691L, "SortPlan", "");
insertTable2(it2, 2147483691L, "Enveloping", "N");
insertTable2(it2, 2147483691L, "PostComponentId", "21876");
insertTable2(it2, 2147483691L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483691L, "city", "Bruxelles");
insertTable2(it2, 2147483691L, "AddressG7", "");
insertTable2(it2, 2147483691L, "CopyMention", "");
insertTable2(it2, 2147483691L, "AddressG8", "");
insertTable2(it2, 2147483691L, "StapleNbr", "");
insertTable2(it2, 2147483691L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483691L, "AddressG5", "");
insertTable2(it2, 2147483691L, "header", "true");
insertTable2(it2, 2147483691L, "EnvelopSortingValue", "BE1180___testOlivier011-0022___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483691L, "GroupedWith", "");
insertTable2(it2, 2147483691L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483691L, "DiversionReason", "001");
insertTable2(it2, 2147483691L, "Pliable", "true");
insertTable2(it2, 2147483691L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483691L, "country", "BE");
insertTable2(it2, 2147483691L, "AddressG1", "testOlivier011-0022");
insertTable2(it2, 2147483691L, "MentionCode", "");
insertTable2(it2, 2147483691L, "postCode", "1180");
insertTable2(it2, 2147483691L, "SC5", "=");
insertTable2(it2, 2147483691L, "Branding", "1C");
insertTable1(it1, 2147483692L);
insertTable2(it2, 2147483692L, "SC2", "PostCode=1180");
insertTable2(it2, 2147483692L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483692L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483692L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 2147483692L, "DocumentSortingValues", "______21876__1__1");
insertTable2(it2, 2147483692L, "ItemSeq", "1");
insertTable2(it2, 2147483692L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 2147483692L, "Plex", "S");
insertTable2(it2, 2147483692L, "SC3", "=");
insertTable2(it2, 2147483692L, "has_address", "true");
insertTable2(it2, 2147483692L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 2147483692L, "Language", "FR");
insertTable2(it2, 2147483692L, "logo", "false");
insertTable2(it2, 2147483692L, "SC4", "=");
insertTable2(it2, 2147483692L, "InternalAddress", "233/621");
insertTable2(it2, 2147483692L, "AddressG6", "");
insertTable2(it2, 2147483692L, "InternalAddressBringer", "true");
insertTable2(it2, 2147483692L, "AddresseeSeq", "1");
insertTable2(it2, 2147483692L, "SC1", "Requester=ddch257");
insertTable2(it2, 2147483692L, "CommunicationOrderId", "21886");
insertTable2(it2, 2147483692L, "BatchTypeId", "233-621-001");
insertTable2(it2, 2147483692L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483692L, "SortPlan", "");
insertTable2(it2, 2147483692L, "Enveloping", "N");
insertTable2(it2, 2147483692L, "PostComponentId", "21876");
insertTable2(it2, 2147483692L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 2147483692L, "city", "Bruxelles");
insertTable2(it2, 2147483692L, "AddressG7", "");
insertTable2(it2, 2147483692L, "CopyMention", "");
insertTable2(it2, 2147483692L, "AddressG8", "");
insertTable2(it2, 2147483692L, "StapleNbr", "");
insertTable2(it2, 2147483692L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483692L, "AddressG5", "");
insertTable2(it2, 2147483692L, "header", "true");
insertTable2(it2, 2147483692L, "EnvelopSortingValue", "BE1180___testOlivier011-0022___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 2147483692L, "GroupedWith", "");
insertTable2(it2, 2147483692L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 2147483692L, "DiversionReason", "001");
insertTable2(it2, 2147483692L, "Pliable", "true");
insertTable2(it2, 2147483692L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483692L, "country", "BE");
insertTable2(it2, 2147483692L, "AddressG1", "testOlivier011-0022");
insertTable2(it2, 2147483692L, "MentionCode", "");
insertTable2(it2, 2147483692L, "postCode", "1180");
insertTable2(it2, 2147483692L, "SC5", "=");
insertTable2(it2, 2147483692L, "Branding", "1C");
insertTable1(it1, 2147483693L);
insertTable2(it2, 2147483693L, "SC2", "=");
insertTable2(it2, 2147483693L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483693L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483693L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483693L, "DocumentSortingValues", "______21877__1__1");
insertTable2(it2, 2147483693L, "ItemSeq", "1");
insertTable2(it2, 2147483693L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483693L, "Plex", "S");
insertTable2(it2, 2147483693L, "SC3", "=");
insertTable2(it2, 2147483693L, "has_address", "true");
insertTable2(it2, 2147483693L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483693L, "Language", "FR");
insertTable2(it2, 2147483693L, "logo", "false");
insertTable2(it2, 2147483693L, "SC4", "=");
insertTable2(it2, 2147483693L, "InternalAddress", "");
insertTable2(it2, 2147483693L, "AddressG6", "");
insertTable2(it2, 2147483693L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483693L, "AddresseeSeq", "1");
insertTable2(it2, 2147483693L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483693L, "CommunicationOrderId", "21887");
insertTable2(it2, 2147483693L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483693L, "location", "rue du broker");
insertTable2(it2, 2147483693L, "SortPlan", "");
insertTable2(it2, 2147483693L, "Enveloping", "C");
insertTable2(it2, 2147483693L, "PostComponentId", "21877");
insertTable2(it2, 2147483693L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483693L, "city", "Broker ville");
insertTable2(it2, 2147483693L, "AddressG7", "");
insertTable2(it2, 2147483693L, "CopyMention", "");
insertTable2(it2, 2147483693L, "AddressG8", "");
insertTable2(it2, 2147483693L, "StapleNbr", "");
insertTable2(it2, 2147483693L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483693L, "AddressG5", "");
insertTable2(it2, 2147483693L, "header", "true");
insertTable2(it2, 2147483693L, "EnvelopSortingValue", "BE1000___testOlivier012-0023___________rue du broker_________________");
insertTable2(it2, 2147483693L, "GroupedWith", "");
insertTable2(it2, 2147483693L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483693L, "DiversionReason", "");
insertTable2(it2, 2147483693L, "Pliable", "true");
insertTable2(it2, 2147483693L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483693L, "country", "BE");
insertTable2(it2, 2147483693L, "AddressG1", "testOlivier012-0023");
insertTable2(it2, 2147483693L, "MentionCode", "");
insertTable2(it2, 2147483693L, "postCode", "1000");
insertTable2(it2, 2147483693L, "SC5", "=");
insertTable2(it2, 2147483693L, "Branding", "1C");
insertTable1(it1, 2147483694L);
insertTable2(it2, 2147483694L, "SC2", "=");
insertTable2(it2, 2147483694L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483694L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483694L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483694L, "DocumentSortingValues", "______21877__1__1");
insertTable2(it2, 2147483694L, "ItemSeq", "1");
insertTable2(it2, 2147483694L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483694L, "Plex", "S");
insertTable2(it2, 2147483694L, "SC3", "=");
insertTable2(it2, 2147483694L, "has_address", "true");
insertTable2(it2, 2147483694L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483694L, "Language", "FR");
insertTable2(it2, 2147483694L, "logo", "false");
insertTable2(it2, 2147483694L, "SC4", "=");
insertTable2(it2, 2147483694L, "InternalAddress", "");
insertTable2(it2, 2147483694L, "AddressG6", "");
insertTable2(it2, 2147483694L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483694L, "AddresseeSeq", "1");
insertTable2(it2, 2147483694L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483694L, "CommunicationOrderId", "21887");
insertTable2(it2, 2147483694L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483694L, "location", "rue du broker");
insertTable2(it2, 2147483694L, "SortPlan", "");
insertTable2(it2, 2147483694L, "Enveloping", "C");
insertTable2(it2, 2147483694L, "PostComponentId", "21877");
insertTable2(it2, 2147483694L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483694L, "city", "Broker ville");
insertTable2(it2, 2147483694L, "AddressG7", "");
insertTable2(it2, 2147483694L, "CopyMention", "");
insertTable2(it2, 2147483694L, "AddressG8", "");
insertTable2(it2, 2147483694L, "StapleNbr", "");
insertTable2(it2, 2147483694L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483694L, "AddressG5", "");
insertTable2(it2, 2147483694L, "header", "true");
insertTable2(it2, 2147483694L, "EnvelopSortingValue", "BE1000___testOlivier012-0023___________rue du broker_________________");
insertTable2(it2, 2147483694L, "GroupedWith", "");
insertTable2(it2, 2147483694L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483694L, "DiversionReason", "");
insertTable2(it2, 2147483694L, "Pliable", "true");
insertTable2(it2, 2147483694L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483694L, "country", "BE");
insertTable2(it2, 2147483694L, "AddressG1", "testOlivier012-0023");
insertTable2(it2, 2147483694L, "MentionCode", "");
insertTable2(it2, 2147483694L, "postCode", "1000");
insertTable2(it2, 2147483694L, "SC5", "=");
insertTable2(it2, 2147483694L, "Branding", "1C");
insertTable1(it1, 2147483695L);
insertTable2(it2, 2147483695L, "SC2", "=");
insertTable2(it2, 2147483695L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483695L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483695L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483695L, "DocumentSortingValues", "______21878__1__1");
insertTable2(it2, 2147483695L, "ItemSeq", "1");
insertTable2(it2, 2147483695L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483695L, "Plex", "S");
insertTable2(it2, 2147483695L, "SC3", "=");
insertTable2(it2, 2147483695L, "has_address", "true");
insertTable2(it2, 2147483695L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483695L, "Language", "FR");
insertTable2(it2, 2147483695L, "logo", "false");
insertTable2(it2, 2147483695L, "SC4", "=");
insertTable2(it2, 2147483695L, "InternalAddress", "");
insertTable2(it2, 2147483695L, "AddressG6", "");
insertTable2(it2, 2147483695L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483695L, "AddresseeSeq", "1");
insertTable2(it2, 2147483695L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483695L, "CommunicationOrderId", "21888");
insertTable2(it2, 2147483695L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483695L, "location", "rue du broker");
insertTable2(it2, 2147483695L, "SortPlan", "");
insertTable2(it2, 2147483695L, "Enveloping", "C");
insertTable2(it2, 2147483695L, "PostComponentId", "21878");
insertTable2(it2, 2147483695L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483695L, "city", "Broker ville");
insertTable2(it2, 2147483695L, "AddressG7", "");
insertTable2(it2, 2147483695L, "CopyMention", "");
insertTable2(it2, 2147483695L, "AddressG8", "");
insertTable2(it2, 2147483695L, "StapleNbr", "");
insertTable2(it2, 2147483695L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483695L, "AddressG5", "");
insertTable2(it2, 2147483695L, "header", "true");
insertTable2(it2, 2147483695L, "EnvelopSortingValue", "BE1000___testOlivier012-0024___________rue du broker_________________");
insertTable2(it2, 2147483695L, "GroupedWith", "");
insertTable2(it2, 2147483695L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483695L, "DiversionReason", "");
insertTable2(it2, 2147483695L, "Pliable", "true");
insertTable2(it2, 2147483695L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483695L, "country", "BE");
insertTable2(it2, 2147483695L, "AddressG1", "testOlivier012-0024");
insertTable2(it2, 2147483695L, "MentionCode", "");
insertTable2(it2, 2147483695L, "postCode", "1000");
insertTable2(it2, 2147483695L, "SC5", "=");
insertTable2(it2, 2147483695L, "Branding", "1C");
insertTable1(it1, 2147483696L);
insertTable2(it2, 2147483696L, "SC2", "=");
insertTable2(it2, 2147483696L, "AddressG4", "BELGIQUE");
insertTable2(it2, 2147483696L, "IsIdenticalToDocumentAddress", "true");
insertTable2(it2, 2147483696L, "AddressG3", "Broker ville");
insertTable2(it2, 2147483696L, "DocumentSortingValues", "______21878__1__1");
insertTable2(it2, 2147483696L, "ItemSeq", "1");
insertTable2(it2, 2147483696L, "BatchTypeInstructions", "");
insertTable2(it2, 2147483696L, "Plex", "S");
insertTable2(it2, 2147483696L, "SC3", "=");
insertTable2(it2, 2147483696L, "has_address", "true");
insertTable2(it2, 2147483696L, "SubBatchSortingValue", "Une info b");
insertTable2(it2, 2147483696L, "Language", "FR");
insertTable2(it2, 2147483696L, "logo", "false");
insertTable2(it2, 2147483696L, "SC4", "=");
insertTable2(it2, 2147483696L, "InternalAddress", "");
insertTable2(it2, 2147483696L, "AddressG6", "");
insertTable2(it2, 2147483696L, "InternalAddressBringer", "false");
insertTable2(it2, 2147483696L, "AddresseeSeq", "1");
insertTable2(it2, 2147483696L, "SC1", "DeliveryInformation=Une info bidon");
insertTable2(it2, 2147483696L, "CommunicationOrderId", "21888");
insertTable2(it2, 2147483696L, "BatchTypeId", "BROKER NET");
insertTable2(it2, 2147483696L, "location", "rue du broker");
insertTable2(it2, 2147483696L, "SortPlan", "");
insertTable2(it2, 2147483696L, "Enveloping", "C");
insertTable2(it2, 2147483696L, "PostComponentId", "21878");
insertTable2(it2, 2147483696L, "BatchTypeLabel", "BROKER NET");
insertTable2(it2, 2147483696L, "city", "Broker ville");
insertTable2(it2, 2147483696L, "AddressG7", "");
insertTable2(it2, 2147483696L, "CopyMention", "");
insertTable2(it2, 2147483696L, "AddressG8", "");
insertTable2(it2, 2147483696L, "StapleNbr", "");
insertTable2(it2, 2147483696L, "TLEBundle", "Niveau2");
insertTable2(it2, 2147483696L, "AddressG5", "");
insertTable2(it2, 2147483696L, "header", "true");
insertTable2(it2, 2147483696L, "EnvelopSortingValue", "BE1000___testOlivier012-0024___________rue du broker_________________");
insertTable2(it2, 2147483696L, "GroupedWith", "");
insertTable2(it2, 2147483696L, "AddressG2", "rue du broker");
insertTable2(it2, 2147483696L, "DiversionReason", "");
insertTable2(it2, 2147483696L, "Pliable", "true");
insertTable2(it2, 2147483696L, "TLEBinder", "Niveau1");
insertTable2(it2, 2147483696L, "country", "BE");
insertTable2(it2, 2147483696L, "AddressG1", "testOlivier012-0024");
insertTable2(it2, 2147483696L, "MentionCode", "");
insertTable2(it2, 2147483696L, "postCode", "1000");
insertTable2(it2, 2147483696L, "SC5", "=");
insertTable2(it2, 2147483696L, "Branding", "1C");
insertTable2(it2, 2147483649L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483649L, "GenerationTime", "Wed Oct 22 14:12:10 CEST 2008");
insertTable2(it2, 2147483649L, "DocumentID", "21865/1/1//");
insertTable2(it2, 2147483649L, "PageSequenceId", "000001");
insertTable2(it2, 2147483649L, "PhysicalID", "No");
insertTable2(it2, 2147483649L, "Staple", "No");
updateTable2(ut2, 2147483649L);
insertTable2(it2, 2147483650L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483650L, "GenerationTime", "Wed Oct 22 14:12:10 CEST 2008");
insertTable2(it2, 2147483650L, "DocumentID", "21865/1/1//");
insertTable2(it2, 2147483650L, "PageSequenceId", "000002");
insertTable2(it2, 2147483650L, "PhysicalID", "No");
insertTable2(it2, 2147483650L, "Staple", "No");
updateTable2(ut2, 2147483650L);
insertTable2(it2, 2147483651L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483651L, "GenerationTime", "Wed Oct 22 14:12:10 CEST 2008");
insertTable2(it2, 2147483651L, "DocumentID", "21866/1/1//");
insertTable2(it2, 2147483651L, "PageSequenceId", "000001");
insertTable2(it2, 2147483651L, "PhysicalID", "No");
insertTable2(it2, 2147483651L, "Staple", "No");
updateTable2(ut2, 2147483651L);
insertTable2(it2, 2147483652L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483652L, "GenerationTime", "Wed Oct 22 14:12:10 CEST 2008");
insertTable2(it2, 2147483652L, "DocumentID", "21866/1/1//");
insertTable2(it2, 2147483652L, "PageSequenceId", "000002");
insertTable2(it2, 2147483652L, "PhysicalID", "No");
insertTable2(it2, 2147483652L, "Staple", "No");
updateTable2(ut2, 2147483652L);
insertTable1(it1, 4294967297L);
insertTable2(it2, 4294967297L, "SC2", "PostCode=1180");
insertTable2(it2, 4294967297L, "AddressG4", "BELGIQUE");
insertTable2(it2, 4294967297L, "IsIdenticalToDocumentAddress", "");
insertTable2(it2, 4294967297L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 4294967297L, "DocumentSortingValues", "");
insertTable2(it2, 4294967297L, "ItemSeq", "0");
insertTable2(it2, 4294967297L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 4294967297L, "Plex", "S");
insertTable2(it2, 4294967297L, "SC3", "=");
insertTable2(it2, 4294967297L, "has_address", "true");
insertTable2(it2, 4294967297L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 4294967297L, "Language", "FR");
insertTable2(it2, 4294967297L, "SC4", "=");
insertTable2(it2, 4294967297L, "InternalAddress", "233/621");
insertTable2(it2, 4294967297L, "AddressG6", "");
insertTable2(it2, 4294967297L, "InternalAddressBringer", "true");
insertTable2(it2, 4294967297L, "AddresseeSeq", "0");
insertTable2(it2, 4294967297L, "SC1", "Requester=ddch257");
insertTable2(it2, 4294967297L, "CommunicationOrderId", "21867");
insertTable2(it2, 4294967297L, "BatchTypeId", "233-621-001");
insertTable2(it2, 4294967297L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 4294967297L, "SortPlan", "");
insertTable2(it2, 4294967297L, "Enveloping", "N");
insertTable2(it2, 4294967297L, "PostComponentId", "21857");
insertTable2(it2, 4294967297L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 4294967297L, "city", "Bruxelles");
insertTable2(it2, 4294967297L, "AddressG7", "");
insertTable2(it2, 4294967297L, "CopyMention", "");
insertTable2(it2, 4294967297L, "StapleNbr", "NO");
insertTable2(it2, 4294967297L, "AddressG8", "");
insertTable2(it2, 4294967297L, "AddressG5", "");
insertTable2(it2, 4294967297L, "EnvelopSortingValue", "BE1180___testOlivier002-0003___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 4294967297L, "GroupedWith", "");
insertTable2(it2, 4294967297L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 4294967297L, "DiversionReason", "001");
insertTable2(it2, 4294967297L, "Pliable", "true");
insertTable2(it2, 4294967297L, "country", "BE");
insertTable2(it2, 4294967297L, "AddressG1", "testOlivier002-0003");
insertTable2(it2, 4294967297L, "MentionCode", "");
insertTable2(it2, 4294967297L, "postCode", "1180");
insertTable2(it2, 4294967297L, "SC5", "=");
insertTable2(it2, 4294967297L, "env_type", "I");
insertTable2(it2, 4294967297L, "Branding", "1C");
insertTable2(it2, 4294967297L, "PaperLayout", "ADDINT");
insertTable2(it2, 4294967297L, "GenerationTime", "Wed Oct 22 14:12:10 CEST 2008");
insertTable2(it2, 4294967297L, "DocumentID", "21867/0/0//");
insertTable2(it2, 4294967297L, "PageSequenceId", "000001");
insertTable2(it2, 4294967297L, "PhysicalID", "No");
insertTable2(it2, 4294967297L, "cover_page", "true");
insertTable2(it2, 4294967297L, "Staple", "No");
updateTable2(ut2, 4294967297L);
insertTable2(it2, 2147483653L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483653L, "GenerationTime", "Wed Oct 22 14:12:10 CEST 2008");
insertTable2(it2, 2147483653L, "DocumentID", "21867/1/1//");
insertTable2(it2, 2147483653L, "PageSequenceId", "000002");
insertTable2(it2, 2147483653L, "PhysicalID", "No");
insertTable2(it2, 2147483653L, "Staple", "No");
updateTable2(ut2, 2147483653L);
insertTable2(it2, 2147483654L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483654L, "GenerationTime", "Wed Oct 22 14:12:10 CEST 2008");
insertTable2(it2, 2147483654L, "DocumentID", "21867/1/1//");
insertTable2(it2, 2147483654L, "PageSequenceId", "000003");
insertTable2(it2, 2147483654L, "PhysicalID", "No");
insertTable2(it2, 2147483654L, "Staple", "No");
updateTable2(ut2, 2147483654L);
insertTable1(it1, 6442450945L);
insertTable2(it2, 6442450945L, "SC2", "PostCode=1180");
insertTable2(it2, 6442450945L, "AddressG4", "BELGIQUE");
insertTable2(it2, 6442450945L, "IsIdenticalToDocumentAddress", "");
insertTable2(it2, 6442450945L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 6442450945L, "DocumentSortingValues", "");
insertTable2(it2, 6442450945L, "ItemSeq", "0");
insertTable2(it2, 6442450945L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 6442450945L, "Plex", "S");
insertTable2(it2, 6442450945L, "SC3", "=");
insertTable2(it2, 6442450945L, "has_address", "true");
insertTable2(it2, 6442450945L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 6442450945L, "Language", "FR");
insertTable2(it2, 6442450945L, "SC4", "=");
insertTable2(it2, 6442450945L, "InternalAddress", "233/621");
insertTable2(it2, 6442450945L, "AddressG6", "");
insertTable2(it2, 6442450945L, "InternalAddressBringer", "true");
insertTable2(it2, 6442450945L, "AddresseeSeq", "0");
insertTable2(it2, 6442450945L, "SC1", "Requester=ddch257");
insertTable2(it2, 6442450945L, "CommunicationOrderId", "21868");
insertTable2(it2, 6442450945L, "BatchTypeId", "233-621-001");
insertTable2(it2, 6442450945L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 6442450945L, "SortPlan", "");
insertTable2(it2, 6442450945L, "Enveloping", "N");
insertTable2(it2, 6442450945L, "PostComponentId", "21858");
insertTable2(it2, 6442450945L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 6442450945L, "city", "Bruxelles");
insertTable2(it2, 6442450945L, "AddressG7", "");
insertTable2(it2, 6442450945L, "CopyMention", "");
insertTable2(it2, 6442450945L, "StapleNbr", "NO");
insertTable2(it2, 6442450945L, "AddressG8", "");
insertTable2(it2, 6442450945L, "AddressG5", "");
insertTable2(it2, 6442450945L, "EnvelopSortingValue", "BE1180___testOlivier002-0004___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 6442450945L, "GroupedWith", "");
insertTable2(it2, 6442450945L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 6442450945L, "DiversionReason", "001");
insertTable2(it2, 6442450945L, "Pliable", "true");
insertTable2(it2, 6442450945L, "country", "BE");
insertTable2(it2, 6442450945L, "AddressG1", "testOlivier002-0004");
insertTable2(it2, 6442450945L, "MentionCode", "");
insertTable2(it2, 6442450945L, "postCode", "1180");
insertTable2(it2, 6442450945L, "SC5", "=");
insertTable2(it2, 6442450945L, "env_type", "I");
insertTable2(it2, 6442450945L, "Branding", "1C");
insertTable2(it2, 6442450945L, "PaperLayout", "ADDINT");
insertTable2(it2, 6442450945L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 6442450945L, "DocumentID", "21868/0/0//");
insertTable2(it2, 6442450945L, "PageSequenceId", "000001");
insertTable2(it2, 6442450945L, "PhysicalID", "No");
insertTable2(it2, 6442450945L, "cover_page", "true");
insertTable2(it2, 6442450945L, "Staple", "No");
updateTable2(ut2, 6442450945L);
insertTable2(it2, 2147483655L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483655L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483655L, "DocumentID", "21868/1/1//");
insertTable2(it2, 2147483655L, "PageSequenceId", "000002");
insertTable2(it2, 2147483655L, "PhysicalID", "No");
insertTable2(it2, 2147483655L, "Staple", "No");
updateTable2(ut2, 2147483655L);
insertTable2(it2, 2147483656L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483656L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483656L, "DocumentID", "21868/1/1//");
insertTable2(it2, 2147483656L, "PageSequenceId", "000003");
insertTable2(it2, 2147483656L, "PhysicalID", "No");
insertTable2(it2, 2147483656L, "Staple", "No");
updateTable2(ut2, 2147483656L);
insertTable2(it2, 2147483657L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483657L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483657L, "DocumentID", "21869/1/1//");
insertTable2(it2, 2147483657L, "PageSequenceId", "000001");
insertTable2(it2, 2147483657L, "PhysicalID", "No");
insertTable2(it2, 2147483657L, "Staple", "No");
updateTable2(ut2, 2147483657L);
insertTable1(it1, 8589934593L);
insertTable2(it2, 8589934593L, "SC2", "PostCode=1180");
insertTable2(it2, 8589934593L, "AddressG4", "BELGIQUE");
insertTable2(it2, 8589934593L, "IsIdenticalToDocumentAddress", "");
insertTable2(it2, 8589934593L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 8589934593L, "DocumentSortingValues", "");
insertTable2(it2, 8589934593L, "ItemSeq", "0");
insertTable2(it2, 8589934593L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 8589934593L, "Plex", "S");
insertTable2(it2, 8589934593L, "SC3", "=");
insertTable2(it2, 8589934593L, "has_address", "true");
insertTable2(it2, 8589934593L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 8589934593L, "Language", "FR");
insertTable2(it2, 8589934593L, "SC4", "=");
insertTable2(it2, 8589934593L, "InternalAddress", "233/621");
insertTable2(it2, 8589934593L, "AddressG6", "");
insertTable2(it2, 8589934593L, "InternalAddressBringer", "true");
insertTable2(it2, 8589934593L, "AddresseeSeq", "0");
insertTable2(it2, 8589934593L, "SC1", "Requester=ddch257");
insertTable2(it2, 8589934593L, "CommunicationOrderId", "21873");
insertTable2(it2, 8589934593L, "BatchTypeId", "233-621-001");
insertTable2(it2, 8589934593L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 8589934593L, "SortPlan", "");
insertTable2(it2, 8589934593L, "Enveloping", "N");
insertTable2(it2, 8589934593L, "PostComponentId", "21863");
insertTable2(it2, 8589934593L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 8589934593L, "city", "Bruxelles");
insertTable2(it2, 8589934593L, "AddressG7", "");
insertTable2(it2, 8589934593L, "CopyMention", "");
insertTable2(it2, 8589934593L, "StapleNbr", "NO");
insertTable2(it2, 8589934593L, "AddressG8", "");
insertTable2(it2, 8589934593L, "AddressG5", "");
insertTable2(it2, 8589934593L, "EnvelopSortingValue", "BE1180___testOlivier005-0009___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 8589934593L, "GroupedWith", "");
insertTable2(it2, 8589934593L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 8589934593L, "DiversionReason", "001");
insertTable2(it2, 8589934593L, "Pliable", "true");
insertTable2(it2, 8589934593L, "country", "BE");
insertTable2(it2, 8589934593L, "AddressG1", "testOlivier005-0009");
insertTable2(it2, 8589934593L, "MentionCode", "");
insertTable2(it2, 8589934593L, "postCode", "1180");
insertTable2(it2, 8589934593L, "SC5", "=");
insertTable2(it2, 8589934593L, "env_type", "I");
insertTable2(it2, 8589934593L, "Branding", "1C");
insertTable2(it2, 2147483658L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483658L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483658L, "DocumentID", "21869/1/1//");
insertTable2(it2, 2147483658L, "PageSequenceId", "000002");
insertTable2(it2, 2147483658L, "PhysicalID", "No");
insertTable2(it2, 2147483658L, "Staple", "No");
updateTable2(ut2, 2147483658L);
insertTable2(it2, 2147483659L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483659L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483659L, "DocumentID", "21870/1/1//");
insertTable2(it2, 2147483659L, "PageSequenceId", "000001");
insertTable2(it2, 2147483659L, "PhysicalID", "No");
insertTable2(it2, 2147483659L, "Staple", "No");
updateTable2(ut2, 2147483659L);
insertTable2(it2, 2147483660L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483660L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483660L, "DocumentID", "21870/1/1//");
insertTable2(it2, 2147483660L, "PageSequenceId", "000002");
insertTable2(it2, 2147483660L, "PhysicalID", "No");
insertTable2(it2, 2147483660L, "Staple", "No");
updateTable2(ut2, 2147483660L);
insertTable2(it2, 2147483661L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483661L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483661L, "DocumentID", "21871/1/1//");
insertTable2(it2, 2147483661L, "PageSequenceId", "000001");
insertTable2(it2, 2147483661L, "PhysicalID", "No");
insertTable2(it2, 2147483661L, "Staple", "No");
updateTable2(ut2, 2147483661L);
insertTable2(it2, 2147483662L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483662L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483662L, "DocumentID", "21871/1/1//");
insertTable2(it2, 2147483662L, "PageSequenceId", "000002");
insertTable2(it2, 2147483662L, "PhysicalID", "No");
insertTable2(it2, 2147483662L, "Staple", "No");
updateTable2(ut2, 2147483662L);
insertTable2(it2, 2147483663L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483663L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483663L, "DocumentID", "21872/1/1//");
insertTable2(it2, 2147483663L, "PageSequenceId", "000001");
insertTable2(it2, 2147483663L, "PhysicalID", "No");
insertTable2(it2, 2147483663L, "Staple", "No");
updateTable2(ut2, 2147483663L);
insertTable2(it2, 2147483664L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483664L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483664L, "DocumentID", "21872/1/1//");
insertTable2(it2, 2147483664L, "PageSequenceId", "000002");
insertTable2(it2, 2147483664L, "PhysicalID", "No");
insertTable2(it2, 2147483664L, "Staple", "No");
updateTable2(ut2, 2147483664L);
insertTable1(it1, 10737418241L);
insertTable2(it2, 10737418241L, "SC2", "PostCode=1180");
insertTable2(it2, 10737418241L, "AddressG4", "BELGIQUE");
insertTable2(it2, 10737418241L, "IsIdenticalToDocumentAddress", "");
insertTable2(it2, 10737418241L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 10737418241L, "DocumentSortingValues", "");
insertTable2(it2, 10737418241L, "ItemSeq", "0");
insertTable2(it2, 10737418241L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 10737418241L, "Plex", "S");
insertTable2(it2, 10737418241L, "SC3", "=");
insertTable2(it2, 10737418241L, "has_address", "true");
insertTable2(it2, 10737418241L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 10737418241L, "Language", "FR");
insertTable2(it2, 10737418241L, "SC4", "=");
insertTable2(it2, 10737418241L, "InternalAddress", "233/621");
insertTable2(it2, 10737418241L, "AddressG6", "");
insertTable2(it2, 10737418241L, "InternalAddressBringer", "true");
insertTable2(it2, 10737418241L, "AddresseeSeq", "0");
insertTable2(it2, 10737418241L, "SC1", "Requester=ddch257");
insertTable2(it2, 10737418241L, "CommunicationOrderId", "21874");
insertTable2(it2, 10737418241L, "BatchTypeId", "233-621-001");
insertTable2(it2, 10737418241L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 10737418241L, "SortPlan", "");
insertTable2(it2, 10737418241L, "Enveloping", "N");
insertTable2(it2, 10737418241L, "PostComponentId", "21864");
insertTable2(it2, 10737418241L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 10737418241L, "city", "Bruxelles");
insertTable2(it2, 10737418241L, "AddressG7", "");
insertTable2(it2, 10737418241L, "CopyMention", "");
insertTable2(it2, 10737418241L, "StapleNbr", "NO");
insertTable2(it2, 10737418241L, "AddressG8", "");
insertTable2(it2, 10737418241L, "AddressG5", "");
insertTable2(it2, 10737418241L, "EnvelopSortingValue", "BE1180___testOlivier005-0010___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 10737418241L, "GroupedWith", "");
insertTable2(it2, 10737418241L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 10737418241L, "DiversionReason", "001");
insertTable2(it2, 10737418241L, "Pliable", "true");
insertTable2(it2, 10737418241L, "country", "BE");
insertTable2(it2, 10737418241L, "AddressG1", "testOlivier005-0010");
insertTable2(it2, 10737418241L, "MentionCode", "");
insertTable2(it2, 10737418241L, "postCode", "1180");
insertTable2(it2, 10737418241L, "SC5", "=");
insertTable2(it2, 10737418241L, "env_type", "I");
insertTable2(it2, 10737418241L, "Branding", "1C");
insertTable2(it2, 8589934593L, "PaperLayout", "ADDINT");
insertTable2(it2, 8589934593L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 8589934593L, "DocumentID", "21873/0/0//");
insertTable2(it2, 8589934593L, "PageSequenceId", "000001");
insertTable2(it2, 8589934593L, "PhysicalID", "No");
insertTable2(it2, 8589934593L, "cover_page", "true");
insertTable2(it2, 8589934593L, "Staple", "No");
updateTable2(ut2, 8589934593L);
insertTable2(it2, 2147483665L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483665L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483665L, "DocumentID", "21873/1/1//");
insertTable2(it2, 2147483665L, "PageSequenceId", "000002");
insertTable2(it2, 2147483665L, "PhysicalID", "No");
insertTable2(it2, 2147483665L, "Staple", "No");
updateTable2(ut2, 2147483665L);
insertTable2(it2, 2147483666L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483666L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483666L, "DocumentID", "21873/1/1//");
insertTable2(it2, 2147483666L, "PageSequenceId", "000003");
insertTable2(it2, 2147483666L, "PhysicalID", "No");
insertTable2(it2, 2147483666L, "Staple", "No");
updateTable2(ut2, 2147483666L);
insertTable2(it2, 10737418241L, "PaperLayout", "ADDINT");
insertTable2(it2, 10737418241L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 10737418241L, "DocumentID", "21874/0/0//");
insertTable2(it2, 10737418241L, "PageSequenceId", "000001");
insertTable2(it2, 10737418241L, "PhysicalID", "No");
insertTable2(it2, 10737418241L, "cover_page", "true");
insertTable2(it2, 10737418241L, "Staple", "No");
updateTable2(ut2, 10737418241L);
insertTable2(it2, 2147483667L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483667L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483667L, "DocumentID", "21874/1/1//");
insertTable2(it2, 2147483667L, "PageSequenceId", "000002");
insertTable2(it2, 2147483667L, "PhysicalID", "No");
insertTable2(it2, 2147483667L, "Staple", "No");
updateTable2(ut2, 2147483667L);
insertTable2(it2, 2147483668L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483668L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483668L, "DocumentID", "21874/1/1//");
insertTable2(it2, 2147483668L, "PageSequenceId", "000003");
insertTable2(it2, 2147483668L, "PhysicalID", "No");
insertTable2(it2, 2147483668L, "Staple", "No");
updateTable2(ut2, 2147483668L);
insertTable2(it2, 2147483669L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483669L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483669L, "DocumentID", "21875/1/1//");
insertTable2(it2, 2147483669L, "PageSequenceId", "000001");
insertTable2(it2, 2147483669L, "PhysicalID", "No");
insertTable2(it2, 2147483669L, "Staple", "No");
updateTable2(ut2, 2147483669L);
insertTable2(it2, 2147483670L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483670L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483670L, "DocumentID", "21875/1/1//");
insertTable2(it2, 2147483670L, "PageSequenceId", "000002");
insertTable2(it2, 2147483670L, "PhysicalID", "No");
insertTable2(it2, 2147483670L, "Staple", "No");
updateTable2(ut2, 2147483670L);
insertTable1(it1, 12884901889L);
insertTable2(it2, 12884901889L, "SC2", "PostCode=1180");
insertTable2(it2, 12884901889L, "AddressG4", "BELGIQUE");
insertTable2(it2, 12884901889L, "IsIdenticalToDocumentAddress", "");
insertTable2(it2, 12884901889L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 12884901889L, "DocumentSortingValues", "");
insertTable2(it2, 12884901889L, "ItemSeq", "0");
insertTable2(it2, 12884901889L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 12884901889L, "Plex", "S");
insertTable2(it2, 12884901889L, "SC3", "=");
insertTable2(it2, 12884901889L, "has_address", "true");
insertTable2(it2, 12884901889L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 12884901889L, "Language", "FR");
insertTable2(it2, 12884901889L, "SC4", "=");
insertTable2(it2, 12884901889L, "InternalAddress", "233/621");
insertTable2(it2, 12884901889L, "AddressG6", "");
insertTable2(it2, 12884901889L, "InternalAddressBringer", "true");
insertTable2(it2, 12884901889L, "AddresseeSeq", "0");
insertTable2(it2, 12884901889L, "SC1", "Requester=ddch257");
insertTable2(it2, 12884901889L, "CommunicationOrderId", "21879");
insertTable2(it2, 12884901889L, "BatchTypeId", "233-621-001");
insertTable2(it2, 12884901889L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 12884901889L, "SortPlan", "");
insertTable2(it2, 12884901889L, "Enveloping", "N");
insertTable2(it2, 12884901889L, "PostComponentId", "21869");
insertTable2(it2, 12884901889L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 12884901889L, "city", "Bruxelles");
insertTable2(it2, 12884901889L, "AddressG7", "");
insertTable2(it2, 12884901889L, "CopyMention", "");
insertTable2(it2, 12884901889L, "StapleNbr", "NO");
insertTable2(it2, 12884901889L, "AddressG8", "");
insertTable2(it2, 12884901889L, "AddressG5", "");
insertTable2(it2, 12884901889L, "EnvelopSortingValue", "BE1180___testOlivier008-0015___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 12884901889L, "GroupedWith", "");
insertTable2(it2, 12884901889L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 12884901889L, "DiversionReason", "001");
insertTable2(it2, 12884901889L, "Pliable", "true");
insertTable2(it2, 12884901889L, "country", "BE");
insertTable2(it2, 12884901889L, "AddressG1", "testOlivier008-0015");
insertTable2(it2, 12884901889L, "MentionCode", "");
insertTable2(it2, 12884901889L, "postCode", "1180");
insertTable2(it2, 12884901889L, "SC5", "=");
insertTable2(it2, 12884901889L, "env_type", "I");
insertTable2(it2, 12884901889L, "Branding", "1C");
insertTable2(it2, 2147483671L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483671L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483671L, "DocumentID", "21876/1/1//");
insertTable2(it2, 2147483671L, "PageSequenceId", "000001");
insertTable2(it2, 2147483671L, "PhysicalID", "No");
insertTable2(it2, 2147483671L, "Staple", "No");
updateTable2(ut2, 2147483671L);
insertTable2(it2, 2147483672L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483672L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483672L, "DocumentID", "21876/1/1//");
insertTable2(it2, 2147483672L, "PageSequenceId", "000002");
insertTable2(it2, 2147483672L, "PhysicalID", "No");
insertTable2(it2, 2147483672L, "Staple", "No");
updateTable2(ut2, 2147483672L);
insertTable2(it2, 2147483673L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483673L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483673L, "DocumentID", "21877/1/1//");
insertTable2(it2, 2147483673L, "PageSequenceId", "000001");
insertTable2(it2, 2147483673L, "PhysicalID", "No");
insertTable2(it2, 2147483673L, "Staple", "No");
updateTable2(ut2, 2147483673L);
insertTable2(it2, 2147483674L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483674L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483674L, "DocumentID", "21877/1/1//");
insertTable2(it2, 2147483674L, "PageSequenceId", "000002");
insertTable2(it2, 2147483674L, "PhysicalID", "No");
insertTable2(it2, 2147483674L, "Staple", "No");
updateTable2(ut2, 2147483674L);
insertTable2(it2, 2147483675L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483675L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483675L, "DocumentID", "21878/1/1//");
insertTable2(it2, 2147483675L, "PageSequenceId", "000001");
insertTable2(it2, 2147483675L, "PhysicalID", "No");
insertTable2(it2, 2147483675L, "Staple", "No");
updateTable2(ut2, 2147483675L);
insertTable2(it2, 2147483676L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483676L, "GenerationTime", "Wed Oct 22 14:12:11 CEST 2008");
insertTable2(it2, 2147483676L, "DocumentID", "21878/1/1//");
insertTable2(it2, 2147483676L, "PageSequenceId", "000002");
insertTable2(it2, 2147483676L, "PhysicalID", "No");
insertTable2(it2, 2147483676L, "Staple", "No");
updateTable2(ut2, 2147483676L);
insertTable1(it1, 15032385537L);
insertTable2(it2, 15032385537L, "SC2", "PostCode=1180");
insertTable2(it2, 15032385537L, "AddressG4", "BELGIQUE");
insertTable2(it2, 15032385537L, "IsIdenticalToDocumentAddress", "");
insertTable2(it2, 15032385537L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 15032385537L, "DocumentSortingValues", "");
insertTable2(it2, 15032385537L, "ItemSeq", "0");
insertTable2(it2, 15032385537L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 15032385537L, "Plex", "S");
insertTable2(it2, 15032385537L, "SC3", "=");
insertTable2(it2, 15032385537L, "has_address", "true");
insertTable2(it2, 15032385537L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 15032385537L, "Language", "FR");
insertTable2(it2, 15032385537L, "SC4", "=");
insertTable2(it2, 15032385537L, "InternalAddress", "233/621");
insertTable2(it2, 15032385537L, "AddressG6", "");
insertTable2(it2, 15032385537L, "InternalAddressBringer", "true");
insertTable2(it2, 15032385537L, "AddresseeSeq", "0");
insertTable2(it2, 15032385537L, "SC1", "Requester=ddch257");
insertTable2(it2, 15032385537L, "CommunicationOrderId", "21880");
insertTable2(it2, 15032385537L, "BatchTypeId", "233-621-001");
insertTable2(it2, 15032385537L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 15032385537L, "SortPlan", "");
insertTable2(it2, 15032385537L, "Enveloping", "N");
insertTable2(it2, 15032385537L, "PostComponentId", "21870");
insertTable2(it2, 15032385537L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 15032385537L, "city", "Bruxelles");
insertTable2(it2, 15032385537L, "AddressG7", "");
insertTable2(it2, 15032385537L, "CopyMention", "");
insertTable2(it2, 15032385537L, "StapleNbr", "NO");
insertTable2(it2, 15032385537L, "AddressG8", "");
insertTable2(it2, 15032385537L, "AddressG5", "");
insertTable2(it2, 15032385537L, "EnvelopSortingValue", "BE1180___testOlivier008-0016___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 15032385537L, "GroupedWith", "");
insertTable2(it2, 15032385537L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 15032385537L, "DiversionReason", "001");
insertTable2(it2, 15032385537L, "Pliable", "true");
insertTable2(it2, 15032385537L, "country", "BE");
insertTable2(it2, 15032385537L, "AddressG1", "testOlivier008-0016");
insertTable2(it2, 15032385537L, "MentionCode", "");
insertTable2(it2, 15032385537L, "postCode", "1180");
insertTable2(it2, 15032385537L, "SC5", "=");
insertTable2(it2, 15032385537L, "env_type", "I");
insertTable2(it2, 15032385537L, "Branding", "1C");
insertTable2(it2, 12884901889L, "PaperLayout", "ADDINT");
insertTable2(it2, 12884901889L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 12884901889L, "DocumentID", "21879/0/0//");
insertTable2(it2, 12884901889L, "PageSequenceId", "000001");
insertTable2(it2, 12884901889L, "PhysicalID", "No");
insertTable2(it2, 12884901889L, "cover_page", "true");
insertTable2(it2, 12884901889L, "Staple", "No");
updateTable2(ut2, 12884901889L);
insertTable2(it2, 2147483677L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483677L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483677L, "DocumentID", "21879/1/1//");
insertTable2(it2, 2147483677L, "PageSequenceId", "000002");
insertTable2(it2, 2147483677L, "PhysicalID", "No");
insertTable2(it2, 2147483677L, "Staple", "No");
updateTable2(ut2, 2147483677L);
insertTable2(it2, 2147483678L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483678L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483678L, "DocumentID", "21879/1/1//");
insertTable2(it2, 2147483678L, "PageSequenceId", "000003");
insertTable2(it2, 2147483678L, "PhysicalID", "No");
insertTable2(it2, 2147483678L, "Staple", "No");
updateTable2(ut2, 2147483678L);
insertTable2(it2, 15032385537L, "PaperLayout", "ADDINT");
insertTable2(it2, 15032385537L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 15032385537L, "DocumentID", "21880/0/0//");
insertTable2(it2, 15032385537L, "PageSequenceId", "000001");
insertTable2(it2, 15032385537L, "PhysicalID", "No");
insertTable2(it2, 15032385537L, "cover_page", "true");
insertTable2(it2, 15032385537L, "Staple", "No");
updateTable2(ut2, 15032385537L);
insertTable2(it2, 2147483679L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483679L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483679L, "DocumentID", "21880/1/1//");
insertTable2(it2, 2147483679L, "PageSequenceId", "000002");
insertTable2(it2, 2147483679L, "PhysicalID", "No");
insertTable2(it2, 2147483679L, "Staple", "No");
updateTable2(ut2, 2147483679L);
insertTable2(it2, 2147483680L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483680L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483680L, "DocumentID", "21880/1/1//");
insertTable2(it2, 2147483680L, "PageSequenceId", "000003");
insertTable2(it2, 2147483680L, "PhysicalID", "No");
insertTable2(it2, 2147483680L, "Staple", "No");
updateTable2(ut2, 2147483680L);
insertTable1(it1, 17179869185L);
insertTable2(it2, 17179869185L, "SC2", "PostCode=1180");
insertTable2(it2, 17179869185L, "AddressG4", "BELGIQUE");
insertTable2(it2, 17179869185L, "IsIdenticalToDocumentAddress", "");
insertTable2(it2, 17179869185L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 17179869185L, "DocumentSortingValues", "");
insertTable2(it2, 17179869185L, "ItemSeq", "0");
insertTable2(it2, 17179869185L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 17179869185L, "Plex", "S");
insertTable2(it2, 17179869185L, "SC3", "=");
insertTable2(it2, 17179869185L, "has_address", "true");
insertTable2(it2, 17179869185L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 17179869185L, "Language", "FR");
insertTable2(it2, 17179869185L, "SC4", "=");
insertTable2(it2, 17179869185L, "InternalAddress", "233/621");
insertTable2(it2, 17179869185L, "AddressG6", "");
insertTable2(it2, 17179869185L, "InternalAddressBringer", "true");
insertTable2(it2, 17179869185L, "AddresseeSeq", "0");
insertTable2(it2, 17179869185L, "SC1", "Requester=ddch257");
insertTable2(it2, 17179869185L, "CommunicationOrderId", "21885");
insertTable2(it2, 17179869185L, "BatchTypeId", "233-621-001");
insertTable2(it2, 17179869185L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 17179869185L, "SortPlan", "");
insertTable2(it2, 17179869185L, "Enveloping", "N");
insertTable2(it2, 17179869185L, "PostComponentId", "21875");
insertTable2(it2, 17179869185L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 17179869185L, "city", "Bruxelles");
insertTable2(it2, 17179869185L, "AddressG7", "");
insertTable2(it2, 17179869185L, "CopyMention", "");
insertTable2(it2, 17179869185L, "StapleNbr", "NO");
insertTable2(it2, 17179869185L, "AddressG8", "");
insertTable2(it2, 17179869185L, "AddressG5", "");
insertTable2(it2, 17179869185L, "EnvelopSortingValue", "BE1180___testOlivier011-0021___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 17179869185L, "GroupedWith", "");
insertTable2(it2, 17179869185L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 17179869185L, "DiversionReason", "001");
insertTable2(it2, 17179869185L, "Pliable", "true");
insertTable2(it2, 17179869185L, "country", "BE");
insertTable2(it2, 17179869185L, "AddressG1", "testOlivier011-0021");
insertTable2(it2, 17179869185L, "MentionCode", "");
insertTable2(it2, 17179869185L, "postCode", "1180");
insertTable2(it2, 17179869185L, "SC5", "=");
insertTable2(it2, 17179869185L, "env_type", "I");
insertTable2(it2, 17179869185L, "Branding", "1C");
insertTable2(it2, 2147483681L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483681L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483681L, "DocumentID", "21881/1/1//");
insertTable2(it2, 2147483681L, "PageSequenceId", "000001");
insertTable2(it2, 2147483681L, "PhysicalID", "No");
insertTable2(it2, 2147483681L, "Staple", "No");
updateTable2(ut2, 2147483681L);
insertTable2(it2, 2147483682L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483682L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483682L, "DocumentID", "21881/1/1//");
insertTable2(it2, 2147483682L, "PageSequenceId", "000002");
insertTable2(it2, 2147483682L, "PhysicalID", "No");
insertTable2(it2, 2147483682L, "Staple", "No");
updateTable2(ut2, 2147483682L);
insertTable2(it2, 2147483683L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483683L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483683L, "DocumentID", "21882/1/1//");
insertTable2(it2, 2147483683L, "PageSequenceId", "000001");
insertTable2(it2, 2147483683L, "PhysicalID", "No");
insertTable2(it2, 2147483683L, "Staple", "No");
updateTable2(ut2, 2147483683L);
insertTable2(it2, 2147483684L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483684L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483684L, "DocumentID", "21882/1/1//");
insertTable2(it2, 2147483684L, "PageSequenceId", "000002");
insertTable2(it2, 2147483684L, "PhysicalID", "No");
insertTable2(it2, 2147483684L, "Staple", "No");
updateTable2(ut2, 2147483684L);
insertTable2(it2, 2147483685L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483685L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483685L, "DocumentID", "21883/1/1//");
insertTable2(it2, 2147483685L, "PageSequenceId", "000001");
insertTable2(it2, 2147483685L, "PhysicalID", "No");
insertTable2(it2, 2147483685L, "Staple", "No");
updateTable2(ut2, 2147483685L);
insertTable2(it2, 2147483686L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483686L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483686L, "DocumentID", "21883/1/1//");
insertTable2(it2, 2147483686L, "PageSequenceId", "000002");
insertTable2(it2, 2147483686L, "PhysicalID", "No");
insertTable2(it2, 2147483686L, "Staple", "No");
updateTable2(ut2, 2147483686L);
insertTable2(it2, 2147483687L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483687L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483687L, "DocumentID", "21884/1/1//");
insertTable2(it2, 2147483687L, "PageSequenceId", "000001");
insertTable2(it2, 2147483687L, "PhysicalID", "No");
insertTable2(it2, 2147483687L, "Staple", "No");
updateTable2(ut2, 2147483687L);
insertTable1(it1, 19327352833L);
insertTable2(it2, 19327352833L, "SC2", "PostCode=1180");
insertTable2(it2, 19327352833L, "AddressG4", "BELGIQUE");
insertTable2(it2, 19327352833L, "IsIdenticalToDocumentAddress", "");
insertTable2(it2, 19327352833L, "AddressG3", "1180 Bruxelles");
insertTable2(it2, 19327352833L, "DocumentSortingValues", "");
insertTable2(it2, 19327352833L, "ItemSeq", "0");
insertTable2(it2, 19327352833L, "BatchTypeInstructions", "Ne pas jeter ces documents. Ils ont \u00e9t\u00e9 faits pour quelque chose.");
insertTable2(it2, 19327352833L, "Plex", "S");
insertTable2(it2, 19327352833L, "SC3", "=");
insertTable2(it2, 19327352833L, "has_address", "true");
insertTable2(it2, 19327352833L, "SubBatchSortingValue", "ddch257___1180______");
insertTable2(it2, 19327352833L, "Language", "FR");
insertTable2(it2, 19327352833L, "SC4", "=");
insertTable2(it2, 19327352833L, "InternalAddress", "233/621");
insertTable2(it2, 19327352833L, "AddressG6", "");
insertTable2(it2, 19327352833L, "InternalAddressBringer", "true");
insertTable2(it2, 19327352833L, "AddresseeSeq", "0");
insertTable2(it2, 19327352833L, "SC1", "Requester=ddch257");
insertTable2(it2, 19327352833L, "CommunicationOrderId", "21886");
insertTable2(it2, 19327352833L, "BatchTypeId", "233-621-001");
insertTable2(it2, 19327352833L, "location", "Bla bla bla bla bla bla 99");
insertTable2(it2, 19327352833L, "SortPlan", "");
insertTable2(it2, 19327352833L, "Enveloping", "N");
insertTable2(it2, 19327352833L, "PostComponentId", "21876");
insertTable2(it2, 19327352833L, "BatchTypeLabel", "Diversion pour test");
insertTable2(it2, 19327352833L, "city", "Bruxelles");
insertTable2(it2, 19327352833L, "AddressG7", "");
insertTable2(it2, 19327352833L, "CopyMention", "");
insertTable2(it2, 19327352833L, "StapleNbr", "NO");
insertTable2(it2, 19327352833L, "AddressG8", "");
insertTable2(it2, 19327352833L, "AddressG5", "");
insertTable2(it2, 19327352833L, "EnvelopSortingValue", "BE1180___testOlivier011-0022___________Bla bla bla bla bla bla 99____");
insertTable2(it2, 19327352833L, "GroupedWith", "");
insertTable2(it2, 19327352833L, "AddressG2", "Bla bla bla bla bla bla 99");
insertTable2(it2, 19327352833L, "DiversionReason", "001");
insertTable2(it2, 19327352833L, "Pliable", "true");
insertTable2(it2, 19327352833L, "country", "BE");
insertTable2(it2, 19327352833L, "AddressG1", "testOlivier011-0022");
insertTable2(it2, 19327352833L, "MentionCode", "");
insertTable2(it2, 19327352833L, "postCode", "1180");
insertTable2(it2, 19327352833L, "SC5", "=");
insertTable2(it2, 19327352833L, "env_type", "I");
insertTable2(it2, 19327352833L, "Branding", "1C");
insertTable2(it2, 2147483688L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483688L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483688L, "DocumentID", "21884/1/1//");
insertTable2(it2, 2147483688L, "PageSequenceId", "000002");
insertTable2(it2, 2147483688L, "PhysicalID", "No");
insertTable2(it2, 2147483688L, "Staple", "No");
updateTable2(ut2, 2147483688L);
insertTable2(it2, 17179869185L, "PaperLayout", "ADDINT");
insertTable2(it2, 17179869185L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 17179869185L, "DocumentID", "21885/0/0//");
insertTable2(it2, 17179869185L, "PageSequenceId", "000001");
insertTable2(it2, 17179869185L, "PhysicalID", "No");
insertTable2(it2, 17179869185L, "cover_page", "true");
insertTable2(it2, 17179869185L, "Staple", "No");
updateTable2(ut2, 17179869185L);
insertTable2(it2, 2147483689L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483689L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483689L, "DocumentID", "21885/1/1//");
insertTable2(it2, 2147483689L, "PageSequenceId", "000002");
insertTable2(it2, 2147483689L, "PhysicalID", "No");
insertTable2(it2, 2147483689L, "Staple", "No");
updateTable2(ut2, 2147483689L);
insertTable2(it2, 2147483690L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483690L, "GenerationTime", "Wed Oct 22 14:12:12 CEST 2008");
insertTable2(it2, 2147483690L, "DocumentID", "21885/1/1//");
insertTable2(it2, 2147483690L, "PageSequenceId", "000003");
insertTable2(it2, 2147483690L, "PhysicalID", "No");
insertTable2(it2, 2147483690L, "Staple", "No");
updateTable2(ut2, 2147483690L);
insertTable2(it2, 19327352833L, "PaperLayout", "ADDINT");
insertTable2(it2, 19327352833L, "GenerationTime", "Wed Oct 22 14:12:13 CEST 2008");
insertTable2(it2, 19327352833L, "DocumentID", "21886/0/0//");
insertTable2(it2, 19327352833L, "PageSequenceId", "000001");
insertTable2(it2, 19327352833L, "PhysicalID", "No");
insertTable2(it2, 19327352833L, "cover_page", "true");
insertTable2(it2, 19327352833L, "Staple", "No");
updateTable2(ut2, 19327352833L);
insertTable2(it2, 2147483691L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483691L, "GenerationTime", "Wed Oct 22 14:12:13 CEST 2008");
insertTable2(it2, 2147483691L, "DocumentID", "21886/1/1//");
insertTable2(it2, 2147483691L, "PageSequenceId", "000002");
insertTable2(it2, 2147483691L, "PhysicalID", "No");
insertTable2(it2, 2147483691L, "Staple", "No");
updateTable2(ut2, 2147483691L);
insertTable2(it2, 2147483692L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483692L, "GenerationTime", "Wed Oct 22 14:12:13 CEST 2008");
insertTable2(it2, 2147483692L, "DocumentID", "21886/1/1//");
insertTable2(it2, 2147483692L, "PageSequenceId", "000003");
insertTable2(it2, 2147483692L, "PhysicalID", "No");
insertTable2(it2, 2147483692L, "Staple", "No");
updateTable2(ut2, 2147483692L);
insertTable2(it2, 2147483693L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483693L, "GenerationTime", "Wed Oct 22 14:12:13 CEST 2008");
insertTable2(it2, 2147483693L, "DocumentID", "21887/1/1//");
insertTable2(it2, 2147483693L, "PageSequenceId", "000001");
insertTable2(it2, 2147483693L, "PhysicalID", "No");
insertTable2(it2, 2147483693L, "Staple", "No");
updateTable2(ut2, 2147483693L);
insertTable2(it2, 2147483694L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483694L, "GenerationTime", "Wed Oct 22 14:12:13 CEST 2008");
insertTable2(it2, 2147483694L, "DocumentID", "21887/1/1//");
insertTable2(it2, 2147483694L, "PageSequenceId", "000002");
insertTable2(it2, 2147483694L, "PhysicalID", "No");
insertTable2(it2, 2147483694L, "Staple", "No");
updateTable2(ut2, 2147483694L);
insertTable2(it2, 2147483695L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483695L, "GenerationTime", "Wed Oct 22 14:12:13 CEST 2008");
insertTable2(it2, 2147483695L, "DocumentID", "21888/1/1//");
insertTable2(it2, 2147483695L, "PageSequenceId", "000001");
insertTable2(it2, 2147483695L, "PhysicalID", "No");
insertTable2(it2, 2147483695L, "Staple", "No");
updateTable2(ut2, 2147483695L);
insertTable2(it2, 2147483696L, "PaperLayout", "LETTER");
insertTable2(it2, 2147483696L, "GenerationTime", "Wed Oct 22 14:12:13 CEST 2008");
insertTable2(it2, 2147483696L, "DocumentID", "21888/1/1//");
insertTable2(it2, 2147483696L, "PageSequenceId", "000002");
insertTable2(it2, 2147483696L, "PhysicalID", "No");
insertTable2(it2, 2147483696L, "Staple", "No");
updateTable2(ut2, 2147483696L);
it1.close();
it2.close();
ut2.close();
}
/**
* Add a test case for DERBY-4331 where the rows were not ordered correctly
* for both ascending and descending order by clause.
*/
public void testDerby4331() throws SQLException {
Statement s;
ResultSet rs;
RuntimeStatisticsParser rtsp;
String [][] desc_result = new String[][] {
{"3"},{"3"},{"2"},{"2"},{"2"},{"1"}};
String [][] asc_result = new String[][] {
{"1"},{"2"},{"2"},{"2"},{"3"},{"3"}};
String sql1 =
"SELECT CS.ID FROM CHANGESETS CS, FILECHANGES FC, "+
"REPOSITORIES R, FILES F, AUTHORS A WHERE "+
"R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' "+
"AND F.REPOSITORY = R.ID AND A.REPOSITORY = R.ID AND "+
"CS.REPOSITORY = R.ID AND CS.ID = FC.CHANGESET AND F.ID = FC.FILE "+
"AND A.ID = CS.AUTHOR AND EXISTS ( "+
"SELECT 1 FROM FILES F2 WHERE "+
"F2.ID = FC.FILE AND F2.REPOSITORY = R.ID AND "+
"F2.PATH LIKE '/%' ESCAPE '#') "+
"ORDER BY CS.ID DESC";
s = createStatement();
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n" +
"CHANGESETS CS, FILECHANGES FC, REPOSITORIES R, FILES F, "+
"AUTHORS A WHERE " +
"R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' "+
"AND F.REPOSITORY = R.ID AND A.REPOSITORY = R.ID AND "+
"CS.REPOSITORY = R.ID AND CS.ID = FC.CHANGESET AND "+
"F.ID = FC.FILE AND A.ID = CS.AUTHOR AND EXISTS ( "+
"SELECT 1 FROM FILES F2 WHERE "+
"F2.ID = FC.FILE AND F2.REPOSITORY = R.ID AND "+
"F2.PATH LIKE '/%' ESCAPE '#') "+
"ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n" +
"REPOSITORIES R -- DERBY-PROPERTIES constraint=REPOSITORIES_PATH \n"+
",FILES F -- DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
",FILECHANGES FC -- DERBY-PROPERTIES constraint=FILECHANGES_FILE_CHANGESET \n"+
", AUTHORS A -- DERBY-PROPERTIES constraint=AUTHORS_REPOSITORY_NAME \n"+
", CHANGESETS CS -- DERBY-PROPERTIES constraint=CHANGESETS_PRIMARY_ID \n"+
"WHERE "+
"R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' "+
"AND F.REPOSITORY = R.ID AND "+
"A.REPOSITORY = R.ID AND "+
"CS.REPOSITORY = R.ID AND "+
"CS.ID = FC.CHANGESET AND "+
"F.ID = FC.FILE AND "+
"A.ID = CS.AUTHOR AND "+
"EXISTS ( SELECT 1 FROM FILES F2 WHERE "+
"F2.ID = FC.FILE AND F2.REPOSITORY = R.ID AND "+
"F2.PATH LIKE '/%' ESCAPE '#') "+
"ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM " +
" CHANGESETS CS, FILECHANGES FC, REPOSITORIES R, FILES F, "+
"AUTHORS A WHERE "+
"R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' "+
"AND F.REPOSITORY = R.ID AND A.REPOSITORY = R.ID AND "+
"CS.REPOSITORY = R.ID AND CS.ID = FC.CHANGESET AND "+
"F.ID = FC.FILE AND A.ID = CS.AUTHOR AND EXISTS ( "+
"SELECT 1 FROM FILES F2 WHERE F2.REPOSITORY = 1) "+
"ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n" +
"REPOSITORIES R, FILES F, FILECHANGES FC, AUTHORS A, "+
"CHANGESETS CS WHERE " +
"R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' "+
"AND F.REPOSITORY = R.ID AND A.REPOSITORY = R.ID AND "+
"CS.REPOSITORY = R.ID AND CS.ID = FC.CHANGESET AND "+
"F.ID = FC.FILE AND A.ID = CS.AUTHOR AND EXISTS ( "+
"SELECT 1 FROM FILES F2 WHERE "+
"F2.ID = FC.FILE AND F2.REPOSITORY = R.ID AND "+
"F2.PATH LIKE '/%' ESCAPE '#') ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n"+
"REPOSITORIES R --DERBY-PROPERTIES constraint=REPOSITORIES_PATH \n"+
", FILES F --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
", FILECHANGES FC --DERBY-PROPERTIES constraint=FILECHANGES_FILE_CHANGESET \n"+
", AUTHORS A --DERBY-PROPERTIES constraint=AUTHORS_REPOSITORY_NAME \n"+
", CHANGESETS CS --DERBY-PROPERTIES constraint=CHANGESETS_PRIMARY_ID \n"+
"WHERE " +
"R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' "+
"AND F.REPOSITORY = R.ID AND A.REPOSITORY = R.ID AND "+
"CS.REPOSITORY = R.ID AND CS.ID = FC.CHANGESET AND "+
"F.ID = FC.FILE AND A.ID = CS.AUTHOR AND EXISTS ( SELECT 1 "+
"FROM FILES F2 --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
"WHERE F2.ID = FC.FILE AND F2.REPOSITORY = R.ID AND "+
"F2.PATH LIKE '/%' ESCAPE '#') ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n" +
"REPOSITORIES R --DERBY-PROPERTIES constraint=REPOSITORIES_PATH \n"+
", FILES F --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
", FILECHANGES FC --DERBY-PROPERTIES constraint=FILECHANGES_FILE_CHANGESET \n"+
", AUTHORS A --DERBY-PROPERTIES constraint=AUTHORS_REPOSITORY_NAME \n"+
", CHANGESETS CS --DERBY-PROPERTIES constraint=CHANGESETS_PRIMARY_ID \n"+
"WHERE "+
"R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' "+
"AND F.REPOSITORY = R.ID AND A.REPOSITORY = R.ID AND "+
"CS.REPOSITORY = R.ID AND CS.ID = FC.CHANGESET AND "+
"F.ID = FC.FILE AND A.ID = CS.AUTHOR AND EXISTS ( "+
"SELECT 1 "+
"FROM FILES F2 --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
"WHERE F2.ID = FC.FILE )ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n"+
"REPOSITORIES R --DERBY-PROPERTIES constraint=REPOSITORIES_PATH \n"+
", FILES F --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
", FILECHANGES FC --DERBY-PROPERTIES constraint=FILECHANGES_FILE_CHANGESET \n"+
", CHANGESETS CS --DERBY-PROPERTIES constraint=CHANGESETS_PRIMARY_ID \n"+
"WHERE "+
"R.PATH = '/var/tmp/source5923202038296723704opengrok/mercurial' "+
"AND F.REPOSITORY = R.ID AND CS.REPOSITORY = R.ID AND "+
"CS.ID = FC.CHANGESET AND F.ID = FC.FILE AND EXISTS ("+
"SELECT 1 " +
"FROM FILES F2 --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
"WHERE F2.ID = FC.FILE) ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n"+
"FILES F --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
", FILECHANGES FC --DERBY-PROPERTIES constraint=FILECHANGES_FILE_CHANGESET \n"+
", CHANGESETS CS --DERBY-PROPERTIES constraint=CHANGESETS_PRIMARY_ID \n"+
"WHERE CS.ID = FC.CHANGESET AND F.ID = FC.FILE AND EXISTS ( "+
"SELECT 1 "+
"FROM FILES F2 --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
"WHERE F2.ID = FC.FILE) ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n"+
"FILES F --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
", FILECHANGES FC --DERBY-PROPERTIES constraint=FILECHANGES_FILE_CHANGESET \n"+
", CHANGESETS CS --DERBY-PROPERTIES constraint=CHANGESETS_PRIMARY_ID \n"+
"WHERE CS.ID = FC.CHANGESET AND F.ID = FC.FILE AND EXISTS ( "+
"SELECT 1 "+
"FROM FILES F2 --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
"WHERE F2.ID = FC.FILE) ORDER BY CS.ID";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, asc_result);
sql1 =
"SELECT CS.ID FROM --DERBY-PROPERTIES joinOrder=FIXED \n"+
"FILES F --DERBY-PROPERTIES constraint=FILES_REPOSITORY_PATH \n"+
", FILECHANGES FC --DERBY-PROPERTIES constraint=FILECHANGES_FILE_CHANGESET \n"+
", CHANGESETS CS --DERBY-PROPERTIES constraint=CHANGESETS_PRIMARY_ID \n"+
"WHERE CS.ID = FC.CHANGESET AND F.ID = FC.FILE "+
"ORDER BY CS.ID DESC";
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, desc_result);
}
/**
* Add a test case for DERBY-4240 where the rows were not ordered despite
* an order by clause. The fix for DERBY-3926 took care of the bug.
*/
public void testDerby4240OrderByCase() throws SQLException {
String sql1 =
"SELECT t1.id, t1.name FROM test2 t2 INNER JOIN test1 t1 "+
"ON t2.rel_id = t1.id WHERE t2.entity_id = 1 ORDER BY t1.id ASC";
Statement s;
ResultSet rs;
RuntimeStatisticsParser rtsp;
String [][] result;
s = createStatement();
s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
rs = s.executeQuery(sql1);
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.whatSortingRequired());
rs = s.executeQuery(sql1);
result = new String[][] {
{"101", "Pupy"},{"102", "Tom"}, {"103", "Jerry"}};
JDBC.assertFullResultSet(rs, result);
}
/**
* Some more tests for order by and sort avoidance logic
*/
public void testAdditionalOrderByCases() throws SQLException {
String sql1;
Statement s;
ResultSet rs;
RuntimeStatisticsParser rtsp;
String [][] result;
s = createStatement();
s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
sql1 = "select a.col1, b.col2, c.col2 from a, b, c where c.col1=3 " +
"order by a.col1, c.col1";
rs = s.executeQuery(sql1);
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.whatSortingRequired());
rs = s.executeQuery(sql1);
result = new String[][] {
{"1", "2", "3"},{"1", "2", "3"}, {"1", "2", "3"},
{"1", "2", "3"},{"1", "2", "3"}, {"1", "2", "3"},
{"1", "2", "3"},{"1", "2", "3"}};
JDBC.assertFullResultSet(rs, result);
sql1 = "select a.col1, b.col2, c.col2 from a, b, c where a.col1=1 "+
"and b.col1 = 2 and c.col1=3 order by a.col1, b.col1, c.col1";
rs = s.executeQuery(sql1);
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertFalse(rtsp.whatSortingRequired());
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, result);
sql1 = "select c.col1, b.col1, a.col1 from a, b, c where a.col1=1 "+
"and b.col1 = 2 and c.col1=3 order by c.col1, b.col1, a.col1";
result = new String[][] {
{"3", "2", "1"},{"3", "2", "1"}, {"3", "2", "1"},
{"3", "2", "1"},{"3", "2", "1"}, {"3", "2", "1"},
{"3", "2", "1"},{"3", "2", "1"}};
rs = s.executeQuery(sql1);
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertFalse(rtsp.whatSortingRequired());
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, result);
sql1 = "select c.col1, b.col1, a.col1 from a, b, c where a.col1=1 "+
"and b.col1 = 2 and c.col1=3 order by c.col2, b.col2, a.col2";
rs = s.executeQuery(sql1);
rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.whatSortingRequired());
rs = s.executeQuery(sql1);
JDBC.assertFullResultSet(rs, result);
}
/**
* Test for forcing a order of tables in the FROM list user optimizer
* overrides. This ordering of table is going to require us to do sorting.
* This forced sorting returns the correct result order.
*/
public void testForceSortWithOptimizerOverrides() throws SQLException {
Statement s = createStatement();
String sql1 = "SELECT table1.id, m0.value, m1.value " +
"FROM --DERBY-PROPERTIES joinOrder=FIXED \n"+
"table2 m0, table2 m1, table1 "+
"WHERE table1.id=m0.id AND m0.name='PageSequenceId' "+
"AND table1.id=m1.id AND m1.name='PostComponentId' "+
"AND m1.value='21857' ORDER BY m0.value";
s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
ResultSet rs = s.executeQuery(sql1);
RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.usedTableScan("TABLE2"));
assertTrue(rtsp.whatSortingRequired());
rs = s.executeQuery(sql1);
String[][] result = {
{"4294967297", "000001", "21857"},
{"2147483653", "000002", "21857"},
{"2147483654", "000003", "21857"}};
JDBC.assertFullResultSet(rs, result);
}
/**
* Following sql with no overrides also demonstrates the bug where we are
* returning the results in wrong order
*/
public void testWithNoOptimizerOverrides() throws SQLException {
Statement s = createStatement();
String sql1 = "SELECT table1.id, m0.value, m1.value FROM table1, " +
"table2 m0, table2 m1 WHERE table1.id=m0.id AND " +
"m0.name='PageSequenceId' AND table1.id=m1.id AND " +
"m1.name='PostComponentId' AND m1.value='21857' " +
"ORDER BY m0.value";
s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
ResultSet rs = s.executeQuery(sql1);
RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
assertTrue(rtsp.usedSpecificIndexForIndexScan("TABLE2","KEY3"));
assertTrue(rtsp.whatSortingRequired());
rs = s.executeQuery(sql1);
String[][] result = {
{"4294967297", "000001", "21857"},
{"2147483653", "000002", "21857"},
{"2147483654", "000003", "21857"}};
JDBC.assertFullResultSet(rs, result);
}
/**
* Test for forcing the index use using optimizer override. This will
* demonstrate the bug where we are returning the results in wrong order
*/
public void testForcedIndexUseForWrongOrder() throws SQLException {
Statement s = createStatement();
String sql1 = "SELECT table1.id, m0.value, m1.value \n" +
"FROM --DERBY-PROPERTIES joinOrder=FIXED \n" +
"table2 m1 -- DERBY-PROPERTIES index=key3 \n" +
", table2 m0 -- DERBY-PROPERTIES index=key3 \n"+
", table1 " +
"WHERE table1.id=m0.id AND m0.name='PageSequenceId' "+
"AND table1.id=m1.id AND m1.name='PostComponentId' AND "+
" m1.value='21857' ORDER BY m0.value";
s.execute("call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
ResultSet rs = s.executeQuery(sql1);
RuntimeStatisticsParser rtsp = SQLUtilities.getRuntimeStatisticsParser(
s);
assertTrue(rtsp.usedSpecificIndexForIndexScan("TABLE2","KEY3"));
assertTrue(rtsp.whatSortingRequired());
rs = s.executeQuery(sql1);
String[][] result = {
{"4294967297", "000001", "21857"},
{"2147483653", "000002", "21857"},
{"2147483654", "000003", "21857"}};
JDBC.assertFullResultSet(rs, result);
}
/*
* DERBY-6148. Verifying that permuted join order doesn't
* erroneously give sort avoidance under certain index access
* paths.
*/
public void testDerby6148() throws SQLException {
Statement s = createStatement();
createTablesForDerby6148(s);
insertDataForDerby6148();
createIndexesForDerby6148(s);
// This query failed prior to fixing DERBY-6148
final String brokenQuery =
"SELECT t.id, t.item, title " +
" FROM d6148_tests t" +
" -- DERBY-PROPERTIES joinStrategy = NESTEDLOOP, " +
" constraint = d6148_tests_1\n" +
" , d6148_item_usage u" +
" -- DERBY-PROPERTIES joinStrategy = NESTEDLOOP," +
" constraint = d6148_item_usage_1\n" +
" WHERE username = 'MICKEY' AND " +
" u.item = t.item " +
"ORDER BY t.item, title";
// These queries worked prior to fixing DERBY-6148
final String goodQuery1 = // changed order of FROM tables here:
"SELECT t.id, t.item, title " +
" FROM d6148_item_usage u" +
" -- DERBY-PROPERTIES joinStrategy = NESTEDLOOP," +
" constraint = d6148_item_usage_1\n" +
" , d6148_tests t" +
" -- DERBY-PROPERTIES joinStrategy = NESTEDLOOP, " +
" constraint = d6148_tests_1\n" +
" WHERE username = 'MICKEY' AND " +
" u.item = t.item " +
"ORDER BY t.item, title";
final String goodQuery2 = // changed ORDER BY column to other equijoin
// predicate column
"SELECT t.id, t.item, title " +
" FROM d6148_tests t" +
" -- DERBY-PROPERTIES joinStrategy = NESTEDLOOP, " +
" constraint = d6148_tests_1\n" +
" , d6148_item_usage u" +
" -- DERBY-PROPERTIES joinStrategy = NESTEDLOOP," +
" constraint = d6148_item_usage_1\n" +
" WHERE username = 'MICKEY' AND " +
" u.item = t.item " +
"ORDER BY u.item, title";
final String[][] expectedRows = getExpectedRowsDerby6148();
JDBC.assertFullResultSet(s.executeQuery(brokenQuery), expectedRows);
JDBC.assertFullResultSet(s.executeQuery(goodQuery1), expectedRows);
JDBC.assertFullResultSet(s.executeQuery(goodQuery2), expectedRows);
}
private String[][] getExpectedRowsDerby6148() {
return new String[][]{
{"15", "60001", "Test 15 "},
{"19", "60001", "Test 19 "},
{"25", "60001", "Test 25 "},
{"27", "60001", "Test 27 "},
{"28", "60001", "Test 28 "},
{"10", "61303", "Test 10 "},
{"11", "61303", "Test 11 "},
{"13", "61303", "Test 13 "},
{"14", "61303", "Test 14 "},
{"21", "61303", "Test 21 "},
{"35", "61303", "Test 35 "},
{"9", "61303", "Test 9 "},
{"26", "7205731", "Test 26 "},
{"32", "7205731", "Test 32 "},
{"4", "7205731", "Test 4 "},
{"5", "7205731", "Test 5 "},
{"6", "7205731", "Test 6 "},
{"7", "7205731", "Test 7 "},
{"8", "7205731", "Test 8 "},
{"1", "XY101", "Test 1 "},
{"12", "XY101", "Test 12 "},
{"16", "XY101", "Test 16 "},
{"17", "XY101", "Test 17 "},
{"18", "XY101", "Test 18 "},
{"2", "XY101", "Test 2 "},
{"22", "XY101", "Test 22 "},
{"23", "XY101", "Test 23 "},
{"24", "XY101", "Test 24 "},
{"3", "XY101", "Test 3 "},
{"31", "XY101", "Test 31 "}};
}
private void createTablesForDerby6148(Statement s) throws SQLException {
s.executeUpdate(
"create table d6148_tests (" +
" id integer not null generated always as identity " +
" (start with 1, increment by 1), " +
" item varchar(15) not null, " +
" title varchar(255) not null)");
s.executeUpdate(
"create table d6148_item_usage (" +
" username varchar(15) not null, " +
" item varchar(15) not null, " +
" value smallint default 0)");
s.executeUpdate(
"create table d6148_items (" +
" item varchar(15) not null, " +
" name varchar(255) not null, " +
" special char(1) default null)");
s.executeUpdate(
"create table d6148_users (" +
" username varchar(15) not null, " +
" surname varchar(255) not null)");
}
private void createIndexesForDerby6148(Statement s) throws SQLException {
// Create primary/unique indexes
s.executeUpdate(
"alter table d6148_items add constraint " +
" d6148_items_pk primary key (item)");
s.executeUpdate(
"alter table d6148_item_usage add constraint " +
" d6148_item_usage_pk primary key (username, item)");
s.executeUpdate(
"alter table d6148_users add constraint " +
" users_pk primary key (username)");
s.executeUpdate(
"alter table d6148_tests add constraint " +
" d6148_tests_pk primary key (id)");
s.executeUpdate(
"alter table d6148_tests add constraint " +
" d6148_tests_1 unique (item, title)");
// Add foreign key constraints
s.executeUpdate(
"alter table d6148_item_usage add constraint " +
" d6148_item_usage_2 foreign key (item) references " +
" d6148_items (item) on delete cascade on update no action");
s.executeUpdate(
"alter table d6148_item_usage add constraint " +
" d6148_item_usage_1 foreign key (username) references " +
" d6148_users (username) on delete cascade on update no action");
s.executeUpdate(
"alter table d6148_tests add constraint " +
" d6148_tests_2 foreign key (item) references " +
" d6148_items (item) on delete cascade on update no action");
}
private void insertDataForDerby6148() throws SQLException {
String[][] users = {
{"ADMIN","Administrator"},
{"MINNIE","MOUSE"},
{"MICKEY","MOUSE"},
{"TEST","Test"},
{"PIED","Piper"},
{"WINNIE","Pooh"},
{"DONALD","Duck"},
{"CLARK","Kent"},
{"VARG","Veum"},
{"TOMMY","Tiger"},
{"USER1","?????"},
{"DEMO","Demo"},
{"BRAM","Stoker"},
{"USER2","???????"},
{"USER3","?????"}};
PreparedStatement ps = prepareStatement(
"insert into d6148_users values (?,?)");
for (String[] u : users) {
ps.setString(1, u[0]);
ps.setString(2, u[1]);
ps.executeUpdate();
}
String[][] items = {
{"XY101","XY101", null},
{"61303","61303", null},
{"7205731","7205731", null},
{"60001","60001", null},
{"60001B","60001B", null},
{"61108","61108", null}};
ps = prepareStatement(
"insert into d6148_items values (?,?,?)");
for (String[] i : items) {
ps.setString(1, i[0]);
ps.setString(2, i[1]);
ps.setString(3, i[2]);
ps.executeUpdate();
}
String[][] tests = {
{"XY101","Test 1 "},
{"XY101","Test 2 "},
{"XY101","Test 3 "},
{"7205731","Test 4 "},
{"7205731","Test 5 "},
{"7205731","Test 6 "},
{"7205731","Test 7 "},
{"7205731","Test 8 "},
{"61303","Test 9 "},
{"61303","Test 10 "},
{"61303","Test 11 "},
{"XY101","Test 12 "},
{"61303","Test 13 "},
{"61303","Test 14 "},
{"60001","Test 15 "},
{"XY101","Test 16 "},
{"XY101","Test 17 "},
{"XY101","Test 18 "},
{"60001","Test 19 "},
{"60001B","Test 20 "},
{"61303","Test 21 "},
{"XY101","Test 22 "},
{"XY101","Test 23 "},
{"XY101","Test 24 "},
{"60001","Test 25 "},
{"7205731","Test 26 "},
{"60001","Test 27 "},
{"60001","Test 28 "},
{"60001B","Test 29 "},
{"60001B","Test 30 "},
{"XY101","Test 31 "},
{"7205731","Test 32 "},
{"60001B","Test 33 "},
{"60001B","Test 34 "},
{"61303","Test 35 "}};
ps = prepareStatement(
"insert into d6148_tests values (default,?,?)");
for (String[] t : tests) {
ps.setString(1, t[0]);
ps.setString(2, t[1]);
ps.executeUpdate();
}
String[][] item_usage = {
{"MINNIE","XY101","4"},
{"MICKEY","XY101","4"},
{"MICKEY","61303","4"},
{"MICKEY","7205731","4"},
{"PIED","61303","2"},
{"TOMMY","60001","1"},
{"USER1","60001","0"},
{"BRAM","60001","2"},
{"WINNIE","7205731","1"},
{"MICKEY","60001","4"},
{"DONALD","60001","2"},
{"PIED","60001","2"},
{"VARG","60001","2"},
{"CLARK","60001","2"},
{"TEST","60001B","0"},
{"DEMO","61303","0"},
{"DONALD","61303","2"},
{"DONALD","60001B","4"},
{"DEMO","XY101","0"},
{"USER2","61303","0"},
{"USER3","61303","0"},
{"MICKEY","61108","4"},
{"MINNIE","60001B","0"}};
ps = prepareStatement(
"insert into d6148_item_usage values (?,?,?)");
for (String[] iu : item_usage) {
ps.setString(1, iu[0]);
ps.setString(2, iu[1]);
ps.setString(3, iu[2]);
ps.executeUpdate();
}
}
}