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: [email protected]
Reporter: [email protected]
CC: [email protected]
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.
