diff options
| author | monty@donna.mysql.com <> | 2000-12-28 03:56:38 +0200 |
|---|---|---|
| committer | monty@donna.mysql.com <> | 2000-12-28 03:56:38 +0200 |
| commit | c0f40d14cc36f56f5b4dba288583acd345429e4e (patch) | |
| tree | c27e400395741740f2e230395445236b38db27c1 /mysql-test/r/distinct.result | |
| parent | 361067e9150f7fa57d5b2ac722ed55df9c14cc53 (diff) | |
| download | mariadb-git-c0f40d14cc36f56f5b4dba288583acd345429e4e.tar.gz | |
Added support for hex strings to mysqlimport
A lot of new tests to mysqltest
Fixed bug with BDB tables and autocommit
Diffstat (limited to 'mysql-test/r/distinct.result')
| -rw-r--r-- | mysql-test/r/distinct.result | 155 |
1 files changed, 155 insertions, 0 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result new file mode 100644 index 00000000000..79c55e45342 --- /dev/null +++ b/mysql-test/r/distinct.result @@ -0,0 +1,155 @@ +id +NULL +-1 +0 +1 +2 +3 +4 +5 +6 +7 +8 +9 +10 +id facility +NULL NULL +-1 +0 +1 /L +2 A01 +3 ANC +4 F01 +5 FBX +6 MT +7 P +8 RV +9 SRV +10 VMT +id-5 facility +NULL NULL +-6 +-5 +-4 /L +-3 A01 +-2 ANC +-1 F01 +0 FBX +1 MT +2 P +3 RV +4 SRV +5 VMT +id concat(facility) +NULL NULL +-1 +0 +1 /L +2 A01 +3 ANC +4 F01 +5 FBX +6 MT +7 P +8 RV +9 SRV +10 VMT +a max(id) b +10 10 VMT +9 9 SRV +8 8 RV +7 7 P +6 6 MT +5 5 FBX +4 4 F01 +3 3 ANC +2 2 A01 +1 1 /L +-1 -1 +0 0 +NULL NULL NULL +grp count(*) +0 7 +1 6 +FACILITY +NULL + +/L +A01 +ANC +F01 +FBX +MT +P +RV +SRV +VMT +FACILITY +NULL + +/L +A01 +ANC +F01 +FBX +MT +P +RV +SRV +VMT +count(*) +12 +count(facility) +12 +count(*) +13 +count(*) +1 +count(*) +0 +count(*) +12 +count(*) +1 +count(*) +12 +UserId +UserId +UserId +UserId +b +1 +table type possible_keys key key_len ref rows Extra +t3 index a a 4 NULL 6 Using index; Using temporary +t2 index a a 4 NULL 5 Using index; Distinct +t1 eq_ref PRIMARY PRIMARY 4 t2.a 1 where used; Distinct +a +1 +table type possible_keys key key_len ref rows Extra +t1 index PRIMARY PRIMARY 4 NULL 2 Using index; Using temporary +t3 ref a a 5 t1.a 12 Using index; Distinct +a +1 +2 +1 +1 +name +aa +ab +name +aa +ab +1 +1 +key_link_id link +NULL NULL +table type possible_keys key key_len ref rows Extra +t1 index id id 4 NULL 2 Using index; Using temporary +t2 index id id 8 NULL 1 Using index; Distinct +t3 index id id 8 NULL 1 Using index; Distinct +j_lj_t2 index id id 4 NULL 2 where used; Using index; Distinct +t2_lj index id id 8 NULL 1 where used; Using index; Distinct +j_lj_t3 index id id 4 NULL 2 where used; Using index; Distinct +t3_lj index id id 8 NULL 1 where used; Using index; Distinct +id +2 |