sqlite - Unsupported Sql

Not logged in

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

• Contents
• No-Diff
• Text

*** 16,22 ****
  *: 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)
  
  *: 2005.09.25 : free text search capabilities in select statements:
  Mysql does free text search Match(field_list) Against(keyword)
--- 16,22 ----
  *: 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)
  
  *: 2005.09.25 : free text search capabilities in select statements:
  Mysql does free text search Match(field_list) Against(keyword)
***************
*** 202,209 ****
  		UPDATE
  			t1
  		SET
! 			measure = ( SELECT measure FROM t2 WHERE t2.key =
! t1.key )
  		;
  
  
--- 202,208 ----
  		UPDATE
  			t1
  		SET
! 			measure = ( SELECT measure FROM t2 WHERE t2.key = t1.key )
  		;