| Showing all 29 (Edit, Save, CSV, Feed) |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 56353 | 2010-08-29 23:26 | 2022-12-04 20:45 | MySQL Server: Views | Verified | S3 | 5.1.49 | Any | Any | Confusing ERROR 1449 on VIEW creation |
| 56225 | 2010-08-24 16:59 | 2022-05-10 9:10 | MySQL Server: Views | Verified | S4 | 5.0, 5.1, 5.6.99, 6.0 | Any | Any | Implement MERGE algorithm for views which use UNION ALL |
| 14985 | 2005-11-16 13:07 | 2014-03-13 8:10 | MySQL Server: Views | Verified (3690 days) | S3 | 5.0.17 BK | Linux (Linux) | Any | Removing a Table "referenced" by a View is allowed |
| 61112 | 2011-05-10 7:31 | 2011-05-12 9:16 | MySQL Server: Views | Verified (4728 days) | S3 | 5.1.55 | Any | Any | Unqualified table names are changed silently |
| 58089 | 2010-11-09 18:40 | 2018-09-09 20:45 | MySQL Server: Views | Verified (4899 days) | S3 | 5.1.49-2-log, 5.0, 5.1, 5.6.99 | Linux (Debian) | Any | CREATE VIEW refuses WITH CHECK OPTION for updatable view |
| 56350 | 2010-08-29 20:52 | 2018-09-09 20:45 | MySQL Server: Views | Verified (4981 days) | S3 | 5.0, 5.1 | Other (Win XP) | Any | View of Union with literals compiles with wrong data types. |
| 54766 | 2010-06-24 10:33 | 2018-09-09 20:45 | MySQL Server: Views | Verified (5048 days) | S3 | 5.0.92, 5.1.49, 5.5.5-m3 | Any | Any | Impossible to use view after creation |
| 50716 | 2010-01-29 8:10 | 2012-05-18 20:19 | MySQL Server: Views | Verified (5194 days) | S3 | 5.1, mysql-next-mr | Any | Any | VIEW with UCS2 literals return wrong results |
| 41760 | 2008-12-27 2:01 | 2020-05-03 20:45 | MySQL Server: Views | Verified (5295 days) | S3 | 5.0 and up | Any | Any | Inserting into multiple-table views is not working |
| 42624 | 2009-02-05 15:53 | 2022-12-04 20:45 | MySQL Server: Views | Verified (5541 days) | S3 | 5.1.30, 5.0, 5.1, 6.0 bzr | Any (MS Windows, Linux) | Any | corrupt view when connecting while --skip-grant-tables is active |
| 23720 | 2006-10-27 14:09 | 2018-09-09 20:45 | MySQL Server: Views | Verified (5673 days) | S4 | 5.0.21-log | Any (All) | Any | There is no way to defer schema checking on CREATE VIEW |
| 6442 | 2004-11-04 20:33 | 2018-09-09 20:45 | MySQL Server: Views | Verified (5677 days) | S3 | 5.0.2, 5.1.28 | Any | Any | Views: updatability not established at view creation time |
| 39626 | 2008-09-24 11:17 | 2018-09-09 20:45 | MySQL Server: Views | Verified (5686 days) | S2 | 5.0.67, 5.0, 5.1, 6.0 bzr | Any | Any | Bad column case in a resultset of select from view |
| 35869 | 2008-04-07 9:12 | 2020-05-03 20:45 | MySQL Server: Views | Verified (5856 days) | S2 | 5.0/5.1/6.0 | Any | Any | Defining a view over an aggregate view renders the view definition invalid |
| 35499 | 2008-03-22 6:26 | 2018-09-09 20:45 | MySQL Server: Views | Verified (5872 days) | S3 | mysql-6.0-backup,5.1 | Linux | Any | View when created with swe7 character set fails. |
| 34023 | 2008-01-23 22:07 | 2020-05-03 20:45 | MySQL Server: Views | Verified (5929 days) | S3 | 5.0, 5.1 BK,6.0.5-alpha-debug | Linux (SUSE 10 / 64-bit) | Any | Views: column name length = 0 if binary non-latin |
| 5507 | 2004-09-10 2:35 | 2012-05-18 20:19 | MySQL Server: Views | Verified (5980 days) | S4 | 5.0.2-alpha | Linux (SuSE 8.2) | Any | TRUNCATE wth views needs better error message |
| 18433 | 2006-03-22 19:16 | 2022-12-04 20:45 | MySQL Server: Views | Verified (6099 days) | S4 | 5.0.25-BK, 5.1.x | Any (irrevelant) | Any | Lift limitation on using variables in view definition |
| 29347 | 2007-06-25 23:20 | 2020-05-03 20:45 | MySQL Server: Views | Verified (6143 days) | S3 | 5.1.20bk 5.0.44 | FreeBSD | Any | inconsistency in grant update(col) on view if user doesnt have select |
| 20356 | 2006-06-09 11:55 | 2021-12-17 13:46 | MySQL Server: Views | Verified (6148 days) | S2 | 5.0.22 + 5.1.11 | Windows (Windows, Mac OS X) | Any | Names containing UPPERCASES get LOWERCASE'd |
| 27713 | 2007-04-09 11:17 | 2020-05-03 20:45 | MySQL Server: Views | Verified (6219 days) | S3 | 5.0.38, 5.1, 5.2 | Any | Any | INSERTs fail for empty table using WITH_CHECK_OPTION |
| 19953 | 2006-05-19 18:58 | 2018-09-09 20:45 | MySQL Server: Views | Verified (6260 days) | S3 | 5.0.21-community-nt | Windows (win32 - XP SP2) | Any | Incomplete error when attempting to CREATE VIEW without SELECT GRANT |
| 17656 | 2006-02-22 23:32 | 2011-02-16 23:43 | MySQL Server: Views | Verified (6316 days) | S4 | Any | Perform Check for User before Creating Views in info_schema.views | ||
| 17370 | 2006-02-14 10:52 | 2011-02-16 23:43 | MySQL Server: Views | Verified (6639 days) | S4 | 5.0.18 | Linux (Linux) | Any | creation of invalid views impossible, valid flag missing |
| 16862 | 2006-01-27 23:20 | 2011-02-16 23:43 | MySQL Server: Views | Verified (6656 days) | S4 | 5.0.18 | Linux (linux) | Any | Views appear to have no indices |
| 15344 | 2005-11-30 9:43 | 2023-08-02 10:10 | MySQL Server: Views | Verified (6715 days) | S4 | Any | Any | Comments on views and triggers | |
| 13382 | 2005-09-21 15:16 | 2011-02-16 23:43 | MySQL Server: Views | Verified (6785 days) | S4 | 5.0.12/BK source | Linux (Linux Fedora Core 2) | Any | Renaming a Table that is use in VIEWS leads to client problems |
| 5502 | 2004-09-10 2:09 | 2012-05-18 20:19 | MySQL Server: Views | Verified (6818 days) | S4 | 5.0.2-alpha | Linux (SuSE 8.2) | Any | Views: ALGORITHM clause should be changed and moved |
| 5159 | 2004-08-23 1:42 | 2023-08-02 10:05 | MySQL Server: Views | Verified (6833 days) | S4 | 5.0.2-alpha-debug | Linux (SuSE 8.2) | Any | Views: Comments are not preserved |
| Showing all 29 (Edit, Save, CSV, Feed) |
