###################################################################################
###################################### 8.0.40 ###################################### 
###################################################################################

-- Build pulled from https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-boost-8.0.40.tar.gz


scl enable devtoolset-11 bash
MYSQL_VERSION="Bug116776"
TARGET=/export/home/tmp/ushastry/src/$MYSQL_VERSION
rm -rf /export/home/tmp/ushastry/src/$MYSQL_VERSION
rm -rf bld/
mkdir bld && cd bld
rm -rf CMakeCache.txt

/home/umshastr/work/binaries/utils/cmake-3.28.1/bin/cmake .. -DWITH_BOOST=../boost/ -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=Release -DWITH_SSL=system -DWITH_UNIT_TESTS=0  -DCMAKE_INSTALL_PREFIX=$TARGET -G Ninja
ninja -n 16
ninja install

cd $TARGET

BugNumber=116776
rm -rf $BugNumber/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/$BugNumber --log-error-verbosity=3
bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/$BugNumber --core-file --socket=/tmp/mysql.sock  --port=3306 --log-error=$PWD/$BugNumber/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1  2>&1 &


[umshastr@support-cluster03:/export/home/tmp/ushastry/src/Bug116776]$ bin/mysql -uroot -S/tmp/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.40 Source distribution

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database tpcds;
Query OK, 1 row affected (0.00 sec)

mysql> \q
Bye
[umshastr@support-cluster03:/export/home/tmp/ushastry/src/Bug116776]$ time bin/mysql -uroot -S/tmp/mysql.sock tpcds < /export/home/tmp/ushastry/src/reporter_dumps/tpcds_dump.sql

real	8m5.837s
user	0m9.112s
sys	0m0.404s

bin/mysql -uroot -S/tmp/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.40 Source distribution

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use tpcds
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> explain format=TREE select  i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact,
    ->  sum(ss_ext_sales_price) ext_price
    ->  from date_dim, store_sales, item,customer,customer_address,store
    ->  where d_date_sk = ss_sold_date_sk
    ->    and ss_item_sk = i_item_sk
    ->    and i_manager_id=7
    ->    and d_moy=11
    ->    and d_year=1999
    ->    and ss_customer_sk = c_customer_sk
    ->    and c_current_addr_sk = ca_address_sk
    ->    and substr(ca_zip,1,5) <> substr(s_zip,1,5)
    ->    and ss_store_sk = s_store_sk
    ->  group by i_brand
    ->       ,i_brand_id
    ->       ,i_manufact_id
    ->       ,i_manufact
    ->  order by ext_price desc
    ->          ,i_brand
    ->          ,i_brand_id
    ->          ,i_manufact_id
    ->          ,i_manufact
    -> limit 100\G
*************************** 1. row ***************************
EXPLAIN: -> Limit: 100 row(s)
    -> Sort: ext_price DESC, item.i_brand, item.i_brand_id, item.i_manufact_id, item.i_manufact, limit input to 100 row(s) per chunk
        -> Table scan on <temporary>
            -> Aggregate using temporary table
                -> Nested loop inner join  (cost=80777 rows=1173)
                    -> Nested loop inner join  (cost=79681 rows=1173)
                        -> Nested loop inner join  (cost=78586 rows=1173)
                            -> Nested loop inner join  (cost=56682 rows=23469)
                                -> Inner hash join (no condition)  (cost=4323 rows=2082)
                                    -> Filter: (item.i_manager_id = 7)  (cost=201 rows=1735)
                                        -> Table scan on item  (cost=201 rows=17347)
                                    -> Hash
                                        -> Table scan on store  (cost=2.2 rows=12)
                                -> Filter: ((store_sales.ss_store_sk = store.s_store_sk) and (store_sales.ss_sold_date_sk is not null) and (store_sales.ss_customer_sk is not null))  (cost=1.39 rows=11.3)
                                    -> Index lookup on store_sales using PRIMARY (ss_item_sk=item.i_item_sk)  (cost=1.39 rows=113)
                            -> Filter: ((date_dim.d_year = 1999) and (date_dim.d_moy = 11))  (cost=0.0833 rows=0.05)
                                -> Single-row index lookup on date_dim using PRIMARY (d_date_sk=store_sales.ss_sold_date_sk)  (cost=0.0833 rows=1)
                        -> Filter: (customer.c_current_addr_sk is not null)  (cost=0.0833 rows=1)
                            -> Single-row index lookup on customer using PRIMARY (c_customer_sk=store_sales.ss_customer_sk)  (cost=0.0833 rows=1)
                    -> Filter: (substr(customer_address.ca_zip,1,5) <> substr(store.s_zip,1,5))  (cost=0.0833 rows=1)
                        -> Single-row index lookup on customer_address using PRIMARY (ca_address_sk=customer.c_current_addr_sk)  (cost=0.0833 rows=1)

1 row in set (0.00 sec)

mysql> select  i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact,
    ->  sum(ss_ext_sales_price) ext_price
    ->  from date_dim, store_sales, item,customer,customer_address,store
    ->  where d_date_sk = ss_sold_date_sk
    ->    and ss_item_sk = i_item_sk
    ->    and i_manager_id=7
    ->    and d_moy=11
    ->    and d_year=1999
    ->    and ss_customer_sk = c_customer_sk
    ->    and c_current_addr_sk = ca_address_sk
    ->    and substr(ca_zip,1,5) <> substr(s_zip,1,5)
    ->    and ss_store_sk = s_store_sk
    ->  group by i_brand
    ->       ,i_brand_id
    ->       ,i_manufact_id
    ->       ,i_manufact
    ->  order by ext_price desc
    ->          ,i_brand
    ->          ,i_brand_id
    ->          ,i_manufact_id
    ->          ,i_manufact
    -> limit 100;
+----------+-----------------------+---------------+-----------------+-----------+
| brand_id | brand                 | i_manufact_id | i_manufact      | ext_price |
+----------+-----------------------+---------------+-----------------+-----------+
|  8013005 | exportimaxi #5        |            87 | ationeing       |  67191.09 |
|  2001001 | amalgimporto #1       |           986 | callyeingn st   |  47365.82 |
|  4003002 | exportiedu pack #2    |           207 | ationbarable    |  46186.82 |
|  7010007 | univnameless #7       |           873 | priationeing    |  44941.82 |
|  1003001 | exportiamalg #1       |           330 | barpripri       |  44623.51 |
|  7008002 | namelessbrand #2      |           610 | baroughtcally   |  40391.19 |
|  8003007 | exportinameless #7    |           330 | barpripri       |  39360.88 |
|  1003001 | exportiamalg #1       |           151 | oughtantiought  |  38014.92 |
|  1001002 | amalgamalg #2         |           185 | antieingought   |  37903.19 |
|  8001008 | amalgnameless #8      |           293 | prin stable     |  37677.71 |
|  8011007 | amalgmaxi #7          |           291 | oughtn stable   |  37183.53 |
|  1004002 | edu packamalg #2      |           345 | antiesepri      |  36754.49 |
|  6015006 | scholarbrand #6       |           294 | esen stable     |  36075.25 |
|  2002002 | importoimporto #2     |           312 | ableoughtpri    |  35733.22 |
|  7010009 | univnameless #9       |             9 | n st            |  34761.98 |
| 10002008 | importounivamalg #8   |           271 | oughtationable  |  33816.85 |
|  6016006 | corpbrand #6          |           965 | anticallyn st   |  32961.34 |
|  1001001 | amalgamalg #1         |           180 | bareingought    |  32076.40 |
|  2004001 | edu packimporto #1    |           222 | ableableable    |  31528.48 |
|  2004001 | edu packimporto #1    |           166 | callycallyought |  31523.09 |
|  6006001 | corpcorp #1           |           268 | eingcallyable   |  30973.78 |
|  5004002 | edu packscholar #2    |           547 | ationeseanti    |  30859.76 |
|  7010007 | univnameless #7       |           402 | ablebarese      |  30423.54 |
|  6004005 | edu packcorp #5       |           139 | n stpriought    |  30332.13 |
|  7010003 | univnameless #3       |            78 | eingation       |  29390.96 |
|  8004007 | edu packnameless #7   |            65 | antically       |  29165.52 |
|  1004001 | edu packamalg #1      |           462 | ablecallyese    |  28599.14 |
|  4001002 | amalgedu pack #2      |           669 | n stcallycally  |  28495.38 |
|  4001001 | amalgedu pack #1      |           284 | eseeingable     |  27971.15 |
|  6010005 | univbrand #5          |           572 | ableationanti   |  27809.46 |
|  3003001 | exportiexporti #1     |           550 | barantianti     |  27766.61 |
|  2002001 | importoimporto #1     |            97 | ationn st       |  27506.82 |
|  3003001 | exportiexporti #1     |           220 | barableable     |  27401.95 |
|  5002002 | importoscholar #2     |           427 | ationableese    |  27283.13 |
|  5003002 | exportischolar #2     |            88 | eingeing        |  26989.73 |
|  8006009 | corpnameless #9       |            83 | prieing         |  26918.46 |
|  3001001 | amalgexporti #1       |            18 | eingought       |  26762.47 |
|  7014005 | edu packnameless #5   |           142 | ableeseought    |  26675.08 |
|  2004002 | edu packimporto #2    |           481 | oughteingese    |  26662.07 |
|  3001001 | amalgexporti #1       |            47 | ationese        |  26372.12 |
|  5002001 | importoscholar #1     |            57 | ationanti       |  26027.83 |
|  4004001 | edu packedu pack #1   |            32 | ablepri         |  25877.47 |
| 10011002 | amalgamalgamalg #2    |           859 | n stantieing    |  25651.62 |
|  5002002 | importoscholar #2     |           544 | eseeseanti      |  25548.12 |
|  9014011 | edu packunivamalg #11 |            15 | antiought       |  25521.64 |
|  3003001 | exportiexporti #1     |           757 | ationantiation  |  25208.23 |
|  8005007 | scholarnameless #7    |           206 | callybarable    |  24979.05 |
|  5003001 | exportischolar #1     |           887 | ationeingeing   |  24047.50 |
|  7005001 | scholarbrand #1       |           181 | oughteingought  |  23987.07 |
|  1001002 | amalgamalg #2         |            21 | oughtable       |  23946.44 |
|  4001001 | amalgedu pack #1      |           167 | ationcallyought |  23746.65 |
|  2002002 | importoimporto #2     |           301 | oughtbarpri     |  23648.30 |
|  8001007 | amalgnameless #7      |           154 | eseantiought    |  23507.61 |
|  5001001 | amalgscholar #1       |           684 | eseeingcally    |  23381.97 |
|  5002001 | importoscholar #1     |            97 | ationn st       |  23344.32 |
|  9005003 | scholarmaxi #3        |           605 | antibarcally    |  22998.50 |
|  4001001 | amalgedu pack #1      |           590 | barn stanti     |  22167.05 |
| 10013006 | exportiamalgamalg #6  |            13 | priought        |  22099.34 |
|  5002001 | importoscholar #1     |            69 | n stcally       |  21970.66 |
|  1002001 | importoamalg #1       |           884 | eseeingeing     |  21931.73 |
|  6011007 | amalgbrand #7         |           284 | eseeingable     |  21624.09 |
|  3004001 | edu packexporti #1    |           357 | ationantipri    |  21406.80 |
|  8010003 | univmaxi #3           |           314 | eseoughtpri     |  21073.01 |
|  8001001 | amalgnameless #1      |           329 | n stablepri     |  20822.23 |
|  6008002 | namelesscorp #2       |           328 | eingablepri     |  20323.83 |
|  3002001 | importoexporti #1     |           649 | n stesecally    |  20279.23 |
| 10015004 | scholaramalgamalg #4  |           545 | antieseanti     |  20242.55 |
|  6015002 | scholarbrand #2       |            21 | oughtable       |  19870.18 |
|  2001001 | amalgimporto #1       |           685 | antieingcally   |  19839.83 |
|  5004001 | edu packscholar #1    |           158 | eingantiought   |  19651.24 |
|  9011011 | amalgunivamalg #11    |           751 | oughtantiation  |  19559.87 |
|  8014002 | edu packmaxi #2       |           257 | ationantiable   |  19418.66 |
|  6005002 | scholarcorp #2        |           164 | esecallyought   |  19401.51 |
|  8006007 | corpnameless #7       |           602 | ablebarcally    |  19376.16 |
|  1001001 | amalgamalg #1         |           179 | n stationought  |  19364.84 |
|  7009002 | maxibrand #2          |           233 | pripriable      |  19330.62 |
|  8016002 | corpmaxi #2           |            81 | oughteing       |  19256.59 |
|  7004003 | edu packbrand #3      |           431 | oughtpriese     |  19235.10 |
|  1002001 | importoamalg #1       |           185 | antieingought   |  19087.58 |
|  4003002 | exportiedu pack #2    |           825 | antiableeing    |  18583.50 |
|  7009009 | maxibrand #9          |           326 | callyablepri    |  18296.43 |
|  8005003 | scholarnameless #3    |           159 | n stantiought   |  18253.81 |
|  6010006 | univbrand #6          |           262 | ablecallyable   |  18210.00 |
|  3001001 | amalgexporti #1       |            30 | barpri          |  18194.49 |
|  2003001 | exportiimporto #1     |           160 | barcallyought   |  18193.04 |
|  9014008 | edu packunivamalg #8  |           639 | n stprically    |  17681.66 |
|  4004002 | edu packedu pack #2   |           384 | eseeingpri      |  17603.60 |
| 10002005 | importounivamalg #5   |           485 | antieingese     |  17531.27 |
|  7006007 | corpbrand #7          |           189 | n steingought   |  17411.51 |
|  8013003 | exportimaxi #3        |           561 | oughtcallyanti  |  16910.70 |
|  3004002 | edu packexporti #2    |            83 | prieing         |  16797.48 |
|  3002002 | importoexporti #2     |            50 | baranti         |  16694.48 |
|  3002002 | importoexporti #2     |            52 | ableanti        |  15965.99 |
|  9006005 | corpmaxi #5           |           839 | n stprieing     |  15858.10 |
|  2004001 | edu packimporto #1    |            25 | antiable        |  15815.64 |
|  2001001 | amalgimporto #1       |           233 | pripriable      |  15521.92 |
|  7016007 | corpnameless #7       |           288 | eingeingable    |  15350.10 |
|  2002002 | importoimporto #2     |           426 | callyableese    |  15194.31 |
|  5001001 | amalgscholar #1       |           125 | antiableought   |  15053.03 |
|  4003001 | exportiedu pack #1    |           505 | antibaranti     |  15003.18 |
+----------+-----------------------+---------------+-----------------+-----------+
100 rows in set (0.31 sec)
.
100 rows in set (0.29 sec)
100 rows in set (0.28 sec)
100 rows in set (0.27 sec)
100 rows in set (0.28 sec)




############################################################################
###################################### apply patch on top of 8.0.40
############################################################################

scl enable devtoolset-11 bash
MYSQL_VERSION="Bug116776_patched"
TARGET=/export/home/tmp/ushastry/src/$MYSQL_VERSION
rm -rf /export/home/tmp/ushastry/src/$MYSQL_VERSION
rm -rf bld/
mkdir bld && cd bld
rm -rf CMakeCache.txt

/home/umshastr/work/binaries/utils/cmake-3.28.1/bin/cmake .. -DWITH_BOOST=../boost/ -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=Release -DWITH_SSL=system -DWITH_UNIT_TESTS=0  -DCMAKE_INSTALL_PREFIX=$TARGET -G Ninja
ninja -j8
ninja install


cd $TARGET

BugNumber=116776
rm -rf $BugNumber/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/$BugNumber --log-error-verbosity=3
bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/$BugNumber --core-file --socket=/tmp/mysql.sock  --port=3306 --log-error=$PWD/$BugNumber/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1  2>&1 &

[umshastr@support-cluster03:/export/home/tmp/ushastry/src/Bug116776_patched]$ bin/mysql -uroot -S/tmp/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.40 Source distribution

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database tpcds;
Query OK, 1 row affected (0.00 sec)

mysql> \q
Bye
[umshastr@support-cluster03:/export/home/tmp/ushastry/src/Bug116776_patched]$ time bin/mysql -uroot -S/tmp/mysql.sock tpcds < /export/home/tmp/ushastry/src/reporter_dumps/tpcds_dump.sql

real	8m8.974s
user	0m9.075s
sys	0m0.409s
[umshastr@support-cluster03:/export/home/tmp/ushastry/src/Bug116776_patched]$ bin/mysql -uroot -S/tmp/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.40 Source distribution

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use tpcds
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> explain format=TREE select  i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact,
    ->  sum(ss_ext_sales_price) ext_price
    ->  from date_dim, store_sales, item,customer,customer_address,store
    ->  where d_date_sk = ss_sold_date_sk
    ->    and ss_item_sk = i_item_sk
    ->    and i_manager_id=7
    ->    and d_moy=11
    ->    and d_year=1999
    ->    and ss_customer_sk = c_customer_sk
    ->    and c_current_addr_sk = ca_address_sk
    ->    and substr(ca_zip,1,5) <> substr(s_zip,1,5)
    ->    and ss_store_sk = s_store_sk
    ->  group by i_brand
    ->       ,i_brand_id
    ->       ,i_manufact_id
    ->       ,i_manufact
    ->  order by ext_price desc
    ->          ,i_brand
    ->          ,i_brand_id
    ->          ,i_manufact_id
    ->          ,i_manufact
    -> limit 100\G
*************************** 1. row ***************************
EXPLAIN: -> Limit: 100 row(s)
    -> Sort: ext_price DESC, item.i_brand, item.i_brand_id, item.i_manufact_id, item.i_manufact, limit input to 100 row(s) per chunk
        -> Table scan on <temporary>
            -> Aggregate using temporary table
                -> Nested loop inner join  (cost=2420 rows=62.5e-9)
                    -> Nested loop inner join  (cost=2420 rows=1.25e-6)
                        -> Nested loop inner join  (cost=2420 rows=25e-6)
                            -> Nested loop inner join  (cost=2420 rows=0.0025)
                                -> Nested loop inner join  (cost=2420 rows=0.0025)
                                    -> Filter: (item.i_manager_id = 7)  (cost=2419 rows=0.05)
                                        -> Table scan on item  (cost=2419 rows=17472)
                                    -> Filter: ((store_sales.ss_store_sk is not null) and (store_sales.ss_sold_date_sk is not null) and (store_sales.ss_customer_sk is not null))  (cost=1.52 rows=0.05)
                                        -> Index lookup on store_sales using PRIMARY (ss_item_sk=item.i_item_sk)  (cost=1.52 rows=123)
                                -> Single-row index lookup on store using PRIMARY (s_store_sk=store_sales.ss_store_sk)  (cost=3 rows=1)
                            -> Filter: ((date_dim.d_year = 1999) and (date_dim.d_moy = 11))  (cost=9 rows=0.01)
                                -> Single-row index lookup on date_dim using PRIMARY (d_date_sk=store_sales.ss_sold_date_sk)  (cost=9 rows=1)
                        -> Filter: (customer.c_current_addr_sk is not null)  (cost=4001 rows=0.05)
                            -> Single-row index lookup on customer using PRIMARY (c_customer_sk=store_sales.ss_customer_sk)  (cost=4001 rows=1)
                    -> Filter: (substr(customer_address.ca_zip,1,5) <> substr(store.s_zip,1,5))  (cost=80001 rows=0.05)
                        -> Single-row index lookup on customer_address using PRIMARY (ca_address_sk=customer.c_current_addr_sk)  (cost=80001 rows=1)

1 row in set (0.00 sec)

mysql> select  i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact,  sum(ss_ext_sales_price) ext_price  from date_dim, store_sales, item,customer,customer_address,store  where d_date_sk = ss_sold_date_sk    and ss_item_sk = i_item_sk    and i_manager_id=7    and d_moy=11    and d_year=1999    and ss_customer_sk = c_customer_sk     and c_current_addr_sk = ca_address_sk    and substr(ca_zip,1,5) <> substr(s_zip,1,5)     and ss_store_sk = s_store_sk   group by i_brand       ,i_brand_id       ,i_manufact_id       ,i_manufact  order by ext_price desc          ,i_brand          ,i_brand_id          ,i_manufact_id          ,i_manufact limit 100;
+----------+-----------------------+---------------+-----------------+-----------+
| brand_id | brand                 | i_manufact_id | i_manufact      | ext_price |
+----------+-----------------------+---------------+-----------------+-----------+
|  8013005 | exportimaxi #5        |            87 | ationeing       |  67191.09 |
|  2001001 | amalgimporto #1       |           986 | callyeingn st   |  47365.82 |
|  4003002 | exportiedu pack #2    |           207 | ationbarable    |  46186.82 |
|  7010007 | univnameless #7       |           873 | priationeing    |  44941.82 |
|  1003001 | exportiamalg #1       |           330 | barpripri       |  44623.51 |
|  7008002 | namelessbrand #2      |           610 | baroughtcally   |  40391.19 |
|  8003007 | exportinameless #7    |           330 | barpripri       |  39360.88 |
|  1003001 | exportiamalg #1       |           151 | oughtantiought  |  38014.92 |
|  1001002 | amalgamalg #2         |           185 | antieingought   |  37903.19 |
|  8001008 | amalgnameless #8      |           293 | prin stable     |  37677.71 |
|  8011007 | amalgmaxi #7          |           291 | oughtn stable   |  37183.53 |
|  1004002 | edu packamalg #2      |           345 | antiesepri      |  36754.49 |
|  6015006 | scholarbrand #6       |           294 | esen stable     |  36075.25 |
|  2002002 | importoimporto #2     |           312 | ableoughtpri    |  35733.22 |
|  7010009 | univnameless #9       |             9 | n st            |  34761.98 |
| 10002008 | importounivamalg #8   |           271 | oughtationable  |  33816.85 |
|  6016006 | corpbrand #6          |           965 | anticallyn st   |  32961.34 |
|  1001001 | amalgamalg #1         |           180 | bareingought    |  32076.40 |
|  2004001 | edu packimporto #1    |           222 | ableableable    |  31528.48 |
|  2004001 | edu packimporto #1    |           166 | callycallyought |  31523.09 |
|  6006001 | corpcorp #1           |           268 | eingcallyable   |  30973.78 |
|  5004002 | edu packscholar #2    |           547 | ationeseanti    |  30859.76 |
|  7010007 | univnameless #7       |           402 | ablebarese      |  30423.54 |
|  6004005 | edu packcorp #5       |           139 | n stpriought    |  30332.13 |
|  7010003 | univnameless #3       |            78 | eingation       |  29390.96 |
|  8004007 | edu packnameless #7   |            65 | antically       |  29165.52 |
|  1004001 | edu packamalg #1      |           462 | ablecallyese    |  28599.14 |
|  4001002 | amalgedu pack #2      |           669 | n stcallycally  |  28495.38 |
|  4001001 | amalgedu pack #1      |           284 | eseeingable     |  27971.15 |
|  6010005 | univbrand #5          |           572 | ableationanti   |  27809.46 |
|  3003001 | exportiexporti #1     |           550 | barantianti     |  27766.61 |
|  2002001 | importoimporto #1     |            97 | ationn st       |  27506.82 |
|  3003001 | exportiexporti #1     |           220 | barableable     |  27401.95 |
|  5002002 | importoscholar #2     |           427 | ationableese    |  27283.13 |
|  5003002 | exportischolar #2     |            88 | eingeing        |  26989.73 |
|  8006009 | corpnameless #9       |            83 | prieing         |  26918.46 |
|  3001001 | amalgexporti #1       |            18 | eingought       |  26762.47 |
|  7014005 | edu packnameless #5   |           142 | ableeseought    |  26675.08 |
|  2004002 | edu packimporto #2    |           481 | oughteingese    |  26662.07 |
|  3001001 | amalgexporti #1       |            47 | ationese        |  26372.12 |
|  5002001 | importoscholar #1     |            57 | ationanti       |  26027.83 |
|  4004001 | edu packedu pack #1   |            32 | ablepri         |  25877.47 |
| 10011002 | amalgamalgamalg #2    |           859 | n stantieing    |  25651.62 |
|  5002002 | importoscholar #2     |           544 | eseeseanti      |  25548.12 |
|  9014011 | edu packunivamalg #11 |            15 | antiought       |  25521.64 |
|  3003001 | exportiexporti #1     |           757 | ationantiation  |  25208.23 |
|  8005007 | scholarnameless #7    |           206 | callybarable    |  24979.05 |
|  5003001 | exportischolar #1     |           887 | ationeingeing   |  24047.50 |
|  7005001 | scholarbrand #1       |           181 | oughteingought  |  23987.07 |
|  1001002 | amalgamalg #2         |            21 | oughtable       |  23946.44 |
|  4001001 | amalgedu pack #1      |           167 | ationcallyought |  23746.65 |
|  2002002 | importoimporto #2     |           301 | oughtbarpri     |  23648.30 |
|  8001007 | amalgnameless #7      |           154 | eseantiought    |  23507.61 |
|  5001001 | amalgscholar #1       |           684 | eseeingcally    |  23381.97 |
|  5002001 | importoscholar #1     |            97 | ationn st       |  23344.32 |
|  9005003 | scholarmaxi #3        |           605 | antibarcally    |  22998.50 |
|  4001001 | amalgedu pack #1      |           590 | barn stanti     |  22167.05 |
| 10013006 | exportiamalgamalg #6  |            13 | priought        |  22099.34 |
|  5002001 | importoscholar #1     |            69 | n stcally       |  21970.66 |
|  1002001 | importoamalg #1       |           884 | eseeingeing     |  21931.73 |
|  6011007 | amalgbrand #7         |           284 | eseeingable     |  21624.09 |
|  3004001 | edu packexporti #1    |           357 | ationantipri    |  21406.80 |
|  8010003 | univmaxi #3           |           314 | eseoughtpri     |  21073.01 |
|  8001001 | amalgnameless #1      |           329 | n stablepri     |  20822.23 |
|  6008002 | namelesscorp #2       |           328 | eingablepri     |  20323.83 |
|  3002001 | importoexporti #1     |           649 | n stesecally    |  20279.23 |
| 10015004 | scholaramalgamalg #4  |           545 | antieseanti     |  20242.55 |
|  6015002 | scholarbrand #2       |            21 | oughtable       |  19870.18 |
|  2001001 | amalgimporto #1       |           685 | antieingcally   |  19839.83 |
|  5004001 | edu packscholar #1    |           158 | eingantiought   |  19651.24 |
|  9011011 | amalgunivamalg #11    |           751 | oughtantiation  |  19559.87 |
|  8014002 | edu packmaxi #2       |           257 | ationantiable   |  19418.66 |
|  6005002 | scholarcorp #2        |           164 | esecallyought   |  19401.51 |
|  8006007 | corpnameless #7       |           602 | ablebarcally    |  19376.16 |
|  1001001 | amalgamalg #1         |           179 | n stationought  |  19364.84 |
|  7009002 | maxibrand #2          |           233 | pripriable      |  19330.62 |
|  8016002 | corpmaxi #2           |            81 | oughteing       |  19256.59 |
|  7004003 | edu packbrand #3      |           431 | oughtpriese     |  19235.10 |
|  1002001 | importoamalg #1       |           185 | antieingought   |  19087.58 |
|  4003002 | exportiedu pack #2    |           825 | antiableeing    |  18583.50 |
|  7009009 | maxibrand #9          |           326 | callyablepri    |  18296.43 |
|  8005003 | scholarnameless #3    |           159 | n stantiought   |  18253.81 |
|  6010006 | univbrand #6          |           262 | ablecallyable   |  18210.00 |
|  3001001 | amalgexporti #1       |            30 | barpri          |  18194.49 |
|  2003001 | exportiimporto #1     |           160 | barcallyought   |  18193.04 |
|  9014008 | edu packunivamalg #8  |           639 | n stprically    |  17681.66 |
|  4004002 | edu packedu pack #2   |           384 | eseeingpri      |  17603.60 |
| 10002005 | importounivamalg #5   |           485 | antieingese     |  17531.27 |
|  7006007 | corpbrand #7          |           189 | n steingought   |  17411.51 |
|  8013003 | exportimaxi #3        |           561 | oughtcallyanti  |  16910.70 |
|  3004002 | edu packexporti #2    |            83 | prieing         |  16797.48 |
|  3002002 | importoexporti #2     |            50 | baranti         |  16694.48 |
|  3002002 | importoexporti #2     |            52 | ableanti        |  15965.99 |
|  9006005 | corpmaxi #5           |           839 | n stprieing     |  15858.10 |
|  2004001 | edu packimporto #1    |            25 | antiable        |  15815.64 |
|  2001001 | amalgimporto #1       |           233 | pripriable      |  15521.92 |
|  7016007 | corpnameless #7       |           288 | eingeingable    |  15350.10 |
|  2002002 | importoimporto #2     |           426 | callyableese    |  15194.31 |
|  5001001 | amalgscholar #1       |           125 | antiableought   |  15053.03 |
|  4003001 | exportiedu pack #1    |           505 | antibaranti     |  15003.18 |
+----------+-----------------------+---------------+-----------------+-----------+
100 rows in set (0.13 sec)
.
100 rows in set (0.13 sec)
100 rows in set (0.12 sec)
100 rows in set (0.12 sec)
100 rows in set (0.13 sec)