Field_temporal_with_date Class Reference

#include <field.h>

Inheritance diagram for Field_temporal_with_date:

Collaboration diagram for Field_temporal_with_date:

Public Member Functions
	Field_temporal_with_date (uchar *ptr_arg, uchar *null_ptr_arg, uchar null_bit_arg, enum utype unireg_check_arg, const char *field_name_arg, uint8 int_length_arg, uint8 dec_arg)
	Field_temporal_with_date (bool maybe_null_arg, const char *field_name_arg, uint int_length_arg, uint8 dec_arg)
bool	send_binary (Protocol *protocol)
type_conversion_status	store_time (MYSQL_TIME *ltime, uint8 dec)
String *	val_str (String *, String *)
longlong	val_time_temporal ()
longlong	val_date_temporal ()
bool	get_time (MYSQL_TIME *ltime)
virtual type_conversion_status	validate_stored_val (THD *thd)
Public Member Functions inherited from Field_temporal
	Field_temporal (uchar *ptr_arg, uchar *null_ptr_arg, uchar null_bit_arg, enum utype unireg_check_arg, const char *field_name_arg, uint32 len_arg, uint8 dec_arg)
	Field_temporal (bool maybe_null_arg, const char *field_name_arg, uint32 len_arg, uint8 dec_arg)
virtual Item_result	result_type () const
virtual uint32	max_display_length ()
virtual bool	str_needs_quotes ()
virtual uint	is_equal (Create_field *new_field)
Item_result	numeric_context_result_type () const
enum Item_result	cmp_type () const
enum Derivation	derivation () const
uint	repertoire () const
const CHARSET_INFO *	charset () const
bool	can_be_compared_as_longlong () const
bool	binary () const
type_conversion_status	store (const char *str, uint len, const CHARSET_INFO *cs)
type_conversion_status	store_decimal (const my_decimal *decimal)
type_conversion_status	store (longlong nr, bool unsigned_val)
type_conversion_status	store (double nr)
double	val_real ()
my_decimal *	val_decimal (my_decimal *decimal_value)
Public Member Functions inherited from Field
bool	has_insert_default_function () const
bool	has_update_default_function () const
	Field (uchar *ptr_arg, uint32 length_arg, uchar *null_ptr_arg, uchar null_bit_arg, utype unireg_check_arg, const char *field_name_arg)
	This is used as a table name when the table structure is not set up.
virtual type_conversion_status	store_packed (longlong nr)
type_conversion_status	store_time (MYSQL_TIME *ltime)
type_conversion_status	store (const char *to, uint length, const CHARSET_INFO *cs, enum_check_fields check_level)
virtual longlong	val_int (void)=0
longlong	val_temporal_by_field_type ()
String *	val_str (String *str)
String *	val_int_as_str (String *val_buffer, my_bool unsigned_flag)
virtual Item_result	cast_to_int_type () const
virtual bool	eq (Field *field)
virtual bool	eq_def (Field *field)
virtual uint32	pack_length () const
virtual uint32	pack_length_in_rec () const
virtual bool	compatible_field_size (uint metadata, Relay_log_info *rli, uint16 mflags, int *order)
virtual uint	pack_length_from_metadata (uint field_metadata)
virtual uint	row_pack_length () const
virtual int	save_field_metadata (uchar *first_byte)
virtual uint32	data_length ()
virtual uint32	sort_length () const
virtual uint32	max_data_length () const
virtual type_conversion_status	reset (void)
virtual void	reset_fields ()
virtual bool	get_timestamp (struct timeval *tm, int *warnings)
virtual void	store_timestamp (const timeval *tm)
void	store_timestamp (my_time_t sec)
virtual void	set_default ()
void	evaluate_insert_default_function ()
void	evaluate_update_default_function ()
virtual bool	zero_pack () const
virtual enum ha_base_keytype	key_type () const
virtual uint32	key_length () const
virtual enum_field_types	type () const =0
virtual enum_field_types	real_type () const
virtual enum_field_types	binlog_type () const
int	cmp (const uchar *str)
virtual int	cmp_max (const uchar *a, const uchar *b, uint max_len)
virtual int	cmp (const uchar *, const uchar *)=0
virtual int	cmp_binary (const uchar *a, const uchar *b, uint32 max_length=~0L)
virtual int	cmp_offset (uint row_offset)
virtual int	cmp_binary_offset (uint row_offset)
virtual int	key_cmp (const uchar *a, const uchar *b)
virtual int	key_cmp (const uchar *str, uint length)
virtual uint	decimals () const
virtual void	sql_type (String &str) const =0
bool	is_temporal () const
bool	is_temporal_with_date () const
bool	is_temporal_with_time () const
bool	is_temporal_with_date_and_time () const
bool	is_null (my_ptrdiff_t row_offset=0) const
bool	is_real_null (my_ptrdiff_t row_offset=0) const
bool	is_null_in_record (const uchar *record) const
void	set_null (my_ptrdiff_t row_offset=0)
void	set_notnull (my_ptrdiff_t row_offset=0)
bool	maybe_null (void) const
bool	real_maybe_null (void) const
uint	null_offset (const uchar *record) const
uint	null_offset () const
void	set_null_ptr (uchar *p_null_ptr, uint p_null_bit)
size_t	last_null_byte () const
virtual void	make_field (Send_field *)
virtual void	make_sort_key (uchar *buff, uint length)=0
virtual bool	optimize_range (uint idx, uint part)
virtual void	free ()
virtual Field *	new_field (MEM_ROOT *root, TABLE *new_table, bool keep_type)
virtual Field *	new_key_field (MEM_ROOT *root, TABLE *new_table, uchar *new_ptr, uchar *new_null_ptr, uint new_null_bit)
Field *	new_key_field (MEM_ROOT *root, TABLE *new_table, uchar *new_ptr)
virtual Field *	clone () const =0
virtual Field *	clone (MEM_ROOT *mem_root) const =0
void	move_field (uchar *ptr_arg, uchar *null_ptr_arg, uchar null_bit_arg)
void	move_field (uchar *ptr_arg)
virtual void	move_field_offset (my_ptrdiff_t ptr_diff)
virtual void	get_image (uchar *buff, uint length, const CHARSET_INFO *cs)
virtual void	set_image (const uchar *buff, uint length, const CHARSET_INFO *cs)
virtual uint	get_key_image (uchar *buff, uint length, imagetype type)
virtual void	set_key_image (const uchar *buff, uint length)
longlong	val_int_offset (uint row_offset)
longlong	val_int (const uchar *new_ptr)
String *	val_str (String *str, const uchar *new_ptr)
virtual uchar *	pack (uchar *to, const uchar *from, uint max_length, bool low_byte_first)
uchar *	pack (uchar *to, const uchar *from)
virtual const uchar *	unpack (uchar *to, const uchar *from, uint param_data, bool low_byte_first)
const uchar *	unpack (uchar *to, const uchar *from)
virtual uint	packed_col_length (const uchar *to, uint length)
virtual uint	max_packed_col_length (uint max_length)
uint	offset (uchar *record)
void	copy_from_tmp (int offset)
uint	fill_cache_field (struct st_cache_field *copy)
virtual bool	get_date (MYSQL_TIME *ltime, uint fuzzydate)
virtual const CHARSET_INFO *	charset_for_protocol (void) const
virtual const CHARSET_INFO *	sort_charset (void) const
virtual bool	has_charset (void) const
virtual bool	match_collation_to_optimize_range () const
virtual void	set_derivation (enum Derivation derivation_arg)
bool	set_warning (Sql_condition::enum_warning_level, unsigned int code, int cuted_increment) const
bool	check_overflow (int op_result)
bool	check_truncated (int op_result)
bool	warn_if_overflow (int op_result)
void	init (TABLE *table_arg)
longlong	convert_decimal2longlong (const my_decimal *val, bool unsigned_flag, bool *has_overflow)
virtual uint32	char_length ()
virtual geometry_type	get_geometry_type ()
void	dbug_print ()
ha_storage_media	field_storage_type () const
void	set_storage_type (ha_storage_media storage_type_arg)
column_format_type	column_format () const
void	set_column_format (column_format_type column_format_arg)
virtual void	hash (ulong *nr, ulong *nr2)

Protected Member Functions
virtual bool	get_date_internal (MYSQL_TIME *ltime)=0
bool	get_internal_check_zero (MYSQL_TIME *ltime, uint fuzzydate)
type_conversion_status	convert_number_to_TIME (longlong nr, bool unsigned_val, int nanoseconds, MYSQL_TIME *ltime, int *warning)
bool	convert_str_to_TIME (const char *str, uint len, const CHARSET_INFO *cs, MYSQL_TIME *ltime, MYSQL_TIME_STATUS *status)
type_conversion_status	store_internal_with_round (MYSQL_TIME *ltime, int *warnings)
Protected Member Functions inherited from Field_temporal
uint8	normalize_dec (uint8 dec_arg)
virtual type_conversion_status	store_internal (const MYSQL_TIME *ltime, int *error)=0
type_conversion_status	store_lldiv_t (const lldiv_t *lld, int *warning)
longlong	convert_number_to_datetime (longlong nr, bool unsigned_val, MYSQL_TIME *ltime, int *warning)
void	set_warnings (ErrConvString str, int warnings)
virtual ulonglong	date_flags (const THD *thd)
ulonglong	date_flags ()
void	set_datetime_warning (Sql_condition::enum_warning_level level, uint code, ErrConvString str, timestamp_type ts_type, int cuted_increment)
Protected Member Functions inherited from Field
uchar *	pack_int16 (uchar *to, const uchar *from, bool low_byte_first_to)
const uchar *	unpack_int16 (uchar *to, const uchar *from, bool low_byte_first_from)
uchar *	pack_int24 (uchar *to, const uchar *from, bool low_byte_first_to)
const uchar *	unpack_int24 (uchar *to, const uchar *from, bool low_byte_first_from)
uchar *	pack_int32 (uchar *to, const uchar *from, bool low_byte_first_to)
const uchar *	unpack_int32 (uchar *to, const uchar *from, bool low_byte_first_from)
uchar *	pack_int64 (uchar *to, const uchar *from, bool low_byte_first_to)
const uchar *	unpack_int64 (uchar *to, const uchar *from, bool low_byte_first_from)
bool	field_flags_are_binary ()

Additional Inherited Members
Public Types inherited from Field
enum	utype {   NONE, DATE, SHIELD, NOEMPTY,   CASEUP, PNR, BGNR, PGNR,   YES, NO, REL, CHECK,   EMPTY, UNKNOWN_FIELD, CASEDN, NEXT_NUMBER,   INTERVAL_FIELD, BIT_FIELD, TIMESTAMP_OLD_FIELD, CAPITALIZE,   BLOB_FIELD, TIMESTAMP_DN_FIELD, TIMESTAMP_UN_FIELD, TIMESTAMP_DNUN_FIELD }
enum	geometry_type {   GEOM_GEOMETRY = 0, GEOM_POINT = 1, GEOM_LINESTRING = 2, GEOM_POLYGON = 3,   GEOM_MULTIPOINT = 4, GEOM_MULTILINESTRING = 5, GEOM_MULTIPOLYGON = 6, GEOM_GEOMETRYCOLLECTION = 7 }
enum	imagetype { itRAW, itMBR }
enum	{ LAST_NULL_BYTE_UNDEF = 0 }
Static Public Member Functions inherited from Field
static void *	operator new (size_t size) throw ()
static void *	operator new (size_t size, MEM_ROOT *mem_root) throw ()
static void	operator delete (void *ptr, MEM_ROOT *mem_root)
static void	operator delete (void *ptr_arg, size_t size) throw ()
static bool	type_can_have_key_part (enum_field_types)
static enum_field_types	field_type_merge (enum_field_types, enum_field_types)
static Item_result	result_merge_type (enum_field_types)
Public Attributes inherited from Field
uchar *	ptr
TABLE *	table
TABLE *	orig_table
const char **	table_name
const char *	field_name
LEX_STRING	comment
key_map	key_start
key_map	part_of_key
key_map	part_of_key_not_clustered
key_map	part_of_sortkey
utype	unireg_check
uint32	field_length
uint32	flags
uint16	field_index
uchar	null_bit
bool	is_created_from_null_item
Static Protected Member Functions inherited from Field
static void	handle_int16 (uchar *to, const uchar *from, bool low_byte_first_from, bool low_byte_first_to)
static void	handle_int24 (uchar *to, const uchar *from, bool low_byte_first_from, bool low_byte_first_to)
static void	handle_int32 (uchar *to, const uchar *from, bool low_byte_first_from, bool low_byte_first_to)
static void	handle_int64 (uchar *to, const uchar *from, bool low_byte_first_from, bool low_byte_first_to)
Protected Attributes inherited from Field_temporal
uint8	dec

Detailed Description

Abstract class for types with date with optional time, with or without fractional part: DATE, DATETIME, DATETIME(N), TIMESTAMP, TIMESTAMP(N).

Definition at line 2325 of file field.h.

Constructor & Destructor Documentation

Field_temporal_with_date::Field_temporal_with_date ( uchar *  ptr_arg, uchar *  null_ptr_arg, uchar  null_bit_arg, enum utype  unireg_check_arg, const char *  field_name_arg, uint8  int_length_arg, uint8  dec_arg  )

inline

Constructor for Field_temporal

Parameters

ptr_arg	See Field definition
null_ptr_arg	See Field definition
null_bit_arg	See Field definition
unireg_check_arg	See Field definition
field_name_arg	See Field definition
len_arg	Number of characters in the integer part.
dec_arg	Number of second fraction digits, 0..6.

Definition at line 2359 of file field.h.

Field_temporal_with_date::Field_temporal_with_date ( bool  maybe_null_arg, const char *  field_name_arg, uint  int_length_arg, uint8  dec_arg  )

inline

Constructor for Field_temporal

Parameters

maybe_null_arg	See Field definition
field_name_arg	See Field definition
len_arg	Number of characters in the integer part.
dec_arg	Number of second fraction digits, 0..6.

Definition at line 2375 of file field.h.

Member Function Documentation

type_conversion_status Field_temporal_with_date::convert_number_to_TIME ( longlong  nr, bool  unsigned_val, int  nanoseconds, MYSQL_TIME *  ltime, int *  warning  )

protectedvirtual

Convert a number with fractional part with nanosecond precision into MYSQL_TIME, according to the field type. Nanoseconds are rounded to milliseconds and added to ltime->second_part.

Parameters

IN	nr Number
IN	unsigned_val SIGNED/UNSIGNED flag
IN	nanoseconds Fractional part in nanoseconds
OUT	ltime The value is stored here
OUT	status Conversion status

Return values

false	On success
true	On error

Implements Field_temporal.

Definition at line 5058 of file field.cc.

bool Field_temporal_with_date::convert_str_to_TIME ( const char *  str, uint  len, const CHARSET_INFO *  cs, MYSQL_TIME *  ltime, MYSQL_TIME_STATUS *  status  )

protectedvirtual

Convert a string to MYSQL_TIME, according to the field type.

Parameters

IN	str String
IN	len String length
IN	cs String character set
OUT	ltime The value is stored here
OUT	status Conversion status

Return values

false	Conversion went fine, ltime contains a valid time
true	Conversion failed, ltime was reset and contains nothing

Implements Field_temporal.

Definition at line 5139 of file field.cc.

virtual bool Field_temporal_with_date::get_date_internal ( MYSQL_TIME *  ltime )

protectedpure virtual

Low level function to get value into MYSQL_TIME, without checking for being valid.

Implemented in Field_datetimef, Field_datetime, Field_newdate, Field_timestampf, and Field_timestamp.

bool Field_temporal_with_date::get_internal_check_zero ( MYSQL_TIME *  ltime, uint  fuzzydate  )

protected

Get value into MYSQL_TIME and check TIME_NO_ZERO_DATE flag.

Return values

True	on error: we get a zero value but flags disallow zero dates.
False	on success.

Definition at line 4956 of file field.cc.

type_conversion_status Field_temporal_with_date::store_internal_with_round ( MYSQL_TIME *  ltime, int *  warnings  )

protectedvirtual

Low level routine to store a MYSQL_TIME value into a field with rounding according to the field decimals() value.

Parameters

IN	ltime MYSQL_TIME value.
OUT	error Error flag vector, set in case of error.

Return values

false	In case of success.
true	In case of error.

Implements Field_temporal.

Definition at line 5162 of file field.cc.

type_conversion_status Field_temporal_with_date::store_time ( MYSQL_TIME *  ltime, uint8  dec_arg  )

virtual

Store MYSQL_TIME value with the given amount of decimal digits into a field.

Note, the "dec" parameter represents number of digits of the Item that previously created the MYSQL_TIME value. It's needed when we store the value into a CHAR/VARCHAR/TEXT field to display the proper amount of fractional digits. For other field types the "dec" value does not matter and is ignored.

Parameters

ltime	Time, date or datetime value.
dec	Number of decimals in ltime.

Return values

false	on success
true	on error

This is called when storing a date in a string.

Note

Needs to be changed if/when we want to support different time formats.

Reimplemented from Field.

Definition at line 5091 of file field.cc.

Here is the caller graph for this function:

longlong Field_temporal_with_date::val_date_temporal ( )

virtual

Returns DATE/DATETIME value in packed longlong format. This method should not be called for non-temporal types. Temporal field types override the default method.

Reimplemented from Field.

Reimplemented in Field_datetimef, and Field_newdate.

Definition at line 4970 of file field.cc.

longlong Field_temporal_with_date::val_time_temporal ( )

virtual

Returns TIME value in packed longlong format. This method should not be called for non-temporal types. Temporal field types override the default method.

Reimplemented from Field.

Reimplemented in Field_newdate.

Definition at line 4979 of file field.cc.

type_conversion_status Field_temporal_with_date::validate_stored_val ( THD *  thd )

virtual

Validate date value stored in the field.

Now we check whether date value is zero or has zero in date or not and set warning/error message appropriately(depending on the sql_mode).

Reimplemented from Field.

Reimplemented in Field_timestampf, and Field_timestamp.

Definition at line 5181 of file field.cc.

Here is the caller graph for this function:

---

The documentation for this class was generated from the following files:

• sql/field.h
• sql/field.cc