mysql-test/include/ctype_numconv.inc

8 create table t1 as select concat(1) as c1;
9 show create table t1;
14 create table t1 as select concat(18446744073709551615) as c1;
15 show create table t1;
20 create table t1 as select concat(1.1) as c1;
21 show create table t1;
31 create table t1 as select concat(1+2) as c1;
32 show create table t1;
36 create table t1 as select concat(1-2) as c1;
37 show create table t1;
41 create table t1 as select concat(1*2) as c1;
42 show create table t1;
46 create table t1 as select concat(1/2) as c1;
47 show create table t1;
51 create table t1 as select concat(1 div 2) as c1;
52 show create table t1;
56 create table t1 as select concat(1 % 2) as c1;
57 show create table t1;
61 create table t1 as select concat(-1) as c1;
62 show create table t1;
66 create table t1 as select concat(-(1+2)) as c1;
67 show create table t1;
76 create table t1 as select concat(1|2) as c1;
77 show create table t1;
81 create table t1 as select concat(1&2) as c1;
82 show create table t1;
86 create table t1 as select concat(bit_count(12)) as c1;
87 show create table t1;
91 create table t1 as select concat(2<<1) as c1;
92 show create table t1;
96 create table t1 as select concat(2>>1) as c1;
97 show create table t1;
101 create table t1 as select concat(~0) as c1;
102 show create table t1;
106 create table t1 as select concat(3^2) as c1;
107 show create table t1;
120 create table t1 as select concat(abs(-2)) as c1;
121 show create table t1;
125 create table t1 as select concat(exp(2)) as c1;
126 show create table t1;
130 create table t1 as select concat(log(2)) as c1;
131 show create table t1;
135 create table t1 as select concat(log2(2)) as c1;
136 show create table t1;
140 create table t1 as select concat(log10(2)) as c1;
141 show create table t1;
145 create table t1 as select concat(sqrt(2)) as c1;
146 show create table t1;
150 create table t1 as select concat(pow(2,2)) as c1;
151 show create table t1;
155 create table t1 as select concat(acos(0.5)) as c1;
156 show create table t1;
160 create table t1 as select concat(asin(0.5)) as c1;
161 show create table t1;
165 create table t1 as select concat(atan(0.5)) as c1;
166 show create table t1;
170 create table t1 as select concat(cos(0.5)) as c1;
171 show create table t1;
175 create table t1 as select concat(sin(0.5)) as c1;
176 show create table t1;
180 create table t1 as select concat(tan(0.5)) as c1;
181 show create table t1;
185 create table t1 as select concat(degrees(0)) as c1;
186 show create table t1;
190 create table t1 as select concat(radians(0)) as c1;
191 show create table t1;
195 create table t1 as select concat(ceiling(0.5)) as c1;
196 show create table t1;
200 create table t1 as select concat(floor(0.5)) as c1;
201 show create table t1;
205 create table t1 as select concat(round(0.5)) as c1;
206 show create table t1;
210 create table t1 as select concat(sign(0.5)) as c1;
211 show create table t1;
214 create table t1 as select concat(rand()) as c1;
215 show create table t1;
224 create table t1 as select concat(length('a')) as c1;
225 show create table t1;
229 create table t1 as select concat(char_length('a')) as c1;
230 show create table t1;
234 create table t1 as select concat(bit_length('a')) as c1;
235 show create table t1;
239 create table t1 as select concat(coercibility('a')) as c1;
240 show create table t1;
244 create table t1 as select concat(locate('a','a')) as c1;
245 show create table t1;
249 create table t1 as select concat(field('c','a','b','c')) as c1;
250 show create table t1;
254 create table t1 as select concat(ascii(61)) as c1;
255 show create table t1;
259 create table t1 as select concat(ord(61)) as c1;
260 show create table t1;
264 create table t1 as select concat(find_in_set('b','a,b,c,d')) as c1;
265 show create table t1;
274 create table t1 as select md5('a') as c1;
275 show create table t1;
280 create table t1 as select password('a') as c1;
283 show create table t1;
287 create table t1 as select sha('a') as c1;
288 show create table t1;
292 create table t1 as select sha1('a') as c1;
293 show create table t1;
297 #create table t1 as select sha2('a',224) as c1;
298 #show create table t1;
308 create table t1 as select concat(cast('-1' as signed)) as c1;
309 show create table t1;
313 create table t1 as select concat(cast('1' as unsigned)) as c1;
314 show create table t1;
318 create table t1 as select concat(cast(1/2 as decimal(5,5))) as c1;
319 show create table t1;
323 create table t1 as select concat(cast('2001-01-02 03:04:05' as date)) as c1;
324 show create table t1;
329 create table t1 as select concat(cast('2001-01-02 03:04:05' as time)) as c1;
330 show create table t1;
335 create table t1 as select concat(cast('2001-01-02' as datetime)) as c1;
336 show create table t1;
345 create table t1 as select concat(least(1,2)) as c1;
346 show create table t1;
350 create table t1 as select concat(greatest(1,2)) as c1;
351 show create table t1;
359 create table t1 as select concat(case when 11 then 22 else 33 end) as c1;
360 show create table t1;
368 create table t1 as select concat(coalesce(1,2)) as c1;
369 show create table t1;
377 create table t1 as select concat_ws(1,2,3) as c1;
378 show create table t1;
382 create table t1 as select group_concat(1,2,3) as c1;
383 show create table t1;
389 create table t1 as select 1 as c1 union select 'a';
390 show create table t1;
399 create table t1 as select concat(last_insert_id()) as c1;
400 show create table t1;
404 create table t1 as select concat(benchmark(0,0)) as c1;
405 show create table t1;
409 create table t1 as select concat(sleep(0)) as c1;
410 show create table t1;
416 #create table t1 as select concat(get_lock('a',0)) as c1;
417 #show create table t1;
421 create table t1 as select concat(is_free_lock('xxxx')) as c1;
422 show create table t1;
425 create table t1 as select concat(is_used_lock('a')) as c1;
426 show create table t1;
429 create table t1 as select concat(release_lock('a')) as c1;
430 show create table t1;
434 create table t1 as select concat(crc32('')) as c1;
435 show create table t1;
439 create table t1 as select concat(uncompressed_length('')) as c1;
440 show create table t1;
443 create table t1 as select concat(connection_id()) as c1;
444 show create table t1;
448 create table t1 as select concat(inet_aton('127.1.1.1')) as c1;
449 show create table t1;
453 create table t1 as select concat(inet_ntoa(2130772225)) as c1;
455 show create table t1;
461 create table t1 as select concat(row_count()) as c1;
462 show create table t1;
466 create table t1 as select concat(found_rows()) as c1;
467 show create table t1;
470 create table t1 as select concat(uuid_short()) as c1;
471 show create table t1;
474 create table t1 as select concat(uuid()) as c1;
475 show create table t1;
485 create table t1 as select concat(uuid(), cast('a' as char character set latin1)) as c1;
486 show create table t1;
489 create table t1 as select concat(master_pos_wait('non-existent',0,2)) as c1;
490 show create table t1;
500 create table t1 as select concat(@a2:=2) as c1, @a3:=3 as c2;
502 show create table t1;
507 create table t1 as select concat(@a2) as c1, @a2 as c2;
509 show create table t1;
514 create table t1 as select concat(@a2:=sqrt(1)) as c1, @a3:=sqrt(1) as c2;
516 show create table t1;
521 create table t1 as select concat(@a2) as c1, @a2 as c2;
523 show create table t1;
528 create table t1 as select concat(@a2:=1.1) as c1, @a3:=1.1 as c2;
530 show create table t1;
535 create table t1 as select concat(@a2) as c1, @a2 as c2;
537 show create table t1;
542 create table t1 as select concat(@@ft_max_word_len) as c1;
544 show create table t1;
552 create table t1 as select concat('a'='a' IS TRUE) as c1;
553 show create table t1;
557 create table t1 as select concat('a'='a' IS NOT TRUE) as c1;
558 show create table t1;
562 create table t1 as select concat(NOT 'a'='a') as c1;
563 show create table t1;
567 create table t1 as select concat('a' IS NULL) as c1;
568 show create table t1;
572 create table t1 as select concat('a' IS NOT NULL) as c1;
573 show create table t1;
577 create table t1 as select concat('a' IS NOT NULL) as c1;
578 show create table t1;
582 create table t1 as select concat(strcmp('a','b')) as c1;
583 show create table t1;
587 create table t1 as select concat('a' like 'b') as c1;
588 show create table t1;
592 create table t1 as select concat('a' between 'b' and 'c') as c1;
593 show create table t1;
597 create table t1 as select concat('a' in ('a','b')) as c1;
598 show create table t1;
602 create table t1 as select concat(interval(23, 1, 15, 17, 30, 44, 200)) as c1;
603 show create table t1;
606 create table t1 (a varchar(10), fulltext key(a));
609 create table t2 as select concat(match (a) against ('a')) as a from t1;
610 show create table t2;
614 create table t1 as select ifnull(1,'a') as c1;
615 show create table t1;
619 create table t1 as select concat(ifnull(1,1)) as c1;
620 show create table t1;
624 create table t1 as select concat(ifnull(1.1,1.1)) as c1;
625 show create table t1;
629 create table t1 as select if(1,'b',1) as c1;
630 show create table t1;
634 create table t1 as select if(1,1,'b') as c1;
635 show create table t1;
639 create table t1 as select concat(if(1,1,1)) as c1;
640 show create table t1;
644 create table t1 as select concat(nullif(1,2)) as c1;
645 show create table t1;
654 create table t1 as select concat(ST_Dimension(ST_GeomFromText('LINSTRING(0 0,10 10)'))) as c1;
657 create table t1 as select concat(ST_NumGeometries(ST_MultiPointFromText('MULTIPOINT(0 0,10 10)'))) …
658 show create table t1;
662 create table t1 as select concat(ST_NumPoints(ST_MultiPointFromText('LINESTRING(0 0,10 10)'))) as c…
663 show create table t1;
667 create table t1 as select concat(ST_SRID(ST_MultiPointFromText('MULTIPOINT(0 0,10 10)'))) as c1;
668 show create table t1;
672 create table t1 as select concat(ST_NumInteriorRings(ST_PolygonFromText('POLYGON((0 0,50 0,50 50,0 …
673 show create table t1;
677 create table t1 as select concat(ST_IsEmpty(ST_GeomFromText('Point(1 1)'))) as c1;
678 show create table t1;
682 create table t1 as select concat(ST_IsSimple(ST_GeomFromText('Point(1 1)'))) as c1;
683 show create table t1;
687 create table t1 as select concat(ST_IsClosed(ST_GeomFromText('LineString(1 1,2 2)'))) as c1;
688 show create table t1;
692 create table t1 as select concat(MBREquals(ST_GeomFromText('Point(1 1)'),ST_GeomFromText('Point(1 1…
696 create table t1 as select concat(ST_X(ST_GeomFromText('Point(1 2)'))) as c1;
697 show create table t1;
701 create table t1 as select concat(ST_X(ST_GeomFromText('Point(1 2)'))) as c1;
702 show create table t1;
706 create table t1 as select concat(ST_Length(ST_GeomFromText('LineString(1 2, 2 2)'))) as c1;
707 show create table t1;
711 create table t1 as select concat(ST_Area(ST_GeomFromText('Polygon((0 0,1 0,1 1,0 1,0 0))'))) as c1;
712 show create table t1;
716 create table t1 as select concat(ST_GeometryType(ST_GeomFromText('Point(1 2)'))) as c1;
717 show create table t1;
721 create table t1 as select concat(ST_AsText(ST_GeomFromText('Point(1 2)'))) as c1;
722 show create table t1;
732 create table t1 as select concat(period_add(200902, 2)) as c1;
733 show create table t1;
737 create table t1 as select concat(period_add(200902, 200802)) as c1;
738 show create table t1;
742 create table t1 as select concat(to_days(20090224)) as c1;
743 show create table t1;
747 create table t1 as select concat(dayofmonth(20090224)) as c1;
748 show create table t1;
752 create table t1 as select concat(dayofyear(20090224)) as c1;
753 show create table t1;
757 create table t1 as select concat(hour('10:11:12')) as c1;
758 show create table t1;
762 create table t1 as select concat(minute('10:11:12')) as c1;
763 show create table t1;
767 create table t1 as select concat(second('10:11:12')) as c1;
768 show create table t1;
772 create table t1 as select concat(quarter(20090224)) as c1;
773 show create table t1;
777 create table t1 as select concat(week(20090224)) as c1;
778 show create table t1;
782 create table t1 as select concat(yearweek(20090224)) as c1;
783 show create table t1;
787 create table t1 as select concat(year(20090224)) as c1;
788 show create table t1;
792 create table t1 as select concat(weekday(20090224)) as c1;
793 show create table t1;
797 create table t1 as select concat(dayofweek(20090224)) as c1;
798 show create table t1;
802 create table t1 as select concat(unix_timestamp(20090224)) as c1;
803 show create table t1;
807 create table t1 as select concat(time_to_sec('10:11:12')) as c1;
808 show create table t1;
812 create table t1 as select concat(extract(year from 20090702)) as c1;
813 show create table t1;
817 create table t1 as select concat(microsecond('12:00:00.123456')) as c1;
818 show create table t1;
822 create table t1 as select concat(month(20090224)) as c1;
823 show create table t1;
827 create table t1 as select concat(last_day('2003-02-05')) as c1;
828 show create table t1;
832 create table t1 as select concat(from_days(730669)) as c1;
833 show create table t1;
837 create table t1 as select concat(curdate()) as c1;
838 show create table t1;
841 create table t1 as select concat(utc_date()) as c1;
842 show create table t1;
845 create table t1 as select concat(curtime()) as c1;
846 show create table t1;
849 create table t1 as select repeat('a',20) as c1 limit 0;
856 create table t1 as select concat(utc_time()) as c1;
857 show create table t1;
861 create table t1 as select concat(sec_to_time(2378)) as c1;
862 show create table t1;
866 create table t1 as select concat(timediff('2001-01-02 00:00:00', '2001-01-01 00:00:00')) as c1;
867 show create table t1;
871 create table t1 as select concat(maketime(10,11,12)) as c1;
872 show create table t1;
876 create table t1 as select get_format(DATE,'USA') as c1;
877 show create table t1;
881 create table t1 as select concat(from_unixtime(1111885200)) as c1;
882 show create table t1;
886 create table t1 as select concat(convert_tz('2004-01-01 12:00:00','+10:00','-6:00')) as c1;
887 show create table t1;
891 create table t1 as select concat(date_add('2004-01-01 12:00:00', interval 1 day)) as c1;
892 show create table t1;
897 create table t1 as select concat(makedate(2009,1)) as c1;
898 show create table t1;
902 create table t1 as select concat(now()) as c1;
903 show create table t1;
906 create table t1 as select concat(utc_timestamp()) as c1;
907 show create table t1;
910 create table t1 as select concat(sysdate()) as c1;
911 show create table t1;
915 create table t1 as select concat(addtime('00:00:00','11:22:33')) as c1;
916 show create table t1;
920 create table t1 as select concat(subtime('23:59:59','11:22:33')) as c1;
921 show create table t1;
929 create table t1 as select elt(1,2,3) as c1;
930 show create table t1;
934 create table t1 as select export_set(1,2,3,4,2) as c1;
935 show create table t1;
939 create table t1 as select insert(1133,3,0,22) as c1;
940 show create table t1;
944 create table t1 as select lcase(123) as c1;
945 show create table t1;
949 create table t1 as select left(123,1) as c1;
950 show create table t1;
954 create table t1 as select lower(123) as c1;
955 show create table t1;
959 create table t1 as select lpad(1,2,0) as c1;
960 show create table t1;
964 create table t1 as select ltrim(1) as c1;
965 show create table t1;
969 create table t1 as select mid(1,1,1) as c1;
970 show create table t1;
974 create table t1 as select repeat(1,2) as c1;
975 show create table t1;
979 create table t1 as select replace(1,1,2) as c1;
980 show create table t1;
984 create table t1 as select reverse(12) as c1;
985 show create table t1;
989 create table t1 as select right(123,1) as c1;
990 show create table t1;
994 create table t1 as select rpad(1,2,0) as c1;
995 show create table t1;
999 create table t1 as select rtrim(1) as c1;
1000 show create table t1;
1004 create table t1 as select soundex(1) as c1;
1005 show create table t1;
1009 create table t1 as select substring(1,1,1) as c1;
1010 show create table t1;
1014 create table t1 as select trim(1) as c1;
1015 show create table t1;
1019 create table t1 as select ucase(1) as c1;
1020 show create table t1;
1024 create table t1 as select upper(1) as c1;
1025 show create table t1;
1032 create table t1 as select repeat(' ', 64) as a limit 0;
1033 show create table t1;
1044 create table t1 (a tinyint);
1047 create table t2 as select concat(a) from t1;
1048 show create table t2;
1051 create table t1 (a tinyint zerofill);
1056 create table t1 (a tinyint(4) zerofill);
1061 create table t1 (a decimal(10,2));
1064 create table t2 as select concat(a) from t1;
1065 show create table t2;
1068 create table t1 (a smallint);
1071 create table t2 as select concat(a) from t1;
1072 show create table t2;
1075 create table t1 (a smallint zerofill);
1080 create table t1 (a mediumint);
1083 create table t2 as select concat(a) from t1;
1084 show create table t2;
1087 create table t1 (a mediumint zerofill);
1092 create table t1 (a int);
1095 create table t2 as select concat(a) from t1;
1096 show create table t2;
1099 create table t1 (a int zerofill);
1104 create table t1 (a bigint);
1107 create table t2 as select concat(a) from t1;
1108 show create table t2;
1111 create table t1 (a bigint zerofill);
1116 create table t1 (a float);
1120 create table t2 as select concat(a) from t1;
1121 show create table t2;
1124 create table t1 (a float zerofill);
1129 create table t1 (a double);
1133 create table t2 as select concat(a) from t1;
1134 show create table t2;
1137 create table t1 (a double zerofill);
1142 create table t1 (a year(4));
1145 create table t2 as select concat(a) from t1;
1146 show create table t2;
1149 create table t1 (a year);
1152 create table t2 as select concat(a) from t1;
1153 show create table t2;
1156 create table t1 (a bit(64));
1160 create table t2 as select concat(a) from t1;
1161 show create table t2;
1164 create table t1 (a timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
1171 create table t2 as select concat(a) from t1;
1172 show create table t2;
1175 create table t1 (a date);
1179 create table t2 as select concat(a) from t1;
1180 show create table t2;
1183 create table t1 (a time);
1188 create table t2 as select concat(a) from t1;
1189 show create table t2;
1192 create table t1 (a datetime);
1196 create table t2 as select concat(a) from t1;
1197 show create table t2;
1202 # create view with string functions with numeric input
1207 create view v1 as select concat(1,2,3) as c1;
1212 create view v1 as select concat_ws(',',1,2,3) as c1;
1217 create view v1 as select elt(1,2,3) as c1;
1222 create view v1 as select export_set(1,2,3,4,2) as c1;
1227 create view v1 as select insert(1133,3,0,22) as c1;
1232 create view v1 as select lcase(123) as c1;
1237 create view v1 as select left(123,1) as c1;
1242 create view v1 as select lower(123) as c1;
1247 create view v1 as select lpad(1,2,0) as c1;
1252 create view v1 as select ltrim(1) as c1;
1257 create view v1 as select mid(1,1,1) as c1;
1262 create view v1 as select repeat(1,2) as c1;
1267 create view v1 as select replace(1,1,2) as c1;
1272 create view v1 as select reverse(12) as c1;
1277 create view v1 as select right(123,1) as c1;
1282 create view v1 as select rpad(1,2,0) as c1;
1287 create view v1 as select rtrim(1) as c1;
1292 create view v1 as select soundex(1) as c1;
1297 create view v1 as select substring(1,1,1) as c1;
1302 create view v1 as select trim(1) as c1;
1307 create view v1 as select ucase(1) as c1;
1312 create view v1 as select upper(1) as c1;
1322 create table t1 (a tinyint);
1324 create view v1(a) as select concat(a) from t1;
1330 create table t1 (a tinyint zerofill);
1332 create view v1(a) as select concat(a) from t1;
1338 create table t1 (a tinyint(30) zerofill);
1340 create view v1(a) as select concat(a) from t1;
1346 create table t1 (a decimal(10,2));
1348 create view v1(a) as select concat(a) from t1;
1354 create table t1 (a smallint);
1356 create view v1(a) as select concat(a) from t1;
1362 create table t1 (a smallint zerofill);
1364 create view v1(a) as select concat(a) from t1;
1370 create table t1 (a mediumint);
1372 create view v1(a) as select concat(a) from t1;
1378 create table t1 (a mediumint zerofill);
1380 create view v1(a) as select concat(a) from t1;
1386 create table t1 (a int);
1388 create view v1(a) as select concat(a) from t1;
1394 create table t1 (a int zerofill);
1396 create view v1(a) as select concat(a) from t1;
1402 create table t1 (a bigint);
1404 create view v1(a) as select concat(a) from t1;
1410 create table t1 (a bigint zerofill);
1412 create view v1(a) as select concat(a) from t1;
1418 create table t1 (a float);
1420 create view v1(a) as select concat(a) from t1;
1426 create table t1 (a float zerofill);
1428 create view v1(a) as select concat(a) from t1;
1434 create table t1 (a double);
1437 create view v1(a) as select concat(a) from t1;
1443 create table t1 (a double zerofill);
1445 create view v1(a) as select concat(a) from t1;
1451 create table t1 (a year(4));
1453 create view v1(a) as select concat(a) from t1;
1459 create table t1 (a year);
1461 create view v1(a) as select concat(a) from t1;
1467 create table t1 (a bit(64));
1470 create view v1(a) as select concat(a) from t1;
1476 create table t1 (a timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
1481 create view v1(a) as select concat(a) from t1;
1487 create table t1 (a date);
1490 create view v1(a) as select concat(a) from t1;
1496 create table t1 (a time);
1499 create view v1(a) as select concat(a) from t1;
1505 create table t1 (a datetime);
1508 create view v1(a) as select concat(a) from t1;
1518 create function f1 (par1 int) returns int
1527 create table t1 as select f1(1) as c1;
1528 show create table t1;
1530 create table t1 as select concat(f1(1)) as c1;
1531 show create table t1;
1532 create view v1 as select concat(f1(1)) as c1;
1539 create function f1 (par1 decimal(18,2)) returns decimal(18,2)
1548 create table t1 as select f1(123.45) as c1;
1549 show create table t1;
1551 create table t1 as select concat(f1(123.45)) as c1;
1552 show create table t1;
1553 create view v1 as select concat(f1(123.45)) as c1;
1560 create function f1 (par1 float) returns float
1569 create table t1 as select f1(123.45) as c1;
1570 show create table t1;
1572 create table t1 as select concat(f1(123.45)) as c1;
1573 show create table t1;
1574 create view v1 as select concat(f1(123.45)) as c1;
1581 create function f1 (par1 date) returns date
1590 create table t1 as select f1(cast('2001-01-02' as date)) as c1;
1591 show create table t1;
1593 create table t1 as select concat(f1(cast('2001-01-02' as date))) as c1;
1594 show create table t1;
1595 create view v1 as select concat(f1(cast('2001-01-02' as date))) as c1;
1628 # is in use, which will create instances of Item_copy.