Tom Deblauwe wrote:
D. Richard Hipp wrote:
What happens when you try to insert the 129th value?
I tried now the following:
add entries with NULL => ok until 128
when I first add index 100, and then add values with NULL as index, it
stops inserts until 128, then I get the message again about primary key
must be unique. If I do a MAX(iID) then I get the value 127, but when I
do a select * then I get this:
128 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
When I start at index 129 and then add with NULL, it goes ok, until 384.
Maybe it has something to do with padding or something?
Regards,
Tom,
