| Anonymous | Login | Signup for a new account | 2010-09-07 19:22 EEST |
| Main | My View | View Issues | Change Log | Roadmap | Docs |
| Viewing Issue Simple Details [ Jump to Notes ] | [ << ] [ >> ] | [ View Advanced ] [ Issue History ] [ Print ] | |||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||
| 0000003 | [qot] general | crash | always | 2008-04-30 17:28 | 2008-06-15 16:12 | ||||
| Reporter | anonymous | View Status | public | ||||||
| Assigned To | administrator | ||||||||
| Priority | normal | Resolution | fixed | ||||||
| Status | resolved | Product Version | 0.0.3 | ||||||
| Summary | 0000003: Segfault for queries that use table alias | ||||||||
| Description |
This is for 0.0.3 which is not yet able to be chosen in Product Version field. This query type works: SELECT table.field FROM table WHERE table.field2 = 'x'; These query types segfault: SELECT t1.field FROM table AS t1 WHERE t1.field2 = 'x'; SELECT t1.field FROM table t1 WHERE t1.field2 = 'x'; |
||||||||
| Additional Information | The last query is the type of query that is generated by Catalyst, a perl MVC project. | ||||||||
| Tags | No tags attached. | ||||||||
| Attached Files | |||||||||
|
|
|||||||||
 Relationships |
|
|
Notes |
|
|
(0000006) mrballcb (reporter) 2008-04-30 17:46 |
The motivation of this bugfix request my plan to write a perl wrapper that will parse a mysql query.log and feed the queries to qot. Over half of the queries in our query.log use table aliases because we use Catalyst for our MVC framework. If need be I can parse the queries and replace the table aliases with actual table names, but it seems to be a function better done by qot itself. At any rate, it would be better handle it gracefully and spit out an error instead of segfaulting. |
|
(0000008) administrator (administrator) 2008-04-30 22:12 |
Yes, aliases are not supported at the moment and they are on my list. After this report I will give them even higher priority. Aliases are actually very important as you can't do self-joins without aliases, nor can you do some types of nested queries. |
|
(0000015) administrator (administrator) 2008-06-15 16:12 |
added full table and field aliases support in version 0.0.4 |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-04-30 17:28 | anonymous | New Issue | |
| 2008-04-30 17:46 | mrballcb | Note Added: 0000006 | |
| 2008-04-30 17:54 | mrballcb | Issue Monitored: mrballcb | |
| 2008-04-30 22:12 | administrator | Note Added: 0000008 | |
| 2008-04-30 22:12 | administrator | Assigned To | => administrator |
| 2008-04-30 22:12 | administrator | Status | new => confirmed |
| 2008-04-30 22:12 | administrator | version | 0.0.2 => 0.0.3 |
| 2008-06-15 16:12 | administrator | Note Added: 0000015 | |
| 2008-06-15 16:12 | administrator | Status | confirmed => resolved |
| 2008-06-15 16:12 | administrator | Resolution | open => fixed |
| Mantis 1.1.1[^] Copyright © 2000 - 2008 Mantis Group |  |
