[
http://issues.apache.org/jira/browse/DERBY-342?page=comments#action_12313048 ]
Thomas J. Taylor commented on DERBY-342:
----------------------------------------
NOTE: If I change the DDL statement from LONG VARCHAR to VARCHAR(3200) the
program works, indicating comparisons are not possible with LONG VARCHAR data
types.
// stmt.execute("CREATE TABLE test (id INTEGER, value LONG VARCHAR)");
stmt.execute("CREATE TABLE test (id INTEGER, value VARCHAR(3200))");
> 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
