๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
Google Git
Sign in
chromium / external / github.com / sqlite / sqlite / refs/heads/wal / src / where.c
  1. be837bd Avoid assertion faults in queries using indices with redundant columns. by drh ยท 16 years ago
  2. ed808ac The query planner fix of check-in [33b1f584ef] should have been on the trunk. by drh ยท 16 years ago
  3. ed754ce Further refinements to table order selection on join query planning. by drh ยท 16 years ago
  4. 1e0f4a8 The query planner uses non-indexable WHERE clause terms to reduce the by drh ยท 16 years ago
  5. f12cde5 Fix code coverage problems in where.c. by drh ยท 16 years ago
  6. 8bd5412 Fix the computation of the number of rows in a table during automatic by drh ยท 16 years ago
  7. 67ae0cb Fix an integer overflow bug in the automatic index logic. The bug was by drh ยท 16 years ago
  8. 52ff8ea Add testcase() macros to the automatic index logic to insure that boundary by drh ยท 16 years ago
  9. 0013e72 When constructing automatic indices do not include the same column more than by drh ยท 16 years ago
  10. c633908 Wrap all automatic index changes inside SQLITE_OMIT_AUTOMATIC_INDEX. Add by drh ยท 16 years ago
  11. 4139c99 Make sure that all automatic indices are covering indices. Otherwise, the by drh ยท 16 years ago
  12. a21a64d Veryquick.test is now working. The SQLITE_STMTSTATUS_AUTOINDEX counter added. by drh ยท 16 years ago
  13. 75bb9f5 Runs quicktest without hitting an assert now. Some tests get unexpected by drh ยท 16 years ago
  14. 424aab8 Progress toward getting automatic indices to work. Still failing in corner by drh ยท 16 years ago
  15. 8b307fb Automatically generate transient indices for tables in joins that would by drh ยท 16 years ago
  16. afc266a Clarification of the implementation of SQLITE_STMTSTATUS_FULLSCAN_STEP. by drh ยท 16 years ago
  17. c26c004 Increase the estimated cost of using a virtual table as the outer loop of a join when there exists an ORDER BY clause that is not satisfied by the virtual table. Fix for [775b39dd3c]. by dan ยท 16 years ago
  18. 5e767c5 Make sure the ON clause of a LEFT JOIN does not cause an index to be by drh ยท 16 years ago
  19. 9978c97 Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging by drh ยท 16 years ago
  20. 5cb7434 Fix a segfault that can occur when the LHS of a LIKE operator has an by drh ยท 16 years ago
  21. 46aae3c Changes to remove warnings in MSVC build. by shaneh ยท 16 years ago
  22. f49f352 Adjustments to column cache handling in order to restore 100% branch by drh ยท 16 years ago
  23. b6da74e Immediately purge entries from the column cache when the associated register by drh ยท 16 years ago
  24. b057e56 Remove unreachable code that was added by the fix to the "(xANDy)OR(z)" bug by drh ยท 16 years ago
  25. c01a3c1 Ensure WHERE clause terms involving tables on the right end of a join by drh ยท 16 years ago
  26. a62bb8d Make sure registers computed for the VFilter opcode are marked invalid by drh ยท 16 years ago
  27. 2f2855b Suppress more instances of unnecessary OP_IsNull and OP_Affinity opcodes. by drh ยท 16 years ago
  28. 039fc32 Code generator tries to avoid pointless OP_IsNull and OP_Affinity opcodes. by drh ยท 16 years ago
  29. f6a8203 Fix a reference to freed memory that can occur following an OOM error in by drh ยท 16 years ago
  30. 8cff69d Enhance the OP_Found and OP_NotFound opcodes so that they can accept an by drh ยท 16 years ago
  31. 35451c6 Suppress unnecessary OP_Noop instructions on when the right table of a by drh ยท 16 years ago
  32. c81c11f Remove the obsolete "$Id:$" RCS identifier strings from the source code. by drh ยท 16 years ago
  33. 1d452e1 Fix compiler warnings. Better comments on some variables associated with by drh ยท 16 years ago
  34. d91ca49 Add some sample requirement implementation comments to where.c. by drh ยท 16 years ago
  35. b4138de Remove an unreachable condition in the WHERE clause processing of bound by drh ยท 16 years ago
  36. 1d2ce4f Remove the sqlite3_reoptimize() API. The same functionality is now provided automatically to queries prepared using prepare_v2(). by dan ยท 16 years ago
  37. f7b0b0a When generating WHERE clause terms internally for NATURAL and USING joins, identify the table by its position in the FROM list, not by its name or alias. Fix for [b73fb0bd64]. by dan ยท 16 years ago
  38. bec451f Make sure the target register is allocated before adding the bogus by drh ยท 16 years ago
  39. 937d0de Add the experimental sqlite3_reoptimize() API. by dan ยท 16 years ago
  40. e83c4f3 Fix compilation with both OMIT_UTF16 and ENABLE_STAT2 defined. Ticket [56928bd084ea530eb8a0b3ebe5d2d9033fb1de7f|56928bd084]. by dan ยท 16 years ago
  41. 3f02218 Suppress some harmless compiler warnings. by drh ยท 16 years ago
  42. cea72b2 Warning cleanup from the MSVC compile. by shane ยท 16 years ago
  43. a8f5761 Remove an unreachable branch from where.c in order to restore 100% by drh ยท 16 years ago
  44. 011cfca Initialize variables differently in the range processing logic of where.c by drh ยท 16 years ago
  45. d001516 Change the expression code generator to account for the fact that the new by drh ยท 16 years ago
  46. daf4a9f Simplifications to the range-scan logic in support of structural testing. by drh ยท 16 years ago
  47. 98cdf62 Continuing refinements of the range-scan optimizations in where.c. by drh ยท 16 years ago
  48. cdaca55 Incremental code and comment cleanup in where.c. There is more to be done. by drh ยท 16 years ago
  49. 9aeda79 All the sqlite3GetCollSeq() function to specify an arbitrary text encoding. by drh ยท 16 years ago
  50. 69188d9 Add the SQLITE_ENABLE_STAT2 macro. If this is not defined at build-time, the stat2 table is not created, populated, or used. by dan ยท 16 years ago
  51. e275dc3 Change the sqlite_stat2 schema to be more flexible. by dan ยท 16 years ago
  52. 02fa469 First version of sqlite_stat2 (schema forces exactly 10 samples). by dan ยท 16 years ago
  53. 69f8bb9 If a binary operator in a WHERE clause that should be performed with no affinity conversions applied to its operands (see http://www.sqlite.org/datatype3.html) is optimized by index lookup, do not apply any conversions to the key value before looking it up in the index. Fix for 93fb9f89d6. by dan ยท 16 years ago
  54. 5236ac1 Changes to the query planner that improve the order in which tables/indexes are scanned in join queries. by dan ยท 16 years ago
  55. f51d1bd Fix a bug in where.c that could cause SQLite to write to freed memory while compiling a query with many terms in the WHERE clause. (CVS 6952) by danielk1977 ยท 16 years ago
  56. 3190f4b Fixed reversed labels in WHERETRACE() statement. Debugging code only. (CVS 6948) by shane ยท 16 years ago
  57. 595a523 Allow virtual tables to be used in shared-cache mode. (CVS 6928) by danielk1977 ยท 16 years ago
  58. e26fa4c Fix a link error and warning that can occur in where.c when compiling under MSVC with SQLITE_OMIT_VIRTUALTABLE defined. Ticket #3914. (CVS 6767) by shane ยท 17 years ago
  59. 8509570 Fix compiler warnings with MSVC build. (CVS 6761) by shane ยท 17 years ago
  60. 2c1a0c5 Add an ALWAYS() to a conditional in where.c. (CVS 6747) by drh ยท 17 years ago
  61. 5901b57 Do not let the reverse_unordered_selects pragma force the use of an index that by drh ยท 17 years ago
  62. 254993e Additional comments to clarify the operation of the LIKE optimizer in by drh ยท 17 years ago
  63. 4e8be3b Clarification of the operation of the OR-term optimizer in where.c. (CVS 6730) by drh ยท 17 years ago
  64. c4ac22e Disable the LIKE optimization if the affinity of the LHS column is by drh ยท 17 years ago
  65. 125feff Make sure the result of sqlite3VdbeGetOp() is not used as an array following by drh ยท 17 years ago
  66. 50d654d Additional changes to reduce stack usage. The SQLITE_SMALL_STACK compile-time by drh ยท 17 years ago
  67. 33e619f Additional refinements to Expr handling. Restore compression of trigger by drh ยท 17 years ago
  68. b7916a7 Simplifications to the Expr object: Remove Expr.span completely and convert by drh ยท 17 years ago
  69. e672c8e Do not transform a WHERE clause of the form "a = ? OR a = ?" to "a IN (?, ?)" if "a" is a column of a virtual table. Ticket #3871. (CVS 6671) by danielk1977 ยท 17 years ago
  70. b2f9efc Fix compiler warning found with gcc -Wextra. (CVS 6614) by drh ยท 17 years ago
  71. 60a4b53 Changes to silence compiler warnings under MSVC. (CVS 6613) by shane ยท 17 years ago
  72. 6a863cd Fix three variable initialization problems found by valgrind. (CVS 6612) by drh ยท 17 years ago
  73. 3500ed6 Make sure the left-shift operator never overflows. (CVS 6605) by drh ยท 17 years ago
  74. 24fb627 Record within the Token structure itself whether or not the token has by drh ยท 17 years ago
  75. 6eacd28 Fix a case in where.c where a crash can follow a malloc failure. Also modify test code in test8.c to check a return code that was being dropped (causing a test in vtab_err.test to fail). (CVS 6567) by danielk1977 ยท 17 years ago
  76. 336a530 Get rid of the special RowSet processing in where.c and move that into by drh ยท 17 years ago
  77. 46619d6 Make sure that the optimizer realizes that an "x IS NULL" contraint does not by drh ยท 17 years ago
  78. ceea332 Rework the column-cache mechanism to be more robust (and more correct). by drh ยท 17 years ago
  79. 044925b Eliminate the OP_VRowid opcode. The regular OP_Rowid now work for both by drh ยท 17 years ago
  80. 6149526 Change the OP_Rowid opcode so that a deferred OP_Seek is pending, it simply by drh ยท 17 years ago
  81. 1b26c7c Remove the rowhash object from the code. Rowset now fills its role. (CVS 6535) by drh ยท 17 years ago
  82. 732dc55 Fix a segfault that followed a malloc failure introduced by (6527). (CVS 6532) by danielk1977 ยท 17 years ago
  83. 1d46146 Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) by danielk1977 ยท 17 years ago
  84. 85799a4 Only enable WHERE-tracing when both TEST and DEBUG are enabled. (CVS 6463) by drh ยท 17 years ago
  85. 081a166 Always enable WHERE-tracing on a test build. by drh ยท 17 years ago
  86. 69a442e Make sure the reverse_unordered_selects pragma works even on unindexed by drh ยท 17 years ago
  87. e3e2ae4 Turn off the debugging macros in where.c - left on by mistake in the by drh ยท 17 years ago
  88. 75572e9 Improvements to cost estimation for evaluating the IN operator. by drh ยท 17 years ago
  89. 7c01f1d Remove an unused parameter from sqlite3DequoteExpr. Fix another unrelated by drh ยท 17 years ago
  90. 296a483 Allow the keyword INDEXED to be used as the name of a table or index or by drh ยท 17 years ago
  91. be22965 Make sure struct WhereClause is aligned on an 8-byte boundary. Fix for #3613, #3736. (CVS 6364) by danielk1977 ยท 17 years ago
  92. c0688ea Removed compiler warnings from MSVC builds. Ticket #3701. (CVS 6335) by shane ยท 17 years ago
  93. 2d2e7bd Reverse commit (6315) for now. (CVS 6317) by danielk1977 ยท 17 years ago
  94. e2d7b24 Scan an index instead of a table for "SELECT count(*) FROM <tbl>" queries. Because an index is usually smaller than a table on disk, this saves some IO. (CVS 6315) by danielk1977 ยท 17 years ago
  95. 699b3d4 Add the reverse_unordered_selects pragma. (CVS 6314) by drh ยท 17 years ago
  96. d336e22 Instead of using SetNumColumns, specify the number of columns in a table or index using the P4 argument. (CVS 6310) by danielk1977 ยท 17 years ago
  97. 6ab3a2e Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) by danielk1977 ยท 17 years ago
  98. fbd60f8 Changes to completely remove all floating point ops if SQLITE_OMIT_FLOATING_POINT defined. Note that w/o fp, date/time, round, nan, etc. are all gone or limited in functionality. Updated some of the test scripts to support missing fp and 64-bit functionality. Ticket #3029. (CVS 6250) by shane ยท 17 years ago
  99. 63207ab Remove compiler warnings under MSVC. (CVS 6249) by shane ยท 17 years ago
  100. d87897d Minor changes to remove a few MSVC compiler warnings at /W3. Ticket #3610. (CVS 6215) by shane ยท 17 years ago