This discussion is archived
2 Replies Latest reply: Nov 30, 2012 7:01 PM by user571093 RSS

updating rulebase with uppercase and lowercase rulename make difference

user571093 Newbie
Currently Being Moderated
hi,

i got a problem when i am experiementing the sample code in oracle semantic developer's guide. the sample is about updating a rulebase-family_rb:

UPDATE mdsys.semr_family_rb SET
antecedents = '(?x :parentOf ?y) (?y :parentOf ?z) (?z :height ?h)',
filter = '(h >= 6)',
aliases = SEM_ALIASES(SEM_ALIAS('','http://www.example.org/family/'))
WHERE rule_name = 'GRANDPARENT_RULE';

in the last line-the where clause, the rule name (GRANDPARENT_RULE) is upper case; but it is lower case when i inserted it into the rulebase. however, when i updated the rulebase using the lower case rule name, i got '0 row inserted' that means nothing updated. and, the following query returned wrong result. however, if i updated the rulebase using the upper case rule name, i got '1 row inserted' and the query result is correct. i thought the upper case and the lower case should made no difference. can anybody tell me why the results are different? thanks in advance.

kind regards,
hong

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points