Lines Matching refs:X
371 do_execsql_test e_update-2.2.X {
515 INSERT INTO t7 VALUES(1, 'one', 'X');
516 INSERT INTO t7 VALUES(2, 'two', 'X');
517 INSERT INTO t7 VALUES(3, 'three', 'X');
518 INSERT INTO t7 VALUES(4, 'four', 'X');
519 INSERT INTO t7 VALUES(5, 'five', 'X');
520 INSERT INTO t7 VALUES(6, 'six', 'X');
521 INSERT INTO t7 VALUES(7, 'seven', 'X');
522 INSERT INTO t7 VALUES(8, 'eight', 'X');
523 INSERT INTO t7 VALUES(9, 'nine', 'X');
524 INSERT INTO t7 VALUES(10, 'ten', 'X');
532 1 "UPDATE t7 SET s = q LIMIT 5" {1 2 3 4 5 X X X X X}
533 2 "UPDATE t7 SET s = r WHERE q>2 LIMIT 4" {1 2 three four five six X X X X}
534 3 "UPDATE t7 SET s = q LIMIT 0" {1 2 three four five six X X X X}
543 3 "UPDATE t7 SET s = 'X' LIMIT -1" {X X X X X X X X X X}
552 1 "UPDATE t7 SET s = q ORDER BY r LIMIT 3" {X X X 4 5 X X 8 X X}
553 2 "UPDATE t7 SET s = r ORDER BY r DESC LIMIT 2" {X two three 4 5 X X 8 X X}
554 3 "UPDATE t7 SET s = q ORDER BY q DESC LIMIT 5" {X two three 4 5 6 7 8 9 10}
556 X "UPDATE t7 SET s = 'X'" {X X X X X X X X X X}
565 1 "UPDATE t7 SET s = q ORDER BY q LIMIT 3 OFFSET 2" {X X 3 4 5 X X X X X}
566 2 "UPDATE t7 SET s = q ORDER BY q DESC LIMIT 2, 3 " {X X 3 4 5 6 7 8 X X}
568 X "UPDATE t7 SET s = 'X'" {X X X X X X X X X X}
580 1 "UPDATE t7 SET s = q LIMIT 4, 2" {X X X X 5 6 X X X X}
581 2 "UPDATE t7 SET s = q LIMIT 2 OFFSET 7" {X X X X 5 6 X 8 9 X}