[ http://issues.apache.org/jira/browse/DERBY-342?page=comments#action_12313051 ]
Daniel John Debrunner commented on DERBY-342: --------------------------------------------- Documented in comparision table in 10.0 manuals http://incubator.apache.org/derby/docs/10.0/manuals/reference/sqlj125.html#HDRSII-SQLJ-58560 No valid comparisions for LONG VARCHAR (no Y entries in table) > ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported > ---------------------------------------------------------------------------- > > Key: DERBY-342 > URL: http://issues.apache.org/jira/browse/DERBY-342 > Project: Derby > Type: Improvement > Components: JDBC, Tools > Versions: 10.0.2.1 > Environment: Windows XP Professional, Service Pack 2; Dell Latitude D600; > 1.5GB RAM > Reporter: Thomas J. Taylor > > Trying to run the same SQL query through JDBC-Derby and IJ results in the > same error: > ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported. > The same Java code/query works with MySQL 4.1 (Connector/J) and MS Access > 2002 (JDBC-ODBC) > Table Definition: > CREATE TABLE itemdata (valuetext LONG VARCHAR); > SQL Statement > ij>SELECT * FROM itemdata WHERE valuetext = 'asdf'; > ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not > supported. > I have tried to use the 'cast' function to perform a LONG VARCHAR comparison: > ij> select * from itemdata where valuetext = cast('asdf' as long varchar); > ERROR 42818: Comparisons between 'LONG VARCHAR' and 'LONG VARCHAR' are not > supported. > The only way I've been able to get ANY result is the following: > ij> select * from itemdata where cast(valuetext as char) = 'asdf'; > VALUETEXT > > > -------------------------------------------------------------------------------------------------------------------------------- > ERROR 22001: A truncation error was encountered trying to shrink CHAR > 'asdf' to length 1. > If I try to cast to VARCHAR, I get a syntax error: > ij> select * from itemdata where cast(valuetext as varchar) = 'asdf'; > ERROR 42X01: Syntax error: Encountered ")" at line 1, column 63. > I also have this problem if I change itemdata.valuetext to CLOB. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
