diff options
Diffstat (limited to 'mysql-test/r/order_by.result')
| -rw-r--r-- | mysql-test/r/order_by.result | 110 |
1 files changed, 110 insertions, 0 deletions
diff --git a/mysql-test/r/order_by.result b/mysql-test/r/order_by.result new file mode 100644 index 00000000000..f550e471c4b --- /dev/null +++ b/mysql-test/r/order_by.result @@ -0,0 +1,110 @@ +id idservice ordre description +2 1 10 Emettre un appel d'offres +2 3 40000 Créer une fiche de client +2 4 40010 Modifier des clients +2 5 40020 Effacer des clients +2 6 51050 Ajouter un service +2 7 51060 Liste des t2 +name +Allan Larsson +David Axmark +Michael Widenius +name +Axmark David +Larsson Allan +Widenius Michael +i +1 +2 +3 +i +1 +3 +2 +i +3 +2 +1 +i +3 +2 +1 +i +2 +1 +3 +id col1 col2 +4 1 1 +3 1 2 +5 1 4 +2 2 1 +1 2 2 +6 2 3 +8 2 4 +7 3 1 +col1 +2 +2 +1 +1 +1 +2 +3 +2 +id +1 +1 +1 +2 +2 +2 +2 +3 +id +2 +2 +1 +1 +1 +2 +3 +2 +test +1 +2 +3 +7 +a b if(b = 1,i,if(b = 2,v,'')) +1 1 50 +2 1 25 +3 2 123 Park Place +4 2 453 Boardwalk +a b if(b = 1,i,if(b = 2,v,'')) +1 1 50 +2 1 25 +3 2 123 Park Place +4 2 453 Boardwalk +DateOfAction TransactionID +1999-07-18 486 +1999-07-19 87 +1999-07-19 89 +1999-07-19 92 +1999-07-19 94 +1999-07-27 828 +1999-07-27 832 +1999-07-27 834 +1999-07-27 840 +2000-03-27 490 +2000-03-28 753 +DateOfAction TransactionID +1999-07-19 87 +1999-07-19 89 +1999-07-19 92 +1999-07-19 94 +1999-07-18 486 +2000-03-27 490 +2000-03-28 753 +1999-07-27 828 +1999-07-27 832 +1999-07-27 834 +1999-07-27 840 |