[root@mysqldevtest tests]# 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 5 Server version: 5.6.4-m7 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> \. Dump-testcase1-script1.sql Database changed Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 45 rows affected (0.00 sec) Records: 45 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> \. Dump-testcase1-script2.sql Database changed Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 62 rows affected (0.01 sec) Records: 62 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> \. Dump-testcase1-script9.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> call sp_test7('nps_score'); -- ORDER BY CASE +-------------------+--------------+ | 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> \. Dump-testcase1-script4.sql Database changed Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 1 row affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> call sp_test7('nps_score'); -- ORDER BY CASE +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -61.5429 | +-------------------+--------------+ 1 row in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> \. Dump-testcase1-script1.sql Database changed Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 45 rows affected (0.00 sec) Records: 45 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> call sp_test7('nps_score'); -- ORDER BY CASE +-------------------+--------------+ | sort_asc_string_1 | sort_numeric | +-------------------+--------------+ | NULL STRING | -45.8333 | | NULL STRING | -49.1803 | | NULL STRING | -60 | | NULL STRING | -60 | | NULL STRING | -54.5455 | | NULL STRING | -61.9048 | | NULL STRING | -74 | | NULL STRING | -77.7778 | | NULL STRING | -73.4694 | | NULL STRING | -59.7701 | | NULL STRING | -61.1111 | | NULL STRING | -72.973 | | NULL STRING | -84.2105 | | NULL STRING | -78.9474 | | NULL STRING | -68.75 | | NULL STRING | -67.9012 | | NULL STRING | -76.1905 | | NULL STRING | -60.3774 | | NULL STRING | -46.6667 | | NULL STRING | -75.8621 | | NULL STRING | -62.5 | | NULL STRING | -45.098 | | NULL STRING | -58.0645 | | NULL STRING | -42.5532 | | NULL STRING | -71.831 | | NULL STRING | -80 | | NULL STRING | -53.3333 | | NULL STRING | -51.2821 | | NULL STRING | -65 | | NULL STRING | -49.0196 | | NULL STRING | -38.4615 | | NULL STRING | -52.2388 | | NULL STRING | -77.4194 | | NULL STRING | -50 | | NULL STRING | -61.4583 | | NULL STRING | -73.4694 | | NULL STRING | -60 | | NULL STRING | -68.75 | | NULL STRING | -75 | | NULL STRING | -56.0606 | | NULL STRING | -40.625 | | NULL STRING | -77.7778 | | NULL STRING | -53.8462 | | NULL STRING | -59.1837 | | NULL STRING | -79.2453 | +-------------------+--------------+ 45 rows in set (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> \. Dump-testcase1-script9.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) mysql> call sp_test7('nps_score'); -- ORDER BY CASE +-------------------+--------------+ | 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>