@infograf768 can you please comment?

@wilsonge can you please comment as Release Lead 4?

No clue about this one off the top of my head. Sounds bad tho. Added it onto my list

can someone put the release blocker tag back please

FWIW also the drag and drop functionality on any list view is based on this so also that won't work correctly

Maybe related with: joomla-framework/database#213

Is this a MySQL 8 issue? I can't reproduce this on 5.7.31.

One thing that doesn't make sense is that ordering condition is required for ordering to work at all. This should not be required.

Hi @sakiss

@bembelimen and I tried to reproduce this issue and can't find a problem not by adding directly an entry to the table not by using the backend for com_content

	$componet = JFactory::getApplication()->bootComponent('com_content');

	/** @var JTable $table */
	$table = $componet->getMVCFactory()->createTable('Article');

	$array = [
		'title' => 'Test1',
		'alias' => 'test1',
		'introtext' => 'text',
		'catid' => 2,
		'language' => '*',
		'state' => 1,
	];

	$table->save($array, 'catid');

	$array = [
		'title' => 'Test2',
		'alias' => 'test2',
		'introtext' => 'text',
		'catid' => 2,
		'language' => '*',
		'state' => 1,
	];

	$table->save($array, 'catid');

this code results in a proper ordering.

I'm removing the release blocker label and would close this issue until you can provide a code to reproduce this issue.