Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | SQL Queries: Using aliases "t" and "d" leads to syntax error | ||
---|---|---|---|
Product: | Base | Reporter: | Wolfgang Jacques <w.jacques> |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | Javier Lopez <xavi_dandy> |
Severity: | Minor | ||
Priority: | P3 | CC: | fredt, issues, yurggent1.791 |
Version: | 3.4.1 | Keywords: | needhelp |
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows 7 | ||
Issue Type: | DEFECT | Latest Confirmation in: | 3.4.1 |
Developer Difficulty: | --- |
Description
Wolfgang Jacques
2013-01-31 13:47:31 UTC
"d" and "t" sounds like "Date" and "Time" - this might add to the solution. Confirmed. Also happens when you use ts instead of t. The workaround is to use any of the following forms: select d.ID from tbladressen "d" select t.Hurz from Tabelle1 "t" select d.ID from tbladressen "D" select t.Hurz from Tabelle1 "T" Hello I was checking your bug and it's true. We'll try to repair soon. Javier Lopez |