• unknown's avatar
    Bug#10946: Confusing error messeges in the case of duplicate trigger definition · 837c9719
    unknown authored
    It was hard to distinguish case, when one was unable to create trigger
    on the table because trigger with same action time and event already
    existed for this table, from the case, when one tried to create trigger
    with name which was already occupied by some other trigger, since in
    both these cases we emitted ER_TRG_ALREADY_EXISTS error and message.
    Now we emit ER_NOT_SUPPORTED_YET error with appropriate additional
    message in the first case. There is no sense in introducing separate
    error for this situation since we plan to get rid of this limitation
    eventually.
    
    
    mysql-test/r/trigger.result:
      Update result for new error message.
    mysql-test/t/trigger.test:
      Update test for new error code.
    sql/sql_trigger.cc:
      If there is already a trigger with the same activation time, report an
      "Unsupported yet" error.
    837c9719
trigger.test 40.2 KB