🐛 Bug Report: Failed one to many relationship

[stnguyen90]

👟 Reproduction steps

Create 2 one way one to many relationships to the same collection from separate collections:

For example, using the CLI:

$ appwrite databases createRelationshipAttribute --databaseId relationships --collectionId first --relatedCollectionId third --type oneToMany --key oneToManyThird --twoWay false --twoWayKey related2
key : oneToManyThird
type : relationship
status : processing
error : 
required : false
array : false
relatedCollection : third
relationType : oneToMany
twoWay : false
twoWayKey : related2
onDelete : restrict
side : parent
✓ Success 

# steven @ Stevens-MacBook-Pro-2 in ~/Projects/appwrite-projects/localhost-test [9:25:40] 
$ appwrite databases createRelationshipAttribute --databaseId relationships --collectionId second --relatedCollectionId third --type oneToMany --key oneToManyThird --twoWay false --twoWayKey related2
key : oneToManyThird
type : relationship
status : processing
error : 
required : false
array : false
relatedCollection : third
relationType : oneToMany
twoWay : false
twoWayKey : related2
onDelete : restrict
side : parent
✓ Success

👍 Expected behavior

Maybe an error should be thrown for the 2nd create relationship attribute API call.

👎 Actual Behavior

API calls are successful, but the attribute ends up as failed, but without any error:

{
  "key": "oneToManyThird",
  "type": "relationship",
  "status": "failed",
  "error": "",
  "required": false,
  "array": false,
  "relatedCollection": "third",
  "relationType": "oneToMany",
  "twoWay": false,
  "twoWayKey": "related2",
  "onDelete": "restrict",
  "side": "parent"
}

Database worker logs show:

appwrite-worker-databases  | [Job] Received Job (66326d5ab7a040.66031591).
appwrite-worker-databases  | SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'related2'
appwrite-worker-databases  | [Job] (66326d5ab7a040.66031591) successfully run.

🎲 Appwrite version

Version 1.5.x

💻 Operating system

Linux

🧱 Your Environment

No response

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[stnguyen90]

Related to #8059 because of the behavior with two way keys