Hi it's a lookup table. There roughly 600 entries, they were maualy cut and
pasted in the sql command line tool as one big insert.
insert into car_code
(
provider_id
,car_id
,car_code
)
values
(5,1,''),
(5,10001,'HONDA'),
(5,10002,'TOYOTA'),
(5,10003,'LEXUS'),
(5,10004,'FORD')
;
On Fri, Feb 2
Hi!
I wrote a test with your DDL and query, and it works for me. I need some
more time to dig into it..
Could you also, please, provide a way (with an example) how you insert data
to the table?
Thanks,
Maksim
On Fri, Feb 25, 2022 at 9:32 PM John Smith wrote:
> Hi Maksim did you look into this
Hi Maksim did you look into this?
On Tue., Feb. 22, 2022, 9:51 a.m. John Smith,
wrote:
> Hi. This is it.
>
> create table if not exists car_code (
> provider_id int,
> car_id int,
> car_code varchar(16),
> primary key (provider_id, car_id)
> ) with "template=replicatedTpl, key_type=C
Hi. This is it.
create table if not exists car_code (
provider_id int,
car_id int,
car_code varchar(16),
primary key (provider_id, car_id)
) with "template=replicatedTpl, key_type=CarCodeKey, value_type=CarCode";
select
car_id
from car_code
where
provider_id = ? and
car_co
Hi,
Yes, it looks strange. Could you please share your DDLs and queries that
led to the exception? We can add a compatibility test and it will help us
to investigate the issue.
Maksim
On Tue, Feb 15, 2022 at 3:28 PM John Smith wrote:
> It's weird. I dropped the table and recreated it without r
It's weird. I dropped the table and recreated it without restarting the
client applications and it started worked.
This hapenned after upgrading from 2.8.1 to 2.12.0
What's even funnier. I did the upgrade on my dev cluster first and let
everything run for a couple weeks just to be sure.
On Tue.,
Hi,
It looks like you have a column with non-String type, but try to query it
with a String argument.
Could you please share your DDL for table and query parameters for this
query?
Thanks,
Maksim
On Tue, Feb 15, 2022 at 8:54 AM John Smith wrote:
> Hi, on the client side I'm getting the below
