inbetween.sql

derby database source code.good for you.

,2096,2095,2098,2097,2099,2100,2106,2107,2108,2111,2112,2113,2114
,2116,2117,2118,2119,2121,2123,2124,2125,2126,2127,2128,2129,2130
,2134,2138,2139,2144,2145,2147,2148,2150,2151,2152,2153,2156,2157
,2158,2160,2161,2162,2163,2164,2165,2166,2167,2170,2171,2172,2173
,2174,2175,2176,2178,2180,2181,2186,5408,2188,2189,2190,2191,2192
,2195,2198,2199,2201,2203,2206,2207,2209,2211,2212,5236,2213,2215
,2216,2217,2218,2219,5253,2224,2225,2226,2227,2229,2231,2232,2233
,2235,2236,2237,2238,2240,2241,2242,2243,2245,2246,2247,2248,2249
,2251,2257,2259,2260,2261,2262,2263,2264,2265,2266,2267,2270,2272
,2273,2274,2275,2276,2277,2281,2282,2284,2285,2288,2289,2290,2291
,2293,2294,2295,2296,2298,2299,2300,2301,2304,2306,2308,2310,2309
,2312,2313,2316,2317,2322,2324,2320,2318,2330,2331,2332,2334,5711
,2335,2337,2338,2339,2344,2345,2347,2348,2349,5740,2350,2354,2356
,2357,2358,2359,2361,2362,2365,2367,2368,2370,2372,2374,2378,2379
,2380,2381,2382,2385,2388,2389,2391,2392,2393,2395,2396,2398,2400
,2402,2401,2403,2404,2406,2408,2409,2411,2413,2417,2419,2421,2422
,2424,2425,2426,2427,2428,2430,2432,2433,2434,2435,2436,2440,2439
,2441,2443,2445,2446,2450,2448,2449,2451,2453,2456,2457,2458,5751
,2460,2462,2463,2465,5731,2468,2469,2471,2472,2474,2479,2480,2481
,2482,2484,2485,2486,2487,2488,2489,2491,2492,2494,2495,2496,2497
,2499,2500,2501,2503,2505,2506,2507,2508,2511,2513,2515,2514,2516
,2522,2525,2523,2526,2527,2528,2529,2532,2531,2533,2534,2535,2537
,2539,2541,2543,2544,2546,2548,2550,2551,5629,2553,2555,2556,2557
,2558,2559,2560,2563,2565,2569,2571,2574,2575,5718,5434,2577,2578
,5760,2580,2584,2585,2587,2589,2590,2591,2592,2593,2594,2596,2598
,2600,2602,2603,2605,2606,2607,2608,2610,2612,2613,2615,2616,2618
,2619,2623,2621,2624,2625,2630,2633,2634,2636,2638,2640,2643,2644
,2649,2651,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2665
,2666,2667,2670,2671,2673,2674,2676,2680,2682,2683,2684,2687,2685
,2690,2688,2694,2692,2695,2696,5448,2698,2699,2700,2701,2703,2704
,2705,2706,2708,2709,2711,2714,2716,2717,2718,2719,2720,2722,2724
,2725,2726,2728,2729,2733,2736,2734,2737,2738,2739,2743,2744,2745
,2746,2747,2748,2754,2751,2753,2755,2757,2758,2761,2763,2766,2768
,2769,2771,2773,2775,2774,2776,2778,2780,2781,2782,2784,2785,2786
,2787,2788,2789,2790,2791,2795,2798,2801,2802,2803,2804,2807,2808
,2809,2810,2812,2814,2815,2816,2819,2820,2822,2824,5649,2828,5465
,2832,2833,5817,5809,5814,5815,2835,2838,2839,2845,2846,2847,2850
,2851,2852,2854,2855,2857,2842,2858,2859,2861,2863,2864,2865,2866
,2872,2873,2874,2875,2878,2881,2882,2883,2884,2885,2886,2887,2888
,2891,2893,2894,2895,2896,2898,2897,2899,2900,2901,2903,2905,2906
,2907,2908,2910,2914,2916,2917,2920,2918,2921,2925,2927,2928,2929
,2932,2934,2936,2937,2938,2940,2939,2942,2943,2944,2945,2947,2950
,2952,2953,2955,2957,2958,2959,2961,2962,2963,2964,2966,2967,2968
,2972,2974,2976,2977,2978,2979,2980,2981,2982,2983,2984,2986,2987
,2988,2989,2990,2991,2992,2993,2994,2996,2997,2998,2999,3000,3001
,3003,3007,3008,3009,3011,3013,3014,3015,3016,3017,3019,3021,5768
,3023,3026,3027,3028,3029,3032,3033,3035,3039,3040,3041,3042,3043
,3044,3045,3046,3048,3050,3051,3055,3056,3057,3060,3061,3062,3064
,3069,3068,3070,3071,3072,3074,3076,3079,3080,3082,3083,3086,3099
,3088,3089,3090,3091,3092,3093,3094,3095,3096,5183,3097,3101,3103
,3104,3107,3109,3111,3112,3114,3116,3120,3122,3123,3126,3127,3128
,3129,3131,3132,3134,3135,3137,3139,5758,5724,3140,3144,3145,3147
,3148,3149,3150,3152,3153,3154,3155,3158,3161,3162,3163,3164,3165
,3166,3167,5776,3168,3170,3180,3181,3182,3186,3191,3192,3196,3198
,3199,3200,3203,3205,3206,3207,3208,3210,3211,3212,3213,3215,3216
,3217,3218,3219,3220,3221,3224,3226,3228,3230,3231,3232,3233,3235
,3236,3237,3239,3241,3242,3243,5687,3245,3246,3248,3249,3253,3254
,3259,3260,3261,3262,3264,3266,3267,3269,5811,3271,3273,3275,3277
,5620,3278,3279,3280,3282,3284,3286,3287,3289,3293,3294,3295,3297
,3299,3302,3301,3305,3307,3306,3308,3310,3311,3312,3313,3315,3316
,5497,3318,3322,3324,3326,3328,3336,3337,3338,3339,3341,5589,3344
,5742,3345,3346,3348,3350,3352,3354,3355,3356,3357,3361,3363,3364
,3365,3367,3368,3369,3371,3370,3372,3375,3373,3377,3378,3379,3381
,5638,3382,3384,3386,3387,3389,3390,3391,3392,3397,3398,3400,3401
,3402,3404,3405,3406,3407,3408,3409,3410,3411,3414,3415,3416,3417
,3418,3420,3421,3423,3424,3426,3428,3430,3431,3432,3433,3435,3436
,3437,5391,3440,3441,3442,3443,3444,3446,3448,3450,3452,3451,3453
,3455,3456,3457,3460,3461,3463,3464,3467,3466,3468,3471,3472,3474
,3475,3477,3479,3481,3482,3484,3485,3486,3487,3488,3489,3491,3493
,3494,3496,3497,3498,3500,3502,3504,3499,3505,3507,3514,3515,3517
,3519,3520,3522,3524,3525,5256,3526,3527,3528,3529,3531,5636,3532
,3533,3535,3536,3538,3539,3541,3544,3548,3550,3551,3552,3554,3556
,3557,3559,3560,3563,3564,3565,3567,3568,3571,3572,3573,3574,3577
,3583,3582,3580,3584,3586,3589,3587,3590,3591,3592,3593,3596,3597
,3599,3602,3603,3604,3605,3606,3608,3609,5398,3612,3614,3615,3616
,3617,3618,3619,3620,3621,3623,3624,3628,3630,3631,3633,3635,3636
,3637,3638,3640,3641,3643,3645,3644,3648,3650,3649,3651,3655,3662
,3664,3665,3667,3668,3672,3673,3676,3679,3681,3682,3683,3685,3688
,3689,3690,3692,3695,3696,3697,3699,3700,3701,3704,5349,3707,3708
,3710,3713,3715,3716,3717,3718,3720,3721,3724,3726,3727,3728,3729
,3731,3732,3733,3735,3736,3741,3745,3747,3749,3751,3752,3754,3756
,3758,3761,3762,3767,3769,3773,3775,5680,5181,3779,3783,3784,3788
,5567,3792,3794,3797,3800,3801,3804,3805,3806,3807,3808,3809,3810
,3811,3812,3813,3814,3819,3818,3820,3821,3822,3824,3825,3826,3827
,3829,3830,3832,5242,3834,3835,3836,3838,3843,3802,3849,3850,3855
,3857,5657,3858,3859,3862,5645,3863,3864,3865,5669,3866,3867,3868
,3869,3872,5720,3873,3874,3877,3879,3880,3881,3882,3884,3885,3886
,3887,3888,3889,3890,3892,3893,3898,3899,3900,3903,3904,3905,3908
,3909,3910,3911,3916,3917,3918,3921,3924,3926,3930,3931,3933,3934
,3936,3938,3939,3940,3941,3945,3949,3950,3954,3955,3957,3958,3960
,3961,3964,3966,3968,3973,3979,3980,3981,3982,3983,3985,3986,3987
,3989,3991,3990,3994,3992,3993,3995,3997,3998,3999,4000,4001,4002
,4003,4004,4005,4006,4007,4008,4009,4011,4012,4013,4015,4016,4020
,4022,4023,5536,4026,4027,4028,4030,4031,4034,5770,4035,4037,4040
,4041,4043,4044,4045,4046,4047,4048,4051,4052,4053,4055,4059,4061
,4062,4063,4064,4067,4070,4073,4074,4075,4076,4077,4079,4081,4083
,4084,4085,4086,4093,5240,4090,4092,4094,4095,4097,4098,4100,4102
,4103,4104,4105,4106,4107,4108,4109,4110,4112,4114,4115,4118,5631
,4120,4124,4132,4135,4142,4144,4145,4147,4148,4149,4150,4156,4159
,4160,4162,4163,4165,4166,4168,4167,4169,4171,4172,4174,4175,4179
,4181,4182,4186,4190,4188,4194,4196,4198,5738,4200,4202,4203,4205
,4206,4208,4211,4212,4213,4215,4217,4220,4223,4225,4229,4230,4231
,4235,4236,4237,4238,4239,5826,4241,4242,4243,4244,4246,5343,4250
,4251,4252,4253,4254,4255,4256,4257,4258,4262,5685,4264,4268,4269
,4270,4271,4272,4273,4274,5659,4279,4281,4283,4284,4285,4287,4291
,4292,4296,4298,4299,4300,4301,4302,4303,4304,4305,4308,4310,5348
,4311,4312,4313,4315,5438,4317,4319,4321,4322,4324,4326,4327,4328
,4329,4330,4331,4334,4336,4337,4341,4342,4343,4344,5326,4346,4352
,4354,4356,4359,4362,4364,4366,4367,4371,4373,4375,4379,4381,4384
,4386,4392,4390,5218,4397,4404,4406,4409,4410,4412,4411,4413,4414
,4416,4418,4420,4424,4426,4427,4430,4431,4432,4433,4437,4438,4439
,4440,4441,4442,4444,4445,4448,4446,5748,4451,4453,4454,4455,4458
,5774,4461,4462,4464,4465,4466,4467,4468,4469,4470,4472,4474,4475
,4476,4479,4480,4482,4483,4485,4487,4490,4492,4493,4494,4500,4501
,4503,4504,4506,4507,4508,4509,4510,4511,4512,4513,4516,4519,4520
,4521,4522,4524,4525,4527,4528,4533,4535,4536,4537,4538,4539,4540
,4541,4542,4544,4547,4548,4550,4552,4553,4555,4556,4557,4559,4561
,4562,4564,4565,4566,4567,4568,4569,5417,4570,4572,4575,4582,4576
,4578,4581,4583,4584,4585,4586,4587,4588,4589,4593,4594,4596,4603
,4604,4605,4610,4612,4614,5387,4619,4622,4624,4626,4627,4628,4629
,4630,4632,4634,4636,4637,4640,4645,4646,4648,4650,4651,4652,4653
,4654,4657,4659,4662,4660,4664,4665,4667,4668,4669,4672,4674,4677
,4679,4681,4682,4683,4684,4686,4688,4689,4690,4692,4693,4694,4695
,4698,4699,4700,4705,4701,4703,4708,4709,4711,4713,4714,4717,4727
,4728,4732,4734,4736,4737,4739,4741,4744,4747,4748,4750,4751,4754
,4755,4756,4758,4759,4761,4762,4764,4765,4767,4769,4749,4770,4771
,4773,4774,4775,4776,4777,4778,4784,4785,4786,4787,4788,4791,4793
,4794,5389,4798,4800,4801,4803,4805,4808,4806,4809,4810,4811,4814
,4815,4816,4822,4826,4827,4829,4831,4824,4832,4835,4836,4838,4839
,4840,4842,4844,4846,4848,4849,4850,4853,4854,4858,4860,4861,4862
,4863,4864,4867,4868,4871,4873,4874,4875,4877,4878,4879,4884,4886
,4888,4889,4890,4891,4892,4893,4894,4895,4896,4897,4899,4902,4903
,4904,4908,4905,4906,4907,4910,4911,4912,4913,4915,4914,4916,4917
,4918,4919,4920,4921,4923,4926,4927,4928,4929,4930,4931,4932,4933
,4937,4942,4944,4945,4946,4948,4950,4951,4954,4956,4958,4960,4961
,4963,4964,4965,4967,4970,4969,4971,4972,4974,4977,4975,4979,4981
,5729,4982,4983,4984,4986,4989,4991,4992,4994,4995,4996,4997,4998
,4999,5001,5003,5005,5006,5655,3969,5007,5622,5009,5013,5015,5021
,5022,5024,5025,5026,5028,5029,5031,5033,5036,5037,5038,5040,5041
,5042,5043,5047,5048,5050,5051,5053,5054,5056,5058,5059,5061,5063
,5064,5065,5066,5068,5069,5070,5072,5073,5076,5080,5081,5082,5083
,5084,5085,5087,5086,5088,5090,5092,5094,5095,5097,5099,5101,5102
,5104,5105,5106,5107,5108,5110,5112,5114,5115,5116,5117,5118,5119
,5120,5121,5123,5124,5125,5126,5127,5128,5130,5131,5132,5134,5136
,5137,5138,5139,5140,5141,5143,5777,5812,5148,5154,5155,5157,5159
,6022,6024,6025,6026,6028,6029,6031,6033,6036,6037,6038,6040,6041
,6042,6043,6047,6048,6050,6051,6053,6054,6056,6058,6059,6061,6063
,6064,6065,6066,6068,6069,6070,6072,6073,6076,6080,6081,6082,6083
,6084,6085,6087,6086,6088,6090,6092,6094,6095,6097,6099,6101,6102
,6104,6105,6106,6107,6108,6110,6112,6114,6115,6116,6117,6118,6119
,6120,6121,6123,6124,6125,6126,6127,6128,6130,6131,6132,6134,6136
,6137,6138,6139,6140,6141,6143,6777,6812,6148,6154,6155,6157,6159
,7022,7024,7025,7026,7028,7029,7031,7033,7036,7037,7038,7040,7041
,7042,7043,7047,7048,7050,7051,7053,7054,7056,7058,7059,7061,7063
,7064,7065,7066,7068,7069,7070,7072,7073,7076,7080,7081,7082,7083
,7084,7085,7087,7086,7088,7090,7092,7094,7095,7097,7099,7101,7102
,7104,7105,7106,7107,7108,7110,7112,7114,7115,7116,7117,7118,7119
,7120,7121,7123,7124,7125,7126,7127,7128,7130,7131,7132,7134,7136
,7137,7138,7139,7140,7141,7143,7777,7812,7148,7154,7155,7157,7159
,8022,8024,8025,8026,8028,8029,8031,8033,8036,8037,8038,8040,8041
,8042,8043,8047,8048,8050,8051,8053,8054,8056,8058,8059,8061,8063
,8064,8065,8066,8068,8069,8070,8072,8073,8076,8080,8081,8082,8083
,8084,8085,8087,8086,8088,8090,8092,8094,8095,8097,8099,8101,8102
,8104,8105,8106,8107,8108,8110,8112,8114,8115,8116,8117,8118,8119
,8120,8121,8123,8124,8125,8126,8127,8128,8130,8131,8132,8134,8136
,8137,8138,8139,8140,8141,8143,8777,8812,8148,8154,8155,8157,8159
,9022,9024,9025,9026,9028,9029,9031,9033,9036,9037,9038,9040,9041
,9042,9043,9047,9048,9050,9051,9053,9054,9056,9058,9059,9061,9063
,9064,9065,9066,9068,9069,9070,9072,9073,9076,9080,9081,9082,9083
,9084,9085,9087,9086,9088,9090,9092,9094,9095,9097,9099,9101,9102
,9104,9105,9106,9107,9108,9110,9112,9114,9115,9116,9117,9118,9119
,9120,9121,9123,9124,9125,9126,9127,9128,9130,9131,9132,9134,9136
,9137,9138,9139,9140,9141,9143,9777,9812,9148,9154,9155,9157,9159
,10022,10024,10025,10026,10028,10029,10031,10033,10036,10037,10038,10040,10041
,10042,10043,10047,10048,10050,10051,10053,10054,10056,10058,10059,10061,10063
,10064,10065,10066,10068,10069,10070,10072,10073,10076,10080,10081,10082,10083
,10084,10085,10087,10086,10088,10090,10092,10094,10095,10097,10099,10101,10102
,10104,10105,10106,10107,10108,10110,10112,10114,10115,10116,10117,10118,10119
,10120,10121,10123,10124,10125,10126,10127,10128,10130,10131,10132,10134,10136
,10137,10138,10139,10140,10141,10143,10777,10812,10148,10154,10155,10157,10159
,11022,11024,11025,11026,11028,11029,11031,11033,11036,11037,11038,11040,11041
,11042,11043,11047,11048,11050,11051,11053,11054,11056,11058,11059,11061,11063
,11064,11065,11066,11068,11069,11070,11072,11073,11076,11080,11081,11082,11083
,11084,11085,11087,11086,11088,11090,11092,11094,11095,11097,11099,11101,11102
,11104,11105,11106,11107,11108,11110,11112,11114,11115,11116,11117,11118,11119
,11120,11121,11123,11124,11125,11126,11127,11128,11130,11131,11132,11134,11136
,11137,11138,11139,11140,11141,11143,11777,11812,11148,11154,11155,11157,11159
,12022,12024,12025,12026,12028,12029,12031,12033,12036,12037,12038,12040,12041
,12042,12043,12047,12048,12050,12051,12053,12054,12056,12058,12059,12061,12063
,12064,12065,12066,12068,12069,12070,12072,12073,12076,12080,12081,12082,12083
,12084,12085,12087,12086,12088,12090,12092,12094,12095,12097,12099,12101,12102
,12104,12105,12106,12107,12108,12110,12112,12114,12115,12116,12117,12118,12119
,12120,12121,12123,12124,12125,12126,12127,12128,12130,12131,12132,12134,12136
,12137,12138,12139,12140,12141,12143,12777,12812,12148,12154,12155,12157,12159
,13022,13024,13025,13026,13028,13029,13031,13033,13036,13037,13038,13040,13041
,13042,13043,13047,13048,13050,13051,13053,13054,13056,13058,13059,13061,13063
,13064,13065,13066,13068,13069,13070,13072,13073,13076,13080,13081,13082,13083
,13084,13085,13087,13086,13088,13090,13092,13094,13095,13097,13099,13101,13102
,13104,13105,13106,13107,13108,13110,13112,13114,13115,13116,13117,13118,13119
,13120,13121,13123,13124,13125,13126,13127,13128,13130,13131,13132,13134,13136
,13137,13138,13139,13140,13141,13143,13777,13812,13148,13154,13155,13157,13159
,14022,14024,14025,14026,14028,14029,14031,14033,14036,14037,14038,14040,14041
,14042,14043,14047,14048,14050,14051,14053,14054,14056,14058,14059,14061,14063
,14064,14065,14066,14068,14069,14070,14072,14073,14076,14080,14081,14082,14083
,14084,14085,14087,14086,14088,14090,14092,14094,14095,14097,14099,14101,14102
,14104,14105,14106,14107,14108,14110,14112,14114,14115,14116,14117,14118,14119
,14120,14121,14123,14124,14125,14126,14127,14128,14130,14131,14132,14134,14136
,14137,14138,14139,14140,14141,14143,14777,14812,14148,14154,14155,14157,14159
,15022,15024,15025,15026,15028,15029,15031,15033,15036,15037,15038,15040,15041
,15042,15043,15047,15048,15050,15051,15053,15054,15056,15058,15059,15061,15063
,15064,15065,15066,15068,15069,15070,15072,15073,15076,15080,15081,15082,15083
,15084,15085,15087,15086,15088,15090,15092,15094,15095,15097,15099,15101,15102
,15104,15105,15106,15107,15108,15110,15112,15114,15115,15116,15117,15118,15119
,15120,15121,15123,15124,15125,15126,15127,15128,15130,15131,15132,15134,15136
,15137,15138,15139,15140,15141,15143,15777,15812,15148,15154,15155,15157,15159
,4436,5162,5165,5170,5171,5173,5345,5174,5765,5177,5750,5793,0) ORDER BY id;

drop table t1;

create table t1(c1 int );
create table t2(c2 int);
insert into t2 values(0);
create view v1(c1)
as
select c1 from t1
union all
select c2 from t2 ;
--following statement fails with NPE before fix of 5469
select c1 from v1 where c1 NOT IN (1, 2);
drop view v1;
drop table t1;
drop table t2;