René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"MySQL8: Issue with case-sensitivity in dicts returned from information_schema","articleBody":"When setting `as_dict=True`, returned values are `.upper()` for `information_schema` tables in MySQL 8.0.21. Since dicts are case-sensitive, lower-case key will thrown `KeyError`. See:\r\n```python\r\n# MySQL 8.0.21\r\n\u003e\u003e\u003e res = dj.conn().query('SELECT constraint_name FROM information_schema.key_column_usage limit 3', as_dict=True).fetchall()\r\n\u003e\u003e\u003e res\r\n[{'CONSTRAINT_NAME': 'PRIMARY'}, {'CONSTRAINT_NAME': 'PRIMARY'}, {'CONSTRAINT_NAME': 'PRIMARY'}]\r\n\u003e\u003e\u003e res[0]['constraint_name']\r\nTraceback (most recent call last):\r\n  File \"\u003cstdin\u003e\", line 1, in \u003cmodule\u003e\r\nKeyError: 'constraint_name'\r\n```\r\nSolution could be to `.lower()` all returned keys after query specifically from `information_schema.*`.\r\n\r\nAlso, this is a good note on the warnings thrown from `MySQL8` in docker i.e. `mbind: Operation not permitted`\r\nhttps://github.com/docker-library/mysql/issues/303","author":{"url":"https://github.com/guzman-raphael","@type":"Person","name":"guzman-raphael"},"datePublished":"2020-10-23T15:50:31.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/818/datajoint-python/issues/818"}