374
381
#define IS_EQUAL_PACK_LENGTH 2
378
Query type constants.
380
QT_ORDINARY -- ordinary SQL query.
381
QT_IS -- SQL query to be shown in INFORMATION_SCHEMA (in utf8 and without
382
character set introducers).
386
Move this out of here once Stew's done with UDF breakout. The following headers need it:
388
sql_lex.h --> included by session.h
406
* @TODO Move to a separate header?
408
* It's needed by item.h and field.h, which are both inter-dependent
409
* and contain forward declarations of many structs/classes in the
412
* What is needed is a separate header file that is included
413
* by *both* item.h and field.h to resolve inter-dependencies
415
* But, probably want to hold off on this until Stew finished the UDF cleanup
419
DERIVATION_IGNORABLE= 5,
420
DERIVATION_COERCIBLE= 4,
421
DERIVATION_SYSCONST= 3,
422
DERIVATION_IMPLICIT= 2,
424
DERIVATION_EXPLICIT= 0
428
* Opening modes for open_temporary_table and open_table_from_share
430
* @TODO Put this into an appropriate header. It is only needed in:
444
* used by several functions in functions/time directory
447
enum date_time_format_types
449
TIME_ONLY= 0, TIME_MICROSECOND, DATE_ONLY, DATE_TIME, DATE_TIME_MICROSECOND
453
enum enum_parsing_place
462
enum enum_mysql_completiontype {
465
, ROLLBACK_AND_CHAIN= 7
468
, COMMIT_AND_CHAIN= 6
471
enum enum_check_fields
475
, CHECK_FIELD_ERROR_FOR_NULL
486
typedef uint64_t query_id_t;
487
typedef void *range_seq_t;
491
The maximum is defined as (ULONG_MAX/1000) with 4 bytes uint32_t
493
static const uint32_t SLAVE_MAX_HEARTBEAT_PERIOD= 4294967;
495
#define SLAVE_NET_TIMEOUT 3600
497
#define MAX_SLAVE_ERROR 2000
499
/* masks for start/stop operations on io and sql slave threads */
504
#define NO_HASH /* Not yet implemented */
507
// the following is for checking tables
509
#define HA_ADMIN_ALREADY_DONE 1
510
#define HA_ADMIN_OK 0
511
#define HA_ADMIN_NOT_IMPLEMENTED -1
512
#define HA_ADMIN_FAILED -2
513
#define HA_ADMIN_CORRUPT -3
514
#define HA_ADMIN_INTERNAL_ERROR -4
515
#define HA_ADMIN_INVALID -5
516
#define HA_ADMIN_REJECT -6
517
#define HA_ADMIN_TRY_ALTER -7
518
#define HA_ADMIN_WRONG_CHECKSUM -8
519
#define HA_ADMIN_NOT_BASE_TABLE -9
520
#define HA_ADMIN_NEEDS_UPGRADE -10
521
#define HA_ADMIN_NEEDS_ALTER -11
522
#define HA_ADMIN_NEEDS_CHECK -12
525
#define HA_ADD_INDEX (0)
526
#define HA_DROP_INDEX (1)
527
#define HA_ALTER_INDEX (2)
528
#define HA_RENAME_INDEX (3)
529
#define HA_ADD_UNIQUE_INDEX (4)
530
#define HA_DROP_UNIQUE_INDEX (5)
531
#define HA_ALTER_UNIQUE_INDEX (6)
532
#define HA_RENAME_UNIQUE_INDEX (7)
533
#define HA_ADD_PK_INDEX (8)
534
#define HA_DROP_PK_INDEX (9)
535
#define HA_ALTER_PK_INDEX (10)
536
#define HA_ADD_COLUMN (11)
537
#define HA_DROP_COLUMN (12)
538
#define HA_CHANGE_COLUMN (13)
539
#define HA_ALTER_COLUMN_NAME (14)
540
#define HA_ALTER_COLUMN_TYPE (15)
541
#define HA_ALTER_COLUMN_ORDER (16)
542
#define HA_ALTER_COLUMN_NULLABLE (17)
543
#define HA_COLUMN_DEFAULT_VALUE (18)
544
#define HA_COLUMN_STORAGE (19)
545
#define HA_COLUMN_FORMAT (20)
546
#define HA_ADD_FOREIGN_KEY (21)
547
#define HA_DROP_FOREIGN_KEY (22)
548
#define HA_ALTER_FOREIGN_KEY (23)
549
#define HA_ADD_CONSTRAINT (24)
550
#define HA_CHANGE_CHARACTER_SET (30)
551
#define HA_SET_DEFAULT_CHARACTER_SET (31)
552
#define HA_CHANGE_AUTOINCREMENT_VALUE (32)
553
#define HA_ALTER_STORAGE (33)
554
#define HA_ALTER_TABLESPACE (34)
555
#define HA_ALTER_ROW_FORMAT (35)
556
#define HA_RENAME_TABLE (36)
557
#define HA_ALTER_STORAGE_ENGINE (37)
558
#define HA_RECREATE (38)
559
#define HA_ALTER_STORED_VCOL (39)
560
/* Remember to increase HA_MAX_ALTER_FLAGS when adding more flags! */
562
/* Return values for check_if_supported_alter */
564
#define HA_ALTER_ERROR -1
565
#define HA_ALTER_SUPPORTED_WAIT_LOCK 0
566
#define HA_ALTER_SUPPORTED_NO_LOCK 1
567
#define HA_ALTER_NOT_SUPPORTED 2
569
/* Bits in table_flags() to show what database can do */
571
#define HA_NO_TRANSACTIONS (1 << 0) /* Doesn't support transactions */
572
#define HA_PARTIAL_COLUMN_READ (1 << 1) /* read may not return all columns */
573
#define HA_TABLE_SCAN_ON_INDEX (1 << 2) /* No separate data/index file */
575
The following should be set if the following is not true when scanning
576
a table with rnd_next()
577
- We will see all rows (including deleted ones)
578
- Row positions are 'table->s->db_record_offset' apart
579
If this flag is not set, filesort will do a postion() call for each matched
580
row to be able to find the row later.
582
#define HA_REC_NOT_IN_SEQ (1 << 3)
585
Reading keys in random order is as fast as reading keys in sort order
586
(Used in records.cc to decide if we should use a record cache and by
587
filesort to decide if we should sort key + data or key + pointer-to-row
589
#define HA_FAST_KEY_READ (1 << 5)
591
Set the following flag if we on delete should force all key to be read
592
and on update read all keys that changes
594
#define HA_REQUIRES_KEY_COLUMNS_FOR_DELETE (1 << 6)
595
#define HA_NULL_IN_KEY (1 << 7) /* One can have keys with NULL */
596
#define HA_DUPLICATE_POS (1 << 8) /* ha_position() gives dup row */
597
#define HA_NO_BLOBS (1 << 9) /* Doesn't support blobs */
598
#define HA_CAN_INDEX_BLOBS (1 << 10)
599
#define HA_AUTO_PART_KEY (1 << 11) /* auto-increment in multi-part key */
600
#define HA_REQUIRE_PRIMARY_KEY (1 << 12) /* .. and can't create a hidden one */
601
#define HA_STATS_RECORDS_IS_EXACT (1 << 13) /* stats.records is exact */
603
If we get the primary key columns for free when we do an index read
604
It also implies that we have to retrive the primary key when using
605
position() and rnd_pos().
607
#define HA_PRIMARY_KEY_IN_READ_INDEX (1 << 15)
609
If HA_PRIMARY_KEY_REQUIRED_FOR_POSITION is set, it means that to position()
610
uses a primary key. Without primary key, we can't call position().
612
#define HA_PRIMARY_KEY_REQUIRED_FOR_POSITION (1 << 16)
613
#define HA_NOT_DELETE_WITH_CACHE (1 << 18)
615
The following is we need to a primary key to delete (and update) a row.
616
If there is no primary key, all columns needs to be read on update and delete
618
#define HA_PRIMARY_KEY_REQUIRED_FOR_DELETE (1 << 19)
619
#define HA_NO_PREFIX_CHAR_KEYS (1 << 20)
620
#define HA_NO_AUTO_INCREMENT (1 << 23)
621
#define HA_HAS_CHECKSUM (1 << 24)
622
/* Table data are stored in separate files (for lower_case_table_names) */
623
#define HA_FILE_BASED (1 << 26)
624
#define HA_NEED_READ_RANGE_BUFFER (1 << 29) /* for read_multi_range */
625
#define HA_ANY_INDEX_MAY_BE_UNIQUE (1 << 30)
626
#define HA_NO_COPY_ON_ALTER (INT64_C(1) << 31)
627
#define HA_HAS_RECORDS (INT64_C(1) << 32) /* records() gives exact count*/
628
#define HA_MRR_CANT_SORT (INT64_C(1) << 34)
631
Engine is capable of row-format and statement-format logging,
634
#define HA_BINLOG_ROW_CAPABLE (INT64_C(1) << 35)
635
#define HA_BINLOG_STMT_CAPABLE (INT64_C(1) << 36)
637
#define HA_ONLINE_ALTER (INT64_C(1) << 37)
640
Set of all binlog flags. Currently only contain the capabilities
643
#define HA_BINLOG_FLAGS (HA_BINLOG_ROW_CAPABLE | HA_BINLOG_STMT_CAPABLE)
645
/* bits in index_flags(index_number) for what you can do with index */
646
#define HA_READ_NEXT 1 /* TODO really use this flag */
647
#define HA_READ_PREV 2 /* supports ::index_prev */
648
#define HA_READ_ORDER 4 /* index_next/prev follow sort order */
649
#define HA_READ_RANGE 8 /* can find all records in a range */
650
#define HA_ONLY_WHOLE_INDEX 16 /* Can't use part key searches */
651
#define HA_KEYREAD_ONLY 64 /* Support HA_EXTRA_KEYREAD */
653
Index scan will not return records in rowid order. Not guaranteed to be
654
set for unordered (e.g. HASH) indexes.
656
#define HA_KEY_SCAN_NOT_ROR 128
657
#define HA_DO_INDEX_COND_PUSHDOWN 256 /* Supports Index Condition Pushdown */
662
HA_PARTITION_FUNCTION_SUPPORTED indicates that the function is
664
HA_FAST_CHANGE_PARTITION means that optimised variants of the changes
665
exists but they are not necessarily done online.
667
HA_ONLINE_DOUBLE_WRITE means that the handler supports writing to both
668
the new partition and to the old partitions when updating through the
669
old partitioning schema while performing a change of the partitioning.
670
This means that we can support updating of the table while performing
671
the copy phase of the change. For no lock at all also a double write
672
from new to old must exist and this is not required when this flag is
674
This is actually removed even before it was introduced the first time.
675
The new idea is that handlers will handle the lock level already in
676
store_lock for ALTER Table partitions.
678
HA_PARTITION_ONE_PHASE is a flag that can be set by handlers that take
679
care of changing the partitions online and in one phase. Thus all phases
680
needed to handle the change are implemented inside the storage engine.
681
The storage engine must also support auto-discovery since the frm file
682
is changed as part of the change and this change must be controlled by
683
the storage engine. A typical engine to support this is NDB (through
686
#define HA_PARTITION_FUNCTION_SUPPORTED (1L << 1)
687
#define HA_FAST_CHANGE_PARTITION (1L << 2)
688
#define HA_PARTITION_ONE_PHASE (1L << 3)
690
/* operations for disable/enable indexes */
691
#define HA_KEY_SWITCH_NONUNIQ 0
692
#define HA_KEY_SWITCH_ALL 1
693
#define HA_KEY_SWITCH_NONUNIQ_SAVE 2
694
#define HA_KEY_SWITCH_ALL_SAVE 3
697
Note: the following includes binlog and closing 0.
698
so: innodb + bdb + ndb + binlog + myisam + myisammrg + archive +
699
example + csv + heap + blackhole + federated + 0
700
(yes, the sum is deliberately inaccurate)
701
TODO remove the limit, use dynarrays
706
Parameters for open() (in register form->filestat)
707
HA_GET_INFO does an implicit HA_ABORT_IF_LOCKED
710
#define HA_OPEN_KEYFILE 1
711
#define HA_OPEN_RNDFILE 2
712
#define HA_GET_INDEX 4
713
#define HA_GET_INFO 8 /* do a ha_info() after open */
714
#define HA_READ_ONLY 16 /* File opened as readonly */
715
/* Try readonly if can't open with read and write */
716
#define HA_TRY_READ_ONLY 32
717
#define HA_WAIT_IF_LOCKED 64 /* Wait if locked on open */
718
#define HA_ABORT_IF_LOCKED 128 /* skip if locked on open.*/
719
#define HA_BLOCK_LOCK 256 /* unlock when reading some records */
720
#define HA_OPEN_TEMPORARY 512
722
/* For transactional LOCK Table. handler::lock_table() */
723
#define HA_LOCK_IN_SHARE_MODE F_RDLCK
724
#define HA_LOCK_IN_EXCLUSIVE_MODE F_WRLCK
726
/* Some key definitions */
727
#define HA_KEY_NULL_LENGTH 1
728
#define HA_KEY_BLOB_LENGTH 2
730
#define HA_LEX_CREATE_TMP_TABLE 1
731
#define HA_LEX_CREATE_IF_NOT_EXISTS 2
732
#define HA_LEX_CREATE_TABLE_LIKE 4
733
#define HA_OPTION_NO_CHECKSUM (1L << 17)
734
#define HA_OPTION_NO_DELAY_KEY_WRITE (1L << 18)
735
#define HA_MAX_REC_LENGTH 65535
737
/* Table caching type */
738
#define HA_CACHE_TBL_NONTRANSACT 0
739
#define HA_CACHE_TBL_NOCACHE 1
740
#define HA_CACHE_TBL_ASKTRANSACT 2
741
#define HA_CACHE_TBL_TRANSACT 4
743
/* Options of START TRANSACTION statement (and later of SET TRANSACTION stmt) */
744
#define DRIZZLE_START_TRANS_OPT_WITH_CONS_SNAPSHOT 1
746
/* Flags for method is_fatal_error */
747
#define HA_CHECK_DUP_KEY 1
748
#define HA_CHECK_DUP_UNIQUE 2
749
#define HA_CHECK_DUP (HA_CHECK_DUP_KEY + HA_CHECK_DUP_UNIQUE)
754
DB_TYPE_FIRST_DYNAMIC=42,
755
DB_TYPE_DEFAULT=127 // Must be last
758
enum row_type { ROW_TYPE_NOT_USED=-1, ROW_TYPE_DEFAULT, ROW_TYPE_FIXED,
759
ROW_TYPE_DYNAMIC, ROW_TYPE_COMPRESSED,
760
ROW_TYPE_REDUNDANT, ROW_TYPE_COMPACT, ROW_TYPE_PAGE };
762
enum column_format_type { COLUMN_FORMAT_TYPE_NOT_USED= -1,
763
COLUMN_FORMAT_TYPE_DEFAULT= 0,
764
COLUMN_FORMAT_TYPE_FIXED= 1,
765
COLUMN_FORMAT_TYPE_DYNAMIC= 2 };
767
enum enum_binlog_func {
772
BFN_BINLOG_PURGE_FILE= 5
775
enum enum_binlog_command {
785
/* struct to hold information about the table that should be created */
787
/* Bits in used_fields */
788
#define HA_CREATE_USED_AUTO (1L << 0)
790
#define HA_CREATE_USED_UNION (1L << 2)
791
#define HA_CREATE_USED_PASSWORD (1L << 17)
793
#define HA_CREATE_USED_INSERT_METHOD (1L << 3)
794
#define HA_CREATE_USED_MIN_ROWS (1L << 4)
795
#define HA_CREATE_USED_MAX_ROWS (1L << 5)
796
#define HA_CREATE_USED_AVG_ROW_LENGTH (1L << 6)
797
#define HA_CREATE_USED_PACK_KEYS (1L << 7)
798
#define HA_CREATE_USED_CHARSET (1L << 8)
799
#define HA_CREATE_USED_DEFAULT_CHARSET (1L << 9)
800
#define HA_CREATE_USED_DATADIR (1L << 10)
801
#define HA_CREATE_USED_INDEXDIR (1L << 11)
802
#define HA_CREATE_USED_ENGINE (1L << 12)
803
#define HA_CREATE_USED_CHECKSUM (1L << 13)
804
#define HA_CREATE_USED_DELAY_KEY_WRITE (1L << 14)
805
#define HA_CREATE_USED_ROW_FORMAT (1L << 15)
806
#define HA_CREATE_USED_COMMENT (1L << 16)
807
#define HA_CREATE_USED_CONNECTION (1L << 18)
808
#define HA_CREATE_USED_KEY_BLOCK_SIZE (1L << 19)
809
#define HA_CREATE_USED_PAGE_CHECKSUM (1L << 21)
810
#define HA_CREATE_USED_BLOCK_SIZE (1L << 22)
812
#define MAXGTRIDSIZE 64
813
#define MAXBQUALSIZE 64
815
#define COMPATIBLE_DATA_YES 0
816
#define COMPATIBLE_DATA_NO 1
818
#define UNDEF_NODEGROUP 65535
819
#define NOT_A_PARTITION_ID ((uint32_t)-1)
821
enum ha_choice { HA_CHOICE_UNDEF, HA_CHOICE_NO, HA_CHOICE_YES };
824
The below two are not used (and not handled) in this milestone of this WL
825
entry because there seems to be no use for them at this stage of
828
#define HA_MRR_SINGLE_POINT 1
829
#define HA_MRR_FIXED_KEY 2
832
Indicates that RANGE_SEQ_IF::next(&range) doesn't need to fill in the
835
#define HA_MRR_NO_ASSOCIATION 4
838
The MRR user will provide ranges in key order, and MRR implementation
839
must return rows in key order.
841
#define HA_MRR_SORTED 8
843
/* MRR implementation doesn't have to retrieve full records */
844
#define HA_MRR_INDEX_ONLY 16
847
The passed memory buffer is of maximum possible size, the caller can't
848
assume larger buffer.
850
#define HA_MRR_LIMITS 32
854
Flag set <=> default MRR implementation is used
855
(The choice is made by **_info[_const]() function which may set this
856
flag. SQL layer remembers the flag value and then passes it to
857
multi_read_range_init().
859
#define HA_MRR_USE_DEFAULT_IMPL 64
862
Used only as parameter to multi_range_read_info():
863
Flag set <=> the caller guarantees that the bounds of the scanned ranges
864
will not have NULL values.
866
#define HA_MRR_NO_NULL_ENDPOINTS 128
868
enum enum_ha_read_modes { RFIRST, RNEXT, RPREV, RLAST, RKEY, RNEXT_SAME };
870
enum enum_tx_isolation { ISO_READ_UNCOMMITTED, ISO_READ_COMMITTED,
871
ISO_REPEATABLE_READ, ISO_SERIALIZABLE};
874
enum SHOW_COMP_OPTION { SHOW_OPTION_YES, SHOW_OPTION_NO, SHOW_OPTION_DISABLED};
877
#define MYF(v) (myf) (v)
880
When a command is added here, be sure it's also added in mysqld.cc
881
in "struct show_var_st status_vars[]= {" ...
883
If the command returns a result set or is not allowed in stored
884
functions or triggers, please also make sure that
885
sp_get_flags_for_command (sp_head.cc) returns proper flags for the
889
enum enum_sql_command {
890
SQLCOM_SELECT, SQLCOM_CREATE_TABLE, SQLCOM_CREATE_INDEX, SQLCOM_ALTER_TABLE,
891
SQLCOM_UPDATE, SQLCOM_INSERT, SQLCOM_INSERT_SELECT,
892
SQLCOM_DELETE, SQLCOM_TRUNCATE, SQLCOM_DROP_TABLE, SQLCOM_DROP_INDEX,
893
SQLCOM_SHOW_DATABASES, SQLCOM_SHOW_TABLES, SQLCOM_SHOW_FIELDS,
894
SQLCOM_SHOW_KEYS, SQLCOM_SHOW_VARIABLES, SQLCOM_SHOW_STATUS,
895
SQLCOM_SHOW_ENGINE_LOGS, SQLCOM_SHOW_ENGINE_STATUS, SQLCOM_SHOW_ENGINE_MUTEX,
896
SQLCOM_SHOW_PROCESSLIST, SQLCOM_SHOW_MASTER_STAT, SQLCOM_SHOW_SLAVE_STAT,
898
SQLCOM_SHOW_CREATE_DB,
899
SQLCOM_SHOW_TABLE_STATUS,
900
SQLCOM_LOAD,SQLCOM_SET_OPTION,SQLCOM_LOCK_TABLES,SQLCOM_UNLOCK_TABLES,
901
SQLCOM_CHANGE_DB, SQLCOM_CREATE_DB, SQLCOM_DROP_DB, SQLCOM_ALTER_DB,
902
SQLCOM_REPAIR, SQLCOM_REPLACE, SQLCOM_REPLACE_SELECT,
903
SQLCOM_OPTIMIZE, SQLCOM_CHECK,
904
SQLCOM_ASSIGN_TO_KEYCACHE,
905
SQLCOM_FLUSH, SQLCOM_KILL, SQLCOM_ANALYZE,
906
SQLCOM_ROLLBACK, SQLCOM_ROLLBACK_TO_SAVEPOINT,
907
SQLCOM_COMMIT, SQLCOM_SAVEPOINT, SQLCOM_RELEASE_SAVEPOINT,
908
SQLCOM_SLAVE_START, SQLCOM_SLAVE_STOP,
909
SQLCOM_BEGIN, SQLCOM_CHANGE_MASTER,
911
SQLCOM_RESET, SQLCOM_PURGE, SQLCOM_PURGE_BEFORE, SQLCOM_SHOW_BINLOGS,
912
SQLCOM_SHOW_OPEN_TABLES,
913
SQLCOM_DELETE_MULTI, SQLCOM_UPDATE_MULTI,
918
SQLCOM_BINLOG_BASE64_EVENT,
921
When a command is added here, be sure it's also added in mysqld.cc
922
in "struct show_var_st status_vars[]= {" ...
924
/* This should be the last !!! */
928
enum enum_duplicates { DUP_ERROR, DUP_REPLACE, DUP_UPDATE };
930
enum release_type { RELEASE_NORMAL, RELEASE_WAIT_FOR_DROP };
933
Make sure that the order of schema_tables and enum_schema_tables are the same.
936
enum enum_schema_tables
940
SCH_COLLATION_CHARACTER_SET_APPLICABILITY,
943
SCH_GLOBAL_VARIABLES,
944
SCH_KEY_COLUMN_USAGE,
948
SCH_REFERENTIAL_CONSTRAINTS,
951
SCH_SESSION_VARIABLES,
955
SCH_TABLE_CONSTRAINTS,
961
#define MY_I_S_MAYBE_NULL 1
962
#define MY_I_S_UNSIGNED 2
965
#define SKIP_OPEN_TABLE 0 // do not open table
966
#define OPEN_FRM_ONLY 1 // open FRM file only
967
#define OPEN_FULL_TABLE 2 // open FRM,MYD, MYI files
970
"Declared Type Collation"
971
A combination of collation and its derivation.
973
Flags for collation aggregation modes:
974
MY_COLL_ALLOW_SUPERSET_CONV - allow conversion to a superset
975
MY_COLL_ALLOW_COERCIBLE_CONV - allow conversion of a coercible value
977
MY_COLL_ALLOW_CONV - allow any kind of conversion
978
(combination of the above two)
979
MY_COLL_DISALLOW_NONE - don't allow return DERIVATION_NONE
980
(e.g. when aggregating for comparison)
981
MY_COLL_CMP_CONV - combination of MY_COLL_ALLOW_CONV
982
and MY_COLL_DISALLOW_NONE
985
#define MY_COLL_ALLOW_SUPERSET_CONV 1
986
#define MY_COLL_ALLOW_COERCIBLE_CONV 2
987
#define MY_COLL_ALLOW_CONV 3
988
#define MY_COLL_DISALLOW_NONE 4
989
#define MY_COLL_CMP_CONV 7
993
This enum is used to report information about monotonicity of function
994
represented by Item* tree.
995
Monotonicity is defined only for Item* trees that represent table
996
partitioning expressions (i.e. have no subselects/user vars/PS parameters
997
etc etc). An Item* tree is assumed to have the same monotonicity properties
998
as its correspoinding function F:
1000
[signed] int64_t F(field1, field2, ...) {
1001
put values of field_i into table record buffer;
1002
return item->val_int();
1006
At the moment function monotonicity is not well defined (and so may be
1007
incorrect) for Item trees with parameters/return types that are different
1008
from INT_RESULT, may be NULL, or are unsigned.
1009
It will be possible to address this issue once the related partitioning bugs
1010
(BUG#16002, BUG#15447, BUG#13436) are fixed.
1013
typedef enum monotonicity_info
1015
NON_MONOTONIC, /* none of the below holds */
1016
MONOTONIC_INCREASING, /* F() is unary and (x < y) => (F(x) <= F(y)) */
1017
MONOTONIC_STRICT_INCREASING /* F() is unary and (x < y) => (F(x) < F(y)) */
1018
} enum_monotonicity_info;
1022
NO_TMP_TABLE, NON_TRANSACTIONAL_TMP_TABLE, TRANSACTIONAL_TMP_TABLE,
1023
INTERNAL_TMP_TABLE, SYSTEM_TMP_TABLE, TMP_TABLE_FRM_FILE_ONLY
1027
Values in this enum are used to indicate how a tables TIMESTAMP field
1028
should be treated. It can be set to the current timestamp on insert or
1030
WARNING: The values are used for bit operations. If you change the
1031
enum, you must keep the bitwise relation of the values. For example:
1032
(int) TIMESTAMP_AUTO_SET_ON_BOTH must be equal to
1033
(int) TIMESTAMP_AUTO_SET_ON_INSERT | (int) TIMESTAMP_AUTO_SET_ON_UPDATE.
1034
We use an enum here so that the debugger can display the value names.
1036
enum timestamp_auto_set_type
1038
TIMESTAMP_NO_AUTO_SET= 0, TIMESTAMP_AUTO_SET_ON_INSERT= 1,
1039
TIMESTAMP_AUTO_SET_ON_UPDATE= 2, TIMESTAMP_AUTO_SET_ON_BOTH= 3
1041
#define clear_timestamp_auto_bits(_target_, _bits_) \
1042
(_target_)= (enum timestamp_auto_set_type)((int)(_target_) & ~(int)(_bits_))
1045
Category of table found in the table share.
1047
enum enum_table_category
1052
TABLE_UNKNOWN_CATEGORY=0,
1056
The table is visible only in the session.
1058
- FLUSH TABLES WITH READ LOCK
1059
- SET GLOBAL READ_ONLY = ON
1060
do not apply to this table.
1061
Note that LOCK Table t FOR READ/WRITE
1062
can be used on temporary tables.
1063
Temporary tables are not part of the table cache.
1065
TABLE_CATEGORY_TEMPORARY=1,
1069
These tables do honor:
1070
- LOCK Table t FOR READ/WRITE
1071
- FLUSH TABLES WITH READ LOCK
1072
- SET GLOBAL READ_ONLY = ON
1073
User tables are cached in the table cache.
1075
TABLE_CATEGORY_USER=2,
1078
Information schema tables.
1079
These tables are an interface provided by the system
1080
to inspect the system metadata.
1081
These tables do *not* honor:
1082
- LOCK Table t FOR READ/WRITE
1083
- FLUSH TABLES WITH READ LOCK
1084
- SET GLOBAL READ_ONLY = ON
1085
as there is no point in locking explicitely
1086
an INFORMATION_SCHEMA table.
1087
Nothing is directly written to information schema tables.
1088
Note that this value is not used currently,
1089
since information schema tables are not shared,
1090
but implemented as session specific temporary tables.
1093
TODO: Fixing the performance issues of I_S will lead
1094
to I_S tables in the table cache, which should use
1097
TABLE_CATEGORY_INFORMATION
1100
/* Information for one open table */
1101
enum index_hint_type
1109
enum enum_enable_or_disable { LEAVE_AS_IS, ENABLE, DISABLE };
1110
enum enum_delay_key_write { DELAY_KEY_WRITE_NONE, DELAY_KEY_WRITE_ON,
1111
DELAY_KEY_WRITE_ALL };
1112
enum enum_slave_exec_mode { SLAVE_EXEC_MODE_STRICT,
1113
SLAVE_EXEC_MODE_IDEMPOTENT,
1114
SLAVE_EXEC_MODE_LAST_BIT};
1115
enum enum_mark_columns
1116
{ MARK_COLUMNS_NONE, MARK_COLUMNS_READ, MARK_COLUMNS_WRITE};
1118
enum enum_filetype { FILETYPE_CSV, FILETYPE_XML };
1120
enum find_item_error_report_type {REPORT_ALL_ERRORS, REPORT_EXCEPT_NOT_FOUND,
1121
IGNORE_ERRORS, REPORT_EXCEPT_NON_UNIQUE,
1122
IGNORE_EXCEPT_NON_UNIQUE};
1124
enum enum_schema_table_state
1127
PROCESSED_BY_CREATE_SORT_INDEX,
1128
PROCESSED_BY_JOIN_EXEC
1132
* The following are for the interface with the .frm file
1135
#define FIELDFLAG_DECIMAL 1
1136
#define FIELDFLAG_BINARY 1 // Shares same flag
1137
#define FIELDFLAG_NUMBER 2
1138
#define FIELDFLAG_DECIMAL_POSITION 4
1139
#define FIELDFLAG_PACK 120 // Bits used for packing
1140
#define FIELDFLAG_INTERVAL 256 // mangled with decimals!
1141
#define FIELDFLAG_BLOB 1024 // mangled with decimals!
1143
#define FIELDFLAG_NO_DEFAULT 16384 /* sql */
1144
#define FIELDFLAG_SUM ((uint32_t) 32768)// predit: +#fieldflag
1145
#define FIELDFLAG_MAYBE_NULL ((uint32_t) 32768)// sql
1146
#define FIELDFLAG_HEX_ESCAPE ((uint32_t) 0x10000)
1147
#define FIELDFLAG_PACK_SHIFT 3
1148
#define FIELDFLAG_DEC_SHIFT 8
1149
#define FIELDFLAG_MAX_DEC 31
1151
#define MTYP_TYPENR(type) (type & 127) /* Remove bits from type */
1153
#define f_is_dec(x) ((x) & FIELDFLAG_DECIMAL)
1154
#define f_is_num(x) ((x) & FIELDFLAG_NUMBER)
1155
#define f_is_decimal_precision(x) ((x) & FIELDFLAG_DECIMAL_POSITION)
1156
#define f_is_packed(x) ((x) & FIELDFLAG_PACK)
1157
#define f_packtype(x) (((x) >> FIELDFLAG_PACK_SHIFT) & 15)
1158
#define f_decimals(x) ((uint8_t) (((x) >> FIELDFLAG_DEC_SHIFT) & \
1160
#define f_is_alpha(x) (!f_is_num(x))
1161
#define f_is_binary(x) ((x) & FIELDFLAG_BINARY) // 4.0- compatibility
1162
#define f_is_enum(x) (((x) & (FIELDFLAG_INTERVAL | FIELDFLAG_NUMBER)) == \
1164
#define f_is_blob(x) (((x) & (FIELDFLAG_BLOB | FIELDFLAG_NUMBER)) == \
1166
#define f_is_equ(x) ((x) & (1+2+FIELDFLAG_PACK+31*256))
1167
#define f_settype(x) (((int) x) << FIELDFLAG_PACK_SHIFT)
1168
#define f_maybe_null(x) (x & FIELDFLAG_MAYBE_NULL)
1169
#define f_no_default(x) (x & FIELDFLAG_NO_DEFAULT)
1170
#define f_is_hex_escape(x) ((x) & FIELDFLAG_HEX_ESCAPE)
1172
384
#endif /* DRIZZLE_SERVER_DEFINITIONS_H */