SimpleName->getFullName()

[staabm]

when running the query SELECT COALESCE(null, gesperrt, freigabe1u1) from ada thru the ast, I get the following function call expression:

the SimpleName of the arguments atm only contain a local name, but not a full qualified name including the reference to the table like ada.gesperrt (or maybe even prefixed with the database name included).

I guess thats something SimpleName->getFullName() should return, but is not yet implemented, right?

sqlftw/sources/Sql/Expression/identifier/SimpleName.php

Lines 33 to 36 in 1260391

	public function getFullName(): string
	{
	return $this->name;
	}

[paranoiq]

hi. for now you have to resolve things like this manually. the nodes currently are not bi-directionally interlinked (parents, siblings etc.) so they cannot give you this information, but it is planned.

also e.g. in case of SELECT a, b FROM c, d external context (metadata for the tables) is needed to resolve from which table the columns originate