Issue Bug Closed

#16560Error during creation from table sys_refindex on oracle 10g database

Sven Limbach 09/13/06, 15:21 updated 03/13/07, 15:31

Description

During the creation of the table “sys_refindex” the following error occured:

ERROR: Query could not be parsed: “SQL engine parse ERROR: No ) parenthesis in list: near “(199)) ) “”. Query: “CREATE TABLE sys_refindex ( hash varchar(32) NOT NULL default ‘’, tablename varchar(40) NOT NULL default ‘’, recuid int(11) NOT NULL default ‘0’, field varchar(40) NOT NULL default ‘’, flexpointer tinytext NOT NULL, softref_key varchar(30) NOT NULL default ‘’, softref_id varchar(40) NOT NULL default ‘’, sorting int(11) NOT NULL default ‘0’, deleted int(11) NOT NULL default ‘0’, ref_table varchar(40) NOT NULL default ‘’, ref_uid int(11) NOT NULL default ‘0’, ref_string varchar(200) NOT NULL default ‘’, PRIMARY KEY (hash), KEY lookup_rec (tablename,recuid), KEY lookup_uid (ref_table,ref_uid), KEY lookup_string (ref_table,ref_string(199)) );”

ORACLE Database Version 10.1.0.4.2
(issue imported from #M4212)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.