5 Replies Latest reply on Mar 10, 2015 12:36 PM by Laurent Schneider

    sybase trigger is not properly displayed

    Laurent Schneider

      Hi

       

      In some Sybase database, the triggers are not displayed correctly

       

      All databases are 15.0.3 and they all have the same application installed.

       

      On the AIX Databases the trigger is displayed properly in SQL Developer on my Windows PC

       

      something like

       

      create trigger trg

      on t1

      for insert, update

      as

      begin

        insert t2(id) select i.id from inserted i

      end

       

      But on the Solaris Databases it is completly weird


      something like

       

      serted i

       

      end

      create trigger trg

      on t1

      for insert, update

      as

      begin

        insert t2(id) select i.id from in

       

       

      Roughly, half ot the triggers are affected.

       

      It does not reproduce in Sybase Central.

       

      Do you have any hint please ? How is the code generated?

       

      Thanks a lot in advance.

      Laurent

       

      PS: it reproduces with any SQL Developer version including the latest 4.1

      PS: I am using jtds3.1