v9.0 Queue Table gets wrong syntax when exported or compared

[Bernhard S]

I have a queue table created like this:

begin
  sys.dbms_aqadm.create_queue_table(
    queue_table        => 'LOGGING_QT',
    queue_payload_type => 'SYS.AQ$_JMS_MESSAGE',
    sort_list          => 'PRIORITY, ENQ_TIME',
    compatible         => '8.1.3',
    primary_instance   =>  0,
    secondary_instance =>  0);
end;
/

When this queue gets exported or compared in PSD v9.0 it results in:

begin
  sys.dbms_aqadm.create_queue_table(
    queue_table => 'LOGGING_QT',
    queue_payload_type => 'SYS.AQ$_JMS_MESSAGE',
    sort_list => 'PRIORITY, ENQUEUE_TIME',
    compatible => '8.1.3',
    primary_instance => 0,
    secondary_instance => 0);
end;
/

When trying to create it like this you get:

ORA-24004: invalid column name  ENQUEUE_TIME in SORT_LIST, should be ENQ_TIME or PRIORITY
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3035
ORA-06512: at "SYS.DBMS_AQADM", line 58
ORA-06512: at line 3

 

[Marco Kalter]

We'll fix it.