~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/dayofmonth.test

Committer: Monty Taylor
Date: 2009-01-29 20:42:53 UTC
mfrom: (819 testable)
mto: (779.3.19 devel)
mto: This revision was merged to the branch mainline in revision 823.
Revision ID: mordred@inaugust.com-20090129204253-9kcnyaxldhy7fyym

Merged with trunk.

Show diffs side-by-side

added added

removed removed

tests/t/dayofmonth.test

# Tests for the DAYOFMONTH() function

# The Drizzle DAYOFMONTH() function differs from the MySQL DAYOFMONTH()

# function in these ways:

# * Does not accept invalid parameters. This results in an error

# in Drizzle.

# DAYOFMONTH() on a NULL should produce

# a NULL.

SELECT DAYOFMONTH(NULL);

# Test improper argument list

# 1 arg is required.

--error 1582 # Wrong parameter count...

SELECT DAYOFMONTH();

--error 1582 # Wrong parameter count...

SELECT DAYOFMONTH(1, 0);

# Test invalid dates passed to DAYOFMONTH

# produce an error, not a NULL or anything

# else...

--error 1686

SELECT DAYOFMONTH("xxx");

# Indy, bad dates!

--error 1686

SELECT DAYOFMONTH("0000-00-00"); # No 0000-00-00 dates!...

--error 1686

SELECT DAYOFMONTH("0000-01-01"); # No zero year parts

--error 1686

SELECT DAYOFMONTH("0001-00-01"); # No zero month parts

--error 1686

SELECT DAYOFMONTH("0001-01-00"); # No zero day parts

--error 1686

SELECT DAYOFMONTH("2000-02-30"); # No Feb 30th!

--error 1686

SELECT DAYOFMONTH("1900-02-29"); # Not a leap DAYOFMONTH since not divisible evenly by 400...

--error 1686

SELECT DAYOFMONTH('1976-15-15'); # No 15th month!

# A good date, which should output 1

SELECT DAYOFMONTH("2009-01-12");

# A good date, which should output 31 - Test of 2 digit DAYOFMONTH conversion and proper day...

SELECT DAYOFMONTH("70-12-31");

# A good date, which should output 329 - Test of 2 digit DAYOFMONTH conversion and proper day in a leap year...

SELECT DAYOFMONTH("00-02-29");

# A good date, which should output 31

SELECT DAYOFMONTH("0001-12-31");

# A good date in the common USA format, should output 31

SELECT DAYOFMONTH('07/31/2009');

# Tests for alternate DATETIME syntaxes

# in string and numeric formats. All should

# return 16.

SELECT DAYOFMONTH('20090916');

SELECT DAYOFMONTH('20090916091528');

SELECT DAYOFMONTH("20090916091528.000000");

SELECT DAYOFMONTH('09-09-16');

SELECT DAYOFMONTH('09.09.16');

SELECT DAYOFMONTH('09/09/16');

SELECT DAYOFMONTH('09-09-16');

SELECT DAYOFMONTH('09-9-2');

SELECT DAYOFMONTH(20090916);

SELECT DAYOFMONTH(20090916091528);

--error 1686 # Don't yet support DOUBLE -> DATETIME.

SELECT DAYOFMONTH(20090916091528.000000);

# Now test field values of different types

USE test;

--disable_warnings

DROP TABLE IF EXISTS t1;

--enable_warnings

CREATE TABLE t1 (

int_fld INT NOT NULL

, date_fld DATE NOT NULL

, datetime_fld DATETIME NOT NULL

, timestamp_fld TIMESTAMP NOT NULL

, char_fld CHAR(22) NOT NULL

, varchar_fld VARCHAR(22) NOT NULL

, text_fld TEXT NOT NULL

, blob_fld BLOB NOT NULL

);

# Should all output 30

INSERT INTO t1 VALUES (

100

20071130

101

, "2007-11-30"

102

, "2007-11-30 16:30:19"

103

, "2007-11-30T16:30:19"

104

, "2007-11-30 16:30:19"

105

, "2007-11-30 16:30:19"

106

, "2007-11-30T16:30:19"

107

, "2007-11-30T16:30:19"

108

);

109

110

SELECT DAYOFMONTH(int_fld) FROM t1;

111

SELECT DAYOFMONTH(date_fld) FROM t1;

112

SELECT DAYOFMONTH(datetime_fld) FROM t1;

113

SELECT DAYOFMONTH(timestamp_fld) FROM t1;

114

SELECT DAYOFMONTH(char_fld) FROM t1;

115

SELECT DAYOFMONTH(varchar_fld) FROM t1;

116

SELECT DAYOFMONTH(text_fld) FROM t1;

117

SELECT DAYOFMONTH(blob_fld) FROM t1;

118

119

DROP TABLE t1;

Older »