René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Invalid enum values fail silently on insert() and insert1()","articleBody":"It seems that invalid enum values do not raise an error in mysql + datajoint-python when inserting into a table. Here's a minimal example:\r\n\r\n```python\r\nimport datajoint as dj\r\n\r\nschema = dj.schema('dj_mysql_test', locals())\r\n\r\n@schema\r\nclass Mouse(dj.Manual):\r\n    definition = '\\n'.join([\r\n    \"m : varchar(128)\", # name\r\n    \"----\",\r\n    \"m_sex : enum('F', 'M', 'unknown')\"\r\n    ])\r\n\r\nm = Mouse()\r\nm.insert1(dict(m='test1', m_sex='M'))\r\nm.insert1(dict(m='test2', m_sex='blarg')) # fails silently\r\nm.insert([dict(m='test3', m_sex='F'),\r\n          dict(m='test4', m_sex='blarg')]) # fails silently\r\n\r\nprint(m.preview())\r\nprint('dj.__version__ == ', dj.__version__)\r\n```\r\nThis results in the following output:\r\n```\r\n*m        m_sex    \r\n+-------+ +-------+\r\ntest1     M        \r\ntest2              \r\ntest3     F        \r\ntest4              \r\n (4 tuples)\r\n\r\ndj.__version__ ==  0.8.0\r\n```\r\nObviously, I'm using the default values for the various kwargs for `.insert()` and `.insert1()`:\r\n```python\r\nreplace=False, ignore_errors=False, skip_duplicates=False, ignore_extra_fields=False\r\n```\r\nMost relevantly, `ignore_errors=False`, yet no error is raised. Is this a known issue? When we try something like this on the same mysql server using datajoint-matlab, an error is raised, as it should be IMO.\r\n\r\n```\r\n$ mysql -V\r\nmysql  Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (x86_64) using readline 6.3\r\n```","author":{"url":"https://github.com/mspacek","@type":"Person","name":"mspacek"},"datePublished":"2017-07-31T12:38:00.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/344/datajoint-python/issues/344"}