MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/5505 #5505: Views: an updatable view is falsely called non-updatable http://bugs.mysql.com/bug.php?id=5505 Submitted by: Peter Gulutzan
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (SuSE 8.2)
Version: 5.0.2-alpha
]]> Fri, 10 Sep 2004 02:25:55 +0000 Server: Views http://bugs.mysql.com/10977 #10977: Views: no warning if column name is truncated http://bugs.mysql.com/bug.php?id=10977 Submitted by: Peter Gulutzan
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (SUSE 9.2)
Version: 5.0.7-beta-debug
]]> Mon, 30 May 2005 21:27:28 +0000 Server: Views http://bugs.mysql.com/11551 #11551: Asymmetric + undocumented behaviour of DROP VIEW and DROP TABLE http://bugs.mysql.com/bug.php?id=11551 Submitted by: Matthias Leich
Category: Server: Views
Status: Closed
Severity: 3
Version: 5.0
]]> Fri, 24 Jun 2005 18:17:18 +0000 Server: Views http://bugs.mysql.com/12122 #12122: Views: ORDER BY doesn't have to mean merge http://bugs.mysql.com/bug.php?id=12122 Submitted by: Trudy Pelzer
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (SuSE 9.2)
Version: 5.0.11-beta-debug-log
]]> Fri, 22 Jul 2005 19:59:35 +0000 Server: Views http://bugs.mysql.com/13000 #13000: WEEKDAY function in views changed to WEEKDAY(TO_DATE(field)) http://bugs.mysql.com/bug.php?id=13000 Submitted by:
Category: Server: Views
Status: Closed
Severity: 3
OS: MacOS (Mac OSX 10.4/Linux)
Version: 5.0.11/BK Source
]]> Tue, 06 Sep 2005 00:28:56 +0000 Server: Views http://bugs.mysql.com/13127 #13127: LEFT JOIN against a VIEW returns NULL instead of correct value http://bugs.mysql.com/bug.php?id=13127 Submitted by: Timothy Smith
Category: Server: Views
Status: Closed
Severity: 2
OS: Any (any)
Version: 5.0.13 current bk
]]> Tue, 13 Sep 2005 03:21:52 +0000 Server: Views http://bugs.mysql.com/13410 #13410: HAVING clause filtering on qualified view column fails to resolve http://bugs.mysql.com/bug.php?id=13410 Submitted by: Dean Ellis
Category: Server: Views
Status: Closed
Severity: 1
Version: 5.0.14
]]> Thu, 22 Sep 2005 20:25:12 +0000 Server: Views http://bugs.mysql.com/13411 #13411: HAVING clause filtering on unqualified view column name crashes server http://bugs.mysql.com/bug.php?id=13411 Submitted by: Dean Ellis
Category: Server: Views
Status: Closed
Severity: 1
Version: 5.0.14
]]> Thu, 22 Sep 2005 20:29:13 +0000 Server: Views http://bugs.mysql.com/13451 #13451: mysql-test-run t/view.test produces warning about unfreed memory http://bugs.mysql.com/bug.php?id=13451 Submitted by: Sergey Petrunya
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux)
Version: 5.0-bk
]]> Fri, 23 Sep 2005 23:29:17 +0000 Server: Views http://bugs.mysql.com/13622 #13622: VIEW depending on information_schema.TRIGGERS claims it does not exist http://bugs.mysql.com/bug.php?id=13622 Submitted by: Roland Bouman
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux Suse, WinXP prof)
Version: 5.0.13/BK source
]]> Thu, 29 Sep 2005 20:23:18 +0000 Server: Views http://bugs.mysql.com/13629 #13629: view.test crashes in -max-debug build http://bugs.mysql.com/bug.php?id=13629 Submitted by: Sergey Petrunya
Category: Server: Views
Status: Closed
Severity: 3
Version: 5.0-bk
]]> Fri, 30 Sep 2005 03:00:20 +0000 Server: Views http://bugs.mysql.com/13683 #13683: INSERT DELAYED into a view create an infinite loop http://bugs.mysql.com/bug.php?id=13683 Submitted by: jocelyn fournier
Category: Server: Views
Status: Closed
Severity: 2
OS: Linux (linux)
Version: 5.0.14-rc/5.0.15-rc BK source
]]> Sat, 01 Oct 2005 15:23:50 +0000 Server: Views http://bugs.mysql.com/14027 #14027: updatable views cannot be updated in certain cases http://bugs.mysql.com/bug.php?id=14027 Submitted by: Eric Uhres
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux, Windows XP)
Version: 5.0.13-rc-nt, 5.0.15-rc BK
]]> Fri, 14 Oct 2005 13:45:59 +0000 Server: Views http://bugs.mysql.com/14308 #14308: server hang, with recursive view (after rename table) http://bugs.mysql.com/bug.php?id=14308 Submitted by: Martin Friebe
Category: Server: Views
Status: Closed
Severity: 2
OS: Windows (windows (likely others)/Linux)
Version: 5.0.15-nt/5.0.16 BK source
]]> Tue, 25 Oct 2005 22:26:29 +0000 Server: Views http://bugs.mysql.com/14466 #14466: Sort Order Incorrect in GROUP_CONCAT Function in a View http://bugs.mysql.com/bug.php?id=14466 Submitted by: Esteban Jesus
Category: Server: Views
Status: Closed
Severity: 3
OS: MacOS (Mac OS X 10.4.2/Linux)
Version: mysql-standard-5.0.15-osx10.4-powerpc-64/BK 5.0
]]> Sat, 29 Oct 2005 13:13:15 +0000 Server: Views http://bugs.mysql.com/14540 #14540: REPAIR, OPTIMIZE or ANALYZE a VIEW crashes server when underlying table is gone http://bugs.mysql.com/bug.php?id=14540 Submitted by: Shane Bester
Category: Server: Views
Status: Closed
Severity: 2
OS: Linux (Linux, Windows)
Version: 5.0.15, 5.0.16bk
]]> Tue, 01 Nov 2005 11:29:29 +0000 Server: Views http://bugs.mysql.com/14719 #14719: Views DEFINER grammar is incorrect http://bugs.mysql.com/bug.php?id=14719 Submitted by: Paul DuBois
Category: Server: Views
Status: Closed
Severity: 3
Version: 5.0.13 and up
]]> Mon, 07 Nov 2005 20:31:51 +0000 Server: Views http://bugs.mysql.com/14850 #14850: ERROR 1062 when a quering a view using a Group By on a column that can be null. http://bugs.mysql.com/bug.php?id=14850 Submitted by: Thomas Healy
Category: Server: Views
Status: Closed
Severity: 2
OS: Linux (Linux)
Version: 5.0.17-BK, 5.0.15
]]> Thu, 10 Nov 2005 23:13:27 +0000 Server: Views http://bugs.mysql.com/14873 #14873: SHOW CREATE VIEW: incorrect output http://bugs.mysql.com/bug.php?id=14873 Submitted by: Paul DuBois
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux)
Version: 5.0.13 and up
]]> Fri, 11 Nov 2005 17:47:37 +0000 Server: Views http://bugs.mysql.com/14875 #14875: Bad view DEFINER makes SHOW CREATE VIEW fail http://bugs.mysql.com/bug.php?id=14875 Submitted by: Paul DuBois
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux)
Version: 5.0.16/5.0.17 BK
]]> Fri, 11 Nov 2005 18:34:13 +0000 Server: Views http://bugs.mysql.com/14997 #14997: Valgrind errors running the lowercase_view test http://bugs.mysql.com/bug.php?id=14997 Submitted by: Guilhem Bichot
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (linux)
Version: 5.1
]]> Wed, 16 Nov 2005 20:21:14 +0000 Server: Views http://bugs.mysql.com/15096 #15096: View -> Function -> View = Crash http://bugs.mysql.com/bug.php?id=15096 Submitted by: Martin Aspeli
Category: Server: Views
Status: Closed
Severity: 2
OS: Windows (Windows XP/Linux)
Version: 5.0.15/5.0.17 BK
]]> Mon, 21 Nov 2005 12:24:33 +0000 Server: Views http://bugs.mysql.com/15119 #15119: temptable view + query cache = crash http://bugs.mysql.com/bug.php?id=15119 Submitted by: Oleksandr Byelkin
Category: Server: Views
Status: Closed
Severity: 2
OS: Any (all)
Version: 5.0
]]> Mon, 21 Nov 2005 23:13:43 +0000 Server: Views http://bugs.mysql.com/15153 #15153: CONVERT_TZ() not allowed in all places in VIEWs http://bugs.mysql.com/bug.php?id=15153 Submitted by: Beat Vontobel
Category: Server: Views
Status: Closed
Severity: 2
OS: Any (All)
Version: 5.0 BK
]]> Tue, 22 Nov 2005 22:47:22 +0000 Server: Views http://bugs.mysql.com/15950 #15950: NOW() optimized away to constant in BETWEEN ... AND ... in VIEWs http://bugs.mysql.com/bug.php?id=15950 Submitted by: Beat Vontobel
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux)
Version: 5.0.19-BK, 5.0.17-standard-log-i686-glibc23
]]> Fri, 23 Dec 2005 02:43:59 +0000 Server: Views http://bugs.mysql.com/16110 #16110: insert permitted into view col w/o default value http://bugs.mysql.com/bug.php?id=16110 Submitted by: Kolbe Kegel
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux)
Version: 5.0.17
]]> Sat, 31 Dec 2005 03:40:37 +0000 Server: Views http://bugs.mysql.com/16589 #16589: MySQL root user cannot access VIEW http://bugs.mysql.com/bug.php?id=16589 Submitted by: Hakan Küçükyılmaz
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux)
Version: 5.0
]]> Tue, 17 Jan 2006 23:41:07 +0000 Server: Views http://bugs.mysql.com/17203 #17203: "sql_no_cache sql_cache" in views created from prepared statement http://bugs.mysql.com/bug.php?id=17203 Submitted by: Dan Kloke
Category: Server: Views
Status: Closed
Severity: 3
OS: Linux (Linux, Windows 2000)
Version: 5.0.19-BK, 5.0.18
]]> Tue, 07 Feb 2006 20:51:59 +0000 Server: Views http://bugs.mysql.com/17254 #17254: Error for DEFINER security on VIEW provides too much info http://bugs.mysql.com/bug.php?id=17254 Submitted by: Arjen Lentz
Category: Server: Views
Status: Closed
Severity: 3
OS: Any (any)
Version: 5.0.19-BK, 5.0.18
]]> Thu, 09 Feb 2006 00:52:49 +0000 Server: Views http://bugs.mysql.com/17371 #17371: Unable to dump a schema with invalid views http://bugs.mysql.com/bug.php?id=17371 Submitted by: Kristian Koehntopp
Category: Server: Views
Status: Closed
Severity: 1
OS: Linux (Linux)
Version: 5.0.18
]]> Tue, 14 Feb 2006 11:02:14 +0000 Server: Views