324
324
CREATE TABLE t11 (f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
326
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t1;
327
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t2;
328
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t4;
329
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t10;
330
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t11;
326
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t1;
327
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t2;
328
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t4;
329
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t10;
330
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t11;
331
331
drop TABLE if exists t3;
332
332
CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) ENGINE = MEMORY;
333
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t3.txt' INTO TABLE t3;
333
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t3.txt' INTO TABLE t3;
334
334
drop database if exists test4;
335
335
CREATE database test4;
337
337
CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int)
339
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' INTO TABLE t6;
339
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' INTO TABLE t6;
341
341
drop TABLE if exists t7, t8;
342
342
CREATE TABLE t7 (f1 char(20),f2 char(25),f3 date,f4 int) ENGINE = MEMORY;
343
343
CREATE TABLE t8 (f1 char(20),f2 char(25),f3 date,f4 int) ENGINE = MEMORY;
344
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t7.txt' INTO TABLE t7;
344
LOAD DATA INFILE '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' INTO TABLE t7;
346
346
Warning 1265 Data truncated for column 'f3' at row 1
347
347
Warning 1265 Data truncated for column 'f3' at row 2
491
491
NULL test tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references
492
492
NULL test tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references
493
493
NULL test tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references
494
NULL test tb2 f74 16 NULL YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
495
NULL test tb2 f75 17 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
496
NULL test tb2 f76 18 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
494
NULL test tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
495
NULL test tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
496
NULL test tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
497
497
NULL test tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references
498
NULL test tb2 f78 20 7.7 YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
499
NULL test tb2 f79 21 00000000000000000007.7 YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
500
NULL test tb2 f80 22 00000000000000000008.8 YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
498
NULL test tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
499
NULL test tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
500
NULL test tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
501
501
NULL test tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references
502
NULL test tb2 f82 24 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
503
NULL test tb2 f83 25 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
504
NULL test tb2 f84 26 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
502
NULL test tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
503
NULL test tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
504
NULL test tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
505
505
NULL test tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references
506
506
NULL test tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references
507
NULL test tb2 f87 29 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
508
NULL test tb2 f88 30 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
509
NULL test tb2 f89 31 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
510
NULL test tb2 f90 32 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
511
NULL test tb2 f91 33 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
512
NULL test tb2 f92 34 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
507
NULL test tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
508
NULL test tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
509
NULL test tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
510
NULL test tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
511
NULL test tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
512
NULL test tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
513
513
NULL test tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references
514
514
NULL test tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references
515
NULL test tb2 f95 37 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
516
NULL test tb2 f96 38 8.8 NO double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
517
NULL test tb2 f97 39 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
518
NULL test tb2 f98 40 00000000000000000008.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
519
NULL test tb2 f99 41 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
515
NULL test tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
516
NULL test tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
517
NULL test tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
518
NULL test tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
519
NULL test tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
520
520
NULL test tb3 f118 1 a NO char 1 1 NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references
521
521
NULL test tb3 f119 2 NO char 1 1 NULL NULL latin1 latin1_bin char(1) select,insert,update,references
522
522
NULL test tb3 f120 3 NO char 1 1 NULL NULL latin1 latin1_swedish_ci char(1) select,insert,update,references
584
584
NULL test tb4 f188 13 0000000009 NO decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references
585
585
NULL test tb4 f189 14 000000000000000000000000000000009.000000000000000000000000000000 NO decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references
586
586
NULL test tb4 f190 15 88.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references
587
NULL test tb4 f191 16 88.8 NO double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
588
NULL test tb4 f192 17 00000000000000000088.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
589
NULL test tb4 f193 18 00000000000000000088.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
587
NULL test tb4 f191 16 88.8 NO double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
588
NULL test tb4 f192 17 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
589
NULL test tb4 f193 18 00000000000000000088.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
590
590
NULL test tb4 f194 19 55.5 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references
591
NULL test tb4 f195 20 55.5 NO double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
592
NULL test tb4 f196 21 00000000000000000055.5 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
593
NULL test tb4 f197 22 00000000000000000055.5 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
591
NULL test tb4 f195 20 55.5 NO double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
592
NULL test tb4 f196 21 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
593
NULL test tb4 f197 22 00000000000000000055.5 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
594
594
NULL test tb4 f198 23 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references
595
NULL test tb4 f199 24 NULL YES float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
596
NULL test tb4 f200 25 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
597
NULL test tb4 f201 26 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
595
NULL test tb4 f199 24 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
596
NULL test tb4 f200 25 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
597
NULL test tb4 f201 26 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
598
598
NULL test tb4 f202 27 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references
599
599
NULL test tb4 f203 28 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references
600
NULL test tb4 f204 29 NULL YES float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
601
NULL test tb4 f205 30 NULL YES float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
602
NULL test tb4 f206 31 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
603
NULL test tb4 f207 32 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
604
NULL test tb4 f208 33 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
605
NULL test tb4 f209 34 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
600
NULL test tb4 f204 29 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
601
NULL test tb4 f205 30 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
602
NULL test tb4 f206 31 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
603
NULL test tb4 f207 32 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
604
NULL test tb4 f208 33 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
605
NULL test tb4 f209 34 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
606
606
NULL test tb4 f210 35 NULL YES float NULL NULL 12 NULL NULL NULL float select,insert,update,references
607
607
NULL test tb4 f211 36 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references
608
NULL test tb4 f212 37 NULL YES float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
609
NULL test tb4 f213 38 NULL YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
610
NULL test tb4 f214 39 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
611
NULL test tb4 f215 40 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
612
NULL test tb4 f216 41 NULL YES float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
613
NULL test tb4 f217 42 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
608
NULL test tb4 f212 37 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
609
NULL test tb4 f213 38 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
610
NULL test tb4 f214 39 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
611
NULL test tb4 f215 40 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
612
NULL test tb4 f216 41 NULL YES float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
613
NULL test tb4 f217 42 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
614
614
NULL test tb4 f218 43 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references
615
615
NULL test tb4 f219 44 NULL YES time NULL NULL NULL NULL NULL NULL time select,insert,update,references
616
616
NULL test tb4 f220 45 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime select,insert,update,references
651
651
NULL test1 tb2 f71 13 NULL YES decimal NULL NULL 10 0 NULL NULL decimal(10,0) unsigned zerofill select,insert,update,references
652
652
NULL test1 tb2 f72 14 NULL YES decimal NULL NULL 63 30 NULL NULL decimal(63,30) unsigned zerofill select,insert,update,references
653
653
NULL test1 tb2 f73 15 NULL YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references
654
NULL test1 tb2 f74 16 NULL YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
655
NULL test1 tb2 f75 17 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
656
NULL test1 tb2 f76 18 NULL YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
654
NULL test1 tb2 f74 16 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
655
NULL test1 tb2 f75 17 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
656
NULL test1 tb2 f76 18 NULL YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
657
657
NULL test1 tb2 f77 19 7.7 YES double NULL NULL 22 NULL NULL NULL double select,insert,update,references
658
NULL test1 tb2 f78 20 7.7 YES double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
659
NULL test1 tb2 f79 21 00000000000000000007.7 YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
660
NULL test1 tb2 f80 22 00000000000000000008.8 YES double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
658
NULL test1 tb2 f78 20 7.7 YES double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
659
NULL test1 tb2 f79 21 00000000000000000007.7 YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
660
NULL test1 tb2 f80 22 00000000000000000008.8 YES double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
661
661
NULL test1 tb2 f81 23 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references
662
NULL test1 tb2 f82 24 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
663
NULL test1 tb2 f83 25 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
664
NULL test1 tb2 f84 26 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
662
NULL test1 tb2 f82 24 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
663
NULL test1 tb2 f83 25 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
664
NULL test1 tb2 f84 26 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
665
665
NULL test1 tb2 f85 27 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references
666
666
NULL test1 tb2 f86 28 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references
667
NULL test1 tb2 f87 29 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
668
NULL test1 tb2 f88 30 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
669
NULL test1 tb2 f89 31 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
670
NULL test1 tb2 f90 32 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
671
NULL test1 tb2 f91 33 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
672
NULL test1 tb2 f92 34 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
667
NULL test1 tb2 f87 29 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
668
NULL test1 tb2 f88 30 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
669
NULL test1 tb2 f89 31 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
670
NULL test1 tb2 f90 32 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
671
NULL test1 tb2 f91 33 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
672
NULL test1 tb2 f92 34 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
673
673
NULL test1 tb2 f93 35 8.8 NO float NULL NULL 12 NULL NULL NULL float select,insert,update,references
674
674
NULL test1 tb2 f94 36 8.8 NO double NULL NULL 22 NULL NULL NULL double select,insert,update,references
675
NULL test1 tb2 f95 37 8.8 NO float unsigned NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
676
NULL test1 tb2 f96 38 8.8 NO double unsigned NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
677
NULL test1 tb2 f97 39 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
678
NULL test1 tb2 f98 40 00000000000000000008.8 NO double unsigned zerofill NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
679
NULL test1 tb2 f99 41 0000000008.8 NO float unsigned zerofill NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
675
NULL test1 tb2 f95 37 8.8 NO float NULL NULL 12 NULL NULL NULL float unsigned select,insert,update,references
676
NULL test1 tb2 f96 38 8.8 NO double NULL NULL 22 NULL NULL NULL double unsigned select,insert,update,references
677
NULL test1 tb2 f97 39 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
678
NULL test1 tb2 f98 40 00000000000000000008.8 NO double NULL NULL 22 NULL NULL NULL double unsigned zerofill select,insert,update,references
679
NULL test1 tb2 f99 41 0000000008.8 NO float NULL NULL 12 NULL NULL NULL float unsigned zerofill select,insert,update,references
680
680
NULL test4 t6 f1 1 NULL YES char 20 20 NULL NULL latin1 latin1_swedish_ci char(20) select,insert,update,references
681
681
NULL test4 t6 f2 2 NULL YES char 25 25 NULL NULL latin1 latin1_swedish_ci char(25) select,insert,update,references
682
682
NULL test4 t6 f3 3 NULL YES date NULL NULL NULL NULL NULL NULL date select,insert,update,references
866
862
NULL test tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
867
863
NULL test tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
868
864
NULL test tb2 f73 double NULL NULL NULL NULL double
869
NULL test tb2 f74 double unsigned NULL NULL NULL NULL double unsigned
870
NULL test tb2 f75 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
871
NULL test tb2 f76 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
865
NULL test tb2 f74 double NULL NULL NULL NULL double unsigned
866
NULL test tb2 f75 double NULL NULL NULL NULL double unsigned zerofill
867
NULL test tb2 f76 double NULL NULL NULL NULL double unsigned zerofill
872
868
NULL test tb2 f77 double NULL NULL NULL NULL double
873
NULL test tb2 f78 double unsigned NULL NULL NULL NULL double unsigned
874
NULL test tb2 f79 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
875
NULL test tb2 f80 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
869
NULL test tb2 f78 double NULL NULL NULL NULL double unsigned
870
NULL test tb2 f79 double NULL NULL NULL NULL double unsigned zerofill
871
NULL test tb2 f80 double NULL NULL NULL NULL double unsigned zerofill
876
872
NULL test tb2 f81 float NULL NULL NULL NULL float
877
NULL test tb2 f82 float unsigned NULL NULL NULL NULL float unsigned
878
NULL test tb2 f83 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
879
NULL test tb2 f84 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
873
NULL test tb2 f82 float NULL NULL NULL NULL float unsigned
874
NULL test tb2 f83 float NULL NULL NULL NULL float unsigned zerofill
875
NULL test tb2 f84 float NULL NULL NULL NULL float unsigned zerofill
880
876
NULL test tb2 f85 float NULL NULL NULL NULL float
881
877
NULL test tb2 f86 float NULL NULL NULL NULL float
882
NULL test tb2 f87 float unsigned NULL NULL NULL NULL float unsigned
883
NULL test tb2 f88 float unsigned NULL NULL NULL NULL float unsigned
884
NULL test tb2 f89 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
885
NULL test tb2 f90 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
886
NULL test tb2 f91 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
887
NULL test tb2 f92 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
878
NULL test tb2 f87 float NULL NULL NULL NULL float unsigned
879
NULL test tb2 f88 float NULL NULL NULL NULL float unsigned
880
NULL test tb2 f89 float NULL NULL NULL NULL float unsigned zerofill
881
NULL test tb2 f90 float NULL NULL NULL NULL float unsigned zerofill
882
NULL test tb2 f91 float NULL NULL NULL NULL float unsigned zerofill
883
NULL test tb2 f92 float NULL NULL NULL NULL float unsigned zerofill
888
884
NULL test tb2 f93 float NULL NULL NULL NULL float
889
885
NULL test tb2 f94 double NULL NULL NULL NULL double
890
NULL test tb2 f95 float unsigned NULL NULL NULL NULL float unsigned
891
NULL test tb2 f96 double unsigned NULL NULL NULL NULL double unsigned
892
NULL test tb2 f97 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
893
NULL test tb2 f98 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
894
NULL test tb2 f99 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
895
NULL test tb2 f100 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
886
NULL test tb2 f95 float NULL NULL NULL NULL float unsigned
887
NULL test tb2 f96 double NULL NULL NULL NULL double unsigned
888
NULL test tb2 f97 float NULL NULL NULL NULL float unsigned zerofill
889
NULL test tb2 f98 double NULL NULL NULL NULL double unsigned zerofill
890
NULL test tb2 f99 float NULL NULL NULL NULL float unsigned zerofill
891
NULL test tb2 f100 double NULL NULL NULL NULL double unsigned zerofill
896
892
NULL test tb2 f101 date NULL NULL NULL NULL date
897
893
NULL test tb2 f102 time NULL NULL NULL NULL time
898
894
NULL test tb2 f103 datetime NULL NULL NULL NULL datetime
969
965
NULL test tb4 f188 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
970
966
NULL test tb4 f189 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
971
967
NULL test tb4 f190 double NULL NULL NULL NULL double
972
NULL test tb4 f191 double unsigned NULL NULL NULL NULL double unsigned
973
NULL test tb4 f192 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
974
NULL test tb4 f193 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
968
NULL test tb4 f191 double NULL NULL NULL NULL double unsigned
969
NULL test tb4 f192 double NULL NULL NULL NULL double unsigned zerofill
970
NULL test tb4 f193 double NULL NULL NULL NULL double unsigned zerofill
975
971
NULL test tb4 f194 double NULL NULL NULL NULL double
976
NULL test tb4 f195 double unsigned NULL NULL NULL NULL double unsigned
977
NULL test tb4 f196 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
978
NULL test tb4 f197 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
972
NULL test tb4 f195 double NULL NULL NULL NULL double unsigned
973
NULL test tb4 f196 double NULL NULL NULL NULL double unsigned zerofill
974
NULL test tb4 f197 double NULL NULL NULL NULL double unsigned zerofill
979
975
NULL test tb4 f198 float NULL NULL NULL NULL float
980
NULL test tb4 f199 float unsigned NULL NULL NULL NULL float unsigned
981
NULL test tb4 f200 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
982
NULL test tb4 f201 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
976
NULL test tb4 f199 float NULL NULL NULL NULL float unsigned
977
NULL test tb4 f200 float NULL NULL NULL NULL float unsigned zerofill
978
NULL test tb4 f201 float NULL NULL NULL NULL float unsigned zerofill
983
979
NULL test tb4 f202 float NULL NULL NULL NULL float
984
980
NULL test tb4 f203 float NULL NULL NULL NULL float
985
NULL test tb4 f204 float unsigned NULL NULL NULL NULL float unsigned
986
NULL test tb4 f205 float unsigned NULL NULL NULL NULL float unsigned
987
NULL test tb4 f206 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
988
NULL test tb4 f207 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
989
NULL test tb4 f208 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
990
NULL test tb4 f209 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
981
NULL test tb4 f204 float NULL NULL NULL NULL float unsigned
982
NULL test tb4 f205 float NULL NULL NULL NULL float unsigned
983
NULL test tb4 f206 float NULL NULL NULL NULL float unsigned zerofill
984
NULL test tb4 f207 float NULL NULL NULL NULL float unsigned zerofill
985
NULL test tb4 f208 float NULL NULL NULL NULL float unsigned zerofill
986
NULL test tb4 f209 float NULL NULL NULL NULL float unsigned zerofill
991
987
NULL test tb4 f210 float NULL NULL NULL NULL float
992
988
NULL test tb4 f211 double NULL NULL NULL NULL double
993
NULL test tb4 f212 float unsigned NULL NULL NULL NULL float unsigned
994
NULL test tb4 f213 double unsigned NULL NULL NULL NULL double unsigned
995
NULL test tb4 f214 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
996
NULL test tb4 f215 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
997
NULL test tb4 f216 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
998
NULL test tb4 f217 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
989
NULL test tb4 f212 float NULL NULL NULL NULL float unsigned
990
NULL test tb4 f213 double NULL NULL NULL NULL double unsigned
991
NULL test tb4 f214 float NULL NULL NULL NULL float unsigned zerofill
992
NULL test tb4 f215 double NULL NULL NULL NULL double unsigned zerofill
993
NULL test tb4 f216 float NULL NULL NULL NULL float unsigned zerofill
994
NULL test tb4 f217 double NULL NULL NULL NULL double unsigned zerofill
999
995
NULL test tb4 f218 date NULL NULL NULL NULL date
1000
996
NULL test tb4 f219 time NULL NULL NULL NULL time
1001
997
NULL test tb4 f220 datetime NULL NULL NULL NULL datetime
1026
1022
NULL test1 tb2 f71 decimal NULL NULL NULL NULL decimal(10,0) unsigned zerofill
1027
1023
NULL test1 tb2 f72 decimal NULL NULL NULL NULL decimal(63,30) unsigned zerofill
1028
1024
NULL test1 tb2 f73 double NULL NULL NULL NULL double
1029
NULL test1 tb2 f74 double unsigned NULL NULL NULL NULL double unsigned
1030
NULL test1 tb2 f75 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1031
NULL test1 tb2 f76 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1025
NULL test1 tb2 f74 double NULL NULL NULL NULL double unsigned
1026
NULL test1 tb2 f75 double NULL NULL NULL NULL double unsigned zerofill
1027
NULL test1 tb2 f76 double NULL NULL NULL NULL double unsigned zerofill
1032
1028
NULL test1 tb2 f77 double NULL NULL NULL NULL double
1033
NULL test1 tb2 f78 double unsigned NULL NULL NULL NULL double unsigned
1034
NULL test1 tb2 f79 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1035
NULL test1 tb2 f80 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1029
NULL test1 tb2 f78 double NULL NULL NULL NULL double unsigned
1030
NULL test1 tb2 f79 double NULL NULL NULL NULL double unsigned zerofill
1031
NULL test1 tb2 f80 double NULL NULL NULL NULL double unsigned zerofill
1036
1032
NULL test1 tb2 f81 float NULL NULL NULL NULL float
1037
NULL test1 tb2 f82 float unsigned NULL NULL NULL NULL float unsigned
1038
NULL test1 tb2 f83 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1039
NULL test1 tb2 f84 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1033
NULL test1 tb2 f82 float NULL NULL NULL NULL float unsigned
1034
NULL test1 tb2 f83 float NULL NULL NULL NULL float unsigned zerofill
1035
NULL test1 tb2 f84 float NULL NULL NULL NULL float unsigned zerofill
1040
1036
NULL test1 tb2 f85 float NULL NULL NULL NULL float
1041
1037
NULL test1 tb2 f86 float NULL NULL NULL NULL float
1042
NULL test1 tb2 f87 float unsigned NULL NULL NULL NULL float unsigned
1043
NULL test1 tb2 f88 float unsigned NULL NULL NULL NULL float unsigned
1044
NULL test1 tb2 f89 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1045
NULL test1 tb2 f90 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1046
NULL test1 tb2 f91 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1047
NULL test1 tb2 f92 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1038
NULL test1 tb2 f87 float NULL NULL NULL NULL float unsigned
1039
NULL test1 tb2 f88 float NULL NULL NULL NULL float unsigned
1040
NULL test1 tb2 f89 float NULL NULL NULL NULL float unsigned zerofill
1041
NULL test1 tb2 f90 float NULL NULL NULL NULL float unsigned zerofill
1042
NULL test1 tb2 f91 float NULL NULL NULL NULL float unsigned zerofill
1043
NULL test1 tb2 f92 float NULL NULL NULL NULL float unsigned zerofill
1048
1044
NULL test1 tb2 f93 float NULL NULL NULL NULL float
1049
1045
NULL test1 tb2 f94 double NULL NULL NULL NULL double
1050
NULL test1 tb2 f95 float unsigned NULL NULL NULL NULL float unsigned
1051
NULL test1 tb2 f96 double unsigned NULL NULL NULL NULL double unsigned
1052
NULL test1 tb2 f97 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1053
NULL test1 tb2 f98 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1054
NULL test1 tb2 f99 float unsigned zerofill NULL NULL NULL NULL float unsigned zerofill
1055
NULL test1 tb2 f100 double unsigned zerofill NULL NULL NULL NULL double unsigned zerofill
1046
NULL test1 tb2 f95 float NULL NULL NULL NULL float unsigned
1047
NULL test1 tb2 f96 double NULL NULL NULL NULL double unsigned
1048
NULL test1 tb2 f97 float NULL NULL NULL NULL float unsigned zerofill
1049
NULL test1 tb2 f98 double NULL NULL NULL NULL double unsigned zerofill
1050
NULL test1 tb2 f99 float NULL NULL NULL NULL float unsigned zerofill
1051
NULL test1 tb2 f100 double NULL NULL NULL NULL double unsigned zerofill
1056
1052
NULL test1 tb2 f101 date NULL NULL NULL NULL date
1057
1053
NULL test1 tb2 f102 time NULL NULL NULL NULL time
1058
1054
NULL test1 tb2 f103 datetime NULL NULL NULL NULL datetime