release/src/router/mysql/sql/unireg.h

   1 /*
   2    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
   3
   4    This program is free software; you can redistribute it and/or modify
   5    it under the terms of the GNU General Public License as published by
   6    the Free Software Foundation; version 2 of the License.
   7
   8    This program is distributed in the hope that it will be useful,
   9    but WITHOUT ANY WARRANTY; without even the implied warranty of
  10    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  11    GNU General Public License for more details.
  12
  13    You should have received a copy of the GNU General Public License
  14    along with this program; if not, write to the Free Software
  15    Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA
  16 */
  17
  18
  19 /*  Extra functions used by unireg library */
  20
  21 #ifndef _unireg_h
  22
  23 #ifndef NO_ALARM_LOOP
  24 #define NO_ALARM_LOOP           /* lib5 and popen can't use alarm */
  25 #endif
  26
  27 /* These paths are converted to other systems (WIN95) before use */
  28
  29 #define LANGUAGE        "english/"
  30 #define ERRMSG_FILE     "errmsg.sys"
  31 #define TEMP_PREFIX     "MY"
  32 #define LOG_PREFIX      "ML"
  33 #define PROGDIR         "bin/"
  34 #ifndef MYSQL_DATADIR
  35 #define MYSQL_DATADIR           "data/"
  36 #endif
  37 #ifndef SHAREDIR
  38 #define SHAREDIR        "share/"
  39 #endif
  40 #ifndef PLUGINDIR
  41 #define PLUGINDIR       "lib/plugin"
  42 #endif
  43
  44 #define ER(X) errmesg[(X) - ER_ERROR_FIRST]
  45 #define ER_SAFE(X) (((X) >= ER_ERROR_FIRST && (X) <= ER_ERROR_LAST) ? ER(X) : "Invalid error code")
  46
  47
  48 #define ERRMAPP 1                               /* Errormap f|r my_error */
  49 #define LIBLEN FN_REFLEN-FN_LEN                 /* Max l{ngd p} dev */
  50 /* extra 4+4 bytes for slave tmp tables */
  51 #define MAX_DBKEY_LENGTH (NAME_LEN*2+1+1+4+4)
  52 #define MAX_ALIAS_NAME 256
  53 #define MAX_FIELD_NAME 34                       /* Max colum name length +2 */
  54 #define MAX_SYS_VAR_LENGTH 32
  55 #define MAX_KEY MAX_INDEXES                     /* Max used keys */
  56 #define MAX_REF_PARTS 16                        /* Max parts used as ref */
  57 #define MAX_KEY_LENGTH 3072                     /* max possible key */
  58 #if SIZEOF_OFF_T > 4
  59 #define MAX_REFLENGTH 8                         /* Max length for record ref */
  60 #else
  61 #define MAX_REFLENGTH 4                         /* Max length for record ref */
  62 #endif
  63 #define MAX_HOSTNAME  61                        /* len+1 in mysql.user */
  64
  65 #define MAX_MBWIDTH             3               /* Max multibyte sequence */
  66 #define MAX_FIELD_CHARLENGTH    255
  67 #define MAX_FIELD_VARCHARLENGTH 65535
  68 #define MAX_FIELD_BLOBLENGTH UINT_MAX32     /* cf field_blob::get_length() */
  69 #define CONVERT_IF_BIGGER_TO_BLOB 512           /* Used for CREATE ... SELECT */
  70
  71 /* Max column width +1 */
  72 #define MAX_FIELD_WIDTH         (MAX_FIELD_CHARLENGTH*MAX_MBWIDTH+1)
  73
  74 #define MAX_BIT_FIELD_LENGTH    64      /* Max length in bits for bit fields */
  75
  76 #define MAX_DATE_WIDTH          10      /* YYYY-MM-DD */
  77 #define MAX_TIME_WIDTH          23      /* -DDDDDD HH:MM:SS.###### */
  78 #define MAX_DATETIME_FULL_WIDTH 29      /* YYYY-MM-DD HH:MM:SS.###### AM */
  79 #define MAX_DATETIME_WIDTH      19      /* YYYY-MM-DD HH:MM:SS */
  80 #define MAX_DATETIME_COMPRESSED_WIDTH 14  /* YYYYMMDDHHMMSS */
  81
  82 #define MAX_TABLES      (sizeof(table_map)*8-3) /* Max tables in join */
  83 #define PARAM_TABLE_BIT (((table_map) 1) << (sizeof(table_map)*8-3))
  84 #define OUTER_REF_TABLE_BIT     (((table_map) 1) << (sizeof(table_map)*8-2))
  85 #define RAND_TABLE_BIT  (((table_map) 1) << (sizeof(table_map)*8-1))
  86 #define PSEUDO_TABLE_BITS (PARAM_TABLE_BIT | OUTER_REF_TABLE_BIT | \
  87                            RAND_TABLE_BIT)
  88 #define MAX_FIELDS      4096                    /* Limit in the .frm file */
  89 #define MAX_PARTITIONS  1024
  90
  91 #define MAX_SELECT_NESTING (sizeof(nesting_map)*8-1)
  92
  93 #define MAX_SORT_MEMORY (2048*1024-MALLOC_OVERHEAD)
  94 #define MIN_SORT_MEMORY (32*1024-MALLOC_OVERHEAD)
  95
  96 /* Memory allocated when parsing a statement / saving a statement */
  97 #define MEM_ROOT_BLOCK_SIZE       8192
  98 #define MEM_ROOT_PREALLOC         8192
  99 #define TRANS_MEM_ROOT_BLOCK_SIZE 4096
 100 #define TRANS_MEM_ROOT_PREALLOC   4096
 101
 102 #define DEFAULT_ERROR_COUNT     64
 103 #define EXTRA_RECORDS   10                      /* Extra records in sort */
 104 #define SCROLL_EXTRA    5                       /* Extra scroll-rows. */
 105 #define FIELD_NAME_USED ((uint) 32768)          /* Bit set if fieldname used */
 106 #define FORM_NAME_USED  ((uint) 16384)          /* Bit set if formname used */
 107 #define FIELD_NR_MASK   16383                   /* To get fieldnumber */
 108 #define FERR            -1                      /* Error from my_functions */
 109 #define CREATE_MODE     0                       /* Default mode on new files */
 110 #define NAMES_SEP_CHAR  '\377'                  /* Char to sep. names */
 111
 112 #define READ_RECORD_BUFFER      (uint) (IO_SIZE*8) /* Pointer_buffer_size */
 113 #define DISK_BUFFER_SIZE        (uint) (IO_SIZE*16) /* Size of diskbuffer */
 114
 115 #define ME_INFO (ME_HOLDTANG+ME_OLDWIN+ME_NOREFRESH)
 116 #define ME_ERROR (ME_BELL+ME_OLDWIN+ME_NOREFRESH)
 117 #define MYF_RW MYF(MY_WME+MY_NABP)              /* Vid my_read & my_write */
 118
 119 #define SPECIAL_USE_LOCKS       1               /* Lock used databases */
 120 #define SPECIAL_NO_NEW_FUNC     2               /* Skip new functions */
 121 #define SPECIAL_SKIP_SHOW_DB    4               /* Don't allow 'show db' */
 122 #define SPECIAL_WAIT_IF_LOCKED  8               /* Wait if locked database */
 123 #define SPECIAL_SAME_DB_NAME   16               /* form name = file name */
 124 #define SPECIAL_ENGLISH        32               /* English error messages */
 125 #define SPECIAL_NO_RESOLVE     64               /* Don't use gethostname */
 126 #define SPECIAL_NO_PRIOR        128             /* Don't prioritize threads */
 127 #define SPECIAL_BIG_SELECTS     256             /* Don't use heap tables */
 128 #define SPECIAL_NO_HOST_CACHE   512             /* Don't cache hosts */
 129 #define SPECIAL_SHORT_LOG_FORMAT 1024
 130 #define SPECIAL_SAFE_MODE       2048
 131 #define SPECIAL_LOG_QUERIES_NOT_USING_INDEXES 4096 /* Obsolete */
 132
 133         /* Extern defines */
 134 #define store_record(A,B) memcpy((A)->B,(A)->record[0],(size_t) (A)->s->reclength)
 135 #define restore_record(A,B) memcpy((A)->record[0],(A)->B,(size_t) (A)->s->reclength)
 136 #define cmp_record(A,B) memcmp((A)->record[0],(A)->B,(size_t) (A)->s->reclength)
 137 #define empty_record(A) { \
 138                           restore_record((A),s->default_values); \
 139                           bfill((A)->null_flags,(A)->s->null_bytes,255);\
 140                         }
 141
 142         /* Defines for use with openfrm, openprt and openfrd */
 143
 144 #define READ_ALL                1       /* openfrm: Read all parameters */
 145 #define CHANGE_FRM              2       /* openfrm: open .frm as O_RDWR */
 146 #define READ_KEYINFO            4       /* L{s nyckeldata fr}n filen */
 147 #define EXTRA_RECORD            8       /* Reservera plats f|r extra record */
 148 #define DONT_OPEN_TABLES        8       /* Don't open database-files (frd) */
 149 #define DONT_OPEN_MASTER_REG    16      /* Don't open first reg-file (prt) */
 150 #define EXTRA_LONG_RECORD       16      /* Plats f|r dubbel s|k-record */
 151 #define COMPUTE_TYPES           32      /* Kontrollera type f|r f{ltena */
 152 #define SEARCH_PRG              64      /* S|k efter registret i 'prg_dev' */
 153 #define READ_USED_NAMES         128     /* L{s anv{nda formul{rnamn */
 154 #define DONT_GIVE_ERROR         256     /* Don't do frm_error on openfrm  */
 155 #define READ_SCREENS            1024    /* Read screens, info and helpfile */
 156 #define DELAYED_OPEN            4096    /* Open table later */
 157 #define OPEN_VIEW               8192    /* Allow open on view */
 158 #define OPEN_VIEW_NO_PARSE     16384    /* Open frm only if it's a view,
 159                                            but do not parse view itself */
 160 /**
 161   This flag is used in function get_all_tables() which fills
 162   I_S tables with data which are retrieved from frm files and storage engine
 163   The flag means that we need to open FRM file only to get necessary data.
 164 */
 165 #define OPEN_FRM_FILE_ONLY     32768
 166 /**
 167   This flag is used in function get_all_tables() which fills
 168   I_S tables with data which are retrieved from frm files and storage engine
 169   The flag means that we need to process tables only to get necessary data.
 170   Views are not processed.
 171 */
 172 #define OPEN_TABLE_ONLY        OPEN_FRM_FILE_ONLY*2
 173 /**
 174   This flag is used in function get_all_tables() which fills
 175   I_S tables with data which are retrieved from frm files and storage engine
 176   The flag means that we need to process views only to get necessary data.
 177   Tables are not processed.
 178 */
 179 #define OPEN_VIEW_ONLY         OPEN_TABLE_ONLY*2
 180 /**
 181   This flag is used in function get_all_tables() which fills
 182   I_S tables with data which are retrieved from frm files and storage engine.
 183   The flag means that we need to open a view using
 184   open_normal_and_derived_tables() function.
 185 */
 186 #define OPEN_VIEW_FULL         OPEN_VIEW_ONLY*2
 187 /**
 188   This flag is used in function get_all_tables() which fills
 189   I_S tables with data which are retrieved from frm files and storage engine.
 190   The flag means that I_S table uses optimization algorithm.
 191 */
 192 #define OPTIMIZE_I_S_TABLE     OPEN_VIEW_FULL*2
 193
 194 #define SC_INFO_LENGTH 4                /* Form format constant */
 195 #define TE_INFO_LENGTH 3
 196 #define MTYP_NOEMPTY_BIT 128
 197
 198 #define FRM_VER_TRUE_VARCHAR (FRM_VER+4) /* 10 */
 199 /*
 200   Minimum length pattern before Turbo Boyer-Moore is used
 201   for SELECT "text" LIKE "%pattern%", excluding the two
 202   wildcards in class Item_func_like.
 203 */
 204 #define MIN_TURBOBM_PATTERN_LEN 3
 205
 206 /*
 207    Defines for binary logging.
 208    Do not decrease the value of BIN_LOG_HEADER_SIZE.
 209    Do not even increase it before checking code.
 210 */
 211
 212 #define BIN_LOG_HEADER_SIZE    4
 213
 214 #define DEFAULT_KEY_CACHE_NAME "default"
 215
 216 /* Include prototypes for unireg */
 217
 218 #include "mysqld_error.h"
 219 #include "structs.h"                            /* All structs we need */
 220
 221 #endif