You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/01/31 14:47:31 UTC
[Bug 121695] New: SQL Queries: Using aliases "t" and "d" leads to
syntax error
https://issues.apache.org/ooo/show_bug.cgi?id=121695
Bug ID: 121695
Issue Type: DEFECT
Summary: SQL Queries: Using aliases "t" and "d" leads to syntax
error
Classification: Application
Product: database access
Version: AOO 3.4.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: minor
Priority: P3
Component: code
Assignee: issues@openoffice.apache.org
Reporter: w.jacques@netz-technik-buero.de
CC: issues@openoffice.apache.org
The following statements in the SQL-Query-Window lead to an error:
select d.ID from tbladressen d
select t.Hurz from Tabelle1 t
Syntax error in SQL expression
SQL-Status: HY000
Fehler-Code: 1000
syntax error, unxpected $end,
expecting BETWEEN or IN or
SQL_TOKEN_LIKE
The error occurs no matter if I use the internal HSQLDB engine or an external
mySQL database attached via Oracle MySQL Connector 1.0.1.
The problem seems to appear with the single letters "d" and "t" only, all other
combinations work fine. The problem still appears when using "AS".
With an external database, the problem does not appear when using direct mode.
Issue was discussed here (in German):
http://de.openoffice.info/viewtopic.php?f=8&t=61053
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121695] SQL Queries: Using aliases "t" and "d" leads to syntax
error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121695
Yurggent Alfredo Chable Torrez <yu...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |yurggent1.791@gmail.com
QA Contact| |xavi_dandy@hotmail.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121695] SQL Queries: Using aliases "t" and "d" leads to syntax
error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121695
--- Comment #1 from Wolfgang Jacques <w....@netz-technik-buero.de> ---
"d" and "t" sounds like "Date" and "Time" - this might add to the solution.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121695] SQL Queries: Using aliases "t" and "d" leads to syntax
error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121695
Javier Lopez <xa...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needhelp
Status|UNCONFIRMED |CONFIRMED
Latest|--- |AOO 3.4.1
Confirmation on| |
Ever confirmed|0 |1
--- Comment #3 from Javier Lopez <xa...@hotmail.com> ---
Hello
I was checking your bug and it's true. We'll try to repair soon.
Javier Lopez
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 121695] SQL Queries: Using aliases "t" and "d" leads to syntax
error
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121695
Fred Toussi <fr...@users.sourceforge.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |fredt@users.sourceforge.net
--- Comment #2 from Fred Toussi <fr...@users.sourceforge.net> ---
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"
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.