Skip Menu |

This queue is for tickets about the SQL-Statement CPAN distribution.

Report information
The Basics
Id: 6154
Status: resolved
Priority: 0/
Queue: SQL-Statement
People
Owner: JZUCKER [...] cpan.org
Requestors: gipeol [...] sci.kun.nl
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Wed Apr 28 08:21:08 2004 Guest - Ticket created
Subject: AND/OR case sensitive
SQL-Statement-1.09/ Perl v5.8.0 Linux beta 2.4.20-4GB-athlon #1 Wed Apr 16 14:44:03 UTC 2003 i686 unknown unknown GNU/Linux When using the keywords 'and' and 'or' in lowercase in the WHERE-clause the parser doesn't output the expected array. For example the BETWEEN statement given and error when used like 'col_name BETWEEN 1 and 5'. And a statement like 'col1 = 3 and (col2 = 4 or col3 = 5)' the output is wrongly nested as if the input was '(col1 = 3 and col2 = 4) or col3 = 5'.
  Sun Feb 27 14:42:54 2005 JZUCKER [...] cpan.org - Correspondence added
The parsing of IN and BETWEEN clauses and of nested parens in WHERE clauses is vastly improved in the upcoming version 1.10. Both of your examples now work. Thanks for the report.
  Sun Feb 27 14:42:55 2005 JZUCKER [...] cpan.org - Status changed from 'new' to 'resolved'
  Sun Feb 27 14:42:55 2005 JZUCKER [...] cpan.org - Given to JZUCKER