Comment 1 for bug 309791

Warnings in SQL should be errors in Drizzle. Here is the data truncation warning locations:

jpipes@serialcoder:~/repos/drizzle/trunk$ ack-grep WARN_DATA_TRUNCATED
drizzled/error.h
297: ER_WARN_DATA_TRUNCATED,

drizzled/field_conv.cc
148: field->set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);
254: ER_WARN_DATA_TRUNCATED, 1);
381: ER_WARN_DATA_TRUNCATED, 1);
412: ER_WARN_DATA_TRUNCATED, 1);
450: ER_WARN_DATA_TRUNCATED, 1);
471: ER_WARN_DATA_TRUNCATED, 1);
486: ER_WARN_DATA_TRUNCATED, 1);
508: ER_WARN_DATA_TRUNCATED, 1);

drizzled/error.cc
563:/* WARN_DATA_TRUNCATED 01000 */

drizzled/field/date.cc
87: ER_WARN_DATA_TRUNCATED,
101: ER_WARN_DATA_TRUNCATED, nr, DRIZZLE_TIMESTAMP_DATE);
135: ER_WARN_DATA_OUT_OF_RANGE : ER_WARN_DATA_TRUNCATED,
160: set_datetime_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED,
170: ER_WARN_DATA_TRUNCATED,
179: set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);

drizzled/field/timetype.cc
54: set_datetime_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED,
62: ER_WARN_DATA_TRUNCATED,

drizzled/field/longstr.cc
56: set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);
59: set_warning(DRIZZLE_ERROR::WARN_LEVEL_NOTE, ER_WARN_DATA_TRUNCATED, 1);

drizzled/field/decimal.cc
152: set_warning(DRIZZLE_ERROR::WARN_LEVEL_NOTE, ER_WARN_DATA_TRUNCATED, 1);

drizzled/field/str.cc
98: set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);

drizzled/field/timestamp.cc
168: set_datetime_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED,
246: ER_WARN_DATA_TRUNCATED,

drizzled/field/double.cc
47: (error ? ER_WARN_DATA_OUT_OF_RANGE : ER_WARN_DATA_TRUNCATED), 1);

drizzled/field/enum.cc
118: set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);
124: set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);
143: set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);

drizzled/field/datetime.cc
115: ER_WARN_DATA_TRUNCATED, initial_nr,
152: set_datetime_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED,
160: set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);

drizzled/field/num.cc
83: set_warning(DRIZZLE_ERROR::WARN_LEVEL_WARN, ER_WARN_DATA_TRUNCATED, 1);

drizzled/my_decimal.cc
41: ER_WARN_DATA_TRUNCATED, ER(ER_WARN_DATA_TRUNCATED),

drizzled/field.cc
838: set_warning(DRIZZLE_ERROR::WARN_LEVEL_NOTE, ER_WARN_DATA_TRUNCATED, 1);

drizzled/sql_state.cc
172: { ER_WARN_DATA_TRUNCATED ,"01000", "" },

client/errname.h
298: { "WARN_DATA_TRUNCATED", 1265 },

I'll be going through these places and converting them to errors instead.