~ubuntu-branches/ubuntu/karmic/gears/karmic

sqlite3CreateView(pParse, &yymsp[-7].minor.yy0, &yymsp[-3].minor.yy0, &yymsp[-2].minor.yy0, yymsp[0].minor.yy219, yymsp[-6].minor.yy46, yymsp[-4].minor.yy46);

2341

}

2342

#line 2347 "parse.c"

2343

break;

2344

case 103: /* cmd ::= DROP VIEW ifexists fullname */

2345

#line 360 "parse.y"

2346

{

2347

sqlite3DropTable(pParse, yymsp[0].minor.yy373, 1, yymsp[-1].minor.yy46);

2348

}

2349

#line 2354 "parse.c"

2350

break;

2351

case 104: /* cmd ::= select */

2352

#line 367 "parse.y"

2353

{

2354

SelectDest dest = {SRT_Callback, 0, 0, 0, 0};

2355

sqlite3Select(pParse, yymsp[0].minor.yy219, &dest, 0, 0, 0);

2356

sqlite3SelectDelete(pParse->db, yymsp[0].minor.yy219);

2357

}

2358

#line 2363 "parse.c"

2359

break;

2360

case 105: /* select ::= oneselect */

2361

case 128: /* seltablist_paren ::= select */

2362

#line 378 "parse.y"

2363

{yygotominor.yy219 = yymsp[0].minor.yy219;}

2364

#line 2369 "parse.c"

2365

break;

2366

case 106: /* select ::= select multiselect_op oneselect */

2367

#line 380 "parse.y"

2368

{

2369

if( yymsp[0].minor.yy219 ){

2370

yymsp[0].minor.yy219->op = yymsp[-1].minor.yy46;

2371

yymsp[0].minor.yy219->pPrior = yymsp[-2].minor.yy219;

2372

}else{

2373

sqlite3SelectDelete(pParse->db, yymsp[-2].minor.yy219);

2374

}

2375

yygotominor.yy219 = yymsp[0].minor.yy219;

2376

}

2377

#line 2382 "parse.c"

2378

break;

2379

case 108: /* multiselect_op ::= UNION ALL */

2380

#line 391 "parse.y"

2381

{yygotominor.yy46 = TK_ALL;}

2382

#line 2387 "parse.c"

2383

break;

2384

case 110: /* oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt */

2385

#line 395 "parse.y"

2386

{

2387

yygotominor.yy219 = sqlite3SelectNew(pParse,yymsp[-6].minor.yy174,yymsp[-5].minor.yy373,yymsp[-4].minor.yy172,yymsp[-3].minor.yy174,yymsp[-2].minor.yy172,yymsp[-1].minor.yy174,yymsp[-7].minor.yy46,yymsp[0].minor.yy234.pLimit,yymsp[0].minor.yy234.pOffset);

2388

}

2389

#line 2394 "parse.c"

2390

break;

2391

case 114: /* sclp ::= selcollist COMMA */

2392

case 238: /* idxlist_opt ::= LP idxlist RP */

2393

#line 416 "parse.y"

2394

{yygotominor.yy174 = yymsp[-1].minor.yy174;}

2395

#line 2400 "parse.c"

2396

break;

2397

case 115: /* sclp ::= */

2398

case 141: /* orderby_opt ::= */

2399

case 149: /* groupby_opt ::= */

2400

case 231: /* exprlist ::= */

2401

case 237: /* idxlist_opt ::= */

2402

#line 417 "parse.y"

2403

{yygotominor.yy174 = 0;}

2404

#line 2409 "parse.c"

2405

break;

2406

case 116: /* selcollist ::= sclp expr as */

2407

#line 418 "parse.y"

2408

{

2409

yygotominor.yy174 = sqlite3ExprListAppend(pParse,yymsp[-2].minor.yy174,yymsp[-1].minor.yy172,yymsp[0].minor.yy0.n?&yymsp[0].minor.yy0:0);

2410

}

2411

#line 2416 "parse.c"

2412

break;

2413

case 117: /* selcollist ::= sclp STAR */

2414

#line 421 "parse.y"

2415

{

2416

Expr *p = sqlite3PExpr(pParse, TK_ALL, 0, 0, 0);

2417

yygotominor.yy174 = sqlite3ExprListAppend(pParse, yymsp[-1].minor.yy174, p, 0);

2418

}

2419

#line 2424 "parse.c"

2420

break;

2421

case 118: /* selcollist ::= sclp nm DOT STAR */

2422

#line 425 "parse.y"

2423

{

2424

Expr *pRight = sqlite3PExpr(pParse, TK_ALL, 0, 0, &yymsp[0].minor.yy0);

2425

Expr *pLeft = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[-2].minor.yy0);

2426

Expr *pDot = sqlite3PExpr(pParse, TK_DOT, pLeft, pRight, 0);

2427

yygotominor.yy174 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy174, pDot, 0);

2428

}

2429

#line 2434 "parse.c"

2430

break;

2431

case 121: /* as ::= */

2432

#line 438 "parse.y"

2433

{yygotominor.yy0.n = 0;}

2434

#line 2439 "parse.c"

2435

break;

2436

case 122: /* from ::= */

2437

#line 450 "parse.y"

2438

{yygotominor.yy373 = sqlite3DbMallocZero(pParse->db, sizeof(*yygotominor.yy373));}

2439

#line 2444 "parse.c"

2440

break;

2441

case 123: /* from ::= FROM seltablist */

2442

#line 451 "parse.y"

2443

{

2444

yygotominor.yy373 = yymsp[0].minor.yy373;

2445

sqlite3SrcListShiftJoinType(yygotominor.yy373);

2446

}

2447

#line 2452 "parse.c"

2448

break;

2449

case 124: /* stl_prefix ::= seltablist joinop */

2450

#line 459 "parse.y"

2451

{

2452

yygotominor.yy373 = yymsp[-1].minor.yy373;

2453

if( yygotominor.yy373 && yygotominor.yy373->nSrc>0 ) yygotominor.yy373->a[yygotominor.yy373->nSrc-1].jointype = yymsp[0].minor.yy46;

2454

}

2455

#line 2460 "parse.c"

2456

break;

2457

case 125: /* stl_prefix ::= */

2458

#line 463 "parse.y"

2459

{yygotominor.yy373 = 0;}

2460

#line 2465 "parse.c"

2461

break;

2462

case 126: /* seltablist ::= stl_prefix nm dbnm as on_opt using_opt */

2463

#line 464 "parse.y"

2464

{

2465

yygotominor.yy373 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-5].minor.yy373,&yymsp[-4].minor.yy0,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,0,yymsp[-1].minor.yy172,yymsp[0].minor.yy432);

2466

}

2467

#line 2472 "parse.c"

2468

break;

2469

case 127: /* seltablist ::= stl_prefix LP seltablist_paren RP as on_opt using_opt */

2470

#line 469 "parse.y"

2471

{

2472

yygotominor.yy373 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy373,0,0,&yymsp[-2].minor.yy0,yymsp[-4].minor.yy219,yymsp[-1].minor.yy172,yymsp[0].minor.yy432);

2473

}

2474

#line 2479 "parse.c"

2475

break;

2476

case 129: /* seltablist_paren ::= seltablist */

2477

#line 480 "parse.y"

2478

{

2479

sqlite3SrcListShiftJoinType(yymsp[0].minor.yy373);

2480

yygotominor.yy219 = sqlite3SelectNew(pParse,0,yymsp[0].minor.yy373,0,0,0,0,0,0,0);

2481

}

2482

#line 2487 "parse.c"

2483

break;

2484

case 130: /* dbnm ::= */

2485

#line 487 "parse.y"

2486

{yygotominor.yy0.z=0; yygotominor.yy0.n=0;}

2487

#line 2492 "parse.c"

2488

break;

2489

case 132: /* fullname ::= nm dbnm */

2490

#line 492 "parse.y"

2491

{yygotominor.yy373 = sqlite3SrcListAppend(pParse->db,0,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0);}

2492

#line 2497 "parse.c"

2493

break;

2494

case 133: /* joinop ::= COMMA|JOIN */

2495

#line 496 "parse.y"

2496

{ yygotominor.yy46 = JT_INNER; }

2497

#line 2502 "parse.c"

2498

break;

2499

case 134: /* joinop ::= JOIN_KW JOIN */

2500

#line 497 "parse.y"

2501

{ yygotominor.yy46 = sqlite3JoinType(pParse,&yymsp[-1].minor.yy0,0,0); }

2502

#line 2507 "parse.c"

2503

break;

2504

case 135: /* joinop ::= JOIN_KW nm JOIN */

2505

#line 498 "parse.y"

2506

{ yygotominor.yy46 = sqlite3JoinType(pParse,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0,0); }

2507

#line 2512 "parse.c"

2508

break;

2509

case 136: /* joinop ::= JOIN_KW nm nm JOIN */

2510

#line 500 "parse.y"

2511

{ yygotominor.yy46 = sqlite3JoinType(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0); }

2512

#line 2517 "parse.c"

2513

break;

2514

case 137: /* on_opt ::= ON expr */

2515

case 145: /* sortitem ::= expr */

2516

case 152: /* having_opt ::= HAVING expr */

2517

case 159: /* where_opt ::= WHERE expr */

2518

case 174: /* expr ::= term */

2519

case 202: /* escape ::= ESCAPE expr */

2520

case 226: /* case_else ::= ELSE expr */

2521

case 228: /* case_operand ::= expr */

2522

#line 504 "parse.y"

2523

{yygotominor.yy172 = yymsp[0].minor.yy172;}

2524

#line 2529 "parse.c"

2525

break;

2526

case 138: /* on_opt ::= */

2527

case 151: /* having_opt ::= */

2528

case 158: /* where_opt ::= */

2529

case 203: /* escape ::= */

2530

case 227: /* case_else ::= */

2531

case 229: /* case_operand ::= */

2532

#line 505 "parse.y"

2533

{yygotominor.yy172 = 0;}

2534

#line 2539 "parse.c"

2535

break;

2536

case 139: /* using_opt ::= USING LP inscollist RP */

2537

case 171: /* inscollist_opt ::= LP inscollist RP */

2538

#line 509 "parse.y"

2539

{yygotominor.yy432 = yymsp[-1].minor.yy432;}

2540

#line 2545 "parse.c"

2541

break;

2542

case 140: /* using_opt ::= */

2543

case 170: /* inscollist_opt ::= */

2544

#line 510 "parse.y"

2545

{yygotominor.yy432 = 0;}

2546

#line 2551 "parse.c"

2547

break;

2548

case 142: /* orderby_opt ::= ORDER BY sortlist */

2549

case 150: /* groupby_opt ::= GROUP BY nexprlist */

2550

case 230: /* exprlist ::= nexprlist */

2551

#line 521 "parse.y"

2552

{yygotominor.yy174 = yymsp[0].minor.yy174;}

2553

#line 2558 "parse.c"

2554

break;

2555

case 143: /* sortlist ::= sortlist COMMA sortitem sortorder */

2556

#line 522 "parse.y"

2557

{

2558

yygotominor.yy174 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy174,yymsp[-1].minor.yy172,0);

2559

if( yygotominor.yy174 ) yygotominor.yy174->a[yygotominor.yy174->nExpr-1].sortOrder = yymsp[0].minor.yy46;

2560

}

2561

#line 2566 "parse.c"

2562

break;

2563

case 144: /* sortlist ::= sortitem sortorder */

2564

#line 526 "parse.y"

2565

{

2566

yygotominor.yy174 = sqlite3ExprListAppend(pParse,0,yymsp[-1].minor.yy172,0);

2567

if( yygotominor.yy174 && yygotominor.yy174->a ) yygotominor.yy174->a[0].sortOrder = yymsp[0].minor.yy46;

2568

}

2569

#line 2574 "parse.c"

2570

break;

2571

case 146: /* sortorder ::= ASC */

2572

case 148: /* sortorder ::= */

2573

#line 534 "parse.y"

2574

{yygotominor.yy46 = SQLITE_SO_ASC;}

2575

#line 2580 "parse.c"

2576

break;

2577

case 147: /* sortorder ::= DESC */

2578

#line 535 "parse.y"

2579

{yygotominor.yy46 = SQLITE_SO_DESC;}

2580

#line 2585 "parse.c"

2581

break;

2582

case 153: /* limit_opt ::= */

2583

#line 561 "parse.y"

2584

{yygotominor.yy234.pLimit = 0; yygotominor.yy234.pOffset = 0;}

2585

#line 2590 "parse.c"

2586

break;

2587

case 154: /* limit_opt ::= LIMIT expr */

2588

#line 562 "parse.y"

2589

{yygotominor.yy234.pLimit = yymsp[0].minor.yy172; yygotominor.yy234.pOffset = 0;}

2590

#line 2595 "parse.c"

2591

break;

2592

case 155: /* limit_opt ::= LIMIT expr OFFSET expr */

2593

#line 564 "parse.y"

2594

{yygotominor.yy234.pLimit = yymsp[-2].minor.yy172; yygotominor.yy234.pOffset = yymsp[0].minor.yy172;}

2595

#line 2600 "parse.c"

2596

break;

2597

case 156: /* limit_opt ::= LIMIT expr COMMA expr */

2598

#line 566 "parse.y"

2599

{yygotominor.yy234.pOffset = yymsp[-2].minor.yy172; yygotominor.yy234.pLimit = yymsp[0].minor.yy172;}

2600

#line 2605 "parse.c"

2601

break;

2602

case 157: /* cmd ::= DELETE FROM fullname where_opt */

2603

#line 570 "parse.y"

2604

{sqlite3DeleteFrom(pParse,yymsp[-1].minor.yy373,yymsp[0].minor.yy172);}

2605

#line 2610 "parse.c"

2606

break;

2607

case 160: /* cmd ::= UPDATE orconf fullname SET setlist where_opt */

2608

#line 580 "parse.y"

2609

{

2610

sqlite3ExprListCheckLength(pParse,yymsp[-1].minor.yy174,"set list");

2611

sqlite3Update(pParse,yymsp[-3].minor.yy373,yymsp[-1].minor.yy174,yymsp[0].minor.yy172,yymsp[-4].minor.yy46);

2612

}

2613

#line 2618 "parse.c"

2614

break;

2615

case 161: /* setlist ::= setlist COMMA nm EQ expr */

2616

#line 589 "parse.y"

2617

{yygotominor.yy174 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy174,yymsp[0].minor.yy172,&yymsp[-2].minor.yy0);}

2618

#line 2623 "parse.c"

2619

break;

2620

case 162: /* setlist ::= nm EQ expr */

2621

#line 591 "parse.y"

2622

{yygotominor.yy174 = sqlite3ExprListAppend(pParse,0,yymsp[0].minor.yy172,&yymsp[-2].minor.yy0);}

2623

#line 2628 "parse.c"

2624

break;

2625

case 163: /* cmd ::= insert_cmd INTO fullname inscollist_opt VALUES LP itemlist RP */

2626

#line 597 "parse.y"

2627

{sqlite3Insert(pParse, yymsp[-5].minor.yy373, yymsp[-1].minor.yy174, 0, yymsp[-4].minor.yy432, yymsp[-7].minor.yy46);}

2628

#line 2633 "parse.c"

2629

break;

2630

case 164: /* cmd ::= insert_cmd INTO fullname inscollist_opt select */

2631

#line 599 "parse.y"

2632

{sqlite3Insert(pParse, yymsp[-2].minor.yy373, 0, yymsp[0].minor.yy219, yymsp[-1].minor.yy432, yymsp[-4].minor.yy46);}

2633

#line 2638 "parse.c"

2634

break;

2635

case 165: /* cmd ::= insert_cmd INTO fullname inscollist_opt DEFAULT VALUES */

2636

#line 601 "parse.y"

2637

{sqlite3Insert(pParse, yymsp[-3].minor.yy373, 0, 0, yymsp[-2].minor.yy432, yymsp[-5].minor.yy46);}

2638

#line 2643 "parse.c"

2639

break;

2640

case 168: /* itemlist ::= itemlist COMMA expr */

2641

case 232: /* nexprlist ::= nexprlist COMMA expr */

2642

#line 612 "parse.y"

2643

{yygotominor.yy174 = sqlite3ExprListAppend(pParse,yymsp[-2].minor.yy174,yymsp[0].minor.yy172,0);}

2644

#line 2649 "parse.c"

2645

break;

2646

case 169: /* itemlist ::= expr */

2647

case 233: /* nexprlist ::= expr */

2648

#line 614 "parse.y"

2649

{yygotominor.yy174 = sqlite3ExprListAppend(pParse,0,yymsp[0].minor.yy172,0);}

2650

#line 2655 "parse.c"

2651

break;

2652

case 172: /* inscollist ::= inscollist COMMA nm */

2653

#line 624 "parse.y"

2654

{yygotominor.yy432 = sqlite3IdListAppend(pParse->db,yymsp[-2].minor.yy432,&yymsp[0].minor.yy0);}

2655

#line 2660 "parse.c"

2656

break;

2657

case 173: /* inscollist ::= nm */

2658

#line 626 "parse.y"

2659

{yygotominor.yy432 = sqlite3IdListAppend(pParse->db,0,&yymsp[0].minor.yy0);}

2660

#line 2665 "parse.c"

2661

break;

2662

case 175: /* expr ::= LP expr RP */

2663

#line 637 "parse.y"

2664

{yygotominor.yy172 = yymsp[-1].minor.yy172; sqlite3ExprSpan(yygotominor.yy172,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0); }

2665

#line 2670 "parse.c"

2666

break;

2667

case 176: /* term ::= NULL */

2668

case 181: /* term ::= INTEGER|FLOAT|BLOB */

2669

case 182: /* term ::= STRING */

2670

#line 638 "parse.y"

2671

{yygotominor.yy172 = sqlite3PExpr(pParse, yymsp[0].major, 0, 0, &yymsp[0].minor.yy0);}

2672

#line 2677 "parse.c"

2673

break;

2674

case 177: /* expr ::= ID */

2675

case 178: /* expr ::= JOIN_KW */

2676

#line 639 "parse.y"

2677

{yygotominor.yy172 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[0].minor.yy0);}

2678

#line 2683 "parse.c"

2679

break;

2680

case 179: /* expr ::= nm DOT nm */

2681

#line 641 "parse.y"

2682

{

2683

Expr *temp1 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[-2].minor.yy0);

2684

Expr *temp2 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[0].minor.yy0);

2685

yygotominor.yy172 = sqlite3PExpr(pParse, TK_DOT, temp1, temp2, 0);

2686

}

2687

#line 2692 "parse.c"

2688

break;

2689

case 180: /* expr ::= nm DOT nm DOT nm */

2690

#line 646 "parse.y"

2691

{

2692

Expr *temp1 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[-4].minor.yy0);

2693

Expr *temp2 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[-2].minor.yy0);

2694

Expr *temp3 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[0].minor.yy0);

2695

Expr *temp4 = sqlite3PExpr(pParse, TK_DOT, temp2, temp3, 0);

2696

yygotominor.yy172 = sqlite3PExpr(pParse, TK_DOT, temp1, temp4, 0);

2697

}

2698

#line 2703 "parse.c"

2699

break;

2700

case 183: /* expr ::= REGISTER */

2701

#line 655 "parse.y"

2702

{yygotominor.yy172 = sqlite3RegisterExpr(pParse, &yymsp[0].minor.yy0);}

2703

#line 2708 "parse.c"

2704

break;

2705

case 184: /* expr ::= VARIABLE */

2706

#line 656 "parse.y"

2707

{

2708

Token *pToken = &yymsp[0].minor.yy0;

2709

Expr *pExpr = yygotominor.yy172 = sqlite3PExpr(pParse, TK_VARIABLE, 0, 0, pToken);

2710

sqlite3ExprAssignVarNumber(pParse, pExpr);

2711

}

2712

#line 2717 "parse.c"

2713

break;

2714

case 185: /* expr ::= expr COLLATE ids */

2715

#line 661 "parse.y"

2716

{

2717

yygotominor.yy172 = sqlite3ExprSetColl(pParse, yymsp[-2].minor.yy172, &yymsp[0].minor.yy0);

2718

}

2719

#line 2724 "parse.c"

2720

break;

2721

case 186: /* expr ::= CAST LP expr AS typetoken RP */

2722

#line 665 "parse.y"

2723

{

2724

yygotominor.yy172 = sqlite3PExpr(pParse, TK_CAST, yymsp[-3].minor.yy172, 0, &yymsp[-1].minor.yy0);

2725

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-5].minor.yy0,&yymsp[0].minor.yy0);

2726

}

2727

#line 2732 "parse.c"

2728

break;

2729

case 187: /* expr ::= ID LP distinct exprlist RP */

2730

#line 670 "parse.y"

2731

{

2732

if( yymsp[-1].minor.yy174 && yymsp[-1].minor.yy174->nExpr>SQLITE_MAX_FUNCTION_ARG ){

2733

sqlite3ErrorMsg(pParse, "too many arguments on function %T", &yymsp[-4].minor.yy0);

2734

}

2735

yygotominor.yy172 = sqlite3ExprFunction(pParse, yymsp[-1].minor.yy174, &yymsp[-4].minor.yy0);

2736

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-4].minor.yy0,&yymsp[0].minor.yy0);

2737

if( yymsp[-2].minor.yy46 && yygotominor.yy172 ){

2738

yygotominor.yy172->flags |= EP_Distinct;

2739

}

2740

}

2741

#line 2746 "parse.c"

2742

break;

2743

case 188: /* expr ::= ID LP STAR RP */

2744

#line 680 "parse.y"

2745

{

2746

yygotominor.yy172 = sqlite3ExprFunction(pParse, 0, &yymsp[-3].minor.yy0);

2747

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-3].minor.yy0,&yymsp[0].minor.yy0);

2748

}

2749

#line 2754 "parse.c"

2750

break;

2751

case 189: /* term ::= CTIME_KW */

2752

#line 684 "parse.y"

2753

{

2754

/* The CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP values are

2755

** treated as functions that return constants */

2756

yygotominor.yy172 = sqlite3ExprFunction(pParse, 0,&yymsp[0].minor.yy0);

2757

if( yygotominor.yy172 ){

2758

yygotominor.yy172->op = TK_CONST_FUNC;

2759

yygotominor.yy172->span = yymsp[0].minor.yy0;

2760

}

2761

}

2762

#line 2767 "parse.c"

2763

break;

2764

case 190: /* expr ::= expr AND expr */

2765

case 191: /* expr ::= expr OR expr */

2766

case 192: /* expr ::= expr LT|GT|GE|LE expr */

2767

case 193: /* expr ::= expr EQ|NE expr */

2768

case 194: /* expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr */

2769

case 195: /* expr ::= expr PLUS|MINUS expr */

2770

case 196: /* expr ::= expr STAR|SLASH|REM expr */

2771

case 197: /* expr ::= expr CONCAT expr */

2772

#line 693 "parse.y"

2773

{yygotominor.yy172 = sqlite3PExpr(pParse,yymsp[-1].major,yymsp[-2].minor.yy172,yymsp[0].minor.yy172,0);}

2774

#line 2779 "parse.c"

2775

break;

2776

case 198: /* likeop ::= LIKE_KW */

2777

case 200: /* likeop ::= MATCH */

2778

#line 705 "parse.y"

2779

{yygotominor.yy72.eOperator = yymsp[0].minor.yy0; yygotominor.yy72.not = 0;}

2780

#line 2785 "parse.c"

2781

break;

2782

case 199: /* likeop ::= NOT LIKE_KW */

2783

case 201: /* likeop ::= NOT MATCH */

2784

#line 706 "parse.y"

2785

{yygotominor.yy72.eOperator = yymsp[0].minor.yy0; yygotominor.yy72.not = 1;}

2786

#line 2791 "parse.c"

2787

break;

2788

case 204: /* expr ::= expr likeop expr escape */

2789

#line 713 "parse.y"

2790

{

2791

ExprList *pList;

2792

pList = sqlite3ExprListAppend(pParse,0, yymsp[-1].minor.yy172, 0);

2793

pList = sqlite3ExprListAppend(pParse,pList, yymsp[-3].minor.yy172, 0);

2794

if( yymsp[0].minor.yy172 ){

2795

pList = sqlite3ExprListAppend(pParse,pList, yymsp[0].minor.yy172, 0);

2796

}

2797

yygotominor.yy172 = sqlite3ExprFunction(pParse, pList, &yymsp[-2].minor.yy72.eOperator);

2798

if( yymsp[-2].minor.yy72.not ) yygotominor.yy172 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy172, 0, 0);

2799

sqlite3ExprSpan(yygotominor.yy172, &yymsp[-3].minor.yy172->span, &yymsp[-1].minor.yy172->span);

2800

if( yygotominor.yy172 ) yygotominor.yy172->flags |= EP_InfixFunc;

2801

}

2802

#line 2807 "parse.c"

2803

break;

2804

case 205: /* expr ::= expr ISNULL|NOTNULL */

2805

#line 726 "parse.y"

2806

{

2807

yygotominor.yy172 = sqlite3PExpr(pParse, yymsp[0].major, yymsp[-1].minor.yy172, 0, 0);

2808

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-1].minor.yy172->span,&yymsp[0].minor.yy0);

2809

}

2810

#line 2815 "parse.c"

2811

break;

2812

case 206: /* expr ::= expr IS NULL */

2813

#line 730 "parse.y"

2814

{

2815

yygotominor.yy172 = sqlite3PExpr(pParse, TK_ISNULL, yymsp[-2].minor.yy172, 0, 0);

2816

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-2].minor.yy172->span,&yymsp[0].minor.yy0);

2817

}

2818

#line 2823 "parse.c"

2819

break;

2820

case 207: /* expr ::= expr NOT NULL */

2821

#line 734 "parse.y"

2822

{

2823

yygotominor.yy172 = sqlite3PExpr(pParse, TK_NOTNULL, yymsp[-2].minor.yy172, 0, 0);

2824

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-2].minor.yy172->span,&yymsp[0].minor.yy0);

2825

}

2826

#line 2831 "parse.c"

2827

break;

2828

case 208: /* expr ::= expr IS NOT NULL */

2829

#line 738 "parse.y"

2830

{

2831

yygotominor.yy172 = sqlite3PExpr(pParse, TK_NOTNULL, yymsp[-3].minor.yy172, 0, 0);

2832

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-3].minor.yy172->span,&yymsp[0].minor.yy0);

2833

}

2834

#line 2839 "parse.c"

2835

break;

2836

case 209: /* expr ::= NOT expr */

2837

case 210: /* expr ::= BITNOT expr */

2838

#line 742 "parse.y"

2839

{

2840

yygotominor.yy172 = sqlite3PExpr(pParse, yymsp[-1].major, yymsp[0].minor.yy172, 0, 0);

2841

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy172->span);

2842

}

2843

#line 2848 "parse.c"

2844

break;

2845

case 211: /* expr ::= MINUS expr */

2846

#line 750 "parse.y"

2847

{

2848

yygotominor.yy172 = sqlite3PExpr(pParse, TK_UMINUS, yymsp[0].minor.yy172, 0, 0);

2849

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy172->span);

2850

}

2851

#line 2856 "parse.c"

2852

break;

2853

case 212: /* expr ::= PLUS expr */

2854

#line 754 "parse.y"

2855

{

2856

yygotominor.yy172 = sqlite3PExpr(pParse, TK_UPLUS, yymsp[0].minor.yy172, 0, 0);

2857

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy172->span);

2858

}

2859

#line 2864 "parse.c"

2860

break;

2861

case 215: /* expr ::= expr between_op expr AND expr */

2862

#line 761 "parse.y"

2863

{

2864

ExprList *pList = sqlite3ExprListAppend(pParse,0, yymsp[-2].minor.yy172, 0);

2865

pList = sqlite3ExprListAppend(pParse,pList, yymsp[0].minor.yy172, 0);

2866

yygotominor.yy172 = sqlite3PExpr(pParse, TK_BETWEEN, yymsp[-4].minor.yy172, 0, 0);

2867

if( yygotominor.yy172 ){

2868

yygotominor.yy172->pList = pList;

2869

}else{

2870

sqlite3ExprListDelete(pParse->db, pList);

2871

}

2872

if( yymsp[-3].minor.yy46 ) yygotominor.yy172 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy172, 0, 0);

2873

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-4].minor.yy172->span,&yymsp[0].minor.yy172->span);

2874

}

2875

#line 2880 "parse.c"

2876

break;

2877

case 218: /* expr ::= expr in_op LP exprlist RP */

2878

#line 777 "parse.y"

2879

{

2880

yygotominor.yy172 = sqlite3PExpr(pParse, TK_IN, yymsp[-4].minor.yy172, 0, 0);

2881

if( yygotominor.yy172 ){

2882

yygotominor.yy172->pList = yymsp[-1].minor.yy174;

2883

sqlite3ExprSetHeight(pParse, yygotominor.yy172);

2884

}else{

2885

sqlite3ExprListDelete(pParse->db, yymsp[-1].minor.yy174);

2886

}

2887

if( yymsp[-3].minor.yy46 ) yygotominor.yy172 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy172, 0, 0);

2888

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-4].minor.yy172->span,&yymsp[0].minor.yy0);

2889

}

2890

#line 2895 "parse.c"

2891

break;

2892

case 219: /* expr ::= LP select RP */

2893

#line 788 "parse.y"

2894

{

2895

yygotominor.yy172 = sqlite3PExpr(pParse, TK_SELECT, 0, 0, 0);

2896

if( yygotominor.yy172 ){

2897

yygotominor.yy172->pSelect = yymsp[-1].minor.yy219;

2898

sqlite3ExprSetHeight(pParse, yygotominor.yy172);

2899

}else{

2900

sqlite3SelectDelete(pParse->db, yymsp[-1].minor.yy219);

2901

}

2902

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0);

2903

}

2904

#line 2909 "parse.c"

2905

break;

2906

case 220: /* expr ::= expr in_op LP select RP */

2907

#line 798 "parse.y"

2908

{

2909

yygotominor.yy172 = sqlite3PExpr(pParse, TK_IN, yymsp[-4].minor.yy172, 0, 0);

2910

if( yygotominor.yy172 ){

2911

yygotominor.yy172->pSelect = yymsp[-1].minor.yy219;

2912

sqlite3ExprSetHeight(pParse, yygotominor.yy172);

2913

}else{

2914

sqlite3SelectDelete(pParse->db, yymsp[-1].minor.yy219);

2915

}

2916

if( yymsp[-3].minor.yy46 ) yygotominor.yy172 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy172, 0, 0);

2917

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-4].minor.yy172->span,&yymsp[0].minor.yy0);

2918

}

2919

#line 2924 "parse.c"

2920

break;

2921

case 221: /* expr ::= expr in_op nm dbnm */

2922

#line 809 "parse.y"

2923

{

2924

SrcList *pSrc = sqlite3SrcListAppend(pParse->db, 0,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0);

2925

yygotominor.yy172 = sqlite3PExpr(pParse, TK_IN, yymsp[-3].minor.yy172, 0, 0);

2926

if( yygotominor.yy172 ){

2927

yygotominor.yy172->pSelect = sqlite3SelectNew(pParse, 0,pSrc,0,0,0,0,0,0,0);

2928

sqlite3ExprSetHeight(pParse, yygotominor.yy172);

2929

}else{

2930

sqlite3SrcListDelete(pParse->db, pSrc);

2931

}

2932

if( yymsp[-2].minor.yy46 ) yygotominor.yy172 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy172, 0, 0);

2933

sqlite3ExprSpan(yygotominor.yy172,&yymsp[-3].minor.yy172->span,yymsp[0].minor.yy0.z?&yymsp[0].minor.yy0:&yymsp[-1].minor.yy0);

2934

}

2935

#line 2940 "parse.c"

2936

break;

2937

case 222: /* expr ::= EXISTS LP select RP */

2938

#line 821 "parse.y"

2939

{

2940

Expr *p = yygotominor.yy172 = sqlite3PExpr(pParse, TK_EXISTS, 0, 0, 0);

2941

if( p ){

2942

p->pSelect = yymsp[-1].minor.yy219;

2943

sqlite3ExprSpan(p,&yymsp[-3].minor.yy0,&yymsp[0].minor.yy0);

2944

sqlite3ExprSetHeight(pParse, yygotominor.yy172);

2945

}else{

2946

sqlite3SelectDelete(pParse->db, yymsp[-1].minor.yy219);

2947

}

2948

}

2949

#line 2954 "parse.c"

2950

break;

2951

case 223: /* expr ::= CASE case_operand case_exprlist case_else END */

2952

#line 834 "parse.y"

2953

{

2954

yygotominor.yy172 = sqlite3PExpr(pParse, TK_CASE, yymsp[-3].minor.yy172, yymsp[-1].minor.yy172, 0);

2955

if( yygotominor.yy172 ){

2956

yygotominor.yy172->pList = yymsp[-2].minor.yy174;

2957

sqlite3ExprSetHeight(pParse, yygotominor.yy172);

2958

}else{

2959

sqlite3ExprListDelete(pParse->db, yymsp[-2].minor.yy174);

2960

}

2961

sqlite3ExprSpan(yygotominor.yy172, &yymsp[-4].minor.yy0, &yymsp[0].minor.yy0);

2962

}

2963

#line 2968 "parse.c"

2964

break;

2965

case 224: /* case_exprlist ::= case_exprlist WHEN expr THEN expr */

2966

#line 846 "parse.y"

2967

{

2968

yygotominor.yy174 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy174, yymsp[-2].minor.yy172, 0);

2969

yygotominor.yy174 = sqlite3ExprListAppend(pParse,yygotominor.yy174, yymsp[0].minor.yy172, 0);

2970

}

2971

#line 2976 "parse.c"

2972

break;

2973

case 225: /* case_exprlist ::= WHEN expr THEN expr */

2974

#line 850 "parse.y"

2975

{

2976

yygotominor.yy174 = sqlite3ExprListAppend(pParse,0, yymsp[-2].minor.yy172, 0);

2977

yygotominor.yy174 = sqlite3ExprListAppend(pParse,yygotominor.yy174, yymsp[0].minor.yy172, 0);

2978

}

2979

#line 2984 "parse.c"

2980

break;

2981

case 234: /* cmd ::= CREATE uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP */

2982

#line 879 "parse.y"

2983

{

2984

sqlite3CreateIndex(pParse, &yymsp[-6].minor.yy0, &yymsp[-5].minor.yy0,

2985

sqlite3SrcListAppend(pParse->db,0,&yymsp[-3].minor.yy0,0), yymsp[-1].minor.yy174, yymsp[-9].minor.yy46,

2986

&yymsp[-10].minor.yy0, &yymsp[0].minor.yy0, SQLITE_SO_ASC, yymsp[-7].minor.yy46);

2987

}

2988

#line 2993 "parse.c"

2989

break;

2990

case 235: /* uniqueflag ::= UNIQUE */

2991

case 283: /* raisetype ::= ABORT */

2992

#line 886 "parse.y"

2993

{yygotominor.yy46 = OE_Abort;}

2994

#line 2999 "parse.c"

2995

break;

2996

case 236: /* uniqueflag ::= */

2997

#line 887 "parse.y"

2998

{yygotominor.yy46 = OE_None;}

2999

#line 3004 "parse.c"

3000

break;

3001

case 239: /* idxlist ::= idxlist COMMA idxitem collate sortorder */

3002

#line 897 "parse.y"

3003

{

3004

Expr *p = 0;

3005

if( yymsp[-1].minor.yy0.n>0 ){

3006

p = sqlite3PExpr(pParse, TK_COLUMN, 0, 0, 0);

3007

sqlite3ExprSetColl(pParse, p, &yymsp[-1].minor.yy0);

3008

}

3009

yygotominor.yy174 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy174, p, &yymsp[-2].minor.yy0);

3010

sqlite3ExprListCheckLength(pParse, yygotominor.yy174, "index");

3011

if( yygotominor.yy174 ) yygotominor.yy174->a[yygotominor.yy174->nExpr-1].sortOrder = yymsp[0].minor.yy46;

3012

}

3013

#line 3018 "parse.c"

3014

break;

3015

case 240: /* idxlist ::= idxitem collate sortorder */

3016

#line 907 "parse.y"

3017

{

3018

Expr *p = 0;

3019

if( yymsp[-1].minor.yy0.n>0 ){

3020

p = sqlite3PExpr(pParse, TK_COLUMN, 0, 0, 0);

3021

sqlite3ExprSetColl(pParse, p, &yymsp[-1].minor.yy0);

3022

}

3023

yygotominor.yy174 = sqlite3ExprListAppend(pParse,0, p, &yymsp[-2].minor.yy0);

3024

sqlite3ExprListCheckLength(pParse, yygotominor.yy174, "index");

3025

if( yygotominor.yy174 ) yygotominor.yy174->a[yygotominor.yy174->nExpr-1].sortOrder = yymsp[0].minor.yy46;

3026

}

3027

#line 3032 "parse.c"

3028

break;

3029

case 242: /* collate ::= */

3030

#line 920 "parse.y"

3031

{yygotominor.yy0.z = 0; yygotominor.yy0.n = 0;}

3032

#line 3037 "parse.c"

3033

break;

3034

case 244: /* cmd ::= DROP INDEX ifexists fullname */

3035

#line 926 "parse.y"

3036

{sqlite3DropIndex(pParse, yymsp[0].minor.yy373, yymsp[-1].minor.yy46);}

3037

#line 3042 "parse.c"

3038

break;

3039

case 245: /* cmd ::= VACUUM */

3040

case 246: /* cmd ::= VACUUM nm */

3041

#line 932 "parse.y"

3042

{sqlite3Vacuum(pParse);}

3043

#line 3048 "parse.c"

3044

break;

3045

case 247: /* cmd ::= PRAGMA nm dbnm EQ nmnum */

3046

case 248: /* cmd ::= PRAGMA nm dbnm EQ ON */

3047

case 249: /* cmd ::= PRAGMA nm dbnm EQ DELETE */

3048

#line 941 "parse.y"

3049

{sqlite3Pragma(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0,0);}

3050

#line 3055 "parse.c"

3051

break;

3052

case 250: /* cmd ::= PRAGMA nm dbnm EQ minus_num */

3053

#line 944 "parse.y"

3054

{

3055

sqlite3Pragma(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0,1);

3056

}

3057

#line 3062 "parse.c"

3058

break;

3059

case 251: /* cmd ::= PRAGMA nm dbnm LP nmnum RP */

3060

#line 947 "parse.y"

3061

{sqlite3Pragma(pParse,&yymsp[-4].minor.yy0,&yymsp[-3].minor.yy0,&yymsp[-1].minor.yy0,0);}

3062

#line 3067 "parse.c"

3063

break;

3064

case 252: /* cmd ::= PRAGMA nm dbnm */

3065

#line 948 "parse.y"

3066

{sqlite3Pragma(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0,0,0);}

3067

#line 3072 "parse.c"

3068

break;

3069

case 260: /* cmd ::= CREATE trigger_decl BEGIN trigger_cmd_list END */

3070

#line 963 "parse.y"

3071

{

3072

Token all;

3073

all.z = yymsp[-3].minor.yy0.z;

3074

all.n = (yymsp[0].minor.yy0.z - yymsp[-3].minor.yy0.z) + yymsp[0].minor.yy0.n;

3075

sqlite3FinishTrigger(pParse, yymsp[-1].minor.yy243, &all);

3076

}

3077

#line 3082 "parse.c"

3078

break;

3079

case 261: /* trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause */

3080

#line 972 "parse.y"

3081

{

3082

sqlite3BeginTrigger(pParse, &yymsp[-7].minor.yy0, &yymsp[-6].minor.yy0, yymsp[-5].minor.yy46, yymsp[-4].minor.yy370.a, yymsp[-4].minor.yy370.b, yymsp[-2].minor.yy373, yymsp[0].minor.yy172, yymsp[-10].minor.yy46, yymsp[-8].minor.yy46);

3083

yygotominor.yy0 = (yymsp[-6].minor.yy0.n==0?yymsp[-7].minor.yy0:yymsp[-6].minor.yy0);

3084

}

3085

#line 3090 "parse.c"

3086

break;

3087

case 262: /* trigger_time ::= BEFORE */

3088

case 265: /* trigger_time ::= */

3089

#line 978 "parse.y"

3090

{ yygotominor.yy46 = TK_BEFORE; }

3091

#line 3096 "parse.c"

3092

break;

3093

case 263: /* trigger_time ::= AFTER */

3094

#line 979 "parse.y"

3095

{ yygotominor.yy46 = TK_AFTER; }

3096

#line 3101 "parse.c"

3097

break;

3098

case 264: /* trigger_time ::= INSTEAD OF */

3099

#line 980 "parse.y"

3100

{ yygotominor.yy46 = TK_INSTEAD;}

3101

#line 3106 "parse.c"

3102

break;

3103

case 266: /* trigger_event ::= DELETE|INSERT */

3104

case 267: /* trigger_event ::= UPDATE */

3105

#line 985 "parse.y"

3106

{yygotominor.yy370.a = yymsp[0].major; yygotominor.yy370.b = 0;}

3107

#line 3112 "parse.c"

3108

break;

3109

case 268: /* trigger_event ::= UPDATE OF inscollist */

3110

#line 987 "parse.y"

3111

{yygotominor.yy370.a = TK_UPDATE; yygotominor.yy370.b = yymsp[0].minor.yy432;}

3112

#line 3117 "parse.c"

3113

break;

3114

case 271: /* when_clause ::= */

3115

case 288: /* key_opt ::= */

3116

#line 994 "parse.y"

3117

{ yygotominor.yy172 = 0; }

3118

#line 3123 "parse.c"

3119

break;

3120

case 272: /* when_clause ::= WHEN expr */

3121

case 289: /* key_opt ::= KEY expr */

3122

#line 995 "parse.y"

3123

{ yygotominor.yy172 = yymsp[0].minor.yy172; }

3124

#line 3129 "parse.c"

3125

break;

3126

case 273: /* trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI */

3127

#line 999 "parse.y"

3128

{

3129

if( yymsp[-2].minor.yy243 ){

3130

yymsp[-2].minor.yy243->pLast->pNext = yymsp[-1].minor.yy243;

3131

}else{

3132

yymsp[-2].minor.yy243 = yymsp[-1].minor.yy243;

3133

}

3134

yymsp[-2].minor.yy243->pLast = yymsp[-1].minor.yy243;

3135

yygotominor.yy243 = yymsp[-2].minor.yy243;

3136

}

3137

#line 3142 "parse.c"

3138

break;

3139

case 274: /* trigger_cmd_list ::= */

3140

#line 1008 "parse.y"

3141

{ yygotominor.yy243 = 0; }

3142

#line 3147 "parse.c"

3143

break;

3144

case 275: /* trigger_cmd ::= UPDATE orconf nm SET setlist where_opt */

3145

#line 1014 "parse.y"

3146

{ yygotominor.yy243 = sqlite3TriggerUpdateStep(pParse->db, &yymsp[-3].minor.yy0, yymsp[-1].minor.yy174, yymsp[0].minor.yy172, yymsp[-4].minor.yy46); }

3147

#line 3152 "parse.c"

3148

break;

3149

case 276: /* trigger_cmd ::= insert_cmd INTO nm inscollist_opt VALUES LP itemlist RP */

3150

#line 1019 "parse.y"

3151

{yygotominor.yy243 = sqlite3TriggerInsertStep(pParse->db, &yymsp[-5].minor.yy0, yymsp[-4].minor.yy432, yymsp[-1].minor.yy174, 0, yymsp[-7].minor.yy46);}

3152

#line 3157 "parse.c"

3153

break;

3154

case 277: /* trigger_cmd ::= insert_cmd INTO nm inscollist_opt select */

3155

#line 1022 "parse.y"

3156

{yygotominor.yy243 = sqlite3TriggerInsertStep(pParse->db, &yymsp[-2].minor.yy0, yymsp[-1].minor.yy432, 0, yymsp[0].minor.yy219, yymsp[-4].minor.yy46);}

3157

#line 3162 "parse.c"

3158

break;

3159

case 278: /* trigger_cmd ::= DELETE FROM nm where_opt */

3160

#line 1026 "parse.y"

3161

{yygotominor.yy243 = sqlite3TriggerDeleteStep(pParse->db, &yymsp[-1].minor.yy0, yymsp[0].minor.yy172);}

3162

#line 3167 "parse.c"

3163

break;

3164

case 279: /* trigger_cmd ::= select */

3165

#line 1029 "parse.y"

3166

{yygotominor.yy243 = sqlite3TriggerSelectStep(pParse->db, yymsp[0].minor.yy219); }

3167

#line 3172 "parse.c"

3168

break;

3169

case 280: /* expr ::= RAISE LP IGNORE RP */

3170

#line 1032 "parse.y"

3171

{

3172

yygotominor.yy172 = sqlite3PExpr(pParse, TK_RAISE, 0, 0, 0);

3173

if( yygotominor.yy172 ){

3174

yygotominor.yy172->iColumn = OE_Ignore;

3175

sqlite3ExprSpan(yygotominor.yy172, &yymsp[-3].minor.yy0, &yymsp[0].minor.yy0);

3176

}

3177

}

3178

#line 3183 "parse.c"

3179

break;

3180

case 281: /* expr ::= RAISE LP raisetype COMMA nm RP */

3181

#line 1039 "parse.y"

3182

{

3183

yygotominor.yy172 = sqlite3PExpr(pParse, TK_RAISE, 0, 0, &yymsp[-1].minor.yy0);

3184

if( yygotominor.yy172 ) {

3185

yygotominor.yy172->iColumn = yymsp[-3].minor.yy46;

3186

sqlite3ExprSpan(yygotominor.yy172, &yymsp[-5].minor.yy0, &yymsp[0].minor.yy0);

3187

}

3188

}

3189

#line 3194 "parse.c"

3190

break;

3191

case 282: /* raisetype ::= ROLLBACK */

3192

#line 1049 "parse.y"

3193

{yygotominor.yy46 = OE_Rollback;}

3194

#line 3199 "parse.c"

3195

break;

3196

case 284: /* raisetype ::= FAIL */

3197

#line 1051 "parse.y"

3198

{yygotominor.yy46 = OE_Fail;}

3199

#line 3204 "parse.c"

3200

break;

3201

case 285: /* cmd ::= DROP TRIGGER ifexists fullname */

3202

#line 1056 "parse.y"

3203

{

3204

sqlite3DropTrigger(pParse,yymsp[0].minor.yy373,yymsp[-1].minor.yy46);

3205

}

3206

#line 3211 "parse.c"

3207

break;

3208

case 286: /* cmd ::= ATTACH database_kw_opt expr AS expr key_opt */

3209

#line 1063 "parse.y"

3210

{

3211

sqlite3Attach(pParse, yymsp[-3].minor.yy172, yymsp[-1].minor.yy172, yymsp[0].minor.yy172);

3212

}

3213

#line 3218 "parse.c"

3214

break;

3215

case 287: /* cmd ::= DETACH database_kw_opt expr */

3216

#line 1066 "parse.y"

3217

{

3218

sqlite3Detach(pParse, yymsp[0].minor.yy172);

3219

}

3220

#line 3225 "parse.c"

3221

break;

3222

case 292: /* cmd ::= REINDEX */

3223

#line 1081 "parse.y"

3224

{sqlite3Reindex(pParse, 0, 0);}

3225

#line 3230 "parse.c"

3226

break;

3227

case 293: /* cmd ::= REINDEX nm dbnm */

3228

#line 1082 "parse.y"

3229

{sqlite3Reindex(pParse, &yymsp[-1].minor.yy0, &yymsp[0].minor.yy0);}

3230

#line 3235 "parse.c"

3231

break;

3232

case 294: /* cmd ::= ANALYZE */

3233

#line 1087 "parse.y"

3234

{sqlite3Analyze(pParse, 0, 0);}

3235

#line 3240 "parse.c"

3236

break;

3237

case 295: /* cmd ::= ANALYZE nm dbnm */

3238

#line 1088 "parse.y"

3239

{sqlite3Analyze(pParse, &yymsp[-1].minor.yy0, &yymsp[0].minor.yy0);}

3240

#line 3245 "parse.c"

3241

break;

3242

case 296: /* cmd ::= ALTER TABLE fullname RENAME TO nm */

3243

#line 1093 "parse.y"

3244

{

3245

sqlite3AlterRenameTable(pParse,yymsp[-3].minor.yy373,&yymsp[0].minor.yy0);

3246

}

3247

#line 3252 "parse.c"

3248

break;

3249

case 297: /* cmd ::= ALTER TABLE add_column_fullname ADD kwcolumn_opt column */

3250

#line 1096 "parse.y"

3251

{

3252

sqlite3AlterFinishAddColumn(pParse, &yymsp[0].minor.yy0);

3253

}

3254

#line 3259 "parse.c"

3255

break;

3256

case 298: /* add_column_fullname ::= fullname */

3257

#line 1099 "parse.y"

3258

{

3259

sqlite3AlterBeginAddColumn(pParse, yymsp[0].minor.yy373);

3260

}

3261

#line 3266 "parse.c"

3262

break;

3263

case 301: /* cmd ::= create_vtab */

3264

#line 1108 "parse.y"

3265

{sqlite3VtabFinishParse(pParse,0);}

3266

#line 3271 "parse.c"

3267

break;

3268

case 302: /* cmd ::= create_vtab LP vtabarglist RP */

3269

#line 1109 "parse.y"

3270

{sqlite3VtabFinishParse(pParse,&yymsp[0].minor.yy0);}

3271

#line 3276 "parse.c"

3272

break;

3273

case 303: /* create_vtab ::= CREATE VIRTUAL TABLE nm dbnm USING nm */

3274

#line 1110 "parse.y"

3275

{

3276

sqlite3VtabBeginParse(pParse, &yymsp[-3].minor.yy0, &yymsp[-2].minor.yy0, &yymsp[0].minor.yy0);

3277

}

3278

#line 3283 "parse.c"

3279

break;

3280

case 306: /* vtabarg ::= */

3281

#line 1115 "parse.y"

3282

{sqlite3VtabArgInit(pParse);}

3283

#line 3288 "parse.c"

3284

break;

3285

case 308: /* vtabargtoken ::= ANY */

3286

case 309: /* vtabargtoken ::= lp anylist RP */

3287

case 310: /* lp ::= LP */

3288

case 312: /* anylist ::= anylist ANY */

3289

#line 1117 "parse.y"

3290

{sqlite3VtabArgExtend(pParse,&yymsp[0].minor.yy0);}

3291

#line 3296 "parse.c"

3292

break;

3293

};

3294

yygoto = yyRuleInfo[yyruleno].lhs;

3295

yysize = yyRuleInfo[yyruleno].nrhs;

3296

yypParser->yyidx -= yysize;

3297

yyact = yy_find_reduce_action(yymsp[-yysize].stateno,yygoto);

3298

if( yyact < YYNSTATE ){

3299

#ifdef NDEBUG

3300

/* If we are not debugging and the reduce action popped at least

3301

** one element off the stack, then we can push the new element back

3302

** onto the stack here, and skip the stack overflow test in yy_shift().

3303

** That gives a significant speed improvement. */

3304

if( yysize ){

3305

yypParser->yyidx++;

3306

yymsp -= yysize-1;

3307

yymsp->stateno = yyact;

3308

yymsp->major = yygoto;

3309

yymsp->minor = yygotominor;

3310

}else

3311

#endif

3312

{

3313

yy_shift(yypParser,yyact,yygoto,&yygotominor);

3314

}

3315

}else{

3316

assert( yyact == YYNSTATE + YYNRULE + 1 );

3317

yy_accept(yypParser);

3318

}

3319

}

3320

3321

3322

** The following code executes when the parse fails

3323

3324

static void yy_parse_failed(

3325

yyParser *yypParser /* The parser */

3326

){

3327

sqlite3ParserARG_FETCH;

3328

#ifndef NDEBUG

3329

if( yyTraceFILE ){

3330

fprintf(yyTraceFILE,"%sFail!\n",yyTracePrompt);

3331

}

3332

#endif

3333

while( yypParser->yyidx>=0 ) yy_pop_parser_stack(yypParser);

3334

/* Here code is inserted which will be executed whenever the

3335

** parser fails */

3336

sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument variable */

3337

}

3338

3339

3340

** The following code executes when a syntax error first occurs.

3341

3342

static void yy_syntax_error(

3343

yyParser *yypParser, /* The parser */

3344

int yymajor, /* The major type of the error token */

3345

YYMINORTYPE yyminor /* The minor type of the error token */

3346

){

3347

sqlite3ParserARG_FETCH;

3348

#define TOKEN (yyminor.yy0)

3349

#line 34 "parse.y"

3350

3351

assert( TOKEN.z[0] ); /* The tokenizer always gives us a token */

3352

sqlite3ErrorMsg(pParse, "near \"%T\": syntax error", &TOKEN);

3353

pParse->parseError = 1;

3354

#line 3361 "parse.c"

3355

sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument variable */

3356

}

3357

3358

3359

** The following is executed when the parser accepts

3360

3361

static void yy_accept(

3362

yyParser *yypParser /* The parser */

3363

){

3364

sqlite3ParserARG_FETCH;

3365

#ifndef NDEBUG

3366

if( yyTraceFILE ){

3367

fprintf(yyTraceFILE,"%sAccept!\n",yyTracePrompt);

3368

}

3369

#endif

3370

while( yypParser->yyidx>=0 ) yy_pop_parser_stack(yypParser);

3371

/* Here code is inserted which will be executed whenever the

3372

** parser accepts */

3373

sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument variable */

3374

}

3375

3376

/* The main parser program.

3377

** The first argument is a pointer to a structure obtained from

3378

** "sqlite3ParserAlloc" which describes the current state of the parser.

3379

** The second argument is the major token number. The third is

3380

** the minor token. The fourth optional argument is whatever the

3381

** user wants (and specified in the grammar) and is available for

3382

** use by the action routines.

3383

3384

** Inputs:

3385

** <ul>

3386

** <li> A pointer to the parser (an opaque structure.)

3387

** <li> The major token number.

3388

** <li> The minor token number.

3389

** <li> An option argument of a grammar-specified type.

3390

** </ul>

3391

3392

** Outputs:

3393

** None.

3394

3395

void sqlite3Parser(

3396

void *yyp, /* The parser */

3397

int yymajor, /* The major token code number */

3398

sqlite3ParserTOKENTYPE yyminor /* The value for the token */

3399

sqlite3ParserARG_PDECL /* Optional %extra_argument parameter */

3400

){

3401

YYMINORTYPE yyminorunion;

3402

int yyact; /* The parser action. */

3403

int yyendofinput; /* True if we are at the end of input */

3404

#ifdef YYERRORSYMBOL

3405

int yyerrorhit = 0; /* True if yymajor has invoked an error */

3406

#endif

3407

yyParser *yypParser; /* The parser */

3408

3409

/* (re)initialize the parser, if necessary */

3410

yypParser = (yyParser*)yyp;

3411

if( yypParser->yyidx<0 ){

3412

#if YYSTACKDEPTH<=0

3413

if( yypParser->yystksz <=0 ){

3414

/*memset(&yyminorunion, 0, sizeof(yyminorunion));*/

3415

yyminorunion = yyzerominor;

3416

yyStackOverflow(yypParser, &yyminorunion);

3417

return;

3418

}

3419

#endif

3420

yypParser->yyidx = 0;

3421

yypParser->yyerrcnt = -1;

3422

yypParser->yystack[0].stateno = 0;

3423

yypParser->yystack[0].major = 0;

3424

}

3425

yyminorunion.yy0 = yyminor;

3426

yyendofinput = (yymajor==0);

3427

sqlite3ParserARG_STORE;

3428

3429

#ifndef NDEBUG

3430

if( yyTraceFILE ){

3431

fprintf(yyTraceFILE,"%sInput %s\n",yyTracePrompt,yyTokenName[yymajor]);

3432

}

3433

#endif

3434

3435

do{

3436

yyact = yy_find_shift_action(yypParser,yymajor);

3437

if( yyact<YYNSTATE ){

3438

assert( !yyendofinput ); /* Impossible to shift the $ token */

3439

yy_shift(yypParser,yyact,yymajor,&yyminorunion);

3440

yypParser->yyerrcnt--;

3441

yymajor = YYNOCODE;

3442

}else if( yyact < YYNSTATE + YYNRULE ){

3443

yy_reduce(yypParser,yyact-YYNSTATE);

3444

}else{

3445

assert( yyact == YY_ERROR_ACTION );

3446

#ifdef YYERRORSYMBOL

3447

int yymx;

3448

#endif

3449

#ifndef NDEBUG

3450

if( yyTraceFILE ){

3451

fprintf(yyTraceFILE,"%sSyntax Error!\n",yyTracePrompt);

3452

}

3453

#endif

3454

#ifdef YYERRORSYMBOL

3455

/* A syntax error has occurred.

3456

** The response to an error depends upon whether or not the

3457

** grammar defines an error token "ERROR".

3458

3459

** This is what we do if the grammar does define ERROR:

3460

3461

** * Call the %syntax_error function.

3462

3463

** * Begin popping the stack until we enter a state where

3464

** it is legal to shift the error symbol, then shift

3465

** the error symbol.

3466

3467

** * Set the error count to three.

3468

3469

** * Begin accepting and shifting new tokens. No new error

3470

** processing will occur until three tokens have been

3471

** shifted successfully.

3472

3473

3474

if( yypParser->yyerrcnt<0 ){

3475

yy_syntax_error(yypParser,yymajor,yyminorunion);

3476

}

3477

yymx = yypParser->yystack[yypParser->yyidx].major;

3478

if( yymx==YYERRORSYMBOL || yyerrorhit ){

3479

#ifndef NDEBUG

3480

if( yyTraceFILE ){

3481

fprintf(yyTraceFILE,"%sDiscard input token %s\n",

3482

yyTracePrompt,yyTokenName[yymajor]);

3483

}

3484

#endif

3485

yy_destructor(yypParser, yymajor,&yyminorunion);

3486

yymajor = YYNOCODE;

3487

}else{

3488

while(

3489

yypParser->yyidx >= 0 &&

3490

yymx != YYERRORSYMBOL &&

3491

(yyact = yy_find_reduce_action(

3492

yypParser->yystack[yypParser->yyidx].stateno,

3493

YYERRORSYMBOL)) >= YYNSTATE

3494

){

3495

yy_pop_parser_stack(yypParser);

3496

}

3497

if( yypParser->yyidx < 0 || yymajor==0 ){

3498

yy_destructor(yypParser,yymajor,&yyminorunion);

3499

yy_parse_failed(yypParser);

3500

yymajor = YYNOCODE;

3501

}else if( yymx!=YYERRORSYMBOL ){

3502

YYMINORTYPE u2;

3503

u2.YYERRSYMDT = 0;

3504

yy_shift(yypParser,yyact,YYERRORSYMBOL,&u2);

3505

}

3506

}

3507

yypParser->yyerrcnt = 3;

3508

yyerrorhit = 1;

3509

#else /* YYERRORSYMBOL is not defined */

3510

/* This is what we do if the grammar does not define ERROR:

3511

3512

** * Report an error message, and throw away the input token.

3513

3514

** * If the input token is $, then fail the parse.

3515

3516

** As before, subsequent error messages are suppressed until

3517

** three input tokens have been successfully shifted.

3518

3519

if( yypParser->yyerrcnt<=0 ){

3520

yy_syntax_error(yypParser,yymajor,yyminorunion);

3521

}

3522

yypParser->yyerrcnt = 3;

3523

yy_destructor(yypParser,yymajor,&yyminorunion);

3524

if( yyendofinput ){

3525

yy_parse_failed(yypParser);

3526

}

3527

yymajor = YYNOCODE;

3528

#endif

3529

}

3530

}while( yymajor!=YYNOCODE && yypParser->yyidx>=0 );

3531

return;

3532

}

Older »