[ http://issues.apache.org/jira/browse/DERBY-342?page=all ]
Satheesh Bandaram updated DERBY-342:
------------------------------------
type: Improvement (was: Bug)
Current behavior of Derby doesn't support comparing 'LONG VARCHAR' with 'CHAR'
datatypes. I believe this is documented somewhere.... If we change this, it
would be an IMPROVEMENT and needs to be confirmed if allowed by SQL
specification.
> 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
