[PHOENIX-5122] PHOENIX-4322 breaks client backward compatibility

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 4.13.0
• Fix Version/s: 4.15.0, 5.1.0, 4.14.3
• Assignee: Jacob Isaac
• Reporter: Jacob Isaac
• Created: 05/Feb/19 00:35
• Updated: 03/Sep/19 18:00
• Resolved: 11/Jun/19 19:58

Description

Scenario :

4.13 client -> 4.14.1 server

Connected to: Phoenix (version 4.13)
Driver: PhoenixEmbeddedDriver (version 4.13)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to true to skip)...
135/135 (100%) Done
Done
sqlline version 1.1.9
0: jdbc:phoenix:localhost> 
0: jdbc:phoenix:localhost> 
0: jdbc:phoenix:localhost> CREATE table P_T000002 (oid VARCHAR NOT NULL, code VARCHAR NOT NULL constraint pk primary key (oid DESC, code DESC));
No rows affected (1.31 seconds)
0: jdbc:phoenix:localhost> 
0: jdbc:phoenix:localhost> upsert into P_T000002 (oid, code) values ('0001', 'v0001');
1 row affected (0.033 seconds)
0: jdbc:phoenix:localhost> upsert into P_T000002 (oid, code) values ('0002', 'v0002');
1 row affected (0.004 seconds)
0: jdbc:phoenix:localhost> 
0: jdbc:phoenix:localhost> select * from P_T000002 where (oid, code) IN (('0001', 'v0001'), ('0002', 'v0002'));
+------------------------------------------+------------------------------------------+
| OID | CODE |
+------------------------------------------+------------------------------------------+
+------------------------------------------+------------------------------------------+
{color:#FF0000}+*No rows selected (0.033 seconds)*+{color}
0: jdbc:phoenix:localhost> select * from P_T000002 ;
+------------------------------------------+------------------------------------------+
| OID | CODE |
+------------------------------------------+------------------------------------------+
| 0002 | v0002 |
| 0001 | v0001 |
+------------------------------------------+------------------------------------------+
2 rows selected (0.016 seconds)
0: jdbc:phoenix:localhost>
 

4.14.1 client -> 4.14.1 server 

Connected to: Phoenix (version 4.14)
Driver: PhoenixEmbeddedDriver (version 4.14)
Autocommit status: true
Transaction isolation: TRANSACTION_READ_COMMITTED
Building list of tables and columns for tab-completion (set fastconnect to true to skip)...
133/133 (100%) Done
Done
sqlline version 1.1.9
0: jdbc:phoenix:localhost> 
0: jdbc:phoenix:localhost> CREATE table P_T000001 (oid VARCHAR NOT NULL, code VARCHAR NOT NULL constraint pk primary key (oid DESC, code DESC));
No rows affected (1.273 seconds)
0: jdbc:phoenix:localhost> 
0: jdbc:phoenix:localhost> upsert into P_T000001 (oid, code) values ('0001', 'v0001');
1 row affected (0.056 seconds)
0: jdbc:phoenix:localhost> upsert into P_T000001 (oid, code) values ('0002', 'v0002');
1 row affected (0.004 seconds)
0: jdbc:phoenix:localhost> 
0: jdbc:phoenix:localhost> select * from P_T000001 where (oid, code) IN (('0001', 'v0001'), ('0002', 'v0002'));
+------------------------------------------+------------------------------------------+
| OID | CODE |
+------------------------------------------+------------------------------------------+
| 0002 | v0002 |
| 0001 | v0001 |
+------------------------------------------+------------------------------------------+
2 rows selected (0.051 seconds)
0: jdbc:phoenix:localhost> select * from P_T000001 ;
+------------------------------------------+------------------------------------------+
| OID | CODE |
+------------------------------------------+------------------------------------------+
| 0002 | v0002 |
| 0001 | v0001 |
+------------------------------------------+------------------------------------------+
2 rows selected (0.017 seconds)
0: jdbc:phoenix:localhost>

Issue Links

• is related to: PHOENIX-4322 DESC primary key column with variable length does not work in SkipScanFilter
• links to: GitHub Pull Request #442