I have a table with a column that is a varchar of greater than 255.
There appears to be a problem with grouping when the column is greater
than 255. From reseach it appears this problem is resolved at 7.2+.
Does anyone have a resolution using 7.1 (getting the upgrade requires
alot of paperwork... sigh)
create table gene_disorders (
gene_id NUMERIC(10) NOT NULL,
disorder VARCHAR(500) NOT NULL,
pos_by VARCHAR(50)
);
A SELECT on this table with an ORDER BY will fail: