xavifeds8 commented on PR #2480:
URL: https://github.com/apache/phoenix/pull/2480#issuecomment-4484746348
**EARLIER BEHAVIOUR:**
1 row selected (0.012 seconds)
0: jdbc:phoenix:> DROP TABLE IF EXISTS test_no_workaround CASCADE;
>
No rows affected (0.948 seconds)
0: jdbc:phoenix:> CREATE TABLE test_no_workaround (
. . . . . . . .)> id VARCHAR PRIMARY KEY,
. . . . . . . .)> name VARCHAR
. . . . . . . .)> );
No rows affected (0.63 seconds)
0: jdbc:phoenix:> UPSERT INTO test_no_workaround(id, name, city VARCHAR,
department VARCHAR, age INTEGER)
. . . .semicolon> VALUES ('1', 'John Doe', 'Chennai', 'Engineering', 30);
. . . . . . . . >
. . . . . . . . > UPSERT INTO test_no_workaround(id, name, city VARCHAR,
department VARCHAR, age INTEGER)
. . . .semicolon> VALUES ('2', 'Jane Smith', 'Mumbai', 'Marketing', 28);
. . . . . . . . >
. . . . . . . . > UPSERT INTO test_no_workaround(id, name, city VARCHAR,
department VARCHAR, age INTEGER)
. . . .semicolon> VALUES ('3', 'Bob Wilson', 'Bangalore', 'Engineering', 35);
>
1 row affected (0.006 seconds)
1 row affected (0.004 seconds)
1 row affected (0.003 seconds)
0: jdbc:phoenix:> SELECT id, name, city, department
. . . .semicolon> FROM test_no_workaround(city VARCHAR, department VARCHAR)
. . . .semicolon> WHERE city = 'Chennai' AND department = 'Engineering';
org.apache.phoenix.schema.PTable$QualifierEncodingScheme$InvalidQualifierBytesException:
Invalid number of qualifier bytes. Expected length: 4. Actual: 4
at
org.apache.phoenix.schema.PTable$QualifierEncodingScheme.getReservedQualifier(PTable.java:549)
at
org.apache.phoenix.schema.PTable$QualifierEncodingScheme.access$400(PTable.java:318)
at
org.apache.phoenix.schema.PTable$QualifierEncodingScheme$3.decode(PTable.java:398)
at
org.apache.phoenix.filter.MultiEncodedCQKeyValueComparisonFilter$1.visit(MultiEncodedCQKeyValueComparisonFilter.java:182)
at
**CURRENT BEHAVIOUR :**
0: jdbc:phoenix:> DROP TABLE IF EXISTS test_no_workaround CASCADE;
. . . . . . . . > CREATE TABLE test_no_workaround (id VARCHAR PRIMARY KEY,
name VARCHAR);
. . . . . . . . > UPSERT INTO test_no_workaround(id, name, city VARCHAR,
department VARCHAR, age INTEGER) VALUES ('1', 'John Doe', '
Chennai', 'Engineering', 30);
. . . . . . . . > UPSERT INTO test_no_workaround(id, name, city VARCHAR,
department VARCHAR, age INTEGER) VALUES ('2', 'Jane Smith',
'Mumbai', 'Marketing', 28);
. . . . . . . . > UPSERT INTO test_no_workaround(id, name, city VARCHAR,
department VARCHAR, age INTEGER) VALUES ('3', 'Bob Wilson',
'Bangalore', 'Engineering', 35);
. . . . . . . . > SELECT id, name, city, department FROM
test_no_workaround(city VARCHAR, department VARCHAR) WHERE city = 'Chennai'
AND department = 'Engineering';
>
No rows affected (0.071 seconds)
No rows affected (0.734 seconds)
1 row affected (0.021 seconds)
1 row affected (0.004 seconds)
1 row affected (0.002 seconds)
+----+----------+---------+-------------+
| ID | NAME | CITY | DEPARTMENT |
+----+----------+---------+-------------+
| 1 | John Doe | Chennai | Engineering |
+----+----------+---------+-------------+
1 row selected (0.026 seconds)
0: jdbc:phoenix:> SELECT id, name, city, department FROM
test_no_workaround(city VARCHAR, department VARCHAR) WHERE city = 'Chennai'
AND department = 'Engineering';
+----+----------+---------+-------------+
| ID | NAME | CITY | DEPARTMENT |
+----+----------+---------+-------------+
| 1 | John Doe | Chennai | Engineering |
+----+----------+---------+-------------+
1 row selected (0.015 seconds)
0: jdbc:phoenix:>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
