~drizzle-trunk/drizzle/development

Merge of Jay's work.

added added

removed removed

384

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

385

select year("0000-00-00"),year(d),year(dt),year(t),year(c) from t1;

386

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

387

select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(t),to_days(c) from t1;

388

to_days("0000-00-00") to_days(d) to_days(dt) to_days(t) to_days(c)

389

NULL NULL NULL 733814 NULL

387

select to_days("0000-00-00"),to_days(d),to_days(dt),to_days(c) from t1;

388

to_days("0000-00-00") to_days(d) to_days(dt) to_days(c)

389

NULL NULL NULL NULL

390

Warnings:

391

Warning 1292 Incorrect datetime value: '0000-00-00'

392

select extract(MONTH FROM "0000-00-00"),extract(MONTH FROM d),extract(MONTH FROM dt),extract(MONTH FROM t),extract(MONTH FROM c) from t1;