diff options
| author | unknown <bar@mysql.com> | 2004-09-16 14:47:39 +0500 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2004-09-16 14:47:39 +0500 |
| commit | e177c9586d10e7c55277051a3e51edfeddbb25f8 (patch) | |
| tree | 11eb7f684a2c3f7ffcfd151072f718831d62f1cd /mysql-test/r/ps_2myisam.result | |
| parent | 5218404b1234bcfc20f4ccf0b7591800c323328b (diff) | |
| download | mariadb-git-e177c9586d10e7c55277051a3e51edfeddbb25f8.tar.gz | |
Return character strings in table, type, possible_keys, key fields
of EXPLAIN SELECT, rather than binary strings.
Diffstat (limited to 'mysql-test/r/ps_2myisam.result')
| -rw-r--r-- | mysql-test/r/ps_2myisam.result | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/mysql-test/r/ps_2myisam.result b/mysql-test/r/ps_2myisam.result index ff0b7d65433..16d3cdbbb47 100644 --- a/mysql-test/r/ps_2myisam.result +++ b/mysql-test/r/ps_2myisam.result @@ -574,15 +574,15 @@ prepare stmt1 from @stmt ; execute stmt1 ; Catalog Database Table Table_alias Column Column_alias Name Type Length Max length Is_null Flags Decimals Charsetnr def id 8 3 1 N 32801 0 8 -def select_type 253 19 18 N 1 31 63 -def table 253 64 16 N 1 31 63 -def type 253 10 3 N 1 31 63 -def possible_keys 253 4096 0 Y 0 31 63 -def key 253 64 0 Y 0 31 63 +def select_type 253 19 18 N 1 31 8 +def table 253 64 16 N 1 31 8 +def type 253 10 3 N 1 31 8 +def possible_keys 253 4096 0 Y 0 31 8 +def key 253 64 0 Y 0 31 8 def key_len 8 3 0 Y 32800 0 8 -def ref 253 1024 0 Y 0 31 63 +def ref 253 1024 0 Y 0 31 8 def rows 8 10 1 N 32801 0 8 -def Extra 253 255 44 N 1 31 63 +def Extra 253 255 44 N 1 31 8 id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 2 1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2 Using where @@ -645,15 +645,15 @@ execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06, @arg07, @arg08, @arg09 ; Catalog Database Table Table_alias Column Column_alias Name Type Length Max length Is_null Flags Decimals Charsetnr def id 8 3 1 N 32801 0 8 -def select_type 253 19 18 N 1 31 63 -def table 253 64 16 N 1 31 63 -def type 253 10 3 N 1 31 63 -def possible_keys 253 4096 0 Y 0 31 63 -def key 253 64 0 Y 0 31 63 +def select_type 253 19 18 N 1 31 8 +def table 253 64 16 N 1 31 8 +def type 253 10 3 N 1 31 8 +def possible_keys 253 4096 0 Y 0 31 8 +def key 253 64 0 Y 0 31 8 def key_len 8 3 0 Y 32800 0 8 -def ref 253 1024 0 Y 0 31 63 +def ref 253 1024 0 Y 0 31 8 def rows 8 10 1 N 32801 0 8 -def Extra 253 255 44 N 1 31 63 +def Extra 253 255 44 N 1 31 8 id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 2 1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2 Using where |