Package org.voltdb.compiler

Examples of org.voltdb.compiler.VoltProjectBuilder.addStmtProcedure()

473
474
475
476
477
478
479
480
481
482
483
        project.addStmtProcedure("TM1_LT",       "SELECT COUNT(*) FROM TM1 WHERE POINTS < ?");
        project.addStmtProcedure("TM1_LET",       "SELECT COUNT(*) FROM TM1 WHERE POINTS <= ?");
        project.addStmtProcedure("TM1_GT",       "SELECT COUNT(*) FROM TM1 WHERE POINTS > ?");
        project.addStmtProcedure("TM1_GET",       "SELECT COUNT(*) FROM TM1 WHERE POINTS >= ?");

        project.addStmtProcedure("TM2_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS < ?");
        project.addStmtProcedure("TM2_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GT_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GT_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GET_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GET_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS <= ?");
View Full Code Here
474
475
476
477
478
479
480
481
482
483
484
        project.addStmtProcedure("TM1_LET",       "SELECT COUNT(*) FROM TM1 WHERE POINTS <= ?");
        project.addStmtProcedure("TM1_GT",       "SELECT COUNT(*) FROM TM1 WHERE POINTS > ?");
        project.addStmtProcedure("TM1_GET",       "SELECT COUNT(*) FROM TM1 WHERE POINTS >= ?");

        project.addStmtProcedure("TM2_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS < ?");
        project.addStmtProcedure("TM2_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GT_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GT_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GET_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GET_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS <= ?");
        boolean success;
View Full Code Here
475
476
477
478
479
480
481
482
483
484
485
        project.addStmtProcedure("TM1_GT",       "SELECT COUNT(*) FROM TM1 WHERE POINTS > ?");
        project.addStmtProcedure("TM1_GET",       "SELECT COUNT(*) FROM TM1 WHERE POINTS >= ?");

        project.addStmtProcedure("TM2_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS < ?");
        project.addStmtProcedure("TM2_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GT_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GT_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GET_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GET_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS <= ?");
        boolean success;

View Full Code Here
476
477
478
479
480
481
482
483
484
485
486
        project.addStmtProcedure("TM1_GET",       "SELECT COUNT(*) FROM TM1 WHERE POINTS >= ?");

        project.addStmtProcedure("TM2_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS < ?");
        project.addStmtProcedure("TM2_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GT_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GT_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GET_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GET_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS <= ?");
        boolean success;

        /////////////////////////////////////////////////////////////
View Full Code Here
477
478
479
480
481
482
483
484
485
486
487
        project.addStmtProcedure("TM2_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS < ?");
        project.addStmtProcedure("TM2_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GT_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GT_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GET_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GET_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS <= ?");
        boolean success;

        /////////////////////////////////////////////////////////////
        // CONFIG #1: 1 Local Site/Partitions running on JNI backend
View Full Code Here
478
479
480
481
482
483
484
485
486
487
488
        project.addStmtProcedure("TM2_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS < ?");
        project.addStmtProcedure("TM2_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GT_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GT_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS > ? AND POINTS <= ?");
        project.addStmtProcedure("TM2_GET_LT",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS < ?");
        project.addStmtProcedure("TM2_GET_LET",       "SELECT COUNT(*) FROM TM2 WHERE UNAME = ? AND POINTS >= ? AND POINTS <= ?");
        boolean success;

        /////////////////////////////////////////////////////////////
        // CONFIG #1: 1 Local Site/Partitions running on JNI backend
        /////////////////////////////////////////////////////////////
View Full Code Here
1699
1700
1701
1702
1703
1704
1705
1706
1707
1708
1709
        } catch (IOException e) {
            assertFalse(true);
        }

        // Test DECODE
        project.addStmtProcedure("DECODE", "select desc,  DECODE (desc,'IBM','zheng'," +
                        "'Microsoft','li'," +
                        "'Hewlett Packard','at'," +
                        "'Gateway','VoltDB'," +
                        "'where') from P1 where id = ?");
        project.addStmtProcedure("DECODEND", "select desc,  DECODE (desc,'zheng','a') from P1 where id = ?");
View Full Code Here
1704
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
        project.addStmtProcedure("DECODE", "select desc,  DECODE (desc,'IBM','zheng'," +
                        "'Microsoft','li'," +
                        "'Hewlett Packard','at'," +
                        "'Gateway','VoltDB'," +
                        "'where') from P1 where id = ?");
        project.addStmtProcedure("DECODEND", "select desc,  DECODE (desc,'zheng','a') from P1 where id = ?");
        project.addStmtProcedure("DECODEVERYLONG", "select desc,  DECODE (desc,'a','a'," +
                "'a','a'," +
                "'a','a'," +
                "'a','a'," +
                "'a','a'," +
View Full Code Here
1705
1706
1707
1708
1709
1710
1711
1712
1713
1714
1715
                        "'Microsoft','li'," +
                        "'Hewlett Packard','at'," +
                        "'Gateway','VoltDB'," +
                        "'where') from P1 where id = ?");
        project.addStmtProcedure("DECODEND", "select desc,  DECODE (desc,'zheng','a') from P1 where id = ?");
        project.addStmtProcedure("DECODEVERYLONG", "select desc,  DECODE (desc,'a','a'," +
                "'a','a'," +
                "'a','a'," +
                "'a','a'," +
                "'a','a'," +
                "'a','a'," +
View Full Code Here
1718
1719
1720
1721
1722
1723
1724
1725
1726
1727
1728
                "'a','a'," +
                "'a','a'," +
                "'a','a'," +
                "'a','a'," +
                "'where') from P1 where id = ?");
        project.addStmtProcedure("DECODE_PARAM_INFER_STRING", "select desc,  DECODE (desc,?,?,desc) from P1 where id = ?");
        project.addStmtProcedure("DECODE_PARAM_INFER_INT", "select desc,  DECODE (id,?,?,id) from P1 where id = ?");
        project.addStmtProcedure("DECODE_PARAM_INFER_DEFAULT", "select desc,  DECODE (?,?,?,?) from P1 where id = ?");
        project.addStmtProcedure("DECODE_PARAM_INFER_CONFLICTING", "select desc,  DECODE (id,1,?,2,99,'贾鑫') from P1 where id = ?");
        // Test OCTET_LENGTH
        project.addStmtProcedure("OCTET_LENGTH", "select desc,  OCTET_LENGTH (desc) from P1 where id = ?");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.