@shur any way to test?

On postgres we have 42 as default:
https://github.com/joomla/joomla-cms/blob/staging/installation/sql/postgresql/joomla.sql#L1546

and on sql azure 0
https://github.com/joomla/joomla-cms/blob/staging/installation/sql/sqlazure/joomla.sql#L2492

It was old mistake and was mention here:
#4437

How to test:

1. After fresh Joomla installation go to #__tags table in the database.
   Or import this joomla.sql file in a new database and go to #__tags table.

2. You'll see that created_user_id field is not empty but equals zero because mysql automatically corrects this empty value to integer 0.
   

Sure it's better not to create these problems that might cause errors (ERROR: Incorrect integer value), but get correct value for this field in joomla.sql.

@zero-24
I checked the table #__categories and found that it is also used created_user_id=42 for ROOT category. Perhaps we should follow the same approach for the ROOT item in #__tags table.

So far it's clear that it should be integer value.
But the main question is what integer value we must use for this field - 0 or 42?

bump up

Please use 42 to be consistent with categories.

In PostreSQL it's also 42: https://github.com/joomla/joomla-cms/blob/staging/installation/sql/postgresql/joomla.sql#L1546
And can you change it for SQLAzure as well?
https://github.com/joomla/joomla-cms/blob/staging/installation/sql/sqlazure/joomla.sql#L2492

created_user_id for tags ROOT category changed to 42

Thanks, setting RTC based on review.

Please add the RTC label @joomla-cms-bot

Please add the RTC label @joomla-cms-bot

You're kidding me, right?

Well, it's not on a text responder, but the bot can add the label

The bot is strict now ;) If the status on jissues is not RTC he will remove it ;) If you set it and add any kind of comment he will add it :)

Well, it's not on a text responder, but the bot can add the label

That would be a cool feature to add

Thank you @shur! Merged with 8d0968d

Probably we need to create some kind of sql update file for the next Joomla release.
This file should replace 0 with 42 in created_user_id field for ROOT category.

one problem less #4311

I don't think it matters at all what user there is for the root category.