Bug 89418 - Query don't work with directly connect at Microsoft Access file (not Access 2007)
Summary: Query don't work with directly connect at Microsoft Access file (not Access 2...
Status: RESOLVED DUPLICATE of bug 83454
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.3.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: mc
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-16 14:32 UTC by mc
Modified: 2015-02-20 20:35 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
demo file .mdb (MS Access < 2007 version) (652.00 KB, application/vnd.ms-access)
2015-02-17 08:00 UTC, mc 		Details
file .odb attached to demo file .mdb (2.81 KB, application/vnd.sun.xml.base)
2015-02-17 08:03 UTC, mc 		Details
sql query missing comma (15.47 KB, image/png)
2015-02-20 18:48 UTC, raal 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description mc 2015-02-16 14:32:45 UTC 
On my file .odb connected directly at Microsoft Access file, now my Query get this error : 
SQL Status: 3075
Error code: -2147217900
Syntax error (missing operator) in query expression ''2012-2013' `Campagna`'.

This is the query : 
SELECT '2012-2013' AS `Campagna`, 'OLIO' AS `Prodotto`, `DO_NUDOC` AS `NrDoc`, `DO_DTDOC` AS `DataDoc`, `DO_DESTI` AS `Cliente`, `DO_TOTAL` AS `TotFattura`
FROM `DOCUMENTI` 
WHERE `DO_TPDOC` = 'FT' 
AND `DO_DESTI` IN ( '222', '180' )

If I connect my .odb via ODBC the query work fine, but i have worked correctly with LO < 4.3 and direct connection at file .mdb
Tried on 2 pc with LO 4.3.5 and 4.1.1
OO 4.1.1 work !
Comment 1 raal 2015-02-17 07:23:36 UTC 
Hello,

Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 mc 2015-02-17 08:00:10 UTC 
Created attachment 113444 [details]
demo file .mdb (MS Access < 2007 version)
Comment 3 mc 2015-02-17 08:03:06 UTC 
Created attachment 113445 [details]
file .odb attached to demo file .mdb

In this file from menu Edit->Database->Propertiers... select the correct path to .mdb file
Comment 4 raal 2015-02-20 18:48:02 UTC 
Created attachment 113557 [details]
sql query missing comma

in your query is comma "," missing between 'First name' and 'Name'
Comment 5 raal 2015-02-20 18:51:02 UTC 
Can you see if bug 83454 is similar to your problem so that I can mark your report as a duplicate of it? (Later bugs are generally marked as duplicates of earlier bugs).
Comment 6 mc 2015-02-20 19:31:38 UTC 
(In reply to raal from comment #5)
> Can you see if bug 83454 is similar to your problem so that I can mark your
> report as a duplicate of it? (Later bugs are generally marked as duplicates
> of earlier bugs).

I realized that the problem is in aliases, but considering that the queries works properly via ODBC

Yes is same problem to bug 83454 !


In your comment #4 :
to write 
SELECT "First name" "Name" FROM ...
is same method to
SELECT "First name" AS "Name" FROM ...
Comment 7 mc 2015-02-20 19:34:22 UTC 
The problem is also present in LO 4.4.1
Comment 8 raal 2015-02-20 20:35:10 UTC 

*** This bug has been marked as a duplicate of bug 83454 ***