The sequence of data columns returned by "select * ..." is wrong about redisql HOT 11 CLOSED

Hi there,

it seems very very weird.

Can you post the database?

Can it be that you have the data swapped in the database?

Cheers,
Simone

from redisql.

You can create a new database backed by a file:

REDISQL.CREATE_DB new test.sqlite

And then copy your db to the new one.

REDISQL.COPY DB new

And now in test.sqlite there should be your original database.

Another alternative is running:

REDISQL.EXEC DB "SELECT C_TS FROM C_KAKOU;`

And print the result.

from redisql.

I'm very sorry, I don't understand what you mean too much. Could you please guide me in the specific operation?

from redisql.

Can you run this command:

REDISQL.EXEC DB "SELECT C_TS FROM C_KAKOU;"

What is the result?

from redisql.

According to the steps you know, the result of the execution is still the same, and the order of the columns is out of order.

1. 1. "AB3981"
   2. (integer) 1
   3. "2019-01-01 00:01:01.0"
   4. "jingzhou"
2. 1. "AB3982"
   2. (integer) 2
   3. "2019-01-01 00:01:02.0"
   4. "jingzhou"
3. 1. "AB3983"
   2. (integer) 3
   3. "2019-01-01 00:01:03.0"
   4. "jingzhou"
4. 1. "AB3984"
   2. (integer) 4
   3. "2019-01-01 00:01:04.0"
   4. "jingzhou"
5. 1. "AB3985"
   2. (integer) 5
   3. "2019-01-01 00:01:05.0"
   4. "jingzhou"
6. 1. "AB3986"
   2. (integer) 6
   3. "2019-01-01 00:01:06.0"
   4. "jingzhou"
7. 1. "AB3987"
   2. (integer) 7
   3. "2019-01-01 00:01:07.0"
   4. "jingzhou"
8. 1. "AB3988"
   2. (integer) 8
   3. "2019-01-01 00:01:08.0"
   4. "jingzhou"
9. 1. "AB3989"
   2. (integer) 9
   3. "2019-01-01 00:01:09.0"
   4. "jingzhou"
10. 1. "AB3990"
    2. (integer) 10
    3. "2019-01-01 00:01:10.0"
    4. "jingzhou"
11. 1. "AD3981"
    2. (integer) 1
    3. "huangshi"
    4. "2019-01-01 00:01:01.0"
12. 1. "AD3982"
    2. (integer) 2
    3. "huangshi"
    4. "2019-01-01 00:01:02.0"
13. 1. "AD3983"
    2. (integer) 3
    3. "huangshi"
    4. "2019-01-01 00:01:03.0"
14. 1. "AD3984"
    2. (integer) 4
    3. "huangshi"
    4. "2019-01-01 00:01:04.0"
15. 1. "AD3985"
    2. (integer) 5
    3. "huangshi"
    4. "2019-01-01 00:01:05.0"
16. 1. "AD3986"
    2. (integer) 6
    3. "huangshi"
    4. "2019-01-01 00:01:06.0"
17. 1. "AD3987"
    2. (integer) 7
    3. "huangshi"
    4. "2019-01-01 00:01:07.0"
18. 1. "AD3988"
    2. (integer) 8
    3. "huangshi"
    4. "2019-01-01 00:01:08.0"
19. 1. "AD3989"
    2. (integer) 9
    3. "huangshi"
    4. "2019-01-01 00:01:09.0"
20. 1. "AD3990"
    2. (integer) 10
    3. "huangshi"
    4. "2019-01-01 00:01:10.0"

from redisql.

Hello,

can you please run this query?

REDISQL.EXEC DB "SELECT C_TS FROM C_KAKOU;"

Note that we are selecting only the C_TS column, not all.

Thanks,
Simone

from redisql.

After your sorting out, I seriously suspect that my code has a bug when inserting data, thank you very much!

from redisql.

SQLite has dynamic typing for the columns of the database. So the type that you declare is an invite, it is not really a constraint.

Sometimes is very useful, some time can end up in this kind of problem.

Cheers,
Simone

from redisql.

Thank you for your detailed answers. I have located a bug that caused me to be out of order when inserting data. Thanks again!

from redisql.

Great!

I will close the issue.

from redisql.

Aw congrats on opening your first issue on github!

from redisql.