dynamobi/dynamobi — Issue #547: [FRG-325] Create index on a UDT causes assertion failuer
Author: dynamobi-build
Created: 2011-12-30 03:34:43+00:00
State: open
Labels: FRG

[reporter="nigel.thomas", created="Mon, 30 Jun 2008 09:27:09 -0500 (GMT-05:00)"]
set schema 'nigel';

set path 'nigel';

!set force true

drop table employees;

!set force false

create or replace type full_name as

( first_name varchar(30)

, middle_initials varchar(10)

, last_name varchar(30)

) instantiable final;

create table employees

( empid int

, name full_name

, age int

, primary key (empid)

);

0: jdbc:farrago:rmi://localhost> create index e_n on employees(name);

Error: java.lang.AssertionError: Was not expecting value 'STRUCTURED' for enumeration 'org.eigenbase.sql.type.SqlTypeName' in this context (state=,code=0)

0: jdbc:farrago:rmi://localhost>

Presumably this is unsupported - but there should be a meaningful error message.