« back to all changes in this revision
Viewing changes to server/field.cc
- browse files at revision 212.2.1
- compare with another revision
- download diff
- download tarball
- view history from revision 212.2.1
- Committer: Patrick Galbraith
- Date: 2008-07-27 19:30:42 UTC
- mto: (212.1.4 codestyle)
- mto: This revision was merged to the branch mainline in revision 217.
- Revision ID: patg@ishvara-20080727193042-iie3dyo65v0grevw
Renamed all MYSQL_TYPE... to FIELD_TYPE...
It took less time than I thought.
All tests pass.
It took less time than I thought.
All tests pass.
- files modified:
- client/drizzle.c
added
removed
server/field.cc
50
50
following #defines describe that gap and how to canculate number of fields
51
51
and index of field in thia array.
52
52
*/
53
#define FIELDTYPE_TEAR_FROM (MYSQL_TYPE_VARCHAR + 1)
54
#define FIELDTYPE_TEAR_TO (MYSQL_TYPE_NEWDECIMAL - 1)
53
#define FIELDTYPE_TEAR_FROM (FIELD_TYPE_VARCHAR + 1)
54
#define FIELDTYPE_TEAR_TO (FIELD_TYPE_NEWDECIMAL - 1)
55
55
#define FIELDTYPE_NUM (FIELDTYPE_TEAR_FROM + (255 - FIELDTYPE_TEAR_TO))
56
56
inline int field_type2index (enum_field_types field_type)
57
57
{
63
63
64
64
static enum_field_types field_types_merge_rules [FIELDTYPE_NUM][FIELDTYPE_NUM]=
65
65
{
66
/* MYSQL_TYPE_DECIMAL -> */
67
{
68
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
69
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_NEWDECIMAL,
70
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
71
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_NEWDECIMAL,
72
//MYSQL_TYPE_DOUBLE
73
MYSQL_TYPE_DOUBLE,
74
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
75
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
76
//MYSQL_TYPE_LONGLONG
77
MYSQL_TYPE_NEWDECIMAL,
78
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
79
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
80
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
81
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
82
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
83
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
84
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
85
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
86
//MYSQL_TYPE_SET
87
MYSQL_TYPE_VARCHAR,
88
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
89
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
90
//MYSQL_TYPE_STRING
91
MYSQL_TYPE_STRING
92
},
93
/* MYSQL_TYPE_TINY -> */
94
{
95
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
96
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_TINY,
97
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
98
MYSQL_TYPE_SHORT, MYSQL_TYPE_LONG,
99
//MYSQL_TYPE_DOUBLE
100
MYSQL_TYPE_DOUBLE,
101
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
102
MYSQL_TYPE_TINY, MYSQL_TYPE_VARCHAR,
103
//MYSQL_TYPE_LONGLONG
104
MYSQL_TYPE_LONGLONG,
105
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
106
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
107
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
108
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_TINY,
109
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
110
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
111
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
112
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
113
//MYSQL_TYPE_SET
114
MYSQL_TYPE_VARCHAR,
115
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
116
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
117
//MYSQL_TYPE_STRING
118
MYSQL_TYPE_STRING
119
},
120
/* MYSQL_TYPE_SHORT -> */
121
{
122
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
123
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_SHORT,
124
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
125
MYSQL_TYPE_SHORT, MYSQL_TYPE_LONG,
126
//MYSQL_TYPE_DOUBLE
127
MYSQL_TYPE_DOUBLE,
128
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
129
MYSQL_TYPE_SHORT, MYSQL_TYPE_VARCHAR,
130
//MYSQL_TYPE_LONGLONG
131
MYSQL_TYPE_LONGLONG,
132
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
133
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
134
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
135
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_SHORT,
136
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
137
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
138
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
139
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
140
//MYSQL_TYPE_SET
141
MYSQL_TYPE_VARCHAR,
142
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
143
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
144
//MYSQL_TYPE_STRING
145
MYSQL_TYPE_STRING
146
},
147
/* MYSQL_TYPE_LONG -> */
148
{
149
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
150
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_LONG,
151
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
152
MYSQL_TYPE_LONG, MYSQL_TYPE_LONG,
153
//MYSQL_TYPE_DOUBLE
154
MYSQL_TYPE_DOUBLE,
155
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
156
MYSQL_TYPE_LONG, MYSQL_TYPE_VARCHAR,
157
//MYSQL_TYPE_LONGLONG
158
MYSQL_TYPE_LONGLONG,
159
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
160
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
161
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
162
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_LONG,
163
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
164
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
165
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
166
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
167
//MYSQL_TYPE_SET
168
MYSQL_TYPE_VARCHAR,
169
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
170
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
171
//MYSQL_TYPE_STRING
172
MYSQL_TYPE_STRING
173
},
174
/* MYSQL_TYPE_DOUBLE -> */
175
{
176
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
177
MYSQL_TYPE_DOUBLE, MYSQL_TYPE_DOUBLE,
178
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
179
MYSQL_TYPE_DOUBLE, MYSQL_TYPE_DOUBLE,
180
//MYSQL_TYPE_DOUBLE
181
MYSQL_TYPE_DOUBLE,
182
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
183
MYSQL_TYPE_DOUBLE, MYSQL_TYPE_VARCHAR,
184
//MYSQL_TYPE_LONGLONG
185
MYSQL_TYPE_DOUBLE,
186
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
187
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
188
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
189
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_DOUBLE,
190
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
191
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
192
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
193
MYSQL_TYPE_DOUBLE, MYSQL_TYPE_VARCHAR,
194
//MYSQL_TYPE_SET
195
MYSQL_TYPE_VARCHAR,
196
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
197
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
198
//MYSQL_TYPE_STRING
199
MYSQL_TYPE_STRING
200
},
201
/* MYSQL_TYPE_NULL -> */
202
{
203
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
204
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_TINY,
205
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
206
MYSQL_TYPE_SHORT, MYSQL_TYPE_LONG,
207
//MYSQL_TYPE_DOUBLE
208
MYSQL_TYPE_DOUBLE,
209
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
210
MYSQL_TYPE_NULL, MYSQL_TYPE_TIMESTAMP,
211
//MYSQL_TYPE_LONGLONG
212
MYSQL_TYPE_LONGLONG,
213
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
214
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_TIME,
215
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
216
MYSQL_TYPE_DATETIME, MYSQL_TYPE_YEAR,
217
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
218
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_VARCHAR,
219
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
220
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_ENUM,
221
//MYSQL_TYPE_SET
222
MYSQL_TYPE_SET,
223
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
224
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
225
//MYSQL_TYPE_STRING
226
MYSQL_TYPE_STRING
227
},
228
/* MYSQL_TYPE_TIMESTAMP -> */
229
{
230
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
231
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
232
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
233
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
234
//MYSQL_TYPE_DOUBLE
235
MYSQL_TYPE_VARCHAR,
236
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
237
MYSQL_TYPE_TIMESTAMP, MYSQL_TYPE_TIMESTAMP,
238
//MYSQL_TYPE_LONGLONG
239
MYSQL_TYPE_VARCHAR,
240
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
241
MYSQL_TYPE_DATETIME, MYSQL_TYPE_DATETIME,
242
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
243
MYSQL_TYPE_DATETIME, MYSQL_TYPE_VARCHAR,
244
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
245
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_VARCHAR,
246
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
247
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
248
//MYSQL_TYPE_SET
249
MYSQL_TYPE_VARCHAR,
250
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
251
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
252
//MYSQL_TYPE_STRING
253
MYSQL_TYPE_STRING
254
},
255
/* MYSQL_TYPE_LONGLONG -> */
256
{
257
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
258
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_LONGLONG,
259
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
260
MYSQL_TYPE_LONGLONG, MYSQL_TYPE_LONGLONG,
261
//MYSQL_TYPE_DOUBLE
262
MYSQL_TYPE_DOUBLE,
263
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
264
MYSQL_TYPE_LONGLONG, MYSQL_TYPE_VARCHAR,
265
//MYSQL_TYPE_LONGLONG
266
MYSQL_TYPE_LONGLONG,
267
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
268
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
269
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
270
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_LONGLONG,
271
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
272
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_VARCHAR,
273
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
274
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
275
//MYSQL_TYPE_SET
276
MYSQL_TYPE_VARCHAR,
277
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
278
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
279
//MYSQL_TYPE_STRING
280
MYSQL_TYPE_STRING
281
},
282
/* MYSQL_TYPE_DATE -> */
283
{
284
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
285
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
286
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
287
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
288
//MYSQL_TYPE_DOUBLE
289
MYSQL_TYPE_VARCHAR,
290
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
291
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_DATETIME,
292
//MYSQL_TYPE_LONGLONG
293
MYSQL_TYPE_VARCHAR,
294
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
295
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_DATETIME,
296
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
297
MYSQL_TYPE_DATETIME, MYSQL_TYPE_VARCHAR,
298
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
299
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_VARCHAR,
300
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
301
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
302
//MYSQL_TYPE_SET
303
MYSQL_TYPE_VARCHAR,
304
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
305
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
306
//MYSQL_TYPE_STRING
307
MYSQL_TYPE_STRING
308
},
309
/* MYSQL_TYPE_TIME -> */
310
{
311
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
312
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
313
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
314
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
315
//MYSQL_TYPE_DOUBLE
316
MYSQL_TYPE_VARCHAR,
317
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
318
MYSQL_TYPE_TIME, MYSQL_TYPE_DATETIME,
319
//MYSQL_TYPE_LONGLONG
320
MYSQL_TYPE_VARCHAR,
321
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
322
MYSQL_TYPE_DATETIME, MYSQL_TYPE_TIME,
323
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
324
MYSQL_TYPE_DATETIME, MYSQL_TYPE_VARCHAR,
325
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
326
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_VARCHAR,
327
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
328
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
329
//MYSQL_TYPE_SET
330
MYSQL_TYPE_VARCHAR,
331
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
332
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
333
//MYSQL_TYPE_STRING
334
MYSQL_TYPE_STRING
335
},
336
/* MYSQL_TYPE_DATETIME -> */
337
{
338
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
339
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
340
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
341
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
342
//MYSQL_TYPE_DOUBLE
343
MYSQL_TYPE_VARCHAR,
344
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
345
MYSQL_TYPE_DATETIME, MYSQL_TYPE_DATETIME,
346
//MYSQL_TYPE_LONGLONG
347
MYSQL_TYPE_VARCHAR,
348
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
349
MYSQL_TYPE_DATETIME, MYSQL_TYPE_DATETIME,
350
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
351
MYSQL_TYPE_DATETIME, MYSQL_TYPE_VARCHAR,
352
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
353
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_VARCHAR,
354
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
355
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
356
//MYSQL_TYPE_SET
357
MYSQL_TYPE_VARCHAR,
358
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
359
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
360
//MYSQL_TYPE_STRING
361
MYSQL_TYPE_STRING
362
},
363
/* MYSQL_TYPE_YEAR -> */
364
{
365
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
366
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_TINY,
367
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
368
MYSQL_TYPE_SHORT, MYSQL_TYPE_LONG,
369
//MYSQL_TYPE_DOUBLE
370
MYSQL_TYPE_DOUBLE,
371
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
372
MYSQL_TYPE_YEAR, MYSQL_TYPE_VARCHAR,
373
//MYSQL_TYPE_LONGLONG
374
MYSQL_TYPE_LONGLONG,
375
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
376
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
377
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
378
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_YEAR,
379
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
380
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
381
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
382
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
383
//MYSQL_TYPE_SET
384
MYSQL_TYPE_VARCHAR,
385
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
386
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
387
//MYSQL_TYPE_STRING
388
MYSQL_TYPE_STRING
389
},
390
/* MYSQL_TYPE_NEWDATE -> */
391
{
392
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
393
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
394
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
395
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
396
//MYSQL_TYPE_DOUBLE
397
MYSQL_TYPE_VARCHAR,
398
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
399
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_DATETIME,
400
//MYSQL_TYPE_LONGLONG
401
MYSQL_TYPE_VARCHAR,
402
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
403
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_DATETIME,
404
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
405
MYSQL_TYPE_DATETIME, MYSQL_TYPE_VARCHAR,
406
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
407
MYSQL_TYPE_NEWDATE, MYSQL_TYPE_VARCHAR,
408
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
409
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
410
//MYSQL_TYPE_SET
411
MYSQL_TYPE_VARCHAR,
412
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
413
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
414
//MYSQL_TYPE_STRING
415
MYSQL_TYPE_STRING
416
},
417
/* MYSQL_TYPE_VARCHAR -> */
418
{
419
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
420
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
421
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
422
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
423
//MYSQL_TYPE_DOUBLE
424
MYSQL_TYPE_VARCHAR,
425
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
426
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
427
//MYSQL_TYPE_LONGLONG
428
MYSQL_TYPE_VARCHAR,
429
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
430
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
431
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
432
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
433
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
434
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
435
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
436
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
437
//MYSQL_TYPE_SET
438
MYSQL_TYPE_VARCHAR,
439
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
440
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
441
//MYSQL_TYPE_STRING
442
MYSQL_TYPE_VARCHAR
443
},
444
/* MYSQL_TYPE_NEWDECIMAL -> */
445
{
446
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
447
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_NEWDECIMAL,
448
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
449
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_NEWDECIMAL,
450
//MYSQL_TYPE_DOUBLE
451
MYSQL_TYPE_DOUBLE,
452
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
453
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
454
//MYSQL_TYPE_LONGLONG
455
MYSQL_TYPE_NEWDECIMAL,
456
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
457
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
458
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
459
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_NEWDECIMAL,
460
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
461
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
462
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
463
MYSQL_TYPE_NEWDECIMAL, MYSQL_TYPE_VARCHAR,
464
//MYSQL_TYPE_SET
465
MYSQL_TYPE_VARCHAR,
466
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
467
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
468
//MYSQL_TYPE_STRING
469
MYSQL_TYPE_STRING
470
},
471
/* MYSQL_TYPE_ENUM -> */
472
{
473
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
474
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
475
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
476
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
477
//MYSQL_TYPE_DOUBLE
478
MYSQL_TYPE_VARCHAR,
479
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
480
MYSQL_TYPE_ENUM, MYSQL_TYPE_VARCHAR,
481
//MYSQL_TYPE_LONGLONG
482
MYSQL_TYPE_VARCHAR,
483
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
484
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
485
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
486
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
487
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
488
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
489
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
490
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
491
//MYSQL_TYPE_SET
492
MYSQL_TYPE_VARCHAR,
493
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
494
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
495
//MYSQL_TYPE_STRING
496
MYSQL_TYPE_STRING
497
},
498
/* MYSQL_TYPE_SET -> */
499
{
500
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
501
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
502
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
503
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
504
//MYSQL_TYPE_DOUBLE
505
MYSQL_TYPE_VARCHAR,
506
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
507
MYSQL_TYPE_SET, MYSQL_TYPE_VARCHAR,
508
//MYSQL_TYPE_LONGLONG
509
MYSQL_TYPE_VARCHAR,
510
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
511
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
512
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
513
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
514
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
515
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
516
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
517
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
518
//MYSQL_TYPE_SET
519
MYSQL_TYPE_VARCHAR,
520
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
521
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
522
//MYSQL_TYPE_STRING
523
MYSQL_TYPE_STRING
524
},
525
/* MYSQL_TYPE_BLOB -> */
526
{
527
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
528
MYSQL_TYPE_BLOB, MYSQL_TYPE_BLOB,
529
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
530
MYSQL_TYPE_BLOB, MYSQL_TYPE_BLOB,
531
//MYSQL_TYPE_DOUBLE
532
MYSQL_TYPE_BLOB,
533
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
534
MYSQL_TYPE_BLOB, MYSQL_TYPE_BLOB,
535
//MYSQL_TYPE_LONGLONG
536
MYSQL_TYPE_BLOB,
537
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
538
MYSQL_TYPE_BLOB, MYSQL_TYPE_BLOB,
539
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
540
MYSQL_TYPE_BLOB, MYSQL_TYPE_BLOB,
541
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
542
MYSQL_TYPE_BLOB, MYSQL_TYPE_BLOB,
543
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
544
MYSQL_TYPE_BLOB, MYSQL_TYPE_BLOB,
545
//MYSQL_TYPE_SET
546
MYSQL_TYPE_BLOB,
547
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
548
MYSQL_TYPE_BLOB, MYSQL_TYPE_BLOB,
549
//MYSQL_TYPE_STRING
550
MYSQL_TYPE_BLOB
551
},
552
/* MYSQL_TYPE_VAR_STRING -> */
553
{
554
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
555
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
556
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
557
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
558
//MYSQL_TYPE_DOUBLE
559
MYSQL_TYPE_VARCHAR,
560
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
561
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
562
//MYSQL_TYPE_LONGLONG
563
MYSQL_TYPE_VARCHAR,
564
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
565
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
566
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
567
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
568
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
569
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
570
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
571
MYSQL_TYPE_VARCHAR, MYSQL_TYPE_VARCHAR,
572
//MYSQL_TYPE_SET
573
MYSQL_TYPE_VARCHAR,
574
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
575
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
576
//MYSQL_TYPE_STRING
577
MYSQL_TYPE_VARCHAR
578
},
579
/* MYSQL_TYPE_STRING -> */
580
{
581
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
582
MYSQL_TYPE_STRING, MYSQL_TYPE_STRING,
583
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
584
MYSQL_TYPE_STRING, MYSQL_TYPE_STRING,
585
//MYSQL_TYPE_DOUBLE
586
MYSQL_TYPE_STRING,
587
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
588
MYSQL_TYPE_STRING, MYSQL_TYPE_STRING,
589
//MYSQL_TYPE_LONGLONG
590
MYSQL_TYPE_STRING,
591
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
592
MYSQL_TYPE_STRING, MYSQL_TYPE_STRING,
593
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
594
MYSQL_TYPE_STRING, MYSQL_TYPE_STRING,
595
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
596
MYSQL_TYPE_STRING, MYSQL_TYPE_VARCHAR,
597
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
598
MYSQL_TYPE_STRING, MYSQL_TYPE_STRING,
599
//MYSQL_TYPE_SET
600
MYSQL_TYPE_STRING,
601
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
602
MYSQL_TYPE_BLOB, MYSQL_TYPE_VARCHAR,
603
//MYSQL_TYPE_STRING
604
MYSQL_TYPE_STRING
66
/* FIELD_TYPE_DECIMAL -> */
67
{
68
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
69
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_NEWDECIMAL,
70
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
71
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_NEWDECIMAL,
72
//FIELD_TYPE_DOUBLE
73
FIELD_TYPE_DOUBLE,
74
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
75
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
76
//FIELD_TYPE_LONGLONG
77
FIELD_TYPE_NEWDECIMAL,
78
//FIELD_TYPE_DATE FIELD_TYPE_TIME
79
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
80
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
81
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
82
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
83
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
84
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
85
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
86
//FIELD_TYPE_SET
87
FIELD_TYPE_VARCHAR,
88
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
89
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
90
//FIELD_TYPE_STRING
91
FIELD_TYPE_STRING
92
},
93
/* FIELD_TYPE_TINY -> */
94
{
95
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
96
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_TINY,
97
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
98
FIELD_TYPE_SHORT, FIELD_TYPE_LONG,
99
//FIELD_TYPE_DOUBLE
100
FIELD_TYPE_DOUBLE,
101
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
102
FIELD_TYPE_TINY, FIELD_TYPE_VARCHAR,
103
//FIELD_TYPE_LONGLONG
104
FIELD_TYPE_LONGLONG,
105
//FIELD_TYPE_DATE FIELD_TYPE_TIME
106
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
107
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
108
FIELD_TYPE_VARCHAR, FIELD_TYPE_TINY,
109
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
110
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
111
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
112
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
113
//FIELD_TYPE_SET
114
FIELD_TYPE_VARCHAR,
115
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
116
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
117
//FIELD_TYPE_STRING
118
FIELD_TYPE_STRING
119
},
120
/* FIELD_TYPE_SHORT -> */
121
{
122
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
123
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_SHORT,
124
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
125
FIELD_TYPE_SHORT, FIELD_TYPE_LONG,
126
//FIELD_TYPE_DOUBLE
127
FIELD_TYPE_DOUBLE,
128
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
129
FIELD_TYPE_SHORT, FIELD_TYPE_VARCHAR,
130
//FIELD_TYPE_LONGLONG
131
FIELD_TYPE_LONGLONG,
132
//FIELD_TYPE_DATE FIELD_TYPE_TIME
133
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
134
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
135
FIELD_TYPE_VARCHAR, FIELD_TYPE_SHORT,
136
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
137
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
138
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
139
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
140
//FIELD_TYPE_SET
141
FIELD_TYPE_VARCHAR,
142
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
143
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
144
//FIELD_TYPE_STRING
145
FIELD_TYPE_STRING
146
},
147
/* FIELD_TYPE_LONG -> */
148
{
149
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
150
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_LONG,
151
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
152
FIELD_TYPE_LONG, FIELD_TYPE_LONG,
153
//FIELD_TYPE_DOUBLE
154
FIELD_TYPE_DOUBLE,
155
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
156
FIELD_TYPE_LONG, FIELD_TYPE_VARCHAR,
157
//FIELD_TYPE_LONGLONG
158
FIELD_TYPE_LONGLONG,
159
//FIELD_TYPE_DATE FIELD_TYPE_TIME
160
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
161
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
162
FIELD_TYPE_VARCHAR, FIELD_TYPE_LONG,
163
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
164
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
165
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
166
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
167
//FIELD_TYPE_SET
168
FIELD_TYPE_VARCHAR,
169
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
170
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
171
//FIELD_TYPE_STRING
172
FIELD_TYPE_STRING
173
},
174
/* FIELD_TYPE_DOUBLE -> */
175
{
176
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
177
FIELD_TYPE_DOUBLE, FIELD_TYPE_DOUBLE,
178
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
179
FIELD_TYPE_DOUBLE, FIELD_TYPE_DOUBLE,
180
//FIELD_TYPE_DOUBLE
181
FIELD_TYPE_DOUBLE,
182
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
183
FIELD_TYPE_DOUBLE, FIELD_TYPE_VARCHAR,
184
//FIELD_TYPE_LONGLONG
185
FIELD_TYPE_DOUBLE,
186
//FIELD_TYPE_DATE FIELD_TYPE_TIME
187
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
188
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
189
FIELD_TYPE_VARCHAR, FIELD_TYPE_DOUBLE,
190
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
191
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
192
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
193
FIELD_TYPE_DOUBLE, FIELD_TYPE_VARCHAR,
194
//FIELD_TYPE_SET
195
FIELD_TYPE_VARCHAR,
196
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
197
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
198
//FIELD_TYPE_STRING
199
FIELD_TYPE_STRING
200
},
201
/* FIELD_TYPE_NULL -> */
202
{
203
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
204
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_TINY,
205
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
206
FIELD_TYPE_SHORT, FIELD_TYPE_LONG,
207
//FIELD_TYPE_DOUBLE
208
FIELD_TYPE_DOUBLE,
209
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
210
FIELD_TYPE_NULL, FIELD_TYPE_TIMESTAMP,
211
//FIELD_TYPE_LONGLONG
212
FIELD_TYPE_LONGLONG,
213
//FIELD_TYPE_DATE FIELD_TYPE_TIME
214
FIELD_TYPE_NEWDATE, FIELD_TYPE_TIME,
215
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
216
FIELD_TYPE_DATETIME, FIELD_TYPE_YEAR,
217
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
218
FIELD_TYPE_NEWDATE, FIELD_TYPE_VARCHAR,
219
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
220
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_ENUM,
221
//FIELD_TYPE_SET
222
FIELD_TYPE_SET,
223
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
224
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
225
//FIELD_TYPE_STRING
226
FIELD_TYPE_STRING
227
},
228
/* FIELD_TYPE_TIMESTAMP -> */
229
{
230
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
231
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
232
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
233
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
234
//FIELD_TYPE_DOUBLE
235
FIELD_TYPE_VARCHAR,
236
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
237
FIELD_TYPE_TIMESTAMP, FIELD_TYPE_TIMESTAMP,
238
//FIELD_TYPE_LONGLONG
239
FIELD_TYPE_VARCHAR,
240
//FIELD_TYPE_DATE FIELD_TYPE_TIME
241
FIELD_TYPE_DATETIME, FIELD_TYPE_DATETIME,
242
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
243
FIELD_TYPE_DATETIME, FIELD_TYPE_VARCHAR,
244
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
245
FIELD_TYPE_NEWDATE, FIELD_TYPE_VARCHAR,
246
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
247
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
248
//FIELD_TYPE_SET
249
FIELD_TYPE_VARCHAR,
250
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
251
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
252
//FIELD_TYPE_STRING
253
FIELD_TYPE_STRING
254
},
255
/* FIELD_TYPE_LONGLONG -> */
256
{
257
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
258
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_LONGLONG,
259
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
260
FIELD_TYPE_LONGLONG, FIELD_TYPE_LONGLONG,
261
//FIELD_TYPE_DOUBLE
262
FIELD_TYPE_DOUBLE,
263
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
264
FIELD_TYPE_LONGLONG, FIELD_TYPE_VARCHAR,
265
//FIELD_TYPE_LONGLONG
266
FIELD_TYPE_LONGLONG,
267
//FIELD_TYPE_DATE FIELD_TYPE_TIME
268
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
269
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
270
FIELD_TYPE_VARCHAR, FIELD_TYPE_LONGLONG,
271
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
272
FIELD_TYPE_NEWDATE, FIELD_TYPE_VARCHAR,
273
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
274
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
275
//FIELD_TYPE_SET
276
FIELD_TYPE_VARCHAR,
277
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
278
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
279
//FIELD_TYPE_STRING
280
FIELD_TYPE_STRING
281
},
282
/* FIELD_TYPE_DATE -> */
283
{
284
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
285
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
286
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
287
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
288
//FIELD_TYPE_DOUBLE
289
FIELD_TYPE_VARCHAR,
290
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
291
FIELD_TYPE_NEWDATE, FIELD_TYPE_DATETIME,
292
//FIELD_TYPE_LONGLONG
293
FIELD_TYPE_VARCHAR,
294
//FIELD_TYPE_DATE FIELD_TYPE_TIME
295
FIELD_TYPE_NEWDATE, FIELD_TYPE_DATETIME,
296
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
297
FIELD_TYPE_DATETIME, FIELD_TYPE_VARCHAR,
298
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
299
FIELD_TYPE_NEWDATE, FIELD_TYPE_VARCHAR,
300
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
301
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
302
//FIELD_TYPE_SET
303
FIELD_TYPE_VARCHAR,
304
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
305
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
306
//FIELD_TYPE_STRING
307
FIELD_TYPE_STRING
308
},
309
/* FIELD_TYPE_TIME -> */
310
{
311
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
312
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
313
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
314
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
315
//FIELD_TYPE_DOUBLE
316
FIELD_TYPE_VARCHAR,
317
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
318
FIELD_TYPE_TIME, FIELD_TYPE_DATETIME,
319
//FIELD_TYPE_LONGLONG
320
FIELD_TYPE_VARCHAR,
321
//FIELD_TYPE_DATE FIELD_TYPE_TIME
322
FIELD_TYPE_DATETIME, FIELD_TYPE_TIME,
323
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
324
FIELD_TYPE_DATETIME, FIELD_TYPE_VARCHAR,
325
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
326
FIELD_TYPE_NEWDATE, FIELD_TYPE_VARCHAR,
327
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
328
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
329
//FIELD_TYPE_SET
330
FIELD_TYPE_VARCHAR,
331
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
332
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
333
//FIELD_TYPE_STRING
334
FIELD_TYPE_STRING
335
},
336
/* FIELD_TYPE_DATETIME -> */
337
{
338
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
339
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
340
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
341
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
342
//FIELD_TYPE_DOUBLE
343
FIELD_TYPE_VARCHAR,
344
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
345
FIELD_TYPE_DATETIME, FIELD_TYPE_DATETIME,
346
//FIELD_TYPE_LONGLONG
347
FIELD_TYPE_VARCHAR,
348
//FIELD_TYPE_DATE FIELD_TYPE_TIME
349
FIELD_TYPE_DATETIME, FIELD_TYPE_DATETIME,
350
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
351
FIELD_TYPE_DATETIME, FIELD_TYPE_VARCHAR,
352
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
353
FIELD_TYPE_NEWDATE, FIELD_TYPE_VARCHAR,
354
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
355
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
356
//FIELD_TYPE_SET
357
FIELD_TYPE_VARCHAR,
358
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
359
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
360
//FIELD_TYPE_STRING
361
FIELD_TYPE_STRING
362
},
363
/* FIELD_TYPE_YEAR -> */
364
{
365
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
366
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_TINY,
367
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
368
FIELD_TYPE_SHORT, FIELD_TYPE_LONG,
369
//FIELD_TYPE_DOUBLE
370
FIELD_TYPE_DOUBLE,
371
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
372
FIELD_TYPE_YEAR, FIELD_TYPE_VARCHAR,
373
//FIELD_TYPE_LONGLONG
374
FIELD_TYPE_LONGLONG,
375
//FIELD_TYPE_DATE FIELD_TYPE_TIME
376
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
377
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
378
FIELD_TYPE_VARCHAR, FIELD_TYPE_YEAR,
379
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
380
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
381
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
382
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
383
//FIELD_TYPE_SET
384
FIELD_TYPE_VARCHAR,
385
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
386
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
387
//FIELD_TYPE_STRING
388
FIELD_TYPE_STRING
389
},
390
/* FIELD_TYPE_NEWDATE -> */
391
{
392
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
393
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
394
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
395
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
396
//FIELD_TYPE_DOUBLE
397
FIELD_TYPE_VARCHAR,
398
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
399
FIELD_TYPE_NEWDATE, FIELD_TYPE_DATETIME,
400
//FIELD_TYPE_LONGLONG
401
FIELD_TYPE_VARCHAR,
402
//FIELD_TYPE_DATE FIELD_TYPE_TIME
403
FIELD_TYPE_NEWDATE, FIELD_TYPE_DATETIME,
404
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
405
FIELD_TYPE_DATETIME, FIELD_TYPE_VARCHAR,
406
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
407
FIELD_TYPE_NEWDATE, FIELD_TYPE_VARCHAR,
408
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
409
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
410
//FIELD_TYPE_SET
411
FIELD_TYPE_VARCHAR,
412
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
413
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
414
//FIELD_TYPE_STRING
415
FIELD_TYPE_STRING
416
},
417
/* FIELD_TYPE_VARCHAR -> */
418
{
419
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
420
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
421
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
422
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
423
//FIELD_TYPE_DOUBLE
424
FIELD_TYPE_VARCHAR,
425
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
426
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
427
//FIELD_TYPE_LONGLONG
428
FIELD_TYPE_VARCHAR,
429
//FIELD_TYPE_DATE FIELD_TYPE_TIME
430
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
431
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
432
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
433
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
434
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
435
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
436
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
437
//FIELD_TYPE_SET
438
FIELD_TYPE_VARCHAR,
439
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
440
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
441
//FIELD_TYPE_STRING
442
FIELD_TYPE_VARCHAR
443
},
444
/* FIELD_TYPE_NEWDECIMAL -> */
445
{
446
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
447
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_NEWDECIMAL,
448
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
449
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_NEWDECIMAL,
450
//FIELD_TYPE_DOUBLE
451
FIELD_TYPE_DOUBLE,
452
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
453
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
454
//FIELD_TYPE_LONGLONG
455
FIELD_TYPE_NEWDECIMAL,
456
//FIELD_TYPE_DATE FIELD_TYPE_TIME
457
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
458
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
459
FIELD_TYPE_VARCHAR, FIELD_TYPE_NEWDECIMAL,
460
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
461
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
462
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
463
FIELD_TYPE_NEWDECIMAL, FIELD_TYPE_VARCHAR,
464
//FIELD_TYPE_SET
465
FIELD_TYPE_VARCHAR,
466
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
467
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
468
//FIELD_TYPE_STRING
469
FIELD_TYPE_STRING
470
},
471
/* FIELD_TYPE_ENUM -> */
472
{
473
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
474
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
475
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
476
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
477
//FIELD_TYPE_DOUBLE
478
FIELD_TYPE_VARCHAR,
479
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
480
FIELD_TYPE_ENUM, FIELD_TYPE_VARCHAR,
481
//FIELD_TYPE_LONGLONG
482
FIELD_TYPE_VARCHAR,
483
//FIELD_TYPE_DATE FIELD_TYPE_TIME
484
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
485
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
486
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
487
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
488
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
489
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
490
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
491
//FIELD_TYPE_SET
492
FIELD_TYPE_VARCHAR,
493
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
494
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
495
//FIELD_TYPE_STRING
496
FIELD_TYPE_STRING
497
},
498
/* FIELD_TYPE_SET -> */
499
{
500
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
501
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
502
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
503
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
504
//FIELD_TYPE_DOUBLE
505
FIELD_TYPE_VARCHAR,
506
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
507
FIELD_TYPE_SET, FIELD_TYPE_VARCHAR,
508
//FIELD_TYPE_LONGLONG
509
FIELD_TYPE_VARCHAR,
510
//FIELD_TYPE_DATE FIELD_TYPE_TIME
511
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
512
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
513
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
514
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
515
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
516
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
517
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
518
//FIELD_TYPE_SET
519
FIELD_TYPE_VARCHAR,
520
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
521
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
522
//FIELD_TYPE_STRING
523
FIELD_TYPE_STRING
524
},
525
/* FIELD_TYPE_BLOB -> */
526
{
527
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
528
FIELD_TYPE_BLOB, FIELD_TYPE_BLOB,
529
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
530
FIELD_TYPE_BLOB, FIELD_TYPE_BLOB,
531
//FIELD_TYPE_DOUBLE
532
FIELD_TYPE_BLOB,
533
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
534
FIELD_TYPE_BLOB, FIELD_TYPE_BLOB,
535
//FIELD_TYPE_LONGLONG
536
FIELD_TYPE_BLOB,
537
//FIELD_TYPE_DATE FIELD_TYPE_TIME
538
FIELD_TYPE_BLOB, FIELD_TYPE_BLOB,
539
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
540
FIELD_TYPE_BLOB, FIELD_TYPE_BLOB,
541
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
542
FIELD_TYPE_BLOB, FIELD_TYPE_BLOB,
543
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
544
FIELD_TYPE_BLOB, FIELD_TYPE_BLOB,
545
//FIELD_TYPE_SET
546
FIELD_TYPE_BLOB,
547
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
548
FIELD_TYPE_BLOB, FIELD_TYPE_BLOB,
549
//FIELD_TYPE_STRING
550
FIELD_TYPE_BLOB
551
},
552
/* FIELD_TYPE_VAR_STRING -> */
553
{
554
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
555
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
556
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
557
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
558
//FIELD_TYPE_DOUBLE
559
FIELD_TYPE_VARCHAR,
560
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
561
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
562
//FIELD_TYPE_LONGLONG
563
FIELD_TYPE_VARCHAR,
564
//FIELD_TYPE_DATE FIELD_TYPE_TIME
565
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
566
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
567
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
568
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
569
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
570
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
571
FIELD_TYPE_VARCHAR, FIELD_TYPE_VARCHAR,
572
//FIELD_TYPE_SET
573
FIELD_TYPE_VARCHAR,
574
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
575
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
576
//FIELD_TYPE_STRING
577
FIELD_TYPE_VARCHAR
578
},
579
/* FIELD_TYPE_STRING -> */
580
{
581
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
582
FIELD_TYPE_STRING, FIELD_TYPE_STRING,
583
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
584
FIELD_TYPE_STRING, FIELD_TYPE_STRING,
585
//FIELD_TYPE_DOUBLE
586
FIELD_TYPE_STRING,
587
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
588
FIELD_TYPE_STRING, FIELD_TYPE_STRING,
589
//FIELD_TYPE_LONGLONG
590
FIELD_TYPE_STRING,
591
//FIELD_TYPE_DATE FIELD_TYPE_TIME
592
FIELD_TYPE_STRING, FIELD_TYPE_STRING,
593
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
594
FIELD_TYPE_STRING, FIELD_TYPE_STRING,
595
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
596
FIELD_TYPE_STRING, FIELD_TYPE_VARCHAR,
597
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
598
FIELD_TYPE_STRING, FIELD_TYPE_STRING,
599
//FIELD_TYPE_SET
600
FIELD_TYPE_STRING,
601
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
602
FIELD_TYPE_BLOB, FIELD_TYPE_VARCHAR,
603
//FIELD_TYPE_STRING
604
FIELD_TYPE_STRING
605
605
}
606
606
};
607
607
627
627
628
628
static Item_result field_types_result_type [FIELDTYPE_NUM]=
629
629
{
630
//MYSQL_TYPE_DECIMAL MYSQL_TYPE_TINY
630
//FIELD_TYPE_DECIMAL FIELD_TYPE_TINY
631
631
DECIMAL_RESULT, INT_RESULT,
632
//MYSQL_TYPE_SHORT MYSQL_TYPE_LONG
632
//FIELD_TYPE_SHORT FIELD_TYPE_LONG
633
633
INT_RESULT, INT_RESULT,
634
//MYSQL_TYPE_DOUBLE
634
//FIELD_TYPE_DOUBLE
635
635
REAL_RESULT,
636
//MYSQL_TYPE_NULL MYSQL_TYPE_TIMESTAMP
636
//FIELD_TYPE_NULL FIELD_TYPE_TIMESTAMP
637
637
STRING_RESULT, STRING_RESULT,
638
//MYSQL_TYPE_LONGLONG
638
//FIELD_TYPE_LONGLONG
639
639
INT_RESULT,
640
//MYSQL_TYPE_DATE MYSQL_TYPE_TIME
640
//FIELD_TYPE_DATE FIELD_TYPE_TIME
641
641
STRING_RESULT, STRING_RESULT,
642
//MYSQL_TYPE_DATETIME MYSQL_TYPE_YEAR
642
//FIELD_TYPE_DATETIME FIELD_TYPE_YEAR
643
643
STRING_RESULT, INT_RESULT,
644
//MYSQL_TYPE_NEWDATE MYSQL_TYPE_VARCHAR
644
//FIELD_TYPE_NEWDATE FIELD_TYPE_VARCHAR
645
645
STRING_RESULT, STRING_RESULT,
646
//MYSQL_TYPE_NEWDECIMAL MYSQL_TYPE_ENUM
646
//FIELD_TYPE_NEWDECIMAL FIELD_TYPE_ENUM
647
647
DECIMAL_RESULT, STRING_RESULT,
648
//MYSQL_TYPE_SET
648
//FIELD_TYPE_SET
649
649
STRING_RESULT,
650
//MYSQL_TYPE_BLOB MYSQL_TYPE_VAR_STRING
650
//FIELD_TYPE_BLOB FIELD_TYPE_VAR_STRING
651
651
STRING_RESULT, STRING_RESULT,
652
//MYSQL_TYPE_STRING
652
//FIELD_TYPE_STRING
653
653
STRING_RESULT
654
654
};
655
655
717
717
bool Field::type_can_have_key_part(enum enum_field_types type)
718
718
{
719
719
switch (type) {
720
case MYSQL_TYPE_VARCHAR:
721
case MYSQL_TYPE_BLOB:
722
case MYSQL_TYPE_VAR_STRING:
723
case MYSQL_TYPE_STRING:
720
case FIELD_TYPE_VARCHAR:
721
case FIELD_TYPE_BLOB:
722
case FIELD_TYPE_VAR_STRING:
723
case FIELD_TYPE_STRING:
724
724
return true;
725
725
default:
726
726
return false;
1386
1386
return copy->length;
1387
1387
}
1388
1388
else if (!zero_pack() &&
1389
(type() == MYSQL_TYPE_STRING && copy->length >= 4 &&
1389
(type() == FIELD_TYPE_STRING && copy->length >= 4 &&
1390
1390
copy->length < 256))
1391
1391
{
1392
1392
copy->strip=1; /* Remove end space */
2203
2203
void Create_field::create_length_to_internal_length(void)
2204
2204
{
2205
2205
switch (sql_type) {
2206
case MYSQL_TYPE_BLOB:
2207
case MYSQL_TYPE_VAR_STRING:
2208
case MYSQL_TYPE_STRING:
2209
case MYSQL_TYPE_VARCHAR:
2206
case FIELD_TYPE_BLOB:
2207
case FIELD_TYPE_VAR_STRING:
2208
case FIELD_TYPE_STRING:
2209
case FIELD_TYPE_VARCHAR:
2210
2210
length*= charset->mbmaxlen;
2211
2211
key_length= length;
2212
2212
pack_length= calc_pack_length(sql_type, length);
2213
2213
break;
2214
case MYSQL_TYPE_ENUM:
2215
case MYSQL_TYPE_SET:
2214
case FIELD_TYPE_ENUM:
2215
case FIELD_TYPE_SET:
2216
2216
/* Pack_length already calculated in sql_parse.cc */
2217
2217
length*= charset->mbmaxlen;
2218
2218
key_length= pack_length;
2219
2219
break;
2220
case MYSQL_TYPE_NEWDECIMAL:
2220
case FIELD_TYPE_NEWDECIMAL:
2221
2221
key_length= pack_length=
2222
2222
my_decimal_get_binary_size(my_decimal_length_to_precision(length,
2223
2223
decimals,
2315
2315
it is NOT NULL, not an AUTO_INCREMENT field and not a TIMESTAMP.
2316
2316
*/
2317
2317
if (!fld_default_value && !(fld_type_modifier & AUTO_INCREMENT_FLAG) &&
2318
(fld_type_modifier & NOT_NULL_FLAG) && fld_type != MYSQL_TYPE_TIMESTAMP)
2318
(fld_type_modifier & NOT_NULL_FLAG) && fld_type != FIELD_TYPE_TIMESTAMP)
2319
2319
flags|= NO_DEFAULT_VALUE_FLAG;
2320
2320
2321
2321
if (fld_length && !(length= (uint) atoi(fld_length)))
2323
2323
sign_len= fld_type_modifier & UNSIGNED_FLAG ? 0 : 1;
2324
2324
2325
2325
switch (fld_type) {
2326
case MYSQL_TYPE_TINY:
2326
case FIELD_TYPE_TINY:
2327
2327
if (!fld_length)
2328
2328
length= MAX_TINYINT_WIDTH+sign_len;
2329
2329
allowed_type_modifier= AUTO_INCREMENT_FLAG;
2330
2330
break;
2331
case MYSQL_TYPE_SHORT:
2331
case FIELD_TYPE_SHORT:
2332
2332
if (!fld_length)
2333
2333
length= MAX_SMALLINT_WIDTH+sign_len;
2334
2334
allowed_type_modifier= AUTO_INCREMENT_FLAG;
2335
2335
break;
2336
case MYSQL_TYPE_LONG:
2336
case FIELD_TYPE_LONG:
2337
2337
if (!fld_length)
2338
2338
length= MAX_INT_WIDTH+sign_len;
2339
2339
allowed_type_modifier= AUTO_INCREMENT_FLAG;
2340
2340
break;
2341
case MYSQL_TYPE_LONGLONG:
2341
case FIELD_TYPE_LONGLONG:
2342
2342
if (!fld_length)
2343
2343
length= MAX_BIGINT_WIDTH;
2344
2344
allowed_type_modifier= AUTO_INCREMENT_FLAG;
2345
2345
break;
2346
case MYSQL_TYPE_NULL:
2346
case FIELD_TYPE_NULL:
2347
2347
break;
2348
case MYSQL_TYPE_NEWDECIMAL:
2348
case FIELD_TYPE_NEWDECIMAL:
2349
2349
my_decimal_trim(&length, &decimals);
2350
2350
if (length > DECIMAL_MAX_PRECISION)
2351
2351
{
2364
2364
pack_length=
2365
2365
my_decimal_get_binary_size(length, decimals);
2366
2366
break;
2367
case MYSQL_TYPE_VARCHAR:
2367
case FIELD_TYPE_VARCHAR:
2368
2368
/*
2369
2369
Long VARCHAR's are automaticly converted to blobs in mysql_prepare_table
2370
2370
if they don't have a default value
2371
2371
*/
2372
2372
max_field_charlength= MAX_FIELD_VARCHARLENGTH;
2373
2373
break;
2374
case MYSQL_TYPE_STRING:
2374
case FIELD_TYPE_STRING:
2375
2375
break;
2376
case MYSQL_TYPE_BLOB:
2376
case FIELD_TYPE_BLOB:
2377
2377
if (fld_default_value)
2378
2378
{
2379
2379
/* Allow empty as default value. */
2405
2405
}
2406
2406
flags|= BLOB_FLAG;
2407
2407
break;
2408
case MYSQL_TYPE_YEAR:
2408
case FIELD_TYPE_YEAR:
2409
2409
if (!fld_length || length != 2)
2410
2410
length= 4; /* Default length */
2411
2411
flags|= ZEROFILL_FLAG | UNSIGNED_FLAG;
2412
2412
break;
2413
case MYSQL_TYPE_DOUBLE:
2413
case FIELD_TYPE_DOUBLE:
2414
2414
allowed_type_modifier= AUTO_INCREMENT_FLAG;
2415
2415
if (!fld_length && !fld_decimals)
2416
2416
{
2424
2424
return(true);
2425
2425
}
2426
2426
break;
2427
case MYSQL_TYPE_TIMESTAMP:
2427
case FIELD_TYPE_TIMESTAMP:
2428
2428
if (!fld_length)
2429
2429
{
2430
2430
/* Compressed date YYYYMMDDHHMMSS */
2478
2478
Field::NONE));
2479
2479
}
2480
2480
break;
2481
case MYSQL_TYPE_DATE:
2481
case FIELD_TYPE_DATE:
2482
2482
/* Old date type. */
2483
sql_type= MYSQL_TYPE_NEWDATE;
2483
sql_type= FIELD_TYPE_NEWDATE;
2484
2484
/* fall trough */
2485
case MYSQL_TYPE_NEWDATE:
2486
length= 10;
2487
break;
2488
case MYSQL_TYPE_TIME:
2489
length= 10;
2490
break;
2491
case MYSQL_TYPE_DATETIME:
2485
case FIELD_TYPE_NEWDATE:
2486
length= 10;
2487
break;
2488
case FIELD_TYPE_TIME:
2489
length= 10;
2490
break;
2491
case FIELD_TYPE_DATETIME:
2492
2492
length= MAX_DATETIME_WIDTH;
2493
2493
break;
2494
case MYSQL_TYPE_SET:
2494
case FIELD_TYPE_SET:
2495
2495
{
2496
2496
pack_length= get_set_pack_length(fld_interval_list->elements);
2497
2497
2507
2507
length= 1;
2508
2508
break;
2509
2509
}
2510
case MYSQL_TYPE_ENUM:
2510
case FIELD_TYPE_ENUM:
2511
2511
{
2512
2512
/* Should be safe. */
2513
2513
pack_length= get_enum_pack_length(fld_interval_list->elements);
2516
2516
String *tmp;
2517
2517
while ((tmp= it++))
2518
2518
interval_list.push_back(tmp);
2519
length= 1; /* See comment for MYSQL_TYPE_SET above. */
2519
length= 1; /* See comment for FIELD_TYPE_SET above. */
2520
2520
break;
2521
2521
}
2522
case MYSQL_TYPE_VAR_STRING:
2522
case FIELD_TYPE_VAR_STRING:
2523
2523
assert(0); /* Impossible, we killed it */
2524
2524
break;
2525
2525
}
2527
2527
char_length= length;
2528
2528
2529
2529
if (!(flags & BLOB_FLAG) &&
2530
((length > max_field_charlength && fld_type != MYSQL_TYPE_SET &&
2531
fld_type != MYSQL_TYPE_ENUM &&
2532
(fld_type != MYSQL_TYPE_VARCHAR || fld_default_value)) ||
2530
((length > max_field_charlength && fld_type != FIELD_TYPE_SET &&
2531
fld_type != FIELD_TYPE_ENUM &&
2532
(fld_type != FIELD_TYPE_VARCHAR || fld_default_value)) ||
2533
2533
(!length &&
2534
fld_type != MYSQL_TYPE_STRING &&
2535
fld_type != MYSQL_TYPE_VARCHAR)))
2534
fld_type != FIELD_TYPE_STRING &&
2535
fld_type != FIELD_TYPE_VARCHAR)))
2536
2536
{
2537
my_error((fld_type == MYSQL_TYPE_VAR_STRING ||
2538
fld_type == MYSQL_TYPE_VARCHAR ||
2539
fld_type == MYSQL_TYPE_STRING) ? ER_TOO_BIG_FIELDLENGTH :
2537
my_error((fld_type == FIELD_TYPE_VAR_STRING ||
2538
fld_type == FIELD_TYPE_VARCHAR ||
2539
fld_type == FIELD_TYPE_STRING) ? ER_TOO_BIG_FIELDLENGTH :
2540
2540
ER_TOO_BIG_DISPLAYWIDTH,
2541
2541
MYF(0),
2542
2542
fld_name, max_field_charlength); /* purecov: inspected */
2557
2557
{
2558
2558
enum_field_types type;
2559
2559
2560
type= MYSQL_TYPE_BLOB;
2560
type= FIELD_TYPE_BLOB;
2561
2561
2562
2562
return type;
2563
2563
}
2570
2570
uint32_t calc_pack_length(enum_field_types type,uint32_t length)
2571
2571
{
2572
2572
switch (type) {
2573
case MYSQL_TYPE_VAR_STRING:
2574
case MYSQL_TYPE_STRING:
2575
case MYSQL_TYPE_VARCHAR: return (length + (length < 256 ? 1: 2));
2576
case MYSQL_TYPE_YEAR:
2577
case MYSQL_TYPE_TINY : return 1;
2578
case MYSQL_TYPE_SHORT : return 2;
2579
case MYSQL_TYPE_DATE:
2580
case MYSQL_TYPE_NEWDATE:
2581
case MYSQL_TYPE_TIME: return 3;
2582
case MYSQL_TYPE_TIMESTAMP:
2583
case MYSQL_TYPE_LONG : return 4;
2584
case MYSQL_TYPE_DOUBLE: return sizeof(double);
2585
case MYSQL_TYPE_DATETIME:
2586
case MYSQL_TYPE_LONGLONG: return 8; /* Don't crash if no int64_t */
2587
case MYSQL_TYPE_NULL : return 0;
2588
case MYSQL_TYPE_BLOB: return 4+portable_sizeof_char_ptr;
2589
case MYSQL_TYPE_SET:
2590
case MYSQL_TYPE_ENUM:
2591
case MYSQL_TYPE_NEWDECIMAL:
2573
case FIELD_TYPE_VAR_STRING:
2574
case FIELD_TYPE_STRING:
2575
case FIELD_TYPE_VARCHAR: return (length + (length < 256 ? 1: 2));
2576
case FIELD_TYPE_YEAR:
2577
case FIELD_TYPE_TINY : return 1;
2578
case FIELD_TYPE_SHORT : return 2;
2579
case FIELD_TYPE_DATE:
2580
case FIELD_TYPE_NEWDATE:
2581
case FIELD_TYPE_TIME: return 3;
2582
case FIELD_TYPE_TIMESTAMP:
2583
case FIELD_TYPE_LONG : return 4;
2584
case FIELD_TYPE_DOUBLE: return sizeof(double);
2585
case FIELD_TYPE_DATETIME:
2586
case FIELD_TYPE_LONGLONG: return 8; /* Don't crash if no int64_t */
2587
case FIELD_TYPE_NULL : return 0;
2588
case FIELD_TYPE_BLOB: return 4+portable_sizeof_char_ptr;
2589
case FIELD_TYPE_SET:
2590
case FIELD_TYPE_ENUM:
2591
case FIELD_TYPE_NEWDECIMAL:
2592
2592
abort(); return 0; // This shouldn't happen
2593
2593
default:
2594
2594
return 0;
2599
2599
uint pack_length_to_packflag(uint type)
2600
2600
{
2601
2601
switch (type) {
2602
case 1: return f_settype((uint) MYSQL_TYPE_TINY);
2603
case 2: return f_settype((uint) MYSQL_TYPE_SHORT);
2602
case 1: return f_settype((uint) FIELD_TYPE_TINY);
2603
case 2: return f_settype((uint) FIELD_TYPE_SHORT);
2604
2604
case 3: assert(1);
2605
case 4: return f_settype((uint) MYSQL_TYPE_LONG);
2606
case 8: return f_settype((uint) MYSQL_TYPE_LONGLONG);
2605
case 4: return f_settype((uint) FIELD_TYPE_LONG);
2606
case 8: return f_settype((uint) FIELD_TYPE_LONGLONG);
2607
2607
}
2608
2608
return 0; // This shouldn't happen
2609
2609
}
2629
2629
}
2630
2630
2631
2631
switch (field_type) {
2632
case MYSQL_TYPE_DATE:
2633
case MYSQL_TYPE_NEWDATE:
2634
case MYSQL_TYPE_TIME:
2635
case MYSQL_TYPE_DATETIME:
2636
case MYSQL_TYPE_TIMESTAMP:
2632
case FIELD_TYPE_DATE:
2633
case FIELD_TYPE_NEWDATE:
2634
case FIELD_TYPE_TIME:
2635
case FIELD_TYPE_DATETIME:
2636
case FIELD_TYPE_TIMESTAMP:
2637
2637
field_charset= &my_charset_bin;
2638
2638
default: break;
2639
2639
}
2642
2642
{
2643
2643
if (!f_is_packed(pack_flag))
2644
2644
{
2645
if (field_type == MYSQL_TYPE_STRING ||
2646
field_type == MYSQL_TYPE_VAR_STRING)
2645
if (field_type == FIELD_TYPE_STRING ||
2646
field_type == FIELD_TYPE_VAR_STRING)
2647
2647
return new Field_string(ptr,field_length,null_pos,null_bit,
2648
2648
unireg_check, field_name,
2649
2649
field_charset);
2650
if (field_type == MYSQL_TYPE_VARCHAR)
2650
if (field_type == FIELD_TYPE_VARCHAR)
2651
2651
return new Field_varstring(ptr,field_length,
2652
2652
HA_VARCHAR_PACKLENGTH(field_length),
2653
2653
null_pos,null_bit,
2679
2679
}
2680
2680
2681
2681
switch (field_type) {
2682
case MYSQL_TYPE_NEWDECIMAL:
2682
case FIELD_TYPE_NEWDECIMAL:
2683
2683
return new Field_new_decimal(ptr,field_length,null_pos,null_bit,
2684
2684
unireg_check, field_name,
2685
2685
f_decimals(pack_flag),
2686
2686
f_is_zerofill(pack_flag) != 0,
2687
2687
f_is_dec(pack_flag) == 0);
2688
case MYSQL_TYPE_DOUBLE:
2688
case FIELD_TYPE_DOUBLE:
2689
2689
return new Field_double(ptr,field_length,null_pos,null_bit,
2690
2690
unireg_check, field_name,
2691
2691
f_decimals(pack_flag),
2692
2692
f_is_zerofill(pack_flag) != 0,
2693
2693
f_is_dec(pack_flag)== 0);
2694
case MYSQL_TYPE_TINY:
2694
case FIELD_TYPE_TINY:
2695
2695
return new Field_tiny(ptr,field_length,null_pos,null_bit,
2696
2696
unireg_check, field_name,
2697
2697
f_is_zerofill(pack_flag) != 0,
2698
2698
f_is_dec(pack_flag) == 0);
2699
case MYSQL_TYPE_SHORT:
2699
case FIELD_TYPE_SHORT:
2700
2700
return new Field_short(ptr,field_length,null_pos,null_bit,
2701
2701
unireg_check, field_name,
2702
2702
f_is_zerofill(pack_flag) != 0,
2703
2703
f_is_dec(pack_flag) == 0);
2704
case MYSQL_TYPE_LONG:
2704
case FIELD_TYPE_LONG:
2705
2705
return new Field_long(ptr,field_length,null_pos,null_bit,
2706
2706
unireg_check, field_name,
2707
2707
f_is_zerofill(pack_flag) != 0,
2708
2708
f_is_dec(pack_flag) == 0);
2709
case MYSQL_TYPE_LONGLONG:
2709
case FIELD_TYPE_LONGLONG:
2710
2710
return new Field_int64_t(ptr,field_length,null_pos,null_bit,
2711
2711
unireg_check, field_name,
2712
2712
f_is_zerofill(pack_flag) != 0,
2713
2713
f_is_dec(pack_flag) == 0);
2714
case MYSQL_TYPE_TIMESTAMP:
2714
case FIELD_TYPE_TIMESTAMP:
2715
2715
return new Field_timestamp(ptr,field_length, null_pos, null_bit,
2716
2716
unireg_check, field_name, share,
2717
2717
field_charset);
2718
case MYSQL_TYPE_YEAR:
2718
case FIELD_TYPE_YEAR:
2719
2719
return new Field_year(ptr,field_length,null_pos,null_bit,
2720
2720
unireg_check, field_name);
2721
case MYSQL_TYPE_DATE:
2722
case MYSQL_TYPE_NEWDATE:
2721
case FIELD_TYPE_DATE:
2722
case FIELD_TYPE_NEWDATE:
2723
2723
return new Field_newdate(ptr,null_pos,null_bit,
2724
2724
unireg_check, field_name, field_charset);
2725
case MYSQL_TYPE_TIME:
2725
case FIELD_TYPE_TIME:
2726
2726
return new Field_time(ptr,null_pos,null_bit,
2727
2727
unireg_check, field_name, field_charset);
2728
case MYSQL_TYPE_DATETIME:
2728
case FIELD_TYPE_DATETIME:
2729
2729
return new Field_datetime(ptr,null_pos,null_bit,
2730
2730
unireg_check, field_name, field_charset);
2731
case MYSQL_TYPE_NULL:
2731
case FIELD_TYPE_NULL:
2732
2732
return new Field_null(ptr, field_length, unireg_check, field_name,
2733
2733
field_charset);
2734
2734
default: // Impossible (Wrong version)
2760
2760
portable_sizeof_char_ptr);
2761
2761
2762
2762
switch (sql_type) {
2763
case MYSQL_TYPE_BLOB:
2764
sql_type= MYSQL_TYPE_BLOB;
2763
case FIELD_TYPE_BLOB:
2764
sql_type= FIELD_TYPE_BLOB;
2765
2765
length/= charset->mbmaxlen;
2766
2766
key_length/= charset->mbmaxlen;
2767
2767
break;
2768
case MYSQL_TYPE_STRING:
2768
case FIELD_TYPE_STRING:
2769
2769
/* Change CHAR -> VARCHAR if dynamic record length */
2770
if (old_field->type() == MYSQL_TYPE_VAR_STRING)
2771
sql_type= MYSQL_TYPE_VARCHAR;
2770
if (old_field->type() == FIELD_TYPE_VAR_STRING)
2771
sql_type= FIELD_TYPE_VARCHAR;
2772
2772
/* fall through */
2773
2773
2774
case MYSQL_TYPE_ENUM:
2775
case MYSQL_TYPE_SET:
2776
case MYSQL_TYPE_VARCHAR:
2777
case MYSQL_TYPE_VAR_STRING:
2774
case FIELD_TYPE_ENUM:
2775
case FIELD_TYPE_SET:
2776
case FIELD_TYPE_VARCHAR:
2777
case FIELD_TYPE_VAR_STRING:
2778
2778
/* This is corrected in create_length_to_internal_length */
2779
2779
length= (length+charset->mbmaxlen-1) / charset->mbmaxlen;
2780
2780
break;
2791
2791
2792
2792
if (!(flags & (NO_DEFAULT_VALUE_FLAG | BLOB_FLAG)) &&
2793
2793
old_field->ptr && orig_field &&
2794
(sql_type != MYSQL_TYPE_TIMESTAMP || /* set def only if */
2794
(sql_type != FIELD_TYPE_TIMESTAMP || /* set def only if */
2795
2795
old_field->table->timestamp_field != old_field || /* timestamp field */
2796
2796
unireg_check == Field::TIMESTAMP_UN_FIELD)) /* has default val */
2797
2797
{
Loggerhead is a web-based interface for Breezy
Version: 2.0.1