Lines Matching refs:shared
12 # $Id: shared.test,v 1.36 2009/03/16 13:19:36 danielk1977 Exp $
34 do_test shared-[expr $av+1].1.0 {
68 # shared-1.*: Simple test to verify basic sanity of table level locking when
70 # shared-2.*: Test that a read transaction can co-exist with a
73 # shared-3.*: Simple test of read-uncommitted mode.
74 # shared-4.*: Check that the schema is locked and unlocked correctly.
75 # shared-5.*: Test that creating/dropping schema items works when databases
77 # shared-6.*: Locking, UNION ALL queries and sub-queries.
78 # shared-7.*: Autovacuum and shared-cache.
79 # shared-8.*: Tests related to the text encoding of shared-cache databases.
80 # shared-9.*: TEMP triggers and shared-cache databases.
81 # shared-10.*: Tests of sqlite3_close().
82 # shared-11.*: Test transaction locking.
85 do_test shared-$av.1.1 {
93 do_test shared-$av.1.2 {
104 do_test shared-$av.1.3 {
116 do_test shared-$av.1.4 {
124 do_test shared-$av.1.5 {
132 do_test shared-$av.1.6 {
143 do_test shared-$av.1.7 {
155 do_test shared-$av.1.8 {
162 do_test shared-$av.2.1 {
172 do_test shared-$av.2.2 {
173 # Start read transactions on db and db2 (the shared pager cache). Ensure
187 do_test shared-$av.2.3 {
211 do_test shared-$av.2.4 {
227 do_test shared-$av.3.1.1 {
252 do_test shared-$av.3.1.2 {
264 do_test shared-$av.3.1.3 {
275 # Tests shared-4.* test that the schema locking rules are applied
299 do_test shared-$av.4.1.1 {
303 do_test shared-$av.4.1.2 {
308 do_test shared-$av.4.1.3 {
318 do_test shared-$av.4.2.1 {
326 do_test shared-$av.4.2.2 {
336 do_test shared-$av.4.3.1 {
342 do_test shared-$av.4.3.2 {
347 do_test shared-$av.4.3.3 {
352 do_test shared-$av.4.3.3 {
357 do_test shared-$av.4.3.4 {
372 do_test shared-$av.4.4.1.2 {
382 do_test shared-$av.4.4.1.2 {
393 do_test shared-$av.4.4.2 {
403 do_test shared-$av.4.4.3 {
406 do_test shared-$av.4.4.4 {
412 do_test shared-$av.4.4.5 {
424 # Tests shared-5.*
429 do_test shared-$av.5.1.1 {
443 do_test shared-$av.5.1.2 {
450 do_test shared-$av.5.1.3 {
457 do_test shared-$av.5.1.4 {
465 do_test shared-$av.5.1.5 {
471 do_test shared-$av.5.1.6 {
478 do_test shared-$av.5.1.7 {
484 do_test shared-$av.5.1.8 {
490 do_test shared-$av.5.1.9 {
498 # Tests shared-6.* test that a query obtains all the read-locks it needs
503 do_test shared-$av.6.1.1 {
512 do_test shared-$av.6.1.2 {
518 do_test shared-$av.6.1.3 {
538 do_test shared-$av.6.1.4 {
562 # Tests shared-7.* test auto-vacuum does not invalidate cursors from
563 # other shared-cache users when it reorganizes the database on
566 do_test shared-$av.7.1 {
592 do_test shared-$av.7.2 {
641 # The following tests try to trick the shared-cache code into assuming
646 do_test shared-$av.8.1.1 {
653 do_test shared-$av.8.1.2 {
657 do_test shared-$av.8.1.3 {
664 do_test shared-$av.8.1.4 {
669 do_test shared-$av.8.1.5 {
677 do_test shared-$av.8.2.1 {
683 do_test shared-$av.8.2.2 {
696 do_test shared-$av.8.3.2 {
701 do_test shared-$av.8.3.3 {
711 do_test shared-$av.8.3.4 {
723 do_test shared-$av.8.2.3 {
736 # The following tests - shared-9.* - test interactions between TEMP triggers
737 # and shared-schemas.
741 do_test shared-$av.9.1 {
754 do_test shared-$av.9.2 {
760 do_test shared-$av.9.3 {
765 } ; # End shared-9.*
768 # The following tests - shared-10.* - test that the library behaves
769 # correctly when a connection to a shared-cache is closed.
771 do_test shared-$av.10.1 {
785 do_test shared-$av.10.2 {
797 do_test shared-$av.10.3 {
813 do_test shared-$av.10.4 {
817 do_test shared-$av.10.5 {
824 do_test shared-$av.10.5 {
825 # Closing db2 should have dropped the shared-cache back to a read-lock.
829 do_test shared-$av.10.6 {
833 do_test shared-$av.10.7 {
843 do_test shared-$av.10.9 {
847 integrity_check shared-$av.10.10
848 do_test shared-$av.10.11 {
853 do_test shared-$av.11.1 {
864 do_test shared-$av.11.2 {
868 do_test shared-$av.11.3 {
871 do_test shared-$av.11.4 {
874 do_test shared-$av.11.5 {
877 do_test shared-$av.11.6 {
880 do_test shared-$av.11.6 {
886 do_test shared-$av.11.7 {
892 do_test shared-$av.11.8 {
906 do_test shared-$av.11.9 {
912 do_test shared-$av.11.11 {
922 do_test shared-$av.12.1 {
929 do_test shared-$av.12.2 {
946 do_test shared-$av.12.3 {
952 do_test shared-$av.12.X {
959 # Internally, locks are acquired on shared B-Tree structures in the order
965 do_test shared-$av.13.1 {
981 do_test shared-$av.13.2 {
995 do_test shared-$av.13.3 {
999 # Test that nothing horrible happens if a connection to a shared B-Tree
1002 do_test shared-$av.14.1 {
1007 do_test shared-$av.14.2 {
1017 do_test shared-$av.14.3 {
1022 # [db2]. This is to try to find any points where shared-schema elements
1028 do_test shared-$av-15.1 {
1053 do_test shared-$av-15.2 {
1061 do_test shared-$av-16.1 {
1071 do_test shared-$av-16.2 {
1084 do_test shared-$av-16.3 {
1099 do_test shared-$av-16.4 {
1112 do_test shared-$av-16.5 {
1121 do_test shared-$av-16.6 {
1127 do_test shared-$av-16.7 {
1140 do_test shared-$av-16.8 {
1147 do_test shared-$av-16.8.1 {
1162 ATTACH 'file:mem?mode=memory&cache=shared' AS shared;
1163 CREATE TABLE shared.xx(a, b);
1167 ATTACH 'file:mem?mode=memory&cache=shared' AS shared;
1172 do_test shared-$av-16.8.2 { db1 eval { SELECT * FROM yy } } {77 88}
1173 do_test shared-$av-16.8.3 {