SEO

#1 (**permalink**) 02-27-2008, 06:03 AM

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:

#2 (**permalink**) 02-27-2008, 06:03 AM

I have no V7.1 system. But, Message manual wrote
"An expression resulting in a string data type with a maximum length
greater than 255 bytes is not permitted in ....." for SQL0134N.
If strictly interprit this, it says "An expression" not says the total
length of ORDER BY expression or columns.

How about try this way?
ORDER BY SUBSTR(disorder,1,250), SUBSTR(disorder,251, 500)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

v7.1 group by and SQL0134N