db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas J. Taylor (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-342) ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported
Date Wed, 08 Jun 2005 14:47:29 GMT
    [ 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


Mime
View raw message