## 5.7.18 root@localhost [(none)]> select bin(244207),bin(4294967296), "test"; +--------------------+-----------------------------------+------+ | bin(244207) | bin(4294967296) | test | +--------------------+-----------------------------------+------+ | 111011100111101111 | 100000000000000000000000000000000 | test | +--------------------+-----------------------------------+------+ 1 row in set (0.00 sec) root@localhost [(none)]> select * from ( -> select bin(244207),bin(4294967296), "test") a, -> ( -> select bin(244207),bin(4294967296), "test") b -> order by a.test -> ; +--------------------+-----------------------+------+--------------------+-----------------------+------+ | bin(244207) | bin(4294967296) | test | bin(244207) | bin(4294967296) | test | +--------------------+-----------------------+------+--------------------+-----------------------+------+ | 111011100111101111 | 100000000000000000000 | test | 111011100111101111 | 100000000000000000000 | test | +--------------------+-----------------------+------+--------------------+-----------------------+------+ 1 row in set (0.01 sec) ## 5.6.36 root@localhost [(none)]> select bin(244207),bin(4294967296), "test"; +--------------------+-----------------------------------+------+ | bin(244207) | bin(4294967296) | test | +--------------------+-----------------------------------+------+ | 111011100111101111 | 100000000000000000000000000000000 | test | +--------------------+-----------------------------------+------+ 1 row in set (0.00 sec) root@localhost [(none)]> select * from ( -> select bin(244207),bin(4294967296), "test") a, -> ( -> select bin(244207),bin(4294967296), "test") b -> order by a.test; +--------------------+-----------------------+------+--------------------+-----------------------+------+ | bin(244207) | bin(4294967296) | test | bin(244207) | bin(4294967296) | test | +--------------------+-----------------------+------+--------------------+-----------------------+------+ | 111011100111101111 | 100000000000000000000 | test | 111011100111101111 | 100000000000000000000 | test | +--------------------+-----------------------+------+--------------------+-----------------------+------+ 1 row in set (0.00 sec) ## 5.5.56 root@localhost [(none)]> select bin(244207),bin(4294967296), "test"; +--------------------+-----------------------------------+------+ | bin(244207) | bin(4294967296) | test | +--------------------+-----------------------------------+------+ | 111011100111101111 | 100000000000000000000000000000000 | test | +--------------------+-----------------------------------+------+ 1 row in set (0.00 sec) root@localhost [(none)]> select * from ( -> select bin(244207),bin(4294967296), "test") a, -> ( -> select bin(244207),bin(4294967296), "test") b -> order by a.test -> ; +--------------------+-----------------------+------+--------------------+-----------------------+------+ | bin(244207) | bin(4294967296) | test | bin(244207) | bin(4294967296) | test | +--------------------+-----------------------+------+--------------------+-----------------------+------+ | 111011100111101111 | 100000000000000000000 | test | 111011100111101111 | 100000000000000000000 | test | +--------------------+-----------------------+------+--------------------+-----------------------+------+ 1 row in set (0.00 sec) ### [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36: bin/mysql -uroot -S /tmp/mysql_ushastry.sock --column-type Warning: Using unique option prefix column-type instead of column-type-info is deprecated and will be removed in a future release. Please use the full name instead. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.36 MySQL Community Server (GPL) Copyright (c) 2000, 2017, 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. root@localhost [(none)]> select bin(244207),bin(4294967296), "test"; Field 1: `bin(244207)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 63 Max_length: 18 Decimals: 31 Flags: Field 2: `bin(4294967296)` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 63 Max_length: 33 Decimals: 31 Flags: Field 3: `test` Catalog: `def` Database: `` Table: `` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 12 Max_length: 4 Decimals: 31 Flags: NOT_NULL +--------------------+-----------------------------------+------+ | bin(244207) | bin(4294967296) | test | +--------------------+-----------------------------------+------+ | 111011100111101111 | 100000000000000000000000000000000 | test | +--------------------+-----------------------------------+------+ 1 row in set (0.00 sec) root@localhost [(none)]> select * from ( -> select bin(244207),bin(4294967296), "test") a, -> ( -> select bin(244207),bin(4294967296), "test") b -> order by a.test; Field 1: `bin(244207)` Catalog: `def` Database: `` Table: `a` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 63 Max_length: 18 Decimals: 0 Flags: Field 2: `bin(4294967296)` Catalog: `def` Database: `` Table: `a` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 63 Max_length: 21 Decimals: 0 Flags: Field 3: `test` Catalog: `def` Database: `` Table: `a` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 12 Max_length: 4 Decimals: 0 Flags: NOT_NULL Field 4: `bin(244207)` Catalog: `def` Database: `` Table: `b` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 63 Max_length: 18 Decimals: 0 Flags: Field 5: `bin(4294967296)` Catalog: `def` Database: `` Table: `b` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 63 Max_length: 21 Decimals: 0 Flags: Field 6: `test` Catalog: `def` Database: `` Table: `b` Org_table: `` Type: VAR_STRING Collation: utf8_general_ci (33) Length: 12 Max_length: 4 Decimals: 0 Flags: NOT_NULL +--------------------+-----------------------+------+--------------------+-----------------------+------+ | bin(244207) | bin(4294967296) | test | bin(244207) | bin(4294967296) | test | +--------------------+-----------------------+------+--------------------+-----------------------+------+ | 111011100111101111 | 100000000000000000000 | test | 111011100111101111 | 100000000000000000000 | test | +--------------------+-----------------------+------+--------------------+-----------------------+------+ 1 row in set (0.00 sec)