Virtual Table Problem

by cyntacks » Mon, 10 Nov 2008 20:42:52 GMT


Sponsored Links
 Hi All,

I Am experiencing a strange issue regarding the joining of a SQLite3
Virtual Table with a "regular" table. MY result allways pull back 0
records, but if i run the same sql on the 2 reular tables it pulls
back all records. After hours or debugging this I am starting to
believe I may not fully comprehend what this sql does on the backend.
This returns now rows:

SELECT v.name, o.year
FROM NAMES_VIRTUAL v
JOIN SOME_OTHER o ON o.test_id = v._id

Now, the STRANGE part of all this is using the "regular" table which
was used to create the virtual table works fine and BOTH the "test_id"
and "_id' values ARE in each table:

SELECT n.name, o.year
FROM NAMES n
JOIN SOME_OTHER o ON o.test_id = n._id

What am I missing, is it possible to join a Vitual and "regular"
table, sqlite3 doc claims it is, but..

Thanks for the help,

Kevin

--~--~---------~--~----~------------~-------~--~----~



Virtual Table Problem

by cyntacks » Mon, 10 Nov 2008 22:40:33 GMT


 GOT IT!!! This was driving me nuts for HOURS!!!!

Long story short, SQLite does not validate fields, that is, you can
stick an INTEGER into a VARCHAR. My code was inserting an INTEGER into
a VARCHAR "assuming" it would be cast into a VARCHAR but in actuality
no conversion takes place, it was just being treated as an INTEGER,
thus my join failed becuase SQLite was seeing the entry as in INTEGER!

Wow, that took WAY too long to figure out...





--~--~---------~--~----~------------~-------~--~----~


Sponsored Links


Virtual Table Problem

by Mark Murphy » Mon, 10 Nov 2008 22:47:38 GMT


 


That's a SQLite-ism. Types expressed in table schemas are hints more so 
than mandates.

-- 
Mark Murphy (a Commons Guy)
 http://commonsware.com 

Android Training on the Ranch! -- Mar 16-20, 2009
 http://www.bignerdranch.com/schedule.shtml 

--~--~---------~--~----~------------~-------~--~----~



Other Threads

1. enable EAP sim in nexus one

Hi Guys

I have modify the RIL code to enable AT+CSIM command support and
loaded it in to nexus one phone
but when i try to send the following AT command

D/RILC    (  119): C[locl]> CSIM_LOCAL
D/RIL     (  119): onRequest: CSIM_LOCAL 105
D/RIL     (  119): requestCSIMLocal --> AT
+CSIM=42,"A088000010FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF"

the entire phone panic ..

checking the last_kmsg shows
[  996.088867] ARM9 has CRASHED
[  996.089294] smem: DIAG '[WCDMA] 12:35:45 FATAL:  (DS  :PFault :
00020) (0)
[  996.089324] '
[  996.090026]
[  996.090393] Restarting Linux version 2.6.35.9-cyanogenmod (l...@low-
virtual-machine) (gcc version 4.4.0 (GCC) ) #1 PREEMPT Sat Dec 11
21:19:13 MYT 2010
[  996.090454]

i have attempt to send other AT+CSIM command and they responds ok , so
i would assume that the code i modify is all right.

any input that can help me to solve this issue is much appreciated .
how does ARM comes into play when i send AT-command to gsm modem ?

Thanks






-- 

2. x86 Creating filesystem error

I am building android for x86,when creating system.img,appear the
follow error.
Can anybody know how to fix it.

make_ext4fs -l 128M -a system out/target/product/generic_x86/obj/
PACKAGING/systemimage_intermediates/system.img out/target/product/
generic_x86/system
Creating filesystem with parameters:
    Size: 134217728
    Block size: 4096
    Blocks per group: 32768
    Inodes per group: 8192
    Inode size: 256
    Journal blocks: 1024
    Label:
    Blocks: 32768
    Block groups: 1
    Reserved block group size: 7
error: do_inode_allocate_extents: Failed to allocate 141 blocks

-- 

3. Android CTS

4. issues in building GingerBread

5. how to track market search terms

6. how to check phone support torch mode..problem pls solve

7. OpenGL Problem with Sphere Texture Mapping