mysql-test/include/ctype_numconv.inc

10 create table t1 as select concat(1) as c1;
11 show create table t1;
16 create table t1 as select concat(18446744073709551615) as c1;
17 show create table t1;
22 create table t1 as select concat(1.1) as c1;
23 show create table t1;
33 create table t1 as select concat(1+2) as c1;
34 show create table t1;
38 create table t1 as select concat(1-2) as c1;
39 show create table t1;
43 create table t1 as select concat(1*2) as c1;
44 show create table t1;
48 create table t1 as select concat(1/2) as c1;
49 show create table t1;
53 create table t1 as select concat(1 div 2) as c1;
54 show create table t1;
58 create table t1 as select concat(1 % 2) as c1;
59 show create table t1;
63 create table t1 as select concat(-1) as c1;
64 show create table t1;
68 create table t1 as select concat(-(1+2)) as c1;
69 show create table t1;
78 create table t1 as select concat(1|2) as c1;
79 show create table t1;
83 create table t1 as select concat(1&2) as c1;
84 show create table t1;
88 create table t1 as select concat(bit_count(12)) as c1;
89 show create table t1;
93 create table t1 as select concat(2<<1) as c1;
94 show create table t1;
98 create table t1 as select concat(2>>1) as c1;
99 show create table t1;
103 create table t1 as select concat(~0) as c1;
104 show create table t1;
108 create table t1 as select concat(3^2) as c1;
109 show create table t1;
122 create table t1 as select concat(abs(-2)) as c1;
123 show create table t1;
127 create table t1 as select concat(exp(2)) as c1;
128 show create table t1;
132 create table t1 as select concat(log(2)) as c1;
133 show create table t1;
137 create table t1 as select concat(log2(2)) as c1;
138 show create table t1;
142 create table t1 as select concat(log10(2)) as c1;
143 show create table t1;
147 create table t1 as select concat(sqrt(2)) as c1;
148 show create table t1;
152 create table t1 as select concat(pow(2,2)) as c1;
153 show create table t1;
157 create table t1 as select concat(acos(0.5)) as c1;
158 show create table t1;
162 create table t1 as select concat(asin(0.5)) as c1;
163 show create table t1;
167 create table t1 as select concat(atan(0.5)) as c1;
168 show create table t1;
172 create table t1 as select concat(cos(0.5)) as c1;
173 show create table t1;
177 create table t1 as select concat(sin(0.5)) as c1;
178 show create table t1;
182 create table t1 as select concat(tan(0.5)) as c1;
183 show create table t1;
187 create table t1 as select concat(degrees(0)) as c1;
188 show create table t1;
192 create table t1 as select concat(radians(0)) as c1;
193 show create table t1;
197 create table t1 as select ceiling(0.5) as c0, concat(ceiling(0.5)) as c1;
198 show create table t1;
202 create table t1 as select floor(0.5) as c0, concat(floor(0.5)) as c1;
203 show create table t1;
207 create table t1 as select concat(round(0.5)) as c1;
208 show create table t1;
212 create table t1 as select concat(sign(0.5)) as c1;
213 show create table t1;
216 create table t1 as select concat(rand()) as c1;
217 show create table t1;
226 create table t1 as select concat(length('a')) as c1;
227 show create table t1;
231 create table t1 as select concat(char_length('a')) as c1;
232 show create table t1;
236 create table t1 as select concat(bit_length('a')) as c1;
237 show create table t1;
241 create table t1 as select concat(coercibility('a')) as c1;
242 show create table t1;
246 create table t1 as select concat(locate('a','a')) as c1;
247 show create table t1;
251 create table t1 as select concat(field('c','a','b','c')) as c1;
252 show create table t1;
256 create table t1 as select concat(ascii(61)) as c1;
257 show create table t1;
261 create table t1 as select concat(ord(61)) as c1;
262 show create table t1;
266 create table t1 as select concat(find_in_set('b','a,b,c,d')) as c1;
267 show create table t1;
276 create table t1 as select md5('a') as c1;
277 show create table t1;
281 create table t1 as select old_password('a') as c1;
282 show create table t1;
286 create table t1 as select password('a') as c1;
287 show create table t1;
291 create table t1 as select sha('a') as c1;
292 show create table t1;
296 create table t1 as select sha1('a') as c1;
297 show create table t1;
301 #create table t1 as select sha2('a',224) as c1;
302 #show create table t1;
312 create table t1 as select concat(cast('-1' as signed)) as c1;
313 show create table t1;
317 create table t1 as select concat(cast('1' as unsigned)) as c1;
318 show create table t1;
322 create table t1 as select concat(cast(1/2 as decimal(5,5))) as c1;
323 show create table t1;
327 create table t1 as select concat(cast('2001-01-02 03:04:05' as date)) as c1;
328 show create table t1;
333 create table t1 as select concat(cast('2001-01-02 03:04:05' as time)) as c1;
334 show create table t1;
339 create table t1 as select concat(cast('2001-01-02' as datetime)) as c1;
340 show create table t1;
349 create table t1 as select concat(least(1,2)) as c1;
350 show create table t1;
354 create table t1 as select concat(greatest(1,2)) as c1;
355 show create table t1;
363 create table t1 as select concat(case when 11 then 22 else 33 end) as c1;
364 show create table t1;
372 create table t1 as select concat(coalesce(1,2)) as c1;
373 show create table t1;
381 create table t1 as select concat_ws(1,2,3) as c1;
382 show create table t1;
386 create table t1 as select group_concat(1,2,3) as c1;
387 show create table t1;
393 create table t1 as select 1 as c1 union select 'a';
394 show create table t1;
403 create table t1 as select concat(last_insert_id()) as c1;
404 show create table t1;
408 create table t1 as select concat(benchmark(0,0)) as c1;
409 show create table t1;
413 create table t1 as select concat(sleep(0)) as c1;
414 show create table t1;
420 #create table t1 as select concat(get_lock('a',0)) as c1;
421 #show create table t1;
425 create table t1 as select concat(is_free_lock('xxxx')) as c1;
426 show create table t1;
429 create table t1 as select concat(is_used_lock('a')) as c1;
430 show create table t1;
433 create table t1 as select concat(release_lock('a')) as c1;
434 show create table t1;
438 create table t1 as select concat(crc32('')) as c1;
439 show create table t1;
443 create table t1 as select concat(uncompressed_length('')) as c1;
444 show create table t1;
447 create table t1 as select concat(connection_id()) as c1;
448 show create table t1;
452 create table t1 as select concat(inet_aton('127.1.1.1')) as c1;
453 show create table t1;
457 create table t1 as select concat(inet_ntoa(2130772225)) as c1;
459 show create table t1;
465 create table t1 as select concat(row_count()) as c1;
466 show create table t1;
470 create table t1 as select concat(found_rows()) as c1;
471 show create table t1;
474 create table t1 as select concat(uuid_short()) as c1;
475 show create table t1;
478 create table t1 as select concat(uuid()) as c1;
479 show create table t1;
489 create table t1 as select concat(uuid(), cast('a' as char character set latin1)) as c1;
490 show create table t1;
493 create table t1 as select concat(master_pos_wait('non-existent',0,2)) as c1;
494 show create table t1;
504 create table t1 as select concat(@a2:=2) as c1, @a3:=3 as c2;
506 show create table t1;
511 create table t1 as select concat(@a2) as c1, @a2 as c2;
513 show create table t1;
518 create table t1 as select concat(@a2:=sqrt(1)) as c1, @a3:=sqrt(1) as c2;
520 show create table t1;
525 create table t1 as select concat(@a2) as c1, @a2 as c2;
527 show create table t1;
532 create table t1 as select concat(@a2:=1.1) as c1, @a3:=1.1 as c2;
534 show create table t1;
539 create table t1 as select concat(@a2) as c1, @a2 as c2;
541 show create table t1;
546 create table t1 as select concat(@@ft_max_word_len) as c1;
548 show create table t1;
556 create table t1 as select concat('a'='a' IS TRUE) as c1;
557 show create table t1;
561 create table t1 as select concat('a'='a' IS NOT TRUE) as c1;
562 show create table t1;
566 create table t1 as select concat(NOT 'a'='a') as c1;
567 show create table t1;
571 create table t1 as select concat('a' IS NULL) as c1;
572 show create table t1;
576 create table t1 as select concat('a' IS NOT NULL) as c1;
577 show create table t1;
581 create table t1 as select concat('a' IS NOT NULL) as c1;
582 show create table t1;
586 create table t1 as select concat(strcmp('a','b')) as c1;
587 show create table t1;
591 create table t1 as select concat('a' like 'b') as c1;
592 show create table t1;
596 create table t1 as select concat('a' between 'b' and 'c') as c1;
597 show create table t1;
601 create table t1 as select concat('a' in ('a','b')) as c1;
602 show create table t1;
606 create table t1 as select concat(interval(23, 1, 15, 17, 30, 44, 200)) as c1;
607 show create table t1;
610 create table t1 (a varchar(10), fulltext key(a));
613 create table t2 as select concat(match (a) against ('a')) as a from t1;
614 show create table t2;
618 create table t1 as select ifnull(1,'a') as c1;
619 show create table t1;
623 create table t1 as select concat(ifnull(1,1)) as c1;
624 show create table t1;
628 create table t1 as select concat(ifnull(1.1,1.1)) as c1;
629 show create table t1;
633 create table t1 as select if(1,'b',1) as c1;
634 show create table t1;
638 create table t1 as select if(1,1,'b') as c1;
639 show create table t1;
643 create table t1 as select concat(if(1,1,1)) as c1;
644 show create table t1;
648 create table t1 as select concat(nullif(1,2)) as c1;
649 show create table t1;
657 create table t1 as select concat(Dimension(GeomFromText('LINSTRING(0 0,10 10)'))) as c1;
658 show create table t1;
662 create table t1 as select concat(NumGeometries(MultiPointFromText('MULTIPOINT(0 0,10 10)'))) as c1;
663 show create table t1;
667 create table t1 as select concat(NumPoints(MultiPointFromText('LINESTRING(0 0,10 10)'))) as c1;
668 show create table t1;
672 create table t1 as select concat(SRID(MultiPointFromText('MULTIPOINT(0 0,10 10)'))) as c1;
673 show create table t1;
677 create table t1 as select concat(NumInteriorRings(PolygonFromText('POLYGON((0 0,50 0,50 50,0 50,0 0…
678 show create table t1;
682 create table t1 as select concat(IsEmpty(GeomFromText('Point(1 1)'))) as c1;
683 show create table t1;
687 create table t1 as select concat(IsSimple(GeomFromText('Point(1 1)'))) as c1;
688 show create table t1;
692 create table t1 as select concat(IsClosed(GeomFromText('LineString(1 1,2 2)'))) as c1;
693 show create table t1;
697 create table t1 as select concat(Equals(GeomFromText('Point(1 1)'),GeomFromText('Point(1 1)'))) as …
701 create table t1 as select concat(x(GeomFromText('Point(1 2)'))) as c1;
702 show create table t1;
706 create table t1 as select concat(x(GeomFromText('Point(1 2)'))) as c1;
707 show create table t1;
711 create table t1 as select concat(GLength(GeomFromText('LineString(1 2, 2 2)'))) as c1;
712 show create table t1;
716 create table t1 as select concat(Area(GeomFromText('Polygon((0 0,1 0,1 1,0 1,0 0))'))) as c1;
717 show create table t1;
721 create table t1 as select concat(GeometryType(GeomFromText('Point(1 2)'))) as c1;
722 show create table t1;
726 create table t1 as select concat(AsText(GeomFromText('Point(1 2)'))) as c1;
727 show create table t1;
737 create table t1 as select concat(period_add(200902, 2)) as c1;
738 show create table t1;
743 create table t1 as select concat(period_add(200902, 200802)) as c1;
744 show create table t1;
748 create table t1 as select concat(to_days(20090224)) as c1;
749 show create table t1;
753 create table t1 as select concat(dayofmonth(20090224)) as c1;
754 show create table t1;
758 create table t1 as select concat(dayofyear(20090224)) as c1;
759 show create table t1;
763 create table t1 as select concat(hour('10:11:12')) as c1;
764 show create table t1;
768 create table t1 as select concat(minute('10:11:12')) as c1;
769 show create table t1;
773 create table t1 as select concat(second('10:11:12')) as c1;
774 show create table t1;
778 create table t1 as select concat(quarter(20090224)) as c1;
779 show create table t1;
783 create table t1 as select concat(week(20090224)) as c1;
784 show create table t1;
788 create table t1 as select concat(yearweek(20090224)) as c1;
789 show create table t1;
793 create table t1 as select concat(year(20090224)) as c1;
794 show create table t1;
798 create table t1 as select concat(weekday(20090224)) as c1;
799 show create table t1;
803 create table t1 as select concat(dayofweek(20090224)) as c1;
804 show create table t1;
808 create table t1 as select concat(unix_timestamp(20090224)) as c1;
809 show create table t1;
813 create table t1 as select concat(time_to_sec('10:11:12')) as c1;
814 show create table t1;
818 create table t1 as select concat(extract(year from 20090702)) as c1;
819 show create table t1;
823 create table t1 as select concat(microsecond('12:00:00.123456')) as c1;
824 show create table t1;
828 create table t1 as select concat(month(20090224)) as c1;
829 show create table t1;
833 create table t1 as select concat(last_day('2003-02-05')) as c1;
834 show create table t1;
838 create table t1 as select concat(from_days(730669)) as c1;
839 show create table t1;
843 create table t1 as select concat(curdate()) as c1;
844 show create table t1;
847 create table t1 as select concat(utc_date()) as c1;
848 show create table t1;
851 create table t1 as select concat(curtime()) as c1;
852 show create table t1;
855 create table t1 as select repeat('a',20) as c1 limit 0;
862 create table t1 as select concat(utc_time()) as c1;
863 show create table t1;
867 create table t1 as select concat(sec_to_time(2378)) as c1;
868 show create table t1;
872 create table t1 as select concat(timediff('2001-01-02 00:00:00', '2001-01-01 00:00:00')) as c1;
873 show create table t1;
877 create table t1 as select concat(maketime(10,11,12)) as c1;
878 show create table t1;
882 create table t1 as select get_format(DATE,'USA') as c1;
883 show create table t1;
887 create table t1 as select concat(from_unixtime(1111885200)) as c1;
888 show create table t1;
892 create table t1 as select concat(convert_tz('2004-01-01 12:00:00','+10:00','-6:00')) as c1;
893 show create table t1;
897 create table t1 as select concat(date_add('2004-01-01 12:00:00', interval 1 day)) as c1;
898 show create table t1;
903 create table t1 as select concat(makedate(2009,1)) as c1;
904 show create table t1;
908 create table t1 as select concat(now()) as c1;
909 show create table t1;
912 create table t1 as select concat(utc_timestamp()) as c1;
913 show create table t1;
916 create table t1 as select concat(sysdate()) as c1;
917 show create table t1;
921 create table t1 as select concat(addtime('00:00:00','11:22:33')) as c1;
922 show create table t1;
926 create table t1 as select concat(subtime('23:59:59','11:22:33')) as c1;
927 show create table t1;
935 create table t1 as select elt(1,2,3) as c1;
936 show create table t1;
940 create table t1 as select export_set(1,2,3,4,2) as c1;
941 show create table t1;
945 create table t1 as select insert(1133,3,0,22) as c1;
946 show create table t1;
950 create table t1 as select lcase(123) as c1;
951 show create table t1;
955 create table t1 as select left(123,1) as c1;
956 show create table t1;
960 create table t1 as select lower(123) as c1;
961 show create table t1;
965 create table t1 as select lpad(1,2,0) as c1;
966 show create table t1;
970 create table t1 as select ltrim(1) as c1;
971 show create table t1;
975 create table t1 as select mid(1,1,1) as c1;
976 show create table t1;
980 create table t1 as select repeat(1,2) as c1;
981 show create table t1;
985 create table t1 as select replace(1,1,2) as c1;
986 show create table t1;
990 create table t1 as select reverse(12) as c1;
991 show create table t1;
995 create table t1 as select right(123,1) as c1;
996 show create table t1;
1000 create table t1 as select rpad(1,2,0) as c1;
1001 show create table t1;
1005 create table t1 as select rtrim(1) as c1;
1006 show create table t1;
1010 create table t1 as select soundex(1) as c1;
1011 show create table t1;
1015 create table t1 as select substring(1,1,1) as c1;
1016 show create table t1;
1020 create table t1 as select trim(1) as c1;
1021 show create table t1;
1025 create table t1 as select ucase(1) as c1;
1026 show create table t1;
1030 create table t1 as select upper(1) as c1;
1031 show create table t1;
1038 create table t1 as select repeat(' ', 64) as a limit 0;
1039 show create table t1;
1050 create table t1 (a tinyint);
1053 create table t2 as select concat(a) from t1;
1054 show create table t2;
1057 create table t1 (a tinyint zerofill);
1062 create table t1 (a tinyint(4) zerofill);
1067 create table t1 (a decimal(10,2));
1070 create table t2 as select concat(a) from t1;
1071 show create table t2;
1074 create table t1 (a smallint);
1077 create table t2 as select concat(a) from t1;
1078 show create table t2;
1081 create table t1 (a smallint zerofill);
1086 create table t1 (a mediumint);
1089 create table t2 as select concat(a) from t1;
1090 show create table t2;
1093 create table t1 (a mediumint zerofill);
1098 create table t1 (a int);
1101 create table t2 as select concat(a) from t1;
1102 show create table t2;
1105 create table t1 (a int zerofill);
1110 create table t1 (a bigint);
1113 create table t2 as select concat(a) from t1;
1114 show create table t2;
1117 create table t1 (a bigint zerofill);
1122 create table t1 (a float);
1126 create table t2 as select concat(a) from t1;
1127 show create table t2;
1130 create table t1 (a float zerofill);
1135 create table t1 (a double);
1139 create table t2 as select concat(a) from t1;
1140 show create table t2;
1143 create table t1 (a double zerofill);
1148 create table t1 (a year(2));
1151 create table t2 as select concat(a) from t1;
1152 show create table t2;
1155 create table t1 (a year);
1158 create table t2 as select concat(a) from t1;
1159 show create table t2;
1162 create table t1 (a bit(64));
1166 create table t2 as select concat(a) from t1;
1167 show create table t2;
1170 create table t1 (a timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
1177 create table t2 as select concat(a) from t1;
1178 show create table t2;
1181 create table t1 (a date);
1185 create table t2 as select concat(a) from t1;
1186 show create table t2;
1189 create table t1 (a time);
1194 create table t2 as select concat(a) from t1;
1195 show create table t2;
1198 create table t1 (a datetime);
1202 create table t2 as select concat(a) from t1;
1203 show create table t2;
1208 # create view with string functions with numeric input
1213 create view v1 as select concat(1,2,3) as c1;
1218 create view v1 as select concat_ws(',',1,2,3) as c1;
1223 create view v1 as select elt(1,2,3) as c1;
1228 create view v1 as select export_set(1,2,3,4,2) as c1;
1233 create view v1 as select insert(1133,3,0,22) as c1;
1238 create view v1 as select lcase(123) as c1;
1243 create view v1 as select left(123,1) as c1;
1248 create view v1 as select lower(123) as c1;
1253 create view v1 as select lpad(1,2,0) as c1;
1258 create view v1 as select ltrim(1) as c1;
1263 create view v1 as select mid(1,1,1) as c1;
1268 create view v1 as select repeat(1,2) as c1;
1273 create view v1 as select replace(1,1,2) as c1;
1278 create view v1 as select reverse(12) as c1;
1283 create view v1 as select right(123,1) as c1;
1288 create view v1 as select rpad(1,2,0) as c1;
1293 create view v1 as select rtrim(1) as c1;
1298 create view v1 as select soundex(1) as c1;
1303 create view v1 as select substring(1,1,1) as c1;
1308 create view v1 as select trim(1) as c1;
1313 create view v1 as select ucase(1) as c1;
1318 create view v1 as select upper(1) as c1;
1328 create table t1 (a tinyint);
1330 create view v1(a) as select concat(a) from t1;
1336 create table t1 (a tinyint zerofill);
1338 create view v1(a) as select concat(a) from t1;
1344 create table t1 (a tinyint(30) zerofill);
1346 create view v1(a) as select concat(a) from t1;
1352 create table t1 (a decimal(10,2));
1354 create view v1(a) as select concat(a) from t1;
1360 create table t1 (a smallint);
1362 create view v1(a) as select concat(a) from t1;
1368 create table t1 (a smallint zerofill);
1370 create view v1(a) as select concat(a) from t1;
1376 create table t1 (a mediumint);
1378 create view v1(a) as select concat(a) from t1;
1384 create table t1 (a mediumint zerofill);
1386 create view v1(a) as select concat(a) from t1;
1392 create table t1 (a int);
1394 create view v1(a) as select concat(a) from t1;
1400 create table t1 (a int zerofill);
1402 create view v1(a) as select concat(a) from t1;
1408 create table t1 (a bigint);
1410 create view v1(a) as select concat(a) from t1;
1416 create table t1 (a bigint zerofill);
1418 create view v1(a) as select concat(a) from t1;
1424 create table t1 (a float);
1426 create view v1(a) as select concat(a) from t1;
1432 create table t1 (a float zerofill);
1434 create view v1(a) as select concat(a) from t1;
1440 create table t1 (a double);
1443 create view v1(a) as select concat(a) from t1;
1449 create table t1 (a double zerofill);
1451 create view v1(a) as select concat(a) from t1;
1457 create table t1 (a year(2));
1459 create view v1(a) as select concat(a) from t1;
1465 create table t1 (a year);
1467 create view v1(a) as select concat(a) from t1;
1473 create table t1 (a bit(64));
1476 create view v1(a) as select concat(a) from t1;
1482 create table t1 (a timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
1487 create view v1(a) as select concat(a) from t1;
1493 create table t1 (a date);
1496 create view v1(a) as select concat(a) from t1;
1502 create table t1 (a time);
1505 create view v1(a) as select concat(a) from t1;
1511 create table t1 (a datetime);
1514 create view v1(a) as select concat(a) from t1;
1524 create function f1 (par1 int) returns int
1533 create table t1 as select f1(1) as c1;
1534 show create table t1;
1536 create table t1 as select concat(f1(1)) as c1;
1537 show create table t1;
1538 create view v1 as select concat(f1(1)) as c1;
1545 create function f1 (par1 decimal(18,2)) returns decimal(18,2)
1554 create table t1 as select f1(123.45) as c1;
1555 show create table t1;
1557 create table t1 as select concat(f1(123.45)) as c1;
1558 show create table t1;
1559 create view v1 as select concat(f1(123.45)) as c1;
1566 create function f1 (par1 float) returns float
1575 create table t1 as select f1(123.45) as c1;
1576 show create table t1;
1578 create table t1 as select concat(f1(123.45)) as c1;
1579 show create table t1;
1580 create view v1 as select concat(f1(123.45)) as c1;
1587 create function f1 (par1 date) returns date
1596 create table t1 as select f1(cast('2001-01-02' as date)) as c1;
1597 show create table t1;
1599 create table t1 as select concat(f1(cast('2001-01-02' as date))) as c1;
1600 show create table t1;
1601 create view v1 as select concat(f1(cast('2001-01-02' as date))) as c1;
1636 # is in use, which will create instances of Item_copy.