Bug #106017 | case requet | ||
---|---|---|---|
Submitted: | 31 Dec 2021 13:17 | Modified: | 31 Jan 2022 14:46 |
Reporter: | nicolas garnier | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | OS: | Any | |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
Tags: | case |
[31 Dec 2021 13:17]
nicolas garnier
[31 Dec 2021 14:46]
MySQL Verification Team
Thank you for the bug report. Please provide the correct query: mysql 8.0 > SELECT rental_id, staff_id, nombre, -> CASE -> WHEN nombre = 2 THEN "egale a 2" -> WHEN nombre = 1 THEN "egale a 1" -> ELSE "autre" -> END -> FROM rental; ERROR 1054 (42S22): Unknown column 'nombre' in 'field list' mysql 8.0 > DESC rental\G *************************** 1. row *************************** Field: rental_id Type: int Null: NO Key: PRI Default: NULL Extra: auto_increment *************************** 2. row *************************** Field: rental_date Type: datetime Null: NO Key: MUL Default: NULL Extra: *************************** 3. row *************************** Field: inventory_id Type: mediumint unsigned Null: NO Key: MUL Default: NULL Extra: *************************** 4. row *************************** Field: customer_id Type: smallint unsigned Null: NO Key: MUL Default: NULL Extra: *************************** 5. row *************************** Field: return_date Type: datetime Null: YES Key: Default: NULL Extra: *************************** 6. row *************************** Field: staff_id Type: tinyint unsigned Null: NO Key: MUL Default: NULL Extra: *************************** 7. row *************************** Field: last_update Type: timestamp Null: NO Key: Default: CURRENT_TIMESTAMP Extra: DEFAULT_GENERATED on update CURRENT_TIMESTAMP 7 rows in set (0.01 sec) mysql 8.0 >
[1 Feb 2022 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".