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] Created: (DERBY-392) Disable creating indexes on long varchar for bit data. Long varchar column doesn't allow creating indexes already.
Date Fri, 24 Jun 2005 21:23:57 GMT
Disable creating indexes on long varchar for bit data. Long varchar column doesn't allow creating
indexes already.
------------------------------------------------------------------------------------------------------------------

         Key: DERBY-392
         URL: http://issues.apache.org/jira/browse/DERBY-392
     Project: Derby
        Type: Bug
  Components: SQL  
    Versions: 10.1.1.0, 10.0.2.2    
 Environment: generic
    Reporter: Satheesh Bandaram
    Priority: Minor


It should not be possible to create an index on 'long varchar for bit data' datatypes. Derby
currently doesn't allow creating indexes on 'long varchar' datatypes and the same should apply
for it's bit data equivalent too.

ij> create table longchar ( i int, c long varchar);
0 rows inserted/updated/deleted
ij> create index longIdx on longchar(c);
ERROR X0X67: Columns of type 'LONG VARCHAR' may not be used in CREATE INDEX, ORD
ER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because compari
sons are not supported for that type.
ij> create table longcharBitData ( i int, c long varchar for bit data);
0 rows inserted/updated/deleted
ij> create index longIdx on longcharBitData(c);
0 rows inserted/updated/deleted

-- 
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