1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sql/SQLite/sqliteLimit.h Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,183 @@
1.4 +/*
1.5 +** 2007 May 7
1.6 +**
1.7 +** The author disclaims copyright to this source code. In place of
1.8 +** a legal notice, here is a blessing:
1.9 +**
1.10 +** May you do good and not evil.
1.11 +** May you find forgiveness for yourself and forgive others.
1.12 +** May you share freely, never taking more than you give.
1.13 +**
1.14 +*************************************************************************
1.15 +**
1.16 +** This file defines various limits of what SQLite can process.
1.17 +**
1.18 +** @(#) $Id: sqliteLimit.h,v 1.8 2008/03/26 15:56:22 drh Exp $
1.19 +*/
1.20 +
1.21 +/*
1.22 +** The maximum length of a TEXT or BLOB in bytes. This also
1.23 +** limits the size of a row in a table or index.
1.24 +**
1.25 +** The hard limit is the ability of a 32-bit signed integer
1.26 +** to count the size: 2^31-1 or 2147483647.
1.27 +*/
1.28 +#ifndef SQLITE_MAX_LENGTH
1.29 +# define SQLITE_MAX_LENGTH 1000000000
1.30 +#endif
1.31 +
1.32 +/*
1.33 +** This is the maximum number of
1.34 +**
1.35 +** * Columns in a table
1.36 +** * Columns in an index
1.37 +** * Columns in a view
1.38 +** * Terms in the SET clause of an UPDATE statement
1.39 +** * Terms in the result set of a SELECT statement
1.40 +** * Terms in the GROUP BY or ORDER BY clauses of a SELECT statement.
1.41 +** * Terms in the VALUES clause of an INSERT statement
1.42 +**
1.43 +** The hard upper limit here is 32676. Most database people will
1.44 +** tell you that in a well-normalized database, you usually should
1.45 +** not have more than a dozen or so columns in any table. And if
1.46 +** that is the case, there is no point in having more than a few
1.47 +** dozen values in any of the other situations described above.
1.48 +*/
1.49 +#ifndef SQLITE_MAX_COLUMN
1.50 +# define SQLITE_MAX_COLUMN 2000
1.51 +#endif
1.52 +
1.53 +/*
1.54 +** The maximum length of a single SQL statement in bytes.
1.55 +**
1.56 +** It used to be the case that setting this value to zero would
1.57 +** turn the limit off. That is no longer true. It is not possible
1.58 +** to turn this limit off.
1.59 +*/
1.60 +#ifndef SQLITE_MAX_SQL_LENGTH
1.61 +# define SQLITE_MAX_SQL_LENGTH 1000000000
1.62 +#endif
1.63 +
1.64 +/*
1.65 +** The maximum depth of an expression tree. This is limited to
1.66 +** some extent by SQLITE_MAX_SQL_LENGTH. But sometime you might
1.67 +** want to place more severe limits on the complexity of an
1.68 +** expression.
1.69 +**
1.70 +** A value of 0 used to mean that the limit was not enforced.
1.71 +** But that is no longer true. The limit is now strictly enforced
1.72 +** at all times.
1.73 +*/
1.74 +#ifndef SQLITE_MAX_EXPR_DEPTH
1.75 +# define SQLITE_MAX_EXPR_DEPTH 1000
1.76 +#endif
1.77 +
1.78 +/*
1.79 +** The maximum number of terms in a compound SELECT statement.
1.80 +** The code generator for compound SELECT statements does one
1.81 +** level of recursion for each term. A stack overflow can result
1.82 +** if the number of terms is too large. In practice, most SQL
1.83 +** never has more than 3 or 4 terms. Use a value of 0 to disable
1.84 +** any limit on the number of terms in a compount SELECT.
1.85 +*/
1.86 +#ifndef SQLITE_MAX_COMPOUND_SELECT
1.87 +# define SQLITE_MAX_COMPOUND_SELECT 500
1.88 +#endif
1.89 +
1.90 +/*
1.91 +** The maximum number of opcodes in a VDBE program.
1.92 +** Not currently enforced.
1.93 +*/
1.94 +#ifndef SQLITE_MAX_VDBE_OP
1.95 +# define SQLITE_MAX_VDBE_OP 25000
1.96 +#endif
1.97 +
1.98 +/*
1.99 +** The maximum number of arguments to an SQL function.
1.100 +*/
1.101 +#ifndef SQLITE_MAX_FUNCTION_ARG
1.102 +# define SQLITE_MAX_FUNCTION_ARG 100
1.103 +#endif
1.104 +
1.105 +/*
1.106 +** The maximum number of in-memory pages to use for the main database
1.107 +** table and for temporary tables. The SQLITE_DEFAULT_CACHE_SIZE
1.108 +*/
1.109 +#ifndef SQLITE_DEFAULT_CACHE_SIZE
1.110 +# define SQLITE_DEFAULT_CACHE_SIZE 2000
1.111 +#endif
1.112 +#ifndef SQLITE_DEFAULT_TEMP_CACHE_SIZE
1.113 +# define SQLITE_DEFAULT_TEMP_CACHE_SIZE 500
1.114 +#endif
1.115 +
1.116 +/*
1.117 +** The maximum number of attached databases. This must be between 0
1.118 +** and 30. The upper bound on 30 is because a 32-bit integer bitmap
1.119 +** is used internally to track attached databases.
1.120 +*/
1.121 +#ifndef SQLITE_MAX_ATTACHED
1.122 +# define SQLITE_MAX_ATTACHED 10
1.123 +#endif
1.124 +
1.125 +
1.126 +/*
1.127 +** The maximum value of a ?nnn wildcard that the parser will accept.
1.128 +*/
1.129 +#ifndef SQLITE_MAX_VARIABLE_NUMBER
1.130 +# define SQLITE_MAX_VARIABLE_NUMBER 999
1.131 +#endif
1.132 +
1.133 +/* Maximum page size. The upper bound on this value is 32768. This a limit
1.134 +** imposed by the necessity of storing the value in a 2-byte unsigned integer
1.135 +** and the fact that the page size must be a power of 2.
1.136 +*/
1.137 +#ifndef SQLITE_MAX_PAGE_SIZE
1.138 +# define SQLITE_MAX_PAGE_SIZE 32768
1.139 +#endif
1.140 +
1.141 +
1.142 +/*
1.143 +** The default size of a database page.
1.144 +*/
1.145 +#ifndef SQLITE_DEFAULT_PAGE_SIZE
1.146 +# define SQLITE_DEFAULT_PAGE_SIZE 1024
1.147 +#endif
1.148 +#if SQLITE_DEFAULT_PAGE_SIZE>SQLITE_MAX_PAGE_SIZE
1.149 +# undef SQLITE_DEFAULT_PAGE_SIZE
1.150 +# define SQLITE_DEFAULT_PAGE_SIZE SQLITE_MAX_PAGE_SIZE
1.151 +#endif
1.152 +
1.153 +/*
1.154 +** Ordinarily, if no value is explicitly provided, SQLite creates databases
1.155 +** with page size SQLITE_DEFAULT_PAGE_SIZE. However, based on certain
1.156 +** device characteristics (sector-size and atomic write() support),
1.157 +** SQLite may choose a larger value. This constant is the maximum value
1.158 +** SQLite will choose on its own.
1.159 +*/
1.160 +#ifndef SQLITE_MAX_DEFAULT_PAGE_SIZE
1.161 +# define SQLITE_MAX_DEFAULT_PAGE_SIZE 8192
1.162 +#endif
1.163 +#if SQLITE_MAX_DEFAULT_PAGE_SIZE>SQLITE_MAX_PAGE_SIZE
1.164 +# undef SQLITE_MAX_DEFAULT_PAGE_SIZE
1.165 +# define SQLITE_MAX_DEFAULT_PAGE_SIZE SQLITE_MAX_PAGE_SIZE
1.166 +#endif
1.167 +
1.168 +
1.169 +/*
1.170 +** Maximum number of pages in one database file.
1.171 +**
1.172 +** This is really just the default value for the max_page_count pragma.
1.173 +** This value can be lowered (or raised) at run-time using that the
1.174 +** max_page_count macro.
1.175 +*/
1.176 +#ifndef SQLITE_MAX_PAGE_COUNT
1.177 +# define SQLITE_MAX_PAGE_COUNT 1073741823
1.178 +#endif
1.179 +
1.180 +/*
1.181 +** Maximum length (in bytes) of the pattern in a LIKE or GLOB
1.182 +** operator.
1.183 +*/
1.184 +#ifndef SQLITE_MAX_LIKE_PATTERN_LENGTH
1.185 +# define SQLITE_MAX_LIKE_PATTERN_LENGTH 50000
1.186 +#endif