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;
279 create table t1 as select old_password('a') as c1;
280 show create table t1;
284 create table t1 as select password('a') as c1;
285 show create table t1;
289 create table t1 as select sha('a') as c1;
290 show create table t1;
294 create table t1 as select sha1('a') as c1;
295 show create table t1;
299 #create table t1 as select sha2('a',224) as c1;
300 #show create table t1;
310 create table t1 as select concat(cast('-1' as signed)) as c1;
311 show create table t1;
315 create table t1 as select concat(cast('1' as unsigned)) as c1;
316 show create table t1;
320 create table t1 as select concat(cast(1/2 as decimal(5,5))) as c1;
321 show create table t1;
325 create table t1 as select concat(cast('2001-01-02 03:04:05' as date)) as c1;
326 show create table t1;
331 create table t1 as select concat(cast('2001-01-02 03:04:05' as time)) as c1;
332 show create table t1;
337 create table t1 as select concat(cast('2001-01-02' as datetime)) as c1;
338 show create table t1;
347 create table t1 as select concat(least(1,2)) as c1;
348 show create table t1;
352 create table t1 as select concat(greatest(1,2)) as c1;
353 show create table t1;
361 create table t1 as select concat(case when 11 then 22 else 33 end) as c1;
362 show create table t1;
370 create table t1 as select concat(coalesce(1,2)) as c1;
371 show create table t1;
379 create table t1 as select concat_ws(1,2,3) as c1;
380 show create table t1;
384 create table t1 as select group_concat(1,2,3) as c1;
385 show create table t1;
391 create table t1 as select 1 as c1 union select 'a';
392 show create table t1;
401 create table t1 as select concat(last_insert_id()) as c1;
402 show create table t1;
406 create table t1 as select concat(benchmark(0,0)) as c1;
407 show create table t1;
411 create table t1 as select concat(sleep(0)) as c1;
412 show create table t1;
418 #create table t1 as select concat(get_lock('a',0)) as c1;
419 #show create table t1;
423 create table t1 as select concat(is_free_lock('xxxx')) as c1;
424 show create table t1;
427 create table t1 as select concat(is_used_lock('a')) as c1;
428 show create table t1;
431 create table t1 as select concat(release_lock('a')) as c1;
432 show create table t1;
436 create table t1 as select concat(crc32('')) as c1;
437 show create table t1;
441 create table t1 as select concat(uncompressed_length('')) as c1;
442 show create table t1;
445 create table t1 as select concat(connection_id()) as c1;
446 show create table t1;
450 create table t1 as select concat(inet_aton('127.1.1.1')) as c1;
451 show create table t1;
455 create table t1 as select concat(inet_ntoa(2130772225)) as c1;
457 show create table t1;
463 create table t1 as select concat(row_count()) as c1;
464 show create table t1;
468 create table t1 as select concat(found_rows()) as c1;
469 show create table t1;
472 create table t1 as select concat(uuid_short()) as c1;
473 show create table t1;
476 create table t1 as select concat(uuid()) as c1;
477 show create table t1;
487 create table t1 as select concat(uuid(), cast('a' as char character set latin1)) as c1;
488 show create table t1;
491 create table t1 as select concat(master_pos_wait('non-existent',0,2)) as c1;
492 show create table t1;
502 create table t1 as select concat(@a2:=2) as c1, @a3:=3 as c2;
504 show create table t1;
509 create table t1 as select concat(@a2) as c1, @a2 as c2;
511 show create table t1;
516 create table t1 as select concat(@a2:=sqrt(1)) as c1, @a3:=sqrt(1) as c2;
518 show create table t1;
523 create table t1 as select concat(@a2) as c1, @a2 as c2;
525 show create table t1;
530 create table t1 as select concat(@a2:=1.1) as c1, @a3:=1.1 as c2;
532 show create table t1;
537 create table t1 as select concat(@a2) as c1, @a2 as c2;
539 show create table t1;
544 create table t1 as select concat(@@ft_max_word_len) as c1;
546 show create table t1;
554 create table t1 as select concat('a'='a' IS TRUE) as c1;
555 show create table t1;
559 create table t1 as select concat('a'='a' IS NOT TRUE) as c1;
560 show create table t1;
564 create table t1 as select concat(NOT 'a'='a') as c1;
565 show create table t1;
569 create table t1 as select concat('a' IS NULL) as c1;
570 show create table t1;
574 create table t1 as select concat('a' IS NOT NULL) as c1;
575 show create table t1;
579 create table t1 as select concat('a' IS NOT NULL) as c1;
580 show create table t1;
584 create table t1 as select concat(strcmp('a','b')) as c1;
585 show create table t1;
589 create table t1 as select concat('a' like 'b') as c1;
590 show create table t1;
594 create table t1 as select concat('a' between 'b' and 'c') as c1;
595 show create table t1;
599 create table t1 as select concat('a' in ('a','b')) as c1;
600 show create table t1;
604 create table t1 as select concat(interval(23, 1, 15, 17, 30, 44, 200)) as c1;
605 show create table t1;
608 create table t1 (a varchar(10), fulltext key(a));
611 create table t2 as select concat(match (a) against ('a')) as a from t1;
612 show create table t2;
616 create table t1 as select ifnull(1,'a') as c1;
617 show create table t1;
621 create table t1 as select concat(ifnull(1,1)) as c1;
622 show create table t1;
626 create table t1 as select concat(ifnull(1.1,1.1)) as c1;
627 show create table t1;
631 create table t1 as select if(1,'b',1) as c1;
632 show create table t1;
636 create table t1 as select if(1,1,'b') as c1;
637 show create table t1;
641 create table t1 as select concat(if(1,1,1)) as c1;
642 show create table t1;
646 create table t1 as select concat(nullif(1,2)) as c1;
647 show create table t1;
655 create table t1 as select concat(Dimension(GeomFromText('LINSTRING(0 0,10 10)'))) as c1;
656 show create table t1;
660 create table t1 as select concat(NumGeometries(MultiPointFromText('MULTIPOINT(0 0,10 10)'))) as c1;
661 show create table t1;
665 create table t1 as select concat(NumPoints(MultiPointFromText('LINESTRING(0 0,10 10)'))) as c1;
666 show create table t1;
670 create table t1 as select concat(SRID(MultiPointFromText('MULTIPOINT(0 0,10 10)'))) as c1;
671 show create table t1;
675 create table t1 as select concat(NumInteriorRings(PolygonFromText('POLYGON((0 0,50 0,50 50,0 50,0 0…
676 show create table t1;
680 create table t1 as select concat(IsEmpty(GeomFromText('Point(1 1)'))) as c1;
681 show create table t1;
685 create table t1 as select concat(IsSimple(GeomFromText('Point(1 1)'))) as c1;
686 show create table t1;
690 create table t1 as select concat(IsClosed(GeomFromText('LineString(1 1,2 2)'))) as c1;
691 show create table t1;
695 create table t1 as select concat(Equals(GeomFromText('Point(1 1)'),GeomFromText('Point(1 1)'))) as …
699 create table t1 as select concat(x(GeomFromText('Point(1 2)'))) as c1;
700 show create table t1;
704 create table t1 as select concat(x(GeomFromText('Point(1 2)'))) as c1;
705 show create table t1;
709 create table t1 as select concat(GLength(GeomFromText('LineString(1 2, 2 2)'))) as c1;
710 show create table t1;
714 create table t1 as select concat(Area(GeomFromText('Polygon((0 0,1 0,1 1,0 1,0 0))'))) as c1;
715 show create table t1;
719 create table t1 as select concat(GeometryType(GeomFromText('Point(1 2)'))) as c1;
720 show create table t1;
724 create table t1 as select concat(AsText(GeomFromText('Point(1 2)'))) as c1;
725 show create table t1;
735 create table t1 as select concat(period_add(200902, 2)) as c1;
736 show create table t1;
740 create table t1 as select concat(period_add(200902, 200802)) as c1;
741 show create table t1;
745 create table t1 as select concat(to_days(20090224)) as c1;
746 show create table t1;
750 create table t1 as select concat(dayofmonth(20090224)) as c1;
751 show create table t1;
755 create table t1 as select concat(dayofyear(20090224)) as c1;
756 show create table t1;
760 create table t1 as select concat(hour('10:11:12')) as c1;
761 show create table t1;
765 create table t1 as select concat(minute('10:11:12')) as c1;
766 show create table t1;
770 create table t1 as select concat(second('10:11:12')) as c1;
771 show create table t1;
775 create table t1 as select concat(quarter(20090224)) as c1;
776 show create table t1;
780 create table t1 as select concat(week(20090224)) as c1;
781 show create table t1;
785 create table t1 as select concat(yearweek(20090224)) as c1;
786 show create table t1;
790 create table t1 as select concat(year(20090224)) as c1;
791 show create table t1;
795 create table t1 as select concat(weekday(20090224)) as c1;
796 show create table t1;
800 create table t1 as select concat(dayofweek(20090224)) as c1;
801 show create table t1;
805 create table t1 as select concat(unix_timestamp(20090224)) as c1;
806 show create table t1;
810 create table t1 as select concat(time_to_sec('10:11:12')) as c1;
811 show create table t1;
815 create table t1 as select concat(extract(year from 20090702)) as c1;
816 show create table t1;
820 create table t1 as select concat(microsecond('12:00:00.123456')) as c1;
821 show create table t1;
825 create table t1 as select concat(month(20090224)) as c1;
826 show create table t1;
830 create table t1 as select concat(last_day('2003-02-05')) as c1;
831 show create table t1;
835 create table t1 as select concat(from_days(730669)) as c1;
836 show create table t1;
840 create table t1 as select concat(curdate()) as c1;
841 show create table t1;
844 create table t1 as select concat(utc_date()) as c1;
845 show create table t1;
848 create table t1 as select concat(curtime()) as c1;
849 show create table t1;
852 create table t1 as select repeat('a',20) as c1 limit 0;
859 create table t1 as select concat(utc_time()) as c1;
860 show create table t1;
864 create table t1 as select concat(sec_to_time(2378)) as c1;
865 show create table t1;
869 create table t1 as select concat(timediff('2001-01-02 00:00:00', '2001-01-01 00:00:00')) as c1;
870 show create table t1;
874 create table t1 as select concat(maketime(10,11,12)) as c1;
875 show create table t1;
879 create table t1 as select get_format(DATE,'USA') as c1;
880 show create table t1;
884 create table t1 as select concat(from_unixtime(1111885200)) as c1;
885 show create table t1;
889 create table t1 as select concat(convert_tz('2004-01-01 12:00:00','+10:00','-6:00')) as c1;
890 show create table t1;
894 create table t1 as select concat(date_add('2004-01-01 12:00:00', interval 1 day)) as c1;
895 show create table t1;
900 create table t1 as select concat(makedate(2009,1)) as c1;
901 show create table t1;
905 create table t1 as select concat(now()) as c1;
906 show create table t1;
909 create table t1 as select concat(utc_timestamp()) as c1;
910 show create table t1;
913 create table t1 as select concat(sysdate()) as c1;
914 show create table t1;
918 create table t1 as select concat(addtime('00:00:00','11:22:33')) as c1;
919 show create table t1;
923 create table t1 as select concat(subtime('23:59:59','11:22:33')) as c1;
924 show create table t1;
932 create table t1 as select elt(1,2,3) as c1;
933 show create table t1;
937 create table t1 as select export_set(1,2,3,4,2) as c1;
938 show create table t1;
942 create table t1 as select insert(1133,3,0,22) as c1;
943 show create table t1;
947 create table t1 as select lcase(123) as c1;
948 show create table t1;
952 create table t1 as select left(123,1) as c1;
953 show create table t1;
957 create table t1 as select lower(123) as c1;
958 show create table t1;
962 create table t1 as select lpad(1,2,0) as c1;
963 show create table t1;
967 create table t1 as select ltrim(1) as c1;
968 show create table t1;
972 create table t1 as select mid(1,1,1) as c1;
973 show create table t1;
977 create table t1 as select repeat(1,2) as c1;
978 show create table t1;
982 create table t1 as select replace(1,1,2) as c1;
983 show create table t1;
987 create table t1 as select reverse(12) as c1;
988 show create table t1;
992 create table t1 as select right(123,1) as c1;
993 show create table t1;
997 create table t1 as select rpad(1,2,0) as c1;
998 show create table t1;
1002 create table t1 as select rtrim(1) as c1;
1003 show create table t1;
1007 create table t1 as select soundex(1) as c1;
1008 show create table t1;
1012 create table t1 as select substring(1,1,1) as c1;
1013 show create table t1;
1017 create table t1 as select trim(1) as c1;
1018 show create table t1;
1022 create table t1 as select ucase(1) as c1;
1023 show create table t1;
1027 create table t1 as select upper(1) as c1;
1028 show create table t1;
1035 create table t1 as select repeat(' ', 64) as a limit 0;
1036 show create table t1;
1047 create table t1 (a tinyint);
1050 create table t2 as select concat(a) from t1;
1051 show create table t2;
1054 create table t1 (a tinyint zerofill);
1059 create table t1 (a tinyint(4) zerofill);
1064 create table t1 (a decimal(10,2));
1067 create table t2 as select concat(a) from t1;
1068 show create table t2;
1071 create table t1 (a smallint);
1074 create table t2 as select concat(a) from t1;
1075 show create table t2;
1078 create table t1 (a smallint zerofill);
1083 create table t1 (a mediumint);
1086 create table t2 as select concat(a) from t1;
1087 show create table t2;
1090 create table t1 (a mediumint zerofill);
1095 create table t1 (a int);
1098 create table t2 as select concat(a) from t1;
1099 show create table t2;
1102 create table t1 (a int zerofill);
1107 create table t1 (a bigint);
1110 create table t2 as select concat(a) from t1;
1111 show create table t2;
1114 create table t1 (a bigint zerofill);
1119 create table t1 (a float);
1123 create table t2 as select concat(a) from t1;
1124 show create table t2;
1127 create table t1 (a float zerofill);
1132 create table t1 (a double);
1136 create table t2 as select concat(a) from t1;
1137 show create table t2;
1140 create table t1 (a double zerofill);
1145 create table t1 (a year(2));
1148 create table t2 as select concat(a) from t1;
1149 show create table t2;
1152 create table t1 (a year);
1155 create table t2 as select concat(a) from t1;
1156 show create table t2;
1159 create table t1 (a bit(64));
1163 create table t2 as select concat(a) from t1;
1164 show create table t2;
1167 create table t1 (a timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
1174 create table t2 as select concat(a) from t1;
1175 show create table t2;
1178 create table t1 (a date);
1182 create table t2 as select concat(a) from t1;
1183 show create table t2;
1186 create table t1 (a time);
1191 create table t2 as select concat(a) from t1;
1192 show create table t2;
1195 create table t1 (a datetime);
1199 create table t2 as select concat(a) from t1;
1200 show create table t2;
1205 # create view with string functions with numeric input
1210 create view v1 as select concat(1,2,3) as c1;
1215 create view v1 as select concat_ws(',',1,2,3) as c1;
1220 create view v1 as select elt(1,2,3) as c1;
1225 create view v1 as select export_set(1,2,3,4,2) as c1;
1230 create view v1 as select insert(1133,3,0,22) as c1;
1235 create view v1 as select lcase(123) as c1;
1240 create view v1 as select left(123,1) as c1;
1245 create view v1 as select lower(123) as c1;
1250 create view v1 as select lpad(1,2,0) as c1;
1255 create view v1 as select ltrim(1) as c1;
1260 create view v1 as select mid(1,1,1) as c1;
1265 create view v1 as select repeat(1,2) as c1;
1270 create view v1 as select replace(1,1,2) as c1;
1275 create view v1 as select reverse(12) as c1;
1280 create view v1 as select right(123,1) as c1;
1285 create view v1 as select rpad(1,2,0) as c1;
1290 create view v1 as select rtrim(1) as c1;
1295 create view v1 as select soundex(1) as c1;
1300 create view v1 as select substring(1,1,1) as c1;
1305 create view v1 as select trim(1) as c1;
1310 create view v1 as select ucase(1) as c1;
1315 create view v1 as select upper(1) as c1;
1325 create table t1 (a tinyint);
1327 create view v1(a) as select concat(a) from t1;
1333 create table t1 (a tinyint zerofill);
1335 create view v1(a) as select concat(a) from t1;
1341 create table t1 (a tinyint(30) zerofill);
1343 create view v1(a) as select concat(a) from t1;
1349 create table t1 (a decimal(10,2));
1351 create view v1(a) as select concat(a) from t1;
1357 create table t1 (a smallint);
1359 create view v1(a) as select concat(a) from t1;
1365 create table t1 (a smallint zerofill);
1367 create view v1(a) as select concat(a) from t1;
1373 create table t1 (a mediumint);
1375 create view v1(a) as select concat(a) from t1;
1381 create table t1 (a mediumint zerofill);
1383 create view v1(a) as select concat(a) from t1;
1389 create table t1 (a int);
1391 create view v1(a) as select concat(a) from t1;
1397 create table t1 (a int zerofill);
1399 create view v1(a) as select concat(a) from t1;
1405 create table t1 (a bigint);
1407 create view v1(a) as select concat(a) from t1;
1413 create table t1 (a bigint zerofill);
1415 create view v1(a) as select concat(a) from t1;
1421 create table t1 (a float);
1423 create view v1(a) as select concat(a) from t1;
1429 create table t1 (a float zerofill);
1431 create view v1(a) as select concat(a) from t1;
1437 create table t1 (a double);
1440 create view v1(a) as select concat(a) from t1;
1446 create table t1 (a double zerofill);
1448 create view v1(a) as select concat(a) from t1;
1454 create table t1 (a year(2));
1456 create view v1(a) as select concat(a) from t1;
1462 create table t1 (a year);
1464 create view v1(a) as select concat(a) from t1;
1470 create table t1 (a bit(64));
1473 create view v1(a) as select concat(a) from t1;
1479 create table t1 (a timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
1484 create view v1(a) as select concat(a) from t1;
1490 create table t1 (a date);
1493 create view v1(a) as select concat(a) from t1;
1499 create table t1 (a time);
1502 create view v1(a) as select concat(a) from t1;
1508 create table t1 (a datetime);
1511 create view v1(a) as select concat(a) from t1;
1521 create function f1 (par1 int) returns int
1530 create table t1 as select f1(1) as c1;
1531 show create table t1;
1533 create table t1 as select concat(f1(1)) as c1;
1534 show create table t1;
1535 create view v1 as select concat(f1(1)) as c1;
1542 create function f1 (par1 decimal(18,2)) returns decimal(18,2)
1551 create table t1 as select f1(123.45) as c1;
1552 show create table t1;
1554 create table t1 as select concat(f1(123.45)) as c1;
1555 show create table t1;
1556 create view v1 as select concat(f1(123.45)) as c1;
1563 create function f1 (par1 float) returns float
1572 create table t1 as select f1(123.45) as c1;
1573 show create table t1;
1575 create table t1 as select concat(f1(123.45)) as c1;
1576 show create table t1;
1577 create view v1 as select concat(f1(123.45)) as c1;
1584 create function f1 (par1 date) returns date
1593 create table t1 as select f1(cast('2001-01-02' as date)) as c1;
1594 show create table t1;
1596 create table t1 as select concat(f1(cast('2001-01-02' as date))) as c1;
1597 show create table t1;
1598 create view v1 as select concat(f1(cast('2001-01-02' as date))) as c1;
1633 # is in use, which will create instances of Item_copy.