>>>>> "Krunal" == Krunal Bauskar <krunalbauskar@stripped> writes:
Krunal> For MySQL ENUM data-type user is suppose to create table with some
Krunal> pre-defined values for ENUM.
Krunal> For e.g:
Krunal> CREATE TABLE sizes (
Krunal> name ENUM('small', 'medium', 'large')
Krunal> MySQL meta-data registers enum values viz. small/medium/large
Krunal> If user inserts a value which is not found in this cache and MySQL is
Krunal> in non-strict mode, MySQL will handover an empty string to Storage Engine.
MySQL will hand over a record where it has an integer representing the
enum value, not a string.
Krunal> But now if user tries to select from this table using "select *", SE will
Krunal> handover an empty string as done by MySQL during insert time but this
Krunal> handing over fails as MySQL refuses to accept this value.
SE should return a record populated with values, not strings.
How are you populating the record ?
You can easily shut down any errors during the population by setting
thd->count_cuted_fields to 0. You must of course set it back to it's
original value when you are done.