On 09/27/2017 11:31 AM, Jim Hu wrote:
> Query: SELECT
> annotation_id,row_id,original_row_data,annotation_timestamp,user_id,team_id,session_id,annotation_inning
> FROM `unittest_cacao_annotation` INNER JOIN `unittest_cacao_user` ON
> ((annotation_user = cacao_user.id)) WHERE annotation_id = "6057"
> Function: CacaoModelAnnotation::load
> Error: 1054 Unknown column 'cacao_user.id' in 'on clause' (localhost)
MediaWikiTestCase sets $wgDBprefix to cause database queries to refer to
temporary tables instead of the original tables. If your code does not
handle table prefixes correctly, you can get such an error message.
> 'cacao_user' => array('INNER JOIN',
> 'annotation_user = cacao_user.id' ),
To make a query like this work with a table prefix, you should alias the
referenced table ("cacao_user" in this case), then in the condition,
refer to the table using the alias:
$result = $dbr->select(
array( 'cacao_annotation', 'u' => 'cacao_user' ),
[...]
'cacao_user' => array( 'INNER JOIN', 'annotation_user = u.id' ),
--
Kevin Israel -- Wikipedia editor, MediaWiki developer
https://en.wikipedia.org/wiki/User:PleaseStand
_______________________________________________
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
