LOG/EFF Table Views Won't Join with NON Table Views

[GoogleCodeExporter]

What steps will reproduce the problem?

  1. Create a NON Table
  2. Create a LOG Table with a Foreign Key to the NON Table
  3. Generate/Install
  4. NON Table "_ALL" view does not exist error

What is the expected output? What do you see instead?

  -) No errors

Please use labels and text to provide additional information.

  -) Pre-Release 0.11

Fix Includes Changes to "create_all" and "create_asof":

   view_suffix  varchar2(10);

         if buff.type = 'NON' then
            view_suffix := '_ACT';
         else
            view_suffix := '_ALL';
         end if;
         p('  left outer join ' || 
                   get_tabname(buff.fk_table_id) || view_suffix ||

Original issue reported on code.google.com by Duane.Di...@gmail.com on 28 Aug 2012 at 3:10

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

function get_tabtype
      (tabid_in  in  tables.id%type)
   return varchar2
   --  For a table ID, return the table type
is
begin
   return nk_aa(tabid_in).tbuff.type;
end get_tabtype;
----------------------------------------
         if get_tabtype(buff.fk_table_id) = 'NON' then
            view_suffix := '_ACT ';
         else
            view_suffix := '_ALL ';
         end if;
         p('  left outer join ' || 
                   get_tabname(buff.fk_table_id) || view_suffix ||

Original comment by Duane.Di...@gmail.com on 28 Aug 2012 at 3:34

[GoogleCodeExporter]

Original comment by Duane.Di...@gmail.com on 28 Aug 2012 at 3:49

• Changed state: Fixed