Skip navigation links

 Systems for MySQL

The world's most popular open source database

Contact a MySQL Representative

Login | Register

• MySQL.com
• Developer Zone
• Partners & Solutions
• Customer Login

• DevZone
• Downloads
• Documentation
• Articles
• Forums
• Bugs
• Forge
• Blogs

 

---

Learn about new MySQL releases, technical articles, events and more.

Subscribe Now »

mysql/src/5.1-dbg/sql/unireg.h

Go to the documentation of this file.

/* Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */


/*  Extra functions used by unireg library */

#ifndef _unireg_h

#ifndef NO_ALARM_LOOP
#define NO_ALARM_LOOP           /* lib5 and popen can't use alarm */
#endif

/* These paths are converted to other systems (WIN95) before use */

#define LANGUAGE        "english/"
#define ERRMSG_FILE     "errmsg.sys"
#define TEMP_PREFIX     "MY"
#define LOG_PREFIX      "ML"
#define PROGDIR         "bin/"
#ifndef DATADIR
#define DATADIR         "data/"
#endif
#ifndef SHAREDIR
#define SHAREDIR        "share/"
#endif
#ifndef LIBDIR
#define LIBDIR          "lib/"
#endif

#define ER(X) errmesg[(X) - ER_ERROR_FIRST]
#define ER_SAFE(X) (((X) >= ER_ERROR_FIRST && (X) <= ER_ERROR_LAST) ? ER(X) : "Invalid error code")


#define ERRMAPP 1                               /* Errormap f|r my_error */
#define LIBLEN FN_REFLEN-FN_LEN                 /* Max l{ngd p} dev */
/* extra 4+4 bytes for slave tmp tables */
#define MAX_DBKEY_LENGTH (NAME_LEN*2+1+1+4+4)
#define MAX_ALIAS_NAME 256
#define MAX_FIELD_NAME 34                       /* Max colum name length +2 */
#define MAX_SYS_VAR_LENGTH 32
#define MAX_KEY MAX_INDEXES                     /* Max used keys */
#define MAX_REF_PARTS 16                        /* Max parts used as ref */
#define MAX_KEY_LENGTH 3072                     /* max possible key */
#if SIZEOF_OFF_T > 4
#define MAX_REFLENGTH 8                         /* Max length for record ref */
#else
#define MAX_REFLENGTH 4                         /* Max length for record ref */
#endif
#define MAX_HOSTNAME  61                        /* len+1 in mysql.user */

#define MAX_MBWIDTH             3               /* Max multibyte sequence */
#define MAX_FIELD_CHARLENGTH    255
#define MAX_FIELD_VARCHARLENGTH 65535
#define CONVERT_IF_BIGGER_TO_BLOB 512           /* Used for CREATE ... SELECT */

/* Max column width +1 */
#define MAX_FIELD_WIDTH         (MAX_FIELD_CHARLENGTH*MAX_MBWIDTH+1)

#define MAX_BIT_FIELD_LENGTH    64      /* Max length in bits for bit fields */

#define MAX_DATE_WIDTH          10      /* YYYY-MM-DD */
#define MAX_TIME_WIDTH          23      /* -DDDDDD HH:MM:SS.###### */
#define MAX_DATETIME_FULL_WIDTH 29      /* YYYY-MM-DD HH:MM:SS.###### AM */
#define MAX_DATETIME_WIDTH      19      /* YYYY-MM-DD HH:MM:SS */

#define MAX_TABLES      (sizeof(table_map)*8-3) /* Max tables in join */
#define PARAM_TABLE_BIT (((table_map) 1) << (sizeof(table_map)*8-3))
#define OUTER_REF_TABLE_BIT     (((table_map) 1) << (sizeof(table_map)*8-2))
#define RAND_TABLE_BIT  (((table_map) 1) << (sizeof(table_map)*8-1))
#define PSEUDO_TABLE_BITS (PARAM_TABLE_BIT | OUTER_REF_TABLE_BIT | \
                           RAND_TABLE_BIT)
#define MAX_FIELDS      4096                    /* Limit in the .frm file */
#define MAX_PARTITIONS  1024

#define MAX_SORT_MEMORY (2048*1024-MALLOC_OVERHEAD)
#define MIN_SORT_MEMORY (32*1024-MALLOC_OVERHEAD)

/* Memory allocated when parsing a statement / saving a statement */
#define MEM_ROOT_BLOCK_SIZE       8192
#define MEM_ROOT_PREALLOC         8192
#define TRANS_MEM_ROOT_BLOCK_SIZE 4096
#define TRANS_MEM_ROOT_PREALLOC   4096

#define DEFAULT_ERROR_COUNT     64
#define EXTRA_RECORDS   10                      /* Extra records in sort */
#define SCROLL_EXTRA    5                       /* Extra scroll-rows. */
#define FIELD_NAME_USED ((uint) 32768)          /* Bit set if fieldname used */
#define FORM_NAME_USED  ((uint) 16384)          /* Bit set if formname used */
#define FIELD_NR_MASK   16383                   /* To get fieldnumber */
#define FERR            -1                      /* Error from my_functions */
#define CREATE_MODE     0                       /* Default mode on new files */
#define NAMES_SEP_CHAR  '\377'                  /* Char to sep. names */

#define READ_RECORD_BUFFER      (uint) (IO_SIZE*8) /* Pointer_buffer_size */
#define DISK_BUFFER_SIZE        (uint) (IO_SIZE*16) /* Size of diskbuffer */
#define POSTFIX_ERROR           DBL_MAX

#define ME_INFO (ME_HOLDTANG+ME_OLDWIN+ME_NOREFRESH)
#define ME_ERROR (ME_BELL+ME_OLDWIN+ME_NOREFRESH)
#define MYF_RW MYF(MY_WME+MY_NABP)              /* Vid my_read & my_write */

#define SPECIAL_USE_LOCKS       1               /* Lock used databases */
#define SPECIAL_NO_NEW_FUNC     2               /* Skip new functions */
#define SPECIAL_SKIP_SHOW_DB    4               /* Don't allow 'show db' */
#define SPECIAL_WAIT_IF_LOCKED  8               /* Wait if locked database */
#define SPECIAL_SAME_DB_NAME   16               /* form name = file name */
#define SPECIAL_ENGLISH        32               /* English error messages */
#define SPECIAL_NO_RESOLVE     64               /* Don't use gethostname */
#define SPECIAL_NO_PRIOR        128             /* Don't prioritize threads */
#define SPECIAL_BIG_SELECTS     256             /* Don't use heap tables */
#define SPECIAL_NO_HOST_CACHE   512             /* Don't cache hosts */
#define SPECIAL_SHORT_LOG_FORMAT 1024
#define SPECIAL_SAFE_MODE       2048
#define SPECIAL_LOG_QUERIES_NOT_USING_INDEXES 4096 /* Log q not using indexes */

        /* Extern defines */
#define store_record(A,B) bmove_align((A)->B,(A)->record[0],(size_t) (A)->s->reclength)
#define restore_record(A,B) bmove_align((A)->record[0],(A)->B,(size_t) (A)->s->reclength)
#define cmp_record(A,B) memcmp((A)->record[0],(A)->B,(size_t) (A)->s->reclength)
#define empty_record(A) { \
                          restore_record((A),s->default_values); \
                          bfill((A)->null_flags,(A)->s->null_bytes,255);\
                        }

        /* Defines for use with openfrm, openprt and openfrd */

#define READ_ALL                1       /* openfrm: Read all parameters */
#define CHANGE_FRM              2       /* openfrm: open .frm as O_RDWR */
#define READ_KEYINFO            4       /* L{s nyckeldata fr}n filen */
#define EXTRA_RECORD            8       /* Reservera plats f|r extra record */
#define DONT_OPEN_TABLES        8       /* Don't open database-files (frd) */
#define DONT_OPEN_MASTER_REG    16      /* Don't open first reg-file (prt) */
#define EXTRA_LONG_RECORD       16      /* Plats f|r dubbel s|k-record */
#define COMPUTE_TYPES           32      /* Kontrollera type f|r f{ltena */
#define SEARCH_PRG              64      /* S|k efter registret i 'prg_dev' */
#define READ_USED_NAMES         128     /* L{s anv{nda formul{rnamn */
#define DONT_GIVE_ERROR         256     /* Don't do frm_error on openfrm  */
#define READ_SCREENS            1024    /* Read screens, info and helpfile */
#define DELAYED_OPEN            4096    /* Open table later */
#define OPEN_VIEW               8192    /* Allow open on view */
#define OPEN_VIEW_NO_PARSE     16384    /* Open frm only if it's a view,
                                           but do not parse view itself */
#define SC_INFO_LENGTH 4                /* Form format constant */
#define TE_INFO_LENGTH 3
#define MTYP_NOEMPTY_BIT 128

#define FRM_VER_TRUE_VARCHAR (FRM_VER+4) /* 10 */
/*
  Minimum length pattern before Turbo Boyer-Moore is used
  for SELECT "text" LIKE "%pattern%", excluding the two
  wildcards in class Item_func_like.
*/
#define MIN_TURBOBM_PATTERN_LEN 3

/* 
   Defines for binary logging.
   Do not decrease the value of BIN_LOG_HEADER_SIZE.
   Do not even increase it before checking code.
*/

#define BIN_LOG_HEADER_SIZE    4 
#define FLOATING_POINT_BUFFER 331

#define DEFAULT_KEY_CACHE_NAME "default"

/* Include prototypes for unireg */

#include "mysqld_error.h"
#include "structs.h"                            /* All structs we need */

#endif

---

© 1995-2008 MySQL AB, 2008 Sun Microsystems, Inc.

• Online Shop
• Site Map
• About MySQL
• Legal
• Privacy Policy
• Contact Us
• Job Opportunities