Description
Steps to reproduce are as follows:
1. Create an immutable table with multiple column families:
0: jdbc:phoenix:> CREATE TABLE TEST ( . . . . . . . . > ID VARCHAR PRIMARY KEY, . . . . . . . . > A.COL1 VARCHAR, . . . . . . . . > B.COL2 VARCHAR . . . . . . . . > ) IMMUTABLE_ROWS = TRUE; No rows affected (1.182 seconds)
2. Upsert some rows:
0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id0', '0', 'a'); 1 row affected (0.138 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id1', '1', NULL); 1 row affected (0.009 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id2', '2', 'b'); 1 row affected (0.011 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id3', '3', NULL); 1 row affected (0.007 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id4', '4', 'c'); 1 row affected (0.006 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id5', '5', NULL); 1 row affected (0.007 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id6', '6', 'd'); 1 row affected (0.007 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id7', '7', NULL); 1 row affected (0.007 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id8', '8', 'e'); 1 row affected (0.007 seconds) 0: jdbc:phoenix:> UPSERT INTO TEST VALUES ('id9', '9', NULL); 1 row affected (0.009 seconds)
3. Count query is okay:
0: jdbc:phoenix:> SELECT COUNT(COL1) FROM TEST WHERE COL2 IS NOT NULL; +----------------+ | COUNT(A.COL1) | +----------------+ | 5 | +----------------+ 1 row selected (0.1 seconds)
4. However, the following select query returns wrong result (it should return 5 records):
0: jdbc:phoenix:> SELECT COL1 FROM TEST WHERE COL2 IS NOT NULL; +-------+ | COL1 | +-------+ | 0 | | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | +-------+ 10 rows selected (0.058 seconds)
Attachments
Attachments
Issue Links
- links to