Bug #32496 In "traditional, ansi" an identifier is not more accepted, that formerly was.
| Submitted: | 19 Nov 2007 15:05 | Modified: | 9 Jan 2008 14:55 |
|---|---|---|---|
| Reporter: | Horst Hunger | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Parser | Severity: | S3 (Non-critical) |
| Version: | 5.0.52 | OS: | Linux (Suse 10.2) |
| Assigned to: | Horst Hunger | CPU Architecture: | Any |
[19 Nov 2007 16:34]
Joerg Bruehe
Effect starts in 5.0, is a consequence of the fix for bug#27695 which extends the rules for table column names to also apply to view column names.
[22 Nov 2007 14:03]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/38276 ChangeSet@1.2625, 2007-11-22 15:05:04+01:00, hhunger@hh-nb.hhunger +6 -0 Modifications due to bug#32496.
[26 Nov 2007 20:26]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/38571 ChangeSet@1.2586, 2007-11-26 21:28:01+01:00, hhunger@hh-nb.hhunger +5 -0 patch for bug#32496 (2nd) with ansi conformant and Mysql test case.
[26 Nov 2007 21:48]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/38578 ChangeSet@1.2615, 2007-11-26 22:50:12+01:00, hhunger@hh-nb.hhunger +2 -0 post merge fix for bug#32496.
[27 Nov 2007 10:20]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/38605 ChangeSet@1.2694, 2007-11-27 11:22:25+01:00, hhunger@hh-nb.hhunger +5 -0 post merge fix for bug#32496
[29 Nov 2007 12:53]
Bugs System
Pushed into 6.0.4-alpha
[11 Dec 2007 14:50]
Bugs System
Pushed into 5.0.52
[11 Dec 2007 14:51]
Bugs System
Pushed into 5.1.23-rc
[9 Jan 2008 14:55]
Paul DuBois
Noted in 5.0.54, 5.1.23, 6.0.4 changelogs. The rules for valid column names were being applied differently for base tables and views.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.047 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: The following SQl statement fails with error 1166: Incorrect column name 'pure column f3: ' though it is and was valid: CREATE OR REPLACE VIEW v1 AS SELECT f3 AS "pure column f3: ", f1 + f3 AS "sum of columns f1 + f3 = ", 3 * (- 0.11111E+1) AS "product of constants 3 * (- 0.11111E+1): ", '->' || CAST(f3 AS CHAR) || '<-' AS "expression with '||'=CONCAT and CAST(DECIMAL column AS CHAR): " FROM t1 WHERE f1 = 2; SELECT * FROM v1; How to repeat: run the attached test.