StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POIn MariaDB, function placed in a trigger starts returns a different value
primarykey
Id
19033874
data
AcceptedAnswerId
19071122
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-09-26T16:39:33.603
FavoriteCount
0
LastActivityDate
2013-09-29T13:19:55.460
LastEditDate
2013-09-27T10:58:00.893
LastEditorUserId
545145
OwnerUserId
545145
ParentId
0
PostTypeId
1
Score
1
ViewCount
481
LastEditorDisplayName
text
Body
There are such table and functions: <pre><code>CREATE TABLE `test` (`ID` BINARY(16)) ENGINE=InnoDB; CREATE FUNCTION `UUID_ENCODE`(`uuid` CHAR(36)) RETURNS binary(16) DETERMINISTIC BEGIN RETURN UNHEX(REVERSE(REPLACE(uuid,'-',''))); END CREATE FUNCTION `UUID_DECODE`(`uuid` BINARY(16)) RETURNS char(36) DETERMINISTIC BEGIN RETURN LOWER(CONCAT_WS('-', REVERSE(HEX(RIGHT(uuid,6))), REVERSE(HEX(MID(uuid,9,2))), REVERSE(HEX(MID(uuid,7,2))), REVERSE(HEX(MID(uuid,5,2))), REVERSE(HEX(LEFT(uuid,4))) )); END </code></pre> Insert is working properly: <pre><code>INSERT INTO test (ID) VALUES(UUID_ENCODE('323febe6-cd89-4773-a46c-aab794fb7cbc')); SELECT UUID_DECODE(ID) FROM test; +--------------------------------------+ | uuid_decode(id) | +--------------------------------------+ | 323febe6cd89-4773-a46c-aab7-94fb7cbc | +--------------------------------------+ </code></pre> Just create a trigger: <pre><code>CREATE TRIGGER `test_uuid_encode` BEFORE INSERT ON `test` FOR EACH ROW BEGIN SET NEW.ID = UUID_ENCODE(NEW.ID); END </code></pre> and get half truncated value in table: <pre><code>INSERT INTO test (ID) VALUES('323febe6-cd89-4773-a46c-aab794fb7cbc'); Warning (Code 1265): Data truncated for column 'ID' at row 1 SELECT UUID_DECODE(ID) FROM test; +--------------------------------------+ | uuid_decode(id) | +--------------------------------------+ | 000000000000-0000-0032-3feb-e6cd8947 | +--------------------------------------+ </code></pre> What is wrong with this trigger? Software version is: <blockquote> Ver 5.5.33a-MariaDB for Win64 on x86 (mariadb.org binary distribution) </blockquote>
Tags
<mysql><triggers><binary><uuid><mariadb>
Title
In MariaDB, function placed in a trigger starts returns a different value
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USYuriy
UserOwnerUserId
1. USYuriy
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POIn MariaDB, function placed in a trigger starts returns a different value
 UserUserId
 USYuriy
 VoteTypeVoteTypeId
 VTBountyStart
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.