574.3.14
by Lee
moving functions from item_timefunc to functions/time directory |
1 |
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
|
2 |
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
|
|
3 |
*
|
|
4 |
* Copyright (C) 2008 Sun Microsystems
|
|
5 |
*
|
|
6 |
* This program is free software; you can redistribute it and/or modify
|
|
7 |
* it under the terms of the GNU General Public License as published by
|
|
8 |
* the Free Software Foundation; version 2 of the License.
|
|
9 |
*
|
|
10 |
* This program is distributed in the hope that it will be useful,
|
|
11 |
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
12 |
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
13 |
* GNU General Public License for more details.
|
|
14 |
*
|
|
15 |
* You should have received a copy of the GNU General Public License
|
|
16 |
* along with this program; if not, write to the Free Software
|
|
17 |
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
|
|
18 |
*/
|
|
19 |
||
813.1.8
by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors |
20 |
#include "drizzled/server_includes.h" |
574.3.14
by Lee
moving functions from item_timefunc to functions/time directory |
21 |
#include CSTDINT_H
|
813.1.8
by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors |
22 |
#include "drizzled/temporal.h" |
23 |
#include "drizzled/error.h" |
|
24 |
#include "drizzled/session.h" |
|
25 |
#include "drizzled/function/time/month.h" |
|
574.3.14
by Lee
moving functions from item_timefunc to functions/time directory |
26 |
|
27 |
int64_t Item_func_month::val_int() |
|
28 |
{
|
|
813.1.8
by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors |
29 |
assert(fixed); |
30 |
||
31 |
if (args[0]->is_null()) |
|
32 |
{
|
|
33 |
/* For NULL argument, we return a NULL result */
|
|
34 |
null_value= true; |
|
35 |
return 0; |
|
36 |
}
|
|
37 |
||
38 |
/* Grab the first argument as a DateTime object */
|
|
39 |
drizzled::DateTime temporal; |
|
40 |
Item_result arg0_result_type= args[0]->result_type(); |
|
41 |
||
42 |
switch (arg0_result_type) |
|
43 |
{
|
|
813.1.19
by Jay Pipes
To remain in compatibility with MySQL, added ability to interpret |
44 |
case DECIMAL_RESULT: |
45 |
/*
|
|
46 |
* For doubles supplied, interpret the arg as a string,
|
|
47 |
* so intentionally fall-through here...
|
|
48 |
* This allows us to accept double parameters like
|
|
49 |
* 19971231235959.01 and interpret it the way MySQL does:
|
|
50 |
* as a TIMESTAMP-like thing with a microsecond component.
|
|
51 |
* Ugh, but need to keep backwards-compat.
|
|
52 |
*/
|
|
813.1.8
by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors |
53 |
case STRING_RESULT: |
54 |
{
|
|
813.1.14
by Jay Pipes
Quick fix for shadowing problem in second.cc |
55 |
char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING]; |
813.1.8
by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors |
56 |
String tmp(buff,sizeof(buff), &my_charset_utf8_bin); |
57 |
String *res= args[0]->val_str(&tmp); |
|
58 |
if (! temporal.from_string(res->c_ptr(), res->length())) |
|
59 |
{
|
|
60 |
/*
|
|
61 |
* Could not interpret the function argument as a temporal value,
|
|
62 |
* so throw an error and return 0
|
|
63 |
*/
|
|
64 |
my_error(ER_INVALID_DATETIME_VALUE, MYF(0), res->c_ptr()); |
|
65 |
return 0; |
|
66 |
}
|
|
67 |
}
|
|
68 |
break; |
|
69 |
case INT_RESULT: |
|
813.1.14
by Jay Pipes
Quick fix for shadowing problem in second.cc |
70 |
if (temporal.from_int64_t(args[0]->val_int())) |
71 |
break; |
|
72 |
/* Intentionally fall-through on invalid conversion from integer */
|
|
813.1.8
by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors |
73 |
default: |
74 |
{
|
|
75 |
/*
|
|
76 |
* Could not interpret the function argument as a temporal value,
|
|
77 |
* so throw an error and return 0
|
|
78 |
*/
|
|
79 |
null_value= true; |
|
813.1.14
by Jay Pipes
Quick fix for shadowing problem in second.cc |
80 |
char buff[DRIZZLE_MAX_LENGTH_DATETIME_AS_STRING]; |
813.1.8
by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors |
81 |
String tmp(buff,sizeof(buff), &my_charset_utf8_bin); |
82 |
String *res; |
|
83 |
||
84 |
res= args[0]->val_str(&tmp); |
|
85 |
||
86 |
my_error(ER_INVALID_DATETIME_VALUE, MYF(0), res->c_ptr()); |
|
87 |
return 0; |
|
88 |
}
|
|
89 |
}
|
|
90 |
return (int64_t) temporal.months(); |
|
574.3.14
by Lee
moving functions from item_timefunc to functions/time directory |
91 |
}
|
92 |
||
93 |
String* Item_func_monthname::val_str(String* str) |
|
94 |
{
|
|
813.1.8
by Jay Pipes
Fixes MONTH() function to use new Temporal system. Errors |
95 |
assert(fixed); |
96 |
||
97 |
if (args[0]->is_null()) |
|
98 |
{
|
|
99 |
/* For NULL argument, we return a NULL result */
|
|
100 |
null_value= true; |
|
101 |
return (String *) 0; |
|
102 |
}
|
|
574.3.14
by Lee
moving functions from item_timefunc to functions/time directory |
103 |
const char *month_name; |
104 |
uint32_t month= (uint) val_int(); |
|
105 |
Session *session= current_session; |
|
106 |
||
107 |
if (null_value || !month) |
|
108 |
{
|
|
109 |
null_value=1; |
|
110 |
return (String*) 0; |
|
111 |
}
|
|
112 |
null_value=0; |
|
113 |
month_name= session->variables.lc_time_names->month_names->type_names[month-1]; |
|
114 |
str->set(month_name, strlen(month_name), system_charset_info); |
|
115 |
return str; |
|
116 |
}
|