Re: [sqlite] sqlite and lemon operator precedence problem/question

2007-11-17 Thread D. Richard Hipp
On Nov 17, 2007, at 5:30 PM, Joe Wilson wrote: sqlite> select ~1 - ~5; -8 sqlite> select (~1) - (~5); 4 That would be a bug in lemon... I guess adopting the same operator precedence as MySQL or MS SQL Server is out of the question? I believe SQLite uses the same operator prec

Re: [sqlite] sqlite and lemon operator precedence problem/question

2007-11-17 Thread Joe Wilson
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > I was wrong. Turns out the bug was in the SQLite grammar > file parse.y. It was assigning the same precedence to the > ones-complement ~ operator and the NOT operator. But > ~ should have higher precedence, it seems. Fixed by > check-in [4548].

Re: [sqlite] sqlite and lemon operator precedence problem/question

2007-11-17 Thread Joe Wilson
> > sqlite> select ~1 - ~5; > > -8 > > sqlite> select (~1) - (~5); > > 4 > > > > That would be a bug in lemon... I guess adopting the same operator precedence as MySQL or MS SQL Server is out of the question? http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html BINARY, COLLAT

Re: [sqlite] sqlite and lemon operator precedence problem/question

2007-11-17 Thread D. Richard Hipp
On Nov 17, 2007, at 5:12 PM, D. Richard Hipp wrote: On Nov 17, 2007, at 4:58 PM, Joe Wilson wrote: I'm having difficulty with Lemon's operator precedence. That would be a bug in lemon... I was wrong. Turns out the bug was in the SQLite grammar file parse.y. It was assigning the same

Re: [sqlite] sqlite and lemon operator precedence problem/question

2007-11-17 Thread D. Richard Hipp
On Nov 17, 2007, at 4:58 PM, Joe Wilson wrote: I'm having difficulty with Lemon's operator precedence. Given SQLite's operator precedence table where it's presumably interpreted with lowest precedence tokens at the top to the highest precedence tokens at the bottom: %left OR. %left AND.