Le 27/02/2019 à 14:55, Richard Hipp a écrit :
On 2/27/19, Richard Hipp <d...@sqlite.org> wrote:
The modified script can be downloaded from
https://sqlite.orge/tmp/tcl-sqlite-testcase-20190227125331.txt
Typo: "sqlite.org", not "sqlite.orge".
https://sqlite.org/tmp/tcl-sqlite-testcase-20190227125331.txt
Thank Mr Hipp, for your script
Platform here : Win 7 + SQLite 3.24.0 + Tcl 8.6.9
Additional precisions :
- Tcl provided by Magicsplat latest version (1.9.0)
(https://www.magicsplat.com/tcl-installer/index.html)
- SQLite package provided by AndroWish release "Asteroid Day"
vanilla distribution (http://www.androwish.org/download/index.html)
because we need JSON extension (absent from Magicsplat)
I ran your script and I didn't get same results as yours.
Here below are results from your script runed on my computer,
unchanged from my first post :
8.6
8.6.9
{2018-06-04 19:24:41
c7ee0833225bfd8c5ec2f9bf62b97c4e04d03bd9566366d5221ac8fb199a87ca}
# Sequence A
1.00
1.00 text
1.00 text
1.00 text
1.00 blob
1 real
# Sequence B
1.00
1.0 real
1.0 real
1.0 real
1.00 blob
1 real
# Sequence C
1.00
1.00 text
1.00 text
1.0 real
1.00 blob
1.0 real
Compared to your output from your computer :
8.6
8.6.9
{2019-02-26 18:21:08
6d39d6a68bf09e0b4f6706218373e74fc03148fd8bdba5031c3de2f750d87cf2}
# Sequence A
1.00
1.00 text
1.00 text
1.00 text
1.00 blob
1.00 text
# Sequence B
1.00
1.0 real
1.0 real
1.0 real
1.00 blob
1.00 text
# Sequence C
1.00
1.00 text
1.00 text
1.00 text
1.00 blob
1.00 text
Apart the unclear reasons the outputs differ between the two computers,
have you any explanation why the typof() output of
"SELECT DerefDict_SQL('A'), typeof(DerefDict_SQL('A'))" (identical in
both compturers)
gives "text" in Sequence A and "real" in Sequence B ?
Thank you
Jean-Baptiste
---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel
antivirus Avast.
https://www.avast.com/antivirus
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users