feature: impl support for create, insert(delayed/no delayed mode), update, delete, select, support for unsigned [tinyint~int]

[hustjieke]

[hustjieke]

For tinyint unsigned = 128, it will be paresd as value(-128) in iterator during send result:

// here we deal with both signed/unsigned, the exact values will be converted on send results phase.
void TempTable::RecordIterator::PrepareValues() {
  if (_currentRNo < uint64_t(table->NumOfObj())) {
...
...
      } else if (attrt_tmp == common::ColumnType::BYTEINT) {
        char &v = (*(AttrBuffer<char> *)table->GetDisplayableAttrP(att)->buffer)[_currentRNo];
        // uchar &v = (*(AttrBuffer<uchar> *)table->GetDisplayableAttrP(att)->buffer)[_currentRNo];
        if (v == common::NULL_VALUE_C)
          dataTypes[att]->SetToNull();
        else
...
...

We should condering this case, as it will be treated as NULL. The same problem with unsigned [smallint, mediumint, int]

mysql> select max(a) from t;
+--------+
| max(a) |
+--------+
|   NULL |
+--------+
1 row in set (0.00 sec)

mysql> select min(a) from t;
+--------+
| min(a) |
+--------+
|   NULL |
+--------+
1 row in set (0.00 sec)

mysql> select * from t;
+------+
| a    |
+------+
|  128 |
+------+
1 row in set (0.01 sec)

[hustjieke]

TODO: changed all tianmu enum boundary values to mysql style:
in include/my_global.h

#define INT_MIN64       (~0x7FFFFFFFFFFFFFFFLL)
#define INT_MAX64       0x7FFFFFFFFFFFFFFFLL
#define INT_MIN32       (~0x7FFFFFFFL)
#define INT_MAX32       0x7FFFFFFFL
#define UINT_MAX32      0xFFFFFFFFL
#define INT_MIN24       (~0x007FFFFF)
#define INT_MAX24       0x007FFFFF
#define UINT_MAX24      0x00FFFFFF
#define INT_MIN16       (~0x7FFF)
#define INT_MAX16       0x7FFF
#define UINT_MAX16      0xFFFF
#define INT_MIN8        (~0x7F)
#define INT_MAX8        0x7F
#define UINT_MAX8       0xFF