methods/cart/src/pg_gp/sql/rf_test.sql_in

m4_include(`SQLCommon.m4')

DROP TABLE IF EXISTS golf_dt_test;
CREATE TABLE golf_dt_test (
    id          INT,
    outlook     TEXT,
    temperature DOUBLE PRECISION,
    humidity    DOUBLE PRECISION,
    windy       TEXT,
    class       TEXT
) m4_ifdef(`__POSTGRESQL__', `', `DISTRIBUTED BY (id)');

INSERT INTO golf_dt_test VALUES (1, 'sunny', 85, 85, ' false', ' Do not Play');
INSERT INTO golf_dt_test VALUES (3, 'overcast', 83, 78, ' false', ' Play');
INSERT INTO golf_dt_test VALUES (5, 'rain', 68, 80, ' false', ' Play');
INSERT INTO golf_dt_test VALUES (7, 'overcast', 64, 65, ' true', ' Play');
INSERT INTO golf_dt_test VALUES (9, 'sunny', 69, 70, ' false', ' Play');
INSERT INTO golf_dt_test VALUES (11, 'sunny', 75, 70, ' true', ' Play');
INSERT INTO golf_dt_test VALUES (13, 'overcast', 81, 75, ' false', ' Play');
INSERT INTO golf_dt_test VALUES (2, 'sunny', 80, 90, ' true', ' Do not Play');
INSERT INTO golf_dt_test VALUES (4, 'rain', 70, 96, ' false', ' Play');
INSERT INTO golf_dt_test VALUES (6, 'rain', 65, 70, ' true', ' Do not Play');
INSERT INTO golf_dt_test VALUES (8, 'sunny', 72, 95, ' false', ' Do not Play');
INSERT INTO golf_dt_test VALUES (10, 'rain', 75, 80, ' false', ' Play');
INSERT INTO golf_dt_test VALUES (12, 'overcast', 72, 90, ' true', ' Play');
INSERT INTO golf_dt_test VALUES (14, 'rain', 71, 80, ' true', ' Do not Play');

DROP TABLE IF EXISTS crx_dt_test;
CREATE TABLE crx_dt_test (
    id      INTEGER,
    a1      TEXT,
    a2      DOUBLE PRECISION,
    a3      DOUBLE PRECISION,
    a4      TEXT,
    a5      TEXT,
    a6      TEXT,
    a7      TEXT,
    a8      DOUBLE PRECISION,
    a9      TEXT,
    a10     TEXT,
    a11     DOUBLE PRECISION,
    a12     TEXT,
    a13     TEXT,
    a14     DOUBLE PRECISION,
    a15     DOUBLE PRECISION,
    a16     TEXT
) m4_ifdef(`__POSTGRESQL__', `', `DISTRIBUTED BY (id)');

INSERT INTO crx_dt_test VALUES (2, 'a', 58.670000000000002, 4.46, 'u', 'g', 'q', 'h', 3.04, 't', 't', 6, 'f', 'g', 43, 560, '+');
INSERT INTO crx_dt_test VALUES (4, 'b', 27.829999999999998, 1.54, 'u', 'g', 'w', 'v', 3.75, 't', 't', 5, 't', 'g', 100, 3, '+');
INSERT INTO crx_dt_test VALUES (6, 'b', 32.079999999999998, 4, 'u', 'g', 'm', 'v', 2.5, 't', 'f', 0, 't', 'g', 360, 0, '+');
INSERT INTO crx_dt_test VALUES (8, 'a', 22.920000000000002, 11.585000000000001, 'u', 'g', 'cc', 'v', 0.040000000000000001, 't', 'f', 0, 'f', 'g', 80, 1349, '+');
INSERT INTO crx_dt_test VALUES (10, 'b', 42.5, 4.915, 'y', 'p', 'w', 'v', 3.165, 't', 'f', 0, 't', 'g', 52, 1442, '+');
INSERT INTO crx_dt_test VALUES (12, 'b', 29.920000000000002, 1.835, 'u', 'g', 'c', 'h', 4.335, 't', 'f', 0, 'f', 'g', 260, 200, '+');
INSERT INTO crx_dt_test VALUES (14, 'b', 48.079999999999998, 6.04, 'u', 'g', 'k', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 0, 2690, '+');
INSERT INTO crx_dt_test VALUES (16, 'b', 36.670000000000002, 4.415, 'y', 'p', 'k', 'v', 0.25, 't', 't', 10, 't', 'g', 320, 0, '+');
INSERT INTO crx_dt_test VALUES (18, 'a', 23.25, 5.875, 'u', 'g', 'q', 'v', 3.1699999999999999, 't', 't', 10, 'f', 'g', 120, 245, '+');
INSERT INTO crx_dt_test VALUES (20, 'a', 19.170000000000002, 8.5850000000000009, 'u', 'g', 'cc', 'h', 0.75, 't', 't', 7, 'f', 'g', 96, 0, '+');
INSERT INTO crx_dt_test VALUES (22, 'b', 23.25, 1, 'u', 'g', 'c', 'v', 0.83499999999999996, 't', 'f', 0, 'f', 's', 300, 0, '+');
INSERT INTO crx_dt_test VALUES (24, 'a', 27.420000000000002, 14.5, 'u', 'g', 'x', 'h', 3.085, 't', 't', 1, 'f', 'g', 120, 11, '+');
INSERT INTO crx_dt_test VALUES (26, 'a', 15.83, 0.58499999999999996, 'u', 'g', 'c', 'h', 1.5, 't', 't', 2, 'f', 'g', 100, 0, '+');
INSERT INTO crx_dt_test VALUES (28, 'b', 56.579999999999998, 18.5, 'u', 'g', 'd', 'bb', 15, 't', 't', 17, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (30, 'b', 42.079999999999998, 1.04, 'u', 'g', 'w', 'v', 5, 't', 't', 6, 't', 'g', 500, 10000, '+');
INSERT INTO crx_dt_test VALUES (32, 'b', 42, 9.7899999999999991, 'u', 'g', 'x', 'h', 7.96, 't', 't', 8, 'f', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (34, 'a', 36.75, 5.125, 'u', 'g', 'e', 'v', 5, 't', 'f', 0, 't', 'g', 0, 4000, '+');
INSERT INTO crx_dt_test VALUES (36, 'b', 27.829999999999998, 1.5, 'u', 'g', 'w', 'v', 2, 't', 't', 11, 't', 'g', 434, 35, '+');
INSERT INTO crx_dt_test VALUES (38, 'a', 23, 11.75, 'u', 'g', 'x', 'h', 0.5, 't', 't', 2, 't', 'g', 300, 551, '+');
INSERT INTO crx_dt_test VALUES (40, 'b', 54.579999999999998, 9.4149999999999991, 'u', 'g', 'ff', 'ff', 14.414999999999999, 't', 't', 11, 't', 'g', 30, 300, '+');
INSERT INTO crx_dt_test VALUES (42, 'b', 28.920000000000002, 15, 'u', 'g', 'c', 'h', 5.335, 't', 't', 11, 'f', 'g', 0, 2283, '+');
INSERT INTO crx_dt_test VALUES (44, 'b', 39.579999999999998, 13.914999999999999, 'u', 'g', 'w', 'v', 8.625, 't', 't', 6, 't', 'g', 70, 0, '+');
INSERT INTO crx_dt_test VALUES (46, 'b', 54.329999999999998, 6.75, 'u', 'g', 'c', 'h', 2.625, 't', 't', 11, 't', 'g', 0, 284, '+');
INSERT INTO crx_dt_test VALUES (48, 'b', 31.920000000000002, 4.46, 'u', 'g', 'cc', 'h', 6.04, 't', 't', 3, 'f', 'g', 311, 300, '+');
INSERT INTO crx_dt_test VALUES (50, 'b', 23.920000000000002, 0.66500000000000004, 'u', 'g', 'c', 'v', 0.16500000000000001, 'f', 'f', 0, 'f', 'g', 100, 0, '+');
INSERT INTO crx_dt_test VALUES (52, 'b', 26, 1, 'u', 'g', 'q', 'v', 1.75, 't', 'f', 0, 't', 'g', 280, 0, '+');
INSERT INTO crx_dt_test VALUES (54, 'b', 34.920000000000002, 2.5, 'u', 'g', 'w', 'v', 0, 't', 'f', 0, 't', 'g', 239, 200, '+');
INSERT INTO crx_dt_test VALUES (56, 'b', 23.329999999999998, 11.625, 'y', 'p', 'w', 'v', 0.83499999999999996, 't', 'f', 0, 't', 'g', 160, 300, '+');
INSERT INTO crx_dt_test VALUES (58, 'b', 44.329999999999998, 0.5, 'u', 'g', 'i', 'h', 5, 't', 'f', 0, 't', 'g', 320, 0, '+');
INSERT INTO crx_dt_test VALUES (60, 'b', 43.25, 3, 'u', 'g', 'q', 'h', 6, 't', 't', 11, 'f', 'g', 80, 0, '+');
INSERT INTO crx_dt_test VALUES (62, 'b', 31.670000000000002, 16.164999999999999, 'u', 'g', 'd', 'v', 3, 't', 't', 9, 'f', 'g', 250, 730, '+');
INSERT INTO crx_dt_test VALUES (64, 'a', 20.420000000000002, 0.83499999999999996, 'u', 'g', 'q', 'v', 1.585, 't', 't', 1, 'f', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (66, 'b', 34.170000000000002, 1.54, 'u', 'g', 'cc', 'v', 1.54, 't', 't', 1, 't', 'g', 520, 50000, '+');
INSERT INTO crx_dt_test VALUES (68, 'b', 25.5, 0.375, 'u', 'g', 'm', 'v', 0.25, 't', 't', 3, 'f', 'g', 260, 15108, '+');
INSERT INTO crx_dt_test VALUES (70, 'b', 35.170000000000002, 25.125, 'u', 'g', 'x', 'h', 1.625, 't', 't', 1, 't', 'g', 515, 500, '+');
INSERT INTO crx_dt_test VALUES (72, 'b', 34.829999999999998, 4, 'u', 'g', 'd', 'bb', 12.5, 't', 'f', 0, 't', 'g', NULL, 0, '-');
INSERT INTO crx_dt_test VALUES (74, 'b', 44.25, 0.5, 'u', 'g', 'm', 'v', 10.75, 't', 'f', 0, 'f', 's', 400, 0, '-');
INSERT INTO crx_dt_test VALUES (76, 'b', 20.670000000000002, 5.29, 'u', 'g', 'q', 'v', 0.375, 't', 't', 1, 'f', 'g', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (78, 'a', 19.170000000000002, 0.58499999999999996, 'y', 'p', 'aa', 'v', 0.58499999999999996, 't', 'f', 0, 't', 'g', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (80, 'b', 21.5, 9.75, 'u', 'g', 'c', 'v', 0.25, 't', 'f', 0, 'f', 'g', 140, 0, '-');
INSERT INTO crx_dt_test VALUES (82, 'a', 27.670000000000002, 1.5, 'u', 'g', 'm', 'v', 2, 't', 'f', 0, 'f', 's', 368, 0, '-');
INSERT INTO crx_dt_test VALUES (84, 'a', NULL, 3.5, 'u', 'g', 'd', 'v', 3, 't', 'f', 0, 't', 'g', 300, 0, '-');
INSERT INTO crx_dt_test VALUES (86, 'b', 37.170000000000002, 4, 'u', 'g', 'c', 'bb', 5, 't', 'f', 0, 't', 's', 280, 0, '-');
INSERT INTO crx_dt_test VALUES (88, 'b', 25.670000000000002, 2.21, 'y', 'p', 'aa', 'v', 4, 't', 'f', 0, 'f', 'g', 188, 0, '-');
INSERT INTO crx_dt_test VALUES (90, 'a', 49, 1.5, 'u', 'g', 'j', 'j', 0, 't', 'f', 0, 't', 'g', 100, 27, '-');
INSERT INTO crx_dt_test VALUES (92, 'b', 31.420000000000002, 15.5, 'u', 'g', 'c', 'v', 0.5, 't', 'f', 0, 'f', 'g', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (94, 'b', 52.329999999999998, 1.375, 'y', 'p', 'c', 'h', 9.4600000000000009, 't', 'f', 0, 't', 'g', 200, 100, '-');
INSERT INTO crx_dt_test VALUES (96, 'a', 28.579999999999998, 3.54, 'u', 'g', 'i', 'bb', 0.5, 't', 'f', 0, 't', 'g', 171, 0, '-');
INSERT INTO crx_dt_test VALUES (98, 'b', NULL, 0.5, 'u', 'g', 'c', 'bb', 0.83499999999999996, 't', 'f', 0, 't', 's', 320, 0, '-');
INSERT INTO crx_dt_test VALUES (100, 'a', 28.5, 1, 'u', 'g', 'q', 'v', 1, 't', 't', 2, 't', 'g', 167, 500, '-');
INSERT INTO crx_dt_test VALUES (102, 'b', 35.25, 16.5, 'y', 'p', 'c', 'v', 4, 't', 'f', 0, 'f', 'g', 80, 0, '-');
INSERT INTO crx_dt_test VALUES (104, 'b', 25, 12, 'u', 'g', 'k', 'v', 2.25, 't', 't', 2, 't', 'g', 120, 5, '-');
INSERT INTO crx_dt_test VALUES (106, 'b', 54.829999999999998, 15.5, 'u', 'g', 'e', 'z', 0, 't', 't', 20, 'f', 'g', 152, 130, '-');
INSERT INTO crx_dt_test VALUES (108, 'a', 25, 11, 'y', 'p', 'aa', 'v', 4.5, 't', 'f', 0, 'f', 'g', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (110, 'a', 19.75, 0.75, 'u', 'g', 'c', 'v', 0.79500000000000004, 't', 't', 5, 't', 'g', 140, 5, '-');
INSERT INTO crx_dt_test VALUES (112, 'a', 24.5, 1.04, 'y', 'p', 'ff', 'ff', 0.5, 't', 't', 3, 'f', 'g', 180, 147, '-');
INSERT INTO crx_dt_test VALUES (114, 'a', 33.75, 0.75, 'u', 'g', 'k', 'bb', 1, 't', 't', 3, 't', 'g', 212, 0, '-');
INSERT INTO crx_dt_test VALUES (116, 'a', 25.420000000000002, 1.125, 'u', 'g', 'q', 'v', 1.29, 't', 't', 2, 'f', 'g', 200, 0, '-');
INSERT INTO crx_dt_test VALUES (118, 'b', 52.5, 6.5, 'u', 'g', 'k', 'v', 6.29, 't', 't', 15, 'f', 'g', 0, 11202, '+');
INSERT INTO crx_dt_test VALUES (120, 'a', 20.75, 10.335000000000001, 'u', 'g', 'cc', 'h', 0.33500000000000002, 't', 't', 1, 't', 'g', 80, 50, '+');
INSERT INTO crx_dt_test VALUES (122, 'b', 25.670000000000002, 12.5, 'u', 'g', 'cc', 'v', 1.21, 't', 't', 67, 't', 'g', 140, 258, '+');
INSERT INTO crx_dt_test VALUES (124, 'a', 44.170000000000002, 6.665, 'u', 'g', 'q', 'v', 7.375, 't', 't', 3, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (126, 'b', 34.920000000000002, 5, 'u', 'g', 'x', 'h', 7.5, 't', 't', 6, 't', 'g', 0, 1000, '+');
INSERT INTO crx_dt_test VALUES (128, 'b', 22.75, 11, 'u', 'g', 'q', 'v', 2.5, 't', 't', 7, 't', 'g', 100, 809, '+');
INSERT INTO crx_dt_test VALUES (130, 'a', 28.420000000000002, 3.5, 'u', 'g', 'w', 'v', 0.83499999999999996, 't', 'f', 0, 'f', 's', 280, 0, '+');
INSERT INTO crx_dt_test VALUES (132, 'b', 20.420000000000002, 1.835, 'u', 'g', 'c', 'v', 2.25, 't', 't', 1, 'f', 'g', 100, 150, '+');
INSERT INTO crx_dt_test VALUES (134, 'b', 36.25, 5, 'u', 'g', 'c', 'bb', 2.5, 't', 't', 6, 'f', 'g', 0, 367, '+');
INSERT INTO crx_dt_test VALUES (136, 'b', 48.579999999999998, 6.5, 'u', 'g', 'q', 'h', 6, 't', 'f', 0, 't', 'g', 350, 0, '+');
INSERT INTO crx_dt_test VALUES (138, 'b', 33.579999999999998, 2.75, 'u', 'g', 'm', 'v', 4.25, 't', 't', 6, 'f', 'g', 204, 0, '+');
INSERT INTO crx_dt_test VALUES (140, 'a', 26.920000000000002, 13.5, 'u', 'g', 'q', 'h', 5, 't', 't', 2, 'f', 'g', 0, 5000, '+');
INSERT INTO crx_dt_test VALUES (142, 'a', 56.5, 16, 'u', 'g', 'j', 'ff', 0, 't', 't', 15, 'f', 'g', 0, 247, '+');
INSERT INTO crx_dt_test VALUES (144, 'b', 22.329999999999998, 11, 'u', 'g', 'w', 'v', 2, 't', 't', 1, 'f', 'g', 80, 278, '+');
INSERT INTO crx_dt_test VALUES (146, 'b', 32.829999999999998, 2.5, 'u', 'g', 'cc', 'h', 2.75, 't', 't', 6, 'f', 'g', 160, 2072, '+');
INSERT INTO crx_dt_test VALUES (148, 'a', 40.329999999999998, 7.54, 'y', 'p', 'q', 'h', 8, 't', 't', 14, 'f', 'g', 0, 2300, '+');
INSERT INTO crx_dt_test VALUES (150, 'a', 52.829999999999998, 15, 'u', 'g', 'c', 'v', 5.5, 't', 't', 14, 'f', 'g', 0, 2200, '+');
INSERT INTO crx_dt_test VALUES (152, 'a', 58.329999999999998, 10, 'u', 'g', 'q', 'v', 4, 't', 't', 14, 'f', 'g', 0, 1602, '+');
INSERT INTO crx_dt_test VALUES (154, 'b', 23.079999999999998, 2.5, 'u', 'g', 'c', 'v', 1.085, 't', 't', 11, 't', 'g', 60, 2184, '+');
INSERT INTO crx_dt_test VALUES (156, 'a', 21.670000000000002, 11.5, 'y', 'p', 'j', 'j', 0, 't', 't', 11, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (158, 'a', 68.670000000000002, 15, 'u', 'g', 'e', 'z', 0, 't', 't', 14, 'f', 'g', 0, 3376, '+');
INSERT INTO crx_dt_test VALUES (160, 'b', 34.079999999999998, 0.080000000000000002, 'y', 'p', 'm', 'bb', 0.040000000000000001, 't', 't', 1, 't', 'g', 280, 2000, '+');
INSERT INTO crx_dt_test VALUES (162, 'b', 44, 2, 'u', 'g', 'm', 'v', 1.75, 't', 't', 2, 't', 'g', 0, 15, '+');
INSERT INTO crx_dt_test VALUES (164, 'b', 32, 1.75, 'y', 'p', 'e', 'h', 0.040000000000000001, 't', 'f', 0, 't', 'g', 393, 0, '+');
INSERT INTO crx_dt_test VALUES (166, 'a', 40.829999999999998, 10, 'u', 'g', 'q', 'h', 1.75, 't', 'f', 0, 'f', 'g', 29, 837, '+');
INSERT INTO crx_dt_test VALUES (168, 'a', 32.329999999999998, 0.54000000000000004, 'u', 'g', 'cc', 'v', 0.040000000000000001, 't', 'f', 0, 'f', 'g', 440, 11177, '+');
INSERT INTO crx_dt_test VALUES (170, 'b', 37.5, 1.125, 'y', 'p', 'd', 'v', 1.5, 'f', 'f', 0, 't', 'g', 431, 0, '+');
INSERT INTO crx_dt_test VALUES (172, 'b', 41.329999999999998, 0, 'u', 'g', 'c', 'bb', 15, 't', 'f', 0, 'f', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (174, 'a', 49.829999999999998, 13.585000000000001, 'u', 'g', 'k', 'h', 8.5, 't', 'f', 0, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (176, 'b', 27, 1.5, 'y', 'p', 'w', 'v', 0.375, 't', 'f', 0, 't', 'g', 260, 1065, '+');
INSERT INTO crx_dt_test VALUES (178, 'a', 26.079999999999998, 8.6649999999999991, 'u', 'g', 'aa', 'v', 1.415, 't', 'f', 0, 'f', 'g', 160, 150, '+');
INSERT INTO crx_dt_test VALUES (180, 'b', 20.170000000000002, 8.1699999999999999, 'u', 'g', 'aa', 'v', 1.96, 't', 't', 14, 'f', 'g', 60, 158, '+');
INSERT INTO crx_dt_test VALUES (182, 'a', 21.25, 2.335, 'u', 'g', 'i', 'bb', 0.5, 't', 't', 4, 'f', 's', 80, 0, '+');
INSERT INTO crx_dt_test VALUES (184, 'a', 57.079999999999998, 19.5, 'u', 'g', 'c', 'v', 5.5, 't', 't', 7, 'f', 'g', 0, 3000, '+');
INSERT INTO crx_dt_test VALUES (186, 'b', 48.75, 8.5, 'u', 'g', 'c', 'h', 12.5, 't', 't', 9, 'f', 'g', 181, 1655, '+');
INSERT INTO crx_dt_test VALUES (188, 'b', 40.579999999999998, 5, 'u', 'g', 'c', 'v', 5, 't', 't', 7, 'f', 'g', 0, 3065, '+');
INSERT INTO crx_dt_test VALUES (190, 'a', 33.079999999999998, 4.625, 'u', 'g', 'q', 'h', 1.625, 't', 't', 2, 'f', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (192, 'b', 42, 0.20499999999999999, 'u', 'g', 'i', 'h', 5.125, 't', 'f', 0, 'f', 'g', 400, 0, '+');
INSERT INTO crx_dt_test VALUES (194, 'b', 22.670000000000002, 1.585, 'y', 'p', 'w', 'v', 3.085, 't', 't', 6, 'f', 'g', 80, 0, '+');
INSERT INTO crx_dt_test VALUES (196, 'b', 28.25, 5.04, 'y', 'p', 'c', 'bb', 1.5, 't', 't', 8, 't', 'g', 144, 7, '+');
INSERT INTO crx_dt_test VALUES (198, 'b', 48.170000000000002, 7.625, 'u', 'g', 'w', 'h', 15.5, 't', 't', 12, 'f', 'g', 0, 790, '+');
INSERT INTO crx_dt_test VALUES (200, 'b', 22.579999999999998, 10.039999999999999, 'u', 'g', 'x', 'v', 0.040000000000000001, 't', 't', 9, 'f', 'g', 60, 396, '+');
INSERT INTO crx_dt_test VALUES (202, 'a', 41.329999999999998, 1, 'u', 'g', 'i', 'bb', 2.25, 't', 'f', 0, 't', 'g', 0, 300, '+');
INSERT INTO crx_dt_test VALUES (204, 'a', 20.75, 10.25, 'u', 'g', 'q', 'v', 0.70999999999999996, 't', 't', 2, 't', 'g', 49, 0, '+');
INSERT INTO crx_dt_test VALUES (206, 'a', 35.420000000000002, 12, 'u', 'g', 'q', 'h', 14, 't', 't', 8, 'f', 'g', 0, 6590, '+');
INSERT INTO crx_dt_test VALUES (208, 'b', 28.670000000000002, 9.3350000000000009, 'u', 'g', 'q', 'h', 5.665, 't', 't', 6, 'f', 'g', 381, 168, '+');
INSERT INTO crx_dt_test VALUES (210, 'b', 39.5, 4.25, 'u', 'g', 'c', 'bb', 6.5, 't', 't', 16, 'f', 'g', 117, 1210, '+');
INSERT INTO crx_dt_test VALUES (212, 'b', 24.329999999999998, 6.625, 'y', 'p', 'd', 'v', 5.5, 't', 'f', 0, 't', 's', 100, 0, '+');
INSERT INTO crx_dt_test VALUES (214, 'b', 23.079999999999998, 11.5, 'u', 'g', 'i', 'v', 3.5, 't', 't', 9, 'f', 'g', 56, 742, '+');
INSERT INTO crx_dt_test VALUES (216, 'b', 48.170000000000002, 3.5, 'u', 'g', 'aa', 'v', 3.5, 't', 'f', 0, 'f', 's', 230, 0, '+');
INSERT INTO crx_dt_test VALUES (218, 'b', 55.920000000000002, 11.5, 'u', 'g', 'ff', 'ff', 5, 't', 't', 5, 'f', 'g', 0, 8851, '+');
INSERT INTO crx_dt_test VALUES (220, 'a', 18.920000000000002, 9.25, 'y', 'p', 'c', 'v', 1, 't', 't', 4, 't', 'g', 80, 500, '+');
INSERT INTO crx_dt_test VALUES (222, 'b', 65.420000000000002, 11, 'u', 'g', 'e', 'z', 20, 't', 't', 7, 't', 'g', 22, 0, '+');
INSERT INTO crx_dt_test VALUES (224, 'a', 18.829999999999998, 9.5399999999999991, 'u', 'g', 'aa', 'v', 0.085000000000000006, 't', 'f', 0, 'f', 'g', 100, 0, '+');
INSERT INTO crx_dt_test VALUES (226, 'b', 23.25, 4, 'u', 'g', 'c', 'bb', 0.25, 't', 'f', 0, 't', 'g', 160, 0, '+');
INSERT INTO crx_dt_test VALUES (228, 'a', 22.5, 8.4600000000000009, 'y', 'p', 'x', 'v', 2.46, 'f', 'f', 0, 'f', 'g', 164, 0, '+');
INSERT INTO crx_dt_test VALUES (230, 'b', 22.079999999999998, 11, 'u', 'g', 'cc', 'v', 0.66500000000000004, 't', 'f', 0, 'f', 'g', 100, 0, '+');
INSERT INTO crx_dt_test VALUES (232, 'a', 47.420000000000002, 3, 'u', 'g', 'x', 'v', 13.875, 't', 't', 2, 't', 'g', 519, 1704, '+');
INSERT INTO crx_dt_test VALUES (234, 'b', 27.670000000000002, 13.75, 'u', 'g', 'w', 'v', 5.75, 't', 'f', 0, 't', 'g', 487, 500, '+');
INSERT INTO crx_dt_test VALUES (236, 'a', 20.670000000000002, 1.835, 'u', 'g', 'q', 'v', 2.085, 't', 't', 5, 'f', 'g', 220, 2503, '+');
INSERT INTO crx_dt_test VALUES (238, 'b', 21.329999999999998, 7.5, 'u', 'g', 'aa', 'v', 1.415, 't', 't', 1, 'f', 'g', 80, 9800, '+');
INSERT INTO crx_dt_test VALUES (240, 'b', 38.170000000000002, 10.125, 'u', 'g', 'x', 'v', 2.5, 't', 't', 6, 'f', 'g', 520, 196, '+');
INSERT INTO crx_dt_test VALUES (242, 'b', 48.25, 25.085000000000001, 'u', 'g', 'w', 'v', 1.75, 't', 't', 3, 'f', 'g', 120, 14, '+');
INSERT INTO crx_dt_test VALUES (244, 'a', 18.75, 7.5, 'u', 'g', 'q', 'v', 2.71, 't', 't', 5, 'f', 'g', NULL, 26726, '+');
INSERT INTO crx_dt_test VALUES (246, 'b', 33.170000000000002, 3.04, 'y', 'p', 'c', 'h', 2.04, 't', 't', 1, 't', 'g', 180, 18027, '+');
INSERT INTO crx_dt_test VALUES (248, 'a', 19.670000000000002, 0.20999999999999999, 'u', 'g', 'q', 'h', 0.28999999999999998, 't', 't', 11, 'f', 'g', 80, 99, '+');
INSERT INTO crx_dt_test VALUES (250, 'b', 21.829999999999998, 11, 'u', 'g', 'x', 'v', 0.28999999999999998, 't', 't', 6, 'f', 'g', 121, 0, '+');
INSERT INTO crx_dt_test VALUES (252, 'b', 41.420000000000002, 5, 'u', 'g', 'q', 'h', 5, 't', 't', 6, 't', 'g', 470, 0, '+');
INSERT INTO crx_dt_test VALUES (254, 'b', 23.170000000000002, 11.125, 'u', 'g', 'x', 'h', 0.46000000000000002, 't', 't', 1, 'f', 'g', 100, 0, '+');
INSERT INTO crx_dt_test VALUES (257, 'b', 20, 11.045, 'u', 'g', 'c', 'v', 2, 'f', 'f', 0, 't', 'g', 136, 0, '-');
INSERT INTO crx_dt_test VALUES (259, 'a', 20.75, 9.5399999999999991, 'u', 'g', 'i', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 200, 1000, '-');
INSERT INTO crx_dt_test VALUES (261, 'b', 32.75, 2.335, 'u', 'g', 'd', 'h', 5.75, 'f', 'f', 0, 't', 'g', 292, 0, '-');
INSERT INTO crx_dt_test VALUES (263, 'a', 48.170000000000002, 1.335, 'u', 'g', 'i', 'o', 0.33500000000000002, 'f', 'f', 0, 'f', 'g', 0, 120, '-');
INSERT INTO crx_dt_test VALUES (265, 'b', 50.75, 0.58499999999999996, 'u', 'g', 'ff', 'ff', 0, 'f', 'f', 0, 'f', 'g', 145, 0, '-');
INSERT INTO crx_dt_test VALUES (267, 'b', 18.329999999999998, 1.21, 'y', 'p', 'e', 'dd', 0, 'f', 'f', 0, 'f', 'g', 100, 0, '-');
INSERT INTO crx_dt_test VALUES (269, 'b', 59.670000000000002, 1.54, 'u', 'g', 'q', 'v', 0.125, 't', 'f', 0, 't', 'g', 260, 0, '+');
INSERT INTO crx_dt_test VALUES (271, 'b', 37.579999999999998, 0, NULL, NULL, NULL, NULL, 0, 'f', 'f', 0, 'f', 'p', NULL, 0, '+');
INSERT INTO crx_dt_test VALUES (273, 'b', 18.079999999999998, 6.75, 'y', 'p', 'm', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 140, 0, '-');
INSERT INTO crx_dt_test VALUES (275, 'b', 30.670000000000002, 2.5, 'u', 'g', 'cc', 'h', 2.25, 'f', 'f', 0, 't', 's', 340, 0, '-');
INSERT INTO crx_dt_test VALUES (277, 'a', 19.170000000000002, 5.415, 'u', 'g', 'i', 'h', 0.28999999999999998, 'f', 'f', 0, 'f', 'g', 80, 484, '-');
INSERT INTO crx_dt_test VALUES (279, 'b', 24.579999999999998, 13.5, 'y', 'p', 'ff', 'ff', 0, 'f', 'f', 0, 'f', 'g', NULL, 0, '-');
INSERT INTO crx_dt_test VALUES (281, 'b', 21.170000000000002, 0.875, 'y', 'p', 'c', 'h', 0.25, 'f', 'f', 0, 'f', 'g', 280, 204, '-');
INSERT INTO crx_dt_test VALUES (283, 'b', 17.670000000000002, 4.46, 'u', 'g', 'c', 'v', 0.25, 'f', 'f', 0, 'f', 's', 80, 0, '-');
INSERT INTO crx_dt_test VALUES (285, 'b', 23.25, 12.625, 'u', 'g', 'c', 'v', 0.125, 'f', 't', 2, 'f', 'g', 0, 5552, '-');
INSERT INTO crx_dt_test VALUES (287, 'a', NULL, 1.5, 'u', 'g', 'ff', 'ff', 0, 'f', 't', 2, 't', 'g', 200, 105, '-');
INSERT INTO crx_dt_test VALUES (289, 'b', 18.829999999999998, 0.41499999999999998, 'y', 'p', 'c', 'v', 0.16500000000000001, 'f', 't', 1, 'f', 'g', 200, 1, '-');
INSERT INTO crx_dt_test VALUES (291, 'b', 23, 0.75, 'u', 'g', 'm', 'v', 0.5, 'f', 'f', 0, 't', 's', 320, 0, '-');
INSERT INTO crx_dt_test VALUES (293, 'b', 25.420000000000002, 0.54000000000000004, 'u', 'g', 'w', 'v', 0.16500000000000001, 'f', 't', 1, 'f', 'g', 272, 444, '-');
INSERT INTO crx_dt_test VALUES (295, 'a', 16.079999999999998, 0.33500000000000002, 'u', 'g', 'ff', 'ff', 0, 'f', 't', 1, 'f', 'g', 160, 126, '-');
INSERT INTO crx_dt_test VALUES (297, 'b', 69.170000000000002, 9, 'u', 'g', 'ff', 'ff', 4, 'f', 't', 1, 'f', 'g', 70, 6, '-');
INSERT INTO crx_dt_test VALUES (299, 'b', 16.329999999999998, 2.75, 'u', 'g', 'aa', 'v', 0.66500000000000004, 'f', 't', 1, 'f', 'g', 80, 21, '-');
INSERT INTO crx_dt_test VALUES (301, 'a', 57.579999999999998, 2, 'u', 'g', 'ff', 'ff', 6.5, 'f', 't', 1, 'f', 'g', 0, 10, '-');
INSERT INTO crx_dt_test VALUES (303, 'b', 23.420000000000002, 1, 'u', 'g', 'c', 'v', 0.5, 'f', 'f', 0, 't', 's', 280, 0, '-');
INSERT INTO crx_dt_test VALUES (305, 'a', 24.75, 13.664999999999999, 'u', 'g', 'q', 'h', 1.5, 'f', 'f', 0, 'f', 'g', 280, 1, '-');
INSERT INTO crx_dt_test VALUES (307, 'b', 23.5, 2.75, 'u', 'g', 'ff', 'ff', 4.5, 'f', 'f', 0, 'f', 'g', 160, 25, '-');
INSERT INTO crx_dt_test VALUES (309, 'b', 27.75, 1.29, 'u', 'g', 'k', 'h', 0.25, 'f', 'f', 0, 't', 's', 140, 0, '-');
INSERT INTO crx_dt_test VALUES (311, 'a', 24.829999999999998, 4.5, 'u', 'g', 'w', 'v', 1, 'f', 'f', 0, 't', 'g', 360, 6, '-');
INSERT INTO crx_dt_test VALUES (313, 'a', 16.329999999999998, 0.20999999999999999, 'u', 'g', 'aa', 'v', 0.125, 'f', 'f', 0, 'f', 'g', 200, 1, '-');
INSERT INTO crx_dt_test VALUES (315, 'b', 16.25, 0, 'y', 'p', 'aa', 'v', 0.25, 'f', 'f', 0, 'f', 'g', 60, 0, '-');
INSERT INTO crx_dt_test VALUES (317, 'b', 21.170000000000002, 0.25, 'y', 'p', 'c', 'h', 0.25, 'f', 'f', 0, 'f', 'g', 280, 204, '-');
INSERT INTO crx_dt_test VALUES (319, 'b', 19.170000000000002, 0, 'y', 'p', 'm', 'bb', 0, 'f', 'f', 0, 't', 's', 500, 1, '+');
INSERT INTO crx_dt_test VALUES (321, 'b', 21.25, 1.5, 'u', 'g', 'w', 'v', 1.5, 'f', 'f', 0, 'f', 'g', 150, 8, '+');
INSERT INTO crx_dt_test VALUES (323, 'a', 33.670000000000002, 0.375, 'u', 'g', 'cc', 'v', 0.375, 'f', 'f', 0, 'f', 'g', 300, 44, '+');
INSERT INTO crx_dt_test VALUES (325, 'b', 33.670000000000002, 1.25, 'u', 'g', 'w', 'v', 1.165, 'f', 'f', 0, 'f', 'g', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (327, 'b', 30.170000000000002, 1.085, 'y', 'p', 'c', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 170, 179, '-');
INSERT INTO crx_dt_test VALUES (329, 'b', 34.829999999999998, 2.5, 'y', 'p', 'w', 'v', 3, 'f', 'f', 0, 'f', 's', 200, 0, '-');
INSERT INTO crx_dt_test VALUES (331, 'b', 20.420000000000002, 0, NULL, NULL, NULL, NULL, 0, 'f', 'f', 0, 'f', 'p', NULL, 0, '-');
INSERT INTO crx_dt_test VALUES (333, 'b', 34.079999999999998, 2.5, 'u', 'g', 'c', 'v', 1, 'f', 'f', 0, 'f', 'g', 460, 16, '-');
INSERT INTO crx_dt_test VALUES (335, 'b', 34.75, 2.5, 'u', 'g', 'cc', 'bb', 0.5, 'f', 'f', 0, 'f', 'g', 348, 0, '-');
INSERT INTO crx_dt_test VALUES (337, 'b', 47.329999999999998, 6.5, 'u', 'g', 'c', 'v', 1, 'f', 'f', 0, 't', 'g', 0, 228, '-');
INSERT INTO crx_dt_test VALUES (339, 'a', 33.25, 3, 'y', 'p', 'aa', 'v', 2, 'f', 'f', 0, 'f', 'g', 180, 0, '-');
INSERT INTO crx_dt_test VALUES (341, 'a', 39.079999999999998, 4, 'u', 'g', 'c', 'v', 3, 'f', 'f', 0, 'f', 'g', 480, 0, '-');
INSERT INTO crx_dt_test VALUES (343, 'b', 26.920000000000002, 2.25, 'u', 'g', 'i', 'bb', 0.5, 'f', 'f', 0, 't', 'g', 640, 4000, '-');
INSERT INTO crx_dt_test VALUES (345, 'b', 38.920000000000002, 1.75, 'u', 'g', 'k', 'v', 0.5, 'f', 'f', 0, 't', 'g', 300, 2, '-');
INSERT INTO crx_dt_test VALUES (347, NULL, 32.25, 1.5, 'u', 'g', 'c', 'v', 0.25, 'f', 'f', 0, 't', 'g', 372, 122, '-');
INSERT INTO crx_dt_test VALUES (349, 'b', 63.329999999999998, 0.54000000000000004, 'u', 'g', 'c', 'v', 0.58499999999999996, 't', 't', 3, 't', 'g', 180, 0, '-');
INSERT INTO crx_dt_test VALUES (351, 'a', 26.170000000000002, 2, 'u', 'g', 'j', 'j', 0, 'f', 'f', 0, 't', 'g', 276, 1, '-');
INSERT INTO crx_dt_test VALUES (353, 'b', 22.5, 11.5, 'y', 'p', 'm', 'v', 1.5, 'f', 'f', 0, 't', 'g', 0, 4000, '-');
INSERT INTO crx_dt_test VALUES (355, 'b', 36.670000000000002, 2, 'u', 'g', 'i', 'v', 0.25, 'f', 'f', 0, 't', 'g', 221, 0, '-');
INSERT INTO crx_dt_test VALUES (357, 'b', 41.170000000000002, 1.335, 'u', 'g', 'd', 'v', 0.16500000000000001, 'f', 'f', 0, 'f', 'g', 168, 0, '-');
INSERT INTO crx_dt_test VALUES (359, 'b', 32.420000000000002, 3, 'u', 'g', 'd', 'v', 0.16500000000000001, 'f', 'f', 0, 't', 'g', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (361, 'a', 30.25, 5.5, 'u', 'g', 'k', 'v', 5.5, 'f', 'f', 0, 't', 's', 100, 0, '-');
INSERT INTO crx_dt_test VALUES (363, 'b', 26.829999999999998, 0.54000000000000004, 'u', 'g', 'k', 'ff', 0, 'f', 'f', 0, 'f', 'g', 100, 0, '-');
INSERT INTO crx_dt_test VALUES (365, 'b', 24.420000000000002, 2, 'u', 'g', 'e', 'dd', 0.16500000000000001, 'f', 't', 2, 'f', 'g', 320, 1300, '-');
INSERT INTO crx_dt_test VALUES (367, 'a', 22.75, 6.165, 'u', 'g', 'aa', 'v', 0.16500000000000001, 'f', 'f', 0, 'f', 'g', 220, 1000, '-');
INSERT INTO crx_dt_test VALUES (369, 'a', 23.579999999999998, 11.5, 'y', 'p', 'k', 'h', 3, 'f', 'f', 0, 't', 'g', 20, 16, '-');
INSERT INTO crx_dt_test VALUES (371, 'b', 33, 2.5, 'y', 'p', 'w', 'v', 7, 'f', 'f', 0, 't', 'g', 280, 0, '-');
INSERT INTO crx_dt_test VALUES (373, 'a', 45, 4.585, 'u', 'g', 'k', 'h', 1, 'f', 'f', 0, 't', 's', 240, 0, '-');
INSERT INTO crx_dt_test VALUES (1, 'b', 30.829999999999998, 0, 'u', 'g', 'w', 'v', 1.25, 't', 't', 1, 'f', 'g', 202, 0, '+');
INSERT INTO crx_dt_test VALUES (3, 'a', 24.5, 0.5, 'u', 'g', 'q', 'h', 1.5, 't', 'f', 0, 'f', 'g', 280, 824, '+');
INSERT INTO crx_dt_test VALUES (5, 'b', 20.170000000000002, 5.625, 'u', 'g', 'w', 'v', 1.71, 't', 'f', 0, 'f', 's', 120, 0, '+');
INSERT INTO crx_dt_test VALUES (7, 'b', 33.170000000000002, 1.04, 'u', 'g', 'r', 'h', 6.5, 't', 'f', 0, 't', 'g', 164, 31285, '+');
INSERT INTO crx_dt_test VALUES (9, 'b', 54.420000000000002, 0.5, 'y', 'p', 'k', 'h', 3.96, 't', 'f', 0, 'f', 'g', 180, 314, '+');
INSERT INTO crx_dt_test VALUES (11, 'b', 22.079999999999998, 0.82999999999999996, 'u', 'g', 'c', 'h', 2.165, 'f', 'f', 0, 't', 'g', 128, 0, '+');
INSERT INTO crx_dt_test VALUES (13, 'a', 38.25, 6, 'u', 'g', 'k', 'v', 1, 't', 'f', 0, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (15, 'a', 45.829999999999998, 10.5, 'u', 'g', 'q', 'v', 5, 't', 't', 7, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (17, 'b', 28.25, 0.875, 'u', 'g', 'm', 'v', 0.95999999999999996, 't', 't', 3, 't', 'g', 396, 0, '+');
INSERT INTO crx_dt_test VALUES (19, 'b', 21.829999999999998, 0.25, 'u', 'g', 'd', 'h', 0.66500000000000004, 't', 'f', 0, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (21, 'b', 25, 11.25, 'u', 'g', 'c', 'v', 2.5, 't', 't', 17, 'f', 'g', 200, 1208, '+');
INSERT INTO crx_dt_test VALUES (23, 'a', 47.75, 8, 'u', 'g', 'c', 'v', 7.875, 't', 't', 6, 't', 'g', 0, 1260, '+');
INSERT INTO crx_dt_test VALUES (25, 'a', 41.170000000000002, 6.5, 'u', 'g', 'q', 'v', 0.5, 't', 't', 3, 't', 'g', 145, 0, '+');
INSERT INTO crx_dt_test VALUES (27, 'a', 47, 13, 'u', 'g', 'i', 'bb', 5.165, 't', 't', 9, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (29, 'b', 57.420000000000002, 8.5, 'u', 'g', 'e', 'h', 7, 't', 't', 3, 'f', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (31, 'b', 29.25, 14.789999999999999, 'u', 'g', 'aa', 'v', 5.04, 't', 't', 5, 't', 'g', 168, 0, '+');
INSERT INTO crx_dt_test VALUES (33, 'b', 49.5, 7.585, 'u', 'g', 'i', 'bb', 7.585, 't', 't', 15, 't', 'g', 0, 5000, '+');
INSERT INTO crx_dt_test VALUES (35, 'a', 22.579999999999998, 10.75, 'u', 'g', 'q', 'v', 0.41499999999999998, 't', 't', 5, 't', 'g', 0, 560, '+');
INSERT INTO crx_dt_test VALUES (37, 'b', 27.25, 1.585, 'u', 'g', 'cc', 'h', 1.835, 't', 't', 12, 't', 'g', 583, 713, '+');
INSERT INTO crx_dt_test VALUES (39, 'b', 27.75, 0.58499999999999996, 'y', 'p', 'cc', 'v', 0.25, 't', 't', 2, 'f', 'g', 260, 500, '+');
INSERT INTO crx_dt_test VALUES (41, 'b', 34.170000000000002, 9.1699999999999999, 'u', 'g', 'c', 'v', 4.5, 't', 't', 12, 't', 'g', 0, 221, '+');
INSERT INTO crx_dt_test VALUES (43, 'b', 29.670000000000002, 1.415, 'u', 'g', 'w', 'h', 0.75, 't', 't', 1, 'f', 'g', 240, 100, '+');
INSERT INTO crx_dt_test VALUES (45, 'b', 56.420000000000002, 28, 'y', 'p', 'c', 'v', 28.5, 't', 't', 40, 'f', 'g', 0, 15, '+');
INSERT INTO crx_dt_test VALUES (47, 'a', 41, 2.04, 'y', 'p', 'q', 'h', 0.125, 't', 't', 23, 't', 'g', 455, 1236, '+');
INSERT INTO crx_dt_test VALUES (49, 'b', 41.5, 1.54, 'u', 'g', 'i', 'bb', 3.5, 'f', 'f', 0, 'f', 'g', 216, 0, '+');
INSERT INTO crx_dt_test VALUES (51, 'a', 25.75, 0.5, 'u', 'g', 'c', 'h', 0.875, 't', 'f', 0, 't', 'g', 491, 0, '+');
INSERT INTO crx_dt_test VALUES (53, 'b', 37.420000000000002, 2.04, 'u', 'g', 'w', 'v', 0.040000000000000001, 't', 'f', 0, 't', 'g', 400, 5800, '+');
INSERT INTO crx_dt_test VALUES (55, 'b', 34.25, 3, 'u', 'g', 'cc', 'h', 7.415, 't', 'f', 0, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (57, 'b', 23.170000000000002, 0, 'u', 'g', 'cc', 'v', 0.085000000000000006, 't', 'f', 0, 'f', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (59, 'b', 35.170000000000002, 4.5, 'u', 'g', 'x', 'h', 5.75, 'f', 'f', 0, 't', 's', 711, 0, '+');
INSERT INTO crx_dt_test VALUES (61, 'b', 56.75, 12.25, 'u', 'g', 'm', 'v', 1.25, 't', 't', 4, 't', 'g', 200, 0, '+');
INSERT INTO crx_dt_test VALUES (63, 'a', 23.420000000000002, 0.79000000000000004, 'y', 'p', 'q', 'v', 1.5, 't', 't', 2, 't', 'g', 80, 400, '+');
INSERT INTO crx_dt_test VALUES (65, 'b', 26.670000000000002, 4.25, 'u', 'g', 'cc', 'v', 4.29, 't', 't', 1, 't', 'g', 120, 0, '+');
INSERT INTO crx_dt_test VALUES (67, 'a', 36, 1, 'u', 'g', 'c', 'v', 2, 't', 't', 11, 'f', 'g', 0, 456, '+');
INSERT INTO crx_dt_test VALUES (69, 'b', 19.420000000000002, 6.5, 'u', 'g', 'w', 'h', 1.46, 't', 't', 7, 'f', 'g', 80, 2954, '+');
INSERT INTO crx_dt_test VALUES (71, 'b', 32.329999999999998, 7.5, 'u', 'g', 'e', 'bb', 1.585, 't', 'f', 0, 't', 's', 420, 0, '-');
INSERT INTO crx_dt_test VALUES (73, 'a', 38.579999999999998, 5, 'u', 'g', 'cc', 'v', 13.5, 't', 'f', 0, 't', 'g', 980, 0, '-');
INSERT INTO crx_dt_test VALUES (75, 'b', 44.829999999999998, 7, 'y', 'p', 'c', 'v', 1.625, 'f', 'f', 0, 'f', 'g', 160, 2, '-');
INSERT INTO crx_dt_test VALUES (77, 'b', 34.079999999999998, 6.5, 'u', 'g', 'aa', 'v', 0.125, 't', 'f', 0, 't', 'g', 443, 0, '-');
INSERT INTO crx_dt_test VALUES (79, 'b', 21.670000000000002, 1.165, 'y', 'p', 'k', 'v', 2.5, 't', 't', 1, 'f', 'g', 180, 20, '-');
INSERT INTO crx_dt_test VALUES (81, 'b', 49.579999999999998, 19, 'u', 'g', 'ff', 'ff', 0, 't', 't', 1, 'f', 'g', 94, 0, '-');
INSERT INTO crx_dt_test VALUES (83, 'b', 39.829999999999998, 0.5, 'u', 'g', 'm', 'v', 0.25, 't', 'f', 0, 'f', 's', 288, 0, '-');
INSERT INTO crx_dt_test VALUES (85, 'b', 27.25, 0.625, 'u', 'g', 'aa', 'v', 0.45500000000000002, 't', 'f', 0, 't', 'g', 200, 0, '-');
INSERT INTO crx_dt_test VALUES (87, 'b', NULL, 0.375, 'u', 'g', 'd', 'v', 0.875, 't', 'f', 0, 't', 's', 928, 0, '-');
INSERT INTO crx_dt_test VALUES (89, 'b', 34, 4.5, 'u', 'g', 'aa', 'v', 1, 't', 'f', 0, 't', 'g', 240, 0, '-');
INSERT INTO crx_dt_test VALUES (91, 'b', 62.5, 12.75, 'y', 'p', 'c', 'h', 5, 't', 'f', 0, 'f', 'g', 112, 0, '-');
INSERT INTO crx_dt_test VALUES (93, 'b', NULL, 5, 'y', 'p', 'aa', 'v', 8.5, 't', 'f', 0, 'f', 'g', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (95, 'b', 28.75, 1.5, 'y', 'p', 'c', 'v', 1.5, 't', 'f', 0, 't', 'g', 0, 225, '-');
INSERT INTO crx_dt_test VALUES (97, 'b', 23, 0.625, 'y', 'p', 'aa', 'v', 0.125, 't', 'f', 0, 'f', 'g', 180, 1, '-');
INSERT INTO crx_dt_test VALUES (99, 'a', 22.5, 11, 'y', 'p', 'q', 'v', 3, 't', 'f', 0, 't', 'g', 268, 0, '-');
INSERT INTO crx_dt_test VALUES (101, 'b', 37.5, 1.75, 'y', 'p', 'c', 'bb', 0.25, 't', 'f', 0, 't', 'g', 164, 400, '-');
INSERT INTO crx_dt_test VALUES (103, 'b', 18.670000000000002, 5, 'u', 'g', 'q', 'v', 0.375, 't', 't', 2, 'f', 'g', 0, 38, '-');
INSERT INTO crx_dt_test VALUES (105, 'b', 27.829999999999998, 4, 'y', 'p', 'i', 'h', 5.75, 't', 't', 2, 't', 'g', 75, 0, '-');
INSERT INTO crx_dt_test VALUES (107, 'b', 28.75, 1.165, 'u', 'g', 'k', 'v', 0.5, 't', 'f', 0, 'f', 's', 280, 0, '-');
INSERT INTO crx_dt_test VALUES (109, 'b', 40.920000000000002, 2.25, 'y', 'p', 'x', 'h', 10, 't', 'f', 0, 't', 'g', 176, 0, '-');
INSERT INTO crx_dt_test VALUES (111, 'b', 29.170000000000002, 3.5, 'u', 'g', 'w', 'v', 3.5, 't', 't', 3, 't', 'g', 329, 0, '-');
INSERT INTO crx_dt_test VALUES (113, 'b', 24.579999999999998, 12.5, 'u', 'g', 'w', 'v', 0.875, 't', 'f', 0, 't', 'g', 260, 0, '-');
INSERT INTO crx_dt_test VALUES (115, 'b', 20.670000000000002, 1.25, 'y', 'p', 'c', 'h', 1.375, 't', 't', 3, 't', 'g', 140, 210, '-');
INSERT INTO crx_dt_test VALUES (117, 'b', 37.75, 7, 'u', 'g', 'q', 'h', 11.5, 't', 't', 7, 't', 'g', 300, 5, '-');
INSERT INTO crx_dt_test VALUES (119, 'b', 57.829999999999998, 7.04, 'u', 'g', 'm', 'v', 14, 't', 't', 6, 't', 'g', 360, 1332, '+');
INSERT INTO crx_dt_test VALUES (121, 'b', 39.920000000000002, 6.21, 'u', 'g', 'q', 'v', 0.040000000000000001, 't', 't', 1, 'f', 'g', 200, 300, '+');
INSERT INTO crx_dt_test VALUES (123, 'a', 24.75, 12.5, 'u', 'g', 'aa', 'v', 1.5, 't', 't', 12, 't', 'g', 120, 567, '+');
INSERT INTO crx_dt_test VALUES (125, 'a', 23.5, 9, 'u', 'g', 'q', 'v', 8.5, 't', 't', 5, 't', 'g', 120, 0, '+');
INSERT INTO crx_dt_test VALUES (127, 'b', 47.670000000000002, 2.5, 'u', 'g', 'm', 'bb', 2.5, 't', 't', 12, 't', 'g', 410, 2510, '+');
INSERT INTO crx_dt_test VALUES (129, 'b', 34.420000000000002, 4.25, 'u', 'g', 'i', 'bb', 3.25, 't', 't', 2, 'f', 'g', 274, 610, '+');
INSERT INTO crx_dt_test VALUES (131, 'b', 67.75, 5.5, 'u', 'g', 'e', 'z', 13, 't', 't', 1, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (133, 'a', 47.420000000000002, 8, 'u', 'g', 'e', 'bb', 6.5, 't', 't', 6, 'f', 'g', 375, 51100, '+');
INSERT INTO crx_dt_test VALUES (135, 'b', 32.670000000000002, 5.5, 'u', 'g', 'q', 'h', 5.5, 't', 't', 12, 't', 'g', 408, 1000, '+');
INSERT INTO crx_dt_test VALUES (137, 'b', 39.920000000000002, 0.54000000000000004, 'y', 'p', 'aa', 'v', 0.5, 't', 't', 3, 'f', 'g', 200, 1000, '+');
INSERT INTO crx_dt_test VALUES (139, 'a', 18.829999999999998, 9.5, 'u', 'g', 'w', 'v', 1.625, 't', 't', 6, 't', 'g', 40, 600, '+');
INSERT INTO crx_dt_test VALUES (141, 'a', 31.25, 3.75, 'u', 'g', 'cc', 'h', 0.625, 't', 't', 9, 't', 'g', 181, 0, '+');
INSERT INTO crx_dt_test VALUES (143, 'b', 43, 0.28999999999999998, 'y', 'p', 'cc', 'h', 1.75, 't', 't', 8, 'f', 'g', 100, 375, '+');
INSERT INTO crx_dt_test VALUES (145, 'b', 27.25, 1.665, 'u', 'g', 'cc', 'h', 5.085, 't', 't', 9, 'f', 'g', 399, 827, '+');
INSERT INTO crx_dt_test VALUES (147, 'b', 23.25, 1.5, 'u', 'g', 'q', 'v', 2.375, 't', 't', 3, 't', 'g', 0, 582, '+');
INSERT INTO crx_dt_test VALUES (149, 'a', 30.5, 6.5, 'u', 'g', 'c', 'bb', 4, 't', 't', 7, 't', 'g', 0, 3065, '+');
INSERT INTO crx_dt_test VALUES (151, 'a', 46.670000000000002, 0.46000000000000002, 'u', 'g', 'cc', 'h', 0.41499999999999998, 't', 't', 11, 't', 'g', 440, 6, '+');
INSERT INTO crx_dt_test VALUES (153, 'b', 37.329999999999998, 6.5, 'u', 'g', 'm', 'h', 4.25, 't', 't', 12, 't', 'g', 93, 0, '+');
INSERT INTO crx_dt_test VALUES (155, 'b', 32.75, 1.5, 'u', 'g', 'cc', 'h', 5.5, 't', 't', 3, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (157, 'a', 28.5, 3.04, 'y', 'p', 'x', 'h', 2.54, 't', 't', 1, 'f', 'g', 70, 0, '+');
INSERT INTO crx_dt_test VALUES (159, 'b', 28, 2, 'u', 'g', 'k', 'h', 4.165, 't', 't', 2, 't', 'g', 181, 0, '+');
INSERT INTO crx_dt_test VALUES (161, 'b', 27.670000000000002, 2, 'u', 'g', 'x', 'h', 1, 't', 't', 4, 'f', 'g', 140, 7544, '+');
INSERT INTO crx_dt_test VALUES (163, 'b', 25.079999999999998, 1.71, 'u', 'g', 'x', 'v', 1.665, 't', 't', 1, 't', 'g', 395, 20, '+');
INSERT INTO crx_dt_test VALUES (165, 'a', 60.579999999999998, 16.5, 'u', 'g', 'q', 'v', 11, 't', 'f', 0, 't', 'g', 21, 10561, '+');
INSERT INTO crx_dt_test VALUES (167, 'b', 19.329999999999998, 9.5, 'u', 'g', 'q', 'v', 1, 't', 'f', 0, 't', 'g', 60, 400, '+');
INSERT INTO crx_dt_test VALUES (169, 'b', 36.670000000000002, 3.25, 'u', 'g', 'q', 'h', 9, 't', 'f', 0, 't', 'g', 102, 639, '+');
INSERT INTO crx_dt_test VALUES (171, 'a', 25.079999999999998, 2.54, 'y', 'p', 'aa', 'v', 0.25, 't', 'f', 0, 't', 'g', 370, 0, '+');
INSERT INTO crx_dt_test VALUES (173, 'b', 56, 12.5, 'u', 'g', 'k', 'h', 8, 't', 'f', 0, 't', 'g', 24, 2028, '+');
INSERT INTO crx_dt_test VALUES (175, 'b', 22.670000000000002, 10.5, 'u', 'g', 'q', 'h', 1.335, 't', 'f', 0, 'f', 'g', 100, 0, '+');
INSERT INTO crx_dt_test VALUES (177, 'b', 25, 12.5, 'u', 'g', 'aa', 'v', 3, 't', 'f', 0, 't', 's', 20, 0, '+');
INSERT INTO crx_dt_test VALUES (179, 'a', 18.420000000000002, 9.25, 'u', 'g', 'q', 'v', 1.21, 't', 't', 4, 'f', 'g', 60, 540, '+');
INSERT INTO crx_dt_test VALUES (181, 'b', 47.670000000000002, 0.28999999999999998, 'u', 'g', 'c', 'bb', 15, 't', 't', 20, 'f', 'g', 0, 15000, '+');
INSERT INTO crx_dt_test VALUES (183, 'a', 20.670000000000002, 3, 'u', 'g', 'q', 'v', 0.16500000000000001, 't', 't', 3, 'f', 'g', 100, 6, '+');
INSERT INTO crx_dt_test VALUES (185, 'a', 22.420000000000002, 5.665, 'u', 'g', 'q', 'v', 2.585, 't', 't', 7, 'f', 'g', 129, 3257, '+');
INSERT INTO crx_dt_test VALUES (375, NULL, 28.170000000000002, 0.58499999999999996, 'u', 'g', 'aa', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 260, 1004, '-');
INSERT INTO crx_dt_test VALUES (377, 'b', 28.670000000000002, 14.5, 'u', 'g', 'd', 'v', 0.125, 'f', 'f', 0, 'f', 'g', 0, 286, '-');
INSERT INTO crx_dt_test VALUES (379, 'b', 34.420000000000002, 1.335, 'u', 'g', 'i', 'bb', 0.125, 'f', 'f', 0, 't', 'g', 440, 4500, '-');
INSERT INTO crx_dt_test VALUES (381, 'b', 43.170000000000002, 5, 'u', 'g', 'i', 'bb', 2.25, 'f', 'f', 0, 't', 'g', 141, 0, '-');
INSERT INTO crx_dt_test VALUES (383, 'a', 24.329999999999998, 2.5, 'y', 'p', 'i', 'bb', 4.5, 'f', 'f', 0, 'f', 'g', 200, 456, '-');
INSERT INTO crx_dt_test VALUES (385, 'b', 22.079999999999998, 11.460000000000001, 'u', 'g', 'k', 'v', 1.585, 'f', 'f', 0, 't', 'g', 100, 1212, '-');
INSERT INTO crx_dt_test VALUES (387, 'b', 22.579999999999998, 1.5, 'y', 'p', 'aa', 'v', 0.54000000000000004, 'f', 'f', 0, 't', 'g', 120, 67, '-');
INSERT INTO crx_dt_test VALUES (389, 'b', 26.670000000000002, 14.585000000000001, 'u', 'g', 'i', 'bb', 0, 'f', 'f', 0, 't', 'g', 178, 0, '-');
INSERT INTO crx_dt_test VALUES (391, 'b', 15.17, 7, 'u', 'g', 'e', 'v', 1, 'f', 'f', 0, 'f', 'g', 600, 0, '-');
INSERT INTO crx_dt_test VALUES (393, 'b', 27.420000000000002, 12.5, 'u', 'g', 'aa', 'bb', 0.25, 'f', 'f', 0, 't', 'g', 720, 0, '-');
INSERT INTO crx_dt_test VALUES (395, 'b', 41.170000000000002, 1.25, 'y', 'p', 'w', 'v', 0.25, 'f', 'f', 0, 'f', 'g', 0, 195, '-');
INSERT INTO crx_dt_test VALUES (397, 'b', 29.829999999999998, 2.04, 'y', 'p', 'x', 'h', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 128, 1, '-');
INSERT INTO crx_dt_test VALUES (399, 'b', 26.170000000000002, 12.5, 'y', 'p', 'k', 'h', 1.25, 'f', 'f', 0, 't', 'g', 0, 17, '-');
INSERT INTO crx_dt_test VALUES (401, 'b', 20.75, 5.085, 'y', 'p', 'j', 'v', 0.28999999999999998, 'f', 'f', 0, 'f', 'g', 140, 184, '-');
INSERT INTO crx_dt_test VALUES (403, 'a', 51.920000000000002, 6.5, 'u', 'g', 'i', 'bb', 3.085, 'f', 'f', 0, 't', 'g', 73, 0, '-');
INSERT INTO crx_dt_test VALUES (405, 'b', 34, 5.085, 'y', 'p', 'i', 'bb', 1.085, 'f', 'f', 0, 't', 'g', 480, 0, '-');
INSERT INTO crx_dt_test VALUES (407, 'a', 40.329999999999998, 8.125, 'y', 'p', 'k', 'v', 0.16500000000000001, 'f', 't', 2, 'f', 'g', NULL, 18, '-');
INSERT INTO crx_dt_test VALUES (409, 'b', 16, 3.125, 'u', 'g', 'w', 'v', 0.085000000000000006, 'f', 't', 1, 'f', 'g', 0, 6, '-');
INSERT INTO crx_dt_test VALUES (411, 'b', 31.25, 2.835, 'u', 'g', 'ff', 'ff', 0, 'f', 't', 5, 'f', 'g', 176, 146, '-');
INSERT INTO crx_dt_test VALUES (413, 'a', 22.670000000000002, 0.79000000000000004, 'u', 'g', 'i', 'v', 0.085000000000000006, 'f', 'f', 0, 'f', 'g', 144, 0, '-');
INSERT INTO crx_dt_test VALUES (415, 'b', 22.25, 0.46000000000000002, 'u', 'g', 'k', 'v', 0.125, 'f', 'f', 0, 't', 'g', 280, 55, '-');
INSERT INTO crx_dt_test VALUES (417, 'b', 22.5, 0.125, 'y', 'p', 'k', 'v', 0.125, 'f', 'f', 0, 'f', 'g', 200, 70, '-');
INSERT INTO crx_dt_test VALUES (419, 'b', 38.420000000000002, 0.70499999999999996, 'u', 'g', 'c', 'v', 0.375, 'f', 't', 2, 'f', 'g', 225, 500, '-');
INSERT INTO crx_dt_test VALUES (421, 'b', 35, 2.5, 'u', 'g', 'i', 'v', 1, 'f', 'f', 0, 't', 'g', 210, 0, '-');
INSERT INTO crx_dt_test VALUES (423, 'b', 29.420000000000002, 1.25, 'u', 'g', 'w', 'v', 1.75, 'f', 'f', 0, 'f', 'g', 200, 0, '-');
INSERT INTO crx_dt_test VALUES (425, 'b', 33.670000000000002, 2.165, 'u', 'g', 'c', 'v', 1.5, 'f', 'f', 0, 'f', 'p', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (427, 'a', 27.670000000000002, 2.04, 'u', 'g', 'w', 'v', 0.25, 'f', 'f', 0, 't', 'g', 180, 50, '-');
INSERT INTO crx_dt_test VALUES (429, 'b', 49.170000000000002, 2.29, 'u', 'g', 'ff', 'ff', 0.28999999999999998, 'f', 'f', 0, 'f', 'g', 200, 3, '-');
INSERT INTO crx_dt_test VALUES (431, 'b', 51.829999999999998, 3, 'y', 'p', 'ff', 'ff', 1.5, 'f', 'f', 0, 'f', 'g', 180, 4, '-');
INSERT INTO crx_dt_test VALUES (433, 'b', 21.829999999999998, 1.54, 'u', 'g', 'k', 'v', 0.085000000000000006, 'f', 'f', 0, 't', 'g', 356, 0, '-');
INSERT INTO crx_dt_test VALUES (435, 'b', 58.579999999999998, 2.71, 'u', 'g', 'c', 'v', 2.415, 'f', 'f', 0, 't', 'g', 320, 0, '-');
INSERT INTO crx_dt_test VALUES (437, 'b', 19.579999999999998, 0.58499999999999996, 'u', 'g', 'ff', 'ff', 0, 'f', 't', 3, 'f', 'g', 350, 769, '-');
INSERT INTO crx_dt_test VALUES (439, 'a', 27.170000000000002, 1.25, 'u', 'g', 'ff', 'ff', 0, 'f', 't', 1, 'f', 'g', 92, 300, '-');
INSERT INTO crx_dt_test VALUES (441, 'b', 23.079999999999998, 0, 'u', 'g', 'k', 'v', 1, 'f', 't', 11, 'f', 's', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (443, 'b', 30.579999999999998, 2.71, 'y', 'p', 'm', 'v', 0.125, 'f', 'f', 0, 't', 's', 80, 0, '-');
INSERT INTO crx_dt_test VALUES (445, 'a', 17.670000000000002, 0, 'y', 'p', 'j', 'ff', 0, 'f', 'f', 0, 'f', 'g', 86, 0, '-');
INSERT INTO crx_dt_test VALUES (447, 'b', 16.5, 0.125, 'u', 'g', 'c', 'v', 0.16500000000000001, 'f', 'f', 0, 'f', 'g', 132, 0, '-');
INSERT INTO crx_dt_test VALUES (449, 'b', 31.25, 1.125, 'u', 'g', 'ff', 'ff', 0, 'f', 't', 1, 'f', 'g', 96, 19, '-');
INSERT INTO crx_dt_test VALUES (451, 'b', NULL, 3, 'y', 'p', 'i', 'bb', 7, 'f', 'f', 0, 'f', 'g', 0, 1, '-');
INSERT INTO crx_dt_test VALUES (453, 'b', 36.5, 4.25, 'u', 'g', 'q', 'v', 3.5, 'f', 'f', 0, 'f', 'g', 454, 50, '-');
INSERT INTO crx_dt_test VALUES (455, 'b', 52.420000000000002, 1.5, 'u', 'g', 'd', 'v', 3.75, 'f', 'f', 0, 't', 'g', 0, 350, '-');
INSERT INTO crx_dt_test VALUES (457, 'b', 34.579999999999998, 0, NULL, NULL, NULL, NULL, 0, 'f', 'f', 0, 'f', 'p', NULL, 0, '-');
INSERT INTO crx_dt_test VALUES (459, 'b', 36.170000000000002, 5.5, 'u', 'g', 'i', 'bb', 5, 'f', 'f', 0, 'f', 'g', 210, 687, '-');
INSERT INTO crx_dt_test VALUES (461, 'a', 24.5, 2.415, 'y', 'p', 'c', 'v', 0, 'f', 'f', 0, 'f', 'g', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (463, 'b', 21.920000000000002, 0.5, 'u', 'g', 'c', 'v', 0.125, 'f', 'f', 0, 'f', 'g', 360, 0, '-');
INSERT INTO crx_dt_test VALUES (465, 'a', 23, 1.835, 'u', 'g', 'j', 'j', 0, 'f', 't', 1, 'f', 'g', 200, 53, '-');
INSERT INTO crx_dt_test VALUES (467, 'b', 31.079999999999998, 3.085, 'u', 'g', 'c', 'v', 2.5, 'f', 't', 2, 't', 'g', 160, 41, '-');
INSERT INTO crx_dt_test VALUES (469, 'b', 22.079999999999998, 2.335, 'u', 'g', 'k', 'v', 0.75, 'f', 'f', 0, 'f', 'g', 180, 0, '-');
INSERT INTO crx_dt_test VALUES (471, 'a', 21.920000000000002, 11.664999999999999, 'u', 'g', 'k', 'h', 0.085000000000000006, 'f', 'f', 0, 'f', 'g', 320, 5, '-');
INSERT INTO crx_dt_test VALUES (473, 'b', 17.420000000000002, 6.5, 'u', 'g', 'i', 'v', 0.125, 'f', 'f', 0, 'f', 'g', 60, 100, '-');
INSERT INTO crx_dt_test VALUES (475, 'b', 20.670000000000002, 0.41499999999999998, 'u', 'g', 'c', 'v', 0.125, 'f', 'f', 0, 'f', 'g', 0, 44, '-');
INSERT INTO crx_dt_test VALUES (477, 'b', 23.579999999999998, 0.83499999999999996, 'u', 'g', 'i', 'h', 0.085000000000000006, 'f', 'f', 0, 't', 'g', 220, 5, '-');
INSERT INTO crx_dt_test VALUES (479, 'b', 22.75, 11.5, 'u', 'g', 'i', 'v', 0.41499999999999998, 'f', 'f', 0, 'f', 'g', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (481, 'a', 16.920000000000002, 0.5, 'u', 'g', 'i', 'v', 0.16500000000000001, 'f', 't', 6, 't', 'g', 240, 35, '-');
INSERT INTO crx_dt_test VALUES (483, 'a', 17.329999999999998, 9.5, 'u', 'g', 'aa', 'v', 1.75, 'f', 't', 10, 't', 'g', 0, 10, '-');
INSERT INTO crx_dt_test VALUES (485, 'b', 34.670000000000002, 1.0800000000000001, 'u', 'g', 'm', 'v', 1.165, 'f', 'f', 0, 'f', 's', 28, 0, '-');
INSERT INTO crx_dt_test VALUES (487, 'b', 28.170000000000002, 0.125, 'y', 'p', 'k', 'v', 0.085000000000000006, 'f', 'f', 0, 'f', 'g', 216, 2100, '-');
INSERT INTO crx_dt_test VALUES (489, 'b', 18.829999999999998, 3.54, 'y', 'p', 'ff', 'ff', 0, 'f', 'f', 0, 't', 'g', 180, 1, '-');
INSERT INTO crx_dt_test VALUES (187, 'b', 40, 6.5, 'u', 'g', 'aa', 'bb', 3.5, 't', 't', 1, 'f', 'g', 0, 500, '+');
INSERT INTO crx_dt_test VALUES (189, 'a', 28.670000000000002, 1.04, 'u', 'g', 'c', 'v', 2.5, 't', 't', 5, 't', 'g', 300, 1430, '+');
INSERT INTO crx_dt_test VALUES (191, 'b', 21.329999999999998, 10.5, 'u', 'g', 'c', 'v', 3, 't', 'f', 0, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (193, 'b', 41.75, 0.95999999999999996, 'u', 'g', 'x', 'v', 2.5, 't', 'f', 0, 'f', 'g', 510, 600, '+');
INSERT INTO crx_dt_test VALUES (195, 'b', 34.5, 4.04, 'y', 'p', 'i', 'bb', 8.5, 't', 't', 7, 't', 'g', 195, 0, '+');
INSERT INTO crx_dt_test VALUES (197, 'b', 33.170000000000002, 3.165, 'y', 'p', 'x', 'v', 3.165, 't', 't', 3, 't', 'g', 380, 0, '+');
INSERT INTO crx_dt_test VALUES (199, 'b', 27.579999999999998, 2.04, 'y', 'p', 'aa', 'v', 2, 't', 't', 3, 't', 'g', 370, 560, '+');
INSERT INTO crx_dt_test VALUES (201, 'a', 24.079999999999998, 0.5, 'u', 'g', 'q', 'h', 1.25, 't', 't', 1, 'f', 'g', 0, 678, '+');
INSERT INTO crx_dt_test VALUES (203, 'b', 24.829999999999998, 2.75, 'u', 'g', 'c', 'v', 2.25, 't', 't', 6, 'f', 'g', NULL, 600, '+');
INSERT INTO crx_dt_test VALUES (205, 'b', 36.329999999999998, 2.125, 'y', 'p', 'w', 'v', 0.085000000000000006, 't', 't', 1, 'f', 'g', 50, 1187, '+');
INSERT INTO crx_dt_test VALUES (207, 'a', 71.579999999999998, 0, NULL, NULL, NULL, NULL, 0, 'f', 'f', 0, 'f', 'p', NULL, 0, '+');
INSERT INTO crx_dt_test VALUES (209, 'b', 35.170000000000002, 2.5, 'u', 'g', 'k', 'v', 4.5, 't', 't', 7, 'f', 'g', 150, 1270, '+');
INSERT INTO crx_dt_test VALUES (211, 'b', 39.329999999999998, 5.875, 'u', 'g', 'cc', 'h', 10, 't', 't', 14, 't', 'g', 399, 0, '+');
INSERT INTO crx_dt_test VALUES (213, 'b', 60.079999999999998, 14.5, 'u', 'g', 'ff', 'ff', 18, 't', 't', 15, 't', 'g', 0, 1000, '+');
INSERT INTO crx_dt_test VALUES (215, 'b', 26.670000000000002, 2.71, 'y', 'p', 'cc', 'v', 5.25, 't', 't', 1, 'f', 'g', 211, 0, '+');
INSERT INTO crx_dt_test VALUES (217, 'b', 41.170000000000002, 4.04, 'u', 'g', 'cc', 'h', 7, 't', 't', 8, 'f', 'g', 320, 0, '+');
INSERT INTO crx_dt_test VALUES (219, 'b', 53.920000000000002, 9.625, 'u', 'g', 'e', 'v', 8.6649999999999991, 't', 't', 5, 'f', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (221, 'a', 50.079999999999998, 12.539999999999999, 'u', 'g', 'aa', 'v', 2.29, 't', 't', 3, 't', 'g', 156, 0, '+');
INSERT INTO crx_dt_test VALUES (223, 'a', 17.579999999999998, 9, 'u', 'g', 'aa', 'v', 1.375, 't', 'f', 0, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (225, 'a', 37.75, 5.5, 'u', 'g', 'q', 'v', 0.125, 't', 'f', 0, 't', 'g', 228, 0, '+');
INSERT INTO crx_dt_test VALUES (227, 'b', 18.079999999999998, 5.5, 'u', 'g', 'k', 'v', 0.5, 't', 'f', 0, 'f', 'g', 80, 0, '+');
INSERT INTO crx_dt_test VALUES (229, 'b', 19.670000000000002, 0.375, 'u', 'g', 'q', 'v', 2, 't', 't', 2, 't', 'g', 80, 0, '+');
INSERT INTO crx_dt_test VALUES (231, 'b', 25.170000000000002, 3.5, 'u', 'g', 'cc', 'v', 0.625, 't', 't', 7, 'f', 'g', 0, 7059, '+');
INSERT INTO crx_dt_test VALUES (233, 'b', 33.5, 1.75, 'u', 'g', 'x', 'h', 4.5, 't', 't', 4, 't', 'g', 253, 857, '+');
INSERT INTO crx_dt_test VALUES (235, 'a', 58.420000000000002, 21, 'u', 'g', 'i', 'bb', 10, 't', 't', 13, 'f', 'g', 0, 6700, '+');
INSERT INTO crx_dt_test VALUES (237, 'b', 26.170000000000002, 0.25, 'u', 'g', 'i', 'bb', 0, 't', 'f', 0, 't', 'g', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (239, 'b', 42.829999999999998, 4.625, 'u', 'g', 'q', 'v', 4.5800000000000001, 't', 'f', 0, 'f', 's', 0, 0, '+');
INSERT INTO crx_dt_test VALUES (241, 'b', 20.5, 10, 'y', 'p', 'c', 'v', 2.5, 't', 'f', 0, 'f', 's', 40, 0, '+');
INSERT INTO crx_dt_test VALUES (243, 'b', 28.329999999999998, 5, 'u', 'g', 'w', 'v', 11, 't', 'f', 0, 't', 'g', 70, 0, '+');
INSERT INTO crx_dt_test VALUES (245, 'b', 18.5, 2, 'u', 'g', 'i', 'v', 1.5, 't', 't', 2, 'f', 'g', 120, 300, '+');
INSERT INTO crx_dt_test VALUES (247, 'b', 45, 8.5, 'u', 'g', 'cc', 'h', 14, 't', 't', 1, 't', 'g', 88, 2000, '+');
INSERT INTO crx_dt_test VALUES (249, NULL, 24.5, 12.75, 'u', 'g', 'c', 'bb', 4.75, 't', 't', 2, 'f', 'g', 73, 444, '+');
INSERT INTO crx_dt_test VALUES (251, 'b', 40.25, 21.5, 'u', 'g', 'e', 'z', 20, 't', 't', 11, 'f', 'g', 0, 1200, '+');
INSERT INTO crx_dt_test VALUES (253, 'a', 17.829999999999998, 11, 'u', 'g', 'x', 'h', 1, 't', 't', 11, 'f', 'g', 0, 3000, '+');
INSERT INTO crx_dt_test VALUES (255, 'b', NULL, 0.625, 'u', 'g', 'k', 'v', 0.25, 'f', 'f', 0, 'f', 'g', 380, 2010, '-');
INSERT INTO crx_dt_test VALUES (256, 'b', 18.170000000000002, 10.25, 'u', 'g', 'c', 'h', 1.085, 'f', 'f', 0, 'f', 'g', 320, 13, '-');
INSERT INTO crx_dt_test VALUES (258, 'b', 20, 0, 'u', 'g', 'd', 'v', 0.5, 'f', 'f', 0, 'f', 'g', 144, 0, '-');
INSERT INTO crx_dt_test VALUES (260, 'a', 24.5, 1.75, 'y', 'p', 'c', 'v', 0.16500000000000001, 'f', 'f', 0, 'f', 'g', 132, 0, '-');
INSERT INTO crx_dt_test VALUES (262, 'a', 52.170000000000002, 0, 'y', 'p', 'ff', 'ff', 0, 'f', 'f', 0, 'f', 'g', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (264, 'a', 20.420000000000002, 10.5, 'y', 'p', 'x', 'h', 0, 'f', 'f', 0, 't', 'g', 154, 32, '-');
INSERT INTO crx_dt_test VALUES (266, 'b', 17.079999999999998, 0.085000000000000006, 'y', 'p', 'c', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 140, 722, '-');
INSERT INTO crx_dt_test VALUES (268, 'a', 32, 6, 'u', 'g', 'd', 'v', 1.25, 'f', 'f', 0, 'f', 'g', 272, 0, '-');
INSERT INTO crx_dt_test VALUES (270, 'b', 18, 0.16500000000000001, 'u', 'g', 'q', 'n', 0.20999999999999999, 'f', 'f', 0, 'f', 'g', 200, 40, '+');
INSERT INTO crx_dt_test VALUES (272, 'b', 32.329999999999998, 2.5, 'u', 'g', 'c', 'v', 1.25, 'f', 'f', 0, 't', 'g', 280, 0, '-');
INSERT INTO crx_dt_test VALUES (274, 'b', 38.25, 10.125, 'y', 'p', 'k', 'v', 0.125, 'f', 'f', 0, 'f', 'g', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (276, 'b', 18.579999999999998, 5.71, 'u', 'g', 'd', 'v', 0.54000000000000004, 'f', 'f', 0, 'f', 'g', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (278, 'a', 18.170000000000002, 10, 'y', 'p', 'q', 'h', 0.16500000000000001, 'f', 'f', 0, 'f', 'g', 340, 0, '-');
INSERT INTO crx_dt_test VALUES (280, 'b', 16.25, 0.83499999999999996, 'u', 'g', 'm', 'v', 0.085000000000000006, 't', 'f', 0, 'f', 's', 200, 0, '-');
INSERT INTO crx_dt_test VALUES (282, 'b', 23.920000000000002, 0.58499999999999996, 'y', 'p', 'cc', 'h', 0.125, 'f', 'f', 0, 'f', 'g', 240, 1, '-');
INSERT INTO crx_dt_test VALUES (284, 'a', 16.5, 1.25, 'u', 'g', 'q', 'v', 0.25, 'f', 't', 1, 'f', 'g', 108, 98, '-');
INSERT INTO crx_dt_test VALUES (286, 'b', 17.579999999999998, 10, 'u', 'g', 'w', 'h', 0.16500000000000001, 'f', 't', 1, 'f', 'g', 120, 1, '-');
INSERT INTO crx_dt_test VALUES (288, 'b', 29.5, 0.57999999999999996, 'u', 'g', 'w', 'v', 0.28999999999999998, 'f', 't', 1, 'f', 'g', 340, 2803, '-');
INSERT INTO crx_dt_test VALUES (290, 'a', 21.75, 1.75, 'y', 'p', 'j', 'j', 0, 'f', 'f', 0, 'f', 'g', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (292, 'a', 18.25, 10, 'u', 'g', 'w', 'v', 1, 'f', 't', 1, 'f', 'g', 120, 1, '-');
INSERT INTO crx_dt_test VALUES (294, 'b', 35.75, 2.415, 'u', 'g', 'w', 'v', 0.125, 'f', 't', 2, 'f', 'g', 220, 1, '-');
INSERT INTO crx_dt_test VALUES (296, 'a', 31.920000000000002, 3.125, 'u', 'g', 'ff', 'ff', 3.04, 'f', 't', 2, 't', 'g', 200, 4, '-');
INSERT INTO crx_dt_test VALUES (298, 'b', 32.920000000000002, 2.5, 'u', 'g', 'aa', 'v', 1.75, 'f', 't', 2, 't', 'g', 720, 0, '-');
INSERT INTO crx_dt_test VALUES (300, 'b', 22.170000000000002, 12.125, 'u', 'g', 'c', 'v', 3.335, 'f', 't', 2, 't', 'g', 180, 173, '-');
INSERT INTO crx_dt_test VALUES (302, 'b', 18.25, 0.16500000000000001, 'u', 'g', 'd', 'v', 0.25, 'f', 'f', 0, 't', 's', 280, 0, '-');
INSERT INTO crx_dt_test VALUES (304, 'a', 15.92, 2.875, 'u', 'g', 'q', 'v', 0.085000000000000006, 'f', 'f', 0, 'f', 'g', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (306, 'b', 48.75, 26.335000000000001, 'y', 'p', 'ff', 'ff', 0, 't', 'f', 0, 't', 'g', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (308, 'b', 18.579999999999998, 10.289999999999999, 'u', 'g', 'ff', 'ff', 0.41499999999999998, 'f', 'f', 0, 'f', 'g', 80, 0, '-');
INSERT INTO crx_dt_test VALUES (310, 'a', 31.75, 3, 'y', 'p', 'j', 'j', 0, 'f', 'f', 0, 'f', 'g', 160, 20, '-');
INSERT INTO crx_dt_test VALUES (312, 'b', 19, 1.75, 'y', 'p', 'c', 'v', 2.335, 'f', 'f', 0, 't', 'g', 112, 6, '-');
INSERT INTO crx_dt_test VALUES (314, 'a', 18.579999999999998, 10, 'u', 'g', 'd', 'v', 0.41499999999999998, 'f', 'f', 0, 'f', 'g', 80, 42, '-');
INSERT INTO crx_dt_test VALUES (316, 'b', 23, 0.75, 'u', 'g', 'm', 'v', 0.5, 't', 'f', 0, 't', 's', 320, 0, '-');
INSERT INTO crx_dt_test VALUES (318, 'b', 17.5, 22, 'l', 'gg', 'ff', 'o', 0, 'f', 'f', 0, 't', 'p', 450, 100000, '+');
INSERT INTO crx_dt_test VALUES (320, 'b', 36.75, 0.125, 'y', 'p', 'c', 'v', 1.5, 'f', 'f', 0, 't', 'g', 232, 113, '+');
INSERT INTO crx_dt_test VALUES (322, 'a', 18.079999999999998, 0.375, 'l', 'gg', 'cc', 'ff', 10, 'f', 'f', 0, 't', 's', 300, 0, '+');
INSERT INTO crx_dt_test VALUES (324, 'b', 48.579999999999998, 0.20499999999999999, 'y', 'p', 'k', 'v', 0.25, 't', 't', 11, 'f', 'g', 380, 2732, '+');
INSERT INTO crx_dt_test VALUES (326, 'a', 29.5, 1.085, 'y', 'p', 'x', 'v', 1, 'f', 'f', 0, 'f', 'g', 280, 13, '-');
INSERT INTO crx_dt_test VALUES (328, NULL, 40.829999999999998, 3.5, 'u', 'g', 'i', 'bb', 0.5, 'f', 'f', 0, 'f', 's', 1160, 0, '-');
INSERT INTO crx_dt_test VALUES (330, 'b', NULL, 4, 'y', 'p', 'i', 'v', 0.085000000000000006, 'f', 'f', 0, 't', 'g', 411, 0, '-');
INSERT INTO crx_dt_test VALUES (332, 'a', 33.25, 2.5, 'y', 'p', 'c', 'v', 2.5, 'f', 'f', 0, 't', 'g', 0, 2, '-');
INSERT INTO crx_dt_test VALUES (334, 'a', 25.25, 12.5, 'u', 'g', 'd', 'v', 1, 'f', 'f', 0, 't', 'g', 180, 1062, '-');
INSERT INTO crx_dt_test VALUES (336, 'b', 27.670000000000002, 0.75, 'u', 'g', 'q', 'h', 0.16500000000000001, 'f', 'f', 0, 't', 'g', 220, 251, '-');
INSERT INTO crx_dt_test VALUES (338, 'a', 34.829999999999998, 1.25, 'y', 'p', 'i', 'h', 0.5, 'f', 'f', 0, 't', 'g', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (340, 'b', 28, 3, 'u', 'g', 'w', 'v', 0.75, 'f', 'f', 0, 't', 'g', 300, 67, '-');
INSERT INTO crx_dt_test VALUES (342, 'b', 42.75, 4.085, 'u', 'g', 'aa', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 108, 100, '-');
INSERT INTO crx_dt_test VALUES (344, 'b', 33.75, 2.75, 'u', 'g', 'i', 'bb', 0, 'f', 'f', 0, 'f', 'g', 180, 0, '-');
INSERT INTO crx_dt_test VALUES (346, 'b', 62.75, 7, 'u', 'g', 'e', 'z', 0, 'f', 'f', 0, 'f', 'g', 0, 12, '-');
INSERT INTO crx_dt_test VALUES (348, 'b', 26.75, 4.5, 'y', 'p', 'c', 'bb', 2.5, 'f', 'f', 0, 'f', 'g', 200, 1210, '-');
INSERT INTO crx_dt_test VALUES (350, 'b', 27.829999999999998, 1.5, 'u', 'g', 'w', 'v', 2.25, 'f', 't', 1, 't', 'g', 100, 3, '-');
INSERT INTO crx_dt_test VALUES (352, 'b', 22.170000000000002, 0.58499999999999996, 'y', 'p', 'ff', 'ff', 0, 'f', 'f', 0, 'f', 'g', 100, 0, '-');
INSERT INTO crx_dt_test VALUES (354, 'b', 30.75, 1.585, 'u', 'g', 'd', 'v', 0.58499999999999996, 'f', 'f', 0, 't', 's', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (356, 'a', 16, 0.16500000000000001, 'u', 'g', 'aa', 'v', 1, 'f', 't', 2, 't', 'g', 320, 1, '-');
INSERT INTO crx_dt_test VALUES (358, 'a', 19.5, 0.16500000000000001, 'u', 'g', 'q', 'v', 0.040000000000000001, 'f', 'f', 0, 't', 'g', 380, 0, '-');
INSERT INTO crx_dt_test VALUES (360, 'a', 36.75, 4.71, 'u', 'g', 'ff', 'ff', 0, 'f', 'f', 0, 'f', 'g', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (362, 'b', 23.079999999999998, 2.5, 'u', 'g', 'ff', 'ff', 0.085000000000000006, 'f', 'f', 0, 't', 'g', 100, 4208, '-');
INSERT INTO crx_dt_test VALUES (364, 'b', 16.920000000000002, 0.33500000000000002, 'y', 'p', 'k', 'v', 0.28999999999999998, 'f', 'f', 0, 'f', 's', 200, 0, '-');
INSERT INTO crx_dt_test VALUES (366, 'b', 42.829999999999998, 1.25, 'u', 'g', 'm', 'v', 13.875, 'f', 't', 1, 't', 'g', 352, 112, '-');
INSERT INTO crx_dt_test VALUES (368, 'b', 39.420000000000002, 1.71, 'y', 'p', 'm', 'v', 0.16500000000000001, 'f', 'f', 0, 'f', 's', 400, 0, '-');
INSERT INTO crx_dt_test VALUES (370, 'b', 21.420000000000002, 0.75, 'y', 'p', 'r', 'n', 0.75, 'f', 'f', 0, 't', 'g', 132, 2, '-');
INSERT INTO crx_dt_test VALUES (372, 'b', 26.329999999999998, 13, 'u', 'g', 'e', 'dd', 0, 'f', 'f', 0, 't', 'g', 140, 1110, '-');
INSERT INTO crx_dt_test VALUES (374, 'b', 26.25, 1.54, 'u', 'g', 'w', 'v', 0.125, 'f', 'f', 0, 'f', 'g', 100, 0, '-');
INSERT INTO crx_dt_test VALUES (376, 'a', 20.829999999999998, 0.5, 'y', 'p', 'e', 'dd', 1, 'f', 'f', 0, 'f', 'g', 260, 0, '-');
INSERT INTO crx_dt_test VALUES (378, 'b', 20.670000000000002, 0.83499999999999996, 'y', 'p', 'c', 'v', 2, 'f', 'f', 0, 't', 's', 240, 0, '-');
INSERT INTO crx_dt_test VALUES (380, 'b', 33.579999999999998, 0.25, 'u', 'g', 'i', 'bb', 4, 'f', 'f', 0, 't', 's', 420, 0, '-');
INSERT INTO crx_dt_test VALUES (382, 'a', 22.670000000000002, 7, 'u', 'g', 'c', 'v', 0.16500000000000001, 'f', 'f', 0, 'f', 'g', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (384, 'a', 56.829999999999998, 4.25, 'y', 'p', 'ff', 'ff', 5, 'f', 'f', 0, 't', 'g', 0, 4, '-');
INSERT INTO crx_dt_test VALUES (386, 'b', 34, 5.5, 'y', 'p', 'c', 'v', 1.5, 'f', 'f', 0, 't', 'g', 60, 0, '-');
INSERT INTO crx_dt_test VALUES (388, 'b', 21.170000000000002, 0, 'u', 'g', 'c', 'v', 0.5, 'f', 'f', 0, 't', 's', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (390, 'b', 22.920000000000002, 0.17000000000000001, 'u', 'g', 'm', 'v', 0.085000000000000006, 'f', 'f', 0, 'f', 's', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (392, 'b', 39.920000000000002, 5, 'u', 'g', 'i', 'bb', 0.20999999999999999, 'f', 'f', 0, 'f', 'g', 550, 0, '-');
INSERT INTO crx_dt_test VALUES (394, 'b', 24.75, 0.54000000000000004, 'u', 'g', 'm', 'v', 1, 'f', 'f', 0, 't', 'g', 120, 1, '-');
INSERT INTO crx_dt_test VALUES (396, 'a', 33.079999999999998, 1.625, 'u', 'g', 'd', 'v', 0.54000000000000004, 'f', 'f', 0, 't', 'g', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (398, 'a', 23.579999999999998, 0.58499999999999996, 'y', 'p', 'ff', 'ff', 0.125, 'f', 'f', 0, 'f', 'g', 120, 87, '-');
INSERT INTO crx_dt_test VALUES (400, 'b', 31, 2.085, 'u', 'g', 'c', 'v', 0.085000000000000006, 'f', 'f', 0, 'f', 'g', 300, 0, '-');
INSERT INTO crx_dt_test VALUES (402, 'b', 28.920000000000002, 0.375, 'u', 'g', 'c', 'v', 0.28999999999999998, 'f', 'f', 0, 'f', 'g', 220, 140, '-');
INSERT INTO crx_dt_test VALUES (404, 'a', 22.670000000000002, 0.33500000000000002, 'u', 'g', 'q', 'v', 0.75, 'f', 'f', 0, 'f', 's', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (406, 'a', 69.5, 6, 'u', 'g', 'ff', 'ff', 0, 'f', 'f', 0, 'f', 's', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (408, 'a', 19.579999999999998, 0.66500000000000004, 'y', 'p', 'c', 'v', 1, 'f', 't', 1, 'f', 'g', 2000, 2, '-');
INSERT INTO crx_dt_test VALUES (410, 'b', 17.079999999999998, 0.25, 'u', 'g', 'q', 'v', 0.33500000000000002, 'f', 't', 4, 'f', 'g', 160, 8, '-');
INSERT INTO crx_dt_test VALUES (412, 'b', 25.170000000000002, 3, 'u', 'g', 'c', 'v', 1.25, 'f', 't', 1, 'f', 'g', 0, 22, '-');
INSERT INTO crx_dt_test VALUES (414, 'b', 40.579999999999998, 1.5, 'u', 'g', 'i', 'bb', 0, 'f', 'f', 0, 'f', 's', 300, 0, '-');
INSERT INTO crx_dt_test VALUES (416, 'a', 22.25, 1.25, 'y', 'p', 'ff', 'ff', 3.25, 'f', 'f', 0, 'f', 'g', 280, 0, '-');
INSERT INTO crx_dt_test VALUES (418, 'b', 23.579999999999998, 1.79, 'u', 'g', 'c', 'v', 0.54000000000000004, 'f', 'f', 0, 't', 'g', 136, 1, '-');
INSERT INTO crx_dt_test VALUES (420, 'a', 26.579999999999998, 2.54, 'y', 'p', 'ff', 'ff', 0, 'f', 'f', 0, 't', 'g', 180, 60, '-');
INSERT INTO crx_dt_test VALUES (422, 'b', 20.420000000000002, 1.085, 'u', 'g', 'q', 'v', 1.5, 'f', 'f', 0, 'f', 'g', 108, 7, '-');
INSERT INTO crx_dt_test VALUES (424, 'b', 26.170000000000002, 0.83499999999999996, 'u', 'g', 'cc', 'v', 1.165, 'f', 'f', 0, 'f', 'g', 100, 0, '-');
INSERT INTO crx_dt_test VALUES (426, 'b', 24.579999999999998, 1.25, 'u', 'g', 'c', 'v', 0.25, 'f', 'f', 0, 'f', 'g', 110, 0, '-');
INSERT INTO crx_dt_test VALUES (428, 'b', 37.5, 0.83499999999999996, 'u', 'g', 'e', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 120, 5, '-');
INSERT INTO crx_dt_test VALUES (430, 'b', 33.579999999999998, 0.33500000000000002, 'y', 'p', 'cc', 'v', 0.085000000000000006, 'f', 'f', 0, 'f', 'g', 180, 0, '-');
INSERT INTO crx_dt_test VALUES (432, 'b', 22.920000000000002, 3.165, 'y', 'p', 'c', 'v', 0.16500000000000001, 'f', 'f', 0, 'f', 'g', 160, 1058, '-');
INSERT INTO crx_dt_test VALUES (434, 'b', 25.25, 1, 'u', 'g', 'aa', 'v', 0.5, 'f', 'f', 0, 'f', 'g', 200, 0, '-');
INSERT INTO crx_dt_test VALUES (436, 'b', 19, 0, 'y', 'p', 'ff', 'ff', 0, 'f', 't', 4, 'f', 'g', 45, 1, '-');
INSERT INTO crx_dt_test VALUES (438, 'a', 53.329999999999998, 0.16500000000000001, 'u', 'g', 'ff', 'ff', 0, 'f', 'f', 0, 't', 's', 62, 27, '-');
INSERT INTO crx_dt_test VALUES (440, 'b', 25.920000000000002, 0.875, 'u', 'g', 'k', 'v', 0.375, 'f', 't', 2, 't', 'g', 174, 3, '-');
INSERT INTO crx_dt_test VALUES (442, 'b', 39.579999999999998, 5, 'u', 'g', 'ff', 'ff', 0, 'f', 't', 2, 'f', 'g', 17, 1, '-');
INSERT INTO crx_dt_test VALUES (444, 'b', 17.25, 3, 'u', 'g', 'k', 'v', 0.040000000000000001, 'f', 'f', 0, 't', 'g', 160, 40, '-');
INSERT INTO crx_dt_test VALUES (446, 'a', NULL, 11.25, 'u', 'g', 'ff', 'ff', 0, 'f', 'f', 0, 'f', 'g', NULL, 5200, '-');
INSERT INTO crx_dt_test VALUES (448, 'a', 27.329999999999998, 1.665, 'u', 'g', 'ff', 'ff', 0, 'f', 'f', 0, 'f', 'g', 340, 1, '-');
INSERT INTO crx_dt_test VALUES (450, 'b', 20, 7, 'u', 'g', 'c', 'v', 0.5, 'f', 'f', 0, 'f', 'g', 0, 0, '-');
INSERT INTO crx_dt_test VALUES (452, 'b', 39.5, 1.625, 'u', 'g', 'c', 'v', 1.5, 'f', 'f', 0, 'f', 'g', 0, 316, '-');
INSERT INTO crx_dt_test VALUES (454, NULL, 29.75, 0.66500000000000004, 'u', 'g', 'w', 'v', 0.25, 'f', 'f', 0, 't', 'g', 300, 0, '-');
INSERT INTO crx_dt_test VALUES (456, 'b', 36.170000000000002, 18.125, 'u', 'g', 'w', 'v', 0.085000000000000006, 'f', 'f', 0, 'f', 'g', 320, 3552, '-');
INSERT INTO crx_dt_test VALUES (458, 'b', 29.670000000000002, 0.75, 'y', 'p', 'c', 'v', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 240, 0, '-');
INSERT INTO crx_dt_test VALUES (460, 'b', 25.670000000000002, 0.28999999999999998, 'y', 'p', 'c', 'v', 1.5, 'f', 'f', 0, 't', 'g', 160, 0, '-');
INSERT INTO crx_dt_test VALUES (462, 'b', 24.079999999999998, 0.875, 'u', 'g', 'm', 'v', 0.085000000000000006, 'f', 't', 4, 'f', 'g', 254, 1950, '-');
INSERT INTO crx_dt_test VALUES (464, 'a', 36.579999999999998, 0.28999999999999998, 'u', 'g', 'ff', 'ff', 0, 'f', 't', 10, 'f', 'g', 200, 18, '-');
INSERT INTO crx_dt_test VALUES (466, 'a', 27.579999999999998, 3, 'u', 'g', 'm', 'v', 2.79, 'f', 't', 1, 't', 'g', 280, 10, '-');
INSERT INTO crx_dt_test VALUES (468, 'a', 30.420000000000002, 1.375, 'u', 'g', 'w', 'h', 0.040000000000000001, 'f', 't', 3, 'f', 'g', 0, 33, '-');
INSERT INTO crx_dt_test VALUES (470, 'b', 16.329999999999998, 4.085, 'u', 'g', 'i', 'h', 0.41499999999999998, 'f', 'f', 0, 't', 'g', 120, 0, '-');
INSERT INTO crx_dt_test VALUES (472, 'b', 21.079999999999998, 4.125, 'y', 'p', 'i', 'h', 0.040000000000000001, 'f', 'f', 0, 'f', 'g', 140, 100, '-');
INSERT INTO crx_dt_test VALUES (474, 'b', 19.170000000000002, 4, 'y', 'p', 'i', 'v', 1, 'f', 'f', 0, 't', 'g', 360, 1000, '-');
INSERT INTO crx_dt_test VALUES (476, 'b', 26.75, 2, 'u', 'g', 'd', 'v', 0.75, 'f', 'f', 0, 't', 'g', 80, 0, '-');
INSERT INTO crx_dt_test VALUES (478, 'b', 39.170000000000002, 2.5, 'y', 'p', 'i', 'h', 10, 'f', 'f', 0, 't', 's', 200, 0, '-');
INSERT INTO crx_dt_test VALUES (480, NULL, 26.5, 2.71, 'y', 'p', NULL, NULL, 0.085000000000000006, 'f', 'f', 0, 'f', 's', 80, 0, '-');
INSERT INTO crx_dt_test VALUES (482, 'b', 23.5, 3.165, 'y', 'p', 'k', 'v', 0.41499999999999998, 'f', 't', 1, 't', 'g', 280, 80, '-');
INSERT INTO crx_dt_test VALUES (484, 'b', 23.75, 0.41499999999999998, 'y', 'p', 'c', 'v', 0.040000000000000001, 'f', 't', 2, 'f', 'g', 128, 6, '-');
INSERT INTO crx_dt_test VALUES (486, 'b', 74.829999999999998, 19, 'y', 'p', 'ff', 'ff', 0.040000000000000001, 'f', 't', 2, 'f', 'g', 0, 351, '-');
INSERT INTO crx_dt_test VALUES (488, 'b', 24.5, 13.335000000000001, 'y', 'p', 'aa', 'v', 0.040000000000000001, 'f', 'f', 0, 't', 'g', 120, 475, '-');
INSERT INTO crx_dt_test VALUES (490, NULL, 45.329999999999998, 1, 'u', 'g', 'q', 'v', 0.125, 'f', 'f', 0, 't', 'g', 263, 0, '-');

drop function if exists rf_test( TEXT, TEXT, TEXT, TEXT,TEXT, INT,TEXT,INT);
CREATE OR REPLACE FUNCTION rf_test
    (
    training_set        TEXT,
    method              TEXT,
    cont_features       TEXT,
    class_column        TEXT,
    score_set           TEXT,
    tree_dep            INT,
    missing_operation   TEXT,
    num_of_tree         INT
    )
RETURNS TEXT AS $$
DECLARE
    result              TEXT;
    score_accuracy      FLOAT8;
    train_result        rf_train_result;
    tree_name           TEXT := 'trained_rf';
    classify_result     TEXT := 'classify_result';
    classify_result2    TEXT := 'classify_result2';
    size                INT;
    size_consistent     INT;
    pass                BOOL;
BEGIN
    result='PASS';

    train_result = rf_train(method,training_set,tree_name,
        num_of_tree,null,1,cont_features,null,'id',class_column,
        missing_operation,tree_dep,0,0,0);

    -- ensure we didn't change the variable names of the returned type
    EXECUTE 'SELECT COUNT(*) = 7 FROM pg_attribute
             WHERE attrelid = ''rf_train_result''::regclass and
                   attname IN (''training_time'', ''num_of_samples'',
                                ''num_trees'', ''features_per_node'',
                                ''num_tree_nodes'', ''max_tree_depth'',
                                ''split_criterion'')'
           INTO pass;
    IF (NOT pass) THEN
        result = 'FAIL';
        RAISE EXCEPTION 'Install check failed.';
    END IF;

    score_accuracy = rf_score(tree_name,score_set,0);
    -- parallel classify should work.
    PERFORM rf_classify(tree_name,score_set,classify_result,'f',0);

    -- serial classify should work.
    PERFORM rf_classify(tree_name,score_set,classify_result2,'t',0);

    -- Check the classification result is OK
    IF ( __table_exists(classify_result)
            AND __table_exists(classify_result2) ) THEN
        EXECUTE 'SELECT COUNT(*) FROM '||classify_result||';' INTO size;

        EXECUTE 'SELECT COUNT(*) FROM '||classify_result||' t1,'||classify_result2||
            ' t2 WHERE t1.id=t2.id AND t1.class=t2.class;' INTO size_consistent;

        EXECUTE 'DROP TABLE '||classify_result;
        EXECUTE 'DROP TABLE '||classify_result2;

        -- The results from the two classification method should be consistent.
        IF (size <> size_consistent) THEN
            result = 'FAIL';
            RAISE EXCEPTION 'Install check failed.';
        END IF;
    ELSE
        result = 'FAIL';
        RAISE EXCEPTION 'Install check failed.';
    END IF;

    PERFORM rf_clean(tree_name);

    -- Since random forest use sampling, the trained model varies each time.
    -- As a result, we cannot check the display result as the test for c4.5.
    -- But for the chosen data set, we should not get an accuracy lower than 0.8.
    IF (score_accuracy<0.8) THEN
        result = 'FAIL';
        RAISE EXCEPTION 'Install check failed.';
    END IF;
    RETURN result;
END
$$ language plpgsql;

SELECT rf_test('crx_dt_test','gini','A2,A3,A8,A11,A14,A15',
    'a16','crx_dt_test',10,'ignore',5);

SELECT rf_test('crx_dt_test','gainratio','A2,A3,A8,A11,A14,A15',
    'a16','crx_dt_test',10,'explicit',5);

SELECT rf_test('crx_dt_test','infogain','A2,A3,A8,A11,A14,A15',
    'a16','crx_dt_test',10,'explicit',5);