Hello friends,
I am trying to build Virtuoso 5.0.0 ... i hit a curious problem, which
noone seems to have reported!
The problem is that, virtuoso-opensource-5.0.0/libsrc/Wi/sql_code.c is
not being generated properly.
Many of the procedures are not quoted. A short example is:
static const char *proc62 =
" create procedure ddl_pk_change_final (in tb varchar, in cols any)
{
declare st, msg, tname, tname_esc, tb_esc varchar;
tname := complete_table_name ('TEMP__', 0);
tname_esc := sprintf ('"%I"."%I"."%I"',
name_part (tname, 0), name_part (tname, 1), name_part (tname,
2));
tb_esc := sprintf ('"%I"."%I"."%I"',
name_part (tb, 0), name_part (tb, 1), name_part (tb, 2));
update DB.DBA.SYS_TRIGGERS set T_TABLE = tname where T_TABLE = tb;
exec (sprintf ('drop table %s', tb_esc), st, msg, vector ());
update DB.DBA.SYS_TRIGGERS set T_TABLE = tb where T_TABLE = tname;
exec (sprintf ('alter table %s rename %s', tname_esc, tb_esc), st,
msg, vector ());
commit work;
}
"--src system.sql:850\n";
I'm guessing that the sql_to_c.awk script is failing to add the quotes
around these lines. Since I do not know awk, I hope that someone could
help me resolve this problem to build virtuoso.
Regards
Rajeev J Sebastian
