Beautifier and Comments

[Holger B]

Hi Marco,

the Beautifier has some problems with comments. I have realized it for some versions now, but perhaps noone else has. try to beautify the following and watch the comment:

SELECT a.cust_account_id
      ,a.account_number
       /*,hz_utility_v2pub.get_lookupmeaning('FND_LOOKUP_VALUES'
         ,'CUSTOMER CLASS'
         ,a.customer_class_code) AS customer_class_code */
      ,a.account_established_date
  FROM hz_cust_accounts     a
      ,hz_customer_profiles p
 WHERE a.account_number = x_customer_rec.customer_number
   AND p.cust_account_id = a.cust_account_id
   AND p.site_use_id IS NULL;

the seconed and third line of the comment are constantly indented each time you run the beautifier.

Greeting,
holger

 

[Marco Kalter]

This is indeed a known bug. It will be fixed.