#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

  • Comment has been marked as spam. 
    Undo

    You can see all pending comments posted by this user  here

    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
     
  • Chanaka Indrajith Dharmarathna

    • assigned_to: nobody --> chanaka777
     
  • Chanaka Indrajith Dharmarathna

    This bug was fixed in repository and will be part of a future release; thanks for reporting.

     
  • Chanaka Indrajith Dharmarathna

    • 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
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks