rareddy

seclect * from X, Y where X.PK = Y.PK

rareddy

SELECT * FROM X, Y WHERE X.PK = Y.PK

rareddy

> db.inventory.insert(
...     {
...      item: "ABC1",
...      details: [{
...          model: "14Q3",
...          manufacturer: "XYZ Company"
...      }, 
...      {
...          model: "14Q4",
...          manufacturer: "ABC Company"

rareddy

============================================================================
USER COMMAND:
SELECT p.UserName AS x, pf.UserName AS y FROM trippin.People AS p INNER JOIN trippin.People_Friends AS pf ON p.UserName = pf.People_UserName LIMIT 100

----------------------------------------------------------------------------
OPTIMIZE: 
SELECT p.UserName AS x, pf.UserName AS y FROM trippin.People AS p INNER JOIN trippin.People_Friends AS pf ON p.UserName = pf.People_UserName LIMIT 100

----------------------------------------------------------------------------
GENERATE CANONICAL: 

rareddy

{
   "value":[
      {
         "UserName":"russellwhyte",
         "Friends":[
            {
               "UserName":"scottketchum"
            },
            {
               "UserName":"ronaldmundy"

rareddy

Failed tests: 
  TestInfinispanJndiDSLSearch.testQueryGetLTE:95->BasicAnnotatedSearchTest.performTest:139->BasicAnnotatedSearchTest.performTest:158 Did not get expected number of rows expected:<99> but was:<200>
  TestInfinispanJndiDSLSearch>BasicAnnotatedSearchTest.testQueryRangeBetween:107->BasicAnnotatedSearchTest.performTest:139->BasicAnnotatedSearchTest.performTest:158 Did not get expected number of rows expected:<1> but was:<200>
  TestInfinispanJndiDSLSearch>BasicAnnotatedSearchTest.testQueryRangeAbove:115->BasicAnnotatedSearchTest.performTest:139->BasicAnnotatedSearchTest.performTest:158 Did not get expected number of rows expected:<199> but was:<200>
  TestInfinispanJndiDSLSearch>BasicAnnotatedSearchTest.testQueryRangeBelow:123->BasicAnnotatedSearchTest.performTest:139->BasicAnnotatedSearchTest.performTest:158 Did not get expected number of rows expected:<98> but was:<200>
  TestInfinispanJndiDSLSearch>BasicAnnotatedSearchTest.testQueryAnd:131->BasicAnnotatedSearchTest.performTest:139->BasicAnnotated

rareddy

14:05:01,990 ERROR [org.teiid.SECURITY] (New I/O worker #1) null TEIID40017 Unexpected exception for session null: java.lang.NoSuchMethodException: ping
	at org.teiid.core.util.ReflectionHelper.findBestMethodWithSignature(ReflectionHelper.java:174) [teiid-common-core-8.4.1.jar:8.4.1]
	at org.teiid.core.util.ReflectionHelper.findBestMethodOnTarget(ReflectionHelper.java:91) [teiid-common-core-8.4.1.jar:8.4.1]
	at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:84) [teiid-runtime-8.4.1.jar:8.4.1]
	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1.jar:8.4.1]
	at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:192) [teiid-runtime-8.4.1.jar:8.4.1]
	at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:178) [teiid-runtime-8.4.1.jar:8.4.1]
	at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:201) [teiid-runtime-8.4.1.jar:8.4.1]
	at org.jboss.

rareddy

FOR EACH ROW
BEGIN
  IF(changing.booking_id) 
  BEGIN
      Update booking set booking_id=NEW.booing_id where id = old.id;
  END
  ELSE IF (..)
  BEGIN
  END
  ELSE ..

rareddy

asset: _bootstrap/demo.vdb
main-class: org.wildfly.swarm.Swarm
hollow: false
properties:
  swarm.uberjar.build.user: rareddy
  swarm.uberjar.build.timestamp: 2017-10-30T13:21Z
  swarm.app.artifact: demo.vdb
modules: !!set
  org.wildfly.swarm.jmx: null
  org.wildfly.swarm.datasources: null

rareddy

org.jboss.arquillian.container.spi.client.container.DeploymentException: Could not parse pom.xml: /home/rareddy/development/teiid-demo/pom.xml
	at org.wildfly.swarm.arquillian.adapter.WildFlySwarmContainer.deploy(WildFlySwarmContainer.java:92)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController$3.call(ContainerDeployController.java:161)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController$3.call(ContainerDeployController.java:128)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController.executeOperation(ContainerDeployController.java:271)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController.deploy(ContainerDeployController.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.i