sys_guid() call always return same value

[srijithchandran]

mybatis version : 3.4.6
Oracle exadata 12c
my mapper xml

<select id="getSysGuId" resultType="String">
		select sys_guid() from dual
</select>

Im not using sys_guid() directly in my insert. Since my code inserting multiple tables (insert all) based on input and also refer another table sys_guid().

Whenever I call getSysGuId, Im getting same value.

[kazuki43zoo]

By default settings, The MyBatis cache a result object on local cache. The default scope of local cache is session. you can clear local cache using flushCache="true" as follow:

  <select id="getSysGuId" resultType="String" flushCache="true">
		select sys_guid() from dual
  </select>

[kazuki43zoo]

Same with #1632.