Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from MySQL to GaussDB/ U0400049: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with DISTINCT
Updated on 2025-06-07 GMT+08:00
View PDF
Share

U0400049: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with DISTINCT

Description

GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with DISTINCT.

Database Type and Version

  • Source database type and version: MySQL 5.5, 5.6, 5.7, and 8.0
  • Target database type and version: GaussDB (M-compatible mode)
Syntax Example 
SELECT DISTINCT id FROM test_lock1 FOR UPDATE;

Suggestion

No solution is available. You are advised to refactor application code.