[MDEV-24285] support oracle build-in function: sys_guid Created: 2020-11-26 Updated: 2021-06-01 Resolved: 2021-05-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Fix Version/s: | 10.6.1 |
| Type: | Task | Priority: | Major |
| Reporter: | woqutech | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Attachments: |
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
SYS_GUID is an Oracle function, similar to the UUID function in mariadb, the document link is: there are two difference between sys_guid and uuid in mariadb :
example for oracle sys_guid SQL> SELECT SYS_GUID() FROM DUAL; SYS_GUID() SQL> SELECT SYS_GUID() FROM DUAL; SYS_GUID() SQL> SELECT SYS_GUID() FROM DUAL; SYS_GUID()
SQL> SELECT SYS_GUID() FROM DUAL; SYS_GUID() SQL> SELECT SYS_GUID() FROM DUAL; SYS_GUID() SQL> SELECT SYS_GUID() FROM DUAL; SYS_GUID() I have implemented SYS_ GUID, the behavior and algorithms are the same as UUID, but the output format is different.
|
| Comments |
| Comment by woqutech [ 2020-11-26 ] |
|
add my patch |
| Comment by Michael Widenius [ 2021-01-04 ] |
|
Patch is ok and I will apply it to 10.6. Two comments:
|
| Comment by woqutech [ 2021-01-05 ] |
|
Thanks for comment and test case. |