drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 1 | /* |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 2 | ** 2001 September 15 |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 3 | ** |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 4 | ** The author disclaims copyright to this source code. In place of |
| 5 | ** a legal notice, here is a blessing: |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 6 | ** |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 7 | ** May you do good and not evil. |
| 8 | ** May you find forgiveness for yourself and forgive others. |
| 9 | ** May you share freely, never taking more than you give. |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 10 | ** |
| 11 | ************************************************************************* |
| 12 | ** This file contains code to implement a pseudo-random number |
| 13 | ** generator (PRNG) for SQLite. |
| 14 | ** |
| 15 | ** Random numbers are used by some of the database backends in order |
| 16 | ** to generate random integer keys for tables or random filenames. |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 17 | */ |
| 18 | #include "sqliteInt.h" |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 19 | |
drh | af9ff33 | 2002-01-16 21:00:27 +0000 | [diff] [blame] | 20 | |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 21 | /* All threads share a single random number generator. |
| 22 | ** This structure is the current state of the generator. |
| 23 | */ |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 24 | static SQLITE_WSD struct sqlite3PrngType { |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 25 | unsigned char isInit; /* True if initialized */ |
| 26 | unsigned char i, j; /* State variables */ |
| 27 | unsigned char s[256]; /* State variables */ |
drh | 1875f7a | 2008-12-08 18:19:17 +0000 | [diff] [blame] | 28 | } sqlite3Prng; |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 29 | |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 30 | /* |
drh | ad75e98 | 2001-10-09 04:19:46 +0000 | [diff] [blame] | 31 | ** Get a single 8-bit random value from the RC4 PRNG. The Mutex |
| 32 | ** must be held while executing this routine. |
drh | af9ff33 | 2002-01-16 21:00:27 +0000 | [diff] [blame] | 33 | ** |
| 34 | ** Why not just use a library random generator like lrand48() for this? |
drh | f0863fe | 2005-06-12 21:35:51 +0000 | [diff] [blame] | 35 | ** Because the OP_NewRowid opcode in the VDBE depends on having a very |
drh | af9ff33 | 2002-01-16 21:00:27 +0000 | [diff] [blame] | 36 | ** good source of random numbers. The lrand48() library function may |
| 37 | ** well be good enough. But maybe not. Or maybe lrand48() has some |
| 38 | ** subtle problems on some systems that could cause problems. It is hard |
| 39 | ** to know. To minimize the risk of problems due to bad lrand48() |
drh | aaab572 | 2002-02-19 13:39:21 +0000 | [diff] [blame] | 40 | ** implementations, SQLite uses this random number generator based |
drh | af9ff33 | 2002-01-16 21:00:27 +0000 | [diff] [blame] | 41 | ** on RC4, which we know works very well. |
drh | f0863fe | 2005-06-12 21:35:51 +0000 | [diff] [blame] | 42 | ** |
| 43 | ** (Later): Actually, OP_NewRowid does not depend on a good source of |
| 44 | ** randomness any more. But we will leave this code in all the same. |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 45 | */ |
drh | ea67883 | 2008-12-10 19:26:22 +0000 | [diff] [blame] | 46 | static u8 randomByte(void){ |
drh | bbd82df | 2004-02-11 09:46:30 +0000 | [diff] [blame] | 47 | unsigned char t; |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 48 | |
drh | ad75e98 | 2001-10-09 04:19:46 +0000 | [diff] [blame] | 49 | |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 50 | /* The "wsdPrng" macro will resolve to the pseudo-random number generator |
| 51 | ** state vector. If writable static data is unsupported on the target, |
| 52 | ** we have to locate the state vector at run-time. In the more common |
| 53 | ** case where writable static data is supported, wsdPrng can refer directly |
| 54 | ** to the "sqlite3Prng" state vector declared above. |
| 55 | */ |
| 56 | #ifdef SQLITE_OMIT_WSD |
| 57 | struct sqlite3PrngType *p = &GLOBAL(struct sqlite3PrngType, sqlite3Prng); |
| 58 | # define wsdPrng p[0] |
| 59 | #else |
| 60 | # define wsdPrng sqlite3Prng |
| 61 | #endif |
| 62 | |
| 63 | |
drh | 90bfcda | 2001-09-23 19:46:51 +0000 | [diff] [blame] | 64 | /* Initialize the state of the random number generator once, |
| 65 | ** the first time this routine is called. The seed value does |
| 66 | ** not need to contain a lot of randomness since we are not |
| 67 | ** trying to do secure encryption or anything like that... |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 68 | ** |
| 69 | ** Nothing in this file or anywhere else in SQLite does any kind of |
| 70 | ** encryption. The RC4 algorithm is being used as a PRNG (pseudo-random |
| 71 | ** number generator) not as an encryption device. |
| 72 | */ |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 73 | if( !wsdPrng.isInit ){ |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 74 | int i; |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 75 | char k[256]; |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 76 | wsdPrng.j = 0; |
| 77 | wsdPrng.i = 0; |
drh | d677b3d | 2007-08-20 22:48:41 +0000 | [diff] [blame] | 78 | sqlite3OsRandomness(sqlite3_vfs_find(0), 256, k); |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 79 | for(i=0; i<256; i++){ |
drh | ea67883 | 2008-12-10 19:26:22 +0000 | [diff] [blame] | 80 | wsdPrng.s[i] = (u8)i; |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 81 | } |
| 82 | for(i=0; i<256; i++){ |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 83 | wsdPrng.j += wsdPrng.s[i] + k[i]; |
| 84 | t = wsdPrng.s[wsdPrng.j]; |
| 85 | wsdPrng.s[wsdPrng.j] = wsdPrng.s[i]; |
| 86 | wsdPrng.s[i] = t; |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 87 | } |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 88 | wsdPrng.isInit = 1; |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 89 | } |
| 90 | |
| 91 | /* Generate and return single random byte |
| 92 | */ |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 93 | wsdPrng.i++; |
| 94 | t = wsdPrng.s[wsdPrng.i]; |
| 95 | wsdPrng.j += t; |
| 96 | wsdPrng.s[wsdPrng.i] = wsdPrng.s[wsdPrng.j]; |
| 97 | wsdPrng.s[wsdPrng.j] = t; |
| 98 | t += wsdPrng.s[wsdPrng.i]; |
| 99 | return wsdPrng.s[t]; |
drh | ad75e98 | 2001-10-09 04:19:46 +0000 | [diff] [blame] | 100 | } |
| 101 | |
| 102 | /* |
drh | bbd82df | 2004-02-11 09:46:30 +0000 | [diff] [blame] | 103 | ** Return N random bytes. |
drh | ad75e98 | 2001-10-09 04:19:46 +0000 | [diff] [blame] | 104 | */ |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 105 | void sqlite3_randomness(int N, void *pBuf){ |
drh | bbd82df | 2004-02-11 09:46:30 +0000 | [diff] [blame] | 106 | unsigned char *zBuf = pBuf; |
drh | 18472fa | 2008-10-07 15:25:48 +0000 | [diff] [blame] | 107 | #if SQLITE_THREADSAFE |
danielk1977 | 59f8c08 | 2008-06-18 17:09:10 +0000 | [diff] [blame] | 108 | sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_PRNG); |
drh | 65bbf29 | 2008-06-19 01:03:17 +0000 | [diff] [blame] | 109 | #endif |
drh | 51fc347 | 2007-08-21 13:51:23 +0000 | [diff] [blame] | 110 | sqlite3_mutex_enter(mutex); |
drh | bbd82df | 2004-02-11 09:46:30 +0000 | [diff] [blame] | 111 | while( N-- ){ |
| 112 | *(zBuf++) = randomByte(); |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 113 | } |
drh | 51fc347 | 2007-08-21 13:51:23 +0000 | [diff] [blame] | 114 | sqlite3_mutex_leave(mutex); |
drh | ae85dc8 | 2001-01-13 14:34:05 +0000 | [diff] [blame] | 115 | } |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 116 | |
drh | 3088d59 | 2008-03-21 16:45:47 +0000 | [diff] [blame] | 117 | #ifndef SQLITE_OMIT_BUILTIN_TEST |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 118 | /* |
| 119 | ** For testing purposes, we sometimes want to preserve the state of |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 120 | ** PRNG and restore the PRNG to its saved state at a later time, or |
| 121 | ** to reset the PRNG to its initial state. These routines accomplish |
| 122 | ** those tasks. |
| 123 | ** |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 124 | ** The sqlite3_test_control() interface calls these routines to |
| 125 | ** control the PRNG. |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 126 | */ |
drh | 1875f7a | 2008-12-08 18:19:17 +0000 | [diff] [blame] | 127 | static SQLITE_WSD struct sqlite3PrngType sqlite3SavedPrng; |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 128 | void sqlite3PrngSaveState(void){ |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 129 | memcpy( |
| 130 | &GLOBAL(struct sqlite3PrngType, sqlite3SavedPrng), |
| 131 | &GLOBAL(struct sqlite3PrngType, sqlite3Prng), |
| 132 | sizeof(sqlite3Prng) |
| 133 | ); |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 134 | } |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 135 | void sqlite3PrngRestoreState(void){ |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 136 | memcpy( |
| 137 | &GLOBAL(struct sqlite3PrngType, sqlite3Prng), |
| 138 | &GLOBAL(struct sqlite3PrngType, sqlite3SavedPrng), |
| 139 | sizeof(sqlite3Prng) |
| 140 | ); |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 141 | } |
drh | 2fa1868 | 2008-03-19 14:15:34 +0000 | [diff] [blame] | 142 | void sqlite3PrngResetState(void){ |
drh | 78f82d1 | 2008-09-02 00:52:52 +0000 | [diff] [blame] | 143 | GLOBAL(struct sqlite3PrngType, sqlite3Prng).isInit = 0; |
drh | 93aed5a | 2008-01-16 17:46:38 +0000 | [diff] [blame] | 144 | } |
drh | 3088d59 | 2008-03-21 16:45:47 +0000 | [diff] [blame] | 145 | #endif /* SQLITE_OMIT_BUILTIN_TEST */ |