Re: [sqlite] apparent column data type affected by numeric operation elsewhere

[mm.w]

Hello,

attached my build settings/patches if it helps, I added stuff for win

Best.



On Mon, Mar 24, 2014 at 10:15 AM, mm.w <0xcafef...@gmail.com> wrote:

> Hello ok thx,
>
> I currently use 3.8.3.1 amalgamation, I try to keep on official updates, I
> have already mine to deal with
>
> Best.
>
>
> On Mon, Mar 24, 2014 at 10:10 AM, Richard Hipp <d...@sqlite.org> wrote:
>
>> On Mon, Mar 24, 2014 at 1:07 PM, mm.w <0xcafef...@gmail.com> wrote:
>>
>> > Hello,
>> >
>> > is it fixed in 3.8.4.1 or only in the repo?
>> > is that possible to add the date on the "Download Page" section?
>> >
>>
>> It was fixed earlier this morning on trunk.  You can download the latest
>> sources from the website (see the "tarball" and "zip archive" links on
>> http://www.sqlite.org/src/info/221f8f9447) or you can use the diffs on
>> that
>> page to patch whatever version of Fossil you are using.
>>
>>
>>
>> >
>> > Best.
>> >
>> >
>> > On Mon, Mar 24, 2014 at 8:35 AM, Richard Hipp <d...@sqlite.org> wrote:
>> >
>> > > Also worked correctly in 3.8.2.  Problem introduced in 3.8.3.  Fixed
>> > here:
>> > > http://www.sqlite.org/src/info/221f8f9447
>> > >
>> > >
>> > >
>> > >
>> > > On Mon, Mar 24, 2014 at 4:52 AM, Clemens Ladisch <clem...@ladisch.de>
>> > > wrote:
>> > >
>> > > > Hi,
>> > > >
>> > > > it appears that SQLite thinks it can reuse a register even when
>> > > > another operation changes it by applying numeric affinity:
>> > > >
>> > > > > create table t(x);
>> > > > > insert into t values('1');
>> > > > > select typeof(x) from t where x=x;
>> > > > text
>> > > > > select typeof(x) from t where x=x+0;
>> > > > integer
>> > > >
>> > > > (first reported here: <http://stackoverflow.com/questions/22598026
>> >)
>> > > >
>> > > > This worked correctly in SQLite 3.7.17.
>> > > >
>> > > >
>> > > > Regards,
>> > > > Clemens
>> > > > _______________________________________________
>> > > > sqlite-users mailing list
>> > > > sqlite-users@sqlite.org
>> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > > >
>> > >
>> > >
>> > >
>> > > --
>> > > D. Richard Hipp
>> > > d...@sqlite.org
>> > > _______________________________________________
>> > > sqlite-users mailing list
>> > > sqlite-users@sqlite.org
>> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> > >
>> > _______________________________________________
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> >
>>
>>
>>
>> --
>> D. Richard Hipp
>> d...@sqlite.org
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>

#ifndef __clang_analyzer__

#ifndef _REENTRANT
        #define _REENTRANT 1
#endif
#define SQLITE_ENABLE_COLUMN_METADATA 1
#define SQLITE_HAVE_ISNAN 1
#define SQLITE_THREADSAFE 1
#define SQLITE_ENABLE_FTS3 1
#define SQLITE_ENABLE_RTREE 1
#define SQLITE_DEFAULT_PAGE_SIZE 4096

#if defined(_MSC_VER)
        #include <windows.h>
        #include <time.h>
        #include <float.h>
        #include <string.h>
        #ifndef usleep
                static inline void _usleep_win(__int64 useconds)
                { 
                        HANDLE timer;
                        LARGE_INTEGER due;
                        due.QuadPart = -(10 * useconds);
                        timer = CreateWaitableTimer(NULL, TRUE, NULL);
                        SetWaitableTimer(timer, &due, 0, NULL, NULL, FALSE);
                        WaitForSingleObject(timer, INFINITE);
                        CloseHandle(timer); 
                }
                #define usleep(x) _usleep_win((x))
        #endif
        #if _MSC_VER < 1600
                #ifndef isnan
                        #define isnan(x) ((x)!=(x))
                #endif
                #ifndef isinf
                        #define isinf(x) (!_finite((x)))
                #endif
        #else
                #ifndef isnan
                        #define isnan(x) _isnan((x))
                #endif
                #ifndef isinf
                        #define isinf(x) (!_finite((x)))
                #endif
                #ifndef gmtime_r
                        #define gmtime_r(tp, tm) ((gmtime_s((tm), (tp)) == 0) ? 
(tp) : NULL)
                #endif
        
                #ifndef localtime_r
                        #define localtime_r(tp, tm) ((localtime_s((tm), (tp)) 
== 0) ? (tp) : NULL)
                #endif
                
                #ifndef strerror_r
                        #define strerror_r(errno, buf, len) strerror_s((buf), 
(len), (errno))
                #endif
                
                #define HAVE_STDINT_H 1
                #define HAVE_USLEEP 1
                #define HAVE_LOCALTIME_R 1
                #define HAVE_GMTIME_R 1
                #define HAVE_STRERROR_R 1
        #endif
#else
        #define HAVE_STDINT_H 1
        #define HAVE_USLEEP 1
        #define HAVE_LOCALTIME_R 1
        #define HAVE_GMTIME_R 1
        #define HAVE_STRERROR_R 1
#endif

/* here goes [sqlite3.c] */

#endif /* !!__clang_analyzer__ */
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users