sqlite - Unsupported Sql

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 13,19 ****
  
      This is Sybase ASE syntax. Related to "Oracle's join syntax" mentioned below
  
! *: This appears to be unsupported: updating multiple columns with subselect
  
     update T1 set (theUpdatedValue, theOtherValue) =
  (select theTop, theValue from T2 where T2.theKey = T1.theID)
--- 13,19 ----
  
      This is Sybase ASE syntax. Related to "Oracle's join syntax" mentioned below
  
! *: 2005.10.06 : This appears to be unsupported: updating multiple columns with subselect
  
     update T1 set (theUpdatedValue, theOtherValue) =
  (select theTop, theValue from T2 where T2.theKey = T1.theID)