phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacob Isaac (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-5122) PHOENIX-4322 breaks client backward compatibility
Date Wed, 06 Feb 2019 02:18:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-5122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16761378#comment-16761378
] 

Jacob Isaac commented on PHOENIX-5122:
--------------------------------------

I'll take back my last comment,

The bug existed in 4.13 client -> 4.13 server

Let me dig a little more the bug I was chasing (in ftests) was with the DELETE stmt with
IN clause. Thought these would behaved the same way.

log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
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)...
97/97 (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.326 seconds)
0: jdbc:phoenix:localhost> 
0: jdbc:phoenix:localhost> upsert into P_T000002 (oid, code) values ('0001', 'v0001');
1 row affected (0.034 seconds)
0: jdbc:phoenix:localhost> upsert into P_T000002 (oid, code) values ('0002', 'v0002');
1 row affected (0.003 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.032 seconds)*{color}
0: jdbc:phoenix:localhost> select * from P_T000002 ;
+------------------------------------------+------------------------------------------+
| OID | CODE |
+------------------------------------------+------------------------------------------+
| 0002 | v0002 |
| 0001 | v0001 |
+------------------------------------------+------------------------------------------+
2 rows selected (0.021 seconds)
0: jdbc:phoenix:localhost>

 

> PHOENIX-4322 breaks client backward compatibility
> -------------------------------------------------
>
>                 Key: PHOENIX-5122
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5122
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.13.0
>            Reporter: Jacob Isaac
>            Priority: Blocker
>             Fix For: 4.15.0, 4.14.2
>
>
> 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>



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message