~drizzle-trunk/drizzle/development

SELECT MICROSECOND(NULL);

MICROSECOND(NULL)

NULL

SELECT MICROSECOND();

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near ')' at line 1

SELECT MICROSECOND(1, 0);

ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near ' 0)' at line 1

SELECT MICROSECOND("xxx");

ERROR HY000: Received an invalid datetime value 'xxx'.

SELECT MICROSECOND("0000-00-00");

ERROR HY000: Received an invalid datetime value '0000-00-00'.

SELECT MICROSECOND("0000-01-01");

ERROR HY000: Received an invalid datetime value '0000-01-01'.

SELECT MICROSECOND("0001-00-01");

ERROR HY000: Received an invalid datetime value '0001-00-01'.

SELECT MICROSECOND("0001-01-00");

ERROR HY000: Received an invalid datetime value '0001-01-00'.

SELECT MICROSECOND("2000-02-30");

ERROR HY000: Received an invalid datetime value '2000-02-30'.

SELECT MICROSECOND("1900-02-29");

ERROR HY000: Received an invalid datetime value '1900-02-29'.

SELECT MICROSECOND('1976-15-15');

ERROR HY000: Received an invalid datetime value '1976-15-15'.

SELECT MICROSECOND('23:59:70');

ERROR HY000: Received an invalid datetime value '23:59:70'.

SELECT MICROSECOND('23:70:59');

ERROR HY000: Received an invalid datetime value '23:70:59'.

SELECT MICROSECOND('26:00:00');

ERROR HY000: Received an invalid datetime value '26:00:00'.

SELECT MICROSECOND('26:00:00.9999999');

ERROR HY000: Received an invalid datetime value '26:00:00.9999999'.

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

MICROSECOND("2009-01-12")

0

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

MICROSECOND("70-12-31")

0

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

MICROSECOND('07/31/2009')

0

SELECT MICROSECOND("2008-11-30 03:30:15");

MICROSECOND("2008-11-30 03:30:15")

0

SELECT MICROSECOND("2008-11-30T03:30:15");

MICROSECOND("2008-11-30T03:30:15")

0

SELECT MICROSECOND("2008-11-30T03:30:15.123456");

MICROSECOND("2008-11-30T03:30:15.123456")

123456

SELECT MICROSECOND("20081130033015");

MICROSECOND("20081130033015")

0

SELECT MICROSECOND("20081130033015.123456");

MICROSECOND("20081130033015.123456")

123456

SELECT MICROSECOND("20081130033015.12345");

MICROSECOND("20081130033015.12345")

123450

SELECT MICROSECOND("20081130033015.1234");

MICROSECOND("20081130033015.1234")

123400

SELECT MICROSECOND("20081130033015.123");

MICROSECOND("20081130033015.123")

123000

SELECT MICROSECOND("20081130033015.12");

MICROSECOND("20081130033015.12")

120000

SELECT MICROSECOND("20081130033015.1");

MICROSECOND("20081130033015.1")

100000

SELECT MICROSECOND(20081130033015);

MICROSECOND(20081130033015)

0

SELECT MICROSECOND(20081130033015.123456);

MICROSECOND(20081130033015.123456)

123456

SELECT MICROSECOND(20081130033015.12345);

MICROSECOND(20081130033015.12345)

123450

SELECT MICROSECOND(20081130033015.1234);

MICROSECOND(20081130033015.1234)

123400

SELECT MICROSECOND(20081130033015.123);

MICROSECOND(20081130033015.123)

123000

SELECT MICROSECOND(20081130033015.12);

MICROSECOND(20081130033015.12)

120000

SELECT MICROSECOND(20081130033015.1);

MICROSECOND(20081130033015.1)

100000

SELECT MICROSECOND(231115);

MICROSECOND(231115)

0

SELECT MICROSECOND("231115");

MICROSECOND("231115")

0

SELECT MICROSECOND("23:59:59");

MICROSECOND("23:59:59")

0

SELECT MICROSECOND("23:59:59.123456");

MICROSECOND("23:59:59.123456")

123456

USE test;

DROP TABLE IF EXISTS t1;

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

);

INSERT INTO t1 VALUES (

20071130

, "2007-11-30"

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

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

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

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

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

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

);

SELECT MICROSECOND(int_fld) FROM t1;

MICROSECOND(int_fld)

0

SELECT MICROSECOND(date_fld) FROM t1;

MICROSECOND(date_fld)

0

SELECT MICROSECOND(datetime_fld) FROM t1;

MICROSECOND(datetime_fld)

0

SELECT MICROSECOND(timestamp_fld) FROM t1;

MICROSECOND(timestamp_fld)

0

SELECT MICROSECOND(char_fld) FROM t1;

MICROSECOND(char_fld)

0

SELECT MICROSECOND(varchar_fld) FROM t1;

MICROSECOND(varchar_fld)

0

SELECT MICROSECOND(text_fld) FROM t1;

MICROSECOND(text_fld)

0

SELECT MICROSECOND(blob_fld) FROM t1;

MICROSECOND(blob_fld)

0

DROP TABLE t1;