Mediawiki 1.39.4, PHP 8.1.25, MariaDB 11.1.
When #get_db_data is constructed like this (using SQL JOIN):
{{#get_db_data:
db=test
|from=t1
|where=t1.c1='test'
|join on=t1.c1=t2.id
|data=t1c1=t1.c1
}}
the resulting query is
SELECT t1.c1 FROM t1 WHERE t1.c1='test'
i.e. missing 'JOIN t2 ON t1.c1=t2.id'.
Tested with ExternalData 3.1, 3.2 and Git master.
Thanks for any attention to this.
Šar?nas
_______________________________________________
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org
To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
When #get_db_data is constructed like this (using SQL JOIN):
{{#get_db_data:
db=test
|from=t1
|where=t1.c1='test'
|join on=t1.c1=t2.id
|data=t1c1=t1.c1
}}
the resulting query is
SELECT t1.c1 FROM t1 WHERE t1.c1='test'
i.e. missing 'JOIN t2 ON t1.c1=t2.id'.
Tested with ExternalData 3.1, 3.2 and Git master.
Thanks for any attention to this.
Šar?nas
_______________________________________________
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org
To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/