[root@mysqldevtest ~]# cat Dump-testcase2-script1.sql | mysql test [root@mysqldevtest ~]# mysql test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.24 MySQL Community Server (GPL) Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. 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> call sp_test6('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -84.2105 | | NULL STRING | -80 | | NULL STRING | -79.2453 | | NULL STRING | -78.9474 | | NULL STRING | -77.7778 | | NULL STRING | -77.4194 | | NULL STRING | -76.1905 | | NULL STRING | -75.8621 | | NULL STRING | -75 | | NULL STRING | -74 | | NULL STRING | -73.4694 | | NULL STRING | -72.973 | | NULL STRING | -71.831 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -65 | | NULL STRING | -62.5 | | NULL STRING | -61.9048 | | NULL STRING | -61.4583 | | NULL STRING | -61.1111 | | NULL STRING | -60.3774 | | NULL STRING | -60 | | NULL STRING | -59.7701 | | NULL STRING | -59.1837 | | NULL STRING | -58.0645 | | NULL STRING | -56.0606 | | NULL STRING | -54.5455 | | NULL STRING | -53.8462 | | NULL STRING | -53.3333 | | NULL STRING | -52.2388 | | NULL STRING | -51.2821 | | NULL STRING | -50 | | NULL STRING | -49.1803 | | NULL STRING | -49.0196 | | NULL STRING | -46.6667 | | NULL STRING | -45.8333 | | NULL STRING | -45.098 | | NULL STRING | -42.5532 | | NULL STRING | -40.625 | | NULL STRING | -38.4615 | +-------------------+--------------+ 40 rows in set (0.01 sec) Query OK, 0 rows affected (0.01 sec) mysql> DELETE FROM RawData WHERE rowid <>22364454717488109; Query OK, 44 rows affected (0.00 sec) mysql> call sp_test6('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -52.2388 | +-------------------+--------------+ 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> \. Dump-testcase2-script3.sql Query OK, 44 rows affected (0.00 sec) Records: 44 Duplicates: 0 Warnings: 0 mysql> call sp_test6('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -84.2105 | | NULL STRING | -80 | | NULL STRING | -79.2453 | | NULL STRING | -78.9474 | | NULL STRING | -77.7778 | | NULL STRING | -77.4194 | | NULL STRING | -76.1905 | | NULL STRING | -75.8621 | | NULL STRING | -75 | | NULL STRING | -74 | | NULL STRING | -73.4694 | | NULL STRING | -72.973 | | NULL STRING | -71.831 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -65 | | NULL STRING | -62.5 | | NULL STRING | -61.9048 | | NULL STRING | -61.4583 | | NULL STRING | -61.1111 | | NULL STRING | -60.3774 | | NULL STRING | -60 | | NULL STRING | -59.7701 | | NULL STRING | -59.1837 | | NULL STRING | -58.0645 | | NULL STRING | -56.0606 | | NULL STRING | -54.5455 | | NULL STRING | -53.8462 | | NULL STRING | -53.3333 | | NULL STRING | -52.2388 | | NULL STRING | -51.2821 | | NULL STRING | -50 | | NULL STRING | -49.1803 | | NULL STRING | -49.0196 | | NULL STRING | -46.6667 | | NULL STRING | -45.8333 | | NULL STRING | -45.098 | | NULL STRING | -42.5532 | | NULL STRING | -40.625 | | NULL STRING | -38.4615 | +-------------------+--------------+ 40 rows in set (0.01 sec) Query OK, 0 rows affected (0.01 sec) mysql> call sp_test7('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -84.2105 | | NULL STRING | -80 | | NULL STRING | -79.2453 | | NULL STRING | -78.9474 | | NULL STRING | -77.7778 | | NULL STRING | -77.7778 | | NULL STRING | -77.4194 | | NULL STRING | -76.1905 | | NULL STRING | -75.8621 | | NULL STRING | -75 | | NULL STRING | -74 | | NULL STRING | -73.4694 | | NULL STRING | -73.4694 | | NULL STRING | -72.973 | | NULL STRING | -71.831 | | NULL STRING | -68.75 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -65 | | NULL STRING | -62.5 | | NULL STRING | -61.9048 | | NULL STRING | -61.4583 | | NULL STRING | -61.1111 | | NULL STRING | -60.3774 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -59.7701 | | NULL STRING | -59.1837 | | NULL STRING | -58.0645 | | NULL STRING | -56.0606 | | NULL STRING | -54.5455 | | NULL STRING | -53.8462 | | NULL STRING | -53.3333 | | NULL STRING | -52.2388 | | NULL STRING | -51.2821 | | NULL STRING | -50 | | NULL STRING | -49.1803 | | NULL STRING | -49.0196 | | NULL STRING | -46.6667 | | NULL STRING | -45.8333 | | NULL STRING | -45.098 | | NULL STRING | -42.5532 | | NULL STRING | -40.625 | | NULL STRING | -38.4615 | +-------------------+--------------+ 45 rows in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> DELETE FROM RawData WHERE rowid <>22364454717488109; Query OK, 44 rows affected (0.00 sec) mysql> call sp_test7('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -52.2388 | +-------------------+--------------+ 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> \. Dump-testcase2-script3.sql Query OK, 44 rows affected (0.00 sec) Records: 44 Duplicates: 0 Warnings: 0 mysql> call sp_test7('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -73.4694 | | NULL STRING | -77.7778 | | NULL STRING | -74 | | NULL STRING | -61.9048 | | NULL STRING | -54.5455 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -49.1803 | | NULL STRING | -45.8333 | | NULL STRING | -79.2453 | | NULL STRING | -59.1837 | | NULL STRING | -53.8462 | | NULL STRING | -77.7778 | | NULL STRING | -40.625 | | NULL STRING | -56.0606 | | NULL STRING | -75 | | NULL STRING | -68.75 | | NULL STRING | -60 | | NULL STRING | -73.4694 | | NULL STRING | -61.4583 | | NULL STRING | -50 | | NULL STRING | -77.4194 | | NULL STRING | -38.4615 | | NULL STRING | -49.0196 | | NULL STRING | -65 | | NULL STRING | -51.2821 | | NULL STRING | -53.3333 | | NULL STRING | -80 | | NULL STRING | -52.2388 | | NULL STRING | -71.831 | | NULL STRING | -42.5532 | | NULL STRING | -58.0645 | | NULL STRING | -45.098 | | NULL STRING | -62.5 | | NULL STRING | -75.8621 | | NULL STRING | -46.6667 | | NULL STRING | -60.3774 | | NULL STRING | -76.1905 | | NULL STRING | -67.9012 | | NULL STRING | -68.75 | | NULL STRING | -78.9474 | | NULL STRING | -84.2105 | | NULL STRING | -72.973 | | NULL STRING | -61.1111 | | NULL STRING | -59.7701 | +-------------------+--------------+ 45 rows in set (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql> call sp_reset_sp(); Query OK, 0 rows affected (0.00 sec) mysql> call sp_test7('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -84.2105 | | NULL STRING | -80 | | NULL STRING | -79.2453 | | NULL STRING | -78.9474 | | NULL STRING | -77.7778 | | NULL STRING | -77.7778 | | NULL STRING | -77.4194 | | NULL STRING | -76.1905 | | NULL STRING | -75.8621 | | NULL STRING | -75 | | NULL STRING | -74 | | NULL STRING | -73.4694 | | NULL STRING | -73.4694 | | NULL STRING | -72.973 | | NULL STRING | -71.831 | | NULL STRING | -68.75 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -65 | | NULL STRING | -62.5 | | NULL STRING | -61.9048 | | NULL STRING | -61.4583 | | NULL STRING | -61.1111 | | NULL STRING | -60.3774 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -59.7701 | | NULL STRING | -59.1837 | | NULL STRING | -58.0645 | | NULL STRING | -56.0606 | | NULL STRING | -54.5455 | | NULL STRING | -53.8462 | | NULL STRING | -53.3333 | | NULL STRING | -52.2388 | | NULL STRING | -51.2821 | | NULL STRING | -50 | | NULL STRING | -49.1803 | | NULL STRING | -49.0196 | | NULL STRING | -46.6667 | | NULL STRING | -45.8333 | | NULL STRING | -45.098 | | NULL STRING | -42.5532 | | NULL STRING | -40.625 | | NULL STRING | -38.4615 | +-------------------+--------------+ 45 rows in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> call sp_test8('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -84.2105 | | NULL STRING | -80 | | NULL STRING | -79.2453 | | NULL STRING | -78.9474 | | NULL STRING | -77.7778 | | NULL STRING | -77.4194 | | NULL STRING | -76.1905 | | NULL STRING | -75.8621 | | NULL STRING | -75 | | NULL STRING | -74 | | NULL STRING | -73.4694 | | NULL STRING | -72.973 | | NULL STRING | -71.831 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -65 | | NULL STRING | -62.5 | | NULL STRING | -61.9048 | | NULL STRING | -61.4583 | | NULL STRING | -61.1111 | | NULL STRING | -60.3774 | | NULL STRING | -60 | | NULL STRING | -59.7701 | | NULL STRING | -59.1837 | | NULL STRING | -58.0645 | | NULL STRING | -56.0606 | | NULL STRING | -54.5455 | | NULL STRING | -53.8462 | | NULL STRING | -53.3333 | | NULL STRING | -52.2388 | | NULL STRING | -51.2821 | | NULL STRING | -50 | | NULL STRING | -49.1803 | | NULL STRING | -49.0196 | | NULL STRING | -46.6667 | | NULL STRING | -45.8333 | | NULL STRING | -45.098 | | NULL STRING | -42.5532 | | NULL STRING | -40.625 | | NULL STRING | -38.4615 | +-------------------+--------------+ 40 rows in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> DELETE FROM RawData WHERE rowid <>22364454717488109; Query OK, 44 rows affected (0.00 sec) mysql> call sp_test8('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -52.2388 | +-------------------+--------------+ 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> \. Dump-testcase2-script3.sql Query OK, 44 rows affected (0.00 sec) Records: 44 Duplicates: 0 Warnings: 0 mysql> call sp_test8('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -84.2105 | | NULL STRING | -80 | | NULL STRING | -79.2453 | | NULL STRING | -78.9474 | | NULL STRING | -77.7778 | | NULL STRING | -77.4194 | | NULL STRING | -76.1905 | | NULL STRING | -75.8621 | | NULL STRING | -75 | | NULL STRING | -74 | | NULL STRING | -73.4694 | | NULL STRING | -72.973 | | NULL STRING | -71.831 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -65 | | NULL STRING | -62.5 | | NULL STRING | -61.9048 | | NULL STRING | -61.4583 | | NULL STRING | -61.1111 | | NULL STRING | -60.3774 | | NULL STRING | -60 | | NULL STRING | -59.7701 | | NULL STRING | -59.1837 | | NULL STRING | -58.0645 | | NULL STRING | -56.0606 | | NULL STRING | -54.5455 | | NULL STRING | -53.8462 | | NULL STRING | -53.3333 | | NULL STRING | -52.2388 | | NULL STRING | -51.2821 | | NULL STRING | -50 | | NULL STRING | -49.1803 | | NULL STRING | -49.0196 | | NULL STRING | -46.6667 | | NULL STRING | -45.8333 | | NULL STRING | -45.098 | | NULL STRING | -42.5532 | | NULL STRING | -40.625 | | NULL STRING | -38.4615 | +-------------------+--------------+ 40 rows in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> call sp_test9('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -84.2105 | | NULL STRING | -80 | | NULL STRING | -79.2453 | | NULL STRING | -78.9474 | | NULL STRING | -77.7778 | | NULL STRING | -77.7778 | | NULL STRING | -77.4194 | | NULL STRING | -76.1905 | | NULL STRING | -75.8621 | | NULL STRING | -75 | | NULL STRING | -74 | | NULL STRING | -73.4694 | | NULL STRING | -73.4694 | | NULL STRING | -72.973 | | NULL STRING | -71.831 | | NULL STRING | -68.75 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -65 | | NULL STRING | -62.5 | | NULL STRING | -61.9048 | | NULL STRING | -61.4583 | | NULL STRING | -61.1111 | | NULL STRING | -60.3774 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -59.7701 | | NULL STRING | -59.1837 | | NULL STRING | -58.0645 | | NULL STRING | -56.0606 | | NULL STRING | -54.5455 | | NULL STRING | -53.8462 | | NULL STRING | -53.3333 | | NULL STRING | -52.2388 | | NULL STRING | -51.2821 | | NULL STRING | -50 | | NULL STRING | -49.1803 | | NULL STRING | -49.0196 | | NULL STRING | -46.6667 | | NULL STRING | -45.8333 | | NULL STRING | -45.098 | | NULL STRING | -42.5532 | | NULL STRING | -40.625 | | NULL STRING | -38.4615 | +-------------------+--------------+ 45 rows in set (0.01 sec) Query OK, 0 rows affected (0.01 sec) mysql> DELETE FROM RawData WHERE rowid <>22364454717488109; Query OK, 44 rows affected (0.00 sec) mysql> call sp_test9('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -52.2388 | +-------------------+--------------+ 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> \. Dump-testcase2-script3.sql Query OK, 44 rows affected (0.01 sec) Records: 44 Duplicates: 0 Warnings: 0 mysql> call sp_test9('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -53.8462 | | NULL STRING | -77.7778 | | NULL STRING | -40.625 | | NULL STRING | -56.0606 | | NULL STRING | -75 | | NULL STRING | -68.75 | | NULL STRING | -60 | | NULL STRING | -73.4694 | | NULL STRING | -61.4583 | | NULL STRING | -50 | | NULL STRING | -77.4194 | | NULL STRING | -38.4615 | | NULL STRING | -49.0196 | | NULL STRING | -65 | | NULL STRING | -51.2821 | | NULL STRING | -53.3333 | | NULL STRING | -80 | | NULL STRING | -52.2388 | | NULL STRING | -71.831 | | NULL STRING | -42.5532 | | NULL STRING | -58.0645 | | NULL STRING | -45.098 | | NULL STRING | -62.5 | | NULL STRING | -75.8621 | | NULL STRING | -46.6667 | | NULL STRING | -60.3774 | | NULL STRING | -76.1905 | | NULL STRING | -67.9012 | | NULL STRING | -68.75 | | NULL STRING | -78.9474 | | NULL STRING | -84.2105 | | NULL STRING | -72.973 | | NULL STRING | -61.1111 | | NULL STRING | -59.7701 | | NULL STRING | -73.4694 | | NULL STRING | -77.7778 | | NULL STRING | -74 | | NULL STRING | -61.9048 | | NULL STRING | -54.5455 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -49.1803 | | NULL STRING | -45.8333 | | NULL STRING | -79.2453 | | NULL STRING | -59.1837 | +-------------------+--------------+ 45 rows in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> call sp_reset_sp(); Query OK, 0 rows affected (0.00 sec) mysql> call sp_test9('nps_score'); +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -84.2105 | | NULL STRING | -80 | | NULL STRING | -79.2453 | | NULL STRING | -78.9474 | | NULL STRING | -77.7778 | | NULL STRING | -77.7778 | | NULL STRING | -77.4194 | | NULL STRING | -76.1905 | | NULL STRING | -75.8621 | | NULL STRING | -75 | | NULL STRING | -74 | | NULL STRING | -73.4694 | | NULL STRING | -73.4694 | | NULL STRING | -72.973 | | NULL STRING | -71.831 | | NULL STRING | -68.75 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -65 | | NULL STRING | -62.5 | | NULL STRING | -61.9048 | | NULL STRING | -61.4583 | | NULL STRING | -61.1111 | | NULL STRING | -60.3774 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -59.7701 | | NULL STRING | -59.1837 | | NULL STRING | -58.0645 | | NULL STRING | -56.0606 | | NULL STRING | -54.5455 | | NULL STRING | -53.8462 | | NULL STRING | -53.3333 | | NULL STRING | -52.2388 | | NULL STRING | -51.2821 | | NULL STRING | -50 | | NULL STRING | -49.1803 | | NULL STRING | -49.0196 | | NULL STRING | -46.6667 | | NULL STRING | -45.8333 | | NULL STRING | -45.098 | | NULL STRING | -42.5532 | | NULL STRING | -40.625 | | NULL STRING | -38.4615 | +-------------------+--------------+ 45 rows in set (0.00 sec) Query OK, 0 rows affected (0.01 sec)