Menu

#2536 (ok 2.11.2) Character \'+\' in query wrongly interpreted

2.11.0
fixed
1
2013-06-11
2007-09-20
Kemal
No

In v2.11.0 when the SQL SELECT query contains the plus ('+') character, after results are shown, if the [Show] button is used then the plus character is translated into a space (like in URL encoding).

To test:
SELECT * FROM my_table WHERE my_column LIKE '%+%'

Test the above on a table which can be like
CREATE TABLE my_table (my_column VARCHAR(32));
INSERT INTO my_table (my_column) VALUES ('+1'), ('+2'), ('+3');

Discussion

  • Marc Delisle

    Marc Delisle - 2007-09-23
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2007-09-23

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2007-09-23
    • priority: 5 --> 1
    • summary: Character '+' in query interpreted as space when using Show --> (ok 2.11.2) Character '+' in query wrongly interpreted
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-10-27
    • summary: (ok 2.11.2) Character '+' in query wrongly interpreted --> (ok 2.11.2) Character \'+\' in query wrongly interpreted
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

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