db-derby-dev mailing list archives

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


Mime
View raw message