#77 Query builder: reverse "where a.x >= b.y" is wrong

2016.10
closed
bug (8)
2016-10-23
2012-09-25
PAscal
No

select * from a,b
where a.x >= b.y

returns

select *
from a inner join b on a.x=b.y

Discussion

  • PAscal

    PAscal - 2013-07-12

    Today SQLeo always generates SQL in ANSI format

    ANSI format is
    SELECT ... FROM tab1 inner join tab2 on tab1.field = tab2.field

    Non ANSI format or SQL92 format is
    SELECT ... FROM tab1, tab2
    where tab1.field = tab2.field

    Ticket #99 has been created to make SQLeo able to generate in NON-ANSI, SQL92 format
    but it will be for later

    So ticket # 77
    is that reverting
    SELECT ... FROM tab1 inner join tab2 on tab1.field <> tab2.field
    is correct

    but that reverting
    SELECT ... FROM tab1 inner join tab2 on tab1.field != tab2.field
    or
    SELECT ... FROM tab1, tab2
    where tab1.field != tab2.field

    generates
    SELECT ...FROM tab1 inner join tab2 on tab1.field = tab2.field
    when they should generate
    SELECT ... FROM tab1 inner join tab2 on tab1.field <> tab2.field

     
  • PAscal

    PAscal - 2015-09-07
    • Milestone: not planned --> Candidates
     
  • PAscal

    PAscal - 2015-09-08

    see ticket #273 that is similar

     
  • PAscal

    PAscal - 2016-08-18
    • Milestone: Candidates --> 2016.09
     
  • PAscal

    PAscal - 2016-09-25
    • Milestone: 2016.09 --> 2016.10
     
  • PAscal

    PAscal - 2016-09-25

    after reversing,
    query seems OK in GUI ( join is >=)
    but wrong in SQL syntax ...

     
  • PAscal

    PAscal - 2016-10-20
    • status: open --> commited
    • assigned_to: Dana Proctor
     
  • PAscal

    PAscal - 2016-10-23
    • status: commited --> closed
     

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks