Bug #108352 From Virtual Column get Warning
Submitted: 31 Aug 2022 14:52 Modified: 1 Sep 2022 12:00
Reporter: Ertugrul DIRIK Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Query Cache Severity:S3 (Non-critical)
Version:10.4.24 OS:Windows (Windows 10)
Assigned to: CPU Architecture:Other ((AMD64) AMD A10-7870K Radeon R7 3.90 GHz)
Tags: SQL ALTER Script

[31 Aug 2022 14:52] Ertugrul DIRIK
First of all I have a users table. The table contains fullname and surname fields.
I want to create a virtual column with VARCHAR(255) type to join fullname and surname fields. It was created virtual column. But I runned sql query 'SELECT * FROM users' when I got warnings 'Warning: #1292 Truncated incorrect DOUBLE value' and Virtual column shows result 0. I still get the same warnings even after reset mysql and clear caches.

How to repeat:
I'm sry but I don't undestand what the question means.
[1 Sep 2022 12:00] MySQL Verification Team

Thank you for your bug report.

First of all, we do not have server version 10.4.24. Hence, this info should be corrected.

Second, why do you believe that your report falls in the category of the Query Cache ????

Now, more important remarks .....

Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php. In short, we need a repeatable test case in the form of the set of SQL commands that always lead to the behaviour that you report. Preferably, the result should be repeatable with the release 8.0.30.

Next, you probably have some problems in your definition of the virtual column, so please consult our Reference Manual on the correct manner to achieve what you need.

If you can provide more information, feel free to add it to this bug and we will change the status back to 'Open'.  

Thank you for your interest in MySQL.