diff options
Diffstat (limited to 'mysql-test/r/metadata.result')
| -rw-r--r-- | mysql-test/r/metadata.result | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/mysql-test/r/metadata.result b/mysql-test/r/metadata.result index 3418348854f..fcaeb3359f0 100644 --- a/mysql-test/r/metadata.result +++ b/mysql-test/r/metadata.result @@ -21,7 +21,7 @@ def test t1 t1 g g 5 4 0 Y 32768 3 63 def test t1 t1 h h 246 7 0 Y 32768 4 63 def test t1 t1 i i 13 4 0 Y 32864 0 63 def test t1 t1 j j 10 10 0 Y 128 0 63 -def test t1 t1 k k 7 19 0 N 9441 0 63 +def test t1 t1 k k 7 19 0 N 9377 0 63 def test t1 t1 l l 12 19 0 Y 128 0 63 def test t1 t1 m m 254 1 0 Y 256 0 8 def test t1 t1 n n 254 3 0 Y 2048 0 8 @@ -205,7 +205,7 @@ CREATE TABLE t1 (f1 INT); CREATE VIEW v1 AS SELECT f1 FROM t1; SELECT f1 FROM v1 va; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr -def test v1 va f1 f1 3 11 0 Y 32768 0 63 +def test va va f1 f1 3 11 0 Y 32768 0 63 f1 DROP VIEW v1; DROP TABLE t1; @@ -283,8 +283,8 @@ def test t1 t1 dcol dcol 5 22 0 Y 32768 31 63 def test t1 t1 double_precision_col double_precision_col 5 22 0 Y 32768 31 63 def test t1 t1 dcol_uns dcol_uns 5 22 0 Y 32800 31 63 def test t1 t1 date_col date_col 10 10 0 Y 128 0 63 -def test t1 t1 time_col time_col 11 8 0 Y 128 0 63 -def test t1 t1 timestamp_col timestamp_col 7 19 0 N 9441 0 63 +def test t1 t1 time_col time_col 11 10 0 Y 128 0 63 +def test t1 t1 timestamp_col timestamp_col 7 19 0 N 9377 0 63 def test t1 t1 year_col year_col 13 4 0 Y 32864 0 63 def test t1 t1 datetime_col datetime_col 12 19 0 Y 128 0 63 def test t1 t1 char_col char_col 254 5 0 Y 0 0 8 @@ -302,3 +302,9 @@ def test t1 t1 enum_col enum_col 254 1 0 Y 256 0 8 def test t1 t1 set_col set_col 254 5 0 Y 2048 0 8 bool_col boolean_col bit_col tiny tiny_uns small small_uns medium medium_uns int_col int_col_uns big big_uns decimal_col numeric_col fixed_col dec_col decimal_col_uns fcol fcol_uns dcol double_precision_col dcol_uns date_col time_col timestamp_col year_col datetime_col char_col varchar_col binary_col varbinary_col tinyblob_col blob_col mediumblob_col longblob_col text_col mediumtext_col longtext_col enum_col set_col drop table t1; +select cast('01:01:01' as time), cast('01:01:01' as time(2)); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def cast('01:01:01' as time) 11 10 8 Y 128 0 63 +def cast('01:01:01' as time(2)) 11 13 11 Y 128 2 63 +cast('01:01:01' as time) cast('01:01:01' as time(2)) +01:01:01 01:01:01.00 |