René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Inserting with `skip_duplicates=True` fails with error message \"attr X is ambiguous\"","articleBody":"I'm encountering a case in which inserting with `skip_duplicates=True` results in an error. The effective query performed by the insert is:\r\n\r\n```sql\r\n'INSERT INTO `cortex_ex_machina_mesonet_analysis2018_02_20`.`__high_oracle_units` (`group_id`,`data_hash`,`readout_key`,`neuron_id`) SELECT `group_id`,`data_hash`,`readout_key`,`neuron_id` FROM (SELECT * FROM `cortex_ex_machina_mesonet_analysis2018_02_20`.`__target_dataset__unit` WHERE ((`data_hash`=\\'a502f8a1ad8fab1f3fea0b3638af26a4\\') AND (`group_id`=4)) AND ((`group_id`,`readout_key`,`unit_id`,`animal_id`) in (SELECT `group_id`,`readout_key`,`unit_id`,`animal_id` FROM (SELECT `group_id`,`animal_id`,`session`,`scan_idx`,`window`,`unit_id`,`pearson`,concat_ws(\"-\", animal_id, session, scan_idx) as `readout_key` FROM `cortex_ex_machina_mesonet_data`.`__meso_net_all_oracle__unit_scores`) as `_s16` WHERE ((`group_id`,`animal_id`,`unit_id`,`readout_key`) in (SELECT `group_id`,`animal_id`,`unit_id`,`readout_key` FROM `cortex_ex_machina_mesonet_analysis2018_02_20`.`__target_dataset__unit` WHERE ((`data_hash`=\\'a502f8a1ad8fab1f3fea0b3638af26a4\\') AND (`group_id`=4)))) AND (pearson \u003e 0.395305)))) as `_s17` ON DUPLICATE KEY UPDATE `group_id`=`group_id`'\r\n```\r\n When the above query is attempted, it fails with an error: `\r\nInternalError: (1052, \"Column 'group_id' in field list is ambiguous\")`\r\n\r\nIt appears to have to do with the fact that the attribute `group_id` is present on both target and source of the insert. I'll need to look into this further, but it may be the case that our \"workaround\" for duplicate entry (i.e. the `ON DUPLICATE KEY UPDATE group_id=group_id`) is not compatible when inserting from another relation.","author":{"url":"https://github.com/eywalker","@type":"Person","name":"eywalker"},"datePublished":"2018-02-22T00:59:04.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/451/datajoint-python/issues/451"}