Bug #101282 | list index out of range in _DATE_to_python() while using json_extract | ||
---|---|---|---|
Submitted: | 23 Oct 2020 9:59 | Modified: | 3 Nov 2020 6:36 |
Reporter: | Mitesh Jat | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Connector / Python | Severity: | S2 (Serious) |
Version: | 8.0.13 | OS: | Linux (5.4.0-48-generic #52-Ubuntu SMP) |
Assigned to: | CPU Architecture: | x86 (x86_64) | |
Tags: | connector, MySQL, python |
[23 Oct 2020 9:59]
Mitesh Jat
[23 Oct 2020 10:32]
Mitesh Jat
MySQL Server Version: 5.7
[2 Nov 2020 12:23]
MySQL Verification Team
Hello Mitesh Jat, Thank you for the report and feedback. I'm not seeing any issues with with the Connector/Python 8.0.22(only diff being that I'm using VS 2019 and Python version 3.7.8). Could you please upgrade Connector/Python and report us back if you are still seeing the issue? If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Thank you for your interest in MySQL. - -- Opened connection <mysql.connector.connection.MySQLConnection object at 0x000002202DD84B48> OS: Windows 10 Python: 3.7.8 (tags/v3.7.8:4b47a5b6ba, Jun 28 2020, 08:53:46) [MSC v.1916 64 bit (AMD64)] Driver: mysql.connector 8.0.22 MySQL Server version : 8.0.22 Inside Constructor Executed sql: select json_extract(info,"$.json_object.address.pincode") pincode from `bug`.demo on cursor: MySQLCursor: select json_extract(info,"$.json_object... [('"600052"',)] Press any key to continue . . . . -- Opened connection <mysql.connector.connection.MySQLConnection object at 0x00000145910B4B88> OS: Windows 10 Python: 3.7.8 (tags/v3.7.8:4b47a5b6ba, Jun 28 2020, 08:53:46) [MSC v.1916 64 bit (AMD64)] Driver: mysql.connector 8.0.22 MySQL Server version : 5.7.32 Inside Constructor Executed sql: select json_extract(info,"$.json_object.address.pincode") pincode from `bug`.demo on cursor: MySQLCursor: select json_extract(info,"$.json_object... [('"600052"',)] Press any key to continue . . . regards, Umesh
[2 Nov 2020 12:47]
MySQL Verification Team
- VS 2019, Python 3.8.0, Connector/Python 8.0.22 and MySQL Server 5.7 - no issues observed Opened connection <mysql.connector.connection.MySQLConnection object at 0x0365B370> OS: Windows 10 Python: 3.8.0 (tags/v3.8.0:fa919fd, Oct 14 2019, 19:21:23) [MSC v.1916 32 bit (Intel)] Driver: mysql.connector 8.0.22 MySQL Server version : 5.7.32 Inside Constructor Executed sql: select json_extract(info,"$.json_object.address.pincode") pincode from `bug`.demo on cursor: MySQLCursor: select json_extract(info,"$.json_object... [('"600052"',)] Press any key to continue . . .
[3 Nov 2020 6:36]
Mitesh Jat
Dear Umesh, Kindly try to repeat on Linux Machine instead of Windows.
[5 Nov 2020 8:58]
MySQL Verification Team
On OL7, MySQL Server 5.7.32, Python 3.8 and Connector/Python 8.0.22 PYTHONPATH="./8.0.22/lib/python3.8/site-packages/" python3.8 Bug101282.py Opened connection <mysql.connector.connection.MySQLConnection object at 0x7f4484e23970> OS: Linux 5.4.17-2011.1.2.el7uek.x86_64 Python: 3.8.6 (default, Nov 4 2020, 09:39:13) [GCC 4.8.5 20150623 (Red Hat 4.8.5-39.0.3)] Driver: mysql.connector 8.0.22 MySQL Server version : 5.7.32 Inside Constructor Executed sql: select json_extract(info,"$.json_object.address.pincode") pincode from `bug`.demo on cursor: MySQLCursor: select json_extract(info,"$.json_object... [('"600052"',)]