Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#3068 (ok 3.5.4) subquery: wrong sql statement for export

3.4.9
fixed
1
2013-06-11
2010-07-26
Anonymous
No

If i enter a sql-statement (with subselect) and want to export some of the entries a syntactically wrong sql-statement results:
SELECT user FROM `jufiuser` WHERE user NOT IN ( SELECT user FROM bedenk )

results in

SELECT user FROM bedenkmass)
WHERE ( ( `jufiuser4`.`user` = 'bay' ) ) AND ( user NOT IN ( SELECT user FROM bedenkmass ) )

Discussion


  • Anonymous
    2010-07-26

    i have partly changed the tablenames in the first query but not in the result query. jufiuser should be jufiuser4 and bedenk should be bedenkmass in the first query too.

     
  • Marc Delisle
    Marc Delisle
    2010-08-01

    • summary: wrong sql statement for export --> subquery: wrong sql statement for export
     
  • Marc Delisle
    Marc Delisle
    2012-01-15

    Problem still present in 3.4.9.

     
  • Marc Delisle
    Marc Delisle
    2012-01-15

    • milestone: 1160431 --> 3.4.9
     
    • assigned_to: nobody --> chanaka777
     
  • This bug was fixed in repository and will be part of a future release; thanks for reporting.

     
    • priority: 5 --> 1
    • summary: subquery: wrong sql statement for export --> (ok 3.5.4) subquery: wrong sql statement for export
    • status: open --> open-fixed
     
  • Marc Delisle
    Marc Delisle
    2012-11-16

    • status: open-fixed --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed