Kevin Wilson wrote : > >The following index hangs sql studio when executed in both internal and >Oracle modes. According to the doc ( >http://dev.mysql.com/doc/maxdb/en/6d/117c4dd14811d2a97400a0c944 >9261/content. >htm ) I should be able to do this if I am reading it correctly. > > >CREATE INDEX "IDX_PERSON_UFNAME" ON "MYDB"."PERSON"(UPPER("FNAME") ASC) > > >Server: SAPDB v7.5.0.14 on Linux >
According to the reference manual the function must be a user defined function (dbfunction) : <create_index_statement> ::= CREATE [UNIQUE] INDEX <index_name> ON <table_name> (<index_spec>) <index_spec> ::= <column_name> [ASC|DESC] | <dbfunction_name> (<column_name>,...) [ASC|DESC] Since the use of user defined function is not recommended with version 7.5.0, function based indexes should not be used yet. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
