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/12963 #12963: Problem with DAYOFWEEK(CURDATE()) and View http://bugs.mysql.com/bug.php?id=12963 Submitted by: Are Casilla
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Linux (Debian version 2.6.8-2-686)
Version: MySQL 5.0.12-beta-standard
]]> Sat, 03 Sep 2005 08:22:18 +0000 Server: Views http://bugs.mysql.com/13452 #13452: UNION + VIEW == ERROR 1048 (23000), Column 'id1' cannot be null http://bugs.mysql.com/bug.php?id=13452 Submitted by: Timothy Smith
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Any (all)
Version: 5.0
]]> Sat, 24 Sep 2005 00:30:48 +0000 Server: Views http://bugs.mysql.com/13472 #13472: memory leak in view.test http://bugs.mysql.com/bug.php?id=13472 Submitted by: Sergei Golubchik
Category: Server: Views
Status: Duplicate
Severity: 3
Version: 5.0
]]> Sun, 25 Sep 2005 20:38:09 +0000 Server: Views http://bugs.mysql.com/14493 #14493: DESCRIBE viewname shows wrong result http://bugs.mysql.com/bug.php?id=14493 Submitted by: MySQL-Front Team
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Windows (Windows XP/Linux)
Version: 5.0.15/BK source 5.0
]]> Sun, 30 Oct 2005 20:04:17 +0000 Server: Views http://bugs.mysql.com/15753 #15753: column alias not recognized in a query that uses views http://bugs.mysql.com/bug.php?id=15753 Submitted by: Kevin Gilpin
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Windows (Windows)
Version: 5.0.16, 5.0.17
]]> Wed, 14 Dec 2005 18:11:03 +0000 Server: Views http://bugs.mysql.com/20500 #20500: trim(both ' ' from col) causes syntax error in a view http://bugs.mysql.com/bug.php?id=20500 Submitted by: Shane Bester
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Any (*)
Version: 5.0BK, 5.1.11
]]> Fri, 16 Jun 2006 12:30:17 +0000 Server: Views http://bugs.mysql.com/23464 #23464: A view with an ORDER BY clause becomes non-updatable http://bugs.mysql.com/bug.php?id=23464 Submitted by: Giuseppe Maxia
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Any (all)
Version: 5.0.27-BK, 5.0.26 and 5.1.12
]]> Thu, 19 Oct 2006 14:02:32 +0000 Server: Views http://bugs.mysql.com/24070 #24070: 'show create view' fails for ALL PRIVILEGES user when definer can't view http://bugs.mysql.com/bug.php?id=24070 Submitted by: River Tarnell
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Solaris (Solaris 10)
Version: 5.0.24a-max-log
]]> Wed, 08 Nov 2006 03:15:05 +0000 Server: Views http://bugs.mysql.com/25109 #25109: Query on a view drops a record http://bugs.mysql.com/bug.php?id=25109 Submitted by: Jrme Despatis
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Linux (Linux, Debian Testing Kernel 2.6.18)
Version: 5.0.34-BK, 5.0.30
]]> Sat, 16 Dec 2006 12:19:44 +0000 Server: Views http://bugs.mysql.com/25585 #25585: Make test fails for 5.0.33 http://bugs.mysql.com/bug.php?id=25585 Submitted by: Sebastian Nohn
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Linux (Linux 2.6.15 (Ubuntu 6.06))
Version: 5.0.33
]]> Fri, 12 Jan 2007 13:09:28 +0000 Server: Views http://bugs.mysql.com/25991 #25991: Views are always lowercase http://bugs.mysql.com/bug.php?id=25991 Submitted by: Peter Olson
Category: Server: Views
Status: Duplicate
Severity: 3
OS: MacOS (OS X)
Version: 5.0.27
]]> Wed, 31 Jan 2007 20:08:01 +0000 Server: Views http://bugs.mysql.com/30057 #30057: Removed function Calls from Select Expresion when Creating Views http://bugs.mysql.com/bug.php?id=30057 Submitted by: Stefan Haubold
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Linux (Debian 3.1, Mysql DotDeb)
Version: 5.0.41
]]> Wed, 25 Jul 2007 23:41:14 +0000 Server: Views http://bugs.mysql.com/32842 #32842: If ALTER VIEW spans more rows VIEW_DEFINITION is incorrect updated. http://bugs.mysql.com/bug.php?id=32842 Submitted by: Santo Leto
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Windows (XPSP2)
Version: 5.1.22-rc, 6.0.3
]]> Thu, 29 Nov 2007 12:35:25 +0000 Server: Views http://bugs.mysql.com/36774 #36774: different outputs for show create view for the same view http://bugs.mysql.com/bug.php?id=36774 Submitted by: Ecker Sandor
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Windows (XP)
Version: 5.0.51a,5.1.24rc
]]> Sat, 17 May 2008 07:41:50 +0000 Server: Views http://bugs.mysql.com/38649 #38649: View's SELECT contains a variable or parameter http://bugs.mysql.com/bug.php?id=38649 Submitted by: Daniel Penza
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Windows
Version: 5.0.51a
]]> Fri, 08 Aug 2008 02:00:13 +0000 Server: Views http://bugs.mysql.com/39427 #39427: join_nested.test produces valgrind warning in mysql_create_view() http://bugs.mysql.com/bug.php?id=39427 Submitted by: Gleb Shchepa
Category: Server: Views
Status: Duplicate
Severity: 1
OS: Any
Version: 5.0+
]]> Fri, 12 Sep 2008 19:18:32 +0000 Server: Views http://bugs.mysql.com/40097 #40097: mysql_register_view initializes query.str to a stack allocated buffer http://bugs.mysql.com/bug.php?id=40097 Submitted by: Mark Callaghan
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Any
Version: 5.0.67, 5.0 bzr
]]> Fri, 17 Oct 2008 02:36:36 +0000 Server: Views http://bugs.mysql.com/41561 #41561: View creation statement hard-codes the database name http://bugs.mysql.com/bug.php?id=41561 Submitted by: Sheeri Cabral
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Linux
Version: 5.0.45
]]> Wed, 17 Dec 2008 16:29:42 +0000 Server: Views http://bugs.mysql.com/41899 #41899: "orgtable" field info changed in MySQL 5.1 http://bugs.mysql.com/bug.php?id=41899 Submitted by: Andrew Hanna
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1.30
]]> Tue, 06 Jan 2009 17:45:19 +0000 Server: Views http://bugs.mysql.com/46779 #46779: restore fails as 'dummy' table representing VIEW is invalid http://bugs.mysql.com/bug.php?id=46779 Submitted by: Peter Laursen
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Any
Version: 5.1.37
]]> Tue, 18 Aug 2009 09:36:12 +0000 Server: Views http://bugs.mysql.com/48456 #48456: syntax error in view containing natural join within a row() construct http://bugs.mysql.com/bug.php?id=48456 Submitted by: Shane Bester
Category: Server: Views
Status: Duplicate
Severity: 2
OS: Any
Version: 5.0.85, 5.1.40
]]> Sat, 31 Oct 2009 21:27:05 +0000 Server: Views http://bugs.mysql.com/49853 #49853: Create view sometimes creates an invalid view http://bugs.mysql.com/bug.php?id=49853 Submitted by: Andrew Garner
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Linux
Version: 5.0.88,5.1.41, next-mr
]]> Mon, 21 Dec 2009 18:04:22 +0000 Server: Views http://bugs.mysql.com/54139 #54139: cannot view structure of invalid view in some cases http://bugs.mysql.com/bug.php?id=54139 Submitted by: Shane Bester
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Any
Version: >=5.1.40, 5.1.47, 5.5.4
]]> Tue, 01 Jun 2010 12:16:00 +0000 Server: Views http://bugs.mysql.com/59005 #59005: error 1356 using coalesce or ifnull in order to customize grandtotal text http://bugs.mysql.com/bug.php?id=59005 Submitted by: nick rulez
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Any
Version: 5.1.36, 5.5.9
]]> Fri, 17 Dec 2010 18:58:06 +0000 Server: Views http://bugs.mysql.com/60628 #60628: Error 1064 on SELECT from VIEW containing TIMESTAMPDIFF(MICROSECOND, ...) http://bugs.mysql.com/bug.php?id=60628 Submitted by: Clifford Johnson
Category: Server: Views
Status: Duplicate
Severity: 3
OS: Any (XP SP3)
Version: 5.5.9, 5.5.11
]]> Thu, 24 Mar 2011 21:23:49 +0000 Server: Views