Here are the opcodes generated for each operation using the EXPLAIN command
sqlite> explain select offsets(pasta_text), DataPasta from pasta_text where past a_text match 'andamento*'; addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Trace 0 0 0 00 1 Goto 0 14 0 00 2 VOpen 0 0 0 vtab:3E6EE8:46A920 00 3 String8 0 3 0 andamento* 00 4 Integer 37 1 0 00 5 Integer 1 2 0 00 6 VFilter 0 12 1 00 7 VColumn 0 35 1 00 8 Function 0 1 4 offsets(1) 01 9 VColumn 0 4 5 00 10 ResultRow 4 2 0 00 11 VNext 0 7 0 00 12 Close 0 0 0 00 13 Halt 0 0 0 00 14 Transaction 0 0 0 00 15 VerifyCookie 0 297 0 00 16 Goto 0 2 0 00 sqlite> explain select offsets(pasta_text), DataPasta from pasta_text where past a_text match 'andamento*' group by DataPasta; addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Trace 0 0 0 00 1 OpenEphemeral 1 3 0 keyinfo(1,BINARY) 00 2 Integer 0 4 0 00 3 Integer 0 3 0 00 4 Gosub 6 41 0 00 5 Goto 0 45 0 00 6 VOpen 0 0 0 vtab:3E6EE8:46A920 00 7 String8 0 11 0 andamento* 00 8 Integer 37 9 0 00 9 Integer 1 10 0 00 10 VFilter 0 17 9 00 11 VColumn 0 4 9 00 12 Sequence 1 10 0 00 13 VColumn 0 35 11 00 14 MakeRecord 9 3 12 00 15 IdxInsert 1 12 0 00 16 VNext 0 11 0 00 17 Close 0 0 0 00 18 Sort 1 44 0 00 19 Column 1 0 8 00 20 Compare 7 8 1 keyinfo(1,BINARY) 00 21 Jump 22 26 22 00 22 Move 8 7 1 00 23 Gosub 5 34 0 00 24 IfPos 4 44 0 00 25 Gosub 6 41 0 00 26 Column 1 2 1 00 27 Column 1 0 2 00 28 Integer 1 3 0 00 29 Next 1 19 0 00 30 Gosub 5 34 0 00 31 Goto 0 44 0 00 32 Integer 1 4 0 00 33 Return 5 0 0 00 34 IfPos 3 36 0 00 35 Return 5 0 0 00 36 SCopy 1 9 0 00 37 Function 0 9 13 offsets(1) 01 38 SCopy 2 14 0 00 39 ResultRow 13 2 0 00 40 Return 5 0 0 00 41 Null 0 1 0 00 42 Null 0 2 0 00 43 Return 6 0 0 00 44 Halt 0 0 0 00 45 Transaction 0 0 0 00 46 VerifyCookie 0 297 0 00 47 Goto 0 6 0 00 sqlite> -- View this message in context: http://old.nabble.com/Bug-in-using-overloaded-functions-for-virtual-tables--tp32364864p32726667.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
