Error when change version from 0.9 to 1.0.1 about redisql HOT 3 CLOSED

Hi,

it should be compatible, hence you are seeing a bug.

I am guessing you are using file-backed databases, is that correct?
A wild guess is that you loading twice the statements here, once from the RDB file and one from the normal file. Or maybe once from the RDB and once from the AOF.
Is that possible?

Can you share the data with us so that we can quickly find a solution?

Send free to send whatever is necessary to re-produce the issue at [email protected]

from redisql.

Hi,

I can't share my data, I already run command flushdb in redis :v
But below is steps I do:

1. I use version 0.9 with empty data
2. I make a db name backup with file-backed ( it already contain data)
3. I create a db name myDb and use command REDISQL.COPY to copy from backup to myDb
4. My application connects to myDB and it always creates some query statements and updates if it already exists

And this issue occurs when I change the version to 1.0.1 and restart Redis.

from redisql.

Thanks for the detailed steps.

I will try to re-produce the issue and if I succeed I will decide what is the best way forward, thanks for the report.

I will keep the issue open as a reminder for myself.

from redisql.