Showing 1-30 of 53 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
---|---|---|---|---|---|---|---|---|---|
4789 | 2004-07-28 16:01 | 2005-08-30 4:15 | MySQL Server | Closed (6786 days) | S3 | 4.0 4.1 | Any (all) | Any | Problem with natural join for more than 2 tables |
3759 | 2004-05-14 11:48 | 2004-08-30 17:15 | MySQL Server | Closed (7151 days) | S3 | 4.0.18 | FreeBSD (freebsd (possible all)) | Any | LEFT JOIN not fully optimized with IN condition in where |
20297 | 2006-06-06 16:05 | 2006-07-20 13:40 | MySQL Server | Closed (6462 days) | S1 | 4.0.27, 4.1.20, 4.1-BK | Any | a INNER JOIN b RIGHT JOIN c returns excessive rows | |
7455 | 2004-12-21 12:48 | 2004-12-28 11:35 | MySQL Server | Closed (7031 days) | S2 | 4.1 | Any | unexpected result: TRIM(<NULL> FROM <whatever>) gives NOT NULL | |
20954 | 2006-07-10 22:57 | 2006-08-09 20:00 | MySQL Server: Optimizer | Closed (6442 days) | S3 | 4.1, 5.0, 5.1 | Any | avg(keyval) retuns 0.38 but max(keyval) returns an empty set | |
11694 | 2005-07-01 20:24 | 2005-11-01 20:21 | MySQL Server: Optimizer | Closed (6723 days) | S3 | 4.1.12 | Windows (Windows) | Any | Column alias in ORDER BY works, but not if in an expression |
11185 | 2005-06-08 20:26 | 2005-06-24 17:19 | MySQL Server: Optimizer | Closed (6853 days) | S2 | 4.1.12 | *, freebsd | Any | index on unsigned bigint modifies result |
5080 | 2004-08-18 1:30 | 2004-08-20 22:43 | MySQL Server | Closed (7161 days) | S2 | 4.1.3-beta | Linux (Debian Linux 2.6.7) | Any | Bug with LEFT JOIN and TEMPORARY Tables |
4285 | 2004-06-25 13:11 | 2005-01-25 16:16 | MySQL Server | Closed (7003 days) | S3 | 4.1.3-beta bk tree | Linux (Linux) | Any | multiple key cache doesn't work properly |
6427 | 2004-11-04 10:34 | 2005-02-23 18:05 | MySQL Server | Closed (6974 days) | S3 | 4.1.6-gamma-standard-log | Linux (Linux) | Any | Replace error |
7331 | 2004-12-15 18:15 | 2005-01-26 23:54 | MySQL Server | Closed (7002 days) | S3 | 4.1.7 | Windows (Windows XP SP2) | Any | Mysql returns empty set when using order |
7377 | 2004-12-17 7:24 | 2005-01-28 0:03 | MySQL Server | Closed (7000 days) | S3 | 4.1.7 | Linux (linux, solaris) | Any | SHOW index on MERGE table crashes debug server |
6495 | 2004-11-08 10:18 | 2005-08-30 4:14 | MySQL Server | Closed (6786 days) | S3 | 4.1.7 | Linux (Linux) | Any | Illogical requirement for column qualification in NATURAL join |
6489 | 2004-11-07 23:18 | 2005-09-17 14:19 | MySQL Server | Closed (6768 days) | S3 | 4.1.7 | Linux (Linux) | Any | Named columns (USING) join returns redundant columns |
7425 | 2004-12-20 11:35 | 2005-03-10 17:57 | MySQL Server | Closed (6959 days) | S3 | 4.1.7 (probably others) | Any (any) | Any | inconsistent sort order on unsigned columns result of substraction |
7797 | 2005-01-11 10:18 | 2005-02-01 22:27 | MySQL Server | Closed (6996 days) | S3 | 4.1.8a | Solaris (Solaris 9) | Any | make test fails on count_distinct3 |
9067 | 2005-03-09 7:31 | 2008-11-02 18:49 | MySQL Server: Optimizer | Closed (5626 days) | S3 | 4.1.9 | Windows (Windows XP SP2) | Any | USING cannot match columns on second JOIN |
10646 | 2005-05-15 19:22 | 2005-08-29 22:06 | MySQL Server | Closed (6787 days) | S3 | 4.1.9 | Linux (linux dec alpha) | Any | Columns included in the join between two tables are ambigious in the select |
8023 | 2005-01-19 22:20 | 2005-02-21 19:28 | MySQL Server | Closed (6976 days) | S3 | 4.1.XX/5.0.XX | Linux (Slackware Linux) | Any | limit on UNION with from DUAL, causes syntax error |
6276 | 2004-10-27 6:51 | 2005-08-25 9:42 | MySQL Server | Closed (6791 days) | S2 | 5.0 | Linux (Linux) | Any | A SELECT that does a NATURAL JOIN of view and table crashes server |
17523 | 2006-02-17 11:32 | 2006-03-02 15:16 | MySQL Server | Closed (6602 days) | S3 | 5.0 | Any | natural join abd information_schema | |
21787 | 2006-08-22 15:46 | 2006-09-19 16:32 | MySQL Server | Closed (6401 days) | S3 | 5.0 + 5.1 + 4.1 | Windows (Windows, Linux) | Any | COUNT(*) + ORDER BY + LIMIT returns wrong result |
6558 | 2004-11-10 17:59 | 2005-08-27 19:27 | MySQL Server: Optimizer | Closed (6789 days) | S3 | 5.0.0-alpha-max-debug | Any | Views: CREATE VIEW fails with JOIN ... USING | |
12943 | 2005-09-02 4:45 | 2005-09-29 7:45 | MySQL Server: Optimizer | Closed (6756 days) | S2 | 5.0.12 | Any (any) | Any | bogus "Unknown column 'a.b' in 'on clause'" error |
13597 | 2005-09-29 7:39 | 2005-10-05 23:57 | MySQL Server: Optimizer | Closed (6750 days) | S2 | 5.0.12 | Any (any) | Any | Column in ON condition not resolved if references a table in nested right join |
13067 | 2005-09-08 16:11 | 2005-09-14 0:23 | MySQL Server: Optimizer | Closed (6771 days) | S3 | 5.0.12 beta/BK source | Windows (Windows NT/Linux) | Any | JOIN xxx USING is case sensitive |
12977 | 2005-09-04 12:29 | 2005-09-08 19:40 | MySQL Server: Optimizer | Closed (6777 days) | S2 | 5.0.12-beta-standard/BK source | Linux (Gentoo Linux) | Any | Crash referencing a joined column by table when a USING follows an ON |
13127 | 2005-09-13 3:21 | 2005-09-23 17:16 | MySQL Server: Views | Closed (6762 days) | S2 | 5.0.13 current bk | Any (any) | Any | LEFT JOIN against a VIEW returns NULL instead of correct value |
16710 | 2006-01-22 16:35 | 2006-04-06 13:24 | MySQL Server | Closed (6567 days) | S2 | 5.0.13-5.0.17 | FreeBSD (FreeBSD 5.4-6.0) | Any | select distinct doesn't return all it should |
14027 | 2005-10-14 13:45 | 2005-11-01 19:26 | MySQL Server: Views | Closed (6723 days) | S3 | 5.0.13-rc-nt, 5.0.15-rc BK | Linux (Linux, Windows XP) | Any | updatable views cannot be updated in certain cases |
Showing 1-30 of 53 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |