cubrid icon indicating copy to clipboard operation
cubrid copied to clipboard

[CBRD-24413] Remove the db_user OID from printing event log.

Open beyondykk9 opened this issue 3 years ago • 1 comments

http://jira.cubrid.org/browse/CBRD-24413

After the sql statement recorded in the event, the OID of the record containing the user's information in the db_user table of the logged-in user is displayed. It already shows which user logged in in the event log, so it seems there is not necessary to show. The user oid is included in hash text produced at compiling. So, the routines print event logs should be modified to print without user-oid from hash text.

The event log shows no printing user OID as below.

06/27/22 08:54:33.504 - TEMP_VOLUME_EXPAND
  client: DBA@bwkim192|csql(178473)
  sql: delete [au] from [_db_auth] [au] where [au].[class_of] in (select distinct [cl] from [_db_class] [cl] where unique_name= ?:0 )
  bind: 'dba.tt'
  time: 7
  pages: 8192

beyondykk9 avatar Jun 27 '22 00:06 beyondykk9

Codecov Report

Merging #3689 (54db49c) into develop (8e5f2aa) will decrease coverage by 27.71%. The diff coverage is 25.00%.

:exclamation: Current head 54db49c differs from pull request most recent head 0ccc76f. Consider uploading reports for the commit 0ccc76f to get more accurate results

@@             Coverage Diff              @@
##           develop    #3689       +/-   ##
============================================
- Coverage    51.80%   24.09%   -27.72%     
============================================
  Files          515      515               
  Lines       392792   397250     +4458     
============================================
- Hits        203504    95706   -107798     
- Misses      189288   301544   +112256     
Impacted Files Coverage Δ
src/object/class_object.c 40.23% <0.00%> (-31.85%) :arrow_down:
src/optimizer/query_planner.c 12.94% <0.00%> (-66.03%) :arrow_down:
src/parser/parse_tree_cl.c 12.06% <100.00%> (-59.09%) :arrow_down:
src/method/method_def.hpp 0.00% <0.00%> (-100.00%) :arrow_down:
src/xasl/xasl_analytic.cpp 0.00% <0.00%> (-100.00%) :arrow_down:
src/object/object_printer.hpp 0.00% <0.00%> (-100.00%) :arrow_down:
src/method/method_oid_handler.hpp 0.00% <0.00%> (-100.00%) :arrow_down:
src/method/method_struct_query.hpp 0.00% <0.00%> (-100.00%) :arrow_down:
src/method/method_struct_oid_info.hpp 0.00% <0.00%> (-100.00%) :arrow_down:
src/object/schema_class_truncator.hpp 0.00% <0.00%> (-100.00%) :arrow_down:
... and 260 more

Continue to review full report at Codecov.

Legend - Click here to learn more Δ = absolute <relative> (impact), ø = not affected, ? = missing data Powered by Codecov. Last update 8f8e3a8...0ccc76f. Read the comment docs.

codecov-commenter avatar Jun 27 '22 01:06 codecov-commenter