Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

About the bug of the mysql.py file in the output directory #1676

Open
BMooS opened this issue Jan 13, 2022 · 1 comment
Open

About the bug of the mysql.py file in the output directory #1676

BMooS opened this issue Jan 13, 2022 · 1 comment

Comments

@BMooS
Copy link

BMooS commented Jan 13, 2022

Describe the bug
In the Output Event Code Reference section of the official document, the timestamp attribute in Shared Attributes is timestamp in ISO8601 format in UTC time zone, but the output to the MySQL database written in the document is written by docs/sql/mysql.sql In the created table, the attribute of timestamp in the table is datetime. The formats of the two are not uniform, which will cause an error to insert data.

Server (please complete the following information):

  • OS: Linux ubuntu 5.13.0-25-generic #26-Ubuntu SMP Fri Jan 7 15:48:31 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
  • Python: Python 3.9.7

Error messages in the log
output_mysql: MySQL Error: (1292, "1292 (22007): Truncated incorrect DECIMAL value: '2022-01-13T07:48:01.616628Z'", '22007')

@micheloosterhof
Copy link
Member

Thanks for reporting this! I wonder why this never came up before.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants