diff options
Diffstat (limited to 'mysql-test/r/metadata.result')
| -rw-r--r-- | mysql-test/r/metadata.result | 504 |
1 files changed, 499 insertions, 5 deletions
diff --git a/mysql-test/r/metadata.result b/mysql-test/r/metadata.result index 3db3bcd450f..7848390b62e 100644 --- a/mysql-test/r/metadata.result +++ b/mysql-test/r/metadata.result @@ -1,13 +1,105 @@ drop table if exists t1,t2; select 1, 1.0, -1, "hello", NULL; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr -def 1 8 1 1 N 32897 0 63 +def 1 3 1 1 N 32897 0 63 def 1.0 246 4 3 N 32897 1 63 -def -1 8 2 2 N 32897 0 63 +def -1 3 2 2 N 32897 0 63 def hello 253 5 5 N 1 39 8 def NULL 6 0 0 Y 32896 0 63 1 1.0 -1 hello NULL 1 1.0 -1 hello NULL +SELECT +1 AS c1, +11 AS c2, +111 AS c3, +1111 AS c4, +11111 AS c5, +111111 AS c6, +1111111 AS c7, +11111111 AS c8, +111111111 AS c9, +1111111111 AS c10, +11111111111 AS c11, +111111111111 AS c12, +1111111111111 AS c13, +11111111111111 AS c14, +111111111111111 AS c15, +1111111111111111 AS c16, +11111111111111111 AS c17, +111111111111111111 AS c18, +1111111111111111111 AS c19, +11111111111111111111 AS c20, +111111111111111111111 AS c21; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def c1 3 1 1 N 32897 0 63 +def c2 3 2 2 N 32897 0 63 +def c3 3 3 3 N 32897 0 63 +def c4 3 4 4 N 32897 0 63 +def c5 3 5 5 N 32897 0 63 +def c6 3 6 6 N 32897 0 63 +def c7 3 7 7 N 32897 0 63 +def c8 3 8 8 N 32897 0 63 +def c9 3 9 9 N 32897 0 63 +def c10 8 10 10 N 32897 0 63 +def c11 8 11 11 N 32897 0 63 +def c12 8 12 12 N 32897 0 63 +def c13 8 13 13 N 32897 0 63 +def c14 8 14 14 N 32897 0 63 +def c15 8 15 15 N 32897 0 63 +def c16 8 16 16 N 32897 0 63 +def c17 8 17 17 N 32897 0 63 +def c18 8 18 18 N 32897 0 63 +def c19 8 19 19 N 32897 0 63 +def c20 8 20 20 N 32929 0 63 +def c21 246 22 21 N 32897 0 63 +c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 +1 11 111 1111 11111 111111 1111111 11111111 111111111 1111111111 11111111111 111111111111 1111111111111 11111111111111 111111111111111 1111111111111111 11111111111111111 111111111111111111 1111111111111111111 11111111111111111111 111111111111111111111 +SELECT +-1 AS c1, +-11 AS c2, +-111 AS c3, +-1111 AS c4, +-11111 AS c5, +-111111 AS c6, +-1111111 AS c7, +-11111111 AS c8, +-111111111 AS c9, +-1111111111 AS c10, +-11111111111 AS c11, +-111111111111 AS c12, +-1111111111111 AS c13, +-11111111111111 AS c14, +-111111111111111 AS c15, +-1111111111111111 AS c16, +-11111111111111111 AS c17, +-111111111111111111 AS c18, +-1111111111111111111 AS c19, +-11111111111111111111 AS c20, +-111111111111111111111 AS c21; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def c1 3 2 2 N 32897 0 63 +def c2 3 3 3 N 32897 0 63 +def c3 3 4 4 N 32897 0 63 +def c4 3 5 5 N 32897 0 63 +def c5 3 6 6 N 32897 0 63 +def c6 3 7 7 N 32897 0 63 +def c7 3 8 8 N 32897 0 63 +def c8 3 9 9 N 32897 0 63 +def c9 8 10 10 N 32897 0 63 +def c10 8 11 11 N 32897 0 63 +def c11 8 12 12 N 32897 0 63 +def c12 8 13 13 N 32897 0 63 +def c13 8 14 14 N 32897 0 63 +def c14 8 15 15 N 32897 0 63 +def c15 8 16 16 N 32897 0 63 +def c16 8 17 17 N 32897 0 63 +def c17 8 18 18 N 32897 0 63 +def c18 8 19 19 N 32897 0 63 +def c19 8 20 20 N 32897 0 63 +def c20 246 21 21 N 32897 0 63 +def c21 246 22 22 N 32897 0 63 +c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 +-1 -11 -111 -1111 -11111 -111111 -1111111 -11111111 -111111111 -1111111111 -11111111111 -111111111111 -1111111111111 -11111111111111 -111111111111111 -1111111111111111 -11111111111111111 -111111111111111111 -1111111111111111111 -11111111111111111111 -111111111111111111111 create table t1 (a tinyint, b smallint, c mediumint, d int, e bigint, f float(3,2), g double(4,3), h decimal(5,4), i year, j date, k timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, l datetime, m enum('a','b'), n set('a','b'), o char(10)); select * from t1; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr @@ -55,7 +147,7 @@ id data data 2 female no select t1.id from t1 union select t2.id from t2; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr -def id id 1 4 1 Y 32768 0 63 +def id id 246 4 1 Y 32768 0 63 id 1 2 @@ -76,12 +168,12 @@ def aaa @arg00 @arg00 8 20 1 Y 32768 0 63 1 select 1 union select 1; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr -def 1 1 8 20 1 N 32769 0 63 +def 1 1 3 1 1 N 32769 0 63 1 1 select * from (select 1 union select 1) aaa; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr -def aaa 1 1 8 20 1 N 32769 0 63 +def aaa 1 1 3 1 1 N 32769 0 63 1 1 drop table t1; @@ -308,3 +400,405 @@ 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 +# +# MDEV-12854 Synchronize CREATE..SELECT data type and result set metadata data type for INT functions +# +SELECT +STRCMP('a','b'), +OCTET_LENGTH('a'), +CHAR_LENGTH('a'), +COERCIBILITY('a'), +ASCII('a'), +ORD('a'), +CRC32('a'), +UNCOMPRESSED_LENGTH(COMPRESS('a')); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def STRCMP('a','b') 3 2 2 N 32897 0 63 +def OCTET_LENGTH('a') 3 10 1 N 32897 0 63 +def CHAR_LENGTH('a') 3 10 1 N 32897 0 63 +def COERCIBILITY('a') 3 10 1 N 32897 0 63 +def ASCII('a') 3 3 2 N 32897 0 63 +def ORD('a') 3 7 2 N 32897 0 63 +def CRC32('a') 3 10 10 N 32929 0 63 +def UNCOMPRESSED_LENGTH(COMPRESS('a')) 3 10 1 Y 32896 0 63 +STRCMP('a','b') OCTET_LENGTH('a') CHAR_LENGTH('a') COERCIBILITY('a') ASCII('a') ORD('a') CRC32('a') UNCOMPRESSED_LENGTH(COMPRESS('a')) +-1 1 1 4 97 97 3904355907 1 +SELECT +INTERVAL(2,1,2,3), +REGEXP_INSTR('a','a'), +LOCATE('a','a'), +FIND_IN_SET('b','a,b,c,d'), +FIELD('a','a','b'); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def INTERVAL(2,1,2,3) 3 2 1 N 32897 0 63 +def REGEXP_INSTR('a','a') 3 11 1 N 32897 0 63 +def LOCATE('a','a') 3 11 1 N 32897 0 63 +def FIND_IN_SET('b','a,b,c,d') 3 3 1 N 32897 0 63 +def FIELD('a','a','b') 3 3 1 N 32897 0 63 +INTERVAL(2,1,2,3) REGEXP_INSTR('a','a') LOCATE('a','a') FIND_IN_SET('b','a,b,c,d') FIELD('a','a','b') +2 1 1 2 1 +SELECT +SIGN(1), +BIT_COUNT(1); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def SIGN(1) 3 2 1 N 32897 0 63 +def BIT_COUNT(1) 3 2 1 N 32897 0 63 +SIGN(1) BIT_COUNT(1) +1 1 +SELECT +BENCHMARK(0,0), +SLEEP(0); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def BENCHMARK(0,0) 3 1 1 N 32897 0 63 +def SLEEP(0) 3 1 1 N 32897 0 63 +BENCHMARK(0,0) SLEEP(0) +0 0 +SELECT +GET_LOCK('metadata',0), +IS_FREE_LOCK('metadata'), +RELEASE_LOCK('metadata'); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def GET_LOCK('metadata',0) 3 1 1 Y 32896 0 63 +def IS_FREE_LOCK('metadata') 3 1 1 Y 32896 0 63 +def RELEASE_LOCK('metadata') 3 1 1 Y 32896 0 63 +GET_LOCK('metadata',0) IS_FREE_LOCK('metadata') RELEASE_LOCK('metadata') +1 0 1 +SELECT +PERIOD_ADD(200801,2), +PERIOD_DIFF(200802,200703), +TO_DAYS('2007-10-07'), +DAYOFMONTH('2007-02-03'), +DAYOFWEEK('2007-02-03'), +TO_SECONDS('2013-06-13'); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def PERIOD_ADD(200801,2) 3 6 6 N 32897 0 63 +def PERIOD_DIFF(200802,200703) 3 6 2 N 32897 0 63 +def TO_DAYS('2007-10-07') 3 6 6 Y 32896 0 63 +def DAYOFMONTH('2007-02-03') 3 2 1 Y 32896 0 63 +def DAYOFWEEK('2007-02-03') 3 1 1 Y 32896 0 63 +def TO_SECONDS('2013-06-13') 8 12 11 Y 32896 0 63 +PERIOD_ADD(200801,2) PERIOD_DIFF(200802,200703) TO_DAYS('2007-10-07') DAYOFMONTH('2007-02-03') DAYOFWEEK('2007-02-03') TO_SECONDS('2013-06-13') +200803 11 733321 3 7 63538300800 +SELECT +YEAR('2001-02-03 04:05:06.000007'), +DAY('2001-02-03 04:05:06.000007'), +HOUR('2001-02-03 04:05:06.000007'), +MINUTE('2001-02-03 04:05:06.000007'), +SECOND('2001-02-03 04:05:06.000007'), +MICROSECOND('2001-02-03 04:05:06.000007'); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def YEAR('2001-02-03 04:05:06.000007') 3 4 4 Y 32896 0 63 +def DAY('2001-02-03 04:05:06.000007') 3 2 1 Y 32896 0 63 +def HOUR('2001-02-03 04:05:06.000007') 3 2 1 Y 32896 0 63 +def MINUTE('2001-02-03 04:05:06.000007') 3 2 1 Y 32896 0 63 +def SECOND('2001-02-03 04:05:06.000007') 3 2 1 Y 32896 0 63 +def MICROSECOND('2001-02-03 04:05:06.000007') 3 6 1 Y 32896 0 63 +YEAR('2001-02-03 04:05:06.000007') DAY('2001-02-03 04:05:06.000007') HOUR('2001-02-03 04:05:06.000007') MINUTE('2001-02-03 04:05:06.000007') SECOND('2001-02-03 04:05:06.000007') MICROSECOND('2001-02-03 04:05:06.000007') +2001 3 4 5 6 7 +SELECT +WEEK('2001-02-03 04:05:06.000007'), +QUARTER('2001-02-03 04:05:06.000007'), +YEARWEEK('2001-02-03 04:05:06.000007'); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def WEEK('2001-02-03 04:05:06.000007') 3 2 1 Y 32896 0 63 +def QUARTER('2001-02-03 04:05:06.000007') 3 1 1 Y 32896 0 63 +def YEARWEEK('2001-02-03 04:05:06.000007') 3 6 6 Y 32896 0 63 +WEEK('2001-02-03 04:05:06.000007') QUARTER('2001-02-03 04:05:06.000007') YEARWEEK('2001-02-03 04:05:06.000007') +4 1 200104 +SELECT BIT_LENGTH(10); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def BIT_LENGTH(10) 8 11 2 N 32897 0 63 +BIT_LENGTH(10) +16 +SELECT 1|2, 1&2, 1<<2, 1>>2, ~0, 1^2; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def 1|2 8 21 1 N 32929 0 63 +def 1&2 8 21 1 N 32929 0 63 +def 1<<2 8 21 1 N 32929 0 63 +def 1>>2 8 21 1 N 32929 0 63 +def ~0 8 21 20 N 32929 0 63 +def 1^2 8 21 1 N 32929 0 63 +1|2 1&2 1<<2 1>>2 ~0 1^2 +3 0 4 0 18446744073709551615 3 +SELECT LAST_INSERT_ID(); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def LAST_INSERT_ID() 8 21 1 N 32929 0 63 +LAST_INSERT_ID() +0 +SELECT ROW_COUNT(), FOUND_ROWS(); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def ROW_COUNT() 8 21 2 N 32897 0 63 +def FOUND_ROWS() 8 21 1 N 32897 0 63 +ROW_COUNT() FOUND_ROWS() +-1 1 +SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01'); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01') 8 21 1 Y 32896 0 63 +TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01') +3 +# +# MDEV-12856 Wrong result set metadata for DIV +# +SELECT +2 DIV 1 AS d0l, +222222222 DIV 1 AS d09, +2222222222 DIV 1 AS d10; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def d0l 3 1 1 Y 32896 0 63 +def d09 3 9 9 Y 32896 0 63 +def d10 8 10 10 Y 32896 0 63 +d0l d09 d10 +2 222222222 2222222222 +# +# MDEV-12862 Data type of @a:=1e0 depends on the session character set +# +SET NAMES utf8; +CREATE TABLE t1 AS SELECT @:=1e0; +SELECT * FROM t1; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def test t1 t1 @:=1e0 @:=1e0 5 3 1 N 36865 31 63 +@:=1e0 +1 +DROP TABLE t1; +SET NAMES latin1; +CREATE TABLE t1 AS SELECT @:=1e0; +SELECT * FROM t1; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def test t1 t1 @:=1e0 @:=1e0 5 3 1 N 36865 31 63 +@:=1e0 +1 +DROP TABLE t1; +# +# MDEV-12869 Wrong metadata for integer additive and multiplicative operators +# +SELECT +1+1, +11+1, +111+1, +1111+1, +11111+1, +111111+1, +1111111+1, +11111111+1, +111111111+1 LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def 1+1 3 3 0 N 32897 0 63 +def 11+1 3 4 0 N 32897 0 63 +def 111+1 3 5 0 N 32897 0 63 +def 1111+1 3 6 0 N 32897 0 63 +def 11111+1 3 7 0 N 32897 0 63 +def 111111+1 3 8 0 N 32897 0 63 +def 1111111+1 3 9 0 N 32897 0 63 +def 11111111+1 8 10 0 N 32897 0 63 +def 111111111+1 8 11 0 N 32897 0 63 +1+1 11+1 111+1 1111+1 11111+1 111111+1 1111111+1 11111111+1 111111111+1 +SELECT +1-1, +11-1, +111-1, +1111-1, +11111-1, +111111-1, +1111111-1, +11111111-1, +111111111-1 LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def 1-1 3 3 0 N 32897 0 63 +def 11-1 3 4 0 N 32897 0 63 +def 111-1 3 5 0 N 32897 0 63 +def 1111-1 3 6 0 N 32897 0 63 +def 11111-1 3 7 0 N 32897 0 63 +def 111111-1 3 8 0 N 32897 0 63 +def 1111111-1 3 9 0 N 32897 0 63 +def 11111111-1 8 10 0 N 32897 0 63 +def 111111111-1 8 11 0 N 32897 0 63 +1-1 11-1 111-1 1111-1 11111-1 111111-1 1111111-1 11111111-1 111111111-1 +SELECT +1*1, +11*1, +111*1, +1111*1, +11111*1, +111111*1, +1111111*1, +11111111*1, +111111111*1 LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def 1*1 3 3 0 N 32897 0 63 +def 11*1 3 4 0 N 32897 0 63 +def 111*1 3 5 0 N 32897 0 63 +def 1111*1 3 6 0 N 32897 0 63 +def 11111*1 3 7 0 N 32897 0 63 +def 111111*1 3 8 0 N 32897 0 63 +def 1111111*1 3 9 0 N 32897 0 63 +def 11111111*1 8 10 0 N 32897 0 63 +def 111111111*1 8 11 0 N 32897 0 63 +1*1 11*1 111*1 1111*1 11111*1 111111*1 1111111*1 11111111*1 111111111*1 +SELECT +1 MOD 1, +11 MOD 1, +111 MOD 1, +1111 MOD 1, +11111 MOD 1, +111111 MOD 1, +1111111 MOD 1, +11111111 MOD 1, +111111111 MOD 1, +1111111111 MOD 1, +11111111111 MOD 1 LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def 1 MOD 1 3 1 0 Y 32896 0 63 +def 11 MOD 1 3 2 0 Y 32896 0 63 +def 111 MOD 1 3 3 0 Y 32896 0 63 +def 1111 MOD 1 3 4 0 Y 32896 0 63 +def 11111 MOD 1 3 5 0 Y 32896 0 63 +def 111111 MOD 1 3 6 0 Y 32896 0 63 +def 1111111 MOD 1 3 7 0 Y 32896 0 63 +def 11111111 MOD 1 3 8 0 Y 32896 0 63 +def 111111111 MOD 1 3 9 0 Y 32896 0 63 +def 1111111111 MOD 1 8 10 0 Y 32896 0 63 +def 11111111111 MOD 1 8 11 0 Y 32896 0 63 +1 MOD 1 11 MOD 1 111 MOD 1 1111 MOD 1 11111 MOD 1 111111 MOD 1 1111111 MOD 1 11111111 MOD 1 111111111 MOD 1 1111111111 MOD 1 11111111111 MOD 1 +SELECT +-(1), +-(11), +-(111), +-(1111), +-(11111), +-(111111), +-(1111111), +-(11111111), +-(111111111) LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def -(1) 3 2 0 N 32897 0 63 +def -(11) 3 3 0 N 32897 0 63 +def -(111) 3 4 0 N 32897 0 63 +def -(1111) 3 5 0 N 32897 0 63 +def -(11111) 3 6 0 N 32897 0 63 +def -(111111) 3 7 0 N 32897 0 63 +def -(1111111) 3 8 0 N 32897 0 63 +def -(11111111) 3 9 0 N 32897 0 63 +def -(111111111) 8 10 0 N 32897 0 63 +-(1) -(11) -(111) -(1111) -(11111) -(111111) -(1111111) -(11111111) -(111111111) +SELECT +ABS(1), +ABS(11), +ABS(111), +ABS(1111), +ABS(11111), +ABS(111111), +ABS(1111111), +ABS(11111111), +ABS(111111111), +ABS(1111111111) LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def ABS(1) 3 1 0 N 32897 0 63 +def ABS(11) 3 2 0 N 32897 0 63 +def ABS(111) 3 3 0 N 32897 0 63 +def ABS(1111) 3 4 0 N 32897 0 63 +def ABS(11111) 3 5 0 N 32897 0 63 +def ABS(111111) 3 6 0 N 32897 0 63 +def ABS(1111111) 3 7 0 N 32897 0 63 +def ABS(11111111) 3 8 0 N 32897 0 63 +def ABS(111111111) 3 9 0 N 32897 0 63 +def ABS(1111111111) 8 10 0 N 32897 0 63 +ABS(1) ABS(11) ABS(111) ABS(1111) ABS(11111) ABS(111111) ABS(1111111) ABS(11111111) ABS(111111111) ABS(1111111111) +SELECT +CEILING(1), +CEILING(11), +CEILING(111), +CEILING(1111), +CEILING(11111), +CEILING(111111), +CEILING(1111111), +CEILING(11111111), +CEILING(111111111), +CEILING(1111111111) LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def CEILING(1) 3 3 0 N 32897 0 63 +def CEILING(11) 3 4 0 N 32897 0 63 +def CEILING(111) 3 5 0 N 32897 0 63 +def CEILING(1111) 3 6 0 N 32897 0 63 +def CEILING(11111) 3 7 0 N 32897 0 63 +def CEILING(111111) 3 8 0 N 32897 0 63 +def CEILING(1111111) 3 9 0 N 32897 0 63 +def CEILING(11111111) 8 10 0 N 32897 0 63 +def CEILING(111111111) 8 11 0 N 32897 0 63 +def CEILING(1111111111) 8 12 0 N 32897 0 63 +CEILING(1) CEILING(11) CEILING(111) CEILING(1111) CEILING(11111) CEILING(111111) CEILING(1111111) CEILING(11111111) CEILING(111111111) CEILING(1111111111) +SELECT +FLOOR(1), +FLOOR(11), +FLOOR(111), +FLOOR(1111), +FLOOR(11111), +FLOOR(111111), +FLOOR(1111111), +FLOOR(11111111), +FLOOR(111111111), +FLOOR(1111111111) LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def FLOOR(1) 3 3 0 N 32897 0 63 +def FLOOR(11) 3 4 0 N 32897 0 63 +def FLOOR(111) 3 5 0 N 32897 0 63 +def FLOOR(1111) 3 6 0 N 32897 0 63 +def FLOOR(11111) 3 7 0 N 32897 0 63 +def FLOOR(111111) 3 8 0 N 32897 0 63 +def FLOOR(1111111) 3 9 0 N 32897 0 63 +def FLOOR(11111111) 8 10 0 N 32897 0 63 +def FLOOR(111111111) 8 11 0 N 32897 0 63 +def FLOOR(1111111111) 8 12 0 N 32897 0 63 +FLOOR(1) FLOOR(11) FLOOR(111) FLOOR(1111) FLOOR(11111) FLOOR(111111) FLOOR(1111111) FLOOR(11111111) FLOOR(111111111) FLOOR(1111111111) +SELECT +ROUND(1), +ROUND(11), +ROUND(111), +ROUND(1111), +ROUND(11111), +ROUND(111111), +ROUND(1111111), +ROUND(11111111), +ROUND(111111111), +ROUND(1111111111) LIMIT 0; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def ROUND(1) 3 1 0 N 32897 0 63 +def ROUND(11) 3 2 0 N 32897 0 63 +def ROUND(111) 3 3 0 N 32897 0 63 +def ROUND(1111) 3 4 0 N 32897 0 63 +def ROUND(11111) 3 5 0 N 32897 0 63 +def ROUND(111111) 3 6 0 N 32897 0 63 +def ROUND(1111111) 3 7 0 N 32897 0 63 +def ROUND(11111111) 3 8 0 N 32897 0 63 +def ROUND(111111111) 3 9 0 N 32897 0 63 +def ROUND(1111111111) 8 10 0 N 32897 0 63 +ROUND(1) ROUND(11) ROUND(111) ROUND(1111) ROUND(11111) ROUND(111111) ROUND(1111111) ROUND(11111111) ROUND(111111111) ROUND(1111111111) +# +# MDEV-12546 Wrong metadata or data type for string user variables +# +SET @a='test'; +SELECT @a; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def @a 251 16777215 4 Y 0 39 8 +@a +test +CREATE TABLE t1 AS SELECT @a; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `@a` longtext DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1; +SELECT @b1:=10, @b2:=@b2:=111111111111; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def @b1:=10 3 2 2 N 32897 0 63 +def @b2:=@b2:=111111111111 8 12 12 N 32897 0 63 +@b1:=10 @b2:=@b2:=111111111111 +10 111111111111 +CREATE TABLE t1 AS SELECT @b1:=10, @b2:=111111111111; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `@b1:=10` int(2) NOT NULL, + `@b2:=111111111111` bigint(12) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1; |