[Dbix-class] ENUM values from MySQL using the column_info()

[Zbigniew Lukasiak]

Hi,

The reason I was against to code even a bit more than some basic rules
is that I wanted adding the new column info fields, and or other
databases (not covered by the current two cases) to be simple so that
people would continue the work.   Perhaps I should not fear the
complexity so much or try to shift it to one place.  But still this
whole issue is pretty idiosyncrastic and I would not consider
case-insensitivity as a 'design error', but rather as a common ground
for all the databases.

Just for your information I tried quoting - but all I've got is:

zby at zby:~/progs/Test$ perl test.pl
DBD::Pg::st execute failed: ERROR:  column "me.id" does not exist
DBIx::Class::ResultSet::find(): Error executing 'SELECT "me.id",
"me.name", "me.NAME" FROM "casecheck" "me" WHERE ( "me.id" = ? )':
ERROR:  column "me.id" does not exist


For the creation of this table I used the following SQL:

create table Casecheck (
id serial primary key,
"name" text,
"NAME" text
);

--
Zbyszek